private bool PostStepEndChanges(int companyId) { // Update project times projectTime2TDS = new ProjectTimeTDS(); if (cbxEndConfirm.Checked) { EmployeeGateway employeeGateway = new EmployeeGateway(new DataSet()); int employeeId = employeeGateway.GetEmployeIdByLoginId(Convert.ToInt32(Session["loginID"])); TeamProjectTime2Detail teamProjectTime2Detail = new TeamProjectTime2Detail(teamProjectTime2TDS); string error = teamProjectTime2Detail.MoveToProjectTime(projectTime2TDS, (string)ViewState["LHMode"], Convert.ToBoolean(Session["sgLFS_LABOUR_HOURS_FULL_EDITING"]), ddlTypeOfWork.SelectedValue, ddlFunction.SelectedValue, companyId, employeeId); if (error != "") { return false; } } // Update team project time teamProjectTime2TDSToSave = new TeamProjectTime2TDS(); if (cbxEndSave.Checked) { TeamProjectTime2 teamProjectTime2 = new TeamProjectTime2(teamProjectTime2TDS); if (rbtnEndSaveNew.Checked) { teamProjectTime2.Insert((int)ViewState["teamProjectTimeId"], tbxEndSaveNew.Text.Trim(), teamProjectTime2TDSToSave); } else { teamProjectTime2.Update((int)ViewState["teamProjectTimeId"], int.Parse(luEndSaveTemplate.SelectedValue.ToString()), teamProjectTime2TDSToSave); } } return true; }
/// <summary> /// Insert /// </summary> /// <param name="teamProjectTimeId">teamProjectTimeId</param> /// <param name="newTemplateName">newTemplateName</param> /// <param name="teamProjectTime2TDSToSave">teamProjectTime2TDSToSave</param> public void Insert(int teamProjectTimeId, string newTemplateName, TeamProjectTime2TDS teamProjectTime2TDSToSave) { // Insert master row TeamProjectTime2TDS.LFS_TEAM_PROJECT_TIMERow masterRow = GetRow(teamProjectTimeId); int companiesId = masterRow.CompaniesID; int projectId = masterRow.ProjectID; DateTime date_ = masterRow.Date_; DateTime? startTime = null; if (!masterRow.IsNull("StartTime")) startTime = masterRow.StartTime; DateTime? endTime = null; if (!masterRow.IsNull("EndTime")) endTime = masterRow.EndTime; double? offset = null; if (!masterRow.IsNull("Offset")) offset = masterRow.Offset; string workingDetails = ""; if (!masterRow.IsNull("WorkingDetails")) workingDetails = masterRow.WorkingDetails; string location = ""; if (!masterRow.IsNull("Location")) location = masterRow.Location; Int64? mealsCountry = null; if (!masterRow.IsNull("MealsCountry")) mealsCountry = masterRow.MealsCountry; String mealsAllowanceType = ""; if (!masterRow.IsNull("MealsAllowanceType")) mealsAllowanceType = masterRow.MealsAllowanceType; decimal mealsAllowance = masterRow.MealsAllowance; int? unitId = null; if (!masterRow.IsNull("UnitID")) unitId = masterRow.UnitID; int? towedUnitId = null; if (!masterRow.IsNull("TowedUnitID")) towedUnitId = masterRow.TowedUnitID; string comments = ""; if (!masterRow.IsNull("Comments")) comments = masterRow.Comments; string type = "Template"; string state = "Done"; int loginId = masterRow.LoginID; bool deleted = false; string work_ = masterRow.Work_; string function_ = masterRow.Function_; bool fairWage = masterRow.FairWage; TeamProjectTime2 teamProjectTime2ToSave = new TeamProjectTime2(teamProjectTime2TDSToSave); teamProjectTime2ToSave.Insert(0, newTemplateName, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage); // Insert detail rows TeamProjectTime2Detail teamProjectTime2Detail = new TeamProjectTime2Detail(Data); teamProjectTime2Detail.Insert(teamProjectTimeId, teamProjectTime2TDSToSave); }
private void PostStepDataChanges() { int teamProjectTimeId = (int)ViewState["teamProjectTimeId"]; string templateName = ""; int companiesId = int.Parse(ddlClient.SelectedValue); int projectId = int.Parse(ddlProject.SelectedValue); DateTime date_ = tkrdpDate_.SelectedDate.Value; string workingDetails = ""; if (tbxWorkingDetails.Text != "(Select)") workingDetails = tbxWorkingDetails.Text; string work_ = ddlTypeOfWork.SelectedValue; string function_ = ddlFunction.SelectedValue; ProjectGateway projectGateway = new ProjectGateway(new DataSet()); projectGateway.LoadByProjectId(projectId); CountryGateway countryGateway = new CountryGateway(new DataSet()); countryGateway.LoadByCountryId(projectGateway.GetCountryID(projectId)); string location = countryGateway.GetName(projectGateway.GetCountryID(projectId)); DateTime? startTime = null; if ((ddlStartTimeHour.SelectedValue.Trim() != "") && (ddlStartTimeMinute.SelectedValue.Trim() != "") ) { startTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlStartTimeHour.SelectedValue), Int32.Parse(ddlStartTimeMinute.SelectedValue), 0); } DateTime? endTime = null; if ((ddlEndTimeHour.SelectedValue.Trim() != "") && (ddlEndTimeMinute.SelectedValue.Trim() != "") ) { endTime = new DateTime(date_.Year, date_.Month, date_.Day, Int32.Parse(ddlEndTimeHour.SelectedValue), Int32.Parse(ddlEndTimeMinute.SelectedValue), 0); } double? offset = 0; if (ddlLunch.SelectedValue != "0") offset = double.Parse(ddlLunch.SelectedValue); Int64? mealsCountry = null; if (ddlMealsCountry.SelectedValue != "-1") mealsCountry = Int64.Parse(ddlMealsCountry.SelectedValue); string mealsAllowanceType = ""; //if (cbxMealsAllowance.Checked) mealsAllowanceType = "Full Day"; decimal mealsAllowance = MealsAllowance.GetMealsAllowance(mealsCountry, false, "Full Day"); string comments = ""; string type = "Template"; string state = "Done"; int loginId = Convert.ToInt32(Session["loginID"]); bool deleted = false; int? unitId = null; int? towedUnitId = null; bool fairWage = false; if (hdfFairWage.Value == "True") fairWage = true; // New template check TeamProjectTime2 teamProjectTime2 = new TeamProjectTime2(teamProjectTime2TDS); if (((int)ViewState["teamProjectTimeId"] == 0) && ((string)ViewState["StepFrom"] != "Employees")) { // ... Insert team project time teamProjectTime2.Insert(teamProjectTimeId, templateName, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage); } else { // ... Update team project time teamProjectTime2.Update(teamProjectTimeId, templateName, companiesId, projectId, date_, startTime, endTime, offset, workingDetails, location, mealsCountry, mealsAllowanceType, mealsAllowance, unitId, towedUnitId, comments, type, state, loginId, deleted, work_, function_, fairWage); } // Store date in date edit for employees step tbxDate.Text = tkrdpDate_.SelectedDate.Value.ToString(); hdfDate.Value = tkrdpDate_.SelectedDate.Value.ToString(); // Store data in hidden components for employees step hdfTeamProjectTimeID.Value = teamProjectTimeId.ToString(); hdfCompaniesID.Value = companiesId.ToString(); hdfProjectID.Value = projectId.ToString(); string startTimeForNextStep = ""; if ((ddlStartTimeHour.SelectedValue.Trim() != "") && (ddlStartTimeMinute.SelectedValue.Trim() != "")) { startTimeForNextStep = ddlStartTimeHour.SelectedValue.Trim() + ":" + ddlStartTimeMinute.SelectedValue.Trim(); } hdfStartTime.Value = startTimeForNextStep; string endTimeForNextStep = ""; if ((ddlEndTimeHour.SelectedValue.Trim() != "") && (ddlEndTimeMinute.SelectedValue.Trim() != "")) { endTimeForNextStep = ddlEndTimeHour.SelectedValue.Trim() + ":" + ddlEndTimeMinute.SelectedValue.Trim(); } hdfEndTime.Value = endTimeForNextStep; if (offset != null) hdfOffset.Value = offset.ToString(); else hdfOffset.Value = ""; hdfWorkingDetails.Value = workingDetails.ToString(); hdfLocation.Value = location.ToString(); hdfMealsCountry.Value = ddlMealsCountry.SelectedValue; hdfIsMealsAllowance.Value = "false";// cbxMealsAllowance.Checked.ToString(); hdfMealsAllowance.Value = mealsAllowance.ToString(); hdfProjectTimeState.Value = "For Approval"; if ((string)ViewState["LHMode"] == "Partial") hdfProjectTimeState.Value = "Approved"; //if (cbxClearUnitAssigment.Checked) hdfClearUnitAssigment.Value = "false"; // ... For work and function string hdfWork_.Value = work_; hdfFunction_.Value = function_; hdfWorkFunctionConcat.Value = work_ + " . " + function_; // Clear Unit Assigment validation //if (cbxClearUnitAssigment.Checked) //{ // // ... Update detail // TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS); // teamProjectTime2DetailTemp.UpdateAll(teamProjectTimeId); //} //else //{ // ... Update detail TeamProjectTime2DetailTemp teamProjectTime2DetailTemp = new TeamProjectTime2DetailTemp(teamProjectTime2TDS); teamProjectTime2DetailTemp.UpdateAll(teamProjectTimeId, false); //} // Store datasets Session["teamProjectTime2TDS"] = teamProjectTime2TDS; teamProjectTimeDetailTemp = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; Session["teamProjectTimeDetailTemp"] = teamProjectTime2TDS.LFS_TEAM_PROJECT_TIME_DETAIL_TEMP; }