protected void updateLabTestsBtn_Click(object sender, EventArgs e) { bool valid = true; TimesheetManager tm = new TimesheetManager(); decimal tHours = Convert.ToDecimal(totalHoursLBL.Text); // try to update, if cannot update, then create new lab test if (sunLabTB.Text != string.Empty && sunLabTB.Text != "0") { if (!hoursValidator(sunLabTB.Text, "Sunday", true)) { valid = false; } } if (valid) { if (!tm.updateLabTest("Sunday", sunNuclearDensityTestTB.Text, sunLabTB.Text, timesheetID, false, ref tHours)) { tm.createLabTest("Sunday", sunNuclearDensityTestTB.Text, sunLabTB.Text, timesheetID, false, ref tHours); } sunLabTB.Text = string.Empty; sunNuclearDensityTestTB.Text = string.Empty; } if (monLabTB.Text != string.Empty && monLabTB.Text != "0") { if (!hoursValidator(monLabTB.Text, "Monday", true)) { valid = false; } } if (valid) { if (!tm.updateLabTest("Monday", monNuclearDensityTestTB.Text, monLabTB.Text, timesheetID, false, ref tHours)) { tm.createLabTest("Monday", monNuclearDensityTestTB.Text, monLabTB.Text, timesheetID, false, ref tHours); } monLabTB.Text = string.Empty; monNuclearDensityTestTB.Text = string.Empty; } if (tuesLabTB.Text != string.Empty && tuesLabTB.Text != "0") { if (!hoursValidator(tuesLabTB.Text, "Tuesday", true)) { valid = false; } } if (valid) { if (!tm.updateLabTest("Tuesday", tuesNuclearDensityTestTB.Text, tuesLabTB.Text, timesheetID, false, ref tHours)) { tm.createLabTest("Tuesday", tuesNuclearDensityTestTB.Text, tuesLabTB.Text, timesheetID, false, ref tHours); } tuesLabTB.Text = string.Empty; tuesNuclearDensityTestTB.Text = string.Empty; } if (wedsLabTB.Text != string.Empty && wedsLabTB.Text != "0") { if (!hoursValidator(wedsLabTB.Text, "Wednesday", true)) { valid = false; } } if (valid) { if (!tm.updateLabTest("Wednesday", wedsNuclearDensityTestTB.Text, wedsLabTB.Text, timesheetID, false, ref tHours)) { tm.createLabTest("Wednesday", wedsNuclearDensityTestTB.Text, wedsLabTB.Text, timesheetID, false, ref tHours); } wedsLabTB.Text = string.Empty; wedsNuclearDensityTestTB.Text = string.Empty; } if (thursLabTB.Text != string.Empty && thursLabTB.Text != "0") { if (!hoursValidator(thursLabTB.Text, "Thursday", true)) { valid = false; } } if (valid) { if (!tm.updateLabTest("Thursday", thursNuclearDensityTestTB.Text, thursLabTB.Text, timesheetID, false, ref tHours)) { tm.createLabTest("Thursday", thursNuclearDensityTestTB.Text, thursLabTB.Text, timesheetID, false, ref tHours); } thursLabTB.Text = string.Empty; thursNuclearDensityTestTB.Text = string.Empty; } if (friLabTB.Text != string.Empty && friLabTB.Text != "0") { if (!hoursValidator(friLabTB.Text, "Friday", true)) { valid = false; } } if (valid) { if (!tm.updateLabTest("Friday", friNuclearDensityTestTB.Text, friLabTB.Text, timesheetID, false, ref tHours)) { tm.createLabTest("Friday", friNuclearDensityTestTB.Text, friLabTB.Text, timesheetID, false, ref tHours); } friLabTB.Text = string.Empty; friNuclearDensityTestTB.Text = string.Empty; } if (satLabTB.Text != string.Empty && satLabTB.Text != "0") { if (!hoursValidator(satLabTB.Text, "Saturday", true)) { valid = false; } } if (valid) { if (!tm.updateLabTest("Saturday", satNuclearDensityTestTB.Text, satLabTB.Text, timesheetID, false, ref tHours)) { tm.createLabTest("Saturday", satNuclearDensityTestTB.Text, satLabTB.Text, timesheetID, false, ref tHours); } satLabTB.Text = string.Empty; satNuclearDensityTestTB.Text = string.Empty; } totalHoursLBL.Text = tHours.ToString("0.0"); updateLabTotals(); // update timesheet tm.updateTimeSheet(timesheetID, tHours, Convert.ToInt32(totalDistanceLBL.Text), Convert.ToInt32(totalTruckLBL.Text), Convert.ToDecimal(totalExpensesLBL.Text), "Updated", " ", " "); summaryGV.DataBind(); updateLabTestsBtn.Visible = false; labTestsBtn.Visible = true; }