// ///////////////////////////////////////////////////////////////////////////////////////////////////// // // 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 WorkView workView = new WorkView(workViewTDS); // process view WorkViewTDS dataset = new WorkViewTDS(); dataset.WorkViewDisplayTemp.Merge(workViewDisplayTemp, true); dataset.WorkViewConditionNew.Merge(workViewConditionNew, true); dataset.WorkViewSortTemp.Merge(workViewSortTemp, true); WorkViewDisplayTemp modelWorkViewDisplayTemp = new WorkViewDisplayTemp(dataset); WorkViewConditionNew modelWorkViewConditionNew = new WorkViewConditionNew(dataset); WorkViewSortTemp modelWorkViewSortTemp = new WorkViewSortTemp(dataset); string summary = ""; summary = summary + "Name: " + tbxName.Text + "\n\n"; summary = summary + "Columns To Display; " + modelWorkViewDisplayTemp.GetColumnsToDisplay() + "\n\n"; summary = summary + "Conditions: " + modelWorkViewConditionNew.GetConditionsForSummary(hdfWorkType.Value, int.Parse(hdfCompanyId.Value)) + "\n\n"; summary = summary + "Logical Expression: " + tbxLogic.Text + "\n\n"; summary = summary + "Order by: " + modelWorkViewSortTemp.GetSortForSummary() + "\n\n"; tbxSummary.Text = summary; }
private void UpdateDatabaseForViews() { int viewId = Int32.Parse(ddlView.SelectedValue.Trim()); int companyId = Int32.Parse(hdfCompanyId.Value.Trim()); DB.Open(); DB.BeginTransaction(); try { WorkView workView = new WorkView(null); workView.DeleteDirect(viewId, 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 void Save() { // process view WorkViewTDS dataset = new WorkViewTDS(); dataset.WorkViewDisplayTemp.Merge(workViewDisplayTemp, true); dataset.WorkViewConditionNew.Merge(workViewConditionNew, true); dataset.WorkViewSortTemp.Merge(workViewSortTemp, true); WorkViewDisplayTemp modelWorkViewDisplayTemp = new WorkViewDisplayTemp(dataset); WorkViewConditionNew modelWorkViewConditionNew = new WorkViewConditionNew(dataset); WorkViewSortTemp modelWorkViewSortTemp = new WorkViewSortTemp(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 workType = hdfWorkType.Value; if (!(Convert.ToBoolean(Session["sgLFS_VIEWS_ADD"]))) { if ((string)Request.QueryString["fm_type"] == "Rehab Assessment") { if (Convert.ToBoolean(Session["sgLFS_CWP_REHABASSESSMENT_VIEW"])) { type = "Personal"; } } if ((string)Request.QueryString["fm_type"] == "Full Length Lining") { if (Convert.ToBoolean(Session["sgLFS_CWP_FULLLENGTHLINING_VIEW"])) { type = "Personal"; } } if ((string)Request.QueryString["fm_type"] == "Junction Lining") { if (Convert.ToBoolean(Session["sgLFS_CWP_JUNCTIONLINING_VIEW"])) { type = "Personal"; } } if ((string)Request.QueryString["fm_type"] == "Point Repairs") { if (Convert.ToBoolean(Session["sgLFS_CWP_POINTREPAIRS_VIEW"])) { type = "Personal"; } } if ((string)Request.QueryString["fm_type"] == "Manhole Repairs") { if (Convert.ToBoolean(Session["sgLFS_CWP_MANHOLEREHABILITATION_VIEW"])) { type = "Personal"; } } } // save to database DB.Open(); DB.BeginTransaction(); try { WorkView workView = new WorkView(null); workView.InsertDirect(viewId, loginId, name, type, logic, sqlCommand, workType, false, companyId); modelWorkViewDisplayTemp.Save(); modelWorkViewConditionNew.Save(viewId, companyId, workType); modelWorkViewSortTemp.Save(viewId, workType, companyId); DB.CommitTransaction(); } catch (Exception ex) { DB.RollbackTransaction(); string url = string.Format("./../../error_page.aspx?error={0}", ex.Message.Replace('\n', ' ')); Response.Redirect(url); } }