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