/// <summary> /// Delete /// </summary> /// <param name="costId">costId</param> public void Delete(int costId, int unitId) { UnitInformationTDS.CostInformationRow row = GetRow(costId); row.Deleted = true; UnitInformationCostExceptionsInformation model = new UnitInformationCostExceptionsInformation(Data); model.DeleteAll(costId); }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"]) && (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_EDIT"]) || Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_COMMENTS"])))) { 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["unit_id"] == null) || ((string)Request.QueryString["unit_type"] == null) || ((string)Request.QueryString["unit_state"] == null) || ((string)Request.QueryString["active_tab"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in units_summary.aspx"); } // Tag Page hdfUnitId.Value = Request.QueryString["unit_id"].ToString(); hdfUnitType.Value = Request.QueryString["unit_type"].ToString(); hdfUnitState.Value = Request.QueryString["unit_state"].ToString(); hdfActiveTab.Value = Request.QueryString["active_tab"].ToString(); hdfCompanyId.Value = Session["companyID"].ToString(); hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString(); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int unitId = Int32.Parse(hdfUnitId.Value.Trim()); Session.Remove("unitsChecklistRulesTempDummy"); Session.Remove("unitsServicesTempDummy"); Session.Remove("unitsInspectionsTempDummy"); Session.Remove("unitsNotesTempDummy"); Session.Remove("unitsCostsDummy"); Session.Remove("unitsCostsExceptionsDummy"); Session.Remove("costIdSelected"); // If coming from // ... units_navigator2.aspx or wucAlarms.ascx.cs if ((Request.QueryString["source_page"] == "units_navigator2.aspx") || (Request.QueryString["source_page"] == "wucAlarms.ascx")) { StoreNavigatorState(); ViewState["update"] = "no"; // ... ... Set initial tab if ((string)Session["dialogOpenedUnits"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; unitInformationTDS = new UnitInformationTDS(); unitsChecklistRulesTemp = new UnitInformationTDS.ChecklistDetailsDataTable(); unitsServicesTemp = new UnitInformationTDS.ServiceDetailsDataTable(); unitsInspectionsTemp = new UnitInformationTDS.InspectionDetailsDataTable(); unitsNotesTemp = new UnitInformationTDS.NoteInformationDataTable(); UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.LoadByUnitId(unitId, companyId); UnitInformationInspectionDetails unitInformationInspectionDetailsForEdit = new UnitInformationInspectionDetails(unitInformationTDS); unitInformationInspectionDetailsForEdit.LoadByUnitId(unitId, companyId); UnitInformationNoteDetails unitInformationNoteDetails = new UnitInformationNoteDetails(unitInformationTDS); unitInformationNoteDetails.LoadByUnitId(unitId, companyId); UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS); unitInformationCostInformation.LoadAllByUnitId(unitId, companyId); UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS); unitInformationCostExceptionsInformation.LoadAllByUnitId(unitId, companyId); Session["costIdSelected"] = 0; // ... For Categories categoriesTDS = new CategoriesTDS(); Category category = new Category(categoriesTDS); category.LoadByUnitType(hdfUnitType.Value, int.Parse(hdfCompanyId.Value)); // .. For Company Levels companyLevelsTDS = new CompanyLevelsTDS(); CompanyLevel companyLevel = new CompanyLevel(companyLevelsTDS); companyLevel.Load(int.Parse(hdfCompanyId.Value)); } else { hdfActiveTab.Value = (string)Session["activeTabUnits"]; // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"]; unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"]; unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"]; unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"]; categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"]; companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"]; } tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; Session["unitsChecklistRulesTemp"] = unitsChecklistRulesTemp; Session["unitsServicesTemp"] = unitsServicesTemp; Session["unitsInspectionsTemp"] = unitsInspectionsTemp; Session["unitsNotesTemp"] = unitsNotesTemp; Session["categoriesTDSForUnits"] = categoriesTDS; Session["companyLevelsTDS"] = companyLevelsTDS; } // ... units_add.aspx if (Request.QueryString["source_page"] == "units_add.aspx") { ViewState["update"] = "yes"; hdfActiveTab.Value = Request.QueryString["active_tab"]; unitInformationTDS = new UnitInformationTDS(); unitsChecklistRulesTemp = new UnitInformationTDS.ChecklistDetailsDataTable(); unitsServicesTemp = new UnitInformationTDS.ServiceDetailsDataTable(); unitsInspectionsTemp = new UnitInformationTDS.InspectionDetailsDataTable(); unitsNotesTemp = new UnitInformationTDS.NoteInformationDataTable(); UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.LoadByUnitId(unitId, companyId); UnitInformationNoteDetails unitInformationNoteDetails = new UnitInformationNoteDetails(unitInformationTDS); unitInformationNoteDetails.LoadByUnitId(unitId, companyId); // ... For Categories categoriesTDS = new CategoriesTDS(); Category category = new Category(categoriesTDS); category.LoadByUnitType(hdfUnitType.Value, int.Parse(hdfCompanyId.Value)); // .. For Company Levels companyLevelsTDS = new CompanyLevelsTDS(); CompanyLevel companyLevel = new CompanyLevel(companyLevelsTDS); companyLevel.Load(int.Parse(hdfCompanyId.Value)); tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; Session["unitsChecklistRulesTemp"] = unitsChecklistRulesTemp; Session["unitsServicesTemp"] = unitsServicesTemp; Session["unitsInspectionsTemp"] = unitsInspectionsTemp; Session["unitsNotesTemp"] = unitsNotesTemp; Session["categoriesTDSForUnits"] = categoriesTDS; Session["companyLevelsTDS"] = companyLevelsTDS; } // ... units_delete.aspx, units_edit.aspx or units_state.aspx if ((Request.QueryString["source_page"] == "units_delete.aspx") || (Request.QueryString["source_page"] == "units_edit.aspx") || (Request.QueryString["source_page"] == "units_state.aspx") ) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore dataset unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"]; unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"]; unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"]; unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"]; categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"]; companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"]; // ... Set initial tab if ((string)Session["dialogOpenedUnits"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; } else { hdfActiveTab.Value = (string)Session["activeTabUnits"]; } tcDetailedInformation.ActiveTabIndex = Int32.Parse(hdfActiveTab.Value); } string filterOptions = string.Format("CostID = {0} AND Deleted = {1}", 0, 0); odsCostsExceptions.FilterExpression = filterOptions; // ... Data for current unit LoadUnitData(unitId, companyId); } else { // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"]; unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"]; unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"]; unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"]; categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"]; companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"]; // Set initial tab int activeTabUnits = Int32.Parse(hdfActiveTab.Value); tcDetailedInformation.ActiveTabIndex = activeTabUnits; } }
protected void grdCostsExceptions_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("EditCostException"); if (Page.IsValid) { int costId = Int32.Parse(((Label)grdCostsExceptions.Rows[e.RowIndex].Cells[3].FindControl("lblExceptionCostIDEdit")).Text.Trim()); int refId = Int32.Parse(((Label)grdCostsExceptions.Rows[e.RowIndex].Cells[3].FindControl("lblExceptionRefIDEdit")).Text.Trim()); int unitId = Int32.Parse(hdfUnitId.Value); string unitOfMeasurement = ((DropDownList)grdCostsExceptions.Rows[e.RowIndex].Cells[0].FindControl("ddlExceptionUnitOfMeasurementUnitsEdit")).SelectedValue; decimal costCad = Decimal.Parse(((TextBox)grdCostsExceptions.Rows[e.RowIndex].Cells[3].FindControl("tbxExceptionCostCadEdit")).Text.Trim()); decimal costUsd = Decimal.Parse(((TextBox)grdCostsExceptions.Rows[e.RowIndex].Cells[3].FindControl("tbxExceptionCostUsdEdit")).Text.Trim()); string work_ = ((DropDownList)grdCostsExceptions.Rows[e.RowIndex].Cells[0].FindControl("ddlExceptionWorkEdit")).SelectedValue; // Update data UnitInformationCostExceptionsInformation model = new UnitInformationCostExceptionsInformation(unitInformationTDS); model.Update(costId, refId, work_, unitOfMeasurement, costCad, costUsd); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; string filterOptions = string.Format("CostID = {0} AND Deleted = {1}", costId, 0); odsCostsExceptions.FilterExpression = filterOptions; } else { e.Cancel = true; } }
protected void grdCostsExceptions_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Costs exception Gridview, if the gridview is edition mode if (grdCostsExceptions.EditIndex >= 0) { grdCostsExceptions.UpdateRow(grdCostsExceptions.EditIndex, true); } // Delete cost exception int costId = (int)e.Keys["CostID"]; int refId = (int)e.Keys["RefID"]; UnitInformationCostExceptionsInformation model = new UnitInformationCostExceptionsInformation(unitInformationTDS); // Delete cost exception model.Delete(costId, refId); grdCostsExceptions.DataBind(); grdCosts.DataBind(); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; }
private void UpdateDatabase() { int companyId = Int32.Parse(hdfCompanyId.Value); int unitId = Int32.Parse(hdfUnitId.Value); LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway(libraryTDSForUnits); libraryFilesGateway.Update(); DB.Open(); DB.BeginTransaction(); try { // ... if can edit everything if (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_EDIT"])) { // Save inspection details UnitInformationInspectionDetails unitInformationInspectionDetails = new UnitInformationInspectionDetails(unitInformationTDS); unitInformationInspectionDetails.Save(unitId, companyId); // Save notes information UnitInformationNoteDetailsGateway unitInformationNoteDetailsGateway = new UnitInformationNoteDetailsGateway(unitInformationTDS); UnitInformationNoteDetails unitInformationNoteDetails = new UnitInformationNoteDetails(unitInformationTDS); foreach (UnitInformationTDS.NoteInformationRow rowNotes in (UnitInformationTDS.NoteInformationDataTable)unitInformationNoteDetailsGateway.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; } } } unitInformationNoteDetails.Save(companyId); // Save costs information UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS); unitInformationCostInformation.Save(companyId); // Save costs exceptions information UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS); unitInformationCostExceptionsInformation.Save(companyId, unitId); // Save unit details UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.Save(arrayCategoriesSelectedForEdit, companyId); } // ... if could only edit notes if (!Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_EDIT"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_COMMENTS"])) { // Save notes information UnitInformationNoteDetailsGateway unitInformationNoteDetailsGateway = new UnitInformationNoteDetailsGateway(unitInformationTDS); UnitInformationNoteDetails unitInformationNoteDetails = new UnitInformationNoteDetails(unitInformationTDS); foreach (UnitInformationTDS.NoteInformationRow rowNotes in (UnitInformationTDS.NoteInformationDataTable)unitInformationNoteDetailsGateway.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; } } } unitInformationNoteDetails.Save(companyId); } DB.CommitTransaction(); // Store datasets unitInformationTDS.AcceptChanges(); libraryTDSForUnits.AcceptChanges(); Session["unitInformationTDS"] = unitInformationTDS; Session["libraryTDSForUnits"] = libraryTDSForUnits; } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private void GrdCostsExceptionsAdd() { if (ValidateCostsExceptionsFooter()) { Page.Validate("AddCostException"); if (Page.IsValid) { int costId = Convert.ToInt32(Session["costIdSelected"]); int companyId = Int32.Parse(hdfCompanyId.Value); string unitOfMeasurement = ((DropDownList)grdCostsExceptions.FooterRow.FindControl("ddlExceptionUnitOfMeasurementUnitsNew")).SelectedValue; decimal costCad = Decimal.Parse(((TextBox)grdCostsExceptions.FooterRow.FindControl("tbxExceptionCostCadNew")).Text.Trim()); decimal costUsd = Decimal.Parse(((TextBox)grdCostsExceptions.FooterRow.FindControl("tbxExceptionCostUsdNew")).Text.Trim()); string work_ = ((DropDownList)grdCostsExceptions.FooterRow.FindControl("ddlExceptionWorkNew")).SelectedValue; UnitInformationCostExceptionsInformation model = new UnitInformationCostExceptionsInformation(unitInformationTDS); model.Insert(costId, work_, unitOfMeasurement, costCad, costUsd, false, companyId, false); Session.Remove("unitCostsExceptionsDummy"); Session["unitInformationTDS"] = unitInformationTDS; string filterOptions = string.Format("CostID = {0} AND Deleted = {1}", costId, 0); odsCostsExceptions.FilterExpression = filterOptions; grdCostsExceptions.DataBind(); } } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"]) && (Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_EDIT"]) || Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_COMMENTS"])))) { 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["unit_id"] == null) || ((string)Request.QueryString["unit_type"] == null) || ((string)Request.QueryString["unit_state"] == null) || ((string)Request.QueryString["active_tab"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in units_edit.aspx"); } // Tag Page hdfUnitId.Value = Request.QueryString["unit_id"].ToString(); hdfUnitType.Value = Request.QueryString["unit_type"].ToString(); hdfUnitState.Value = Request.QueryString["unit_state"].ToString(); hdfActiveTab.Value = Request.QueryString["active_tab"].ToString(); hdfCompanyId.Value = Session["companyID"].ToString(); hdfLoginId.Value = Convert.ToInt32(Session["loginID"]).ToString(); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int unitId = Int32.Parse(hdfUnitId.Value.Trim()); aceManufacturer.ContextKey = hdfCompanyId.Value; // ... For Owner country CountryList countryList = new CountryList(); countryList.LoadAndAddItem(-1, "(Select a country)"); ddlOwnerCountry.DataSource = countryList.Table; ddlOwnerCountry.DataValueField = "CountryID"; ddlOwnerCountry.DataTextField = "Name"; ddlOwnerCountry.DataBind(); // ... For License country ddlLicenseCountry.DataSource = countryList.Table; ddlLicenseCountry.DataValueField = "CountryID"; ddlLicenseCountry.DataTextField = "Name"; ddlLicenseCountry.DataBind(); Session.Remove("unitsChecklistRulesTempDummy"); Session.Remove("unitsServicesTempDummy"); Session.Remove("unitsInspectionsTempDummy"); Session.Remove("unitsNotesTempDummy"); Session.Remove("unitCostsDummy"); Session.Remove("unitCostsExceptionsDummy"); Session.Remove("costIdSelected"); // ... units_navigator2.aspx if (Request.QueryString["source_page"] == "units_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; // ... Set initial tab if ((string)Session["dialogOpenedUnits"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; unitInformationTDS = new UnitInformationTDS(); unitsChecklistRulesTemp = new UnitInformationTDS.ChecklistDetailsDataTable(); unitsServicesTemp = new UnitInformationTDS.ServiceDetailsDataTable(); unitsInspectionsTemp = new UnitInformationTDS.InspectionDetailsDataTable(); unitsNotesTemp = new UnitInformationTDS.NoteInformationDataTable(); UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.LoadByUnitId(unitId, companyId); UnitInformationInspectionDetails unitInformationInspectionDetailsForEdit = new UnitInformationInspectionDetails(unitInformationTDS); unitInformationInspectionDetailsForEdit.LoadByUnitId(unitId, companyId); UnitInformationNoteDetails unitInformationNoteDetailsForEdit = new UnitInformationNoteDetails(unitInformationTDS); unitInformationNoteDetailsForEdit.LoadByUnitId(unitId, companyId); UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS); unitInformationCostInformation.LoadAllByUnitId(unitId, companyId); UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS); unitInformationCostExceptionsInformation.LoadAllByUnitId(unitId, companyId); // ... For Categories categoriesTDS = new CategoriesTDS(); Category category = new Category(categoriesTDS); category.LoadByUnitType(hdfUnitType.Value, int.Parse(hdfCompanyId.Value)); // .. For Company Levels companyLevelsTDS = new CompanyLevelsTDS(); CompanyLevel companyLevel = new CompanyLevel(companyLevelsTDS); companyLevel.Load(int.Parse(hdfCompanyId.Value)); } else { hdfActiveTab.Value = (string)Session["activeTabUnits"]; // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"]; unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"]; unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"]; unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"]; categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"]; companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"]; } arrayCategoriesSelectedForEdit = new ArrayList(); arrayCompanyLevelsSelectedForEdit = new ArrayList(); Session["arrayCategoriesSelectedForEdit"] = arrayCategoriesSelectedForEdit; Session["arrayCompanyLevelsSelectedForEdit"] = arrayCompanyLevelsSelectedForEdit; // Store dataset Session["unitInformationTDS"] = unitInformationTDS; Session["unitsChecklistRulesTemp"] = unitsChecklistRulesTemp; Session["unitsServicesTemp"] = unitsServicesTemp; Session["unitsInspectionsTemp"] = unitsInspectionsTemp; Session["unitsNotesTemp"] = unitsNotesTemp; Session["categoriesTDSForUnits"] = categoriesTDS; Session["companyLevelsTDS"] = companyLevelsTDS; } // ... units_summary.aspx or units_edit.aspx if ((Request.QueryString["source_page"] == "units_summary.aspx") || (Request.QueryString["source_page"] == "units_edit.aspx")) { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore dataset unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"]; unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"]; unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"]; unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"]; categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"]; companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"]; // ... Set initial tab if ((string)Session["dialogOpenedUnits"] != "1") { hdfActiveTab.Value = Request.QueryString["active_tab"]; if (ViewState["update"].ToString().Trim() == "yes") { UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.LoadByUnitId(unitId, companyId); UnitInformationInspectionDetails unitInformationInspectionDetailsForEdit = new UnitInformationInspectionDetails(unitInformationTDS); unitInformationInspectionDetailsForEdit.LoadByUnitId(unitId, companyId); UnitInformationNoteDetails unitInformationNoteDetailsForEdit = new UnitInformationNoteDetails(unitInformationTDS); unitInformationNoteDetailsForEdit.LoadByUnitId(unitId, companyId); UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS); unitInformationCostInformation.LoadAllByUnitId(unitId, companyId); UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS); unitInformationCostExceptionsInformation.LoadAllByUnitId(unitId, companyId); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; } } else { hdfActiveTab.Value = (string)Session["activeTabUnits"]; } arrayCategoriesSelectedForEdit = new ArrayList(); arrayCompanyLevelsSelectedForEdit = new ArrayList(); Session["arrayCategoriesSelectedForEdit"] = arrayCategoriesSelectedForEdit; Session["arrayCompanyLevelsSelectedForEdit"] = arrayCompanyLevelsSelectedForEdit; } // ... units_add.aspx if (Request.QueryString["source_page"] == "units_add.aspx") { ViewState["update"] = "yes"; unitInformationTDS = new UnitInformationTDS(); unitsChecklistRulesTemp = new UnitInformationTDS.ChecklistDetailsDataTable(); unitsServicesTemp = new UnitInformationTDS.ServiceDetailsDataTable(); unitsInspectionsTemp = new UnitInformationTDS.InspectionDetailsDataTable(); unitsNotesTemp = new UnitInformationTDS.NoteInformationDataTable(); UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.LoadByUnitId(unitId, companyId); UnitInformationNoteDetails unitInformationNoteDetailsForEdit = new UnitInformationNoteDetails(unitInformationTDS); unitInformationNoteDetailsForEdit.LoadByUnitId(unitId, companyId); // ... For Categories categoriesTDS = new CategoriesTDS(); Category category = new Category(categoriesTDS); category.LoadByUnitType(hdfUnitType.Value, int.Parse(hdfCompanyId.Value)); // .. For Company Levels companyLevelsTDS = new CompanyLevelsTDS(); CompanyLevel companyLevel = new CompanyLevel(companyLevelsTDS); companyLevel.Load(int.Parse(hdfCompanyId.Value)); arrayCategoriesSelectedForEdit = new ArrayList(); arrayCompanyLevelsSelectedForEdit = new ArrayList(); Session["arrayCategoriesSelectedForEdit"] = arrayCategoriesSelectedForEdit; Session["arrayCompanyLevelsSelectedForEdit"] = arrayCompanyLevelsSelectedForEdit; // Store dataset Session["unitInformationTDS"] = unitInformationTDS; Session["unitsChecklistRulesTemp"] = unitsChecklistRulesTemp; Session["unitsServicesTemp"] = unitsServicesTemp; Session["unitsInspectionsTemp"] = unitsInspectionsTemp; Session["unitsNotesTemp"] = unitsNotesTemp; Session["categoriesTDSForUnits"] = categoriesTDS; Session["companyLevelsTDS"] = companyLevelsTDS; } // ... For Library if (Session["libraryTDSForUnits"] != null) { libraryTDSForUnits = (LibraryTDS)Session["libraryTDSForUnits"]; } else { libraryTDSForUnits = new LibraryTDS(); } Session["costIdSelected"] = 0; grdCostsExceptions.ShowFooter = false; string filterOptions = string.Format("CostID = {0} AND Deleted = {1}", 0, 0); odsCostsExceptions.FilterExpression = filterOptions; // Set initial tab int activeTabUnits = Int32.Parse(hdfActiveTab.Value); tcDetailedInformation.ActiveTabIndex = activeTabUnits; // ... ... Make panels visible MakePanelsVisible(); // ... ... Data for current unit LoadUnitData(companyId); } else { // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; unitsChecklistRulesTemp = (UnitInformationTDS.ChecklistDetailsDataTable)Session["unitsChecklistRulesTemp"]; unitsServicesTemp = (UnitInformationTDS.ServiceDetailsDataTable)Session["unitsServicesTemp"]; unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)Session["unitsInspectionsTemp"]; unitsNotesTemp = (UnitInformationTDS.NoteInformationDataTable)Session["unitsNotesTemp"]; categoriesTDS = (CategoriesTDS)Session["categoriesTDSForUnits"]; companyLevelsTDS = (CompanyLevelsTDS)Session["companyLevelsTDS"]; arrayCategoriesSelectedForEdit = (ArrayList)Session["arrayCategoriesSelectedForEdit"]; arrayCompanyLevelsSelectedForEdit = (ArrayList)Session["arrayCompanyLevelsSelectedForEdit"]; // Set initial tab int activeTabUnits = Int32.Parse(hdfActiveTab.Value); tcDetailedInformation.ActiveTabIndex = activeTabUnits; aceManufacturer.ContextKey = hdfCompanyId.Value; if (Session["libraryTDSForUnits"] != null) { libraryTDSForUnits = (LibraryTDS)Session["libraryTDSForUnits"]; } else { libraryTDSForUnits = new LibraryTDS(); } LoadNotes(); } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"]) && Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_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["unit_id"] == null) || ((string)Request.QueryString["unit_type"] == null) || ((string)Request.QueryString["unit_state"] == null) || ((string)Request.QueryString["active_tab"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in units_delete.aspx"); } // Tag Page hdfUnitId.Value = Request.QueryString["unit_id"].ToString(); hdfUnitType.Value = Request.QueryString["unit_type"].ToString(); hdfUnitState.Value = Request.QueryString["unit_state"].ToString(); hdfCompanyId.Value = Session["companyID"].ToString(); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int unitId = Int32.Parse(hdfUnitId.Value.Trim()); // If comming from // ... units_navigator2.aspx if (Request.QueryString["source_page"] == "units_navigator2.aspx") { StoreNavigatorState(); ViewState["update"] = "no"; unitInformationTDS = new UnitInformationTDS(); UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.LoadByUnitId(unitId, companyId); UnitInformationChecklistDetails unitInformationChecklistDetails = new UnitInformationChecklistDetails(unitInformationTDS); unitInformationChecklistDetails.Load(unitId, companyId); UnitInformationServiceDetails unitInformationServiceDetails = new UnitInformationServiceDetails(unitInformationTDS); unitInformationServiceDetails.Load(unitId, companyId); UnitInformationInspectionDetails unitInformationInspectionDetails = new UnitInformationInspectionDetails(unitInformationTDS); unitInformationInspectionDetails.LoadByUnitId(unitId, companyId); UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS); unitInformationCostExceptionsInformation.LoadAllByUnitId(unitId, companyId); UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS); unitInformationCostInformation.LoadAllByUnitId(unitId, companyId); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; } // ... units_summary.aspx if (Request.QueryString["source_page"] == "units_summary.aspx") { StoreNavigatorState(); ViewState["update"] = Request.QueryString["update"]; // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; } } else { // Restore datasets unitInformationTDS = (UnitInformationTDS)Session["unitInformationTDS"]; } }
private void Delete() { Page.Validate(); if (Page.IsValid) { // Delete int unitId = Int32.Parse(hdfUnitId.Value); int companyId = Int32.Parse(hdfCompanyId.Value); UnitInformationUnitDetails unitInformationUnitDetails = new UnitInformationUnitDetails(unitInformationTDS); unitInformationUnitDetails.Delete(unitId); UnitInformationChecklistDetails unitInformationChecklistDetails = new UnitInformationChecklistDetails(unitInformationTDS); unitInformationChecklistDetails.DeleteAll(); UnitInformationInspectionDetails unitInformationInspectionDetails = new UnitInformationInspectionDetails(unitInformationTDS); unitInformationInspectionDetails.DeleteAll(); UnitInformationCostExceptionsInformation unitInformationCostExceptionsInformation = new UnitInformationCostExceptionsInformation(unitInformationTDS); unitInformationCostExceptionsInformation.DeleteAll(unitId); UnitInformationCostInformation unitInformationCostInformation = new UnitInformationCostInformation(unitInformationTDS); unitInformationCostInformation.DeleteAll(unitId); // Update databse UpdateDatabase(); // Store datasets Session["unitInformationTDS"] = unitInformationTDS; // Redirect string url = ""; url = "./units_navigator2.aspx?source_page=units_delete.aspx" + GetNavigatorState() + "&update=yes"; Response.Redirect(url); } }