protected void updateNonChargeableBtn_Click(object sender, EventArgs e)
{
TimesheetManager tm = new TimesheetManager();
bool result, valid = true;
int count = 0, nCDist = Convert.ToInt32(totalDistanceLBL.Text), tDist = Convert.ToInt32(totalTruckLBL.Text);
decimal nCHours = Convert.ToDecimal(totalHoursLBL.Text), nCExpense = Convert.ToDecimal(Convert.ToDecimal(totalExpensesLBL.Text));
//sunday
if (sunNCHoursTB.Text != string.Empty)
{
if (!hoursValidator(sunNCHoursTB.Text, "Sunday", true))
{
valid = false;
}
}
if (valid)
{
result = tm.updateNonChargeable(sunNCHoursTB.Text, sunNCAccomTB.Text, sunNCDistanceTB.Text, sunNCMiscTB.Text, "Sunday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, sunNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
if (result)
{
count++;
timesheetStatusLBL.Text = count + " Row(s) Updated Successfully";
}
else
{
timesheetStatusLBL.Text = tm.createNonChargeable(sunNCHoursTB.Text, sunNCAccomTB.Text, sunNCDistanceTB.Text, sunNCMiscTB.Text, "Sunday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, sunNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
}
}
// monday
if (monNCHoursTB.Text != string.Empty)
{
if (!hoursValidator(monNCHoursTB.Text, "Monday", true))
{
valid = false;
}
}
if (valid)
{
result = tm.updateNonChargeable(monNCHoursTB.Text, monNCAccomTB.Text, monNCDistanceTB.Text, monNCMiscTB.Text, "Monday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, monNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
if (result)
{
count++;
timesheetStatusLBL.Text = count + " Row(s) Updated Successfully";
}
else
{
timesheetStatusLBL.Text = tm.createNonChargeable(monNCHoursTB.Text, monNCAccomTB.Text, monNCDistanceTB.Text, monNCMiscTB.Text, "Monday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, monNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
}
}
// tuesday
if (tuesNCHoursTB.Text != string.Empty)
{
if (!hoursValidator(tuesNCHoursTB.Text, "Tuesday", true))
{
valid = false;
}
}
if (valid)
{
result = tm.updateNonChargeable(tuesNCHoursTB.Text, tuesNCAccomTB.Text, tuesNCDistanceTB.Text, tuesNCMiscTB.Text, "Tuesday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, tuesNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
if (result)
{
count++;
timesheetStatusLBL.Text = count + " Row(s) Updated Successfully";
}
else
{
timesheetStatusLBL.Text = tm.createNonChargeable(tuesNCHoursTB.Text, tuesNCAccomTB.Text, tuesNCDistanceTB.Text, tuesNCMiscTB.Text, "Tuesday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, tuesNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
}
}
// wednessday
if (wedsNCHoursTB.Text != string.Empty)
{
if (!hoursValidator(wedsNCHoursTB.Text, "Wednesday", true))
{
valid = false;
}
}
if (valid)
{
result = tm.updateNonChargeable(wedsNCHoursTB.Text, wedsNCAccomTB.Text, wedsNCDistanceTB.Text, wedsNCMiscTB.Text, "Wednesday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, wedsNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
if (result)
{
count++;
timesheetStatusLBL.Text = count + " Row(s) Updated Successfully";
}
else
{
timesheetStatusLBL.Text = tm.createNonChargeable(wedsNCHoursTB.Text, wedsNCAccomTB.Text, wedsNCDistanceTB.Text, wedsNCMiscTB.Text, "Wednesday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, wedsNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
}
}
// thursday
if (thursNCHoursTB.Text != string.Empty)
{
if (!hoursValidator(thursNCHoursTB.Text, "Thursday", true))
{
valid = false;
}
}
if (valid)
{
result = tm.updateNonChargeable(thursNCHoursTB.Text, thursNCAccomTB.Text, thursNCDistanceTB.Text, thursNCMiscTB.Text, "Thursday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, thursNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
if (result)
{
count++;
timesheetStatusLBL.Text = count + " Row(s) Updated Successfully";
}
else
{
timesheetStatusLBL.Text = tm.createNonChargeable(thursNCHoursTB.Text, thursNCAccomTB.Text, thursNCDistanceTB.Text, thursNCMiscTB.Text, "Thursday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, thursNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
}
}
// friday
if (friNCHoursTB.Text != string.Empty)
{
if (!hoursValidator(friNCHoursTB.Text, "Friday", true))
{
valid = false;
}
}
if (valid)
{
result = tm.updateNonChargeable(friNCHoursTB.Text, friNCAccomTB.Text, friNCDistanceTB.Text, friNCMiscTB.Text, "Friday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, friNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
if (result)
{
count++;
timesheetStatusLBL.Text = count + " Row(s) Updated Successfully";
}
else
{
timesheetStatusLBL.Text = tm.createNonChargeable(friNCHoursTB.Text, friNCAccomTB.Text, friNCDistanceTB.Text, friNCMiscTB.Text, "Friday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, friNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
}
}
// saturday
if (satNCHoursTB.Text != string.Empty)
{
if (!hoursValidator(satNCHoursTB.Text, "Saturday", true))
{
valid = false;
}
}
if (valid)
{
result = tm.updateNonChargeable(satNCHoursTB.Text, satNCAccomTB.Text, satNCDistanceTB.Text, satNCMiscTB.Text, "Saturday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, satNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
if (result)
{
count++;
timesheetStatusLBL.Text = count + " Row(s) Updated Successfully";
}
else
{
timesheetStatusLBL.Text = tm.createNonChargeable(satNCHoursTB.Text, satNCAccomTB.Text, satNCDistanceTB.Text, satNCMiscTB.Text, "Saturday",
detailsDDL.SelectedValue, specifyDDL.SelectedValue, timesheetID, satNCRemarksTB.Text, ref nCHours, ref nCDist, ref nCExpense);
}
}
// update the totalized labels
totalHoursLBL.Text = nCHours.ToString("0.0");
totalExpensesLBL.Text = nCExpense.ToString("0.00##");
totalDistanceLBL.Text = nCDist.ToString();
// if hours exceed 60 throw a dialog
if (nCHours > MAX_WEEKLY_HOURS)
{
// throw a dialog
dialogTitle = "Regular Weekly Hours Exceeded";
msg = "You Worked more than 60 hours. A separate Form must be filled out to accomodate overtime";
ScriptManager.RegisterStartupScript(this, this.GetType(), "projectNumInvalid", "throwDialog();", true);
}
tm.updateTimeSheet(timesheetID, nCHours, nCDist, tDist, nCExpense, "Updated", " ", " ");
// update gridview
summaryGV.DataBind();
// clear form fields
clearNonChargeable();
// update totals
updateNonChargeableTotals();
// reset drop down list to first index
detailsDDL.SelectedIndex = 0;
specifyDDL.SelectedIndex = 0;
NonChargeHoursPanel.Visible = false;
NonChargeExpensesPanel.Visible = false;
updateNonChargeableBtn.Visible = false;
nonChargeBtn.Visible = true;
}
