private void ButtInsert_Click(object sender, EventArgs e)
{
if (TxtWorkOrderNo.Text == "")
MessageBox.Show("Please enter a Work Order Number");
}
else if (Txtcat.Text == "")
MessageBox.Show("Please enter CAT");
else if (Txtmain.Text == "")
MessageBox.Show("Please enter MAIN");
else if (TxtSub.Text == "")
MessageBox.Show("Please enter SUB");
else if (RTBSpec.Text == "")
MessageBox.Show("Please enter SPEC");
else if (TxtEwoSpec.Text == "")
MessageBox.Show("Please enter EWO_SPEC");
else if (TxtExtc.Text == "")
MessageBox.Show("Please enter EXTC");
else if (TxtContractorCode.Text == "")
MessageBox.Show("Please enter Contractor Code");
else if (TxtCreatedBy.Text == "")
MessageBox.Show("Please enter Created By ?");
else
//stores the values entered as variables
string SED_EWO_NO = TxtWorkOrderNo.Text;
string SED_CAT = Txtcat.Text;
string SED_MAIN = Txtmain.Text;
string SED_SUB = TxtSub.Text;
string SED_SPEC = RTBSpec.Text;
string SED_EWO_SPEC = TxtEwoSpec.Text;
string SED_XTC = TxtExtc.Text;
string SED_CONTRACTOR_CODE = TxtContractorCode.Text;
string CREATED_BY = TxtCreatedBy.Text;
SqlCommand cmd = new SqlCommand();
string sql;
try
sql = "INSERT INTO EWO_DETAILS (SED_EWO_NO,SED_CONTRACTOR_CODE,SED_EWO_SPEC,SED_CAT,SED_MAIN,SED_SPEC,SED_SUB,SED_XTC,SED_START_DATE,SED_END_DATE,CREATED_BY,CREATED_DATE)";
sql += String.Format ("VALUES ( @SED_EWO_NO, @SED_CONTRACTOR_CODE, @SED_EWO_SPEC, @SED_CAT, @SED_MAIN, @SED_SPEC, @SED_SUB, @SED_XTC, @SED_START_DATE, @SED_END_DATE, @CREATED_BY, @CREATED_DATE)");
cmd = new SqlCommand(sql, cs);
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@SED_EWO_NO", TxtWorkOrderNo.Text);
cmd.Parameters.AddWithValue("@SED_CONTRACTOR_CODE", TxtContractorCode.Text);
cmd.Parameters.AddWithValue("@SED_EWO_SPEC", TxtEwoSpec.Text);
cmd.Parameters.AddWithValue("@SED_CAT", TxtJcat.Text);
cmd.Parameters.AddWithValue("@SED_MAIN", TxtJmain.Text);
cmd.Parameters.AddWithValue("@SED_SPEC", RTBSpec.Text);
cmd.Parameters.AddWithValue("@SED_SUB", TxtSub.Text);
cmd.Parameters.AddWithValue("@SED_XTC", TxtExtc.Text);
cmd.Parameters.Add("SED_START_DATE", SqlDbType.VarChar).Value = StartDatePicker.Value.Date;
cmd.Parameters.Add("SED_END_DATE", SqlDbType.VarChar).Value = EndDatePicker.Value.Date;
cmd.Parameters.AddWithValue("@CREATED_BY", TxtCreatedBy.Text);
cmd.Parameters.Add("CREATED_DATE", SqlDbType.VarChar).Value = CreatedDatePicker.Value.Date;
cs.Open(); //opens connection
cmd.ExecuteNonQuery(); //writes to the database
MessageBox.Show("Details Added", "Successful");
catch (Exception )
MessageBox.Show("Duplicate Data", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
finally
cs.Close(); // Close connection