protected void btnFinalize_Click(object sender, EventArgs e)
{
//Inspection is technically already created. The only data that needs to be added
//iS the finish date and the hazard items
string messageBoxText = "Are you sure you want to finalize this inspection?";
string caption = "Finalize Inspection Warning";
MessageBoxButton button = MessageBoxButton.YesNoCancel;
MessageBoxImage icon = MessageBoxImage.Warning;
MessageBoxResult result = MessageBox.Show(messageBoxText, caption, button, icon);
if (result == MessageBoxResult.Yes)
{
//Get the inspectionID
int inspectionID = Convert.ToInt32(Request.QueryString["ID"]);
//Create a new SQL connection
SqlConnection conn = new SqlConnection(connectionString);
//Create a new SQL command
SqlCommand comm = conn.CreateCommand();
//Assign the query to the command
comm.CommandText = "UPDATE Inspection SET FinishDate=@finishDate, IsComplete=1 WHERE ID = " + inspectionID;
//Assign the current date time to the query
comm.Parameters.AddWithValue("@finishDate", DateTime.Now);
//Open the connection
conn.Open();
//Execute the command
int rows = comm.ExecuteNonQuery();
//Close the connection
conn.Close();
if (rows > 0)
{
MessageBox.Show("Inspection Finalized");
//Reload the page
Response.Redirect("Homepage.aspx");
//Send out an email to the admin users
string mailBody = "Hello Administrator users. Technician " + lblTechnicianName.Text + " has completed inspection " + inspectionID + " In the lab/room " + lblRoomName.Text + " At the time of " + DateTime.Now + ".";
DataLookup.SendMail(999, "An Inspection Has Been Completed", mailBody);
}
else
{
MessageBox.Show("Error. No Action Taken.");
}
}
if (result == MessageBoxResult.No | result == MessageBoxResult.Cancel)
{
MessageBox.Show("No Action Taken");
}
}
protected void btnSchedule_Click(object sender, EventArgs e)
{
string messageBoxText = "Are you sure you want to schedule this inspection?";
string caption = "Inspection Schedule Warning";
MessageBoxButton button = MessageBoxButton.YesNoCancel;
MessageBoxImage icon = MessageBoxImage.Warning;
MessageBoxResult result = MessageBox.Show(messageBoxText, caption, button, icon);
if (result == MessageBoxResult.Yes)
{
//Get the lab ID
string room = ddlLab.SelectedItem.Text;
var splitValueLab = room.Split(' ');
int labID = Convert.ToInt16(splitValueLab[0]);
//Get the technician ID
string technician = ddlTechnician.SelectedItem.Text;
var splitValueTech = technician.Split(' ');
int technicianID = Convert.ToInt16(splitValueTech[3]);
//Get the due date value
DateTime dueDate = calDueDate.SelectedDate;
//Create a new SQL connection
SqlConnection conn = new SqlConnection(connectionString);
//Create a new SQL command
SqlCommand comm = conn.CreateCommand();
//Assign the query to the command
comm.CommandText = "INSERT INTO Inspection (TechnicianID, LabID, AssignedDate, DueDate) VALUES (@technicianID, @labID, @assignedDate, @dueDate)";
comm.Parameters.Add("@technicianID", technicianID);
comm.Parameters.Add("@labID", labID);
comm.Parameters.Add("@assignedDate", SqlDbType.DateTime).Value = DateTime.Now;
comm.Parameters.Add("@dueDate", SqlDbType.DateTime).Value = dueDate;
//Open the connection
conn.Open();
//Execute the query
int rows = comm.ExecuteNonQuery();
//Close the connection
conn.Close();
//Shows feedback based on the success of the transaction
if (rows > 0)
{
MessageBox.Show("Inspection has been scheduled.");
//Send a notification Email
string mailBody = "Hello " + technician + ", You have a new inspection in room " + room + " that is due on " + dueDate;
DataLookup.SendMail(technicianID, "You Have a New Scheduled Inspection", mailBody);
}
else
{
MessageBox.Show("Error. Inspection has not been scheduled.");
}
}
if (result == MessageBoxResult.No | result == MessageBoxResult.Cancel)
{
MessageBox.Show("No Action Taken");
}
}
