// //////////////////////////////////////////////////////////////////////// // AUXILIAR EVENTS // protected void btnViewDelete_Click(object sender, EventArgs e) { int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); int viewId = Int32.Parse(ddlView.SelectedValue.Trim()); if (!(Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_DELETE"]))) { FmViewGateway fmViewGateway = new FmViewGateway(); fmViewGateway.LoadByViewId(viewId, companyId); string viewType = fmViewGateway.GetType(viewId); if (viewType == "Global") { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } UpdateDatabaseForViews(); // ... For view ddl string fmType = hdfFmType.Value; int loginId = Convert.ToInt32(Session["loginID"]); string viewTypeGlobal = ""; string viewTypePersonal = "Personal"; // Global Views check if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"])) { viewTypeGlobal = "Global"; } FmViewList fmViewList = new FmViewList(); fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId); ddlView.DataSource = fmViewList.Table; ddlView.DataValueField = "ViewID"; ddlView.DataTextField = "Name"; ddlView.DataBind(); ddlView.SelectedIndex = 1; }
private void RestoreNavigatorState() { // Search condition 1 // Columns To Display string columnsToDisplay = Request.QueryString["columns_to_display"]; // Search condition 1 // ... For Condition odsViewForDisplayList.DataBind(); ddlCondition1.DataSourceID = "odsViewForDisplayList"; ddlCondition1.DataValueField = "ConditionID"; ddlCondition1.DataTextField = "Name"; ddlCondition1.DataBind(); ddlCondition1.SelectedValue = Request.QueryString["search_ddlCondition1"]; // ... For text for search tbxCondition1.Text = Request.QueryString["search_tbxCondition1"]; // ... ForView int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); string fmType = hdfFmType.Value; int loginId = Convert.ToInt32(Session["loginID"]); string viewTypeGlobal = ""; string viewTypePersonal = "Personal"; // Global Views check if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"])) { viewTypeGlobal = "Global"; } FmViewList fmViewList = new FmViewList(); fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId); ddlView.DataSource = fmViewList.Table; ddlView.DataValueField = "ViewID"; ddlView.DataTextField = "Name"; ddlView.DataBind(); ddlView.SelectedValue = Request.QueryString["search_ddlView"]; //Other values //... For State odsState.DataBind(); ddlState.DataSourceID = "odsState"; ddlState.DataValueField = "State"; ddlState.DataTextField = "State"; ddlState.DataBind(); ddlState.SelectedValue = Request.QueryString["search_state"]; //... For SortBy odsSortByList.DataBind(); ddlSortBy.DataSourceID = "odsSortByList"; ddlSortBy.DataValueField = "SortID"; ddlSortBy.DataTextField = "Name"; ddlSortBy.DataBind(); ddlSortBy.SelectedValue = Request.QueryString["search_sort_by"]; // ... For BtnOrigin hdfBtnOrigin.Value = Request.QueryString["btn_origin"]; }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"]))) { 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) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in services_navigator.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfFmType.Value = "Services"; // Prepare initial data // ... For sortByList odsSortByList.DataBind(); ddlSortBy.DataSourceID = "odsSortByList"; ddlSortBy.DataValueField = "SortID"; ddlSortBy.DataTextField = "Name"; ddlSortBy.DataBind(); // ... For odsViewForDisplayList.DataBind(); ddlCondition1.DataSourceID = "odsViewForDisplayList"; ddlCondition1.DataValueField = "ConditionID"; ddlCondition1.DataTextField = "Name"; ddlCondition1.DataBind(); // ... For view ddl int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); string fmType = hdfFmType.Value; int loginId = Convert.ToInt32(Session["loginID"]); string viewTypeGlobal = ""; string viewTypePersonal = "Personal"; // Global Views check if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"])) { viewTypeGlobal = "Global"; } FmViewList fmViewList = new FmViewList(); fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId); ddlView.DataSource = fmViewList.Table; ddlView.DataValueField = "ViewID"; ddlView.DataTextField = "Name"; ddlView.DataBind(); ddlView.SelectedIndex = 1; // If coming from // ... Left Menu or out if ((Request.QueryString["source_page"] == "lm") || (Request.QueryString["source_page"] == "out")) { tdNoResults.Visible = false; } // ... services_navigator2.aspx if (Request.QueryString["source_page"] == "services_navigator2.aspx") { RestoreNavigatorState(); if ((string)Request.QueryString["no_results"] == "yes") { tdNoResults.Visible = true; } else { tdNoResults.Visible = false; } } } else { } }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Security check if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"]))) { 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) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in services_navigator2.aspx"); } // Tag Page hdfCompanyId.Value = Session["companyID"].ToString(); hdfFmType.Value = "Services"; // Prepare initial data // ... For sortByList odsSortByList.DataBind(); ddlSortBy.DataSourceID = "odsSortByList"; ddlSortBy.DataValueField = "SortID"; ddlSortBy.DataTextField = "Name"; ddlSortBy.DataBind(); // ... For odsViewForDisplayList.DataBind(); ddlCondition1.DataSourceID = "odsViewForDisplayList"; ddlCondition1.DataValueField = "ConditionID"; ddlCondition1.DataTextField = "Name"; ddlCondition1.DataBind(); // ... For view ddl int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); string fmType = hdfFmType.Value; int loginId = Convert.ToInt32(Session["loginID"]); string viewTypeGlobal = ""; string viewTypePersonal = "Personal"; // Global Views check if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"])) { viewTypeGlobal = "Global"; } FmViewList fmViewList = new FmViewList(); fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId); ddlView.DataSource = fmViewList.Table; ddlView.DataValueField = "ViewID"; ddlView.DataTextField = "Name"; ddlView.DataBind(); ddlView.SelectedIndex = 1; // If coming from // ... services_navigator.aspx or services_navigator2.aspx if ((Request.QueryString["source_page"] == "services_navigator.aspx") || (Request.QueryString["source_page"] == "services_navigator2.aspx")) { RestoreNavigatorState(); servicesNavigatorTDS = (ServicesNavigatorTDS)Session["servicesNavigatorTDS"]; } // ... services_edit.aspx, services_summary.aspx or services_delete.aspx if ((Request.QueryString["source_page"] == "services_edit.aspx") || (Request.QueryString["source_page"] == "services_summary.aspx") || (Request.QueryString["source_page"] == "services_delete.aspx")) { RestoreNavigatorState(); if (Request.QueryString["update"] == "no") { servicesNavigatorTDS = (ServicesNavigatorTDS)Session["servicesNavigatorTDS"]; } else { // ... Delete store data Session.Contents.Remove("servicesNavigatorTDS"); // ... Search data with updates if (hdfBtnOrigin.Value == "Search") { servicesNavigatorTDS = SubmitSearch(); } else { if (hdfBtnOrigin.Value == "Go") { servicesNavigatorTDS = SubmitSearchForViews(); } } // ... store datasets Session["servicesNavigatorTDS"] = servicesNavigatorTDS; } } // ... services_delete.aspx, services_summary.aspx or services_edit.aspx if ((Request.QueryString["source_page"] == "services_delete.aspx") || (Request.QueryString["source_page"] == "services_summary.aspx") || (Request.QueryString["source_page"] == "services_edit.aspx")) { if (servicesNavigatorTDS.ServicesNavigator.Rows.Count == 0) { string url = "./services_navigator.aspx?source_page=services_navigator2.aspx&fm_type=" + hdfFmType.Value + GetNavigatorState() + "&no_results=yes"; Response.Redirect(url); } } // For the grid grdServicesNavigator.DataSource = servicesNavigatorTDS.ServicesNavigator; grdServicesNavigator.DataBind(); //... for the total rows if (servicesNavigatorTDS.ServicesNavigator.Rows.Count > 0) { lblTotalRows.Text = "Total Rows: " + servicesNavigatorTDS.ServicesNavigator.Rows.Count; lblTotalRows.Visible = true; } else { lblTotalRows.Visible = false; } } else { // Restore TDS servicesNavigatorTDS = (ServicesNavigatorTDS)Session["servicesNavigatorTDS"]; // ... for the total rows if (servicesNavigatorTDS.ServicesNavigator.Rows.Count > 0) { lblTotalRows.Text = "Total Rows: " + servicesNavigatorTDS.ServicesNavigator.Rows.Count; lblTotalRows.Visible = true; } else { lblTotalRows.Visible = false; } } }
private void RestoreNavigatorState() { // Columns To Display string columnsToDisplay = Request.QueryString["columns_to_display"]; // Search condition 1 // ... For Condition odsViewForDisplayList.DataBind(); ddlCondition1.DataSourceID = "odsViewForDisplayList"; ddlCondition1.DataValueField = "ConditionID"; ddlCondition1.DataTextField = "Name"; ddlCondition1.DataBind(); ddlCondition1.SelectedValue = Request.QueryString["search_ddlCondition1"]; // ... For text for search tbxCondition1.Text = Request.QueryString["search_tbxCondition1"]; // ... ForView int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); string fmType = hdfFmType.Value; int loginId = Convert.ToInt32(Session["loginID"]); string viewTypeGlobal = ""; string viewTypePersonal = "Personal"; // Global Views check if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"])) { viewTypeGlobal = "Global"; } FmViewList fmViewList = new FmViewList(); fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId); ddlView.DataSource = fmViewList.Table; ddlView.DataValueField = "ViewID"; ddlView.DataTextField = "Name"; ddlView.DataBind(); ddlView.SelectedValue = Request.QueryString["search_ddlView"]; //Other values //... For State odsState.DataBind(); ddlState.DataSourceID = "odsState"; ddlState.DataValueField = "State"; ddlState.DataTextField = "State"; ddlState.DataBind(); ddlState.SelectedValue = Request.QueryString["search_state"]; //... For SortBy odsSortByList.DataBind(); ddlSortBy.DataSourceID = "odsSortByList"; ddlSortBy.DataValueField = "SortID"; ddlSortBy.DataTextField = "Name"; ddlSortBy.DataBind(); ddlSortBy.SelectedValue = Request.QueryString["search_sort_by"]; // ... For BtnOrigin hdfBtnOrigin.Value = Request.QueryString["btn_origin"]; // Grid's columns grdServicesNavigator.Columns[2].Visible = (columnsToDisplay.IndexOf("Service Number") >= 0 ? true : false); grdServicesNavigator.Columns[3].Visible = (columnsToDisplay.IndexOf("Date & Time") >= 0 ? true : false); grdServicesNavigator.Columns[4].Visible = (columnsToDisplay.IndexOf("Fixed Date") >= 0 ? true : false); grdServicesNavigator.Columns[5].Visible = (columnsToDisplay.Contains("State") ? true : false); grdServicesNavigator.Columns[6].Visible = (columnsToDisplay.IndexOf("Problem Description") >= 0 ? true : false); grdServicesNavigator.Columns[7].Visible = (columnsToDisplay.IndexOf("Unit Code") >= 0 ? true : false); grdServicesNavigator.Columns[8].Visible = (columnsToDisplay.IndexOf("Unit Description") >= 0 ? true : false); grdServicesNavigator.Columns[9].Visible = (columnsToDisplay.IndexOf("VIN/SN") >= 0 ? true : false); grdServicesNavigator.Columns[10].Visible = (columnsToDisplay.IndexOf("Unit State") >= 0 ? true : false); grdServicesNavigator.Columns[11].Visible = (columnsToDisplay.IndexOf("Checklist Rule") >= 0 ? true : false); grdServicesNavigator.Columns[12].Visible = (columnsToDisplay.IndexOf("Associated Checklist State") >= 0 ? true : false); grdServicesNavigator.Columns[13].Visible = (columnsToDisplay.IndexOf("Created by") >= 0 ? true : false); grdServicesNavigator.Columns[14].Visible = (columnsToDisplay.IndexOf("Mileage") >= 0 ? true : false); grdServicesNavigator.Columns[15].Visible = (columnsToDisplay.IndexOf("Assignment Date") >= 0 ? true : false); grdServicesNavigator.Columns[16].Visible = (columnsToDisplay.IndexOf("Deadline Date") >= 0 ? true : false); grdServicesNavigator.Columns[17].Visible = (columnsToDisplay.IndexOf("Assigned to") >= 0 ? true : false); grdServicesNavigator.Columns[18].Visible = (columnsToDisplay.IndexOf("Accepted Date") >= 0 ? true : false); grdServicesNavigator.Columns[19].Visible = (columnsToDisplay.IndexOf("Start Date") >= 0 ? true : false); grdServicesNavigator.Columns[20].Visible = (columnsToDisplay.IndexOf("Unit Out Of Service Date") >= 0 ? true : false); grdServicesNavigator.Columns[21].Visible = (columnsToDisplay.IndexOf("Unit Out Of Service Time") >= 0 ? true : false); grdServicesNavigator.Columns[22].Visible = (columnsToDisplay.IndexOf("Start Work Mileage") >= 0 ? true : false); grdServicesNavigator.Columns[23].Visible = (columnsToDisplay.IndexOf("Complete Date") >= 0 ? true : false); grdServicesNavigator.Columns[24].Visible = (columnsToDisplay.IndexOf("Unit Back In Service Date") >= 0 ? true : false); grdServicesNavigator.Columns[25].Visible = (columnsToDisplay.IndexOf("Unit Back In Service Time") >= 0 ? true : false); grdServicesNavigator.Columns[26].Visible = (columnsToDisplay.IndexOf("Complete Work Mileage") >= 0 ? true : false); grdServicesNavigator.Columns[27].Visible = (columnsToDisplay.IndexOf("Work Details") >= 0 ? true : false); grdServicesNavigator.Columns[28].Visible = (columnsToDisplay.IndexOf("Preventable") >= 0 ? true : false); grdServicesNavigator.Columns[29].Visible = (columnsToDisplay.IndexOf("Labour Hours") >= 0 ? true : false); grdServicesNavigator.Columns[30].Visible = (columnsToDisplay.IndexOf("Notes") >= 0 ? true : false); grdServicesNavigator.Columns[31].Visible = (columnsToDisplay.IndexOf("Working Location") >= 0 ? true : false); }
private void RestoreNavigatorState() { try { // Columns To Display string columnsToDisplay = Request.QueryString["columns_to_display"]; // Search condition 1 // ... For Condition odsViewForDisplayList.DataBind(); ddlCondition1.DataSourceID = "odsViewForDisplayList"; ddlCondition1.DataValueField = "ConditionID"; ddlCondition1.DataTextField = "Name"; ddlCondition1.DataBind(); ddlCondition1.SelectedValue = Request.QueryString["search_ddlCondition1"]; // ... For text for search tbxCondition1.Text = Request.QueryString["search_tbxCondition1"]; // ... ForView int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); string fmType = hdfFmType.Value; int loginId = Convert.ToInt32(Session["loginID"]); string viewTypeGlobal = ""; string viewTypePersonal = "Personal"; // Global Views check if (Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_VIEW"])) { viewTypeGlobal = "Global"; } FmViewList fmViewList = new FmViewList(); fmViewList.LoadAndAddItem(fmType, viewTypeGlobal, viewTypePersonal, loginId, companyId); ddlView.DataSource = fmViewList.Table; ddlView.DataValueField = "ViewID"; ddlView.DataTextField = "Name"; ddlView.DataBind(); ddlView.SelectedValue = Request.QueryString["search_ddlView"]; //Other values //... For SortBy odsSortByList.DataBind(); ddlSortBy.DataSourceID = "odsSortByList"; ddlSortBy.DataValueField = "SortID"; ddlSortBy.DataTextField = "Name"; ddlSortBy.DataBind(); ddlSortBy.SelectedValue = Request.QueryString["search_sort_by"]; // ... For BtnOrigin hdfBtnOrigin.Value = Request.QueryString["btn_origin"]; // Grid's columns grdUnitsNavigator.Columns[2].Visible = (columnsToDisplay.IndexOf("Code") >= 0 ? true : false); grdUnitsNavigator.Columns[3].Visible = (columnsToDisplay.IndexOf("Description") >= 0 ? true : false); grdUnitsNavigator.Columns[4].Visible = (columnsToDisplay.IndexOf("VIN/SN") >= 0 ? true : false); grdUnitsNavigator.Columns[5].Visible = (columnsToDisplay.IndexOf(", State") >= 0 ? true : false); grdUnitsNavigator.Columns[6].Visible = (columnsToDisplay.IndexOf("Manufacturer") >= 0 ? true : false); grdUnitsNavigator.Columns[7].Visible = (columnsToDisplay.IndexOf("Model") >= 0 ? true : false); grdUnitsNavigator.Columns[8].Visible = (columnsToDisplay.IndexOf("Is Towable?") >= 0 ? true : false); grdUnitsNavigator.Columns[9].Visible = (columnsToDisplay.IndexOf("Insurance Class") >= 0 ? true : false); grdUnitsNavigator.Columns[10].Visible = (columnsToDisplay.IndexOf("Ryder Specified") >= 0 ? true : false); // before 9 after 11 grdUnitsNavigator.Columns[11].Visible = (columnsToDisplay.IndexOf("Model Year") >= 0 ? true : false); grdUnitsNavigator.Columns[12].Visible = (columnsToDisplay.IndexOf("Category") >= 0 ? true : false); grdUnitsNavigator.Columns[13].Visible = (columnsToDisplay.IndexOf("Company Level") >= 0 ? true : false); grdUnitsNavigator.Columns[14].Visible = (columnsToDisplay.IndexOf("Acquisition Date") >= 0 ? true : false); grdUnitsNavigator.Columns[15].Visible = (columnsToDisplay.IndexOf("Cost (CAD)") >= 0 ? true : false); grdUnitsNavigator.Columns[16].Visible = (columnsToDisplay.IndexOf("Cost (USD)") >= 0 ? true : false); grdUnitsNavigator.Columns[17].Visible = (columnsToDisplay.IndexOf("License Country") >= 0 ? true : false); grdUnitsNavigator.Columns[18].Visible = (columnsToDisplay.IndexOf("License State") >= 0 ? true : false); grdUnitsNavigator.Columns[19].Visible = (columnsToDisplay.IndexOf("License Plate Number") >= 0 ? true : false); grdUnitsNavigator.Columns[20].Visible = (columnsToDisplay.IndexOf("Apportioned Tag Number") >= 0 ? true : false); grdUnitsNavigator.Columns[21].Visible = (columnsToDisplay.IndexOf("Actual Weight") >= 0 ? true : false); grdUnitsNavigator.Columns[22].Visible = (columnsToDisplay.IndexOf("Registered Weight") >= 0 ? true : false); grdUnitsNavigator.Columns[23].Visible = (columnsToDisplay.IndexOf("Tire Size Front") >= 0 ? true : false); grdUnitsNavigator.Columns[24].Visible = (columnsToDisplay.IndexOf("Tire Size Back") >= 0 ? true : false); grdUnitsNavigator.Columns[25].Visible = (columnsToDisplay.IndexOf("Number Of Axes") >= 0 ? true : false); grdUnitsNavigator.Columns[26].Visible = (columnsToDisplay.IndexOf("Fuel Type") >= 0 ? true : false); grdUnitsNavigator.Columns[27].Visible = (columnsToDisplay.IndexOf("Beginning Odometer") >= 0 ? true : false); grdUnitsNavigator.Columns[28].Visible = (columnsToDisplay.IndexOf("Is Reefer Equipped?") >= 0 ? true : false); grdUnitsNavigator.Columns[29].Visible = (columnsToDisplay.IndexOf("Is PTO Equipped?") >= 0 ? true : false); grdUnitsNavigator.Columns[30].Visible = (columnsToDisplay.IndexOf("Owner Type") >= 0 ? true : false); grdUnitsNavigator.Columns[31].Visible = (columnsToDisplay.IndexOf("Owner Country") >= 0 ? true : false); grdUnitsNavigator.Columns[32].Visible = (columnsToDisplay.IndexOf("Owner State") >= 0 ? true : false); grdUnitsNavigator.Columns[33].Visible = (columnsToDisplay.IndexOf("Owner Name") >= 0 ? true : false); grdUnitsNavigator.Columns[34].Visible = (columnsToDisplay.IndexOf("Contact Info") >= 0 ? true : false); grdUnitsNavigator.Columns[35].Visible = (columnsToDisplay.IndexOf("Qualified Date") >= 0 ? true : false); grdUnitsNavigator.Columns[36].Visible = (columnsToDisplay.IndexOf("Not Qualified Date") >= 0 ? true : false); grdUnitsNavigator.Columns[37].Visible = (columnsToDisplay.IndexOf("Not Qualified Explain") >= 0 ? true : false); grdUnitsNavigator.Columns[38].Visible = (columnsToDisplay.IndexOf("Notes") >= 0 ? true : false); } catch { string url = "./units_navigator.aspx?source_page=out"; Response.Redirect(url); } }