// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_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["repair_point_id"] == null) || ((string)Request.QueryString["work_id"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in pr_size.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfRepairPointId.Value = Convert.ToString(Request.QueryString["repair_point_id"]); hdfWorkId.Value = Convert.ToString(Request.QueryString["work_id"]); hdfUpdate.Value = "yes"; Session.Remove("sizeInformationNewDummy"); Session.Remove("sizeInformation"); // If comming from // ... pr_edit.aspx if (Request.QueryString["source_page"] == "pr_edit.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // ... Load size to edit pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"]; sizeInformationTDS = new SizeInformationTDS(); SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationTDS); sizeInformationGateway.Load(Int32.Parse(hdfCompanyId.Value.Trim())); // ... Store datasets Session["sizeInformationTDS"] = sizeInformationTDS; Session["sizeInformation"] = sizeInformationTDS.SizeInformation; } } else { // Restore datasets pointRepairsTDS = (PointRepairsTDS)Session["pointRepairsTDS"]; sizeInformationTDS = (SizeInformationTDS)Session["sizeInformationTDS"]; sizeInformation = sizeInformationTDS.SizeInformation; } }
protected void cvSizeEdit_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = true; string originalSize = ((HiddenField)grdSize.Rows[grdSize.EditIndex].Cells[2].FindControl("hdfSizeEdit")).Value; if (originalSize != args.Value.Trim()) { SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationTDS); if (sizeInformationGateway.Table.Rows.Count > 0) { foreach (SizeInformationTDS.SizeInformationRow row in (SizeInformationTDS.SizeInformationDataTable)sizeInformationGateway.Table) { if (row.Size_ == args.Value.Trim()) { args.IsValid = false; } } } } }
protected void cvSizeNew_ServerValidate(object source, ServerValidateEventArgs args) { args.IsValid = true; SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationTDS); if (sizeInformationGateway.Table.Rows.Count > 0) { foreach (SizeInformationTDS.SizeInformationRow row in (SizeInformationTDS.SizeInformationDataTable)sizeInformationGateway.Table) { if (row.Size_ == args.Value.Trim()) { args.IsValid = false; } } } }
/// <summary> /// Save all size to database (direct) /// </summary> /// <param name="companyId">companyId</param> public void Save(int companyId) { SizeInformationTDS sizeInformationChanges = (SizeInformationTDS)Data.GetChanges(); if (sizeInformationChanges != null) { if (sizeInformationChanges.SizeInformation.Rows.Count > 0) { SizeInformationGateway sizeInformationGateway = new SizeInformationGateway(sizeInformationChanges); foreach (SizeInformationTDS.SizeInformationRow row in (SizeInformationTDS.SizeInformationDataTable)sizeInformationChanges.SizeInformation) { // Insert new size if ((!row.Deleted) && (!row.InDatabase)) { WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway(); WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null); workPointRepairsRepairPointSizeGateway.LoadAllBySize_(row.Size_, row.COMPANY_ID); if (workPointRepairsRepairPointSizeGateway.Table.Rows.Count == 0) { workPointRepairsRepairPointSize.InsertDirect(row.Size_, row.COMPANY_ID, row.Deleted); } else { workPointRepairsRepairPointSize.UnDeleteDirect(row.Size_, row.COMPANY_ID); } } // Update size if ((!row.Deleted) && (row.InDatabase)) { string originalSize_ = row.NewSize_; string newSize_ = row.Size_; int originalCompanyId = companyId; WorkPointRepairsRepairPointSizeGateway workPointRepairsRepairPointSizeGateway = new WorkPointRepairsRepairPointSizeGateway(); WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null); workPointRepairsRepairPointSizeGateway.LoadAllBySize_(newSize_, companyId); if (workPointRepairsRepairPointSizeGateway.Table.Rows.Count == 0) { workPointRepairsRepairPointSize.InsertDirect(newSize_, originalCompanyId, false); } else { workPointRepairsRepairPointSize.UnDeleteDirect(newSize_, originalCompanyId); } if (workPointRepairsRepairPointSizeGateway.IsUsedInPointRepair(originalSize_, companyId)) { WorkPointRepairsRepairGateway workPointRepairsRepairGateway = new WorkPointRepairsRepairGateway(null); workPointRepairsRepairGateway.UpdateSize(originalSize_, companyId, newSize_, companyId); } workPointRepairsRepairPointSize.DeleteDirect(originalSize_, companyId); } // Delete size if ((row.Deleted) && (row.InDatabase)) { WorkPointRepairsRepairPointSize workPointRepairsRepairPointSize = new WorkPointRepairsRepairPointSize(null); workPointRepairsRepairPointSize.DeleteDirect(row.Size_, row.COMPANY_ID); } } } } }