private void LoadInspectionData(int unitId) { UnitInformationTDS dataset = new UnitInformationTDS(); dataset.InspectionDetails.Merge(unitsInspectionsTemp, true); UnitInformationInspectionDetails model = new UnitInformationInspectionDetails(dataset); model.LoadByUnitId(unitId, int.Parse(hdfCompanyId.Value)); unitsInspectionsTemp = (UnitInformationTDS.InspectionDetailsDataTable)model.Table; Session["unitsInspectionsTemp"] = unitsInspectionsTemp; grdInspections.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_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; } }
private void InspectionsAddNew() { if (ValidateInspectionFooter()) { Page.Validate("inspections"); if (Page.IsValid) { DateTime date_ = ((RadDatePicker)grdInspections.FooterRow.FindControl("tkrdpInspectionDateNew")).SelectedDate.Value; Int64 country = Int64.Parse(((DropDownList)grdInspections.FooterRow.FindControl("ddlCountryNew")).SelectedValue.ToString().Trim()); Int64 state = Int64.Parse(((DropDownList)grdInspections.FooterRow.FindControl("ddlStateNew")).SelectedValue.ToString().Trim()); string type = ((DropDownList)grdInspections.FooterRow.FindControl("ddlTypeNew")).SelectedValue.ToString().Trim(); string result = ((DropDownList)grdInspections.FooterRow.FindControl("ddlResultNew")).SelectedValue.ToString().Trim(); decimal? cost = null; if (((TextBox)grdInspections.FooterRow.FindControl("tbxRepairCostNew")).Text.Trim() != "") { cost = Decimal.Parse(((TextBox)grdInspections.FooterRow.FindControl("tbxRepairCostNew")).Text.Trim()); } string notes = ((TextBox)grdInspections.FooterRow.FindControl("tbxNotesNew")).Text.Trim(); string inspectedBy = ((TextBox)grdInspections.FooterRow.FindControl("tbxInspectedByNew")).Text.Trim(); int companyId = Int32.Parse(hdfCompanyId.Value); int unitId = Int32.Parse(hdfUnitId.Value); // Insert UnitInformationInspectionDetails model = new UnitInformationInspectionDetails(unitInformationTDS); model.Insert(date_, country, state, type, result, cost, notes, inspectedBy, "", false, false); // Store datasets Session.Remove("unitsInspectionsTempDummy"); Session["unitInformationTDS"] = unitInformationTDS; grdInspections.DataBind(); grdInspections.PageIndex = grdInspections.PageCount - 1; } } }
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); } }
// //////////////////////////////////////////////////////////////////////// // 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(); } }
protected void grdInspections_RowUpdating(object sender, GridViewUpdateEventArgs e) { Page.Validate("inspectionsEdit"); if (Page.IsValid) { int inspectionId = (int)e.Keys["InspectionID"]; DateTime date_ = ((RadDatePicker)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("tkrdpInspectionDateEdit")).SelectedDate.Value; Int64 country = Int64.Parse(((DropDownList)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("ddlCountryEdit")).SelectedValue.ToString().Trim()); Int64 state = Int64.Parse(((DropDownList)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("ddlStateEdit")).SelectedValue.ToString().Trim()); string type = ((DropDownList)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("ddlTypeEdit")).SelectedValue.ToString().Trim(); string result = ""; if (((DropDownList)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("ddlResultEdit")).SelectedValue != "") { result = ((DropDownList)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("ddlResultEdit")).SelectedValue.Trim(); } decimal? cost = null; if (((TextBox)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("tbxRepairCostEdit")).Text.Trim() != "") { cost = decimal.Parse(((TextBox)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("tbxRepairCostEdit")).Text.Trim()); } string notes = ((TextBox)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("tbxNotesEdit")).Text.Trim(); string inspectedBy = ((TextBox)grdInspections.Rows[e.RowIndex].Cells[1].FindControl("tbxInspectedByEdit")).Text.Trim(); // Update UnitInformationInspectionDetails model = new UnitInformationInspectionDetails(unitInformationTDS); model.Update(inspectionId, date_, country, state, type, result, cost, notes, inspectedBy, "", false, false); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; } else { e.Cancel = true; } }
protected void grdInspections_RowDeleting(object sender, GridViewDeleteEventArgs e) { // Inspections Gridview, if the gridview is edition mode if (grdInspections.EditIndex >= 0) { grdInspections.UpdateRow(grdInspections.EditIndex, true); } // Delete inspections int inspectionId = (int)e.Keys["InspectionID"]; UnitInformationInspectionDetails model = new UnitInformationInspectionDetails(unitInformationTDS); // Delete inspection model.Delete(inspectionId); // Store dataset Session["unitInformationTDS"] = unitInformationTDS; }
// //////////////////////////////////////////////////////////////////////// // 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); } }