protected void Page_Load(object sender, EventArgs e)
{
try
{
DataTable dt = new JpmmsCharting().GetRegionsRatingChart(int.Parse(Request.QueryString["id"]));
chkMainStUDI.Palette = System.Web.UI.DataVisualization.Charting.ChartColorPalette.None;
chkMainStUDI.PaletteCustomColors = new Color[] { Color.Green, Color.Yellow, Color.Blue, Color.Red };
chkMainStUDI.Series[0].XValueMember = "u_rating";
chkMainStUDI.Series[0].YValueMembers = "udi_rate_count";
chkMainStUDI.Series[0].Label = "#PERCENT";
chkMainStUDI.Series[0].LegendText = "#AXISLABEL";
chkMainStUDI.DataSource = dt;
chkMainStUDI.DataBind();
chkMainstBars.Palette = System.Web.UI.DataVisualization.Charting.ChartColorPalette.None;
chkMainstBars.PaletteCustomColors = new Color[] { Color.DarkSlateGray };
chkMainstBars.Series[0].XValueMember = "u_rating";
chkMainstBars.Series[0].YValueMembers = "udi_rate_count";
chkMainstBars.DataSource = dt;
chkMainstBars.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
//RadChart1.HttpHandlerUrl = ResolveUrl("ChartImage.axd");
//DataTable dtRates = UdiShared.GetDistrinctRates();
if (Session["Permissions"] == null || Session["Permissions"].ToString()[7] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (string.IsNullOrEmpty(Request.QueryString["id"]))
{
Response.Redirect("ChartedPavementStatus.aspx", false);
}
DataTable dt = new JpmmsCharting().GetSectionsRatingChart(int.Parse(Request.QueryString["id"]));
chkMainStUDI.Palette = System.Web.UI.DataVisualization.Charting.ChartColorPalette.None;
chkMainStUDI.PaletteCustomColors = new Color[] { Color.Green, Color.Yellow, Color.Blue, Color.Red };
chkMainStUDI.Series[0].XValueMember = "u_rating";
chkMainStUDI.Series[0].YValueMembers = "udi_rate_count";
chkMainStUDI.Series[0].Label = "#PERCENT";
chkMainStUDI.Series[0].LegendText = "#AXISLABEL";
chkMainStUDI.DataSource = dt;
chkMainStUDI.DataBind();
chkMainstBars.Palette = System.Web.UI.DataVisualization.Charting.ChartColorPalette.None;
chkMainstBars.PaletteCustomColors = new Color[] { Color.DarkSlateGray };
chkMainstBars.Series[0].XValueMember = "u_rating";
chkMainstBars.Series[0].YValueMembers = "udi_rate_count";
chkMainstBars.DataSource = dt;
chkMainstBars.DataBind();
//RadChart1.DataSource = dt;
//RadChart1.Series[0].DataYColumn = "udi_rate_count";
//RadChart1.PlotArea.XAxis.DataLabelsColumn = "UDI_RATE";
//RadChart1.PlotArea.XAxis.Appearance.LabelAppearance.RotationAngle = 300;
//RadChart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Color = Color.BlueViolet;
//RadChart1.PlotArea.Appearance.Dimensions.Margins.Bottom = Telerik.Charting.Styles.Unit.Percentage(30);
//RadChart1.DataBind();
//RadChart2.DataSource = dt;
//foreach (DataRow dr in dtRates.Rows)
// RadChart2.Series.Add(new ChartSeries(dr["UDI_RATE"].ToString()));
////RadChart2.Series[0].DataYColumn = "udi_rate_count";
//RadChart2.PlotArea.XAxis.DataLabelsColumn = "UDI_RATE";
//RadChart2.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[7] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (string.IsNullOrEmpty(Request.QueryString["id"]))
{
Response.Redirect("ChartedPavementStatus.aspx", false);
}
DataTable dt = new JpmmsCharting().GetRegionsRatingChart(int.Parse(Request.QueryString["id"]));
chkMainStUDI.Palette = System.Web.UI.DataVisualization.Charting.ChartColorPalette.None;
chkMainStUDI.PaletteCustomColors = new Color[] { Color.Green, Color.Yellow, Color.Blue, Color.Red };
chkMainStUDI.Series[0].XValueMember = "u_rating";
chkMainStUDI.Series[0].YValueMembers = "udi_rate_count";
chkMainStUDI.Series[0].Label = "#PERCENT";
chkMainStUDI.Series[0].LegendText = "#AXISLABEL";
chkMainStUDI.DataSource = dt;
chkMainStUDI.DataBind();
chkMainstBars.Palette = System.Web.UI.DataVisualization.Charting.ChartColorPalette.None;
chkMainstBars.PaletteCustomColors = new Color[] { Color.DarkSlateGray };
chkMainstBars.Series[0].XValueMember = "u_rating";
chkMainstBars.Series[0].YValueMembers = "udi_rate_count";
chkMainstBars.DataSource = dt;
chkMainstBars.DataBind();
}
catch (Exception ex)
{
Response.Write(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 (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;
}
}
