// //////////////////////////////////////////////////////////////////////// // PUBLIC METHODS // /// <summary> /// DeleteDirect /// </summary> /// <param name="viewId">viewId</param> /// <param name="companyId">companyId</param> public void DeleteDirect(int viewId, int companyId) { FmViewDisplay fmViewDisplay = new FmViewDisplay(null); fmViewDisplay.DeleteDirect(viewId, companyId); FmViewCondition fmViewCondition = new FmViewCondition(null); fmViewCondition.DeleteDirect(viewId, companyId); FmViewSort fmViewSort = new FmViewSort(null); fmViewSort.DeleteDirect(viewId, companyId); FmViewGateway fmViewGateway = new FmViewGateway(null); fmViewGateway.Delete(viewId, companyId); }
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; }
// //////////////////////////////////////////////////////////////////////// // EVENTS // protected void Page_Load(object sender, EventArgs e) { // Register client scripts this.RegisterClientScripts(); if (!IsPostBack) { // Validate query string if (((string)Request.QueryString["source_page"] == null) || ((string)Request.QueryString["fm_type"] == null)) { Response.Redirect("./../../error_page.aspx?error=" + "Invalid query string in view_add.aspx"); } // Security check if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_ADD"]))) { if ((string)Request.QueryString["fm_type"] == "Services") { 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."); } } if ((string)Request.QueryString["fm_type"] == "Units") { if (!(Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"]))) { Response.Redirect("./../../error_page.aspx?error=" + "You are not authorized to view this page. Contact your system administrator."); } } } // Tag page hdfFmType.Value = (string)Request.QueryString["fm_type"]; hdfCompanyId.Value = Session["companyID"].ToString(); hdfUpdate.Value = "no"; ViewState["columnsToDisplayPageIndex"] = 0; ViewState["sortPageIndex"] = 0; Session.Remove("fmTypeViewDisplay"); Session.Remove("fmTypeViewDisplayDummy"); Session.Remove("fmTypeViewSort"); Session.Remove("fmTypeViewSortDummy"); Session.Remove("fmViewDisplayTemp"); Session.Remove("fmViewSortTemp"); Session.Remove("fmViewConditionNew"); Session.Remove("fmViewConditionNewDummy"); Session.Remove("categoriesTDSForAddView"); FmViewGateway fmViewGateway = new FmViewGateway(); hdfViewId.Value = (fmViewGateway.GetLastViewId() + 1).ToString().Trim(); // Prepare initial data // ... For view type FmViewTypeList fmViewTypeList = new FmViewTypeList(new DataSet()); fmViewTypeList.LoadAndAddItem("(Select a type)", Int32.Parse(hdfCompanyId.Value)); ddlType.DataSource = fmViewTypeList.Table; ddlType.DataValueField = "Type"; ddlType.DataTextField = "Type"; ddlType.DataBind(); ddlType.SelectedIndex = 0; // ... Global Views check if (!Convert.ToBoolean(Session["sgLFS_GLOBALVIEWS_ADD"])) { ddlType.Items.Remove("Global"); } // If coming from // ... services_navigator.aspx, services_navigator2.aspx, units_navigator.aspx or units_navigator2.aspx if ((Request.QueryString["source_page"] == "services_navigator.aspx") || (Request.QueryString["source_page"] == "services_navigator2.aspx") || (Request.QueryString["source_page"] == "units_navigator.aspx") || (Request.QueryString["source_page"] == "unit_navigator2.aspx")) { // ... For Grids fmViewTDS = new FmViewTDS(); fmTypeViewDisplay = new FmViewTDS.LFS_FM_TYPE_VIEW_DISPLAYDataTable(); fmTypeViewSort = new FmViewTDS.LFS_FM_TYPE_VIEW_SORTDataTable(); fmViewDisplayTemp = new FmViewTDS.FmViewDisplayTempDataTable(); fmViewSortTemp = new FmViewTDS.FmViewSortTempDataTable(); fmViewConditionNew = new FmViewTDS.FmViewConditionNewDataTable(); // ... for Categories categoriesTDS = new CategoriesTDS(); // ... Store datasets Session["fmViewTDS"] = fmViewTDS; Session["fmTypeViewDisplay"] = fmTypeViewDisplay; Session["fmTypeViewSort"] = fmTypeViewSort; Session["fmViewDisplayTemp"] = fmViewDisplayTemp; Session["fmViewSortTemp"] = fmViewSortTemp; Session["fmViewConditionNew"] = fmViewConditionNew; Session["categoriesTDSForAddView"] = categoriesTDS; } // StepSection1In wzViews.ActiveStepIndex = 0; StepBeginIn(); } else { // Restore datasets fmViewTDS = (FmViewTDS)Session["fmViewTDS"]; fmTypeViewDisplay = (FmViewTDS.LFS_FM_TYPE_VIEW_DISPLAYDataTable)Session["fmTypeViewDisplay"]; fmTypeViewSort = (FmViewTDS.LFS_FM_TYPE_VIEW_SORTDataTable)Session["fmTypeViewSort"]; fmViewDisplayTemp = (FmViewTDS.FmViewDisplayTempDataTable)Session["fmViewDisplayTemp"]; fmViewSortTemp = (FmViewTDS.FmViewSortTempDataTable)Session["fmViewSortTemp"]; fmViewConditionNew = (FmViewTDS.FmViewConditionNewDataTable)Session["fmViewConditionNew"]; categoriesTDS = (CategoriesTDS)Session["categoriesTDSForAddView"]; } // Control for postback hdfTag.Value = DateTime.Now.ToLongTimeString(); }
private ServicesNavigatorTDS SubmitSearchForViews() { int viewId = Int32.Parse(ddlView.SelectedValue.Trim()); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); // ... Load SqlCommand FmViewGateway fmViewGateway = new FmViewGateway(); fmViewGateway.LoadByViewId(viewId, companyId); string sqlCommand = ""; sqlCommand = fmViewGateway.GetSqlCommand(viewId); // ... Load data string fmType = hdfFmType.Value.Trim(); ServicesNavigator servicesNavigator = new ServicesNavigator(); servicesNavigator.LoadForViewsFmTypeCompanyId(sqlCommand, fmType, companyId); return (ServicesNavigatorTDS)servicesNavigator.Data; }
protected void btnExportList_Click(object sender, EventArgs e) { string url = ""; string headerValues = ""; int totalColumnsExport = 29; int totalColumnsPreview = 28; string title = "Services Search Results"; string columnsForReport = ""; int j; // ... for title view if (hdfBtnOrigin.Value == "Go") { int viewId = Int32.Parse(ddlView.SelectedValue.Trim()); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); // ... Load name view FmViewGateway fmViewGateway = new FmViewGateway(); fmViewGateway.LoadByViewId(viewId, companyId); title = fmViewGateway.GetName(viewId); } // ... For comments option string comments = "None"; headerValues = ""; columnsForReport = ""; // Establishing header values if (grdServicesNavigator.Columns[2].Visible) headerValues += "Service Number"; if (grdServicesNavigator.Columns[3].Visible) headerValues += " * Date"; if (grdServicesNavigator.Columns[4].Visible) headerValues += " * Fixed Date"; if (grdServicesNavigator.Columns[5].Visible) headerValues += " * Service State"; if (grdServicesNavigator.Columns[6].Visible) headerValues += " * Problem Description"; if (grdServicesNavigator.Columns[7].Visible) headerValues += " * Unit Code"; if (grdServicesNavigator.Columns[8].Visible) headerValues += " * Unit Description"; if (grdServicesNavigator.Columns[9].Visible) headerValues += " * VIN/SN"; if (grdServicesNavigator.Columns[10].Visible) headerValues += " * Unit State"; if (grdServicesNavigator.Columns[11].Visible) headerValues += " * Checklist Rule"; if (grdServicesNavigator.Columns[12].Visible) headerValues += " * Checklist State"; if (grdServicesNavigator.Columns[13].Visible) headerValues += " * Created by"; if (grdServicesNavigator.Columns[14].Visible) headerValues += " * Mileage"; if (grdServicesNavigator.Columns[15].Visible) headerValues += " * Assign Date"; if (grdServicesNavigator.Columns[16].Visible) headerValues += " * Deadline Date"; if (grdServicesNavigator.Columns[17].Visible) headerValues += " * Assigned to"; if (grdServicesNavigator.Columns[18].Visible) headerValues += " * Accepted Date"; if (grdServicesNavigator.Columns[19].Visible) headerValues += " * Start Date"; if (grdServicesNavigator.Columns[20].Visible) headerValues += " * Unit Out Of Service Date"; if (grdServicesNavigator.Columns[21].Visible) headerValues += " * Unit Out Of Service Time"; if (grdServicesNavigator.Columns[22].Visible) headerValues += " * Start Work Mileage"; if (grdServicesNavigator.Columns[23].Visible) headerValues += " * Complete Date"; if (grdServicesNavigator.Columns[24].Visible) headerValues += " * Unit Back In Service Date"; if (grdServicesNavigator.Columns[25].Visible) headerValues += " * Unit Back In Service Time"; if (grdServicesNavigator.Columns[26].Visible) headerValues += " * Complete Work Mileage"; if (grdServicesNavigator.Columns[27].Visible) headerValues += " * Work Details"; if (grdServicesNavigator.Columns[28].Visible) headerValues += " * Preventable"; if (grdServicesNavigator.Columns[29].Visible) headerValues += " * Labour Hours"; if (grdServicesNavigator.Columns[30].Visible) headerValues += " * Notes"; // Establishing columns to display string[] columnsExcel = headerValues.Split('*'); // ... for visible columns for (int i = 0; i < columnsExcel.Length; i++) { j = i + 1; columnsForReport += "&header" + j + "=" + columnsExcel[i].Trim(); } // ... For not visible columns for (int i = columnsExcel.Length; i < totalColumnsExport; i++) { j = i + 1; columnsForReport += "&header" + j + "=None"; } if (grdServicesNavigator.Columns[30].Visible) comments = "Comments"; // Report call Page.Validate(); if (Page.IsValid) { PostPageChanges(); title = title.Replace("'", "%27"); Response.Write("<script language='javascript'> {window.open('./services_print_search_results_report.aspx?" + columnsForReport + "&comments=" + comments + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columnsExcel.Length + "&title=" + title + "&format=excel', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>"); } if (url != "") Response.Redirect(url); }
protected void btnPreviewList_Click(object sender, EventArgs e) { string url = ""; string headerValues = ""; int totalColumnsExport = 37; int totalColumnsPreview = 36; string title = "Units Search Results"; // ... for title view if (hdfBtnOrigin.Value == "Go") { int viewId = Int32.Parse(ddlView.SelectedValue.Trim()); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); // ... Load name view FmViewGateway fmViewGateway = new FmViewGateway(); fmViewGateway.LoadByViewId(viewId, companyId); title = fmViewGateway.GetName(viewId); } // ... For notes option string notes = "None"; // Establishing header values if (grdUnitsNavigator.Columns[2].Visible) headerValues += "Code"; if (grdUnitsNavigator.Columns[3].Visible) headerValues += " * Description"; if (grdUnitsNavigator.Columns[4].Visible) headerValues += " * VIN/SN"; if (grdUnitsNavigator.Columns[5].Visible) headerValues += " * State"; if (grdUnitsNavigator.Columns[6].Visible) headerValues += " * Manufacturer"; if (grdUnitsNavigator.Columns[7].Visible) headerValues += " * Model"; if (grdUnitsNavigator.Columns[8].Visible) headerValues += " * Is Towable?"; if (grdUnitsNavigator.Columns[9].Visible) headerValues += " * Insurance Class"; if (grdUnitsNavigator.Columns[10].Visible) headerValues += " * Ryder Specified"; // before columns 9 after columns 11 if (grdUnitsNavigator.Columns[11].Visible) headerValues += " * Model Year"; if (grdUnitsNavigator.Columns[12].Visible) headerValues += " * Category"; if (grdUnitsNavigator.Columns[13].Visible) headerValues += " * Company Level"; if (grdUnitsNavigator.Columns[14].Visible) headerValues += " * Acquisition Date"; if (grdUnitsNavigator.Columns[15].Visible) headerValues += " * Cost (CAD)"; if (grdUnitsNavigator.Columns[16].Visible) headerValues += " * Cost (USD)"; if (grdUnitsNavigator.Columns[17].Visible) headerValues += " * License Country"; if (grdUnitsNavigator.Columns[18].Visible) headerValues += " * License State"; if (grdUnitsNavigator.Columns[19].Visible) headerValues += " * License Plate Number"; if (grdUnitsNavigator.Columns[20].Visible) headerValues += " * Apportioned Tag Number"; if (grdUnitsNavigator.Columns[21].Visible) headerValues += " * Actual Weight"; if (grdUnitsNavigator.Columns[22].Visible) headerValues += " * Registered Weight"; if (grdUnitsNavigator.Columns[23].Visible) headerValues += " * Tire Size Front"; if (grdUnitsNavigator.Columns[24].Visible) headerValues += " * Tire Size Back"; if (grdUnitsNavigator.Columns[25].Visible) headerValues += " * Number Of Axes"; if (grdUnitsNavigator.Columns[26].Visible) headerValues += " * Fuel Type"; if (grdUnitsNavigator.Columns[27].Visible) headerValues += " * Beginning Odometer"; if (grdUnitsNavigator.Columns[28].Visible) headerValues += " * Is Reefer Equipped?"; if (grdUnitsNavigator.Columns[29].Visible) headerValues += " * Is PTO Equipped?"; if (grdUnitsNavigator.Columns[30].Visible) headerValues += " * Owner Type"; if (grdUnitsNavigator.Columns[31].Visible) headerValues += " * Owner Country"; if (grdUnitsNavigator.Columns[32].Visible) headerValues += " * Owner State"; if (grdUnitsNavigator.Columns[33].Visible) headerValues += " * Owner Name"; if (grdUnitsNavigator.Columns[34].Visible) headerValues += " * Contact Info"; if (grdUnitsNavigator.Columns[35].Visible) headerValues += " * Qualified Date"; if (grdUnitsNavigator.Columns[36].Visible) headerValues += " * Not Qualified Date"; if (grdUnitsNavigator.Columns[37].Visible) headerValues += " * Not Qualified Explain"; // Establishing columns to display string[] columns = headerValues.Split('*'); string columnsForReport = ""; int j; // ... For visible columns for (int i = 0; i < columns.Length; i++) { j = i + 1; columnsForReport += "&header" + j + "=" + columns[i].Trim(); } // ... For not visible columns for (int i = columns.Length; i < totalColumnsPreview; i++) { j = i + 1; columnsForReport += "&header" + j + "=None"; } if (grdUnitsNavigator.Columns[38].Visible) { notes = "Notes"; } // Report call Page.Validate(); if (Page.IsValid) { PostPageChanges(); title = title.Replace("'", "%27"); Response.Write("<script language='javascript'> {window.open('./units_print_search_results_report.aspx?" + columnsForReport + "¬es=" + notes + "&totalColumnsPreview=" + totalColumnsPreview + "&totalColumnsExport=" + totalColumnsExport + "&totalSelectedColumns=" + columns.Length + "&title=" + title + "&format=pdf', '_blank', 'toolbar=no, location=no, directories=no, status=yes, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=800, height=680');}</script>"); } if (url != "") Response.Redirect(url); }
/// <summary> /// SaveForEdit /// </summary> /// <param name="viewId">viewId</param> /// <param name="loginId">loginId</param> /// <param name="name">name</param> /// <param name="type">type</param> /// <param name="logic">logic</param> /// <param name="sqlCommand">sqlCommand</param> /// <param name="fmType">fmType</param> /// <param name="companyId">companyId</param> public void SaveForEdit(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string fmType, int companyId, string newName, string newType) { FmViewGateway fmViewGateway = new FmViewGateway(); fmViewGateway.LoadByViewId(viewId, companyId); int originalViewId = viewId; int originalLoginId = fmViewGateway.GetLoginId(viewId); string originalName = fmViewGateway.GetName(viewId); string originalType = fmViewGateway.GetType(viewId); string originalLogic = fmViewGateway.GetLogic(viewId); string originalSqlCommand = fmViewGateway.GetSqlCommand(viewId); string originalFmType = fmViewGateway.GetFmType(viewId); bool originalDeleted = fmViewGateway.GetDeleted(viewId); int originalCompanyId = fmViewGateway.GetCompanyId(viewId); UpdateDirect(originalViewId, originalLoginId, originalName, originalType, originalLogic, originalSqlCommand, originalFmType, originalDeleted, originalCompanyId, viewId, loginId, newName, newType, logic, sqlCommand, fmType, false, companyId); }
/// <summary> /// InsertDirect /// </summary> /// <param name="viewId">viewId</param> /// <param name="loginId">loginId</param> /// <param name="name">name</param> /// <param name="type">type</param> /// <param name="logic">logic</param> /// <param name="sqlCommand">sqlCommand</param> /// <param name="fmType">fmType</param> /// <param name="deleted">deleted</param> /// <param name="companyId">companyId</param> public void InsertDirect(int viewId, int loginId, string name, string type, string logic, string sqlCommand, string fmType, bool deleted, int companyId) { FmViewGateway fmViewGateway = new FmViewGateway(null); fmViewGateway.Insert(viewId, loginId, name, type, logic, sqlCommand, fmType, deleted, companyId); }
/// <summary> /// UpdateDirect /// </summary> /// <param name="originalViewId">originalViewId</param> /// <param name="originalLoginId">originalLoginId</param> /// <param name="originalName">originalName</param> /// <param name="originalType">originalType</param> /// <param name="origianlLogic">origianlLogic</param> /// <param name="originalSqlCommand">originalSqlCommand</param> /// <param name="originalFmType">originalFmType</param> /// <param name="originalDeleted">originalDeleted</param> /// <param name="originalCompanyId">originalCompanyId</param> /// <param name="newViewID">newViewID</param> /// <param name="newLoginId">newLoginId</param> /// <param name="newName">newName</param> /// <param name="newType">newType</param> /// <param name="newLogic">newLogic</param> /// <param name="newSqlCommand">newSqlCommand</param> /// <param name="newFmType">newFmType</param> /// <param name="newDeleted">newDeleted</param> /// <param name="newCompanyId">newCompanyId</param> public void UpdateDirect(int originalViewId, int originalLoginId, string originalName, string originalType, string origianlLogic, string originalSqlCommand, string originalFmType, bool originalDeleted, int originalCompanyId, int newViewID, int newLoginId, string newName, string newType, string newLogic, string newSqlCommand, string newFmType, bool newDeleted, int newCompanyId) { FmViewGateway fmViewGateway = new FmViewGateway(null); fmViewGateway.Update(originalViewId, originalLoginId, originalName, originalType, origianlLogic, originalSqlCommand, originalFmType, originalDeleted, originalCompanyId, newViewID, newLoginId, newName, newType, newLogic, newSqlCommand, newFmType, newDeleted, newCompanyId); }
private bool StepConditionsNext() { // Validate data bool validData = true; // Edit if there is data to save Page.Validate("ConditionsUpdate"); if (!Page.IsValid) validData = false; if (validData) { // Conditions Gridview, if the gridview is edition mode if (grdConditions.EditIndex >= 0) { grdConditions.UpdateRow(grdConditions.EditIndex, true); grdConditions.DataBind(); } } Page.Validate("ConditionsNext"); if (!Page.IsValid) validData = false; if (validData) { // Add conditions if exists at footer if (ValidateFooterNext()) { GrdConditionsAdd(); } int companyId = Int32.Parse(hdfCompanyId.Value); int viewId = Int32.Parse(hdfViewId.Value); FmViewGateway fmViewGateway = new FmViewGateway(); fmViewGateway.LoadByViewId(viewId, companyId ); fmViewConditionTemp.Rows.Clear(); // Create dataset FmViewTDS dataSet = new FmViewTDS(); dataSet.FmViewConditionNew.Merge(fmViewConditionNew, true); dataSet.FmViewConditionTemp.Merge(fmViewConditionTemp, true); // Process conditions FmViewConditionTemp model = new FmViewConditionTemp(dataSet); FmViewConditionNew modelLogic = new FmViewConditionNew(dataSet); string originalLogic = fmViewGateway.GetLogic(viewId); string newLogic = modelLogic.GetConditionsByDefault(); ArrayList aConditions = new ArrayList(); aConditions = modelLogic.GetConditions(); bool isConditionsUpdate = false; if (originalLogic.Trim() != newLogic.Trim()) { foreach (string conditionNumber in aConditions) { if (!originalLogic.Contains(conditionNumber)) { isConditionsUpdate = true; } } if (!isConditionsUpdate) { if (Session["conditionsUpdate"] != null) { if (Session["conditionsUpdate"].ToString() == "true") { isConditionsUpdate = true; } } } } else { tbxLogic.Text = originalLogic.Trim(); } if (isConditionsUpdate) { tbxLogic.Text = newLogic.Trim(); } else { tbxLogic.Text = originalLogic.Trim(); } // Get changes fmViewConditionNew.Rows.Clear(); fmViewConditionNew.Merge(modelLogic.Table); fmViewConditionTemp.Rows.Clear(); fmViewConditionTemp.Merge(model.Table); // Store tables Session.Remove("fmViewConditionNewDummy"); Session.Remove("fmViewConditionTempDummy"); Session["fmViewConditionNew"] = fmViewConditionNew; Session["fmViewConditionTemp"] = fmViewConditionTemp; Session["conditionsUpdate"] = null; return true; } else { return false; } }