/// <summary> /// GetAllCategoryManagers /// </summary> /// <param name="category">category</param> /// <param name="employeeId">employeeId</param> /// <returns>All Category Managers</returns> public string GetAllCategoryManagers(string category, int employeeId) { string allCategoryManagers = ""; EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(); employeeInformationBasicInformationGateway.LoadByEmployeeId(employeeId); string employeeType = ""; if (employeeInformationBasicInformationGateway.GetType(employeeId).Contains("CA")) { employeeType = "%CA"; } else { employeeType = "%US"; } EmployeeGateway employeeGateway = new EmployeeGateway(Data); employeeGateway.LoadApproveManagersByCategoryType(category, employeeType); foreach (EmployeeTDS.LFS_RESOURCES_EMPLOYEERow row in (EmployeeTDS.LFS_RESOURCES_EMPLOYEEDataTable)Table) { if (allCategoryManagers.Length > 0) { allCategoryManagers = allCategoryManagers + ", " + row.LastName + " " + row.FirstName; } else { allCategoryManagers = allCategoryManagers + row.LastName + " " + row.FirstName; } } //if (allCategoryManagers[allCategoryManagers.Length-1] == ',') //{ // allCategoryManagers = allCategoryManagers.Substring(0, allCategoryManagers.Length - 2); //} return allCategoryManagers; }
protected void grdProjectTime_RowDataBound(object sender, GridViewRowEventArgs e) { // Footer Item if (e.Row.RowType == DataControlRowType.Footer) { EmployeeInformationBasicInformationGateway employeeInformationBasicInformation = new EmployeeInformationBasicInformationGateway(); employeeInformationBasicInformation.LoadByEmployeeId(Int32.Parse(hdfEmployeeID.Value)); string jobClassType = employeeInformationBasicInformation.GetJobClassType(Int32.Parse(hdfEmployeeID.Value)); if (jobClassType != "") { try { ((DropDownList)e.Row.FindControl("ddlJobClassTypeFooter")).SelectedValue = jobClassType; } catch { } } } // Edit Item if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)))) { int projectTimeId = Int32.Parse(((Label)e.Row.FindControl("lblProjectTimeIdEdit")).Text.Trim()); ProjectTimeTempGateway projectTimeTempGateway = new ProjectTimeTempGateway(projectTimeTDS); // For Start Time string startTime = ""; if (projectTimeTempGateway.GetStartTime(projectTimeId) != "") startTime = projectTimeTempGateway.GetStartTime(projectTimeId); 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 (projectTimeTempGateway.GetEndTime(projectTimeId) != "") endTime = projectTimeTempGateway.GetEndTime(projectTimeId); 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 workFunctionConcat = projectTimeTempGateway.GetWorkFunctionConcat(projectTimeId); ((DropDownList)e.Row.FindControl("ddlTypeOfWorkFunctionEdit")).SelectedValue = workFunctionConcat; // For UnitId int? unitId = null; if (projectTimeTempGateway.GetUnitId(projectTimeId).HasValue) unitId = (int)projectTimeTempGateway.GetUnitId(projectTimeId); if (unitId.HasValue) { ((DropDownList)e.Row.FindControl("ddlUnitEdit")).SelectedValue = ((int)unitId).ToString(); } // For TowedId int? towedId = null; if (projectTimeTempGateway.GetTowedUnitId(projectTimeId).HasValue) towedId = (int)projectTimeTempGateway.GetTowedUnitId(projectTimeId); if (towedId.HasValue) { ((DropDownList)e.Row.FindControl("ddlTowedEdit")).SelectedValue = ((int)towedId).ToString(); } string jobClassType = projectTimeTempGateway.GetJobClassType(projectTimeId); if (jobClassType != "") { try { ((DropDownList)e.Row.FindControl("ddlJobClassTypeEdit")).SelectedValue = jobClassType; } catch { } } } }
// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// LoadByEmployeeId /// </summary> /// <param name="employeeId">employeeId</param> /// <param name="companyId">companyId</param> public void LoadByEmployeeId(int employeeId, int companyId) { EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(Data); employeeInformationBasicInformationGateway.LoadByEmployeeId(employeeId); }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_VIEW"]))) { 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)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in vacations_all.aspx"); } // Tag page int companyId = Int32.Parse(Session["companyID"].ToString()); hdfCompanyId.Value = companyId.ToString(); // ... For non vacation managers EmployeeGateway employeeGatewayManager = new EmployeeGateway(); int employeeIdNow = employeeGatewayManager.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); employeeGatewayManager.LoadByEmployeeId(employeeIdNow); if (employeeGatewayManager.GetIsVacationsManager(employeeIdNow)) { hdfIsVacationManager.Value = "True"; } else { hdfIsVacationManager.Value = "False"; } // Initialize values DropDownList ddlVacationsFor = (DropDownList)tkrpbLeftMenuAllVacations.FindItemByValue("nbVacationsForDDL").FindControl("ddlVacationsFor"); EmployeeList employeeList = new EmployeeList(); string employeeTypeNow = employeeGatewayManager.GetType(employeeIdNow); if (employeeTypeNow.Contains("CA")) { employeeList.LoadBySalariedEmployeeTypeAndAddItem(1, "CA", -1, "(All)"); } else { employeeList.LoadBySalariedEmployeeTypeAndAddItem(1, "US", -1, "(All)"); } ddlVacationsFor.DataSource = employeeList.Table; ddlVacationsFor.DataValueField = "EmployeeID"; ddlVacationsFor.DataTextField = "FullName"; ddlVacationsFor.DataBind(); //... date_to_show if ((string)Request.QueryString["date_to_show"] == null) { ViewState["date_to_show"] = DateTime.Now.ToString(); } else { ViewState["date_to_show"] = (string)Request.QueryString["date_to_show"]; } // Load vacations vacationsInformationTDS = new VacationsInformationTDS(); vacationsInformation = new VacationsInformationTDS.VacationsInformationDataTable(); VacationsInformationGateway vacationsInformationGateway = new VacationsInformationGateway(vacationsInformationTDS); if (hdfIsVacationManager.Value == "False") { EmployeeGateway employeeGateway1 = new EmployeeGateway(); ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(); employeeInformationBasicInformationGateway.LoadByEmployeeId(Int32.Parse(ViewState["employee_id"].ToString())); string employeeType = employeeInformationBasicInformationGateway.GetType(Int32.Parse(ViewState["employee_id"].ToString())); if (employeeType.Contains("CA")) { ddlWorkingLocation.SelectedValue = "CA"; } else { ddlWorkingLocation.SelectedValue = "US"; } vacationsInformationGateway.LoadByEmployeeIdEmployeeType(Int32.Parse(ViewState["employee_id"].ToString()), employeeType, companyId); } else { if ((string)Request.QueryString["employee_id"] == null) { ViewState["employee_id"] = "-1"; if (employeeTypeNow.Contains("CA")) { ddlWorkingLocation.SelectedValue = "CA"; } else { ddlWorkingLocation.SelectedValue = "US"; } vacationsInformationGateway.LoadByEmployeeType(employeeTypeNow, companyId); } else { ViewState["employee_id"] = (string)Request.QueryString["employee_id"]; EmployeeInformationBasicInformationGateway employeeInformationBasicInformationGateway = new EmployeeInformationBasicInformationGateway(); employeeInformationBasicInformationGateway.LoadByEmployeeId(Int32.Parse(ViewState["employee_id"].ToString())); string employeeType = employeeInformationBasicInformationGateway.GetType(Int32.Parse(ViewState["employee_id"].ToString())); if (employeeTypeNow.Contains("CA")) { ddlWorkingLocation.SelectedValue = "CA"; } else { ddlWorkingLocation.SelectedValue = "US"; } vacationsInformationGateway.LoadByEmployeeIdEmployeeType(Int32.Parse(ViewState["employee_id"].ToString()), employeeType, companyId); ddlVacationsFor.SelectedValue = ViewState["employee_id"].ToString(); } } Session["vacationsInformationTDS"] = vacationsInformationTDS; Session["vacationsInformation"] = vacationsInformationTDS.VacationsInformation; tkrsVacations.SelectedDate = DateTime.Parse(ViewState["date_to_show"].ToString()); lblTitle.Text = "Vacations Calendar for " + tkrsVacations.SelectedDate.ToString("MMMM") + " " + tkrsVacations.SelectedDate.Year.ToString(); // Databind Page.DataBind(); // For Open Vacation event if ((Request.Params["__EVENTTARGET"]) == "openVacation") { int vacationId = Int32.Parse(Request.Params.Get("__EVENTARGUMENT").ToString()) ; VacationsInformationDaysInformationGateway vacationsInformationDaysInformationGateway = new VacationsInformationDaysInformationGateway(); vacationsInformationDaysInformationGateway.LoadByVacationId(vacationId, companyId); int requestId = vacationsInformationDaysInformationGateway.GetRequestID(vacationId); Session["ddlVacationsForSelectedValue"] = ddlVacationsFor.SelectedValue; Response.Redirect("./vacations_summary.aspx?source_page=vacations_all.aspx&vacation_id=" + vacationId.ToString() + "&request_id=" + requestId.ToString() + "&date_to_show=" + ViewState["date_to_show"]); } } else { vacationsInformationTDS = (VacationsInformationTDS)Session["vacationsInformationTDS"]; vacationsInformation = (VacationsInformationTDS.VacationsInformationDataTable)Session["vacationsInformation"]; // For Open Vacation event if ((Request.Params["__EVENTTARGET"]) == "openVacation") { int vacationId = Int32.Parse(Request.Params.Get("__EVENTARGUMENT").ToString()); VacationsInformationDaysInformationGateway vacationsInformationDaysInformationGateway = new VacationsInformationDaysInformationGateway(); vacationsInformationDaysInformationGateway.LoadByVacationId(vacationId, Int32.Parse(hdfCompanyId.Value)); int requestId = vacationsInformationDaysInformationGateway.GetRequestID(vacationId); DropDownList ddlVacationsFor = (DropDownList)tkrpbLeftMenuAllVacations.FindItemByValue("nbVacationsForDDL").FindControl("ddlVacationsFor"); Session["ddlVacationsForSelectedValue"] = ddlVacationsFor.SelectedValue; Response.Redirect("./vacations_summary.aspx?source_page=vacations_all.aspx&vacation_id=" + vacationId.ToString() + "&request_id=" + requestId.ToString() + "&date_to_show=" + ViewState["date_to_show"]); } } }
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; } } }
// //////////////////////////////////////////////////////////////////////// // 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; } } }