// //////////////////////////////////////////////////////////////////////// // STEP2 - TEMPLATE - PRIVATE METHODS // private void StepTemplateIn() { // Set instruction mWizard2 master = (mWizard2)this.Master; master.WizardInstruction = "Please select a template and click next."; // Initialize variables lblMessage.Visible = false; // Prepare initial data // ... for template TeamProjectTime2TemplateGateway teamProjectTime2TemplateGateway = new TeamProjectTime2TemplateGateway(teamProjectTime2TDS); teamProjectTime2TemplateGateway.LoadByLoginId(Convert.ToInt32(Session["loginID"])); // Store datasets Session["teamProjectTime2TDS"] = teamProjectTime2TDS; template = teamProjectTime2TDS.Template; Session["template"] = teamProjectTime2TDS.Template; }
private void UpdateDatabaseForTemplate() { try { TeamProjectTime2Gateway teamProjectTime2Gateway = new TeamProjectTime2Gateway(teamProjectTime2TDSToSave); teamProjectTime2Gateway.UpdateForTemplate(); teamProjectTime2TDS.AcceptChanges(); teamProjectTime2TDSToSave.AcceptChanges(); // Store dataset Session["teamProjectTime2TDS"] = teamProjectTime2TDS; template = teamProjectTime2TDS.Template; Session["template"] = teamProjectTime2TDS.Template; teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; ; } catch (Exception ex) { string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP1 - BEGIN // // //////////////////////////////////////////////////////////////////////// // STEP1 - BEGIN - METHODS // private void StepBeginIn() { // Set instruction mWizard2 master = (mWizard2)this.Master; master.WizardInstruction = "What do you want to do?"; if ((string)ViewState["StepFrom"] == "Out") { // Prepare initial data for the client TeamProjectTime2TemplateGateway teamProjectTime2TemplateGateway = new TeamProjectTime2TemplateGateway(teamProjectTime2TDS); teamProjectTime2TemplateGateway.LoadByLoginId(Convert.ToInt32(Session["loginID"])); // Store datasets Session["teamProjectTime2TDS"] = teamProjectTime2TDS; template = teamProjectTime2TDS.Template; Session["template"] = teamProjectTime2TDS.Template; // Template existing check if (teamProjectTime2TemplateGateway.Table.Rows.Count == 0) { hdfNewOrTemplate.Value = "New"; wzTeam.ActiveStepIndex = 2; } } }
// //////////////////////////////////////////////////////////////////////// // STEP3 - DATA - METHODS // private void StepDataIn() { // Set instruction mWizard2 master = (mWizard2)this.Master; master.WizardInstruction = "Please define global data, it will be applied to your team members on the next step."; // Wizard type & step from check if ((hdfNewOrTemplate.Value == "New") && ((string)ViewState["StepFrom"] != "Employees")) { // Prepare initial data ddlClient.Enabled = true; ddlProject.Enabled = true; ProjectTimeWorkList projectTimeWorkList = new ProjectTimeWorkList(new DataSet()); projectTimeWorkList.LoadAndAddItem("(Select a Type)"); ddlTypeOfWork.DataSource = projectTimeWorkList.Table; ddlTypeOfWork.DataValueField = "Work_"; ddlTypeOfWork.DataTextField = "Work_"; ddlTypeOfWork.DataBind(); ddlTypeOfWork.SelectedIndex = 0; ProjectTimeWorkFunctionList projectTimeWorkFunctionList = new ProjectTimeWorkFunctionList(new DataSet()); projectTimeWorkFunctionList.LoadActiveForAddAndAddItem("(Select a Function)", "-1"); ddlFunction.DataSource = projectTimeWorkFunctionList.Table; ddlFunction.DataValueField = "Function_"; ddlFunction.DataTextField = "Function_"; ddlFunction.DataBind(); ddlFunction.SelectedIndex = 0; } else { TeamProjectTime2Gateway teamProjectTime2Gateway = new TeamProjectTime2Gateway(teamProjectTime2TDS); TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS); // Prepare initial data if ((string)ViewState["StepFrom"] == "Template") { ViewState["teamProjectTimeId"] = Int32.Parse(hdfSelectedIdTemplate.Value); // ... for TeamProjectTime teamProjectTime2Gateway.LoadByTeamProjectTimeId((int)ViewState["teamProjectTimeId"]); // ... for TeamProjectTimeDetailTemp teamProjectTime2DetailTemp.LoadAllByTeamProjectTimeId((int)ViewState["teamProjectTimeId"]); } // ... for Client string companiesId = teamProjectTime2Gateway.GetCompaniesId((int)ViewState["teamProjectTimeId"]).ToString(); int companyId = Int32.Parse(hdfCompanyId.Value); CompaniesGateway companiesGateway = new CompaniesGateway(); companiesGateway.LoadAllByCompaniesId(Int32.Parse(companiesId), companyId); // ... If Company is active bool deleted = companiesGateway.GetDeleted(Int32.Parse(companiesId)); if (deleted) { ddlClient.SelectedIndex = -1; } else { ddlClient.SelectedValue = companiesId; } if (ddlClient.SelectedValue.Length == 0) { odsClient.DataBind(); ddlClient.DataSourceID = "odsClient"; ddlClient.DataValueField = "COMPANIES_ID"; ddlClient.DataTextField = "Name"; ddlClient.DataBind(); if (deleted) { ddlClient.SelectedIndex = -1; } else { ddlClient.SelectedValue = companiesId; } } if (!deleted) { // ... for project odsProjectsInternalProjectsBallparkProjects.SelectParameters.RemoveAt(2); odsProjectsInternalProjectsBallparkProjects.SelectParameters.Add("ClientId", ddlClient.SelectedValue); odsProjectsInternalProjectsBallparkProjects.Select(); odsProjectsInternalProjectsBallparkProjects.DataBind(); ddlProject.DataSourceID = "odsProjectsInternalProjectsBallparkProjects"; ddlProject.DataValueField = "ProjectID"; ddlProject.DataTextField = "NAME"; ddlProject.DataBind(); try { ddlProject.SelectedValue = teamProjectTime2Gateway.GetProjectId((int)ViewState["teamProjectTimeId"]).ToString(); } catch { ddlProject.SelectedIndex = -1; } } else { ddlProject.SelectedIndex = -1; } // ... for Date if ((string)ViewState["StepFrom"] == "Employees") { tkrdpDate_.SelectedDate = teamProjectTime2Gateway.GetDate_((int)ViewState["teamProjectTimeId"]); } // ... for Type of work ProjectTimeWorkList projectTimeWorkList = new ProjectTimeWorkList(new DataSet()); projectTimeWorkList.LoadAndAddItem("(Select a Type)"); ddlTypeOfWork.DataSource = projectTimeWorkList.Table; ddlTypeOfWork.DataValueField = "Work_"; ddlTypeOfWork.DataTextField = "Work_"; ddlTypeOfWork.DataBind(); if (teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]).ToString() == "") { ddlTypeOfWork.SelectedValue = "(Select a Type)"; } else { ddlTypeOfWork.SelectedValue = (string)teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]); } // ... for function ProjectTimeWorkFunctionList projectTimeWorkFunctionList = new ProjectTimeWorkFunctionList(new DataSet()); if (teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]).ToString() == "") { // ... If there is no type of Work, no function should be loaded projectTimeWorkFunctionList.LoadActiveForAddAndAddItem("(Select a Function)", "-1"); } else { projectTimeWorkFunctionList.LoadActiveForAddAndAddItem("(Select a Function)", teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"])); } ddlFunction.DataSource = projectTimeWorkFunctionList.Table; ddlFunction.DataValueField = "Function_"; ddlFunction.DataTextField = "Function_"; ddlFunction.DataBind(); if (teamProjectTime2Gateway.GetWork((int)ViewState["teamProjectTimeId"]).ToString() == "") { ddlFunction.SelectedValue = "(Select a Function)"; } else { ddlFunction.SelectedValue = (string)teamProjectTime2Gateway.GetFunction((int)ViewState["teamProjectTimeId"]); } // ... for working details if (!deleted) { tbxWorkingDetails.Text = teamProjectTime2Gateway.GetWorkingDetails((int)ViewState["teamProjectTimeId"]); } else { tbxWorkingDetails.Text = ""; } // ... for start time if (teamProjectTime2Gateway.GetStartTime((int)ViewState["teamProjectTimeId"]).HasValue) { string startTime = ((DateTime)teamProjectTime2Gateway.GetStartTime((int)ViewState["teamProjectTimeId"])).ToString("H:mm"); string[] hoursMin1 = startTime.Split(':'); ddlStartTimeHour.SelectedValue = hoursMin1[0].Trim(); ddlStartTimeMinute.SelectedValue = hoursMin1[1].Trim(); } // ... for end time if (teamProjectTime2Gateway.GetEndTime((int)ViewState["teamProjectTimeId"]).HasValue) { string endTime = ((DateTime)teamProjectTime2Gateway.GetEndTime((int)ViewState["teamProjectTimeId"])).ToString("H:mm"); string[] endHoursMin1 = endTime.Split(':'); ddlEndTimeHour.SelectedValue = endHoursMin1[0].Trim(); ddlEndTimeMinute.SelectedValue = endHoursMin1[1].Trim(); } // ... for offset if (teamProjectTime2Gateway.GetOffset((int)ViewState["teamProjectTimeId"]).HasValue) ddlLunch.SelectedValue = Math.Round(teamProjectTime2Gateway.GetOffset((int)ViewState["teamProjectTimeId"]).Value, 2).ToString(); // ... for meals country if (!deleted) { if (teamProjectTime2Gateway.GetMealsCountry((int)ViewState["teamProjectTimeId"]).HasValue) { ddlMealsCountry.SelectedValue = teamProjectTime2Gateway.GetMealsCountry((int)ViewState["teamProjectTimeId"]).Value.ToString(); } else { ddlMealsCountry.SelectedIndex = 0; } } else { ddlMealsCountry.SelectedIndex = -1; } // ... for meals allowance //if (teamProjectTime2Gateway.GetMealsAllowance((int)ViewState["teamProjectTimeId"]) > 0) cbxMealsAllowance.Checked = true; // ... for fair wage if (teamProjectTime2Gateway.GetFairWage((int)ViewState["teamProjectTimeId"])) hdfFairWage.Value = "True"; // Store datasets Session["teamProjectTime2TDS"] = teamProjectTime2TDS; template = teamProjectTime2TDS.Template; Session["template"] = teamProjectTime2TDS.Template; } //cbxClearUnitAssigment.Checked = false; }
private void DeleteTemplate(int teamProjectTimeId) { // Create TDS to save teamProjectTime2TDSToSave = new TeamProjectTime2TDS(); // Delete Template TeamProjectTime2Template teamProjectTime2Template = new TeamProjectTime2Template(teamProjectTime2TDS); teamProjectTime2Template.Delete(teamProjectTimeId); // ... Store datasets for teplate Session.Remove("templateDummy"); Session["teamProjectTime2TDS"] = teamProjectTime2TDS; template = teamProjectTime2TDS.Template; Session["template"] = teamProjectTime2TDS.Template; // Delete associated TeamProjectTime to Template // ... load TeamProjectTime TeamProjectTime2Gateway teamProjectTime2Gateway = new TeamProjectTime2Gateway(teamProjectTime2TDSToSave); teamProjectTime2Gateway.LoadByTeamProjectTimeId(teamProjectTimeId); // ... delete TeamProjectTime TeamProjectTime2 teamProjectTime2 = new TeamProjectTime2(teamProjectTime2TDSToSave); teamProjectTime2.Delete(teamProjectTimeId); // Delete associated TeamProjectTimeDetails to Template // ... load TeamProjectTimeDetails TeamProjectTime2DetailGateway teamProjectTime2DetailGateway = new TeamProjectTime2DetailGateway(teamProjectTime2TDSToSave); teamProjectTime2DetailGateway.LoadByTeamProjectTimeId(teamProjectTimeId); // ... delete TeamProjectTimeDetails TeamProjectTime2Detail teamProjectTime2Detail = new TeamProjectTime2Detail(teamProjectTime2TDSToSave); teamProjectTime2Detail.Delete(teamProjectTimeId); }
protected void SaveSelectedId() { int idForUpdate = 0; bool selected = false; hdfSelectedIdTemplate.Value = "0"; TeamProjectTime2Template teamProjectTime2Template = new TeamProjectTime2Template(teamProjectTime2TDS); foreach (GridViewRow row in grdTemplate.Rows) { // ... Update all rows selected = ((CheckBox)row.FindControl("cbxSelected")).Checked; idForUpdate = Int32.Parse(((Label)row.FindControl("lblTeamProjectTimeID")).Text.Trim()); teamProjectTime2Template.Update(idForUpdate, selected); // ... Save selected project if (selected) { hdfSelectedIdTemplate.Value = idForUpdate.ToString(); } } teamProjectTime2Template.Data.AcceptChanges(); // Store datasets Session["teamProjectTime2TDS"] = teamProjectTime2TDS; template = teamProjectTime2TDS.Template; Session["template"] = teamProjectTime2TDS.Template; }
// //////////////////////////////////////////////////////////////////////// // INITIAL EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"])) { if (!(Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_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 Session.Remove("teamProjectTime2TDS"); Session.Remove("sectionsReinstatePostVideoSelect"); Session.Remove("template"); Session.Remove("templateDummy"); Session.Remove("teamProjectTimeDetailTemp"); Session.Remove("teamProjectTimeDetailTempDummy"); Session.Remove("teamProjectTimeSection"); Session.Remove("teamProjectTimeSectionDummy"); Session.Remove("teamProjectTimeSectionLateral"); Session.Remove("teamProjectTimeSectionLateralDummy"); Session.Remove("teamProjectTimeSectionMH"); Session.Remove("teamProjectTimeSectionMHDummy"); hdfCompanyId.Value = Session["companyID"].ToString(); hdfBtnNext.Value = "False"; // Initialize variables lblMessage.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(); ViewState["StepFrom"] = "Out"; ViewState["teamProjectTimeId"] = 0; // ... Prepare initial data for template odsTemplate.SelectParameters.RemoveAt(0); odsTemplate.SelectParameters.Add("loginId", Convert.ToInt32(Session["loginID"]).ToString()); odsTemplate.Select(); // Store datasets teamProjectTime2TDS = new TeamProjectTime2TDS(); Session["teamProjectTime2TDS"] = teamProjectTime2TDS; template = teamProjectTime2TDS.Template; Session["template"] = teamProjectTime2TDS.Template; teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; teamProjectTimeSection = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION; Session["teamProjectTimeSection"] = teamProjectTimeSection; teamProjectTimeSectionLateral = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION_LATERAL; Session["teamProjectTimeSectionLateral"] = teamProjectTimeSectionLateral; teamProjectTimeSectionMH = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION_MH; Session["teamProjectTimeSectionMH"] = teamProjectTimeSectionMH; Session["sectionsReinstatePostVideoSelect"] = sectionsReinstatePostVideoSelect; // StepSection1In wzTeam.ActiveStepIndex = 0; StepBeginIn(); } else { // Restore datasets teamProjectTime2TDS = (TeamProjectTime2TDS)Session["teamProjectTime2TDS"]; template = teamProjectTime2TDS.Template; Session["template"] = teamProjectTime2TDS.Template; teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; teamProjectTimeSection = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION; Session["teamProjectTimeSection"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION; teamProjectTimeSectionLateral = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION_LATERAL; Session["teamProjectTimeSectionLateral"] = teamProjectTimeSectionLateral; teamProjectTimeSectionMH = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_SECTION_MH; Session["teamProjectTimeSectionMH"] = teamProjectTimeSectionMH; sectionsReinstatePostVideoSelect = (ArrayList)Session["sectionsReinstatePostVideoSelect"]; } }
protected void AddTimesheetTemplateNewEmptyFix(GridView grdTemplate) { if (grdTemplate.Rows.Count == 0) { TeamProjectTime2TDS.TemplateDataTable dt = new TeamProjectTime2TDS.TemplateDataTable(); dt.AddTemplateRow("", "", "", "", false, false); Session["templateDummy"] = dt; grdTemplate.DataBind(); } // normally executes at all postbacks if (grdTemplate.Rows.Count == 1) { TeamProjectTime2TDS.TemplateDataTable dt = (TeamProjectTime2TDS.TemplateDataTable)Session["templateDummy"]; if (dt != null) { grdTemplate.Rows[0].Visible = false; grdTemplate.Rows[0].Controls.Clear(); } } }
// //////////////////////////////////////////////////////////////////////// // STEP2 - TEMPLATE - PUBLIC METHODS // public TeamProjectTime2TDS.TemplateDataTable GetTimesheetsTemplate() { template = (TeamProjectTime2TDS.TemplateDataTable)Session["templateDummy"]; if (template == null) { template = ((TeamProjectTime2TDS.TemplateDataTable)Session["template"]); } return template; }