// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // STEP6 - SUMMARY // // //////////////////////////////////////////////////////////////////////// // STEP6 - SUMMARY - METHODS // private void StepSummaryIn() { // Set instruction Label instruction = (Label)this.Master.FindControl("lblInstruction"); instruction.Text = "Summary"; // Tag Page hdfStep.Value = "StepSummary"; hdfUpdate.Value = "yes"; // Initialize summary FmView fmView = new FmView(fmViewTDS); // Process view FmViewTDS dataset = new FmViewTDS(); dataset.FmViewDisplayTemp.Merge(fmViewDisplayTemp, true); dataset.FmViewConditionNew.Merge(fmViewConditionNew, true); dataset.FmViewSortTemp.Merge(fmViewSortTemp, true); FmViewDisplayTemp modelFmViewDisplayTemp = new FmViewDisplayTemp(dataset); FmViewConditionNew modelFmViewConditionNew = new FmViewConditionNew(dataset); FmViewSortTemp modelFmViewSortTemp = new FmViewSortTemp(dataset); string summary = ""; summary = summary + "Name: " + tbxName.Text + "\n\n"; summary = summary + "Columns To Display; " + modelFmViewDisplayTemp.GetColumnsToDisplay() + "\n\n"; summary = summary + "Conditions: " + modelFmViewConditionNew.GetConditionsForSummary(hdfFmType.Value, int.Parse(hdfCompanyId.Value)) + "\n\n"; summary = summary + "Logical Expression: " + tbxLogic.Text + "\n\n"; summary = summary + "Order by: " + modelFmViewSortTemp.GetSortForSummary() + "\n\n"; tbxSummary.Text = summary; }
private void Save() { // Process view FmViewTDS dataset = new FmViewTDS(); dataset.FmViewDisplayTemp.Merge(fmViewDisplayTemp, true); dataset.FmViewConditionNew.Merge(fmViewConditionNew, true); dataset.FmViewSortTemp.Merge(fmViewSortTemp, true); FmViewDisplayTemp modelFmViewDisplayTemp = new FmViewDisplayTemp(dataset); FmViewConditionNew modelFmViewConditionNew = new FmViewConditionNew(dataset); FmViewSortTemp modelFmViewSortTemp = new FmViewSortTemp(dataset); // Get parameters int viewId = int.Parse(hdfViewId.Value); int companyId = int.Parse(hdfCompanyId.Value); int loginId = Convert.ToInt32(Session["loginID"]); string name = tbxName.Text; string type = ddlType.SelectedValue; string logic = tbxLogic.Text; string sqlCommand = GetSqlCommand(); string fmType = hdfFmType.Value; if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_ADD"])) && ((string)Request.QueryString["fm_type"] == "Services")) { if ((Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_SERVICES_VIEW"])) && ((string)Request.QueryString["fm_type"] == "Services")) { type = "Personal"; } } if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_ADD"])) && ((string)Request.QueryString["fm_type"] == "Units")) { if ((Convert.ToBoolean(Session["sgLFS_FLEETMANAGEMENT_UNITS_VIEW"])) && ((string)Request.QueryString["fm_type"] == "Units")) { type = "Personal"; } } // Save to database DB.Open(); DB.BeginTransaction(); try { FmView fmView = new FmView(null); fmView.InsertDirect(viewId, loginId, name, type, logic, sqlCommand, fmType, false, companyId); modelFmViewDisplayTemp.Save(); modelFmViewConditionNew.Save(viewId, companyId, fmType); modelFmViewSortTemp.Save(viewId, fmType, companyId); DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }
private bool StepColumnsToDisplayNext() { ViewState["columnsToDisplayPageIndex"] = grdColumnsToDisplay.PageIndex; Page.Validate("ColumsToDisplay"); if (Page.IsValid) { StepColumnsToDisplayProcessGrid(); fmViewDisplayTemp.Rows.Clear(); // Create dataset FmViewTDS dataSet = new FmViewTDS(); dataSet.LFS_FM_TYPE_VIEW_DISPLAY.Merge(fmTypeViewDisplay, true); dataSet.FmViewDisplayTemp.Merge(fmViewDisplayTemp, true); // Process new sections FmViewDisplayTemp model = new FmViewDisplayTemp(dataSet); model.Process(int.Parse(hdfViewId.Value), hdfFmType.Value, int.Parse(hdfCompanyId.Value)); // Get changes fmViewDisplayTemp.Rows.Clear(); fmViewDisplayTemp.Merge(model.Table); // Store tables Session.Remove("fmTypeViewDisplayDummy"); Session["fmTypeViewDisplay"] = fmTypeViewDisplay; Session["fmViewDisplayTemp"] = fmViewDisplayTemp; return true; } else { return false; } }
private bool StepColumnsToDisplayNext() { ViewState["columnsToDisplayPageIndex"] = grdColumnsToDisplay.PageIndex; Page.Validate("ColumsToDisplay"); if (Page.IsValid) { hdfStep.Value = "StepColumnsToDisplay"; StepColumnsToDisplayProcessGrid(); fmViewDisplayTemp.Rows.Clear(); // Create dataset FmViewTDS dataSet = new FmViewTDS(); dataSet.LFS_FM_TYPE_VIEW_DISPLAY.Merge(fmTypeViewDisplay, true); dataSet.FmViewDisplayTemp.Merge(fmViewDisplayTemp, true); // Process int companyId = Int32.Parse(hdfCompanyId.Value); string fmType = hdfFmType.Value; int viewId = Int32.Parse(hdfViewId.Value); FmViewDisplayTemp model = new FmViewDisplayTemp(dataSet); model.ProcessForEdit(viewId, fmType, companyId); // get changes fmViewDisplayTemp.Rows.Clear(); fmViewDisplayTemp.Merge(model.Table); // Store tables Session.Remove("fmTypeViewDisplayDummy"); Session["fmTypeViewDisplay"] = fmTypeViewDisplay; Session["fmViewDisplayTemp"] = fmViewDisplayTemp; // Load conditions for next step dataSet.FmViewConditionNew.Merge(fmViewConditionNew, true); dataSet.FmViewConditionTemp.Merge(fmViewConditionTemp, true); FmViewConditionNew modelConditionNew = new FmViewConditionNew(dataSet); modelConditionNew.LoadByViewIdCompanyIdFmType(viewId, companyId, fmType); // Store tables fmViewConditionNew = (FmViewTDS.FmViewConditionNewDataTable)modelConditionNew.Table; Session["fmViewConditionNew"] = fmViewConditionNew; return true; } else { return false; } }