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_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 GrdNotesAddAttachment(int? refId, string subject)
{
Save2();
// Escape single quote
subject = subject.Replace("'", "%27");
if (refId.HasValue)
{
if (ViewState["libraryCategoriesId"] != null)
{
string script = "<script language='javascript'>";
string url = "./units_add_attachment.aspx?source_page=units_edit.aspx&subject=" + Server.UrlEncode(subject) + "&refId=" + refId.ToString() + "&unit_id=" + hdfUnitId.Value + "&library_categories_id=" + Int32.Parse(ViewState["libraryCategoriesId"].ToString());
script = script + string.Format("window.open('{0}', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=510, height=270')", url);
script = script + "</script>";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Notes", script, false);
}
}
else
{
UnitInformationNoteDetails model = new UnitInformationNoteDetails(unitInformationTDS);
refId = model.GetLastRefId();
if (ViewState["libraryCategoriesId"] != null)
{
string script = "<script language='javascript'>";
string url = "./units_add_attachment.aspx?source_page=units_edit.aspx&subject=" + Server.UrlEncode(subject) + "&refId=" + refId.ToString() + "&unit_id=" + hdfUnitId.Value + "&library_categories_id=" + Int32.Parse(ViewState["libraryCategoriesId"].ToString());
script = script + string.Format("window.open('{0}', '_blank', 'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=no, copyhistory=no, width=510, height=270')", url);
script = script + "</script>";
ScriptManager.RegisterStartupScript(this, this.GetType(), "Notes", script, false);
}
}
}
private void GrdNotesDeleteAttachment(int libraryFileId, int refId)
{
// Button delete functionality
if (libraryFileId != 0)
{
UnitInformationNoteDetails model = new UnitInformationNoteDetails(unitInformationTDS);
model.UpdateLibraryFilesId(int.Parse(hdfUnitId.Value), refId, null, "", "");
LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway(libraryTDSForUnits);
libraryFilesGateway.DeleteByLibraryFilesId(libraryFileId);
ViewState["update"] = "no";
Session["unitInformationTDS"] = unitInformationTDS;
Session["libraryTDSForUnits"] = libraryTDSForUnits;
grdNotes.DataBind();
}
}
private void GrdNotesAdd()
{
if (ValidateNotesFooter())
{
Page.Validate("notesDataAdd");
if (Page.IsValid)
{
int unitId = Int32.Parse(hdfUnitId.Value);
int companyId = Int32.Parse(hdfCompanyId.Value);
string newSubject = ((TextBox)grdNotes.FooterRow.FindControl("tbxNoteSubjectNew")).Text.Trim();
int loginId = Convert.ToInt32(Session["loginID"]);
DateTime dateTime_ = DateTime.Now;
string newNote = ((TextBox)grdNotes.FooterRow.FindControl("tbxNoteNoteNew")).Text.Trim();
bool inDatabase = false;
int? libraryFilesId = null;
string fileName = ((Label)grdNotes.FooterRow.FindControl("lblFileNameNoteAttachmentNew")).Text.Trim();
if (fileName != "")
{
LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway();
libraryFilesId = libraryFilesGateway.GetlibraryFilesId(fileName);
}
UnitInformationNoteDetails model = new UnitInformationNoteDetails(unitInformationTDS);
model.Insert(unitId, newSubject, loginId, dateTime_, newNote, false, companyId, inDatabase, libraryFilesId);
Session.Remove("unitsNotesTempDummy");
Session["unitInformationTDS"] = unitInformationTDS;
grdNotes.DataBind();
grdNotes.PageIndex = grdNotes.PageCount - 1;
}
}
}
// ////////////////////////////////////////////////////////////////////////
// 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 grdNotes_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Page.Validate("notesDataEdit");
if (Page.IsValid)
{
int unitId = (int)e.Keys["UnitID"];
int refId = (int)e.Keys["RefID"];
string subject = ((TextBox)grdNotes.Rows[e.RowIndex].Cells[2].FindControl("tbxNoteSubjectEdit")).Text.Trim();
string Note = ((TextBox)grdNotes.Rows[e.RowIndex].Cells[3].FindControl("tbxNoteNoteEdit")).Text.Trim();
int? libraryFilesId = null;
if (((Label)grdNotes.Rows[e.RowIndex].Cells[3].FindControl("lblLibraryFileIdEdit")).Text.Trim() != "")
{
libraryFilesId = Int32.Parse(((Label)grdNotes.Rows[e.RowIndex].Cells[3].FindControl("lblLibraryFileIdEdit")).Text.Trim());
}
// Update data
UnitInformationNoteDetails model = new UnitInformationNoteDetails(unitInformationTDS);
model.Update(unitId, refId, subject, Note, libraryFilesId);
// Store dataset
Session["unitInformationTDS"] = unitInformationTDS;
}
else
{
e.Cancel = true;
}
}
protected void grdNotes_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// Notes Gridview, if the gridview is edition mode
if (grdNotes.EditIndex >= 0)
{
grdNotes.UpdateRow(grdNotes.EditIndex, true);
}
// Delete notes
int unitId = (int)e.Keys["UnitID"];
int refId = (int)e.Keys["RefID"];
UnitInformationNoteDetails model = new UnitInformationNoteDetails(unitInformationTDS);
model.Delete(unitId, refId);
if (((Label)grdNotes.Rows[e.RowIndex].Cells[3].FindControl("lblLibraryFileId")).Text.Trim() != "")
{
int? libraryFilesId = Int32.Parse(((Label)grdNotes.Rows[e.RowIndex].Cells[3].FindControl("lblLibraryFileId")).Text.Trim());
LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway();
libraryFilesGateway.DeleteByLibraryFilesId((int)libraryFilesId);
}
// Store dataset
Session["unitInformationTDS"] = unitInformationTDS;
}
// ////////////////////////////////////////////////////////////////////////
// METHODS
//
private void ProcessUpload2(int unitId, int refId, int companyId)
{
LibraryFilesGateway libraryFilesGateway = new LibraryFilesGateway();
try
{
//... Set the default path to store uploaded files.
AppSettingsReader appSettingReader = new AppSettingsReader();
string websitePath = appSettingReader.GetValue("WebsitePath", typeof(System.String)).ToString();
string filename = "";
//... Get the extension of file
string[] shortFilename = nuifAttachment.FileName.Split(new char[] { '.' });
string ext = "." + shortFilename[shortFilename.Length - 1];
bool exit = false;
while (!exit)
{
StringBuilder builder = new StringBuilder();
Random rand = new Random();
char ch;
for (int i = 0; i < 8; i++)
{
ch = Convert.ToChar(Convert.ToInt32(Math.Floor(26 * rand.NextDouble() + 65)));
builder.Append(ch);
}
filename = builder.ToString();
filename = filename + ext;
libraryFilesGateway.LoadByFileName(filename, companyId);
if (libraryFilesGateway.Table.Rows.Count > 0)
{
exit = false;
}
else
{
exit = true;
}
}
string pathFull = websitePath + "\\Files\\LF_DGHOUGDH\\Library\\";
//... Save the file
nuifAttachment.MoveTo(Path.Combine(pathFull, filename), MoveToOptions.Overwrite);
LibraryFiles libraryFiles = new LibraryFiles(libraryTDSForUnits);
libraryFiles.Insert(filename, tbxDescription.Text, nuifAttachment.FileName, null, Convert.ToInt32(ViewState["libraryCategoriesId"]), Convert.ToInt32(hdfLoginId.Value), int.Parse(Session["companyID"].ToString()), nuifAttachment.FileContent.Length.ToString()); //Note: COMPANY_ID
UnitInformationNoteDetails model = new UnitInformationNoteDetails(unitInformationTDS);
model.UpdateLibraryFilesId(unitId, refId, 0, nuifAttachment.FileName, filename);
Session["libraryTDSForUnits"] = libraryTDSForUnits;
Session["unitInformationTDS"] = unitInformationTDS;
}
catch (Exception ex)
{
}
}