// ////////////////////////////////////////////////////////////////////////
// EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"]) && (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_EDIT"]) || Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_COMMENTS"]))))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Validate query string
if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["unit_id"] == null) || ((string)Request.QueryString["unit_type"] == null) || ((string)Request.QueryString["unit_state"] == null) || ((string)Request.QueryString["active_tab"] == null))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in units_edit.aspx");
}
// Tag Page
hdfUnitId.Value = Request.QueryString["unit_id"].ToString();
hdfUnitType.Value = Request.QueryString["unit_type"].ToString();
hdfUnitState.Value = Request.QueryString["unit_state"].ToString();
hdfActiveTab.Value = Request.QueryString["active_tab"].ToString();
hdfCompanyId.Value = Session["companyID"].ToString();
hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString();
int companyId = Int32.Parse(hdfCompanyId.Value.Trim());
int unitId = Int32.Parse(hdfUnitId.Value.Trim());
aceManufacturer.ContextKey = hdfCompanyId.Value;
// ... For Owner country
CountryList countryList = new CountryList();
countryList.LoadAndAddItem(-1, "(Select a country)");
ddlOwnerCountry.DataSource = countryList.Table;
ddlOwnerCountry.DataValueField = "CountryID";
ddlOwnerCountry.DataTextField = "Name";
ddlOwnerCountry.DataBind();
// ... For License country
ddlLicenseCountry.DataSource = countryList.Table;
ddlLicenseCountry.DataValueField = "CountryID";
ddlLicenseCountry.DataTextField = "Name";
ddlLicenseCountry.DataBind();
Session.Remove("unitsChecklistRulesTempDummy");
Session.Remove("unitsServicesTempDummy");
Session.Remove("unitsInspectionsTempDummy");
Session.Remove("unitsNotesTempDummy");
Session.Remove("unitCostsDummy");
Session.Remove("unitCostsExceptionsDummy");
Session.Remove("costIdSelected");
// ... units_navigator2.aspx
if (Request.QueryString["source_page"] == "units_navigator2.aspx")
{
StoreNavigatorState();
ViewState["update"] = "no";
// ... Set initial tab
if ((string)Session["dialogOpenedUnits"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
unitInformationTDS = new UnitInformationTDS();
unitsChecklistRulesTemp = new UnitInformationTDS.ChecklistDetailsDataTable();
unitsServicesTemp = new UnitInformationTDS.ServiceDetailsDataTable();
unitsInspectionsTemp = new UnitInformationTDS.InspectionDetailsDataTable();
unitsNotesTemp = new UnitInformationTDS.NoteInformationDataTable();
UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS);
unitInformationUnitDetails.LoadByUnitId(unitId, companyId);
UnitInformationInspectionDetails unitInformationInspectionDetailsForEdit = new UnitInformationInspectionDetails(unitInformationTDS);
unitInformationInspectionDetailsForEdit.LoadByUnitId(unitId, companyId);
UnitInformationNoteDetails unitInformationNoteDetailsForEdit = new UnitInformationNoteDetails(unitInformationTDS);
unitInformationNoteDetailsForEdit.LoadByUnitId(unitId, companyId);
UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS);
unitInformationCostInformation.LoadAllByUnitId(unitId, companyId);
UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS);
unitInformationCostExceptionsInformation.LoadAllByUnitId(unitId, companyId);
// ... For Categories
categoriesTDS = new CategoriesTDS();
Category category = new Category(categoriesTDS);
category.LoadByUnitType(hdfUnitType.Value, int.Parse(hdfCompanyId.Value));
// .. For Company Levels
companyLevelsTDS = new CompanyLevelsTDS();
CompanyLevel companyLevel = new CompanyLevel(companyLevelsTDS);
companyLevel.Load(int.Parse(hdfCompanyId.Value));
}
else
{
hdfActiveTab.Value = (string)Session["activeTabUnits"];
// Restore datasets
unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"];
unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"];
unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"];
unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"];
unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"];
categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"];
companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"];
}
arrayCategoriesSelectedForEdit = new ArrayList();
arrayCompanyLevelsSelectedForEdit = new ArrayList();
Session["arrayCategoriesSelectedForEdit"] = arrayCategoriesSelectedForEdit;
Session["arrayCompanyLevelsSelectedForEdit"] = arrayCompanyLevelsSelectedForEdit;
// Store dataset
Session["unitInformationTDS"] = unitInformationTDS;
Session["unitsChecklistRulesTemp"] = unitsChecklistRulesTemp;
Session["unitsServicesTemp"] = unitsServicesTemp;
Session["unitsInspectionsTemp"] = unitsInspectionsTemp;
Session["unitsNotesTemp"] = unitsNotesTemp;
Session["categoriesTDSForUnits"] = categoriesTDS;
Session["companyLevelsTDS"] = companyLevelsTDS;
}
// ... units_summary.aspx or units_edit.aspx
if ((Request.QueryString["source_page"] == "units_summary.aspx") || (Request.QueryString["source_page"] == "units_edit.aspx"))
{
StoreNavigatorState();
ViewState["update"] = Request.QueryString["update"];
// Restore dataset
unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"];
unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"];
unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"];
unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"];
unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"];
categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"];
companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"];
// ... Set initial tab
if ((string)Session["dialogOpenedUnits"] != "1")
{
hdfActiveTab.Value = Request.QueryString["active_tab"];
if (ViewState["update"].ToString().Trim() == "yes")
{
UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS);
unitInformationUnitDetails.LoadByUnitId(unitId, companyId);
UnitInformationInspectionDetails unitInformationInspectionDetailsForEdit = new UnitInformationInspectionDetails(unitInformationTDS);
unitInformationInspectionDetailsForEdit.LoadByUnitId(unitId, companyId);
UnitInformationNoteDetails unitInformationNoteDetailsForEdit = new UnitInformationNoteDetails(unitInformationTDS);
unitInformationNoteDetailsForEdit.LoadByUnitId(unitId, companyId);
UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS);
unitInformationCostInformation.LoadAllByUnitId(unitId, companyId);
UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS);
unitInformationCostExceptionsInformation.LoadAllByUnitId(unitId, companyId);
// Store dataset
Session["unitInformationTDS"] = unitInformationTDS;
}
}
else
{
hdfActiveTab.Value = (string)Session["activeTabUnits"];
}
arrayCategoriesSelectedForEdit = new ArrayList();
arrayCompanyLevelsSelectedForEdit = new ArrayList();
Session["arrayCategoriesSelectedForEdit"] = arrayCategoriesSelectedForEdit;
Session["arrayCompanyLevelsSelectedForEdit"] = arrayCompanyLevelsSelectedForEdit;
}
// ... units_add.aspx
if (Request.QueryString["source_page"] == "units_add.aspx")
{
ViewState["update"] = "yes";
unitInformationTDS = new UnitInformationTDS();
unitsChecklistRulesTemp = new UnitInformationTDS.ChecklistDetailsDataTable();
unitsServicesTemp = new UnitInformationTDS.ServiceDetailsDataTable();
unitsInspectionsTemp = new UnitInformationTDS.InspectionDetailsDataTable();
unitsNotesTemp = new UnitInformationTDS.NoteInformationDataTable();
UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS);
unitInformationUnitDetails.LoadByUnitId(unitId, companyId);
UnitInformationNoteDetails unitInformationNoteDetailsForEdit = new UnitInformationNoteDetails(unitInformationTDS);
unitInformationNoteDetailsForEdit.LoadByUnitId(unitId, companyId);
// ... For Categories
categoriesTDS = new CategoriesTDS();
Category category = new Category(categoriesTDS);
category.LoadByUnitType(hdfUnitType.Value, int.Parse(hdfCompanyId.Value));
// .. For Company Levels
companyLevelsTDS = new CompanyLevelsTDS();
CompanyLevel companyLevel = new CompanyLevel(companyLevelsTDS);
companyLevel.Load(int.Parse(hdfCompanyId.Value));
arrayCategoriesSelectedForEdit = new ArrayList();
arrayCompanyLevelsSelectedForEdit = new ArrayList();
Session["arrayCategoriesSelectedForEdit"] = arrayCategoriesSelectedForEdit;
Session["arrayCompanyLevelsSelectedForEdit"] = arrayCompanyLevelsSelectedForEdit;
// Store dataset
Session["unitInformationTDS"] = unitInformationTDS;
Session["unitsChecklistRulesTemp"] = unitsChecklistRulesTemp;
Session["unitsServicesTemp"] = unitsServicesTemp;
Session["unitsInspectionsTemp"] = unitsInspectionsTemp;
Session["unitsNotesTemp"] = unitsNotesTemp;
Session["categoriesTDSForUnits"] = categoriesTDS;
Session["companyLevelsTDS"] = companyLevelsTDS;
}
// ... For Library
if (Session["libraryTDSForUnits"] != null)
{
libraryTDSForUnits = (LibraryTDS)Session["libraryTDSForUnits"];
}
else
{
libraryTDSForUnits = new LibraryTDS();
}
Session["costIdSelected"] = 0;
grdCostsExceptions.ShowFooter = false;
string filterOptions = string.Format("CostID = {0} AND Deleted = {1}", 0, 0);
odsCostsExceptions.FilterExpression = filterOptions;
// Set initial tab
int activeTabUnits = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTabUnits;
// ... ... Make panels visible
MakePanelsVisible();
// ... ... Data for current unit
LoadUnitData(companyId);
}
else
{
// Restore datasets
unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"];
unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"];
unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"];
unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"];
unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"];
categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"];
companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"];
arrayCategoriesSelectedForEdit = (ArrayList)Session["arrayCategoriesSelectedForEdit"];
arrayCompanyLevelsSelectedForEdit = (ArrayList)Session["arrayCompanyLevelsSelectedForEdit"];
// Set initial tab
int activeTabUnits = Int32.Parse(hdfActiveTab.Value);
tcDetailedInformation.ActiveTabIndex = activeTabUnits;
aceManufacturer.ContextKey = hdfCompanyId.Value;
if (Session["libraryTDSForUnits"] != null)
{
libraryTDSForUnits = (LibraryTDS)Session["libraryTDSForUnits"];
}
else
{
libraryTDSForUnits = new LibraryTDS();
}
LoadNotes();
}
}
// ////////////////////////////////////////////////////////////////////////
// STEP3 - VEHICLE INFORMATION - METHODS
//
private void StepVehicleInformationIn()
{
// Set instruction
Label instruction = (Label)this.Master.FindControl("lblInstruction");
instruction.Text = "Please define license plate information";
// ... For country
CountryList countryList = new CountryList();
countryList.LoadAndAddItem(-1, "(Select a country)");
ddlLicenseCountry.DataSource = countryList.Table;
ddlLicenseCountry.DataValueField = "CountryID";
ddlLicenseCountry.DataTextField = "Name";
ddlLicenseCountry.DataBind();
foreach (int companyLevelId in arrayCompanyLevelsSelected)
{
if (companyLevelId == 2)
{
ddlLicenseCountry.SelectedIndex = 1;
}
if (companyLevelId == 3)
{
ddlLicenseCountry.SelectedIndex = 2;
}
}
ProvinceList provinceList = new ProvinceList();
provinceList.LoadByCountryIdAndAddItem(-1, "(Select a state)", int.Parse(ddlLicenseCountry.SelectedValue));
ddlLicenseState.DataSource = provinceList.Table;
ddlLicenseState.DataValueField = "ProvinceID";
ddlLicenseState.DataTextField = "Name";
ddlLicenseState.DataBind();
ddlLicenseState.SelectedIndex = 0;
}
// ////////////////////////////////////////////////////////////////////////
// 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"];
}
}
// ////////////////////////////////////////////////////////////////////////
// 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))
{
Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_add.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_ADD"])))
{
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_ADD"])))
{
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_ADD"])))
{
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.");
}
}
}
}
}
}
}
}
// Tag Page
hdfSaveClick.Value = "false";
hdfEmployeeID.Value = Request.QueryString["employee_id"].ToString();
hdfPeriodId.Value = Request.QueryString["period_id"];
hdfCompanyId.Value = Session["companyID"].ToString();
hdfIsMoreThan15.Value = "false";
hdfIsMoreThan15Edit.Value = "false";
Session.Remove("projectTimeTempNewDummy");
// Initialize viewstate variables
ViewState["others"] = Request.QueryString["others"];
ViewState["timesheetState"] = "For Approval";
// Get State
int employeeId = Int32.Parse(hdfEmployeeID.Value);
int periodId = Int32.Parse(hdfPeriodId.Value);
TimesheetGateway timesheet = new TimesheetGateway();
timesheet.LoadByEmployeeIdPayPeriodId(employeeId, periodId);
if (timesheet.Table.Rows.Count != 0)
{
ViewState["timesheetState"] = timesheet.GetStateByEmployeeIdPayPeriodId(employeeId, periodId);
}
if (Request.QueryString["source_page"] == "timesheet_summary.aspx" || Request.QueryString["source_page"] == "timesheet_summary_from_approve_project_times.aspx")
{
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();
// Timesheet state check
if (((string)ViewState["LHMode"] == "Full") && (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])))
{
TimesheetGateway timesheetGateway = new TimesheetGateway();
timesheetGateway.LoadByEmployeeIdPayPeriodId(employeeId, periodId);
if ((timesheetGateway.Table.Rows.Count != 0) && (timesheetGateway.GetStateByEmployeeIdPayPeriodId(employeeId, periodId) != "Rejected"))
{
Response.Redirect("./../../error_page.aspx?error=" + "You cannot add project time to an approved or submitted timesheet.");
}
}
// Prepare initial data for client
EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet());
employeeGateway.LoadByEmployeeId(employeeId);
tbxEmployee.Text = employeeGateway.GetFullName(employeeId);
tbxState.Text = "For Approval";
int companyId = Int32.Parse(hdfCompanyId.Value);
CompaniesList companiesList = new CompaniesList(new DataSet());
companiesList.LoadAndAddItem(-1, "(Select a client)", companyId);
ddlClient.DataSource = companiesList.Table;
ddlClient.DataValueField = "COMPANIES_ID";
ddlClient.DataTextField = "Name";
ddlClient.DataBind();
ddlClient.SelectedIndex = 0;
ProjectList projectList = new ProjectList();
projectList.LoadActiveProjectsActiveInternalProjectsActiveBallparkProjectsAndAddItem(-1, "(Select a project)", -1);
ddlProject.DataSource = projectList.Table;
ddlProject.DataValueField = "ProjectID";
ddlProject.DataTextField = "Name";
ddlProject.DataBind();
ddlProject.SelectedIndex = 0;
CountryList countryList = new CountryList(new DataSet());
countryList.LoadAndAddItem(-1, " ");
ddlMealsCountry.DataSource = countryList.Table;
ddlMealsCountry.DataValueField = "CountryID";
ddlMealsCountry.DataTextField = "Name";
ddlMealsCountry.DataBind();
tkrdpStartDate.SelectedDate = DateTime.Now;
tkrdpEndDate.SelectedDate = DateTime.Now;
// Store timesheet dataset
projectTimeTDS = new ProjectTimeTDS();
Session["projectTimeTDS"] = projectTimeTDS;
projectTimeTemp = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
Session["projectTimeTemp"] = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
}
else
{
// Restore datasets
projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"];
projectTimeTemp = projectTimeTDS.LFS_PROJECT_TIME_TEMP;
// Store datasets
Session["projectTimeTemp"] = projectTimeTemp;
}
}
// ////////////////////////////////////////////////////////////////////////
// INITIAL EVENTS
//
protected void Page_Load(object sender, EventArgs e)
{
// Register client scripts
this.RegisterClientScripts();
if (!IsPostBack)
{
// Security check
if (!(Convert.ToBoolean(Session["sgLFS_PROJECTS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_PROJECTS_ADD"])))
{
Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator.");
}
// Tag page
hdfCompanyId.Value = Session["companyID"].ToString();
// Initialize viewstate variables
ViewState["StepFrom"] = "Out";
// Store navigator state
StoreNavigatorState();
// Prepare initial data
// ... for country
CountryList countryList = new CountryList();
countryList.LoadAndAddItem(-1, "(Select a country)");
ddlCountry.DataSource = countryList.Table;
ddlCountry.DataValueField = "CountryID";
ddlCountry.DataTextField = "Name";
ddlCountry.DataBind();
// ... for office
OfficeList officeList = new OfficeList();
officeList.LoadByCountryIdAndAddItem(-1, "(Select an office)", -1);
ddlOffice.DataSource = officeList.Table;
ddlOffice.DataValueField = "OfficeID";
ddlOffice.DataTextField = "Name";
ddlOffice.DataBind();
// ... for province
ProvinceList provinceList = new ProvinceList();
provinceList.LoadByCountryIdAndAddItem(-1, "(Select a province)", -1);
ddlProvince.DataSource = provinceList.Table;
ddlProvince.DataValueField = "ProvinceID";
ddlProvince.DataTextField = "Name";
ddlProvince.DataBind();
// ... for county
CountyList countyList = new CountyList();
countyList.LoadByProvinceIdAndAddItem(-1, "(Select a county)", -1);
ddlCounty.DataSource = countyList.Table;
ddlCounty.DataValueField = "CountyID";
ddlCounty.DataTextField = "Name";
ddlCounty.DataBind();
// ... for city
CityList cityList = new CityList();
cityList.LoadByCountyIdAndAddItem(-1, "(Select a city)", -1);
ddlCity.DataSource = cityList.Table;
ddlCity.DataValueField = "CityID";
ddlCity.DataTextField = "Name";
ddlCity.DataBind();
// ... for employee
EmployeeList employeeList = new EmployeeList();
employeeList.LoadAndAddItem(-1, " ");
ddlProjectLead.DataSource = employeeList.Table;
ddlProjectLead.DataValueField = "EmployeeID";
ddlProjectLead.DataTextField = "FullName";
ddlProjectLead.DataBind();
// ... for salesman
SalesmanList salesmanList = new SalesmanList();
salesmanList.LoadAndAddItem(-1, "(Select a salesman)");
ddlSalesman.DataSource = salesmanList.Table;
ddlSalesman.DataValueField = "SalesmanID";
ddlSalesman.DataTextField = "FullName";
ddlSalesman.DataBind();
// StepLocationIn
// StepSection1In
Wizard.ActiveStepIndex = 0;
StepTypeOfProjectIn();
}
}
