protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlProject.SelectedIndex > 0)
{
int projectId = Int32.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectGateway.GetFairWageApplies(projectId))
{
lblIncludeAllHours.Visible = true;
cbxIncludeAllHours.Visible = true;
upnlIncludeAllHours.Update();
upnlIncludeAllHoursLabel.Update();
}
else
{
lblIncludeAllHours.Visible = false;
cbxIncludeAllHours.Visible = false;
cbxIncludeAllHours.Checked = false;
upnlIncludeAllHours.Update();
upnlIncludeAllHoursLabel.Update();
}
}
else
{
lblIncludeAllHours.Visible = false;
cbxIncludeAllHours.Visible = false;
cbxIncludeAllHours.Checked = false;
upnlIncludeAllHours.Update();
upnlIncludeAllHoursLabel.Update();
}
}
// ////////////////////////////////////////////////////////////////////////
// PUBLIC METHODS
//
public int LoadAll(DateTime startDate, DateTime endDate, int companyId, string month)
{
int rows = 0;
PrintSummaryCostingSheetByMonthDummyInformationGateway printSummaryCostingSheetByMonthDummyInformationGateway = new PrintSummaryCostingSheetByMonthDummyInformationGateway(Data);
printSummaryCostingSheetByMonthDummyInformationGateway.LoadProjectsWithTimesheets(startDate, endDate);
// Load
ProjectCostingSheetAddLabourHoursInformationGateway projectCostingSheetAddLabourHoursInformationGateway = new ProjectCostingSheetAddLabourHoursInformationGateway(Data);
projectCostingSheetAddLabourHoursInformationGateway.ClearBeforeFill = false;
ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(Data);
foreach (ProjectCostingSheetAddTDS.DummyInformationRow projectListRow in (ProjectCostingSheetAddTDS.DummyInformationDataTable)printSummaryCostingSheetByMonthDummyInformationGateway.Table)
{
int projectId = projectListRow.ProjectID;
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
ArrayList works = new ArrayList();
works.Add("Rehab Assessment");
works.Add("Full Length");
works.Add("Point Lining"); works.Add("Grouting");
works.Add("Junction Lining");
works.Add("MH Rehab");
works.Add("Mobilization");
works.Add("Other");
works.Add("Downtime");
works.Add("Office");
works.Add("Office / Shop");
works.Add("R & D");
works.Add("Special Projects");
works.Add("Subcontractor");
works.Add("Watermain Relining");
works.Add("SOTA");
if (!projectGateway.GetFairWageApplies(projectId))
{
model.Load(works, projectId, startDate, endDate, companyId, month);
}
else
{
ArrayList jobClassType = new ArrayList();
jobClassType.Add("Laborer Group 2");
jobClassType.Add("Laborer Group 6");
jobClassType.Add("Operator Group 1");
jobClassType.Add("Operator Group 2");
jobClassType.Add("Regular Rate");
model.LoadFairWageProject(works, jobClassType, projectId, startDate, endDate, companyId, month);
}
decimal totalCostLH = StepLabourHoursInformationProcessGrid();
ProjectCostingSheetAddBasicInformation projectCostingSheetAddBasicInformation = new ProjectCostingSheetAddBasicInformation(Data);
projectCostingSheetAddBasicInformation.Insert2(projectId, projectId, "", startDate, endDate, totalCostLH, totalCostLH, 0, 0, 0, 0, 0, 0, 0, 0, "", false, companyId, 0, 0, 0, 0, 0, 0, 0, 0, 0, month);
rows = rows + projectCostingSheetAddLabourHoursInformationGateway.Table.Rows.Count;
}
projectCostingSheetAddLabourHoursInformationGateway.ClearBeforeFill = true;
return rows;
}
protected void cvJobClassTypeFooter_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = true;
int projectId = int.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(int.Parse(ddlProject.SelectedValue));
if (projectGateway.GetFairWageApplies(projectId))
{
string jobClass = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlJobClassTypeFooter")).SelectedValue;
if (jobClass == "(Select a Job Class Type)")
{
args.IsValid = false;
}
}
}
private void GrdProjectTimeAdd()
{
Page.Validate("generalData");
int projectId = int.Parse(ddlProject.SelectedValue);
if (Page.IsValid)
{
Page.Validate("footerValidData");
if (Page.IsValid)
{
Page.Validate("footerData");
if (Page.IsValid)
{
// Validate project times
if (FooterValidate())
{
// Save data
int employeeId = Int32.Parse(hdfEmployeeID.Value);
int companiesId = int.Parse(ddlClient.SelectedValue);
if (projectId != 35 && projectId != 39 && projectId != 716)
{
DateTime date_ = tkrdpStartDate.SelectedDate.Value;
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string startTimeFooter = "";
string startHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue != "") startHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeHourFooter")).SelectedValue.Trim();
string startMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue != "") startMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlStartTimeMinuteFooter")).SelectedValue.Trim();
if ((startHoursFooter != "") && (startMinutesFooter != ""))
{
startTimeFooter = startHoursFooter + ":" + startMinutesFooter;
}
string endTimeFooter = "";
string endHoursFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue != "") endHoursFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeHourFooter")).SelectedValue.Trim();
string endMinutesFooter = ""; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue != "") endMinutesFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlEndTimeMinuteFooter")).SelectedValue.Trim();
if ((endHoursFooter != "") && (endMinutesFooter != ""))
{
endTimeFooter = endHoursFooter + ":" + endMinutesFooter;
}
decimal? offsetFooter = 0; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlLunchFooter")).SelectedValue != "0") offsetFooter = Decimal.Round(decimal.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlLunchFooter")).SelectedValue), 2);
double? offsetFooterFinal = null; if (offsetFooter.HasValue) offsetFooterFinal = double.Parse(((decimal)offsetFooter).ToString());
string typeOfWorkFooter = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTypeOfWorkFooter")).SelectedValue;
int? unitIdFooter = null; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlUnitFooter")).SelectedValue != "-1") unitIdFooter = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlUnitFooter")).SelectedValue);
int? towedIdFooter = null; if (((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTowedFooter")).SelectedValue != "-1") towedIdFooter = Int32.Parse(((DropDownList)grdProjectTime.FooterRow.FindControl("ddlTowedFooter")).SelectedValue);
string workingDetailsFooter = "Canada";
workingDetailsFooter = hdfWorkingDetails.Value;
bool isMealsAllowanceFooter = false;// ((CheckBox)grdProjectTime.FooterRow.FindControl("ckbxMealsAllowanceFooter")).Checked;
string commentsFooter = ((TextBox)grdProjectTime.FooterRow.FindControl("tbxCommentsFooter")).Text;
int companyId = Int32.Parse(hdfCompanyId.Value);
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
bool fairWage = projectGateway.GetFairWageApplies(projectId);
string projectTimeState = "For Approval"; if ((string)ViewState["LHMode"] == "Partial") projectTimeState = "Approved";
string work_ = "";
string function_ = "";
if (typeOfWorkFooter != "(Select)" && typeOfWorkFooter != "")
{
string[] workFunction = typeOfWorkFooter.ToString().Trim().Split('.');
work_ = workFunction[0].Trim();
function_ = workFunction[1].Trim();
}
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = "";
if (countryGateway.Table.Rows.Count > 0)
{
location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
}
string mealsAllowanceType = ""; if (isMealsAllowanceFooter) mealsAllowanceType = "Full Day";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, isMealsAllowanceFooter, "Full Day");
string jobClassType = ((DropDownList)grdProjectTime.FooterRow.FindControl("ddlJobClassTypeFooter")).SelectedValue;
// Insert Data
ProjectTimeTemp model = new ProjectTimeTemp(projectTimeTDS);
model.Insert(employeeId, companiesId, projectId, date_, startTimeFooter, endTimeFooter, offsetFooterFinal, workingDetailsFooter, location, mealsCountry, mealsAllowanceType, isMealsAllowanceFooter, mealsAllowance, unitIdFooter, towedIdFooter, projectTimeState, commentsFooter, work_, function_, typeOfWorkFooter, fairWage, jobClassType);
// Store Dataset
Session.Remove("projectTimeTempNewDummy");
Session["projectTimeTDS"] = projectTimeTDS;
Session["projectTimeTemp"] = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
grdProjectTime.DataBind();
grdProjectTime.PageIndex = grdProjectTime.PageCount - 1;
}
}
}
}
hdfIsMoreThan15.Value = "false";
upIsMoreThan15.Update();
}
}
protected void grdProjectTime_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("generalData");
if (Page.IsValid)
{
Page.Validate("editValidData");
if (Page.IsValid)
{
Page.Validate("editData");
if (Page.IsValid)
{
int projectTimeId = (int)e.Keys["ProjectTimeID"];
int employeeId = Int32.Parse(hdfEmployeeID.Value);
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
DateTime date_ = tkrdpStartDate.SelectedDate.Value;
string workingDetails = hdfWorkingDetails.Value;
if (projectId == 35 || projectId == 39 || projectId == 716)
{
Page.Validate("specialData");
}
if (Page.IsValid)
{
if (projectId == 35 || projectId == 39 || projectId == 716)
{
date_ = Convert.ToDateTime(((HiddenField)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("hdfDateEdit")).Value);
workingDetails = ddlWorkingDetails.SelectedValue;
}
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string startTime = "";
string startHoursEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlStartTimeHourEdit")).SelectedValue.Trim();
string startMinutesEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlStartTimeMinuteEdit")).SelectedValue.Trim();
if ((startHoursEdit != "") && (startMinutesEdit != "") )
{
startTime = startHoursEdit + ":" + startMinutesEdit;
}
string endTime = "";
string endHoursEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlEndTimeHourEdit")).SelectedValue.Trim();
string endMinutesEdit = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlEndTimeMinuteEdit")).SelectedValue.Trim();
if ((endHoursEdit != "") && (endMinutesEdit != ""))
{
endTime = endHoursEdit + ":" + endMinutesEdit;
}
decimal? offset = 0; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlLunchEdit")).SelectedValue != "0") offset = decimal.Round(Decimal.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlLunchEdit")).SelectedValue), 2);
double? offsetFinal = null; if (offset.HasValue) offsetFinal = double.Parse(((decimal)offset).ToString());
bool isMealsAllowance = false;// ((CheckBox)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ckbxMealsAllowanceEdit")).Checked;
int? unitId = null; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlUnitEdit")).SelectedValue != "-1") unitId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlUnitEdit")).SelectedValue);
int? towedUnitId = null; if (((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlTowedEdit")).SelectedValue != "-1") towedUnitId = Int32.Parse(((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlTowedEdit")).SelectedValue);
string comments = ((TextBox)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("tbxCommentsEdit")).Text;
string workFunctionConcat = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlTypeOfWorkFunctionEdit")).SelectedValue;
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
bool fairWage = projectGateway.GetFairWageApplies(projectId);
string work_ = "";
string function_ = "";
if (workFunctionConcat != "(Select)" && workFunctionConcat != "")
{
string[] workFunction = workFunctionConcat.ToString().Trim().Split('.');
work_ = workFunction[0].Trim();
function_ = workFunction[1].Trim();
}
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
string mealsAllowanceType = ""; if (isMealsAllowance) mealsAllowanceType = "Full Day";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, isMealsAllowance, "Full Day");
string jobClassType = ((DropDownList)grdProjectTime.Rows[e.RowIndex].Cells[1].FindControl("ddlJobClassTypeEdit")).SelectedValue;
// Update data
ProjectTimeTemp model = new ProjectTimeTemp(projectTimeTDS);
model.Update(projectTimeId, companiesId, projectId, date_, startTime, endTime, offsetFinal, workingDetails, location, mealsCountry, mealsAllowanceType, isMealsAllowance, mealsAllowance, unitId, towedUnitId, comments, work_, function_, workFunctionConcat, fairWage, jobClassType);
// Store dataset
Session.Remove("projectTimeTempNewDummy");
Session["projectTimeTDS"] = projectTimeTDS;
Session["projectTimeTemp"] = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
else
{
e.Cancel = true;
}
}
protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
if ((ddlProject.SelectedValue != null) && (ddlProject.SelectedValue != "-1"))
{
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
if (projectGateway.GetFairWageApplies(projectId))
{
if (projectGateway.GetCountryID(Int32.Parse(ddlProject.SelectedValue)) == 1) //Canada
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "1");
odsJobClassType.SelectParameters.Add("jobClassType", "(Select a Job Class Type)");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
else
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "2");
odsJobClassType.SelectParameters.Add("jobClassType", "(Select a Job Class Type)");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
}
else
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "-1");
odsJobClassType.SelectParameters.Add("jobClassType", "");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
if (projectId != 35 && projectId != 39 && projectId != 716)
{
switch (projectGateway.GetCountryID(projectId))
{
case 1:
ddlMealsCountry.SelectedValue = "1";
hdfWorkingDetails.Value = "Canada";
break;
case 2:
ddlMealsCountry.SelectedValue = "2";
hdfWorkingDetails.Value = "USA";
break;
}
if (tkrdpEndDate.Visible)
{
lblStartDate.Text = "Date";
lblLastDate.Visible = false;
tkrdpEndDate.Visible = false;
}
odsWorkingDetails.SelectParameters.RemoveAt(0);
odsWorkingDetails.SelectParameters.Add("workingDetails", "");
odsWorkingDetails.Select();
ddlWorkingDetails.DataBind();
ddlWorkingDetails.SelectedIndex = 0;
lblWorkingDetails.Visible = false;
ddlWorkingDetails.Visible = false;
lblMealsCountry.Visible = true;
ddlMealsCountry.Visible = true;
grdProjectTime.Visible = true;
lblCommentsVacation.Visible = false;
tbxCommentsVacation.Visible = false;
odsWorkFunctionConcat.SelectParameters.RemoveAt(0);
odsWorkFunctionConcat.SelectParameters.Add("workFunctionConcat", "(Select)");
odsWorkFunctionConcat.Select();
}
else
{
ddlMealsCountry.SelectedIndex = 0;
if (!tkrdpEndDate.Visible)
{
lblStartDate.Text = "Start Date";
lblLastDate.Visible = true;
tkrdpEndDate.Visible = true;
}
odsWorkingDetails.SelectParameters.RemoveAt(0);
odsWorkingDetails.SelectParameters.Add("workingDetails", "(Select)");
odsWorkingDetails.Select();
ddlWorkingDetails.DataBind();
ddlWorkingDetails.SelectedIndex = 0;
lblWorkingDetails.Visible = true;
ddlWorkingDetails.Visible = true;
lblMealsCountry.Visible = false;
ddlMealsCountry.Visible = false;
grdProjectTime.Visible = false;
lblCommentsVacation.Visible = true;
tbxCommentsVacation.Visible = true;
odsWorkFunctionConcat.SelectParameters.RemoveAt(0);
odsWorkFunctionConcat.SelectParameters.Add("workFunctionConcat", "");
odsWorkFunctionConcat.Select();
}
}
grdProjectTime.DataBind();
}
private void InsertProject(int projectId)
{
// ... Data for current project
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
projectGateway.LoadByProjectId(projectId);
// ... Definition of general variables
Int64 countryId = projectGateway.GetCountryID(projectId);
int officeId = projectGateway.GetOfficeID(projectId);
Int64? provinceId = projectGateway.GetProvinceID(projectId);
Int64? cityId = projectGateway.GetCityID(projectId);
Int64? countyId = projectGateway.GetCountyID(projectId);
int? projectLeadId = null; if (projectGateway.GetProjectLeadID(projectId).HasValue) projectLeadId = (int)projectGateway.GetProjectLeadID(projectId);
int salesmanId = projectGateway.GetSalesmanID(projectId);
bool deleted = false;
int? clientPrimaryContactID = null; if (projectGateway.GetClientPrimaryContactID(projectId).HasValue) clientPrimaryContactID = (int)projectGateway.GetClientPrimaryContactID(projectId);
int? clientSecondaryContactID = null; if (projectGateway.GetClientSecondaryContactID(projectId).HasValue) clientSecondaryContactID = (int)projectGateway.GetClientSecondaryContactID(projectId);
int? OriginalProjectID = projectId;
int? projectNumberCopy = null; if (projectGateway.GetLastProjectNumberCopy(projectId).HasValue) projectNumberCopy = (int)projectGateway.GetLastProjectNumberCopy(projectId) + 1; else projectNumberCopy = 1;
string projectNumber = projectGateway.GetProjectNumber(projectId) + "-" + projectNumberCopy.ToString();
string projectType = "Proposal";
string projectState = projectGateway.GetProjectState(projectId);
string name = projectGateway.GetName(projectId);
string description = projectGateway.GetDescription(projectId);
DateTime? proposalDate = null; if (projectGateway.GetProposalDate(projectId).HasValue) proposalDate = projectGateway.GetProposalDate(projectId);
DateTime? startDate = null; if (projectGateway.GetStartDate(projectId).HasValue) startDate = projectGateway.GetStartDate(projectId);
DateTime? endDate = null; if (projectGateway.GetEndDate(projectId).HasValue) endDate = projectGateway.GetEndDate(projectId);
int clientId = projectGateway.GetClientID(projectId);
string clientProjectNumber = projectGateway.GetClientProjectNumber(projectId);
int? libraryCategoriesId = null; if (projectGateway.GetLibraryCategoriesId(projectId).HasValue) libraryCategoriesId = (int)projectGateway.GetLibraryCategoriesId(projectId);
bool fairWageApplies = projectGateway.GetFairWageApplies(projectId);
// ... Insert Project
Project project = new Project(projectTDS);
project.Insert(countryId, officeId, projectLeadId, salesmanId, projectNumber, projectType, projectState, name, description, proposalDate, startDate, endDate, clientId, clientPrimaryContactID, clientSecondaryContactID, clientProjectNumber, deleted, OriginalProjectID, projectNumberCopy, libraryCategoriesId, provinceId, cityId, Int32.Parse(hdfCompanyId.Value.Trim()), countyId, fairWageApplies);
// ... Insert History
ProjectHistory projectHistory = new ProjectHistory(projectTDS);
projectHistory.Insert(0, 1, projectState, DateTime.Now, Convert.ToInt32(Session["loginID"]), Int32.Parse(hdfCompanyId.Value.Trim()));
}
protected void grdProjectTime_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
// For Start Time
if (!string.IsNullOrEmpty(hdfStartTime.Value))
{
string startTime = DateTime.Parse(hdfStartTime.Value).ToString("H:mm");
if (startTime != "")
{
string[] hoursMin1 = startTime.Split(':');
((DropDownList)e.Row.FindControl("ddlStartTimeHourFooter")).SelectedValue = hoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlStartTimeMinuteFooter")).SelectedValue = hoursMin1[1].Trim();
}
}
// For End Time
if (!string.IsNullOrEmpty(hdfEndTime.Value))
{
string endTime = DateTime.Parse(hdfEndTime.Value).ToString("H:mm");
if (endTime != "")
{
string[] endHoursMin1 = endTime.Split(':');
((DropDownList)e.Row.FindControl("ddlEndTimeHourFooter")).SelectedValue = endHoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlEndTimeMinuteFooter")).SelectedValue = endHoursMin1[1].Trim();
}
}
// For Lunch
string lunch = hdfOffset.Value;
if (lunch != "")
{
((DropDownList)e.Row.FindControl("ddlLunchFooter")).SelectedValue = lunch;
}
// For Type Of Work
string workFunctionConcat = hdfWorkFunctionConcat.Value;
((DropDownList)e.Row.FindControl("ddlTypeOfWorkFooter")).SelectedValue = workFunctionConcat;
// For Meals Allowance
//string isMealsAllowance = hdfIsMealsAllowance.Value;
//((CheckBox)e.Row.FindControl("ckbxMealsAllowanceFooter")).Checked = Boolean.Parse(isMealsAllowance);
// For Job Class
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(Int32.Parse(ddlProject.SelectedValue));
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
int employeeId = Int32.Parse(((DropDownList)e.Row.FindControl("ddlEmployeesFooter")).SelectedValue);
EmployeeInformationBasicInformationGateway employeeInformationBasicInformation = new EmployeeInformationBasicInformationGateway();
employeeInformationBasicInformation.LoadByEmployeeId(employeeId);
string jobClassType = employeeInformationBasicInformation.GetJobClassType(employeeId);
if (jobClassType != "")
{
((DropDownList)e.Row.FindControl("ddlJobClassTypeFooter")).SelectedValue = jobClassType;
}
}
}
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate))))
{
int teamProjectTimeId = Int32.Parse(((Label)e.Row.FindControl("lblTeamProjectTimeIdEdit")).Text.Trim());
int detailId = Int32.Parse(((Label)e.Row.FindControl("lblDetailIdEdit")).Text.Trim());
TeamProjectTime2DetailGateway teamProjectTime2DetailGateway = new TeamProjectTime2DetailGateway(teamProjectTime2TDS);
// For employee
int employeeId = 0; if (teamProjectTime2DetailGateway.GetEmployeeId(teamProjectTimeId, detailId) != -1) employeeId = teamProjectTime2DetailGateway.GetEmployeeId(teamProjectTimeId, detailId);
if (employeeId != -1)
{
((DropDownList)e.Row.FindControl("ddlEmployeesEdit")).SelectedValue = employeeId.ToString();
}
// For Start Time
string startTime = ""; if (teamProjectTime2DetailGateway.GetStartTime(teamProjectTimeId, detailId) != "") startTime = DateTime.Parse(teamProjectTime2DetailGateway.GetStartTime(teamProjectTimeId, detailId)).ToString("H:mm"); ;
if (startTime != "")
{
string[] hoursMin1 = startTime.Split(':');
((DropDownList)e.Row.FindControl("ddlStartTimeHourEdit")).SelectedValue = hoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlStartTimeMinuteEdit")).SelectedValue = hoursMin1[1].Trim();
}
// For End Time
string endTime = ""; if (teamProjectTime2DetailGateway.GetEndTime(teamProjectTimeId, detailId) != "") endTime = DateTime.Parse(teamProjectTime2DetailGateway.GetEndTime(teamProjectTimeId, detailId)).ToString("H:mm");;
if (endTime != "")
{
string[] endHoursMin1 = endTime.Split(':');
((DropDownList)e.Row.FindControl("ddlEndTimeHourEdit")).SelectedValue = endHoursMin1[0].Trim();
((DropDownList)e.Row.FindControl("ddlEndTimeMinuteEdit")).SelectedValue = endHoursMin1[1].Trim();
}
// For Type Of Work
string work_ = teamProjectTime2DetailGateway.GetWork(teamProjectTimeId, detailId);
string function_ = teamProjectTime2DetailGateway.GetFunction(teamProjectTimeId, detailId);
((DropDownList)e.Row.FindControl("ddlTypeOfWorkFunctionEdit")).SelectedValue = work_ + " . " + function_;
string jobClass = teamProjectTime2DetailGateway.GetJobClassType(teamProjectTimeId, detailId);
((DropDownList)e.Row.FindControl("ddlJobClassTypeEdit")).SelectedValue = jobClass;
// For Unit
int? unitId = null; if (teamProjectTime2DetailGateway.GetUnitId(teamProjectTimeId, detailId).HasValue) unitId = (int)teamProjectTime2DetailGateway.GetUnitId(teamProjectTimeId, detailId);
if (unitId.HasValue)
{
((DropDownList)e.Row.FindControl("ddlUnitEdit")).SelectedValue = ((int)unitId).ToString();
}
// For Towed
int? towedId = null; if (teamProjectTime2DetailGateway.GetTowedUnitId(teamProjectTimeId, detailId).HasValue) towedId = (int)teamProjectTime2DetailGateway.GetTowedUnitId(teamProjectTimeId, detailId);
if (towedId.HasValue)
{
((DropDownList)e.Row.FindControl("ddlTowedEdit")).SelectedValue = ((int)towedId).ToString();
}
}
if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate))))
{
int teamProjectTimeId = Int32.Parse(((Label)e.Row.FindControl("lblTeamProjectTimeId")).Text.Trim());
int detailId = Int32.Parse(((Label)e.Row.FindControl("lblDetailId")).Text.Trim());
TeamProjectTime2DetailGateway teamProjectTime2DetailGateway = new TeamProjectTime2DetailGateway(teamProjectTime2TDS);
// For Start Time
string startTime = "";
try
{
if (teamProjectTime2DetailGateway.GetStartTime(teamProjectTimeId, detailId) != "") startTime = DateTime.Parse(teamProjectTime2DetailGateway.GetStartTime(teamProjectTimeId, detailId)).ToString("H:mm"); ;
}
catch
{
}
if (startTime != "")
{
((TextBox)e.Row.FindControl("tbxStartTime")).Text = startTime;
}
// For End Time
string endTime = "";
try
{
if (teamProjectTime2DetailGateway.GetEndTime(teamProjectTimeId, detailId) != "") endTime = DateTime.Parse(teamProjectTime2DetailGateway.GetEndTime(teamProjectTimeId, detailId)).ToString("H:mm"); ;
}
catch
{
}
if (endTime != "")
{
((TextBox)e.Row.FindControl("tbxEndTime")).Text = endTime;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Validate query string
if (((string)Request.QueryString["source_page"] == null) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null) && ((string)Request.QueryString["period_id"] == null) && ((string)Request.QueryString["projecttime_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_edit.aspx");
}
// Security check
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (Request.QueryString["others"] == "no")
{
if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_EDIT"])))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
else
{
if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_EDIT"])))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_EDIT"])))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
}
}
}
}
// Initialize viewstate variables
ViewState["others"] = Request.QueryString["others"];
ViewState["employee_id"] = int.Parse(Request.QueryString["employee_id"]);
ViewState["period_id"] = int.Parse(Request.QueryString["period_id"]);
ViewState["projecttime_id"] = int.Parse(Request.QueryString["projecttime_id"]);
System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader();
ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString();
hdfCompanyId.Value = Session["companyID"].ToString();
// Get ProjectTime record
ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS);
projectTimeGateway.LoadByProjectTimeId((int)ViewState["projecttime_id"]);
// Project time state check
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (projectTimeGateway.GetProjectTimeState((int)ViewState["projecttime_id"]) == "Approved")
{
Response.Redirect("./../../error_page.aspx?error=" + "You cannot edit an approved project time.");
}
}
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]))
{
bool isValidLimitPayPeriodToManagementEdit = LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime.ValidateLimitedPayPeriodToManagementEdit(projectTimeGateway.GetDate_((int)ViewState["projecttime_id"]), projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"]));
if (!isValidLimitPayPeriodToManagementEdit)
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
else
{
if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]))
{
bool isValidLimitPayPeriodToManagementEdit = LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime.ValidateLimitedPayPeriodToWednesdayManagementEdit(projectTimeGateway.GetDate_((int)ViewState["projecttime_id"]), projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"]));
if (!isValidLimitPayPeriodToManagementEdit)
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
// Store datasets
Session["projectTimeTDS"] = projectTimeTDS;
// Databind
tkrdpDate_.DataBind();
ddlLunch.DataBind();
tbxComments.DataBind();
tbxState.DataBind();
// Prepare initial data for client
StoreNavigatorState();
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]);
tbxEmployee.Text = employeeGateway.GetFullName(int.Parse(Request.QueryString["employee_id"]));
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesList companiesList = new CompaniesList();
companiesList.LoadAndAddItem(-1, "(Select a client)", companyId);
ddlClient.DataSource = companiesList.Table;
ddlClient.DataValueField = "COMPANIES_ID";
ddlClient.DataTextField = "Name";
ddlClient.DataBind();
CompaniesGateway companiesGateway = new CompaniesGateway();
companiesGateway.LoadAllByCompaniesId(Int32.Parse(DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].CompaniesID").ToString()), companyId);
// ... If Company is active
bool deleted = companiesGateway.GetDeleted(Int32.Parse(DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].CompaniesID").ToString()));
if (deleted)
{
ddlClient.SelectedIndex = -1;
}
else
{
ddlClient.SelectedValue = DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].CompaniesID").ToString();
}
ProjectList projectList = new ProjectList();
projectList.LoadProjectsInternalProjectsBallparkProjectsAndAddItem(-1, "(Select a project)", int.Parse(ddlClient.SelectedValue));
ddlProject.DataSource = projectList.Table;
ddlProject.DataValueField = "ProjectID";
ddlProject.DataTextField = "Name";
ddlProject.DataBind();
if (!deleted)
{
try
{
ddlProject.SelectedValue = DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].ProjectID").ToString();
}
catch
{
ddlProject.SelectedIndex = -1;
}
}
else
{
ddlProject.SelectedIndex = -1;
}
if (ddlProject.SelectedIndex != 0)
{
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(Int32.Parse(ddlProject.SelectedValue));
if (projectGateway.GetCountryID(Int32.Parse(ddlProject.SelectedValue)) == 1) //Canada
{
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
ddlJobClassType.Visible = true;
lblJobClassType.Visible = true;
ProjectTimeJobClassTypeList projectTimeJobClassTypeList = new ProjectTimeJobClassTypeList();
projectTimeJobClassTypeList.LoadAndAddItem(1, companyId, "(Select a Job Class Type)");
ddlJobClassType.DataSource = projectTimeJobClassTypeList.Table;
ddlJobClassType.DataValueField = "JobClassType";
ddlJobClassType.DataTextField = "JobClassType";
ddlJobClassType.DataBind();
if (projectTimeGateway.GetJobClassType((int)ViewState["projecttime_id"]).ToString() == "")
{
ddlJobClassType.SelectedIndex = 0;
}
else
{
ddlJobClassType.SelectedValue = (string)DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].JobClassType");
}
}
else
{
ddlJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
}
else
{
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
ddlJobClassType.Visible = true;
lblJobClassType.Visible = true;
ProjectTimeJobClassTypeList projectTimeJobClassTypeList = new ProjectTimeJobClassTypeList();
projectTimeJobClassTypeList.LoadAndAddItem(2, companyId, "(Select a Job Class Type)");
ddlJobClassType.DataSource = projectTimeJobClassTypeList.Table;
ddlJobClassType.DataValueField = "JobClassType";
ddlJobClassType.DataTextField = "JobClassType";
ddlJobClassType.DataBind();
if (projectTimeGateway.GetJobClassType((int)ViewState["projecttime_id"]).ToString() == "")
{
ddlJobClassType.SelectedIndex = 0;
}
else
{
ddlJobClassType.SelectedValue = (string)DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].JobClassType");
}
}
else
{
ddlJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
}
}
else
{
ddlJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
WorkingDetailsGateway workingDetailsGateway = new WorkingDetailsGateway(new DataSet());
workingDetailsGateway.Load();
ddlWorkingDetails.DataSource = workingDetailsGateway.Table;
ddlWorkingDetails.DataValueField = "WorkingDetails";
ddlWorkingDetails.DataTextField = "WorkingDetails";
ddlWorkingDetails.DataBind();
if (!deleted)
{
ddlWorkingDetails.SelectedValue = projectTimeGateway.GetWorkingDetails((int)ViewState["projecttime_id"]);
}
else
{
ddlWorkingDetails.SelectedIndex = -1;
}
ProjectTimeWorkList projectTimeWorkList = new ProjectTimeWorkList(new DataSet());
int projectId = 0;
try
{
projectId = Int32.Parse(ddlProject.SelectedValue);
}
catch
{
}
if (projectId == 35 || projectId == 39 || projectId == 716)
{
projectTimeWorkList.LoadAndAddItem("");
}
else
{
projectTimeWorkList.LoadAndAddItem("(Select a Type)");
}
// Setting start time, end time
string startTime = DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].StartTime", "{0:H:mm}").ToString();
if (!String.IsNullOrEmpty(startTime))
{
string[] hoursMin1 = startTime.Split(':');
ddlStartTimeHour.SelectedValue = hoursMin1[0].Trim();
ddlStartTimeMinute.SelectedValue = hoursMin1[1].Trim();
}
else
{
ddlStartTimeHour.SelectedIndex = 0;
ddlStartTimeMinute.SelectedIndex = 0;
}
string endTime = DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].EndTime", "{0:H:mm}").ToString();
if (!String.IsNullOrEmpty(endTime))
{
string[] endHoursMin1 = endTime.Split(':');
ddlEndTimeHour.SelectedValue = endHoursMin1[0].Trim();
ddlEndTimeMinute.SelectedValue = endHoursMin1[1].Trim();
}
else
{
ddlEndTimeHour.SelectedIndex = 0;
ddlEndTimeMinute.SelectedIndex = 0;
}
// Setting type of Work
ddlTypeOfWork.DataSource = projectTimeWorkList.Table;
ddlTypeOfWork.DataValueField = "Work_";
ddlTypeOfWork.DataTextField = "Work_";
ddlTypeOfWork.DataBind();
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]) == "") ddlTypeOfWork.SelectedIndex = -1; else ddlTypeOfWork.SelectedValue = projectTimeGateway.GetWork((int)ViewState["projecttime_id"]);
ProjectTimeWorkFunctionList projectTimeWorkFunctionList = new ProjectTimeWorkFunctionList(new DataSet());
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]) == "")
{
// ... If there is no type of Work, no function should be loaded
projectTimeWorkFunctionList.LoadAndAddItem("", "-1");
}
else
{
projectTimeWorkFunctionList.LoadAndAddItem("(Select a Function)", projectTimeGateway.GetWork((int)ViewState["projecttime_id"]).ToString());
}
ddlFunction.DataSource = projectTimeWorkFunctionList.Table;
ddlFunction.DataValueField = "Function_";
ddlFunction.DataTextField = "Function_";
ddlFunction.DataBind();
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]).ToString() == "")
{
ddlFunction.SelectedValue = "";
}
else
{
ddlFunction.SelectedValue = (string)DataBinder.Eval(projectTimeTDS, "Tables[LFS_PROJECT_TIME].DefaultView.[0].Function_");
}
CountryList countryList = new CountryList(new DataSet());
countryList.LoadAndAddItem(-1, " ");
ddlMealsCountry.DataSource = countryList.Table;
ddlMealsCountry.DataValueField = "CountryID";
ddlMealsCountry.DataTextField = "Name";
ddlMealsCountry.DataBind();
if (!deleted)
{
if (projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]).HasValue)
{
ddlMealsCountry.SelectedValue = projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]).ToString();
}
else
{
ddlMealsCountry.SelectedValue = "-1";
}
}
else
{
ddlMealsCountry.SelectedIndex = -1;
}
//if (projectTimeGateway.GetMealsAllowance((int)ViewState["projecttime_id"]) > 0)
//{
// cbxMealsAllowance.Checked = true;
//}
string unitType = "Vehicle";
UnitsList unitsList = new UnitsList(new DataSet());
unitsList.LoadAndAddItem("-1", " ", Int32.Parse(Session["companyID"].ToString()), true, 0, unitType);
ddlUnit.DataSource = unitsList.Table;
ddlUnit.DataValueField = "UnitID";
ddlUnit.DataTextField = "UnitCode";
ddlUnit.DataBind();
if (projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]).HasValue)
{
ddlUnit.SelectedValue = ((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"])).ToString();
}
UnitsList towed = new UnitsList(new DataSet());
towed.LoadAndAddItem("-1", " ", Int32.Parse(Session["companyID"].ToString()), true, 1, unitType);
ddlTowed.DataSource = towed.Table;
ddlTowed.DataValueField = "UnitID";
ddlTowed.DataTextField = "UnitCode";
ddlTowed.DataBind();
if (projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]).HasValue)
{
ddlTowed.SelectedValue = ((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"])).ToString();
}
}
else
{
// Restore datasets
projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"];
}
}
protected void ddlProject_SelectedIndexChanged(object sender, EventArgs e)
{
if ((ddlProject.SelectedValue != null) && (ddlProject.SelectedValue != "-1"))
{
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
ProjectTimeJobClassTypeList projectTimeJobClassTypeList = new ProjectTimeJobClassTypeList();
ProjectTimeWorkList projectTimeWorkList = new ProjectTimeWorkList(new DataSet());
projectGateway.LoadByProjectId(int.Parse(ddlProject.SelectedValue));
if (int.Parse(ddlProject.SelectedValue) == 35 || int.Parse(ddlProject.SelectedValue) == 39 || int.Parse(ddlProject.SelectedValue) == 716)
{
projectTimeWorkList.LoadAndAddItem("");
}
else
{
projectTimeWorkList.LoadAndAddItem("(Select a Type)");
}
// Setting type of Work
ddlTypeOfWork.DataSource = projectTimeWorkList.Table;
ddlTypeOfWork.DataValueField = "Work_";
ddlTypeOfWork.DataTextField = "Work_";
ddlTypeOfWork.DataBind();
ddlTypeOfWork.SelectedIndex = 0;
switch (projectGateway.GetCountryID(int.Parse(ddlProject.SelectedValue)))
{
case 1:
ddlWorkingDetails.SelectedValue = "Canada";
ddlMealsCountry.SelectedValue = "1";
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
ddlJobClassType.Visible = true;
lblJobClassType.Visible = true;
int companyId = Int32.Parse(hdfCompanyId.Value);
projectTimeJobClassTypeList.LoadAndAddItem(1, companyId, "(Select a Job Class Type)");
ddlJobClassType.DataSource = projectTimeJobClassTypeList.Table;
ddlJobClassType.DataValueField = "JobClassType";
ddlJobClassType.DataTextField = "JobClassType";
ddlJobClassType.DataBind();
}
else
{
ddlJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
break;
case 2:
ddlWorkingDetails.SelectedValue = "USA";
ddlMealsCountry.SelectedValue = "2";
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
ddlJobClassType.Visible = true;
lblJobClassType.Visible = true;
int companyId = Int32.Parse(hdfCompanyId.Value);
projectTimeJobClassTypeList.LoadAndAddItem(2, companyId, "(Select a Job Class Type)");
ddlJobClassType.DataSource = projectTimeJobClassTypeList.Table;
ddlJobClassType.DataValueField = "JobClassType";
ddlJobClassType.DataTextField = "JobClassType";
ddlJobClassType.DataBind();
}
else
{
ddlJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
break;
}
}
upnlWorkingDetails.Update();
upnlMealsCountry.Update();
upnlJobClassType.Update();
upnlJobClassTypeLabel.Update();
upnlTypeOfWork.Update();
rfvProject.Validate();
}
// ////////////////////////////////////////////////////////////////////////
// AUXILIAR EVENTS
//
protected void cvJobClassType_ServerValidate(object source, ServerValidateEventArgs args)
{
args.IsValid = true;
int projectId = int.Parse(ddlProject.SelectedValue);
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(int.Parse(ddlProject.SelectedValue));
if (projectGateway.GetFairWageApplies(projectId))
{
string jobClass = ddlJobClassType.SelectedValue;
if (jobClass == "(Select a Job Class Type)")
{
args.IsValid = false;
}
}
}
private void PostPageChanges()
{
int projectTimeId = (int)ViewState["projecttime_id"];
int companiesId = int.Parse(ddlClient.SelectedValue);
int projectId = int.Parse(ddlProject.SelectedValue);
DateTime date_ = tkrdpDate_.SelectedDate.Value;
string workingDetails = ""; if (ddlWorkingDetails.SelectedValue != "(Select)") workingDetails = ddlWorkingDetails.SelectedValue;
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectId);
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId));
string location = countryGateway.GetName(projectGateway.GetCountryID(projectId));
DateTime? startTime = null;
if ((ddlStartTimeHour.SelectedValue.Trim() != "") && (ddlStartTimeMinute.SelectedValue.Trim() != "") )
{
startTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlStartTimeHour.SelectedValue), Int32.Parse(ddlStartTimeMinute.SelectedValue), 0);
}
DateTime? endTime = null;
if ((ddlEndTimeHour.SelectedValue.Trim() != "") && (ddlEndTimeMinute.SelectedValue.Trim() != "") )
{
endTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlEndTimeHour.SelectedValue), Int32.Parse(ddlEndTimeMinute.SelectedValue), 0);
}
string work_ = ""; if (ddlTypeOfWork.SelectedValue != "(Select a Type)") work_ = ddlTypeOfWork.SelectedValue;
string function_ = ""; if (ddlFunction.SelectedValue != "(Select a Function)") function_ = ddlFunction.SelectedValue;
double? offset = 0; if (ddlLunch.SelectedValue != "0") offset = double.Parse(ddlLunch.SelectedValue);
Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue);
string mealsAllowanceType = ""; //if (cbxMealsAllowance.Checked) mealsAllowanceType = "Full Day";
decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, false, "Full Day");
int? unitId = null; if (ddlUnit.SelectedValue != "-1") unitId = int.Parse(ddlUnit.SelectedValue);
int? towedUnitId = null; if (ddlTowed.SelectedValue != "-1") towedUnitId = int.Parse(ddlTowed.SelectedValue);
string comments = tbxComments.Text.Trim();
bool fairWage = projectGateway.GetFairWageApplies(projectId);
string jobClassType = ""; if (ddlJobClassType.SelectedValue != "(Select a Job Class Type)") jobClassType = ddlJobClassType.SelectedValue;
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
int employeeId = employeeGateway.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"]));
LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime projectTime = new LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime(projectTimeTDS);
projectTime.Update(projectTimeId, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, work_, function_, fairWage, jobClassType, employeeId);
}
private void UpdateState()
{
ProjectGateway projectGateway = new ProjectGateway(projectTDS);
int projectId = int.Parse(hdfProjectId.Value);
projectGateway.LoadByProjectId(projectId);
Int64 countryId = projectGateway.GetCountryID(projectId);
int officeId = projectGateway.GetOfficeID(projectId);
Int64? provinceId = projectGateway.GetProvinceID(projectId);
Int64? cityId = projectGateway.GetCityID(projectId);
Int64? countyId = projectGateway.GetCountyID(projectId);
int? projectLeadId = projectGateway.GetProjectLeadID(projectId);
int salesmanId = projectGateway.GetSalesmanID(projectId);
string projectType = projectGateway.GetProjectType(projectId);
string projectState = null;
switch ((string)Request.QueryString["state"])
{
//Proposal
case "proposal_award":
projectState = "Awarded";
break;
case "proposal_lost_bid":
projectState = "Lost Bid";
break;
case "proposal_cancel":
projectState = "Canceled";
break;
case "proposal_bidding":
projectState = "Bidding";
break;
case "proposal_unpromote_to_ballpark":
projectState = "Active";
projectType = "Ballpark";
break;
case "proposal_promote_to_project":
projectState = "Active";
projectType = "Project";
break;
//Project
case "project_waiting":
projectState = "Waiting";
break;
case "project_activate":
projectState = "Active";
break;
case "project_inactivate":
projectState = "Inactive";
break;
case "project_complete":
projectState = "Complete";
break;
case "project_cancel":
projectState = "Canceled";
break;
case "project_unpromote_to_ballpark":
projectState = "Active";
projectType = "Ballpark";
break;
case "project_unpromote_to_proposal":
projectState = "Awarded";
projectType = "Proposal";
break;
case "project_tagAsInternal":
projectState = "Active";
projectType = "Internal";
break;
//Internal Project
case "internalProject_activate":
projectState = "Active";
break;
case "internalProject_complete":
projectState = "Complete";
break;
case "internalProject_cancel":
projectState = "Canceled";
break;
case "internalProject_promote_to_proposal":
projectState = "Awarded";
projectType = "Proposal";
break;
case "internalProject_promote_to_project":
projectState = "Active";
projectType = "Project";
break;
//Ballpark
case "ballparkProject_activate":
projectState = "Active";
break;
case "ballparkProject_cancel":
projectState = "Canceled";
break;
case "ballparkProject_promote_to_proposal":
projectState = "Bidding";
projectType = "Proposal";
break;
case "ballparkProject_promote_to_project":
projectState = "Active";
projectType = "Project";
break;
}
string name = projectGateway.GetName(projectId);
string description = projectGateway.GetDescription(projectId);
DateTime? proposalDate = projectGateway.GetProposalDate(projectId);
DateTime? startDate = projectGateway.GetStartDate(projectId);
DateTime? endDate = projectGateway.GetEndDate(projectId);
int clientId = projectGateway.GetClientID(projectId);
string clientProjectNumber = projectGateway.GetClientProjectNumber(projectId);
int? clientPrimaryContactId = projectGateway.GetClientPrimaryContactID(projectId);
int? clientSecondaryContactId = projectGateway.GetClientSecondaryContactID(projectId);
bool deleted = projectGateway.GetDeleted(projectId);
int? libraryCategoriesId = projectGateway.GetLibraryCategoriesId(projectId);
bool fairWageApplies = projectGateway.GetFairWageApplies(projectId);
// Update project
Project project = new Project(projectTDS);
string projectNumber = project.UpdateProjectNumber(projectId, salesmanId);
project.Update(projectId, countryId, officeId, projectLeadId, salesmanId, projectNumber, projectType, projectState, name, description, proposalDate, startDate, endDate, clientId, clientProjectNumber, clientPrimaryContactId, clientSecondaryContactId, deleted, libraryCategoriesId, provinceId, cityId, Int32.Parse(hdfCompanyId.Value.Trim()), countyId, fairWageApplies);
//Insert in history
ProjectHistory projectHistory = new ProjectHistory(projectTDS);
int newRefId = projectHistory.GetNewRefId();
projectHistory.Insert(projectId, newRefId, projectState, DateTime.Now, Convert.ToInt32(Session["loginID"]), Int32.Parse(hdfCompanyId.Value.Trim()));
}
private bool StepDataNext()
{
if (ValidateStepData())
{
PostStepDataChanges();
if (ddlTypeOfWork.SelectedValue == "Full Length")
{
switch (ddlFunction.SelectedValue)
{
case "Install":
SectionsInstallProcessGrid();
break;
case "Prep & Measure":
SectionsPrepAndMeasureProcessGrid();
break;
case "Reinstate & Post Video":
SectionsReinstatePostVideoProcessGrid();
break;
}
}
else
{
if (ddlTypeOfWork.SelectedValue == "MH Rehab")
{
switch (ddlFunction.SelectedValue)
{
case "Prep":
ManholesRehabPrepProcessGrid();
break;
case "Spray":
ManholesRehabSprayProcessGrid();
break;
}
}
}
if ((ddlProject.SelectedValue != null) && (ddlProject.SelectedValue != "-1"))
{
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(int.Parse(ddlProject.SelectedValue));
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
if (projectGateway.GetCountryID(Int32.Parse(ddlProject.SelectedValue)) == 1) //Canada
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "1");
odsJobClassType.SelectParameters.Add("jobClassType", "(Select a Job Class Type)");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
else
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "2");
odsJobClassType.SelectParameters.Add("jobClassType", "(Select a Job Class Type)");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
}
else
{
odsJobClassType.SelectParameters.Clear();
odsJobClassType.SelectParameters.Add("countryId", "-1");
odsJobClassType.SelectParameters.Add("jobClassType", "");
odsJobClassType.SelectParameters.Add("companyId", "3");
odsJobClassType.Select();
}
}
return true;
}
else
{
return false;
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP4 - LABOUR HOUR INFORMATION - METHODS
//
private void StepLabourHourInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please verify Labour Hour information";
// Load
ProjectCostingSheetAddLabourHoursInformation model = new ProjectCostingSheetAddLabourHoursInformation(projectCostingSheetAddTDS);
int projectId = Int32.Parse(hdfProjectId.Value);
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(projectId);
if (projectCostingSheetAddTDS.LabourHoursInformation.Rows.Count <= 0)
{
ArrayList works = new ArrayList();
if (cbxRehabAssessmentData.Checked) works.Add("Rehab Assessment");
if (cbxFullLengthLiningData.Checked) works.Add("Full Length");
if (cbxPointRepairData.Checked) { works.Add("Point Lining"); works.Add("Grouting"); }
if (cbxJunctionLiningData.Checked) works.Add("Junction Lining");
if (cbxManholeRehabData.Checked) works.Add("MH Rehab");
if (cbxMobilizationData.Checked) works.Add("Mobilization");
if (cbxOtherData.Checked)
{
works.Add("Other");
works.Add("Downtime");
works.Add("Office");
works.Add("Office / Shop");
works.Add("R & D");
works.Add("Special Projects");
works.Add("Subcontractor");
works.Add("Watermain Relining");
works.Add("SOTA");
}
if (!projectGateway.GetFairWageApplies(projectId))
{
model.Load(works, projectId, tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value), "");
}
else
{
ArrayList jobClassType = new ArrayList();
jobClassType.Add("Laborer Group 2");
jobClassType.Add("Laborer Group 6");
jobClassType.Add("Operator Group 1");
jobClassType.Add("Operator Group 2");
jobClassType.Add("Regular Rate");
model.LoadFairWageProject(works, jobClassType, projectId, tkrdpFrom.SelectedDate.Value, tkrdpTo.SelectedDate.Value, int.Parse(hdfCompanyId.Value), "");
}
}
// Store tables
Session.Remove("labourHoursInformationDummy");
labourHoursInformation = (ProjectCostingSheetAddTDS.LabourHoursInformationDataTable)model.Table;
Session["labourHoursInformation"] = labourHoursInformation;
Session["projectCostingSheetAddTDS"] = projectCostingSheetAddTDS;
grdTeamMembers.Columns[10].Visible = false;
grdTeamMembers.Columns[11].Visible = false;
grdTeamMembers.Columns[12].Visible = false;
grdTeamMembers.Columns[13].Visible = false;
grdTeamMembers.Columns[15].Visible = false;
grdTeamMembers.Columns[16].Visible = false;
grdTeamMembers.Columns[19].Visible = false;
grdTeamMembers.Columns[20].Visible = false;
// Validate grid columns
if (projectGateway.GetCountryID(projectId) == 1) //Canada
{
// Team Members Grid
grdTeamMembers.Columns[14].Visible = true;
grdTeamMembers.Columns[17].Visible = true;
grdTeamMembers.Columns[18].Visible = false;
grdTeamMembers.Columns[21].Visible = false;
// Totals
lblTeamMembersTotalCost.Text = "Total Cost (CAD) : ";
tbxTeamMembersTotalCostCAD.Visible = true;
tbxTeamMembersTotalCostUSD.Visible = false;
}
else
{
if (projectGateway.GetCountryID(projectId) == 2) //USA
{
// Team Members Grid
grdTeamMembers.Columns[14].Visible = false;
grdTeamMembers.Columns[17].Visible = false;
grdTeamMembers.Columns[18].Visible = true;
grdTeamMembers.Columns[21].Visible = true;
// Totals
lblTeamMembersTotalCost.Text = "Total Cost (USD) : ";
tbxTeamMembersTotalCostCAD.Visible = false;
tbxTeamMembersTotalCostUSD.Visible = true;
}
}
grdTeamMembers.DataBind();
StepLabourHoursInformationProcessGrid();
}
// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Validate query string
if (((string)Request.QueryString["source_page"] == null) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null) && ((string)Request.QueryString["period_id"] == null) && ((string)Request.QueryString["projecttime_id"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_summary.aspx");
}
// Security check
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))
{
if (Request.QueryString["others"] == "no")
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
else
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]))
{
if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
}
}
}
}
}
}
}
// Initialize viewstate's variables
ViewState["others"] = Request.QueryString["others"];
ViewState["employee_id"] = int.Parse(Request.QueryString["employee_id"]);
ViewState["period_id"] = int.Parse(Request.QueryString["period_id"]);
ViewState["projecttime_id"] = int.Parse(Request.QueryString["projecttime_id"]);
System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader();
ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString();
// Get ProjectTime record
projectTimeTDS = new ProjectTimeTDS();
ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS);
projectTimeGateway.LoadByProjectTimeId((int)ViewState["projecttime_id"]);
// Store datasets
Session["projectTimeTDS"] = projectTimeTDS;
// Databind
tbxDate.DataBind();
tbxWorkingDetails.DataBind();
tbxStartTime.DataBind();
tbxEndTime.DataBind();
tbxLunch.DataBind();
tbxComments.DataBind();
tbxState.DataBind();
// Prepare initial data for client
StoreNavigatorState();
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]);
tbxEmployee.Text = employeeGateway.GetFullName((int)ViewState["employee_id"]);
int companyId = Int32.Parse(Session["companyID"].ToString());
CompaniesGateway companiesGateway = new CompaniesGateway(new DataSet());
companiesGateway.LoadAllByCompaniesId(projectTimeGateway.GetCompaniesId((int)ViewState["projecttime_id"]), companyId);
tbxClient.Text = companiesGateway.GetName(projectTimeGateway.GetCompaniesId((int)ViewState["projecttime_id"]));
ProjectGateway projectGateway = new ProjectGateway(new DataSet());
projectGateway.LoadByProjectId(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"]));
tbxProject.Text = projectGateway.GetName(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])) + "(" + projectGateway.GetProjectNumber(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])) + ")";
if (projectGateway.GetFairWageApplies(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])))
{
tbxJobClassType.Visible = true;
lblJobClassType.Visible = true;
tbxJobClassType.Text = projectTimeGateway.GetJobClassType((int)ViewState["projecttime_id"]);
}
else
{
tbxJobClassType.Visible = false;
lblJobClassType.Visible = false;
}
if (projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]).HasValue)
{
CountryGateway countryGateway = new CountryGateway(new DataSet());
countryGateway.LoadByCountryId((Int64)projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]));
tbxMealsCountry.Text = countryGateway.GetName((Int64)projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]));
}
//if (projectTimeGateway.GetMealsAllowance((int)ViewState["projecttime_id"]) > 0)
//{
// cbxMealsAllowance.Checked = true;
//}
//if (projectTimeGateway.GetFairWage((int)ViewState["projecttime_id"]))
//{
// cbxFairWage.Checked = true;
//}
if (projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]).HasValue)
{
UnitsGateway unitGateway = new UnitsGateway(new DataSet());
unitGateway.LoadByUnitId((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]), Convert.ToInt32(Session["companyID"]));
tbxUnit.Text = unitGateway.GetUnitCode((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]));
}
if (projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]).HasValue)
{
UnitsGateway unitGateway = new UnitsGateway(new DataSet());
unitGateway.LoadByUnitId((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]), Convert.ToInt32(Session["companyID"]));
tbxTowed.Text = unitGateway.GetUnitCode((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]));
}
tbxTypeOfWork.Text = "";
if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]) != "")
{
tbxTypeOfWork.Text = projectTimeGateway.GetWork((int)ViewState["projecttime_id"]);
}
tbxFunction.Text = "";
if (projectTimeGateway.GetFunction((int)ViewState["projecttime_id"]) != "")
{
tbxFunction.Text = projectTimeGateway.GetFunction((int)ViewState["projecttime_id"]);
}
}
else
{
// Restore datasets
projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"];
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP4 - EMPLOYEES - AUXILIAR EVENTS
//
protected void ddlEmployeesFooter_SelectedIndexChanged(object sender, EventArgs e)
{
ProjectGateway projectGateway = new ProjectGateway();
projectGateway.LoadByProjectId(Int32.Parse(ddlProject.SelectedValue));
DropDownList ddlEmployee = (DropDownList)sender;
int employeeId = Int32.Parse(ddlEmployee.SelectedValue);
if (projectGateway.GetFairWageApplies(int.Parse(ddlProject.SelectedValue)))
{
EmployeeInformationBasicInformationGateway employeeInformationBasicInformation = new EmployeeInformationBasicInformationGateway();
employeeInformationBasicInformation.LoadByEmployeeId(employeeId);
string jobClassType = employeeInformationBasicInformation.GetJobClassType(employeeId);
if (jobClassType != "")
{
((DropDownList)grdProjectTime.FooterRow.FindControl("ddlJobClassTypeFooter")).SelectedValue = jobClassType;
}
}
}