protected void btnShowReport_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; lblTotal.Visible = false; if (radAreas.Checked) { if (raddtpFrom.SelectedDate == null) { throw new Exception("الرجاء تحديد التاريخ"); } lblTotal.Text = new JpmmsCharting().GetDailyDataEntryTotalArea(raddtpFrom.SelectedDate).ToString("N2"); lblTotal.Visible = true; } else if (radLENGTH.Checked) { if (ddlRegions.SelectedValue == "0") { throw new Exception("الرجاء اختيار المنطقة"); } lblTotal.Text = new Region().GetRegionSamplesTotalLength(int.Parse(ddlRegions.SelectedValue)).ToString(); lblTotal.Visible = true; } else if (radNetworkArea.Checked) { PavementStatusReport total = new JpmmsCharting().GetWholeNetworkArea(); lblTotal.Text = string.Format("مقاطع: {0} م2 \n تقاطعات: {1} م2 \n مناطق فرعية: {2} م2 \n المجموع: {3} م2", total.MainStSectionsTotal.ToString("N2"), total.MainStIntersectsTotal.ToString("N2"), total.RegionsTotal.ToString("N2"), total.WholeNetworkTotal.ToString("N2")); lblTotal.Visible = true; } else if (radIntersectTypes.Checked) { DataTable dt = new GeneralPmmsReporting().GetIntersectionTypes(); Session.Add("option", "radIntersectTypes"); Session.Add("ReportData", dt); string url = "ViewOtherReports.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radMaintDeciding.Checked) { DataTable dt = new MaintDeciding().GetAllMaintDeciding(); Session.Add("option", "radMaintDeciding"); Session.Add("ReportData", dt); string url = "ViewOtherReports.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radSurveyors.Checked) { DataTable dt = new Surveyor().GetAllSurveyors(); Session.Add("option", "radSurveyors"); Session.Add("ReportData", dt); string url = "ViewOtherReports.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radMaintDecisions.Checked) { DataTable dt = new MaintDecision().GetAllDecisions(); Session.Add("option", "radMaintDecisions"); Session.Add("ReportData", dt); string url = "ViewOtherReports.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radFWD.Checked) { lblTotal.Text = " Point " + new MaintDecision().GetAllDecisionsFWD_HAFRIAT(); lblTotal.Visible = true; } else if (radGPR.Checked) { lblTotal.Text = " km/Lane " + new MainStreet().TOTALSUMGPR().Rows[0][0].ToString(); //lblTotal.Text = "1510.21 km/Lane"; lblTotal.Visible = true; } else if (radSKID.Checked) { lblTotal.Text = " km/Lane " + new MainStreet().TOTALSUMSKID().Rows[0][0].ToString(); lblTotal.Visible = true; } else if (radIRI.Checked) { lblTotal.Text = " km/Lane " + new MaintDecision().GetAllDecisionsIRI(); lblTotal.Visible = true; } else if (radDIST.Checked) { lblTotal.Text = " km/Lane " + new MaintDecision().GetAllDecisionsDDF(); lblTotal.Visible = true; } else if (radAssets.Checked) { lblTotal.Text = " km/direction " + new MaintDecision().GetAllDecisionsAssets(); lblTotal.Visible = true; } else if (radRegionsALL.Checked) { lblTotal.Text = " m2 " + new MaintDecision().GetAllSURVEYORS_REGIONS(); lblTotal.Visible = true; } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }
protected void btnShowReport_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; lblTotal.Visible = false; if (radAreas.Checked) { if (raddtpFrom.SelectedDate == null) { throw new Exception("الرجاء تحديد التاريخ"); } lblTotal.Text = new JpmmsCharting().GetDailyDataEntryTotalArea(raddtpFrom.SelectedDate).ToString("N2"); lblTotal.Visible = true; } else if (radNetworkArea.Checked) { PavementStatusReport total = new JpmmsCharting().GetWholeNetworkArea(); lblTotal.Text = string.Format("مقاطع: {0} م2 \n تقاطعات: {1} م2 \n مناطق فرعية: {2} م2 \n المجموع: {3} م2", total.MainStSectionsTotal.ToString("N2"), total.MainStIntersectsTotal.ToString("N2"), total.RegionsTotal.ToString("N2"), total.WholeNetworkTotal.ToString("N2")); lblTotal.Visible = true; } else if (radIntersectTypes.Checked) { DataTable dt = new GeneralPmmsReporting().GetIntersectionTypes(); Session.Add("option", "radIntersectTypes"); Session.Add("ReportData", dt); string url = "ViewOtherReports.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radMaintDeciding.Checked) { DataTable dt = new MaintDeciding().GetAllMaintDeciding(); Session.Add("option", "radMaintDeciding"); Session.Add("ReportData", dt); string url = "ViewOtherReports.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radSurveyors.Checked) { DataTable dt = new Surveyor().GetAllSurveyors(); Session.Add("option", "radSurveyors"); Session.Add("ReportData", dt); string url = "ViewOtherReports.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else if (radMaintDecisions.Checked) { DataTable dt = new MaintDecision().GetAllDecisions(); Session.Add("option", "radMaintDecisions"); Session.Add("ReportData", dt); string url = "ViewOtherReports.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }