protected void grdCosts_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("costsDataEdit"); if (Page.IsValid) { int serviceId = (int)e.Keys["ServiceID"]; int refId = (int)e.Keys["RefID"]; int companyId = Int32.Parse(hdfCompanyId.Value); string partNumber = ((TextBox)grdCosts.Rows[e.RowIndex].Cells[2].FindControl("tbxPartNumber")).Text.Trim(); string partName = ((TextBox)grdCosts.Rows[e.RowIndex].Cells[3].FindControl("tbxPartName")).Text.Trim(); string vendor = ((TextBox)grdCosts.Rows[e.RowIndex].Cells[4].FindControl("tbxVendor")).Text.Trim(); decimal cost = decimal.Parse(((TextBox)grdCosts.Rows[e.RowIndex].Cells[5].FindControl("tbxCost")).Text.Trim()); // Update data ServiceRequestsManagerToolCostInformation model = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS); model.Update(serviceId, refId, partNumber, partName, vendor, cost); // Store dataset Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS; Session["costInformationManagerTool"] = serviceRequestsManagerToolTDS.CostInformation; // Calc TotalCost tbxTotalCost.Text = Decimal.Round(model.GetTotalCost(serviceId, companyId), 2).ToString(); } else { e.Cancel = true; } }
// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP2 - STEPS INFORMATION // // //////////////////////////////////////////////////////////////////////// // STEP2 - STEPS INFORMATION - EVENTS // protected void grdCosts_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Costs Gridview, if the gridview is edition mode if (grdCosts.EditIndex >= 0) { grdCosts.UpdateRow(grdCosts.EditIndex, true); } // Delete costs int serviceId = (int)e.Keys["ServiceID"]; int refId = (int)e.Keys["RefID"]; int companyId = Int32.Parse(hdfCompanyId.Value); ServiceRequestsManagerToolCostInformation model = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS); model.Delete(serviceId, refId); // Store dataset Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS; Session["costInformationManagerTool"] = serviceRequestsManagerToolTDS.CostInformation; // Calc TotalCost tbxTotalCost.Text = Decimal.Round(model.GetTotalCost(serviceId, companyId), 2).ToString(); }
// //////////////////////////////////////////////////////////////////////// // STEP2 - STEPS INFORMATION - METHODS // private void StepStepsInformationIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = ""; // Load data for selected service request int serviceId = Int32.Parse(hdfSelectedSRId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); ServiceRequestsManagerToolBasicInformation serviceRequestsManagerToolBasicInformation = new ServiceRequestsManagerToolBasicInformation(serviceRequestsManagerToolTDS); ServiceRequestsManagerToolCostInformation serviceRequestsManagerToolCostInformation = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS); ServiceInformationServiceNote serviceInformationServiceNoteForEdit = new ServiceInformationServiceNote(serviceInformationTDS); if (Session["dialogOpenedServicesManagerTool"] == null) { // ... Load basic data serviceRequestsManagerToolBasicInformation.LoadByServiceId(serviceId, companyId); // ... Load costs serviceRequestsManagerToolCostInformation.LoadByServiceId(serviceId, companyId); //... Load notes serviceInformationServiceNoteForEdit.LoadByServiceId(serviceId, companyId); } else { ServiceRequestsManagerToolBasicInformationGateway serviceRequestsManagerToolBasicInformationGateway2 = new ServiceRequestsManagerToolBasicInformationGateway(serviceRequestsManagerToolBasicInformation.Data); Session.Remove("dialogOpenedServicesManagerTool"); if (serviceRequestsManagerToolBasicInformationGateway2.GetAcceptedDateTime(serviceId).HasValue) ckbxAcceptSR.Checked = true; if (serviceRequestsManagerToolBasicInformationGateway2.GetStartWorkDateTime(serviceId).HasValue) ckbxStartSR.Checked = true; if (serviceRequestsManagerToolBasicInformationGateway2.GetUnitOutOfServiceDate(serviceId).HasValue) tkrdpStartWorkUnitOutOfServiceDate.SelectedDate = serviceRequestsManagerToolBasicInformationGateway2.GetUnitOutOfServiceDate(serviceId); tbxStartWorkStartMileage.Text = serviceRequestsManagerToolBasicInformationGateway2.GetStartWorkMileage(serviceId); if (serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkDateTime(serviceId).HasValue) ckbxCompleteSR.Checked = true; if (serviceRequestsManagerToolBasicInformationGateway2.GetUnitBackInServiceDate(serviceId).HasValue) tkrdpCompleteWorkUnitBackInServiceDate.SelectedDate = serviceRequestsManagerToolBasicInformationGateway2.GetUnitBackInServiceDate(serviceId); tbxCompleteWorkCompleteMileage.Text = serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkMileage(serviceId); tbxCompleteWorkDataDescription.Text = serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkDetailDescription(serviceId); ckbxPreventableTPV.Checked = serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkDetailPreventable(serviceId); tbxCompleteWorkDataLabourHours.Text = serviceRequestsManagerToolBasicInformationGateway2.GetCompleteWorkDetailTMLabourHours(serviceId).ToString(); } ServiceRequestsManagerToolBasicInformationGateway serviceRequestsManagerToolBasicInformationGateway = new ServiceRequestsManagerToolBasicInformationGateway(serviceRequestsManagerToolBasicInformation.Data); // Validate panels and information string state = serviceRequestsManagerToolBasicInformationGateway.GetServiceStateOriginal(serviceId); hdfState.Value = state; hdfServiceNumber.Value = serviceRequestsManagerToolBasicInformationGateway.GetServiceNumberOriginal(serviceId); hdfServiceDescription.Value = serviceRequestsManagerToolBasicInformationGateway.GetServiceDescriptionOriginal(serviceId); string originalThirdsPartyVendor = serviceRequestsManagerToolBasicInformationGateway.GetAssignedThirdPartyVendor(serviceId); int? unitId = null; if (serviceRequestsManagerToolBasicInformationGateway.GetUnitId(serviceId).HasValue) { unitId = (int)serviceRequestsManagerToolBasicInformationGateway.GetUnitId(serviceId); hdfUnitId.Value = unitId.ToString(); } // ... Validate vehicle information if (unitId.HasValue) { UnitsGateway unitsGateway = new UnitsGateway(); unitsGateway.LoadByUnitId((int)unitId, companyId); string unitType = unitsGateway.GetType((int)unitId); hdfUnitType.Value = unitType; int companyLevel = unitsGateway.GetCompanyLevelId((int)unitId); hdfCompanyLevel.Value = unitsGateway.GetCompanyLevelId((int)unitId).ToString(); CompanyLevelGateway companyLevelGateway = new CompanyLevelGateway(); companyLevelGateway.LoadByCompanyLevelId(companyLevel, companyId); hdfMileageUnitOfMeasurement.Value = companyLevelGateway.GetUnitsUnitOfMeasurement(companyLevel); lblStartWorkStartMileageUnitOfMeasurement.Text = hdfMileageUnitOfMeasurement.Value; lblCompleteWorkCompleteMileageUnitOfMeasurement.Text = hdfMileageUnitOfMeasurement.Value; if (unitType == "Vehicle") { lblStartWorkStartMileage.Visible = true; tbxStartWorkStartMileage.Visible = true; lblCompleteWorkCompleteMileage.Visible = true; tbxCompleteWorkCompleteMileage.Visible = true; lblStartWorkStartMileageUnitOfMeasurement.Visible = true; lblCompleteWorkCompleteMileageUnitOfMeasurement.Visible = true; } else { lblStartWorkStartMileage.Visible = false; tbxStartWorkStartMileage.Visible = false; lblStartWorkStartMileageUnitOfMeasurement.Visible = false; lblCompleteWorkCompleteMileage.Visible = false; tbxCompleteWorkCompleteMileage.Visible = false; lblCompleteWorkCompleteMileageUnitOfMeasurement.Visible = false; } } // ... Validate visible internal panels (complete work info) if (state == "Unassigned") { if (!rbtnAssignToThirdPartyVendor.Checked) { pnlAssignTeamMember.Visible = true; pnlAssignThirdPartyVendor.Visible = false; } else { pnlAssignThirdPartyVendor.Visible = true; pnlAssignTeamMember.Visible = false; } } else { bool teamMemberAssigned = serviceRequestsManagerToolBasicInformationGateway.GetAssignTeamMember(serviceId); if (teamMemberAssigned) { pnlAssignTeamMember.Visible = true; pnlAssignThirdPartyVendor.Visible = false; } else { pnlAssignThirdPartyVendor.Visible = true; pnlAssignTeamMember.Visible = false; } } // ... Validate panels switch (state) { case "Unassigned": pnlAssignmentInformation.Visible = true; acceptInformationSeparator.Visible = true; pnlAcceptInformation.Visible = true; startWorkSeparator.Visible = true; pnlStartWorkInformation.Visible = true; completeWorkSeparator.Visible = true; pnlCompleteWorkInformation.Visible = true; break; case "Assigned": pnlAssignmentInformation.Visible = false; acceptInformationSeparator.Visible = false; pnlAcceptInformation.Visible = true; startWorkSeparator.Visible = true; pnlStartWorkInformation.Visible = true; completeWorkSeparator.Visible = true; pnlCompleteWorkInformation.Visible = true; break; case "Rejected": pnlAssignmentInformation.Visible = true; acceptInformationSeparator.Visible = true; pnlAcceptInformation.Visible = true; startWorkSeparator.Visible = true; pnlStartWorkInformation.Visible = true; completeWorkSeparator.Visible = true; pnlCompleteWorkInformation.Visible = true; break; case "Accepted": pnlAssignmentInformation.Visible = false; acceptInformationSeparator.Visible = false; pnlAcceptInformation.Visible = false; startWorkSeparator.Visible = false; pnlStartWorkInformation.Visible = true; completeWorkSeparator.Visible = true; pnlCompleteWorkInformation.Visible = true; break; case "In Progress": pnlAssignmentInformation.Visible = false; acceptInformationSeparator.Visible = false; pnlAcceptInformation.Visible = false; startWorkSeparator.Visible = false; pnlStartWorkInformation.Visible = false; completeWorkSeparator.Visible = false; pnlCompleteWorkInformation.Visible = true; break; default: throw new Exception("The option for " + wzServices.ActiveStep.Name + " step in services_manager_tool.Wizard_ActiveStepChanged function does not exist"); } hdfPnlAcceptInformation.Value = pnlAcceptInformation.Visible.ToString(); hdfPnlAssignmentInformation.Value = pnlAssignmentInformation.Visible.ToString(); hdfPnlStartWorkInformation.Value = pnlStartWorkInformation.Visible.ToString(); hdfPnlCompleteWorkInformation.Value = pnlCompleteWorkInformation.Visible.ToString(); // ... Load resource library int? libraryCategoriesId = null; if (serviceRequestsManagerToolBasicInformationGateway.GetLibraryCategoriesId(serviceId).HasValue) libraryCategoriesId = (int)serviceRequestsManagerToolBasicInformationGateway.GetLibraryCategoriesId(serviceId); if (libraryCategoriesId.HasValue) { ViewState["libraryCategoriesId"] = (int)libraryCategoriesId; tbxCategoryAssocited.Text = GetFullCategoryName((int)libraryCategoriesId, companyId); btnAssociate.Visible = false; btnUnassociate.Visible = true; } else { tbxCategoryAssocited.Text = ""; btnAssociate.Visible = true; btnUnassociate.Visible = false; } // Store session Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS; }
private void UpdateDatabase() { LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway(libraryTDSForServices); libraryFilesGateway.Update(); DB.Open(); DB.BeginTransaction(); try { int companyId = Int32.Parse(hdfCompanyId.Value); int serviceId = Int32.Parse(hdfSelectedSRId.Value); ServiceRequestsManagerToolBasicInformation serviceRequestsManagerToolBasicInformation = new ServiceRequestsManagerToolBasicInformation(serviceRequestsManagerToolTDS); serviceRequestsManagerToolBasicInformation.Save(companyId); // Save costs information ServiceRequestsManagerToolCostInformation serviceRequestsManagerToolCostInformation = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS); serviceRequestsManagerToolCostInformation.Save((int)serviceId, companyId); // Save notes information ServiceInformationServiceNoteGateway serviceInformationServiceNoteGateway = new ServiceInformationServiceNoteGateway(serviceInformationTDS); ServiceInformationServiceNote serviceInformationServiceNote = new ServiceInformationServiceNote(serviceInformationTDS); foreach (ServiceInformationTDS.NoteInformationRow rowNotes in (ServiceInformationTDS.NoteInformationDataTable)serviceInformationServiceNoteGateway.Table) { if (!rowNotes.IsLIBRARY_FILES_IDNull()) { if (rowNotes.LIBRARY_FILES_ID == 0 && rowNotes.FILENAME != "") { libraryFilesGateway.LoadByFileName(rowNotes.FILENAME, companyId); int newLibraryFilesId = libraryFilesGateway.GetlibraryFilesId(rowNotes.FILENAME); rowNotes.LIBRARY_FILES_ID = newLibraryFilesId; } } } // Save notes information serviceInformationServiceNote.Save(companyId); DB.CommitTransaction(); // Store datasets serviceRequestsManagerToolTDS.AcceptChanges(); Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS; // Store datasets libraryTDSForServices.AcceptChanges(); serviceInformationTDS.AcceptChanges(); Session["serviceInformationTDSForManagerTool"] = serviceInformationTDS; Session["libraryTDSForServices"] = libraryTDSForServices; Session.Remove("libraryTDSForServices"); Session.Remove("serviceInformationTDSForManagerTool"); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void GrdCostsAdd() { if (ValidateCostsFooter()) { Page.Validate("costsDataAdd"); if (Page.IsValid) { int serviceId = 1; int companyId = Int32.Parse(hdfCompanyId.Value); string newPartNumber = ((TextBox)grdCosts.FooterRow.FindControl("tbxPartNumberNew")).Text.Trim(); string newPartName = ((TextBox)grdCosts.FooterRow.FindControl("tbxPartNameNew")).Text.Trim(); string newVendor = ((TextBox)grdCosts.FooterRow.FindControl("tbxVendorNew")).Text.Trim(); decimal newCost = Decimal.Round(Decimal.Parse(((TextBox)grdCosts.FooterRow.FindControl("tbxCostNew")).Text.Trim()), 2); ServiceRequestsManagerToolCostInformation model = new ServiceRequestsManagerToolCostInformation(serviceRequestsManagerToolTDS); model.Insert(serviceId, newPartNumber, newPartName, newVendor, newCost, false, companyId); Session.Remove("serviceCostsDummyManagerTool"); Session["serviceRequestsManagerToolTDS"] = serviceRequestsManagerToolTDS; Session["costInformationManagerTool"] = serviceRequestsManagerToolTDS.CostInformation; // Calc TotalCost tbxTotalCost.Text = Decimal.Round(model.GetTotalCost(serviceId, companyId), 2).ToString(); grdCosts.DataBind(); grdCosts.PageIndex = grdCosts.PageCount - 1; } } }