protected void btnCreateWO_Click(object sender, EventArgs e)
{
DateTime today = DateTime.Now;
try
{
string connection = ConfigurationManager.ConnectionStrings["testDB"].ConnectionString;
SqlConnection conn = new SqlConnection(connection);
SqlCommand cmd = new SqlCommand("INSERT INTO WorkOrder (CustomerID, WCaseNumber, WFName, WLName, WOPFName, WOPLName, WServAdd, WServApt, WServCity, WServState, WServZip, WStatus, WDateCreated, WEmpBPay) VALUES (@CustomerID, @WCaseNumber, @WFName, @WLName, @WOPFname, @WOPLName, @WServAdd, @WServApt, @WServCity, @WServState, @WServZip, @WStatus, @WDateCreated, @WEmpBPay);", conn);
cmd.Parameters.AddWithValue("@CustomerID", id);
cmd.Parameters.AddWithValue("@WCaseNumber", txtCaseNumber.Text);
cmd.Parameters.AddWithValue("@WFName", txtFNameServiceRequestedBy.Text);
cmd.Parameters.AddWithValue("@WLName", txtLNameServiceRequestedBy.Text);
cmd.Parameters.AddWithValue("@WOPFName", txtOppFName.Text);
cmd.Parameters.AddWithValue("@WOPLName", txtOppLName.Text);
cmd.Parameters.AddWithValue("@WServAdd", txtServiceStreetAddress.Text);
cmd.Parameters.AddWithValue("@WServApt", txtApartment.Text);
cmd.Parameters.AddWithValue("@WServCity", txtCity.Text);
cmd.Parameters.AddWithValue("@WServState", ddState.SelectedValue);
cmd.Parameters.AddWithValue("@WServZip", txtZip.Text);
cmd.Parameters.AddWithValue("@WStatus", "A");
cmd.Parameters.AddWithValue("@WDateCreated", today);
cmd.Parameters.AddWithValue("@WEmpBPay", "0");
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
// Email the admin about the new work order
SendMail sm = new SendMail();
if(sm.Send_AdminMail(id.ToString()))
{
//Show a success label
lblCreateWOError.Text = "Your work order was created successfully. Please navigate to the Upload document page to upload the needed court documents.";
lblCreateWOError.ForeColor = System.Drawing.Color.Green;
lblCreateWOError.Visible = true;
btnGoToUpload.Visible = true;
ClearInputs(Page.Controls);
}
else
{
lblCreateWOError.Text = "Your work order was created successfully but the system failed to properly notify the staff at WeServeU LLC.";
lblCreateWOError.ForeColor = System.Drawing.Color.Green;
lblCreateWOError.Visible = true;
}
}
catch(SqlException se)
{
lblCreateWOError.Text = "There was an error creating your work order" + se.ToString();
lblCreateWOError.ForeColor = System.Drawing.Color.Red;
lblCreateWOError.Visible = true;
}
}
