private SubcontractorHoursNavigatorTDS SubmitSearchBySubcontractor()
{
// Retrieve clauses
int subcontractorId = Convert.ToInt32(ddlSubcontractor.SelectedValue);
string whereClause = GetWhereClauseBySubcontractor(subcontractorId);
string orderByClause = GetOrderByClause();
SubcontractorHoursNavigator subcontractorHoursNavigator = new SubcontractorHoursNavigator();
subcontractorHoursNavigator.Load(whereClause, orderByClause);
return (SubcontractorHoursNavigatorTDS)subcontractorHoursNavigator.Data;
}
private void PostPageChanges()
{
SubcontractorHoursNavigator subcontractorHoursNavigator = new SubcontractorHoursNavigator(subcontractorHoursNavigatorTDS);
// Update
foreach (GridViewRow row in grdNavigator.Rows)
{
if (((CheckBox)row.FindControl("cbxSelected")).Checked)
{
int subcontractorId = Int32.Parse(((Label)row.FindControl("lblSubcontractorID")).Text.Trim());
int projectId = Int32.Parse(((Label)row.FindControl("lblProjectID")).Text.Trim());
int refId = Int32.Parse(((Label)row.FindControl("lblRefIDID")).Text.Trim());
bool selected = ((CheckBox)row.FindControl("cbxSelected")).Checked;
subcontractorHoursNavigator.Update(subcontractorId, projectId, refId, selected);
}
}
subcontractorHoursNavigator.Data.AcceptChanges();
// Store datasets
Session["subcontractorHoursNavigatorTDS"] = subcontractorHoursNavigatorTDS;
}