private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data int companyId = Int32.Parse(hdfCompanyId.Value); string period = ddlPeriod.SelectedItem.Value; int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); LiquiForce.LFSLive.BL.FleetManagement.Services.ServicesSRAboutToExpireReport servicesSRAboutToExpireReport = new LiquiForce.LFSLive.BL.FleetManagement.Services.ServicesSRAboutToExpireReport(); if (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_ADMIN"])) { servicesSRAboutToExpireReport.LoadItemsAboutToExpire(period, companyId); } else { servicesSRAboutToExpireReport.LoadItemsAboutToExpireByAssignTeamMemberID(period, employeeId, companyId); } // ... set properties to master page master.Data = servicesSRAboutToExpireReport.Data; master.Table = servicesSRAboutToExpireReport.TableName; // Get report if (servicesSRAboutToExpireReport.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new ServicesSRAboutToExpireReport(); // Report format master.Report.PrintOptions.PaperOrientation = PaperOrientation.Landscape; master.Report.PrintOptions.PaperSize = PaperSize.PaperLegal; } else { master.Report = new ServicesSRAboutToExpireReportExport(); } // ... set parameters to report if (master.Format == "pdf") { LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); master.SetParameter("Period", period.ToString()); } } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); LiquiForce.LFSLive.BL.FleetManagement.Services.ServicesSRExpiredReport servicesSRExpiredReport = new LiquiForce.LFSLive.BL.FleetManagement.Services.ServicesSRExpiredReport(); if (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_ADMIN"])) { servicesSRExpiredReport.LoadExpiredItems(companyId); } else { servicesSRExpiredReport.LoadExpiredItemsByAssignTeamMemberID(employeeId, companyId); } // ... set properties to master page master.Data = servicesSRExpiredReport.Data; master.Table = servicesSRExpiredReport.TableName; // Get report if (servicesSRExpiredReport.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new ServicesSRExpiredReport(); } else { master.Report = new ServicesSRExpiredReportExport(); } // ... set parameters to report if (master.Format == "pdf") { LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); } } }
// //////////////////////////////////////////////////////////////////////// // INITIAL EVENTS // protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { EmployeeGateway employeeGatewayManager = new EmployeeGateway(); int employeeIdNow = employeeGatewayManager.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); employeeGatewayManager.LoadByEmployeeId(employeeIdNow); if (!employeeGatewayManager.GetIsVacationsManager(employeeIdNow)) { // Security check if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_REPORTS"])) { 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_summary_report.aspx"); } EmployeeInformationPayVacationDaysInformationList employeeInformationPayVacationDaysInformationList = new EmployeeInformationPayVacationDaysInformationList(); employeeInformationPayVacationDaysInformationList.Load(); ddlYear.DataSource = employeeInformationPayVacationDaysInformationList.Table; ddlYear.DataValueField = "Year"; ddlYear.DataTextField = "Year"; ddlYear.DataBind(); try { ddlYear.SelectedValue = DateTime.Now.Year.ToString(); } catch { } // Register delegates this.RegisterDelegates(); } else { // Register delegates this.RegisterDelegates(); } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); LiquiForce.LFSLive.BL.FleetManagement.ToDoList.ToDoListToDoAssignedToMeReport toDoListToDoAssignedToMeReport = new LiquiForce.LFSLive.BL.FleetManagement.ToDoList.ToDoListToDoAssignedToMeReport(); // could see all to do lists toDoListToDoAssignedToMeReport.LoadToDoAssignedToMeByEmployeeId(employeeId, companyId); toDoListToDoAssignedToMeReport.Table.AcceptChanges(); // ... set properties to master page master.Data = toDoListToDoAssignedToMeReport.Data; master.Table = toDoListToDoAssignedToMeReport.TableName; // Get report if (toDoListToDoAssignedToMeReport.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new ToDoListToDoAssignedToMeReport(); } else { master.Report = new ToDoListToDoAssignedToMeReportExport(); } // ... set parameters to report if (master.Format == "pdf") { LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Tag page // ... 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"; } // Security check //if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_ADD"]))) //{ if (hdfIsVacationManager.Value == "False") { 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["employee_id"] == null) && ((string)Request.QueryString["date_to_show"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in vacations_add.aspx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); hdfEmployeeId.Value = (string)Request.QueryString["employee_id"]; Session.Remove("vacationsAddTDS"); ViewState["date_to_show"] = (string)Request.QueryString["date_to_show"]; DateTime dateToShow = DateTime.Parse((string)Request.QueryString["date_to_show"]); // Prepare initial data // ... For employee list 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)"); } DropDownList ddlVacationsFor = (DropDownList)tkrpbLeftMenuAllVacations.FindItemByValue("nbVacationsForDDL").FindControl("ddlVacationsFor"); ddlVacationsFor.DataSource = employeeList.Table; ddlVacationsFor.DataValueField = "EmployeeID"; ddlVacationsFor.DataTextField = "FullName"; ddlVacationsFor.DataBind(); ddlVacationsFor.SelectedValue = Session["ddlVacationsForSelectedValue"].ToString(); // ... For employee ddl ddlEmployee.DataSource = employeeList.Table; ddlEmployee.DataValueField = "EmployeeID"; ddlEmployee.DataTextField = "FullName"; ddlEmployee.DataBind(); vacationsAddTDS = new VacationsAddTDS(); vacationDaysInformation = new VacationsAddTDS.DaysInformationDataTable(); // If there is a selected employee if (hdfEmployeeId.Value != "-1") { int companyId = Int32.Parse(hdfCompanyId.Value); int employeeId = Int32.Parse(hdfEmployeeId.Value); // ... Verify basic information VacationsAddBasicInformationGateway vacationsAddBasicInformationGateway = new VacationsAddBasicInformationGateway(vacationsAddTDS); vacationsAddBasicInformationGateway.LoadByEmployeeIdYear(employeeId, dateToShow.Year, companyId); if (vacationsAddBasicInformationGateway.Table.Rows.Count == 0) { Response.Redirect("./../../error_page.aspx?error=" + "The team member don't have total paid day vacations defined in the system. Contact your system administrator."); } else { LoadData(employeeId, dateToShow.Year); // ... Load non working days EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(employeeId); string employeeType = employeeGateway.GetType(employeeId); int companyLevelId = 3; //USA if (employeeType.Contains("CA")) { companyLevelId = 2;//Canada } VacationsAddDaysInformation vacationsAddDaysInformation = new VacationsAddDaysInformation(vacationsAddTDS); //vacationsAddDaysInformation.LoadNonWorkingDaysByCompanyLevelId(companyLevelId, companyId); // ... Load previews vacations //vacationsAddDaysInformation.LoadPreviousVacations(employeeId, companyId); vacationsAddDaysInformation.LoadDataForVacationsAdd(companyLevelId, employeeId, companyId); } } ViewState["employee_id"] = hdfEmployeeId.Value; Session["vacationsAddTDS"] = vacationsAddTDS; Session["vacationDaysInformation"] = vacationsAddTDS.DaysInformation; Page.DataBind(); } else { vacationsAddTDS = (VacationsAddTDS)Session["vacationsAddTDS"]; vacationDaysInformation = (VacationsAddTDS.DaysInformationDataTable)Session["vacationDaysInformation"]; hdfEmployeeId.Value = ViewState["employee_id"].ToString(); } }
private bool StepStepsInformationNext() { bool valid = ValidatePage(); if (valid) { // Assigment Information if (pnlAssignmentInformation.Visible) { hdfDeadlineDate.Value = ""; if (tkrdpDeadlineDate.SelectedDate.HasValue) hdfDeadlineDate.Value = tkrdpDeadlineDate.SelectedDate.Value.ToString(); // ... Myself hdfAssignToMyself.Value = rbtnAssignToMyself.Checked.ToString(); if (rbtnAssignToMyself.Checked) { int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); hdfTeamMemberId.Value = employeeGateway.GetEmployeIdByLoginId(loginId).ToString(); } // ... Team Member hdfAssignToTeamMember.Value = rbtnAssignToTeamMember.Checked.ToString(); if (rbtnAssignToTeamMember.Checked) { hdfTeamMemberId.Value = ""; if (ddlAssignToTeamMember.SelectedValue != "") hdfTeamMemberId.Value = ddlAssignToTeamMember.SelectedValue; hdfTeamMemberFullName.Value = ""; if (ddlAssignToTeamMember.SelectedItem.Text != "") hdfTeamMemberFullName.Value = ddlAssignToTeamMember.SelectedItem.Text; hdfThirdPartyVendor.Value = ""; } // ... Third party vendor hdfAssignToThirdPartyVendor.Value = rbtnAssignToThirdPartyVendor.Checked.ToString(); if (rbtnAssignToThirdPartyVendor.Checked) { hdfTeamMemberId.Value = ""; hdfTeamMemberFullName.Value = ""; hdfThirdPartyVendor.Value = ""; if (tbxAssignToThirdPartyVendor.Text != "") hdfThirdPartyVendor.Value = tbxAssignToThirdPartyVendor.Text.Trim(); } } // Accept information if (pnlAcceptInformation.Visible) { hdfAcceptSR.Value = ckbxAcceptSR.Checked.ToString(); } // Start work information if (pnlStartWorkInformation.Visible) { hdfStartSR.Value = ckbxStartSR.Checked.ToString(); if (ckbxStartSR.Checked) { hdfUnitOutOfServiceDate.Value = ""; if (tkrdpStartWorkUnitOutOfServiceDate.SelectedDate.HasValue) hdfUnitOutOfServiceDate.Value = tkrdpStartWorkUnitOutOfServiceDate.SelectedDate.Value.ToString(); hdfUnitOutOfServiceTime.Value = "8:00 AM"; hdfStartMileage.Value = tbxStartWorkStartMileage.Text.Trim(); } } // Complete work information if (pnlCompleteWorkInformation.Visible) { // Costs Gridview, if the gridview is edition mode if (grdCosts.EditIndex >= 0) { grdCosts.UpdateRow(grdCosts.EditIndex, true); } // ... Save cost GrdCostsAdd(); // ... Tag values hdfUnitBackInServiceDate.Value = ""; if (tkrdpCompleteWorkUnitBackInServiceDate.SelectedDate.HasValue) hdfUnitBackInServiceDate.Value = tkrdpCompleteWorkUnitBackInServiceDate.SelectedDate.Value.ToString(); hdfUnitBackInServiceTime.Value = "8:00 AM"; hdfCompleteWorkMileage.Value = tbxCompleteWorkCompleteMileage.Text.Trim(); if (hdfAssignToThirdPartyVendor.Value == "") { hdfCompleteWorkDescription.Value = tbxCompleteWorkDataDescription.Text.Trim(); hdfCompleteWorkPreventable.Value = ckbxCompleteWorkDataPreventable.Checked.ToString(); hdfCompleteWorkLabourHours.Value = tbxCompleteWorkDataLabourHours.Text.Trim(); hdfCompleteWorkCosts.Value = tbxTotalCost.Text.Trim(); hdfInvoiceNumber.Value = ""; hdfInvoiceAmount.Value = ""; } else { hdfCompleteWorkDescription.Value = tbxDescriptionTPV.Text.Trim(); hdfCompleteWorkPreventable.Value = ckbxPreventableTPV.Checked.ToString(); hdfInvoiceNumber.Value = tbxInvoiceNumberTPV.Text.Trim(); hdfInvoiceAmount.Value = tbxInvoiceAmountTPV.Text.Trim(); hdfCompleteWorkLabourHours.Value = ""; hdfCompleteWorkCosts.Value = ""; } } // Notes // Notes Gridview, if the gridview is edition mode if (grdNotes.EditIndex >= 0) { grdNotes.UpdateRow(grdNotes.EditIndex, true); } GrdNotesAdd(); } return valid; }
private void LoadData() { dashboardMyToDoListTDS = new DashboardTDS(); DashboardMyToDoList model = new DashboardMyToDoList(dashboardMyToDoListTDS); DashboardMyToDoListOnHold modelOnHold = new DashboardMyToDoListOnHold(dashboardMyToDoListTDS); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); string state = "%"; if (ddlStateMyToDo.SelectedValue != "(All)") state = ddlStateMyToDo.SelectedValue; // ... Load to do list // ... ...Load for admin if (!Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_ADMIN"])) { if (state == "New & In Progress") { model.LoadMyNewAndInProgressToDoListByCreated(employeeId, companyId); } else { // ... ... Load for assigned employee model.LoadMyCurrentToDoListByCreatedByIdState(employeeId, state, companyId); } modelOnHold.LoadMyCurrentToDoListOnHoldByCreatedById(employeeId, companyId); } else { if (state == "New & In Progress") { model.LoadNewAndInProgressToDoList(companyId); } else { // ... ... Loads all (current) model.LoadCurrentToDoListByState(state, companyId); } modelOnHold.LoadCurrentToDoListOnHold(companyId); } HttpContext.Current.Session.Add("dashboardMyToDoListTDS", dashboardMyToDoListTDS); Page.DataBind(); }
protected void grdProjectTimeApprove_RowDataBound(object sender, GridViewRowEventArgs e) { // Normal items if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { Label lblJobClass = (Label)e.Row.FindControl("lblJobClass"); Label lblTypeOfWork = (Label)e.Row.FindControl("lblTypeOfWork"); EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); employeeGateway1.LoadByEmployeeId(employeeId); string employeeType = employeeGateway1.GetType(employeeId); if (lblTypeOfWork.Text == "Mobilization" && employeeType.Contains("US")) { lblJobClass.Visible = false; } } }
private ProjectTimeApproveTDS SubmitSearch() { // Load data ProjectTimeApproveTDS dataSet = new ProjectTimeApproveTDS(); ProjectTimeApproveGateway projectTimeApproveGateway = new ProjectTimeApproveGateway(dataSet); EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); employeeGateway1.LoadByEmployeeId(employeeId); string employeeType = employeeGateway1.GetType(employeeId); if (employeeType.Contains("CA")) { projectTimeApproveGateway.LoadByEmployeeTypeEmployeeIdApproveManager("CA", employeeId); } else { if (employeeType.Contains("US")) { projectTimeApproveGateway.LoadByEmployeeTypeEmployeeIdApproveManager("US", employeeId); } else { projectTimeApproveGateway.LoadByEmployeeTypeEmployeeIdApproveManager("SOTA", employeeId); } } return dataSet; }
private void GrdToDoAdd() { if (ValidateToDoFooter()) { Page.Validate("activityDataNew"); if (Page.IsValid) { int employeeId = 0; EmployeeGateway employeeGateway = new EmployeeGateway(); string dateTime_ = ((TextBox)grdToDoList.FooterRow.FindControl("tbxDateTimeNew")).Text; string comment = ((TextBox)grdToDoList.FooterRow.FindControl("tbxCommentsNew")).Text; string type_ = ""; string employeeFullName = ""; GridViewRow row = grdToDoList.FooterRow; DropDownList action = ((DropDownList)row.FindControl("ddlActionsNew")); switch (action.SelectedValue) { case "Assign To User": employeeId = Int32.Parse(((DropDownList)grdToDoList.FooterRow.FindControl("ddlAssignToTeamMemberNew")).SelectedValue); employeeGateway.LoadByEmployeeId(employeeId); employeeFullName = employeeGateway.GetFullName(employeeId); type_ = "AssignUser"; hdfToDoListState.Value = "In Progress"; break; case "Add Comment": int loginId = Convert.ToInt32(Session["loginID"]); employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); type_ = "AddComment"; employeeFullName = employeeGateway.GetFullName(employeeId); hdfToDoListState.Value = "In Progress"; break; case "Complete": employeeId = Int32.Parse(hdfAssignedUser.Value); employeeGateway.LoadByEmployeeId(employeeId); employeeFullName = employeeGateway.GetFullName(employeeId); type_ = "CloseToDo"; hdfCompleted.Value = "True"; hdfToDoListState.Value = "Completed"; break; case "Put On Hold": int loginIdOnHold = Convert.ToInt32(Session["loginID"]); employeeId = employeeGateway.GetEmployeIdByLoginId(loginIdOnHold); type_ = "OnHoldToDo"; employeeFullName = employeeGateway.GetFullName(employeeId); hdfToDoListState.Value = "On Hold"; break; } // static values int toDoId = Int32.Parse(hdfToDoId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); bool inDatabase = false; ToDoListInformationBasicInformation generalModel = new ToDoListInformationBasicInformation(toDoListInformationTDS); generalModel.UpdateState(toDoId, hdfToDoListState.Value); ToDoListInformationActivityInformation model = new ToDoListInformationActivityInformation(toDoListInformationTDS); model.Insert(toDoId, employeeId, type_, DateTime.Parse(dateTime_), comment, false, companyId, inDatabase, employeeFullName); Session.Remove("activityInformationDummy"); Session["toDoListInformationTDS"] = toDoListInformationTDS; grdToDoList.DataBind(); } } }
protected void Page_PreRender(object sender, EventArgs e) { // Set active toolbar mForm6 master = (mForm6)this.Master; master.ActiveToolbar = "LabourHours"; // ... Labour Hours Mode if ((string)ViewState["LHMode"] == "Partial") { // Access control // ... Employees EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet()); employeeListGateway.LoadByRequestProjectTime(1); DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor"); ddlOthersFor.DataSource = employeeListGateway.Table; ddlOthersFor.DataValueField = "EmployeeID"; ddlOthersFor.DataTextField = "FullName"; ddlOthersFor.DataBind(); tkrpbLeftMenuMyTimesheets.Visible = false; tkrpbLeftMenuOthersTimesheets.Items[0].Text = "Timesheets"; tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; } else { EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); employeeGateway1.LoadByEmployeeId(employeeId); if (Request.QueryString["source_page"] == "timesheet_approve.aspx") { tkrmTop.Items[3].Visible = false; //Timesheet tkrmTop.Items[4].Visible = true; //Approve Project Times } else { tkrmTop.Items[3].Visible = true; //Timesheet // Timesheet state check ProjectTimeGateway projectTimeGatewayForState = new ProjectTimeGateway(projectTimeTDS); int projecttime_id = Int32.Parse(ViewState["projecttime_id"].ToString()); if (projectTimeGatewayForState.GetProjectTimeState(projecttime_id) == "For Approval") { tkrmTop.Items[4].Visible = true; //Approve Project Times } else { tkrmTop.Items[4].Visible = false; //Approve Project Times } } if (!employeeGateway1.GetApproveTimesheets(employeeId)) { tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; //Approve Project Times } if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { tkrpbLeftMenuOthersTimesheets.Visible = true; tkrpbLeftMenuTools.Items[0].Items[0].Visible = true; // Add Team Project Time tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Missing Project Time // Access control // ... Employees EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet()); if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { employeeListGateway.LoadByRequestProjectTimeWithoutEmployeeId(1, employeeId); } else { employeeListGateway.LoadByRequestProjectTime(1); } DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor"); ddlOthersFor.DataSource = employeeListGateway.Table; ddlOthersFor.DataValueField = "EmployeeID"; ddlOthersFor.DataTextField = "FullName"; ddlOthersFor.DataBind(); try { ddlOthersFor.SelectedValue = Session["ddlOthersForSelectedValue"].ToString(); } catch { } } else { tkrpbLeftMenuOthersTimesheets.Visible = false; if (!employeeGateway1.GetApproveTimesheets(employeeId)) { tkrpbLeftMenuTools.Visible = false; } tkrpbLeftMenuTools.Items[0].Items[0].Visible = false; // Add Team Project Time tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Missing Project Time } if (!((Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) && (employeeGateway1.GetRequestProjectTime(employeeId)))) { tkrpbLeftMenuMyTimesheets.Visible = false; tkrpbLeftMenuOthersTimesheets.Items[0].Text = "Timesheets"; } if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_REPORTS"])) { tkrpbLeftMenuReports.Visible = false; } } // Get ProjectTime record, can't edit or delete approved timesheets ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS); projectTimeGateway.LoadByProjectTimeId((int)ViewState["projecttime_id"]); if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { if (projectTimeGateway.GetProjectTimeState((int)ViewState["projecttime_id"]) == "Approved") { tkrmTop.Items[1].Visible = false; tkrmTop.Items[2].Visible = false; } } } }
private void LoadData() { int companyId = Int32.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); string period = ddlPeriod.SelectedItem.Value.ToString(); int companyLevelId = Int32.Parse(ddlWorkingLocation.SelectedValue); dashboardItemsAboutToExpireTDS = (DashboardTDS)HttpContext.Current.Session["dashboardItemsAboutToExpireTDS"]; DashboardItemsAboutToExpire model = new DashboardItemsAboutToExpire(dashboardItemsAboutToExpireTDS); if (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_ADMIN"])) { if (companyLevelId == 0) { if (ddlType.SelectedValue != "(All)") { model.LoadAllItemsAboutToExpireByUnitType(period, companyId, ddlType.SelectedValue); } else { model.LoadAllItemsAboutToExpire(period, companyId); } } else { if (ddlType.SelectedValue != "(All)") { model.LoadAllItemsAboutToExpireByCompanyLevelIdUnitType(period, companyId, companyLevelId, ddlType.SelectedValue); } else { model.LoadAllItemsAboutToExpireByCompanyLevelId(period, companyId, companyLevelId); } } } else { if (companyLevelId == 0) { if (ddlType.SelectedValue != "(All)") { model.LoadAllItemsAboutToExpireByAssignTeamMemberIDUnitType(period, employeeId, companyId, ddlType.SelectedValue); } else { // ... Load for assigned employee model.LoadAllItemsAboutToExpireByAssignTeamMemberID(period, employeeId, companyId); } } else { if (ddlType.SelectedValue != "(All)") { model.LoadAllItemsAboutToExpireByAssignTeamMemberIDCompanyLevelIdUnitType(period, employeeId, companyId, companyLevelId, ddlType.SelectedValue); } else { model.LoadAllItemsAboutToExpireByAssignTeamMemberIDCompanyLevelId(period, employeeId, companyId, companyLevelId); } } } model.UpdateForDashboard(companyId); HttpContext.Current.Session.Add("dashboardItemsAboutToExpireTDS", dashboardItemsAboutToExpireTDS); Page.DataBind(); }
protected void grdToDoList_RowDataBound(object sender, GridViewRowEventArgs e) { // Control of footer row if (e.Row.RowType == DataControlRowType.Footer) { int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); // Select action DropDownList actions = (DropDownList)e.Row.FindControl("ddlActionsNew"); actions.SelectedValue = hdfAction.Value; // Only the assigned user could close the todo if (hdfAssignedUser.Value != employeeId.ToString()) { actions.Items.Remove("Close"); } // Make fields visible for actions if (hdfAction.Value == "Assign To User") { ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = true; ((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = true; ((TextBox)e.Row.FindControl("tbxUserNew")).Visible = false; ((Label)e.Row.FindControl("lblClosed")).Visible = false; ((Label)e.Row.FindControl("lblUserNew")).Text = "Assign To"; } if (hdfAction.Value == "Add Comment") { ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = false; ((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = false; ((TextBox)e.Row.FindControl("tbxUserNew")).Visible = true; EmployeeGateway employeeGatewayForUser = new EmployeeGateway(); employeeGatewayForUser.LoadByEmployeeId(employeeId); ((TextBox)e.Row.FindControl("tbxUserNew")).Text = employeeGatewayForUser.GetFullName(employeeId); ((Label)e.Row.FindControl("lblClosed")).Visible = false; ((Label)e.Row.FindControl("lblUserNew")).Text = "Comment Added By"; } if (hdfAction.Value == "Complete") { ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = false; ((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = false; ((TextBox)e.Row.FindControl("tbxUserNew")).Visible = true; EmployeeGateway employeeGatewayForUser = new EmployeeGateway(); employeeGatewayForUser.LoadByEmployeeId(Int32.Parse(hdfAssignedUser.Value)); ((TextBox)e.Row.FindControl("tbxUserNew")).Text = employeeGatewayForUser.GetFullName(Int32.Parse(hdfAssignedUser.Value)); ((Label)e.Row.FindControl("lblClosed")).Visible = false; ((Label)e.Row.FindControl("lblUserNew")).Text = "To Do Completed By"; } if (hdfCompleted.Value == "True") { ((DropDownList)e.Row.FindControl("ddlActionsNew")).Visible = false; ((TextBox)e.Row.FindControl("tbxDateTimeNew")).Visible = false; ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = false; ((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = false; ((TextBox)e.Row.FindControl("tbxUserNew")).Visible = false; ((TextBox)e.Row.FindControl("tbxCommentsNew")).Visible = false; ((Label)e.Row.FindControl("lblActionNew")).Visible = false; ((Label)e.Row.FindControl("lblDateTimeNew")).Visible = false; ((Label)e.Row.FindControl("lblUserNew")).Visible = false; ((Label)e.Row.FindControl("lblCommentsNew")).Visible = false; ((ImageButton)e.Row.FindControl("ibtnAdd")).Visible = false; ((Label)e.Row.FindControl("lblClosed")).Visible = true; } if (hdfAction.Value == "Put On Hold") { ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberNew")).Visible = false; ((CustomValidator)e.Row.FindControl("cvTeamMemberNew")).Visible = false; ((TextBox)e.Row.FindControl("tbxUserNew")).Visible = true; EmployeeGateway employeeGatewayForOnHold = new EmployeeGateway(); employeeGatewayForOnHold.LoadByEmployeeId(employeeId); ((TextBox)e.Row.FindControl("tbxUserNew")).Text = employeeGatewayForOnHold.GetFullName(employeeId); ((Label)e.Row.FindControl("lblClosed")).Visible = false; ((Label)e.Row.FindControl("lblUserNew")).Text = "On Hold By"; } // Date and time DateTime creationDate = DateTime.Now; ((TextBox)e.Row.FindControl("tbxDateTimeNew")).Text = creationDate.ToString(); } // Control of edit rows if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Edit) || (e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)))) { // Date and time DateTime creationDate = DateTime.Now; ((TextBox)e.Row.FindControl("tbxDateTimeEdit")).Text = creationDate.ToString(); string type_ = ((Label)e.Row.FindControl("lblType")).Text; int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); int toDoId = Int32.Parse(((Label)e.Row.FindControl("lblToDoID")).Text); int refId = Int32.Parse(((Label)e.Row.FindControl("lblRefID")).Text); ToDoListInformationActivityInformationGateway toDoListInformationActivityInformationGateway = new ToDoListInformationActivityInformationGateway(toDoListInformationTDS); // Make fields visible for actions if (type_ == "AssignUser") { int employeeIdForAssign = toDoListInformationActivityInformationGateway.GetEmployeeID(toDoId, refId); ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).Visible = true; ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).SelectedValue = employeeIdForAssign.ToString(); ((CustomValidator)e.Row.FindControl("cvTeamMemberEdit")).Visible = true; ((TextBox)e.Row.FindControl("tbxUserEdit")).Visible = false; ((Label)e.Row.FindControl("lblUserEdit")).Text = "Assign To"; } if (type_ == "AddComment") { ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).Visible = false; ((CustomValidator)e.Row.FindControl("cvTeamMemberEdit")).Visible = false; ((TextBox)e.Row.FindControl("tbxUserEdit")).Visible = true; EmployeeGateway employeeGatewayForUser = new EmployeeGateway(); employeeGatewayForUser.LoadByEmployeeId(employeeId); ((TextBox)e.Row.FindControl("tbxUserEdit")).Text = employeeGatewayForUser.GetFullName(employeeId); ((Label)e.Row.FindControl("lblUserEdit")).Text = "Comment Added By"; } if (type_ == "CloseToDo") { ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).Visible = false; ((CustomValidator)e.Row.FindControl("cvTeamMemberEdit")).Visible = false; ((TextBox)e.Row.FindControl("tbxUserEdit")).Visible = true; EmployeeGateway employeeGatewayForUser = new EmployeeGateway(); employeeGatewayForUser.LoadByEmployeeId(Int32.Parse(hdfAssignedUser.Value)); ((TextBox)e.Row.FindControl("tbxUserEdit")).Text = employeeGatewayForUser.GetFullName(Int32.Parse(hdfAssignedUser.Value)); ((Label)e.Row.FindControl("lblUserEdit")).Text = "To Do Completed By"; } if (type_ == "OnHoldToDo") { ((DropDownList)e.Row.FindControl("ddlAssignToTeamMemberEdit")).Visible = false; ((CustomValidator)e.Row.FindControl("cvTeamMemberEdit")).Visible = false; ((TextBox)e.Row.FindControl("tbxUserEdit")).Visible = true; EmployeeGateway employeeGatewayForOnHold = new EmployeeGateway(); employeeGatewayForOnHold.LoadByEmployeeId(employeeId); ((TextBox)e.Row.FindControl("tbxUserEdit")).Text = employeeGatewayForOnHold.GetFullName(employeeId); ((Label)e.Row.FindControl("lblUserEdit")).Text = "On Hold By"; } } // Control normal rows if ((e.Row.RowType == DataControlRowType.DataRow) && ((e.Row.RowState == DataControlRowState.Normal) || (e.Row.RowState == (DataControlRowState.Normal | DataControlRowState.Alternate)))) { // Validate admin actions if ((Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_ADMIN"]))) { ((ImageButton)e.Row.FindControl("ibtnEdit")).Visible = true; ((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = true; } else { bool inDataBase = bool.Parse(((Label)e.Row.FindControl("lblInDataBase")).Text); if (inDataBase) { ((ImageButton)e.Row.FindControl("ibtnEdit")).Visible = false; ((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = false; } else { ((ImageButton)e.Row.FindControl("ibtnEdit")).Visible = true; ((ImageButton)e.Row.FindControl("ibtnDelete")).Visible = true; } } // Change label text string type_ = ((Label)e.Row.FindControl("lblType")).Text; if (type_ == "AssignUser") { ((Label)e.Row.FindControl("lblUser")).Text = "Assign To"; } if (type_ == "AddComment") { ((Label)e.Row.FindControl("lblUser")).Text = "Comment Added By"; } if (type_ == "CloseToDo") { ((Label)e.Row.FindControl("lblUser")).Text = "To Do Completed By"; } if (type_ == "OnHoldToDo") { ((Label)e.Row.FindControl("lblUser")).Text = "On Hold By"; } } }
private void PostPageChanges() { int projectTimeId = (int)ViewState["projecttime_id"]; EmployeeGateway employeeGateway = new EmployeeGateway(); int employeeId = employeeGateway.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); // Delete project time LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime projectTime = new LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime(projectTimeTDS); projectTime.Delete(projectTimeId, employeeId); }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_ITTST_SUPPORTTICKET_ADMIN"]))) { if (!(Convert.ToBoolean(Session["sgLFS_ITTST_SUPPORTTICKET_VIEW"]) && Convert.ToBoolean(Session["sgLFS_ITTST_SUPPORTTICKET_EDIT"]))) { 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 wucSupportTicketAssignedToMe.ascx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); // Prepare initial data HttpContext.Current.Session.Remove("dashboardSupportTicketAssignedToMeDataTableDummy"); HttpContext.Current.Session.Remove("dashboardSupportTicketAssignedToMeOnHoldDataTableDummy"); ArrayList arrayListWidgetData = (ArrayList)HttpContext.Current.Session["mySupportTicketAssignedToMeWidget"]; ArrayList arrayListWidgetDataOnHold = (ArrayList)HttpContext.Current.Session["mySupportTicketAssignedToMeOnHoldWidget"]; // If coming from // ... Out if (Request.QueryString["source_page"] == "out") { int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); // ... For Grid int companyId = Int32.Parse(hdfCompanyId.Value); dashboardSupportTicketAssignedToMeTDS = new DashboardTDS(); DashboardSupportTicketAssignedToMe model = new DashboardSupportTicketAssignedToMe(dashboardSupportTicketAssignedToMeTDS); DashboardSupportTicketAssignedToMeOnHold modelOnHold = new DashboardSupportTicketAssignedToMeOnHold(dashboardSupportTicketAssignedToMeTDS); // ... Load support ticket model.LoadCurrentSupportTicketAssignedToMeByEmployeeId(employeeId, companyId); modelOnHold.LoadSupportTicketAssignedToMeOnHoldByEmployeeId(employeeId, companyId); // ... Store datasets HttpContext.Current.Session.Add("dashboardSupportTicketAssignedToMeTDS", dashboardSupportTicketAssignedToMeTDS); } } else { // Prepare initial data HttpContext.Current.Session.Remove("dashboardSupportTicketAssignedToMeDataTableDummy"); HttpContext.Current.Session.Remove("dashboardSupportTicketAssignedToMeOnHoldDataTableDummy"); // Restore dataset dashboardSupportTicketAssignedToMeTDS = (DashboardTDS)HttpContext.Current.Session["dashboardSupportTicketAssignedToMeTDS"]; } }
// //////////////////////////////////////////////////////////////////////// // 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_HOLIDAY_FULL_EDITING"]))) { 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_setup.aspx"); } // Tag page // ... 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"; } hdfCompanyId.Value = Session["companyID"].ToString(); hdfUpdate.Value = "no"; Session.Remove("vacationsSetup"); Session.Remove("vacationsSetupDummy"); // Prepare initial data // ... For Grids vacationsSetup = new VacationsSetupTDS.VacationsSetupDataTable(); // ... Store datasets Session["vacationsSetup"] = vacationsSetup; // StepSection1In wizard.ActiveStepIndex = 0; StepBeginIn(); } else { // Restore datasets vacationsSetup = (VacationsSetupTDS.VacationsSetupDataTable)Session["vacationsSetup"]; } }
// //////////////////////////////////////////////////////////////////////// // 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_FULL_EDITING"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) && !Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) && !Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) && !Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]) && !Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]) && !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."); } } // 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.aspx"); } // Tag page Session.Remove("timesheetNavigatorDummy"); // Initialize variables lblError.Visible = false; // ... Labour Hours Mode System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader(); ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString(); // ... If coming from out if ((string)Request.QueryString["source_page"] == "out") { Session.Remove("ddlOthersForSelectedValue"); // Store search parameters ViewState["current"] = "yes"; if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { ViewState["others"] = "yes"; } else { ViewState["others"] = "no"; } EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); ViewState["period_id"] = payPeriodGateway.GetPayPeriodId(DateTime.Now); if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_AUTOREPORT"])) { string script = "<script language='javascript'>"; script += "window.open('./../projecttime/timesheet_missing.aspx?source_page=timesheet.aspx', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=550, height=420')"; script += "</script>"; ScriptManager.RegisterStartupScript(this, this.GetType(), "Report", script, false); } } // ... If coming from left menu if ((string)Request.QueryString["source_page"] == "lm") { // Store search parameters ViewState["current"] = "yes"; ViewState["others"] = Request.QueryString["others"]; if (Request.QueryString["others"] == "yes") { ViewState["employee_id"] = int.Parse((string)Request.QueryString["employee_id"]); } else { EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); } PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); ViewState["period_id"] = payPeriodGateway.GetPayPeriodId(DateTime.Now); } // ... If coming from timesheet_all.aspx if ((string)Request.QueryString["source_page"] == "timesheet_all.aspx") { // Store search parameters PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); int currentPeriod = payPeriodGateway.GetCurrent(); if (currentPeriod == int.Parse((string)Request.QueryString["period_id"])) { ViewState["current"] = "yes"; } else { ViewState["current"] = "no"; } ViewState["others"] = Request.QueryString["others"]; ViewState["employee_id"] = int.Parse((string)Request.QueryString["employee_id"]); ViewState["period_id"] = int.Parse((string)Request.QueryString["period_id"]); } // ... If coming from timesheet.aspx if ((string)Request.QueryString["source_page"] == "timesheet.aspx") { // Store search parameters PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); int currentPeriod = payPeriodGateway.GetCurrent(); if (currentPeriod == int.Parse((string)Request.QueryString["period_id"])) { ViewState["current"] = "yes"; } else { ViewState["current"] = "no"; } ViewState["others"] = Request.QueryString["others"]; ViewState["employee_id"] = int.Parse((string)Request.QueryString["employee_id"]); ViewState["period_id"] = int.Parse((string)Request.QueryString["period_id"]); if (Session["OpenTimesheetMissing"] == null) { if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_AUTOREPORT"])) { string script = "<script language='javascript'>"; script += "window.open('./../projecttime/timesheet_missing.aspx?source_page=timesheet.aspx', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=550, height=420')"; script += "</script>"; ScriptManager.RegisterStartupScript(this, this.GetType(), "Report", script, false); } } } // ... If coming from timesheet_summary.aspx, timesheet_add.aspx, timesheet_edit.aspx, timesheet_delete.aspx or timesheet_state.aspx if (((string)Request.QueryString["source_page"] == "timesheet_summary.aspx") || ((string)Request.QueryString["source_page"] == "timesheet_add.aspx") || ((string)Request.QueryString["source_page"] == "timesheet_edit.aspx") || ((string)Request.QueryString["source_page"] == "timesheet_delete.aspx") || ((string)Request.QueryString["source_page"] == "timesheet_state.aspx")) { // Store search parameters PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); int currentPeriod = payPeriodGateway.GetCurrent(); if (currentPeriod == int.Parse((string)Request.QueryString["period_id"])) { ViewState["current"] = "yes"; } else { ViewState["current"] = "no"; } ViewState["others"] = Request.QueryString["others"]; ViewState["employee_id"] = int.Parse((string)Request.QueryString["employee_id"]); ViewState["period_id"] = int.Parse((string)Request.QueryString["period_id"]); } // ... If coming from timesheet_approve.aspx if ((string)Request.QueryString["source_page"] == "timesheet_approve.aspx") { // Store search parameters PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); int currentPeriod = payPeriodGateway.GetCurrent(); EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); ViewState["current"] = "yes"; ViewState["others"] = "yes"; ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); ViewState["period_id"] = currentPeriod; } // Access control // ... Employees EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet()); if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { employeeListGateway.LoadByRequestProjectTimeWithoutEmployeeId(1, (int)ViewState["employee_id"]); } else { employeeListGateway.LoadByRequestProjectTime(1); } DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor"); ddlOthersFor.DataSource = employeeListGateway.Table; ddlOthersFor.DataValueField = "EmployeeID"; ddlOthersFor.DataTextField = "FullName"; ddlOthersFor.DataBind(); // ... Title EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); if ((int)ViewState["employee_id"] != 0) { employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]); if ((string)ViewState["others"] == "no") { if ((Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) && (employeeGateway.GetRequestProjectTime((int)ViewState["employee_id"]))) { if ((string)ViewState["current"] == "yes") { lblTitle.Text = "Current Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]); } else { PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); payPeriodGateway.LoadByPayPeriodId((int)ViewState["period_id"]); lblTitle.Text = "Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]) + " From " + payPeriodGateway.GetStartDate((int)ViewState["period_id"]).ToShortDateString() + " To " + payPeriodGateway.GetEndDate((int)ViewState["period_id"]).ToShortDateString(); } } else { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } else { EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); int employeeIdNow = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); if ((int)ViewState["employee_id"] == employeeIdNow) { if (((Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) && (employeeGateway.GetRequestProjectTime((int)ViewState["employee_id"])))) { if ((string)ViewState["current"] == "yes") { lblTitle.Text = "Current Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]); } else { PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); payPeriodGateway.LoadByPayPeriodId((int)ViewState["period_id"]); lblTitle.Text = "Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]) + " From " + payPeriodGateway.GetStartDate((int)ViewState["period_id"]).ToShortDateString() + " To " + payPeriodGateway.GetEndDate((int)ViewState["period_id"]).ToShortDateString(); } } else { if (ddlOthersFor.Items.Count > 0) { Session["ddlOthersForSelectedValue"] = ddlOthersFor.SelectedValue; Response.Redirect("./timesheet.aspx?source_page=timesheet.aspx&others=yes&employee_id=" + ddlOthersFor.SelectedValue + "&period_id=" + ((int)ViewState["period_id"]).ToString()); } else { Response.Redirect("./../../error_page.aspx?error=" + "No team members with 'Request Timesheet' property are defined in the system. Contact your system administrator for further assistance."); } } } else { if ((string)ViewState["current"] == "yes") { lblTitle.Text = "Current Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]); } else { PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); payPeriodGateway.LoadByPayPeriodId((int)ViewState["period_id"]); lblTitle.Text = "Timesheet For " + employeeGateway.GetFullName((int)ViewState["employee_id"]) + " From " + payPeriodGateway.GetStartDate((int)ViewState["period_id"]).ToShortDateString() + " To " + payPeriodGateway.GetEndDate((int)ViewState["period_id"]).ToShortDateString(); } } } } else { Response.Redirect("./../../error_page.aspx?error=" + "You cannot use the Labour Hours subsystem since you are not registered as a team member in LFS Live. Please contact your system administrator for further assistance."); ; } // Load data timesheetNavigatorTDS = this.SubmitSearch(); Session["timesheetNavigatorTDS"] = timesheetNavigatorTDS; timesheetNavigator = timesheetNavigatorTDS.LFS_PROJECT_TIME; Session["timesheetNavigator"] = timesheetNavigator; // Set Total project time TimesheetNavigator timesheetNavigatorForTotal = new TimesheetNavigator(timesheetNavigatorTDS); tbxTotalCost.Text = timesheetNavigatorForTotal.GetTotalProjectTime().ToString(); } else { // Restore dataset timesheetNavigatorTDS = (TimesheetNavigatorTDS)Session["timesheetNavigatorTDS"]; timesheetNavigator = timesheetNavigatorTDS.LFS_PROJECT_TIME; // Store datase Session["timesheetNavigator"] = timesheetNavigator; } }
public void SendMailFleetManager() { // Get mail information string mailTo = ""; string nameTo = ""; string subject = "Service request has been modified."; string body = ""; // MailtTo, nameTo int companyLevelId = Int32.Parse(hdfCompanyLevel.Value); Employee employees = new Employee(); employees.LoadByFleetManager(companyLevelId); mailTo = employees.GetAllFleetManagersEMails(); nameTo = employees.GetAllFleetManagersNames(); // Mails body body = body + "\nHi " + nameTo + ",\n\nThe following service request has been modified. \n"; body = body + "\n Service Number: " + hdfServiceNumber.Value; body = body + "\n Service Description: " + hdfServiceDescription.Value; // ... Assignation of work // ... ... Deadline date if (hdfDeadlineDate.Value != "") { DateTime deadlineDate = DateTime.Parse(hdfDeadlineDate.Value); string deadlineDateText = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString(); body = body + "\n Deadline date: " + deadlineDateText; } else { body = body + "\n Deadline date: "; } // ... ... Assigned Personal if (hdfAssignToTeamMember.Value == "True") { int employeeId = Int32.Parse(hdfTeamMemberId.Value); EmployeeGateway employeesGateway = new EmployeeGateway(); employeesGateway.LoadForMailsByEmployeeId(employeeId); string assignedTo = ""; if (employeesGateway.Table.Rows.Count > 0) { // Assigned TeamMember assignedTo = employeesGateway.GetFirstName(employeeId) + " " + employeesGateway.GetLastName(employeeId); } body = body + "\n Assigned Team Member: " + assignedTo; } // ... ... Assigned third party vendor if (hdfAssignToThirdPartyVendor.Value == "True") { body = body + "\n Assigned Third Party Vendor: " + hdfThirdPartyVendor.Value; } int registeredByLoginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByLoginId(registeredByLoginId); int registeredByEmployeeId = employeeGateway.GetEmployeIdByLoginId(registeredByLoginId); // ... ... Assigned myself if (hdfAssignToMyself.Value == "True") { if (employeeGateway.Table.Rows.Count > 0) { body = body + "\n Assigned to myself: " + employeeGateway.GetFirstName(registeredByEmployeeId) + " " + employeeGateway.GetLastName(registeredByEmployeeId); } } // Registered by if (employeeGateway.Table.Rows.Count > 0) { body = body + "\n Registered By: " + employeeGateway.GetFirstName(registeredByEmployeeId) + " " + employeeGateway.GetLastName(registeredByEmployeeId); } // Service State body = body + "\n\n Service State: " + hdfServiceState.Value; //Send Mail SendMail(mailTo, subject, body); }
protected void ddlActionsNew_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = grdToDoList.FooterRow; DropDownList action = ((DropDownList)row.FindControl("ddlActionsNew")); switch (action.SelectedValue) { case "Assign To User": ((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Visible = true; ((CustomValidator)row.FindControl("cvTeamMemberNew")).Visible = true; ((TextBox)row.FindControl("tbxUserNew")).Visible = false; ((Label)row.FindControl("lblUserNew")).Text = "Assign To"; break; case "Add Comment": int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); ((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Visible = false; ((CustomValidator)row.FindControl("cvTeamMemberNew")).Visible = false; ((TextBox)row.FindControl("tbxUserNew")).Visible = true; ((Label)row.FindControl("lblUserNew")).Text = "Comment Added By"; EmployeeGateway employeeGatewayForUser = new EmployeeGateway(); employeeGatewayForUser.LoadByEmployeeId(employeeId); ((TextBox)row.FindControl("tbxUserNew")).Text = employeeGatewayForUser.GetFullName(employeeId); break; case "Complete": ((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Visible = false; ((CustomValidator)row.FindControl("cvTeamMemberNew")).Visible = false; ((TextBox)row.FindControl("tbxUserNew")).Visible = true; ((Label)row.FindControl("lblUserNew")).Text = "To Do Completed By"; EmployeeGateway employeeGatewayForUserComplete = new EmployeeGateway(); employeeGatewayForUserComplete.LoadByEmployeeId(Int32.Parse(hdfAssignedUser.Value)); ((TextBox)row.FindControl("tbxUserNew")).Text = employeeGatewayForUserComplete.GetFullName(Int32.Parse(hdfAssignedUser.Value)); break; case "Put On Hold": int loginIdOnHold = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGatewayOnHold = new EmployeeGateway(); int employeeIdOnHold = employeeGatewayOnHold.GetEmployeIdByLoginId(loginIdOnHold); ((DropDownList)row.FindControl("ddlAssignToTeamMemberNew")).Visible = false; ((CustomValidator)row.FindControl("cvTeamMemberNew")).Visible = false; ((TextBox)row.FindControl("tbxUserNew")).Visible = true; ((Label)row.FindControl("lblUserNew")).Text = "On Hold By"; EmployeeGateway employeeGatewayForOnHold = new EmployeeGateway(); employeeGatewayForOnHold.LoadByEmployeeId(employeeIdOnHold); ((TextBox)row.FindControl("tbxUserNew")).Text = employeeGatewayForOnHold.GetFullName(employeeIdOnHold); break; } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Tag page // ... 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"; } // Security check if (hdfIsVacationManager.Value == "False") { //if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_VACATIONS_EDIT"]))) //{ 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["vacation_id"] == null) && ((string)Request.QueryString["request_id"] == null) && ((string)Request.QueryString["date_to_show"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in vacations_edit.aspx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); hdfVacationId.Value = (string)Request.QueryString["vacation_id"]; hdfRequestId.Value = (string)Request.QueryString["request_id"]; int requestId = Int32.Parse(hdfRequestId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); ViewState["date_to_show"] = (string)Request.QueryString["date_to_show"]; DateTime dateToShow = DateTime.Parse((string)Request.QueryString["date_to_show"]); // 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(); ddlVacationsFor.SelectedValue = Session["ddlVacationsForSelectedValue"].ToString(); // Load Data vacationsInformationTDS = new VacationsInformationTDS(); vacationDaysInformation = new VacationsInformationTDS.DaysInformationDataTable(); VacationsInformationDaysInformationGateway vacationsInformationDaysInformationGateway = new VacationsInformationDaysInformationGateway(vacationsInformationTDS); vacationsInformationDaysInformationGateway.LoadByRequestId(requestId, companyId); VacationsInformationRequestsInformationGateway vacationsInformationRequestsInformationGateway = new VacationsInformationRequestsInformationGateway(vacationsInformationTDS); vacationsInformationRequestsInformationGateway.LoadByRequestId(requestId, companyId); hdfEmployeeId.Value = vacationsInformationRequestsInformationGateway.GetEmployeeID(requestId).ToString(); int employeeId = Int32.Parse(hdfEmployeeId.Value); VacationsInformationBasicInformationGateway vacationsInformationBasicInformationGateway = new VacationsInformationBasicInformationGateway(vacationsInformationTDS); vacationsInformationBasicInformationGateway.LoadByEmployeeIdYear(employeeId, dateToShow.Year, companyId); Session["vacationsInformationTDS"] = vacationsInformationTDS; Session["vacationDaysInformation"] = vacationsInformationTDS.DaysInformation; LoadData(employeeId, dateToShow.Year, requestId); Page.DataBind(); } else { vacationsInformationTDS = (VacationsInformationTDS)Session["vacationsInformationTDS"]; vacationDaysInformation = (VacationsInformationTDS.DaysInformationDataTable)Session["vacationDaysInformation"]; } }
protected void grdToDoList_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("activityDataEdit"); if (Page.IsValid) { int toDoId = (int)e.Keys["ToDoID"]; int refId = (int)e.Keys["RefID"]; int employeeId = 0; int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(); string comment = ((TextBox)grdToDoList.Rows[e.RowIndex].Cells[4].FindControl("tbxCommentsEdit")).Text; string employeeFullName = ""; string type_ = ((Label)grdToDoList.Rows[e.RowIndex].Cells[4].FindControl("lblType")).Text; switch (type_) { case "AssignUser": employeeId = Int32.Parse(((DropDownList)grdToDoList.Rows[e.RowIndex].Cells[4].FindControl("ddlAssignToTeamMemberEdit")).SelectedValue); employeeGateway.LoadByEmployeeId(employeeId); employeeFullName = employeeGateway.GetFullName(employeeId); break; case "AddComment": employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); EmployeeGateway employeeGatewayForComment = new EmployeeGateway(); employeeGatewayForComment.LoadByEmployeeId(employeeId); employeeFullName = employeeGatewayForComment.GetFullName(employeeId); break; case "CloseToDo": employeeId = Int32.Parse(hdfAssignedUser.Value); employeeGateway.LoadByEmployeeId(employeeId); employeeFullName = employeeGateway.GetFullName(employeeId); hdfCompleted.Value = "True"; break; case "OnHoldToDo": employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); EmployeeGateway employeeGatewayForOnHold = new EmployeeGateway(); employeeGatewayForOnHold.LoadByEmployeeId(employeeId); employeeFullName = employeeGatewayForOnHold.GetFullName(employeeId); break; } ToDoListInformationActivityInformation model = new ToDoListInformationActivityInformation(toDoListInformationTDS); model.Update(toDoId, refId, employeeId, employeeFullName, comment); // Store dataset Session["toDoListInformationTDS"] = toDoListInformationTDS; } else { e.Cancel = true; } }
protected void Page_PreRender(object sender, EventArgs e) { // Set active toolbar mForm6 master = (mForm6)this.Master; master.ActiveToolbar = "LabourHours"; // ... Labour Hours Mode if ((string)ViewState["LHMode"] == "Partial") { // Access control // ... Employees EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet()); employeeListGateway.LoadByRequestProjectTime(1); DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor"); ddlOthersFor.DataSource = employeeListGateway.Table; ddlOthersFor.DataValueField = "EmployeeID"; ddlOthersFor.DataTextField = "FullName"; ddlOthersFor.DataBind(); tkrpbLeftMenuMyTimesheets.Visible = false; tkrpbLeftMenuOthersTimesheets.Items[0].Text = "Timesheets"; tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; } else { EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); int employeeIdForMenu = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); employeeGateway1.LoadByEmployeeId(employeeIdForMenu); if (!employeeGateway1.GetApproveTimesheets(employeeIdForMenu)) { tkrpbLeftMenuTools.Items[0].Items[1].Visible = false; // Timesheets To Approve } if (Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { tkrpbLeftMenuOthersTimesheets.Visible = true; tkrpbLeftMenuTools.Items[0].Items[0].Visible = true; // Add Team Project Time tkrpbLeftMenuTools.Items[0].Items[2].Visible = true; // Missing Project Time // Access control // ... Employees EmployeeListGateway employeeListGateway = new EmployeeListGateway(new DataSet()); if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { employeeListGateway.LoadByRequestProjectTimeWithoutEmployeeId(1, employeeIdForMenu); } else { employeeListGateway.LoadByRequestProjectTime(1); } DropDownList ddlOthersFor = (DropDownList)tkrpbLeftMenuOthersTimesheets.FindItemByValue("nbOthersTimesheetsDDL").FindControl("ddlOthersFor"); ddlOthersFor.DataSource = employeeListGateway.Table; ddlOthersFor.DataValueField = "EmployeeID"; ddlOthersFor.DataTextField = "FullName"; ddlOthersFor.DataBind(); try { ddlOthersFor.SelectedValue = Session["ddlOthersForSelectedValue"].ToString(); } catch { } } else { tkrpbLeftMenuOthersTimesheets.Visible = false; if (!employeeGateway1.GetApproveTimesheets(employeeIdForMenu)) { tkrpbLeftMenuTools.Visible = false; } tkrpbLeftMenuTools.Items[0].Items[0].Visible = false; // Add Team Project Time tkrpbLeftMenuTools.Items[0].Items[2].Visible = false; // Missing Project Time } if (!((Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"]) || Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) && (employeeGateway1.GetRequestProjectTime(employeeIdForMenu)))) { tkrpbLeftMenuMyTimesheets.Visible = false; tkrpbLeftMenuOthersTimesheets.Items[0].Text = "Timesheets"; } if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_REPORTS"])) { tkrpbLeftMenuReports.Visible = false; } } } }
private bool ValidateToDoFooter() { bool validFooter = false; int employeeId = 0; string comment = ((TextBox)grdToDoList.FooterRow.FindControl("tbxCommentsNew")).Text; if (hdfAction.Value == "Assign To User") { employeeId = Int32.Parse(((DropDownList)grdToDoList.FooterRow.FindControl("ddlAssignToTeamMemberNew")).SelectedValue); if (employeeId != 0) { validFooter = true; } } if (hdfAction.Value == "Add Comment") { int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); if ((employeeId != 0) && (comment != "")) { validFooter = true; } } if (hdfAction.Value == "Complete") { employeeId = Int32.Parse(hdfAssignedUser.Value); if ((employeeId != 0) && (comment != "")) { validFooter = true; } } if (hdfAction.Value == "Put On Hold") { int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); if ((employeeId != 0) && (comment != "")) { validFooter = true; } } return validFooter; }
private void PostPageChanges() { EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); projectTimeTDSToSave = new ProjectTimeTDS(); LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime projectTime = new LiquiForce.LFSLive.BL.LabourHours.ProjectTime.ProjectTime(projectTimeTDS); projectTime.Insert(projectTimeTDSToSave, employeeId); }
private void LoadData() { int companyId = Int32.Parse(hdfCompanyId.Value); int companyLevelId = Int32.Parse(ddlWorkingLocation.SelectedValue); dashboardMyServiceRequestsTDS = (DashboardTDS)HttpContext.Current.Session["dashboardMyServiceRequestsTDS"]; DashboardMyServiceRequests model = new DashboardMyServiceRequests(dashboardMyServiceRequestsTDS); // ... Load int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); if (companyLevelId == 0) { if (ddlType.SelectedValue != "(All)") { model.LoadMyServicesByAssignTeamMemberIDUnitType(employeeId, companyId, ddlType.SelectedValue); } else { model.LoadMyServicesByAssignTeamMemberID(employeeId, companyId); } } else { if (ddlType.SelectedValue != "(All)") { model.LoadMyServicesByAssignTeamMemberIDCompanyLevelIdUnitType(employeeId, companyId, companyLevelId, ddlType.SelectedValue); } else { model.LoadMyServicesByAssignTeamMemberIDCompanyLevelId(employeeId, companyId, companyLevelId); } } model.UpdateForDashboard(companyId); HttpContext.Current.Session.Add("dashboardMyServiceRequestsTDS", dashboardMyServiceRequestsTDS); Page.DataBind(); }
private void UpdateTimesheet() { int employeeId = Int32.Parse(hdfEmployeeID.Value); int periodId = Int32.Parse(hdfPeriodId.Value); TimesheetTDS timesheetTDS = new TimesheetTDS(); TimesheetGateway timesheetGateway = new TimesheetGateway(timesheetTDS); timesheetGateway.LoadByEmployeeIdPayPeriodId(employeeId, periodId); LiquiForce.LFSLive.BL.LabourHours.Timesheet.Timesheet timesheet = new LiquiForce.LFSLive.BL.LabourHours.Timesheet.Timesheet(timesheetTDS); // Approve timesheet if (ViewState["timesheetState"].ToString() == "Approved") { EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); ViewState["approved_by_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); timesheet.Approve(employeeId, periodId, (int)ViewState["approved_by_id"]); } // Reject timesheet if (ViewState["timesheetState"].ToString() == "Rejected") { timesheet.Reject(employeeId, periodId); } // Submit timesheet if (ViewState["timesheetState"].ToString() == "Submitted") { timesheet.Submit(employeeId, periodId); } try { timesheetGateway.Update2(); timesheetTDS.AcceptChanges(); } catch (Exception ex) { string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
// //////////////////////////////////////////////////////////////////////// // 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) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_approve.aspx"); } // Security check EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); hdfCurrentEmployeeId.Value = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])).ToString(); employeeGateway1.LoadByEmployeeId(employeeId); if (!employeeGateway1.GetApproveTimesheets(employeeId)) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } // Tag page Session.Remove("projectTimeApproveDummy"); // Initialize variables lblError.Visible = false; // ... Initialize viewstate variables System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader(); ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString(); // Labour Hours Mode check if ((string)ViewState["LHMode"] == "Partial") { Response.Redirect("./../../error_page.aspx?error=" + "The system is on partial mode. Contact your system administrator."); } ViewState["others"] = Request.QueryString["others"]; PayPeriodGateway payPeriodGateway = new PayPeriodGateway(new DataSet()); ViewState["period_id"] = payPeriodGateway.GetPayPeriodId(DateTime.Now); // Load data // ... Loading employees accordingly to the admins country. EmployeeList employeeList = new EmployeeList(new DataSet()); string employeeType = employeeGateway1.GetType(employeeId); odsClient.SelectParameters.RemoveAt(2); if (employeeType.Contains("CA")) { employeeList.LoadByRequestProjectTimeEmployeeTypeEmployeeIdApproveManagerAndAddItem(1, "CA", -1, "(All)", employeeId); odsClient.SelectParameters.Add("countryId", "1"); } else { if (employeeType.Contains("US")) { employeeList.LoadByRequestProjectTimeEmployeeTypeEmployeeIdApproveManagerAndAddItem(1, "US", -1, "(All)", employeeId); odsClient.SelectParameters.Add("countryId", "2"); } else { employeeList.LoadByRequestProjectTimeEmployeeTypeEmployeeIdApproveManagerAndAddItem(1, "SOTA", -1, "(All)", employeeId); odsClient.SelectParameters.Add("countryId", "-1"); } } odsClient.Select(); ddlClient.SelectedIndex = 0; upnlClient.Update(); ddlTeamMember.DataSource = employeeList.Table; ddlTeamMember.DataValueField = "EmployeeID"; ddlTeamMember.DataTextField = "FullName"; ddlTeamMember.DataBind(); odsProject.SelectParameters.RemoveAt(2); odsProject.SelectParameters.Add("clientId", "-1"); odsProject.Select(); ddlProject.DataBind(); ddlProject.SelectedIndex = 0; upnlProject.Update(); projectTimeApproveTDS = this.SubmitSearch(); // Store Datasets Session["projectTimeApproveTDS"] = projectTimeApproveTDS; projectTimeApprove = projectTimeApproveTDS.ProjectTimeApprove; Session["projectTimeApprove"] = projectTimeApproveTDS.ProjectTimeApprove; // If coming from // ... timesheet_edit.aspx, timesheet_summary.aspx or timesheet_delete.aspx if ((Request.QueryString["source_page"] == "timesheet_edit.aspx") || (Request.QueryString["source_page"] == "timesheet_summary.aspx") || (Request.QueryString["source_page"] == "timesheet_delete.aspx")) { // ... restore top values RestoreNavigatorState(); // ... filter grid information //SetFilterByCountryIdClientIdProjectId(); //SetFilterByEmployeeIdDate(); SetFilterByClientIdProjectIdEmployeeIdDate(); } ViewState["filter_expression"] = "Deleted = 0"; SetFocus(); } else { // Restore dataset projectTimeApproveTDS = (ProjectTimeApproveTDS)Session["projectTimeApproveTDS"]; projectTimeApprove = projectTimeApproveTDS.ProjectTimeApprove; Session["projectTimeApprove"] = projectTimeApproveTDS.ProjectTimeApprove; } }
// //////////////////////////////////////////////////////////////////////// // 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_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."); } } } } } } } } // Validate query string if (((string)Request.QueryString["source_page"] == null) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_all.aspx"); } // Tag page Session.Remove("timesheetAllDummy"); // Initialize variables lblError.Visible = false; ViewState["others"] = Request.QueryString["others"]; if ((string)ViewState["others"] == "yes") { ViewState["employee_id"] = int.Parse(Request.QueryString["employee_id"]); } else { EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); ViewState["employee_id"] = employeeGateway1.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); } System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader(); ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString(); // Prepare initial data for client // ... Title if ((string)ViewState["others"] == "no") { lblTitle.Text = "All My Timesheets"; } else { EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]); lblTitle.Text = "All Timesheets For " + employeeGateway.GetFullName((int)ViewState["employee_id"]); } // Load data timesheetAllTDS = this.SubmitSearch(); Session["timesheetAllTDS"] = timesheetAllTDS; timesheetAll = timesheetAllTDS.TIMESHEET_ALL; Session["timesheetAll"] = timesheetAll; } else { // Restore dataset timesheetAllTDS = (TimesheetAllTDS)Session["timesheetAllTDS"]; timesheetAll = timesheetAllTDS.TIMESHEET_ALL; Session["timesheetAll"] = timesheetAll; } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_EDIT"]))) { 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 wucSRUnassigned.ascx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); hdfEmployeeId.Value = employeeGateway.GetEmployeIdByLoginId(loginId).ToString(); // Prepare initial data HttpContext.Current.Session.Remove("dashboardUnassignedServiceRequestsDummy"); ArrayList arrayListWidgetData = (ArrayList)HttpContext.Current.Session["unassignedSRWidget"]; // If coming from // ... Out if (Request.QueryString["source_page"] == "out") { CompanyLevelsManagersGateway companyLevelsManagersGateway = new CompanyLevelsManagersGateway(); // ... For Grid int companyId = Int32.Parse(hdfCompanyId.Value); int employeeId = Convert.ToInt32(hdfEmployeeId.Value); int companyLevelId = companyLevelsManagersGateway.GetCompanyLevelId(employeeId, companyId); // ... For ddl working location companyLevelsForSRUnassignedTDS = new CompanyLevelsTDS(); CompanyLevel companyLevel = new CompanyLevel(companyLevelsForSRUnassignedTDS); companyLevel.LoadNodes(companyId); GetNodeForCompanyLevel(1); ddlWorkingLocation.Items.Insert(0, new ListItem("(All)", "0")); if (HttpContext.Current.Session["unassignedSRWidget"] != null) { ddlWorkingLocation.SelectedIndex = Convert.ToInt32(arrayListWidgetData[0].ToString()); ddlType.SelectedIndex = Convert.ToInt32(arrayListWidgetData[1].ToString()); companyLevelId = Convert.ToInt32(ddlWorkingLocation.SelectedValue); } else { ddlWorkingLocation.SelectedValue = companyLevelId.ToString(); } dashboardUnassignedServiceRequestsTDS = new DashboardTDS(); DashboardUnassignedServiceRequests model = new DashboardUnassignedServiceRequests(dashboardUnassignedServiceRequestsTDS); // ... Load for admin if (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_ADMIN"])) { if (companyLevelId == 0) { if (ddlType.SelectedValue != "(All)") { model.LoadAllUnassignedServicesByUnitType(companyId, ddlType.SelectedValue); } else { model.LoadAllUnassignedServices(companyId); } } else { if (ddlType.SelectedValue != "(All)") { model.LoadAllUnassignedServicesByCompanyLevelIdUnitType(companyId, companyLevelId, ddlType.SelectedValue); } else { model.LoadAllUnassignedServicesByCompanyLevelId(companyId, companyLevelId); } } } else { if (companyLevelId == 0) { if (ddlType.SelectedValue != "(All)") { model.LoadAllUnassignedServicesByAssignTeamMemberIDUnitType(employeeId, companyId, ddlType.SelectedValue); } else { // ... Load for assigned employee model.LoadAllUnassignedServicesByAssignTeamMemberID(employeeId, companyId); } } else { if (ddlType.SelectedValue != "(All)") { model.LoadAllUnassignedServicesByAssignTeamMemberIDCompanyLevelIdUnitType(employeeId, companyId, companyLevelId, ddlType.SelectedValue); } else { model.LoadAllUnassignedServicesByAssignTeamMemberIDCompanyLevelId(employeeId, companyId, companyLevelId); } } } model.UpdateForDashboard(companyId); // ... Store datasets HttpContext.Current.Session.Add("dashboardUnassignedServiceRequestsTDS", dashboardUnassignedServiceRequestsTDS); HttpContext.Current.Session.Add("companyLevelsForSRUnassignedTDS", companyLevelsForSRUnassignedTDS); } } else { // Prepare initial data HttpContext.Current.Session.Remove("dashboardUnassignedServiceRequestsDummy"); // Restore datasets dashboardUnassignedServiceRequestsTDS = (DashboardTDS)HttpContext.Current.Session["dashboardUnassignedServiceRequestsTDS"]; companyLevelsForSRUnassignedTDS = (CompanyLevelsTDS)HttpContext.Current.Session["companyLevelsForSRUnassignedTDS"]; } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_EDIT"]))) { 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 wucMyToDoList.ascx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); // Prepare initial data HttpContext.Current.Session.Remove("dashboardMyToDoListDataTableDummy"); HttpContext.Current.Session.Remove("dashboardMyToDoListOnHoldDataTableDummy"); ArrayList arrayListWidgetData = (ArrayList)HttpContext.Current.Session["myToDoListWidget"]; ArrayList arrayListWidgetDataOnHold = (ArrayList)HttpContext.Current.Session["myToDoListOnHoldWidget"]; // If coming from // ... Out if (Request.QueryString["source_page"] == "out") { int loginId = Convert.ToInt32(Session["loginID"]); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(loginId); string state = "%"; if (ddlStateMyToDo.SelectedValue != "(All)") state = ddlStateMyToDo.SelectedValue; // ... For Grid int companyId = Int32.Parse(hdfCompanyId.Value); dashboardMyToDoListTDS = new DashboardTDS(); DashboardMyToDoList model = new DashboardMyToDoList(dashboardMyToDoListTDS); DashboardMyToDoListOnHold modelOnHold = new DashboardMyToDoListOnHold(dashboardMyToDoListTDS); if (HttpContext.Current.Session["myToDoListWidget"] != null) { ddlStateMyToDo.SelectedIndex = Convert.ToInt32(arrayListWidgetData[1].ToString()); if (ddlStateMyToDo.SelectedValue != "(All)") state = ddlStateMyToDo.SelectedValue; } // ... Load to do list // ... ...Load for admin if (!Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_TODOLIST_ADMIN"])) { // ... Load for assigned employee model.LoadMyCurrentToDoListByCreatedByIdState(employeeId, state, companyId); modelOnHold.LoadMyCurrentToDoListOnHoldByCreatedById(employeeId, companyId); } else { // ... ... Loads all (current) model.LoadCurrentToDoListByState(state, companyId); modelOnHold.LoadCurrentToDoListOnHold(companyId); } // ... Store datasets HttpContext.Current.Session.Add("dashboardMyToDoListTDS", dashboardMyToDoListTDS); } } else { // Prepare initial data HttpContext.Current.Session.Remove("dashboardMyToDoListDataTableDummy"); HttpContext.Current.Session.Remove("dashboardMyToDoListOnHoldDataTableDummy"); // Restore dataset dashboardMyToDoListTDS = (DashboardTDS)HttpContext.Current.Session["dashboardMyToDoListTDS"]; } }