/// <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);
}
}