public void SendMailForCompletedToDo() { // Get mail information string mailTo = ""; string nameTo = ""; string subject = "A to do list was completed."; string body = ""; // MailtTo, nameTo int createdBy = Int32.Parse(hdfCreatedById.Value); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(createdBy); mailTo = employeeGateway.GetEMail(createdBy); nameTo = employeeGateway.GetFullName(createdBy); // Mails body body = body + "\nHi " + nameTo + ",\n\nThe following to do list was completed. \n"; body = body + "\n Subject: "+ lblTitleSubjectName.Text; body = body + "\n Created By: " + tbxCreatedBy.Text; body = body + "\n Creation Date: " + tbxCreationDate.Text; body = body + "\n Assigned User: "******"\n Due Date: " + tbxDueDate.Text; body = body + "\n Unit / Equipment: " + tbxUnit.Text; //Send Mail SendMail(mailTo, subject, body); }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_DELETE"]))) { 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)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in employees_delete.aspx"); } // Tag page hdfCompanyId.Value = Session["companyID"].ToString(); hdfCurrentEmployeeId.Value = Request.QueryString["employee_id"]; hdfActiveTab.Value = Request.QueryString["active_tab"]; // ... for team member title int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value); EmployeeInformationTDS employeeInformationTDS = new EmployeeInformationTDS(); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(employeeId); lblTitleTeamMember.Text = "Team Member: " + employeeGateway.GetFullName(employeeId); // If coming from // ... employees_navigator2.aspx if (Request.QueryString["source_page"] == "employees_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; } // ... employees_summary.aspx if (Request.QueryString["source_page"] == "employees_summary.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; } // Restore dataset employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"]; } else { // Restore dataset employeeNavigatorTDS = (EmployeeNavigatorTDS)Session["employeeNavigatorTDS"]; } }
public void SendMailForNewTicket() { int companyId = Int32.Parse(hdfCompanyId.Value); // Get mail information string mailTo = ""; string nameTo = ""; string subject = "A support ticket was created."; string body = ""; // MailtTo, nameTo int createdBy = Int32.Parse(hdfTeamMemberId.Value); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(createdBy); mailTo = employeeGateway.GetEMail(createdBy); nameTo = employeeGateway.GetFullName(createdBy); // Mails body body = body + "\nHi " + nameTo + ",\n\nThe following support ticket was created. \n"; body = body + "\n Subject: " + hdfSubject.Value; body = body + "\n Comment: " + hdfComments.Value; body = body + "\n Created By: " + employeeGateway.GetFullName(createdBy); if (hdfDueDate.Value != "") { DateTime dueDate = DateTime.Parse(hdfDueDate.Value); string dueDateText = dueDate.Month.ToString() + "/" + dueDate.Day.ToString() + "/" + dueDate.Year.ToString(); body = body + "\n Due Date: " + dueDateText; } int categoryId = Int32.Parse(hdfCategoriesSelected.Value); SupportTicketCategoryGateway supportTicketCategoryGateway = new SupportTicketCategoryGateway(); supportTicketCategoryGateway.LoadByCategoryId(categoryId, companyId); body = body + "\n Category: " + supportTicketCategoryGateway.GetName(categoryId); //int assignTeamMemberId = Int32.Parse(hdfTeamMemberId.Value); //EmployeeGateway employeeGatewayForAssignment = new EmployeeGateway(); //employeeGatewayForAssignment.LoadByEmployeeId(assignTeamMemberId); //body = body + "\n Assigned team member: " + employeeGatewayForAssignment.GetFullName(assignTeamMemberId) + "\n"; body = body + "\n Assigned team member: Anzovino Dan \n"; //Send Mail SendMail(mailTo, subject, body); }
// //////////////////////////////////////////////////////////////////////// // 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(); } }
protected void Page_PreRender(object sender, EventArgs e) { // Set active toolbar mForm6 master = (mForm6)this.Master; master.ActiveToolbar = "LabourHours"; EmployeeGateway employeeGateway1 = new EmployeeGateway(new DataSet()); int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value); employeeGateway1.LoadByEmployeeId(employeeId); 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; 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; } } }
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; } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Validate query string if (((string)Request.QueryString["source_page"] == null) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null) && ((string)Request.QueryString["period_id"] == null) && ((string)Request.QueryString["projecttime_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_summary.aspx"); } // Security check if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { if (Request.QueryString["others"] == "no") { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"])) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } } } else { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"])) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } } } } } } } // Initialize viewstate's variables ViewState["others"] = Request.QueryString["others"]; ViewState["employee_id"] = int.Parse(Request.QueryString["employee_id"]); ViewState["period_id"] = int.Parse(Request.QueryString["period_id"]); ViewState["projecttime_id"] = int.Parse(Request.QueryString["projecttime_id"]); System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader(); ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString(); // Get ProjectTime record projectTimeTDS = new ProjectTimeTDS(); ProjectTimeGateway projectTimeGateway = new ProjectTimeGateway(projectTimeTDS); projectTimeGateway.LoadByProjectTimeId((int)ViewState["projecttime_id"]); // Store datasets Session["projectTimeTDS"] = projectTimeTDS; // Databind tbxDate.DataBind(); tbxWorkingDetails.DataBind(); tbxStartTime.DataBind(); tbxEndTime.DataBind(); tbxLunch.DataBind(); tbxComments.DataBind(); tbxState.DataBind(); // Prepare initial data for client StoreNavigatorState(); EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); employeeGateway.LoadByEmployeeId((int)ViewState["employee_id"]); tbxEmployee.Text = employeeGateway.GetFullName((int)ViewState["employee_id"]); int companyId = Int32.Parse(Session["companyID"].ToString()); CompaniesGateway companiesGateway = new CompaniesGateway(new DataSet()); companiesGateway.LoadAllByCompaniesId(projectTimeGateway.GetCompaniesId((int)ViewState["projecttime_id"]), companyId); tbxClient.Text = companiesGateway.GetName(projectTimeGateway.GetCompaniesId((int)ViewState["projecttime_id"])); ProjectGateway projectGateway = new ProjectGateway(new DataSet()); projectGateway.LoadByProjectId(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])); tbxProject.Text = projectGateway.GetName(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])) + "(" + projectGateway.GetProjectNumber(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"])) + ")"; if (projectGateway.GetFairWageApplies(projectTimeGateway.GetProjectId((int)ViewState["projecttime_id"]))) { tbxJobClassType.Visible = true; lblJobClassType.Visible = true; tbxJobClassType.Text = projectTimeGateway.GetJobClassType((int)ViewState["projecttime_id"]); } else { tbxJobClassType.Visible = false; lblJobClassType.Visible = false; } if (projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"]).HasValue) { CountryGateway countryGateway = new CountryGateway(new DataSet()); countryGateway.LoadByCountryId((Int64)projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"])); tbxMealsCountry.Text = countryGateway.GetName((Int64)projectTimeGateway.GetMealsCountry((int)ViewState["projecttime_id"])); } //if (projectTimeGateway.GetMealsAllowance((int)ViewState["projecttime_id"]) > 0) //{ // cbxMealsAllowance.Checked = true; //} //if (projectTimeGateway.GetFairWage((int)ViewState["projecttime_id"])) //{ // cbxFairWage.Checked = true; //} if (projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]).HasValue) { UnitsGateway unitGateway = new UnitsGateway(new DataSet()); unitGateway.LoadByUnitId((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"]), Convert.ToInt32(Session["companyID"])); tbxUnit.Text = unitGateway.GetUnitCode((int)projectTimeGateway.GetUnitId((int)ViewState["projecttime_id"])); } if (projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]).HasValue) { UnitsGateway unitGateway = new UnitsGateway(new DataSet()); unitGateway.LoadByUnitId((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"]), Convert.ToInt32(Session["companyID"])); tbxTowed.Text = unitGateway.GetUnitCode((int)projectTimeGateway.GetTowedUnitId((int)ViewState["projecttime_id"])); } tbxTypeOfWork.Text = ""; if (projectTimeGateway.GetWork((int)ViewState["projecttime_id"]) != "") { tbxTypeOfWork.Text = projectTimeGateway.GetWork((int)ViewState["projecttime_id"]); } tbxFunction.Text = ""; if (projectTimeGateway.GetFunction((int)ViewState["projecttime_id"]) != "") { tbxFunction.Text = projectTimeGateway.GetFunction((int)ViewState["projecttime_id"]); } } else { // Restore datasets projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"]; } }
private void LoadData(int toDoId) { ToDoListInformationBasicInformationGateway toDoListInformationBasicInformationGateway = new ToDoListInformationBasicInformationGateway(toDoListInformationTDS); if (toDoListInformationBasicInformationGateway.Table.Rows.Count > 0) { // Load to do Details int companyId = Int32.Parse(hdfCompanyId.Value); int createdById = toDoListInformationBasicInformationGateway.GetCreatedByID(toDoId); hdfCreatedById.Value = createdById.ToString(); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(createdById); tbxCreatedBy.Text = employeeGateway.GetFullName(createdById); tbxCreationDate.Text = toDoListInformationBasicInformationGateway.GetCreationDate(toDoId).ToString(); tbxState.Text = toDoListInformationBasicInformationGateway.GetState(toDoId); if (toDoListInformationBasicInformationGateway.GetDueDate(toDoId).HasValue) { DateTime dueDateValue = (DateTime)toDoListInformationBasicInformationGateway.GetDueDate(toDoId); tbxDueDate.Text = dueDateValue.Month.ToString() + "/" + dueDateValue.Day.ToString() + "/" + dueDateValue.Year.ToString(); } int? unitId = toDoListInformationBasicInformationGateway.GetUnitID(toDoId); tbxUnit.Text = ""; if (unitId.HasValue) { UnitsGateway unitsGateway = new UnitsGateway(); unitsGateway.LoadByUnitId((int)unitId, companyId); tbxUnit.Text = unitsGateway.GetUnitCode((int)unitId) + " " + unitsGateway.GetDescription((int)unitId); } } }
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 Generate() { mReport1 master = (mReport1)this.Master; // Get Data string orderBy = ddlOrderBy.SelectedValue; string whereClause = "(P.Deleted = 0) AND (P.ProjectType = 'Ballpark') AND (P.ProjectState = 'Active')"; if (ddlCountry.SelectedValue != "(All)") { if (whereClause.Length > 0) whereClause += " AND "; whereClause += "(P.CountryID = " + ddlCountry.SelectedValue + ")"; } if (ddlClient.SelectedValue != "-1") { if (whereClause.Length > 0) whereClause += " AND "; whereClause += "(P.ClientID = " + ddlClient.SelectedValue + ")"; } if (ddlSalesman.SelectedValue != "-1") { if (whereClause.Length > 0) whereClause += " AND "; whereClause += "(P.SalesmanID = " + ddlSalesman.SelectedValue + ")"; } LiquiForce.LFSLive.BL.Projects.Projects.BallparkSummaryReport ballparkSummayReport = new LiquiForce.LFSLive.BL.Projects.Projects.BallparkSummaryReport(); ballparkSummayReport.LoadWhereOrderBy(whereClause, orderBy, ddlCurrency.SelectedValue, decimal.Parse(tbxExchangeRate.Text)); // ... set properties to master page master.Data = ballparkSummayReport.Data; master.Table = ballparkSummayReport.TableName; // Get report if (ballparkSummayReport.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.BallparkSummaryReport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.Projects.Projects.BallparkSummaryReportExport(); } // ... set parameters to report if (master.Format == "pdf") { // ... For report master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim())); master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.Trim() + "):"); master.SetParameter("Currency", ddlCurrency.SelectedValue.Trim()); // ... ... user int loginId = Convert.ToInt32(Session["loginID"]); int companyId = Convert.ToInt32(Session["companyID"]); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); // ... ... client if (ddlClient.SelectedValue == "-1") { master.SetParameter("Client", "All"); } else { CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadByCompaniesId(Int32.Parse(ddlClient.SelectedValue), companyId); string clientName = companiesGateway.GetName(Int32.Parse(ddlClient.SelectedValue)); master.SetParameter("Client", clientName); } // ... ... salesman if (ddlSalesman.SelectedValue == "-1") { master.SetParameter("Salesman", "All"); } else { EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(Int32.Parse(ddlSalesman.SelectedValue)); string salesman = employeeGateway.GetFullName(Int32.Parse(ddlSalesman.SelectedValue)); master.SetParameter("Salesman", salesman); } // ... ... country if (ddlCountry.SelectedValue == "2") { master.SetParameter("Country", "USA"); } else { if (ddlCountry.SelectedValue == "1") { master.SetParameter("Country", "Canada"); } else { master.SetParameter("Country", "All"); } } // ... ... order by if (ddlOrderBy.SelectedValue == "P.CountryID") { master.SetParameter("OrderBy", "Country"); } else { if (ddlOrderBy.SelectedValue == "P.ProjectNumber") { master.SetParameter("OrderBy", "Project Number"); } else { if (ddlOrderBy.SelectedValue == "P.Name") { master.SetParameter("OrderBy", "Project Name"); } else { if (ddlOrderBy.SelectedValue == "C.Name") { master.SetParameter("OrderBy", "Client"); } else { master.SetParameter("OrderBy", "Salesman"); } } } } } else { master.SetParameter("ExchangeRate", decimal.Parse(tbxExchangeRate.Text.Trim())); master.SetParameter("Total", "Total (" + ddlCurrency.SelectedValue.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 (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"]; } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue; PrintEmployeeLocationGateway printEmployeeLocationGateway = new PrintEmployeeLocationGateway(); if (ddlEmployee.SelectedValue == "-1") { if (tbxLocation.Text.Trim() == "yes") { printEmployeeLocationGateway.LoadByStartDateEndDateProjectTimeState(DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()), DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()), projectTimeState); } else { printEmployeeLocationGateway.LoadByStartDateEndDateLocationProjectTimeState(DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()), DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()), tbxLocation.Text.Trim(), projectTimeState); } } else { if (tbxLocation.Text.Trim() == "yes") { printEmployeeLocationGateway.LoadByStartDateEndDateEmployeeIdProjectTimeState(DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()), DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()), Int32.Parse(ddlEmployee.SelectedValue), projectTimeState); } else { printEmployeeLocationGateway.LoadByStartDateEndDateEmployeeIdLocationProjectTimeState(DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()), DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()), int.Parse(ddlEmployee.SelectedValue), tbxLocation.Text.Trim(), projectTimeState); } } // ... set properties to master page master.Data = printEmployeeLocationGateway.Data; master.Table = printEmployeeLocationGateway.TableName; // Get report if (printEmployeeLocationGateway.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintEmployeeLocationReport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintEmployeeLocationReportExport(); } // ... set parameters to report if (master.Format == "pdf") { // ... For report // ... ... project time state if (ddlProjectTimeState.SelectedValue == "(All)") { master.SetParameter("projectTimeState", "All"); } else { master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text); } // ... ... team member if (ddlEmployee.SelectedValue == "-1") { master.SetParameter("teamMember", "All"); } else { int teamMemberId = Int32.Parse(ddlEmployee.SelectedValue); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(teamMemberId); string fullName = employeeGateway.GetFullName(teamMemberId); master.SetParameter("teamMember", fullName); } // ... ... user int loginId = Convert.ToInt32(Session["loginID"]); int companyId = Convert.ToInt32(Session["companyID"]); 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("location", tbxLocation.Text.Trim()); master.SetParameter("startTime", tkrdpStartDate.SelectedDate.Value.ToShortDateString()); master.SetParameter("endTime", tkrdpEndDate.SelectedDate.Value.ToShortDateString()); } } }
// //////////////////////////////////////////////////////////////////////// // AUXILIAR EVENTS // protected void ddlEmployee_SelectedIndexChanged(object sender, EventArgs e) { ViewState["date_to_show"] = tkrsVacations.SelectedDate.ToString(); ViewState["employee_id"] = ddlEmployee.SelectedValue; DateTime dateToShow = DateTime.Parse((string)ViewState["date_to_show"]); int companyId = Int32.Parse(hdfCompanyId.Value); hdfEmployeeId.Value = ddlEmployee.SelectedValue.ToString(); int employeeId = Int32.Parse(hdfEmployeeId.Value); // Reload Data 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); } Session["vacationsAddTDS"] = vacationsAddTDS; Session["vacationDaysInformation"] = vacationsAddTDS.DaysInformation; }
// //////////////////////////////////////////////////////////////////////// // 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(); } }
// //////////////////////////////////////////////////////////////////////// // 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"]; } }
private void LoadWorkData(int workId, int assetId) { FullLengthLiningWorkDetailsGateway fullLengthLiningWorkDetailsGateway = new FullLengthLiningWorkDetailsGateway(fullLengthLiningTDS); if (fullLengthLiningWorkDetailsGateway.Table.Rows.Count > 0) { // For Header tbxVideoLength.Text = fullLengthLiningWorkDetailsGateway.GetVideoLength(workId); // Load full length lining general data tbxGeneralClientId.Text = fullLengthLiningWorkDetailsGateway.GetClientId(workId); ckbxGeneralIssueIdentified.Checked = fullLengthLiningWorkDetailsGateway.GetIssueIdentified(workId); ckbxGeneralLfsIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueLFS(workId); ckbxGeneralClientIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueClient(workId); ckbxGeneralSalesIssue.Checked = fullLengthLiningWorkDetailsGateway.GetIssueSales(workId); ckbxGeneralIssueGivenToClient.Checked = fullLengthLiningWorkDetailsGateway.GetIssueGivenToClient(workId); ckbxGeneralIssueResolved.Checked = fullLengthLiningWorkDetailsGateway.GetIssueResolved(workId); ckbxGeneralIssueInvestigation.Checked = fullLengthLiningWorkDetailsGateway.GetIssueInvestigation(workId); // ... Load Dates if (fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workId).HasValue) { tkrdpGeneralProposedLiningDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetProposedLiningDate(workId); } if (fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workId).HasValue) { tkrdpGeneralDeadlineLiningDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetDeadlineLiningDate(workId); } if (fullLengthLiningWorkDetailsGateway.GetP1Date(workId).HasValue) { tkrdpPrepDataP1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetP1Date(workId); tkrdpGeneralP1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetP1Date(workId); } if (fullLengthLiningWorkDetailsGateway.GetM1Date(workId).HasValue) { tkrdpM1DataM1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM1Date(workId); tkrdpGeneralM1Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM1Date(workId); } if (fullLengthLiningWorkDetailsGateway.GetM2Date(workId).HasValue) { tkrdpGeneralM2Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM2Date(workId); tkrdpM2DataM2Date.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetM2Date(workId); } if (fullLengthLiningWorkDetailsGateway.GetInstallDate(workId).HasValue) { tkrdpGeneralInstallDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetInstallDate(workId); tkrdpInstallDataInstallDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetInstallDate(workId); } if (fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId).HasValue) { tkrdpGeneralFinalVideo.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId); tkrdpInstallDataFinalVideoDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetFinalVideoDate(workId); } // ... for RA data if (fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId).HasValue) { tkrdpGeneralPreFlushDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId); tkrdpGeneralPreFlushDateReadOnly.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreFlushDate(workId); } if (fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId).HasValue) { tkrdpGeneralPreVideoDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId); tkrdpGeneralPreVideoDateReadOnly.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetPreVideoDate(workId); } // For FullLengthLiningP1 data tbxPrepDataCXIsRemoved.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).HasValue) tbxPrepDataCXIsRemoved.Text = fullLengthLiningWorkDetailsGateway.GetCxisRemoved(workId).ToString(); ckbxPrepDataRoboticPrepCompleted.Checked = fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompleted(workId); if (fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId).HasValue) { tkrdpPrepDataRoboticPrepCompletedDate.SelectedDate = (DateTime)fullLengthLiningWorkDetailsGateway.GetRoboticPrepCompletedDate(workId); } ckbxPrepDataP1Completed.Checked = fullLengthLiningWorkDetailsGateway.GetP1Completed(workId); // For FullLengthLiningM1 data // ... for material ddlM1DataMaterial.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMaterial(workId); // ... form m1 data tbxM1DataMeasurementsTakenBy.Text = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenBy(workId); ddlM1DataTrafficControl.SelectedValue = fullLengthLiningWorkDetailsGateway.GetTrafficControl(workId); if(fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId) == "") ddlM1DataSiteDetails.SelectedIndex = 0; else ddlM1DataSiteDetails.SelectedValue = fullLengthLiningWorkDetailsGateway.GetSiteDetails(workId); if (fullLengthLiningWorkDetailsGateway.GetAccessType(workId) == "") ddlM1DataAccessType.SelectedIndex = 0; else ddlM1DataAccessType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetAccessType(workId); ckbxM1DataPipeSizeChange.Checked = fullLengthLiningWorkDetailsGateway.GetPipeSizeChange(workId); ckbxM1DataStandardBypass.Checked = fullLengthLiningWorkDetailsGateway.GetStandardBypass(workId); tbxM1DataStandardBypassComments.Text = fullLengthLiningWorkDetailsGateway.GetStandardBypassComments(workId); tbxM1DataTrafficControlDetails.Text = fullLengthLiningWorkDetailsGateway.GetTrafficControlDetails(workId); ddlM1DataMeasurementType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMeasurementType(workId); ddlM1DataMeasuredFromMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId); tbxM1DataMeasuredFromMh.Text = ""; fullLengthLiningWorkDetailsGateway.GetMeasurementFromMh(workId); ddlM1DataVideoDoneFromMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId); tbxM1DataVideoDoneFromMh.Text = fullLengthLiningWorkDetailsGateway.GetVideoDoneFromMh(workId); ddlM1DataVideoDoneToMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId); tbxM1DataVideoDoneToMh.Text = fullLengthLiningWorkDetailsGateway.GetVideoDoneToMh(workId); // For FullLengthLiningM2 data tbxM2DataMeasurementsTakenBy.Text = fullLengthLiningWorkDetailsGateway.GetMeasurementTakenByM2(workId); ckbxM2DataDropPipe.Checked = fullLengthLiningWorkDetailsGateway.GetDropPipe(workId); tbxM2DataDropPipeInvertdepth.Text = fullLengthLiningWorkDetailsGateway.GetDropPipeInvertDepth(workId); tbxM2DataCappedLaterals.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).HasValue) tbxM2DataCappedLaterals.Text = fullLengthLiningWorkDetailsGateway.GetCappedLaterals(workId).ToString(); tbxM2DataLineWidthId.Text = fullLengthLiningWorkDetailsGateway.GetLineWithId(workId); tbxM2DataHydrantAddress.Text = fullLengthLiningWorkDetailsGateway.GetHydrantAddress(workId); ddlM2DataHydroWireWithin10FtOfInversionMh.SelectedValue = fullLengthLiningWorkDetailsGateway.GetHydroWiredWithin10FtOfInversionMH(workId); tbxM2DataDistanceToInversionMH.Text = fullLengthLiningWorkDetailsGateway.GetDistanceToInversionMh(workId); if (fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId) == "") ddlM2DataSurfaceGrade.SelectedIndex = 0; else ddlM2DataSurfaceGrade.SelectedValue = fullLengthLiningWorkDetailsGateway.GetSurfaceGrade(workId); cbxM2DataHydroPulley.Checked = fullLengthLiningWorkDetailsGateway.GetHydroPulley(workId); cbxM2DataFridgeCart.Checked = fullLengthLiningWorkDetailsGateway.GetFridgeCart(workId); cbxM2DataTwoPump.Checked = fullLengthLiningWorkDetailsGateway.GetTwoPump(workId); cbxM2DataSixBypass.Checked = fullLengthLiningWorkDetailsGateway.GetSixBypass(workId); cbxM2DataScaffolding.Checked = fullLengthLiningWorkDetailsGateway.GetScaffolding(workId); cbxM2DataWinchExtension.Checked = fullLengthLiningWorkDetailsGateway.GetWinchExtension(workId); cbxM2DataExtraGenerator.Checked = fullLengthLiningWorkDetailsGateway.GetExtraGenerator(workId); cbxM2DataGreyCableExtension.Checked = fullLengthLiningWorkDetailsGateway.GetGreyCableExtension(workId); cbxM2DataEasementMats.Checked = fullLengthLiningWorkDetailsGateway.GetEasementMats(workId); cbxM2DataRampsRequired.Checked = fullLengthLiningWorkDetailsGateway.GetRampRequired(workId); cbxM2DataCameraSkid.Checked = fullLengthLiningWorkDetailsGateway.GetCameraSkid(workId); // For FullLengthLiningWetOut data int companyId = Int32.Parse(hdfCompanyId.Value); // ... ... tube size = confirmed Size Distance confirmedSizeDistance = new Distance(tbxConfirmedSize.Text); double confirmedSize = 0; string[] confirmedSizeString = confirmedSizeDistance.ToStringInEng1().Split('\"'); if (!confirmedSizeDistance.ToStringInEng1().Contains("'")) { if (Validator.IsValidDouble(tbxConfirmedSize.Text)) { confirmedSize = double.Parse(tbxConfirmedSize.Text); } else { confirmedSize = double.Parse(confirmedSizeString[0]); } } else { confirmedSize = Math.Ceiling(confirmedSizeDistance.ToDoubleInEng3()*12); tbxConfirmedSize.Text = confirmedSize.ToString(); } // ... Verify if work has wet out information WorkFullLengthLiningWetOutGateway workFullLengthLiningWetOutGateway = new WorkFullLengthLiningWetOutGateway(); workFullLengthLiningWetOutGateway.LoadByWorkId(workId, companyId); if (workFullLengthLiningWetOutGateway.Table.Rows.Count > 0) { // ... setup data ddlWetOutDataLinerTube.SelectedValue = fullLengthLiningWorkDetailsGateway.GetLinerTube(workId); if (ddlWetOutDataLinerTube.SelectedValue != "(Select)") { ckbxWetOutDataIncludeWetOutInformation.Checked = true; } else { ckbxWetOutDataIncludeWetOutInformation.Checked = false; } ddlWetOutDataResins.SelectedValue = fullLengthLiningWorkDetailsGateway.GetResinId(workId).ToString(); tbxWetOutDataExcessResin.Text = fullLengthLiningWorkDetailsGateway.GetExcessResin(workId).ToString(); ddlWetOutDataPoundsDrums.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPoundsDrums(workId); tbxWetOutDataDrumDiameter.Text = fullLengthLiningWorkDetailsGateway.GetDrumDiameter(workId).ToString(); tbxWetOutDataHoistMaximumHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistMaximumHeight(workId).ToString(); tbxWetOutDataHoistMinimumHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistMinimumHeight(workId).ToString(); tbxWetOutDataDownDropTubeLength.Text = fullLengthLiningWorkDetailsGateway.GetDownDropTubeLenght(workId).ToString(); tbxWetOutDataPumpHeightAboveGround.Text = fullLengthLiningWorkDetailsGateway.GetPumpHeightAboveGround(workId).ToString(); tbxWetOutDataTubeResinToFeltFactor.Text = fullLengthLiningWorkDetailsGateway.GetTubeResinToFeltFactor(workId).ToString(); // ... wet out sheet DateTime wetOutDataDateOfSheet = fullLengthLiningWorkDetailsGateway.GetDateOfSheet(workId); tbxWetOutDataDateOfSheet.Text = wetOutDataDateOfSheet.Month.ToString() + "/" + wetOutDataDateOfSheet.Day.ToString() + "/" + wetOutDataDateOfSheet.Year.ToString(); ddlWetOutDataMadeBy.SelectedValue = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId).ToString(); hdfRunDetails.Value = fullLengthLiningWorkDetailsGateway.GetRunDetails(workId); ddlWetOutDataRunDetails2.SelectedValue = fullLengthLiningWorkDetailsGateway.GetRunDetails2(workId); tkrdpWetOutDataWetOutDate.SelectedDate = fullLengthLiningWorkDetailsGateway.GetWetOutDate(workId); tbxWetOutDataInstallDate.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId).HasValue) { DateTime? wetOutDataInstallDate = fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId); DateTime wetOutDataInstallDateDateTime = (DateTime)wetOutDataInstallDate; tbxWetOutDataInstallDate.Text = wetOutDataInstallDateDateTime.Month.ToString() + "/" + wetOutDataInstallDateDateTime.Day.ToString() + "/" + wetOutDataInstallDateDateTime.Year.ToString(); } tbxWetOutDataTubeThickness.Text = fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId); tbxWetOutDataLengthToLine.Text = decimal.Round(decimal.Parse(fullLengthLiningWorkDetailsGateway.GetLengthToLine(workId).ToString()), 1).ToString(); tbxWetOutDataPlusExtra.Text = fullLengthLiningWorkDetailsGateway.GetPlusExtra(workId).ToString(); tbxWetOutDataForTurnOffset.Text = fullLengthLiningWorkDetailsGateway.GetForTurnOffset(workId).ToString(); tbxWetOutDataLengthtToWetOut.Text = fullLengthLiningWorkDetailsGateway.GetLengthToWetOut(workId).ToString(); tbxWetOutDataTubeMaxColdHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxColdHead(workId).ToString(); tbxWetOutDataTubeMaxColdHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxColdHeadPsi(workId).ToString(); tbxWetOutDataTubeMaxHotHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxHotHead(workId).ToString(); tbxWetOutDataTubeMaxHotHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeMaxHotHeadPsi(workId).ToString(); tbxWetOutDataTubeIdealHead.Text = fullLengthLiningWorkDetailsGateway.GetTubeIdealHead(workId).ToString(); tbxWetOutDataTubeIdealHeadPSI.Text = fullLengthLiningWorkDetailsGateway.GetTubeIdealHeadPsi(workId).ToString(); tbxWetOutDataNetResinForTube.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTube(workId).ToString(); tbxWetOutDataNetResinForTubeUsgals.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeUsgals(workId).ToString(); tbxWetOutDataNetResinForTubeDrumsIns.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeDrumsIns(workId); tbxWetOutDataNetResinForTubeLbsFt.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeLbsFt(workId).ToString(); tbxWetOutDataNetResinForTubeUsgFt.Text = fullLengthLiningWorkDetailsGateway.GetNetResinForTubeUsgFt(workId).ToString(); tbxWetOutDataExtraResinForMix.Text = fullLengthLiningWorkDetailsGateway.GetExtraResinForMix(workId).ToString(); tbxWetOutDataExtraLbsForMix.Text = fullLengthLiningWorkDetailsGateway.GetExtraLbsForMix(workId).ToString(); tbxWetOutDataTotalMixQuantity.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantity(workId).ToString(); tbxWetOutDataTotalMixQuantityUsgals.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantityUsgals(workId).ToString(); tbxWetOutDataTotalMixQuantityDrumsIns.Text = fullLengthLiningWorkDetailsGateway.GetTotalMixQuantityDrumsIns(workId); ddlWetOutDataInversionType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetInversionType(workId); tbxWetOutDataDepthOfInversionMH.Text = fullLengthLiningWorkDetailsGateway.GetDepthOfInversionMH(workId).ToString(); tbxWetOutDataTubeForColumn.Text = fullLengthLiningWorkDetailsGateway.GetTubeForColumn(workId).ToString(); tbxWetOutDataTubeForStartDry.Text = fullLengthLiningWorkDetailsGateway.GetTubeForStartDry(workId).ToString(); tbxWetOutDataTotalTube.Text = fullLengthLiningWorkDetailsGateway.GetTotalTube(workId).ToString(); tbxWetOutDataDropTubeConnects.Text = fullLengthLiningWorkDetailsGateway.GetDropTubeConnects(workId); tbxWetOutDataAllowsHeadTo.Text = fullLengthLiningWorkDetailsGateway.GetAllowsHeadTo(workId).ToString(); tbxWetOutDataRollerGap.Text = fullLengthLiningWorkDetailsGateway.GetRollerGap(workId).ToString(); tbxWetOutDataHeightNeeded.Text = fullLengthLiningWorkDetailsGateway.GetHeightNeeded(workId).ToString(); tbxWetOutDataAvailable.Text = fullLengthLiningWorkDetailsGateway.GetAvailable(workId); tbxWetOutDataHoistHeight.Text = fullLengthLiningWorkDetailsGateway.GetHoistHeight(workId); hdfResinId.Value = fullLengthLiningWorkDetailsGateway.GetResinId(workId).ToString(); hdfMadeBy.Value = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId).ToString(); tbxWetOutDataNotes.Text = fullLengthLiningWorkDetailsGateway.GetCommentsCipp(workId); lblWetOutDataResinGray.Text = fullLengthLiningWorkDetailsGateway.GetResinsLabel(workId); lblWetOutDataDrumContainsGray.Text = fullLengthLiningWorkDetailsGateway.GetDrumContainsLabel(workId); lblWetOutDataLinerTubeGray.Text = fullLengthLiningWorkDetailsGateway.GetLinerTubeLabel(workId); lblWetOutDataLbDrumsGrey.Text = fullLengthLiningWorkDetailsGateway.GetForLbDrumsLabel(workId); lblWetOutDataNetResinGrey.Text = fullLengthLiningWorkDetailsGateway.GetNetResinLabel(workId); lblWetOutDataCatalystGrey.Text = fullLengthLiningWorkDetailsGateway.GetCatalystLabel(workId); // ... ... graphic labels lblWetOutDataDimensionLabel.Text = confirmedSize + " ins x " + ddlThickness.SelectedValue + " mm Tube"; lblWetOutDataTotalTubeLengthlabel.Text = "Total Tube Length " + tbxWetOutDataTotalTube.Text + " ft"; lblWetOutDataForColumnLabel.Text = tbxWetOutDataTubeForColumn.Text + " ft for Column"; lblWetOutDataDryFtLabel.Text = "Dry " + tbxWetOutDataTubeForStartDry.Text + " ft"; lblWetOutDataWetOutLengthlabel.Text = "Wet-Out Length " + tbxWetOutDataLengthtToWetOut.Text + " ft"; lblWetOutDataDryFtEndLabel.Text = "Dry " + tbxWetOutDataTubeForColumn.Text + " ft"; lblWetOutDataTailEndlabel.Text = "Tail End"; lblWetOutDataColumnEndlabel.Text = "Column End"; lblWetOutDataRollerGapLabel.Text = "Roller Gap " + tbxWetOutDataRollerGap.Text + " mm"; } else { // Wet Out Data // ... Show current day for new sheets DateTime sheetDate = DateTime.Now; tbxWetOutDataDateOfSheet.Text = sheetDate.Month.ToString() + "/" + sheetDate.Day.ToString() + "/" + sheetDate.Year.ToString(); // Set default values. tbxWetOutDataExcessResin.Text = "0.0"; ddlWetOutDataPoundsDrums.SelectedIndex = 1; tbxWetOutDataDrumDiameter.Text = "22.5"; tbxWetOutDataHoistMaximumHeight.Text = "24"; tbxWetOutDataHoistMinimumHeight.Text = "5"; tbxWetOutDataDownDropTubeLength.Text = "19"; tbxWetOutDataPumpHeightAboveGround.Text = "6"; tbxWetOutDataTubeResinToFeltFactor.Text = "87"; tbxWetOutDataPlusExtra.Text = "3"; tbxWetOutDataForTurnOffset.Text = "0"; tbxWetOutDataExtraResinForMix.Text = "0"; tbxWetOutDataTubeForColumn.Text = "16"; tbxWetOutDataTubeForStartDry.Text = "3"; if (ddlWetOutDataInversionType.SelectedValue == "Top") { Distance usmhDepthDistance = new Distance(tbxM1DataUsmhDepth.Text); tbxWetOutDataDepthOfInversionMH.Text = decimal.Round(decimal.Parse(usmhDepthDistance.ToStringInEng3()), 1).ToString(); } else { if (ddlWetOutDataInversionType.SelectedValue == "Bottom") { Distance dsmhDepthDistance = new Distance(tbxM1DataDsmhDepth.Text); tbxWetOutDataDepthOfInversionMH.Text = decimal.Round(decimal.Parse(dsmhDepthDistance.ToStringInEng3()), 1).ToString(); } else { tbxWetOutDataDepthOfInversionMH.Text = "0"; } } tbxWetOutDataRollerGap.Text = "13"; tbxWetOutDataNotes.Text = fullLengthLiningWorkDetailsGateway.GetCommentsCipp(workId); // ...Section values // ... ... Length To Line = Steel Tape Length, the first section to consider is the work one in Xft Yin Distance steelTapeLength = new Distance(tbxSteelTapeLength.Text); tbxWetOutDataLengthToLine.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()), 1).ToString(); tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()),1).ToString(); double lengthToLine = double.Parse(steelTapeLength.ToStringInEng3()); // ... Run details if (cbxlSectionId.Items.Count > 1) { hdfRunDetails.Value = hdfSectionId.Value; } // .... Install Date tbxWetOutDataInstallDate.Text = ""; if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "") { DateTime? inversionDataInstalledOn = tkrdpInstallDataInstallDate.SelectedDate; DateTime installedOnDateTime = (DateTime)inversionDataInstalledOn; tbxWetOutDataInstallDate.Text = installedOnDateTime.Month.ToString() + "/" + installedOnDateTime.Day.ToString() + "/" + installedOnDateTime.Year.ToString(); } } // ... Verify if work has inversion information WorkFullLengthLiningInversionGateway workFullLengthLiningInversionGateway = new WorkFullLengthLiningInversionGateway(); workFullLengthLiningInversionGateway.LoadByWorkId(workId, companyId); // ... Verify if work has inversion information if (workFullLengthLiningInversionGateway.Table.Rows.Count > 0) { // ... Inversion data lblInversionDataSubtitle.Text = fullLengthLiningWorkDetailsGateway.GetLinerTube(workId); DateTime inversionDataDateOfSheet = fullLengthLiningWorkDetailsGateway.GetDateOfSheet(workId); tbxInversionDataDateOfSheet.Text = inversionDataDateOfSheet.Month.ToString() + "/" + inversionDataDateOfSheet.Day.ToString() + "/" + inversionDataDateOfSheet.Year.ToString(); int employeeId = fullLengthLiningWorkDetailsGateway.GetEmployeeId(workId); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(employeeId); tbxInversionDataMadeBy.Text = employeeGateway.GetLastName(employeeId) + " " + employeeGateway.GetFirstName(employeeId); tbxInversionDataInstalledOn.Text = ""; if (fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId).HasValue) { DateTime? inversionDataInstalledOn = fullLengthLiningWorkDetailsGateway.GetWetOutInstallDate(workId); DateTime inversionDataInstalledOnDateTime = (DateTime)inversionDataInstalledOn; tbxInversionDataInstalledOn.Text = inversionDataInstalledOnDateTime.Month.ToString() + "/" + inversionDataInstalledOnDateTime.Day.ToString() + "/" + inversionDataInstalledOnDateTime.Year.ToString(); } tbxInversionDataRunDetails2.Text = fullLengthLiningWorkDetailsGateway.GetRunDetails2(workId); tbxInversionDataCommentsEdit.Text = fullLengthLiningWorkDetailsGateway.GetInversionComment(workId); tbxInversionDataLinerSize.Text = confirmedSizeString + " ins x" + fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId); tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(fullLengthLiningWorkDetailsGateway.GetLengthToLine(workId).ToString()), 1).ToString(); tbxInversionDataWetOutLenght.Text = fullLengthLiningWorkDetailsGateway.GetLengthToWetOut(workId).ToString(); ddlInversionDataInversionPipeType.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPipeType(workId); if (ddlInversionDataInversionPipeType.SelectedValue != "(Select)") { ckbxInversionDataIncludeInversionInformation.Checked = true; } else { ckbxInversionDataIncludeInversionInformation.Checked = false; } ddlInversionDataPipeCondition.SelectedValue = fullLengthLiningWorkDetailsGateway.GetPipeCondition(workId); ddlInversionDataGroundMoisture.SelectedValue = fullLengthLiningWorkDetailsGateway.GetGroundMoisture(workId); tbxInversionDataBoilerSize.Text = fullLengthLiningWorkDetailsGateway.GetBoilerSize(workId).ToString(); tbxInversionDataPumpsTotalCapacity.Text = fullLengthLiningWorkDetailsGateway.GetPumpTotalCapacity(workId).ToString(); tbxInversionDataLayflatSize.Text = fullLengthLiningWorkDetailsGateway.GetLayFlatSize(workId).ToString(); tbxInversionDataLayflatQuantityTotal.Text = fullLengthLiningWorkDetailsGateway.GetLayFlatQuantityTotal(workId).ToString(); tbxInversionDataWaterStartTempTs.Text = fullLengthLiningWorkDetailsGateway.GetWaterStartTemp(workId).ToString(); tbxInversionDataTempT1.Text = fullLengthLiningWorkDetailsGateway.GetTemp1(workId).ToString(); tbxInversionDataHoldAtT1For.Text = fullLengthLiningWorkDetailsGateway.GetHoldAtT1(workId).ToString(); tbxInversionDataTempT2.Text = fullLengthLiningWorkDetailsGateway.GetTempT2(workId).ToString(); tbxInversionDataCookAtT2For.Text = fullLengthLiningWorkDetailsGateway.GetCookAtT2(workId).ToString(); tbxInversionDataCoolDownFor.Text = fullLengthLiningWorkDetailsGateway.GetCoolDownFor(workId).ToString(); tbxInversionDataCoolToTemp.Text = fullLengthLiningWorkDetailsGateway.GetCoolToTemp(workId).ToString(); tbxInversionDataDropInPipeRun.Text = fullLengthLiningWorkDetailsGateway.GetDropInPipeRun(workId).ToString(); tbxInversionDataPipeSlopeOf.Text = fullLengthLiningWorkDetailsGateway.GetPipeSlopOf(workId).ToString(); lblInversionData45F120F.Text = tbxInversionDataWaterStartTempTs.Text + "°F-" + tbxInversionDataTempT1.Text + "°F (hr)"; tbxInversionData45F120F.Text = fullLengthLiningWorkDetailsGateway.GetF45F120(workId).ToString(); tbxInversionDataHold.Text = fullLengthLiningWorkDetailsGateway.GetHold(workId).ToString(); lblInversionData120F185F.Text = tbxInversionDataTempT1.Text + "°F-" + tbxInversionDataTempT2.Text + "°F (hr)"; tbxInversionData120F185F.Text = fullLengthLiningWorkDetailsGateway.GetF120F185(workId).ToString(); tbxInversionDataCookTime.Text = fullLengthLiningWorkDetailsGateway.GetCookTime(workId).ToString(); tbxInversionDataCoolTime.Text = fullLengthLiningWorkDetailsGateway.GetCoolTime(workId).ToString(); tbxInversionDataAproxTotal.Text = fullLengthLiningWorkDetailsGateway.GetAproxTotal(workId).ToString(); tbxInversionDataWaterChangesPerHour.Text = fullLengthLiningWorkDetailsGateway.GetWaterChangesPerHour(workId).ToString(); tbxInversionDataReturnWaterVelocity.Text = fullLengthLiningWorkDetailsGateway.GetReturnWaterVelocity(workId).ToString(); tbxInversionDataLayflatBackPressure.Text = fullLengthLiningWorkDetailsGateway.GetLayflatBackPressure(workId).ToString(); tbxInversionDataPumpLiftAtIdealHead.Text = fullLengthLiningWorkDetailsGateway.GetPumpLiftAtIdealHead(workId).ToString(); tbxInversionDataWaterToFillLinerColumn.Text = fullLengthLiningWorkDetailsGateway.GetWaterToFillLinerColumn(workId).ToString(); tbxInversionDataWaterPerFit.Text = fullLengthLiningWorkDetailsGateway.GetWaterPerFit(workId).ToString(); tbxInversionDataNotesAndInstallationResults.Text = fullLengthLiningWorkDetailsGateway.GetInstallationResults(workId); lblInversionDataLinerInfoGrey.Text = fullLengthLiningWorkDetailsGateway.GetInversionLinerTubeLabel(workId); lblInversionDataHeadsGrey.Text = fullLengthLiningWorkDetailsGateway.GetHeadsIdealLabel(workId); lblInversionDataPumpingCirculationSubtitle.Text = fullLengthLiningWorkDetailsGateway.GetPumpingAndCirculationLabel(workId); // ... ... graphic labels lblInversionDataMaxColdForTubeLabel.Text = tbxWetOutDataTubeMaxColdHead.Text + " ft = Max Cold for tube"; lblInversionDataMaxHotForTubeLabel.Text = tbxWetOutDataTubeMaxHotHead.Text + " ft = Max Hot for tube"; lblInversionDataIdelForTubeLabel.Text = tbxWetOutDataTubeIdealHead.Text + " ft = Ideal for tube"; double maxColdForTubeEnd = double.Parse(tbxWetOutDataTubeMaxColdHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text); lblInversionDataMaxColdForTubeEndLabel.Text = decimal.Round(decimal.Parse(maxColdForTubeEnd.ToString()), 1).ToString() + " ft"; double maxHotForTubeEnd = double.Parse(tbxWetOutDataTubeMaxHotHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text); lblInversionDataMaxHotForTubeEndLabel.Text = decimal.Round(decimal.Parse(maxHotForTubeEnd.ToString()), 1).ToString() + " ft"; double idealForTubeEnd = double.Parse(tbxWetOutDataTubeIdealHead.Text) + double.Parse(tbxInversionDataDropInPipeRun.Text); lblInversionDataIdelForTubeEndLabel.Text = decimal.Round(decimal.Parse(idealForTubeEnd.ToString()), 1).ToString() + " ft"; lblInversionDataPumpHeightLabel.Text = " " + tbxWetOutDataPumpHeightAboveGround.Text + " ft"; lblInversionDataLinerSizeLabel.Text = confirmedSize.ToString() + " ins x" + fullLengthLiningWorkDetailsGateway.GetInversionThickness(workId) + " Liner"; lblInversionDataRunLengthLabel.Text = "Run Length: " + tbxInversionDataRunLength.Text + " ft; Fall: " + tbxInversionDataDropInPipeRun.Text + " ft"; lblInversionDataDepthOfInversionMHLabel.Text = " " + tbxWetOutDataDepthOfInversionMH.Text + " ft"; lblInversionDataEndLabel.Text = "End"; } else { // Wet Out Data // ... Show current day for new sheets DateTime sheetDate = DateTime.Now; tbxInversionDataDateOfSheet.Text = sheetDate.Month.ToString() + "/" + sheetDate.Day.ToString() + "/" + sheetDate.Year.ToString(); // Set default values. lblInversionData45F120F.Text = ""; lblInversionData120F185F.Text = ""; tbxInversionDataBoilerSize.Text = "7000000"; tbxInversionDataPumpsTotalCapacity.Text = "300"; tbxInversionDataLayflatSize.Text = "4"; tbxInversionDataLayflatQuantityTotal.Text = "1"; tbxInversionDataWaterStartTempTs.Text = "45"; tbxInversionDataTempT1.Text = "120"; tbxInversionDataHoldAtT1For.Text = "0.5"; tbxInversionDataTempT2.Text = "185"; tbxInversionDataCookAtT2For.Text = "2"; tbxInversionDataCoolDownFor.Text = "1"; tbxInversionDataCoolToTemp.Text = "85"; // ...Section values // ... ... Length To Line = Steel Tape Length, the first section to consider is the work one in Xft Yin Distance steelTapeLength = new Distance(tbxSteelTapeLength.Text); tbxInversionDataRunLength.Text = decimal.Round(decimal.Parse(steelTapeLength.ToStringInEng3()), 1).ToString(); double lengthToLine = double.Parse(steelTapeLength.ToStringInEng3()); // ... Run details if (cbxlSectionId.Items.Count > 1) { hdfRunDetails.Value = hdfSectionId.Value; } // .... Install Date tbxInversionDataInstalledOn.Text = ""; if (tkrdpInstallDataInstallDate.SelectedDate.ToString() != "") { DateTime? inversionDataInstalledOn = tkrdpInstallDataInstallDate.SelectedDate; DateTime installedOnDateTime = (DateTime)inversionDataInstalledOn; tbxInversionDataInstalledOn.Text = installedOnDateTime.Month.ToString() + "/" + installedOnDateTime.Day.ToString() + "/" + installedOnDateTime.Year.ToString(); } } // ... Show FLL Comments + RA Comments int flWorkId = workId; // ... ... Get raWorkId int raWorkId = 0; int projectId = Int32.Parse(hdfCurrentProjectId.Value); WorkGateway workGateway = new WorkGateway(); workGateway.LoadByProjectIdAssetIdWorkType(projectId, assetId, "Rehab Assessment", companyId); if (workGateway.Table.Rows.Count > 0) { raWorkId = workGateway.GetWorkId(assetId, "Rehab Assessment", projectId); } // ... ... Get comments FullLengthLiningAllComments fullLengthLiningAllComments = new FullLengthLiningAllComments(fullLengthLiningTDS); fullLengthLiningAllComments.LoadAllByFlWorkIdRaWorkId(flWorkId, raWorkId, companyId); // ... ... Store datasets Session["fullLengthLiningTDS"] = fullLengthLiningTDS; // ... ... Show comments tbxCommentsDataComments.Text = fullLengthLiningAllComments.GetFLOrRAComments(companyId, fullLengthLiningAllComments.Table.Rows.Count, "\n"); } }
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) { // Validate query string if (((string)Request.QueryString["source_page"] == null) && ((string)Request.QueryString["others"] == null) && ((string)Request.QueryString["employee_id"] == null) && ((string)Request.QueryString["period_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in timesheet_add.aspx"); } // Security check if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { if (Request.QueryString["others"] == "no") { if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_ADD"]))) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"])) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } } } else { if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_ADD"]))) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_MY_TIMESHEETS_MANAGEMENT_WED"])) { if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_ADD"]))) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT"])) { if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_OTHERS_TIMESHEETS_MANAGEMENT_WED"])) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } } } } } } } // Tag Page hdfSaveClick.Value = "false"; hdfEmployeeID.Value = Request.QueryString["employee_id"].ToString(); hdfPeriodId.Value = Request.QueryString["period_id"]; hdfCompanyId.Value = Session["companyID"].ToString(); hdfIsMoreThan15.Value = "false"; hdfIsMoreThan15Edit.Value = "false"; Session.Remove("projectTimeTempNewDummy"); // Initialize viewstate variables ViewState["others"] = Request.QueryString["others"]; ViewState["timesheetState"] = "For Approval"; // Get State int employeeId = Int32.Parse(hdfEmployeeID.Value); int periodId = Int32.Parse(hdfPeriodId.Value); TimesheetGateway timesheet = new TimesheetGateway(); timesheet.LoadByEmployeeIdPayPeriodId(employeeId, periodId); if (timesheet.Table.Rows.Count != 0) { ViewState["timesheetState"] = timesheet.GetStateByEmployeeIdPayPeriodId(employeeId, periodId); } if (Request.QueryString["source_page"] == "timesheet_summary.aspx" || Request.QueryString["source_page"] == "timesheet_summary_from_approve_project_times.aspx") { ViewState["projecttime_id"] = int.Parse(Request.QueryString["projecttime_id"]); } System.Configuration.AppSettingsReader appSettingReader = new System.Configuration.AppSettingsReader(); ViewState["LHMode"] = appSettingReader.GetValue("LABOUR_HOURS_OPERATION_MODE", typeof(System.String)).ToString(); // Timesheet state check if (((string)ViewState["LHMode"] == "Full") && (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]))) { TimesheetGateway timesheetGateway = new TimesheetGateway(); timesheetGateway.LoadByEmployeeIdPayPeriodId(employeeId, periodId); if ((timesheetGateway.Table.Rows.Count != 0) && (timesheetGateway.GetStateByEmployeeIdPayPeriodId(employeeId, periodId) != "Rejected")) { Response.Redirect("./../../error_page.aspx?error=" + "You cannot add project time to an approved or submitted timesheet."); } } // Prepare initial data for client EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); employeeGateway.LoadByEmployeeId(employeeId); tbxEmployee.Text = employeeGateway.GetFullName(employeeId); tbxState.Text = "For Approval"; int companyId = Int32.Parse(hdfCompanyId.Value); CompaniesList companiesList = new CompaniesList(new DataSet()); companiesList.LoadAndAddItem(-1, "(Select a client)", companyId); ddlClient.DataSource = companiesList.Table; ddlClient.DataValueField = "COMPANIES_ID"; ddlClient.DataTextField = "Name"; ddlClient.DataBind(); ddlClient.SelectedIndex = 0; ProjectList projectList = new ProjectList(); projectList.LoadActiveProjectsActiveInternalProjectsActiveBallparkProjectsAndAddItem(-1, "(Select a project)", -1); ddlProject.DataSource = projectList.Table; ddlProject.DataValueField = "ProjectID"; ddlProject.DataTextField = "Name"; ddlProject.DataBind(); ddlProject.SelectedIndex = 0; CountryList countryList = new CountryList(new DataSet()); countryList.LoadAndAddItem(-1, " "); ddlMealsCountry.DataSource = countryList.Table; ddlMealsCountry.DataValueField = "CountryID"; ddlMealsCountry.DataTextField = "Name"; ddlMealsCountry.DataBind(); tkrdpStartDate.SelectedDate = DateTime.Now; tkrdpEndDate.SelectedDate = DateTime.Now; // Store timesheet dataset projectTimeTDS = new ProjectTimeTDS(); Session["projectTimeTDS"] = projectTimeTDS; projectTimeTemp = projectTimeTDS.LFS_PROJECT_TIME_TEMP; Session["projectTimeTemp"] = projectTimeTDS.LFS_PROJECT_TIME_TEMP; } else { // Restore datasets projectTimeTDS = (ProjectTimeTDS)Session["projectTimeTDS"]; projectTimeTemp = projectTimeTDS.LFS_PROJECT_TIME_TEMP; // Store datasets Session["projectTimeTemp"] = projectTimeTemp; } }
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 cvJobClassEmptyFooter_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = true; int employeeId = Int32.Parse(hdfEmployeeID.Value); EmployeeGateway employee = new EmployeeGateway(); employee.LoadByEmployeeId(employeeId); string jobClass = employee.GetJobClassType(employeeId); if (jobClass == "") { args.IsValid = false; } }
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(); } } }
// //////////////////////////////////////////////////////////////////////// // 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; } }
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 LoadDetailaDataAssignmentData(int serviceId, ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway) { // Load for Assignment Tab // ... pnlAssignmentData tbxAssignmentDataAssignmentDateTime.Text = serviceInformationBasicInformationGateway.GetAssignmentDateTime(serviceId).ToString(); if (serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId).HasValue) { DateTime deadlineDate = (DateTime)serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId); tkrdpAssignmentDataAssignedDeadlineDate.SelectedDate = DateTime.Parse(deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString()); } if ((serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) == "") { // ... For team member rbtnAssignmentDataToTeamMember.Checked = true; rbtnAssignmentDataToTeamMemberReadOnly.Checked = true; // ... For third party vendor rbtnAssignmentDataToThirdPartyVendor.Checked = false; rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = false; } else { if ((!serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) != "") { // ... For team member rbtnAssignmentDataToTeamMember.Checked = false; rbtnAssignmentDataToTeamMemberReadOnly.Checked = false; // ... For third party vendor rbtnAssignmentDataToThirdPartyVendor.Checked = true; rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = true; tbxAssignmentDataAssignToThirdPartyVendor.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId); tbxAssignmentDataAssignToThirdPartyVendorReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId); } else { rbtnAssignmentDataToTeamMember.Checked = false; rbtnAssignmentDataToTeamMemberReadOnly.Checked = false; rbtnAssignmentDataToThirdPartyVendor.Checked = false; rbtnAssignmentDataToThirdPartyVendorReadOnly.Checked = false; } } tbxAssignmentDataAcceptedDateTime.Text = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId).ToString(); DateTime? acceptedDateTime = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId); if (acceptedDateTime.HasValue) tbxAssignmentDataAcceptedDateTime.Text = acceptedDateTime.ToString(); DateTime? rejectedDateTime = serviceInformationBasicInformationGateway.GetRejectedDateTime(serviceId); if (rejectedDateTime.HasValue) tbxAssignmentDataRejectedDateTime.Text = rejectedDateTime.ToString(); tbxAssignmentDataRejectedReason.Text = serviceInformationBasicInformationGateway.GetRejectedReason(serviceId); // ... pnlAssignmentDataReadOnly tbxAssignmentDataAssignmentDateTimeReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignmentDateTime(serviceId).ToString(); tbxAssignmentDataAssignedDeadlineDateReadOnly.Text = ""; if (serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId).HasValue) { DateTime deadlineDate = (DateTime)serviceInformationBasicInformationGateway.GetAssignedDeadlineDate(serviceId); tbxAssignmentDataAssignedDeadlineDateReadOnly.Text = deadlineDate.Month.ToString() + "/" + deadlineDate.Day.ToString() + "/" + deadlineDate.Year.ToString(); } if ((serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) == "") { // ... For team member rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = true; if (serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId).HasValue) { int teamMemberId = (int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(teamMemberId); tbxAssignmentDataReadOnlyAssignToTeamMemberReadOnly.Text = employeeGateway.GetLastName(teamMemberId) + " " + employeeGateway.GetFirstName(teamMemberId); } // ... For third party vendor rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = false; } else { if ((!serviceInformationBasicInformationGateway.GetToTeamMember(serviceId)) && (serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId)) != "") { // ... For team member rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = false; // ... For third party vendor rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = true; tbxAssignmentDataReadOnlyAssignToThirdPartyVendorReadOnly.Text = serviceInformationBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId); } else { rbtnAssignmentDataReadOnlyToTeamMemberReadOnly.Checked = false; rbtnAssignmentDataReadOnlyToThirdPartyVendorReadOnly.Checked = false; } } tbxAssignmentDataAcceptedDateTimeReadOnly.Text = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId).ToString(); DateTime? acceptedDateTimeReadOnly = serviceInformationBasicInformationGateway.GetAcceptedDateTime(serviceId); if (acceptedDateTimeReadOnly.HasValue) tbxAssignmentDataAcceptedDateTimeReadOnly.Text = acceptedDateTimeReadOnly.ToString(); DateTime? rejectedDateTimeReadOnly = serviceInformationBasicInformationGateway.GetRejectedDateTime(serviceId); if (rejectedDateTimeReadOnly.HasValue) tbxAssignmentDataRejectedDateTimeReadOnly.Text = rejectedDateTimeReadOnly.ToString(); tbxAssignmentDataRejectedReasonReadOnly.Text = serviceInformationBasicInformationGateway.GetRejectedReason(serviceId); }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_VIEW"]) && Convert.ToBoolean(Session["sgLFS_RESOURCES_EMPLOYEES_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["employee_id"] == null) || ((string)Request.QueryString["active_tab"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in employees_summary.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfResourceType.Value = "Employees"; hdfActiveTab.Value = Request.QueryString["active_tab"].ToString(); hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString(); hdfCurrentEmployeeId.Value = Request.QueryString["employee_id"]; // Prepare initial data Session.Remove("employeesNotesDummy"); Session.Remove("employeesCostsDummy"); Session.Remove("employeesCostsExceptionsDummy"); Session.Remove("employeesVacationsDummy"); Session.Remove("costIdSelected"); // ... for team member title int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int employeeId = Int32.Parse(hdfCurrentEmployeeId.Value); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(employeeId); lblTitleTeamMember.Text = "Team Member: " + employeeGateway.GetFullName(employeeId); // If coming from // ... employees_navigator2.aspx, employees_add.aspx if ((Request.QueryString["source_page"] == "employees_navigator2.aspx") || (Request.QueryString["source_page"] == "employees_add.aspx")) { StoreNavigatorState(); ViewState["update"] = "yes"; // ... ... Set initial tab if ((string)Session["dialogOpenedEmployees"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; employeeInformationTDS = new EmployeeInformationTDS(); EmployeeInformationBasicInformation employeeInformationBasicInformation = new EmployeeInformationBasicInformation(employeeInformationTDS); employeeInformationBasicInformation.LoadByEmployeeId(employeeId, companyId); EmployeeInformationCostInformation employeeInformationCostInformation = new EmployeeInformationCostInformation(employeeInformationTDS); employeeInformationCostInformation.LoadAllByEmployeeId(employeeId, companyId); EmployeeInformationCostExceptionsInformation employeeInformationCostExceptionsInformation = new EmployeeInformationCostExceptionsInformation(employeeInformationTDS); employeeInformationCostExceptionsInformation.LoadAllByEmployeeId(employeeId, companyId); Session["costIdSelected"] = 0; EmployeeInformationNoteInformation employeeInformationNoteInformationForEdit = new EmployeeInformationNoteInformation(employeeInformationTDS); employeeInformationNoteInformationForEdit.LoadAllByEmployeeId(employeeId, companyId); EmployeeInformationCategoryApproveTimesheetsInformation employeeInformationCategoryApproveTimesheetsInformation = new EmployeeInformationCategoryApproveTimesheetsInformation(employeeInformationTDS); employeeInformationCategoryApproveTimesheetsInformation.LoadByEmployeeId(employeeId); } else { hdfActiveTab.Value = (string)Session["activeTabEmployees"]; // Restore datasets employeeInformationTDS = (EmployeeInformationTDS)Session["employeeInformationTDS"]; } tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); // Store dataset Session["employeeInformationTDS"] = employeeInformationTDS; } // ... employees_delete.aspx or employees_edit.aspx if ((Request.QueryString["source_page"] == "employees_delete.aspx") || (Request.QueryString["source_page"] == "employees_edit.aspx")) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore dataset employeeInformationTDS = (EmployeeInformationTDS)Session["employeeInformationTDS"]; // ... Set initial tab if ((string)Session["dialogOpenedEmployees"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; } else { hdfActiveTab.Value = (string)Session["activeTabEmployees"]; } tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); } string filterOptions = string.Format("CostID = {0} AND Deleted = {1}", 0, 0); odsCostsExceptions.FilterExpression = filterOptions; // Prepare initial data // ... Data for current employee LoadData(); // Databind Page.DataBind(); } else { // Restore datasets employeeInformationTDS = (EmployeeInformationTDS)Session["employeeInformationTDS"]; // Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcDetailedInformation.ActiveTabIndex = activeTab; } }
// //////////////////////////////////////////////////////////////////////// // 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) || ((string)Request.QueryString["service_id"] == null) || ((string)Request.QueryString["active_tab"] == null) || ((string)Request.QueryString["dashboard"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in services_edit.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfFmType.Value = "Services"; hdfServiceId.Value = Request.QueryString["service_id"].ToString(); hdfActiveTab.Value = Request.QueryString["active_tab"].ToString(); hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString(); hdfDashboard.Value = Request.QueryString["dashboard"].ToString(); // Prepare initial data Session.Remove("serviceCostsDummy"); Session.Remove("serviceNotesDummy"); // If coming from int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int serviceId = Int32.Parse(hdfServiceId.Value.Trim()); string fmType = hdfFmType.Value; // ... services_navigator2.aspx, services_add_request.aspx, services_manager_tool.aspx if ((Request.QueryString["source_page"] == "services_navigator2.aspx") || (Request.QueryString["source_page"] == "services_add_request.aspx") || (Request.QueryString["source_page"] == "services_manager_tool.aspx")) { StoreNavigatorState(); ViewState["update"] = "no"; // ... Set initial tab if ((string)Session["dialogOpenedServices"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; serviceInformationTDS = new ServiceInformationTDS(); ServiceInformationBasicInformation serviceInformationBasicInformation = new ServiceInformationBasicInformation(serviceInformationTDS); serviceInformationBasicInformation.LoadByServiceId(serviceId, companyId); ServiceInformationServiceCost serviceInformationServiceCostForEdit = new ServiceInformationServiceCost(serviceInformationTDS); serviceInformationServiceCostForEdit.LoadByServiceId(serviceId, companyId); ServiceInformationServiceNote serviceInformationServiceNoteForEdit = new ServiceInformationServiceNote(serviceInformationTDS); serviceInformationServiceNoteForEdit.LoadByServiceId(serviceId, companyId); } else { hdfActiveTab.Value = (string)Session["activeTabServices"]; // Restore datasets serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"]; } // ... Store dataset Session["serviceInformationTDS"] = serviceInformationTDS; } // ... services_summary.aspx or services_edit if ((Request.QueryString["source_page"] == "services_summary.aspx") || (Request.QueryString["source_page"] == "services_edit.aspx")) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // ... Restore dataset serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"]; // ... Set initial tab if ((string)Session["dialogOpenedServices"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; if (ViewState["update"].ToString().Trim() == "yes") { ServiceInformationBasicInformation serviceInformationBasicInformation = new ServiceInformationBasicInformation(serviceInformationTDS); serviceInformationBasicInformation.LoadByServiceId(serviceId, companyId); ServiceInformationServiceCost serviceInformationServiceCostForEdit = new ServiceInformationServiceCost(serviceInformationTDS); serviceInformationServiceCostForEdit.LoadByServiceId(serviceId, companyId); ServiceInformationServiceNote serviceInformationServiceNoteForEdit = new ServiceInformationServiceNote(serviceInformationTDS); serviceInformationServiceNoteForEdit.LoadByServiceId(serviceId, companyId); // ... Store dataset Session["serviceInformationTDS"] = serviceInformationTDS; } } else { hdfActiveTab.Value = (string)Session["activeTabServices"]; } } // Prepare initial data lblMissingData.Visible = false; // ... Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcDetailedInformation.ActiveTabIndex = activeTab; // ... For total cost ServiceInformationServiceCost serviceInformationServiceCostForTotalCost = new ServiceInformationServiceCost(serviceInformationTDS); tbxTotalCost.Text = Decimal.Round(serviceInformationServiceCostForTotalCost.GetTotalCost(serviceId, companyId), 2).ToString(); // ... Data for current servicew LoadServiceData(companyId); // Databind Page.DataBind(); ServiceInformationBasicInformationGateway serviceInformationBasicInformationGateway = new ServiceInformationBasicInformationGateway(serviceInformationTDS); if (serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId).HasValue) { try { ddlAssignmentDataAssignToTeamMember.SelectedValue = ((int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId)).ToString(); } catch { ddlAssignmentDataAssignToTeamMember.SelectedIndex = 0; } int teamMemberId = (int)serviceInformationBasicInformationGateway.GetAssignTeamMemberId(serviceId); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(teamMemberId); tbxAssignmentDataAssignToTeamMemberReadOnly.Text = employeeGateway.GetLastName(teamMemberId) + " " + employeeGateway.GetFirstName(teamMemberId); } // For thirds party vendor autocomplete aceThirdPartyVendor.ContextKey = serviceId.ToString() + "," + hdfCompanyId.Value; // ... For Library if (Session["libraryTDSForServices"] != null) { libraryTDSForServices = (LibraryTDS)Session["libraryTDSForServices"]; } else { libraryTDSForServices = new LibraryTDS(); } } else { // Restore datasets serviceInformationTDS = (ServiceInformationTDS)Session["serviceInformationTDS"]; // Set initial tab int activeTab = Int32.Parse(hdfActiveTab.Value); tcDetailedInformation.ActiveTabIndex = activeTab; if (Session["libraryTDSForServices"] != null) { libraryTDSForServices = (LibraryTDS)Session["libraryTDSForServices"]; } else { libraryTDSForServices = new LibraryTDS(); } LoadNotes(); } }
// //////////////////////////////////////////////////////////////////////// // 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; } }
private void Generate() { mReport1 master = (mReport1)this.Master; // Get Data string employeeType = (ddlEmployeeType.SelectedValue == "(All)") ? "%" : ddlEmployeeType.SelectedValue + "%"; string projectTimeState = (ddlProjectTimeState.SelectedValue == "(All)") ? "%" : ddlProjectTimeState.SelectedValue; DateTime startDate = DateTime.Parse(tkrdpStartDate.SelectedDate.Value.ToShortDateString()); DateTime endDate = DateTime.Parse(tkrdpEndDate.SelectedDate.Value.ToShortDateString()); PrintMealsGateway printMealsGateway = new PrintMealsGateway(); if (ddlEmployee.SelectedValue == "-1") { if (ddlSalaried.SelectedValue == "(All)") { printMealsGateway.LoadByEmployeeTypeStartDateEndDateProjectTimeState(employeeType, startDate, endDate, projectTimeState); } else { printMealsGateway.LoadByEmployeeSalariedTypeStartDateEndDateProjectTimeState(employeeType, startDate, endDate, projectTimeState, int.Parse(ddlSalaried.SelectedValue)); } } else { if (ddlSalaried.SelectedValue == "(All)") { printMealsGateway.LoadByEmployeeTypeStartDateEndDateEmployeeIdProjectTimeState(employeeType, startDate, endDate, int.Parse(ddlEmployee.SelectedValue), projectTimeState); } else { printMealsGateway.LoadByEmployeeTypeSalariedEmployeeIdStartDateEndDateProjectTimeState(employeeType, startDate, endDate, int.Parse(ddlEmployee.SelectedValue), projectTimeState, int.Parse(ddlSalaried.SelectedValue)); } } // ... set properties to master page master.Data = printMealsGateway.Data; master.Table = printMealsGateway.TableName; // Get report if (printMealsGateway.Table.Rows.Count > 0) { if (master.Format == "pdf") { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintMealsReport(); } else { master.Report = new LiquiForce.LFSLive.WebUI.LabourHours.ProjectTime.PrintMealsReportExport(); } // ... set parameters to report if (master.Format == "pdf") { // ... For report // ... ... project time state if (ddlProjectTimeState.SelectedValue == "(All)") { master.SetParameter("projectTimeState", "All"); } else { master.SetParameter("projectTimeState", ddlProjectTimeState.SelectedItem.Text); } // ... ... team member if (ddlEmployee.SelectedValue == "-1") { master.SetParameter("teamMember", "All"); } else { int teamMemberId = Int32.Parse(ddlEmployee.SelectedValue); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(teamMemberId); string fullName = employeeGateway.GetFullName(teamMemberId); master.SetParameter("teamMember", fullName); } // ... ... team member type if (ddlEmployeeType.SelectedValue == "(All)") { master.SetParameter("teamMemberType", "All"); } else { if (ddlEmployeeType.SelectedValue == "LFSCA") master.SetParameter("teamMemberType", "LFS Canada"); if (ddlEmployeeType.SelectedValue == "LFSUS") master.SetParameter("teamMemberType", "LFS USA"); if (ddlEmployeeType.SelectedValue == "LFS") master.SetParameter("teamMemberType", "All LFS"); if (ddlEmployeeType.SelectedValue == "PAGCA") master.SetParameter("teamMemberType", "PAG Canada"); if (ddlEmployeeType.SelectedValue == "PAGUS") master.SetParameter("teamMemberType", "PAG USA"); if (ddlEmployeeType.SelectedValue == "PAG") master.SetParameter("teamMemberType", "All PAG"); if (ddlEmployeeType.SelectedValue == "SOTA") master.SetParameter("teamMemberType", "SOTA"); if (ddlEmployeeType.SelectedValue == "Salaried") master.SetParameter("teamMemberType", "Salaried"); if (ddlEmployeeType.SelectedValue == "Subcontractor") master.SetParameter("teamMemberType", "Subcontractor"); } // ... ... user int loginId = Convert.ToInt32(Session["loginID"]); int companyId = Convert.ToInt32(Session["companyID"]); LoginGateway loginGateway = new LoginGateway(); loginGateway.LoadByLoginId(loginId, companyId); string user = loginGateway.GetLastName(loginId, companyId) + " " + loginGateway.GetFirstName(loginId, companyId); master.SetParameter("User", user.Trim()); // ... ... salaried if (ddlSalaried.SelectedValue == "(All)") { master.SetParameter("salaried", "All"); } else { if (ddlSalaried.SelectedValue == "1") master.SetParameter("salaried", "Yes"); if (ddlSalaried.SelectedValue == "0") master.SetParameter("salaried", "No"); } master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString()); master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString()); } else { master.SetParameter("dateFrom", tkrdpStartDate.SelectedDate.Value.ToShortDateString()); master.SetParameter("dateTo", tkrdpEndDate.SelectedDate.Value.ToShortDateString()); } } }
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; }
protected void ddlWetOutDataMadeBy_SelectedIndexChanged(object sender, EventArgs e) { if (ddlWetOutDataMadeBy.SelectedValue != "(Select)") { int employeeId = Int32.Parse(ddlWetOutDataMadeBy.SelectedValue); EmployeeGateway employeeGateway = new EmployeeGateway(); employeeGateway.LoadByEmployeeId(employeeId); tbxInversionDataMadeBy.Text = employeeGateway.GetLastName(employeeId) + " " + employeeGateway.GetFirstName(employeeId); } }