protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (!IsPostBack)
{
if (Request.QueryString.Count == 1)
{
DropDownList1.Visible = false;
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().FinalCompareASSETS();
Label1.Text = " عدد الشوارع " + dt.Compute("Count(main_no)", string.Empty).ToString();
gvASSETES.DataSource = dt;
gvASSETES.DataBind();
}
else
{
Label1.Text = "المستخلص رقم";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().FinalCompareASSETS(null);
gvASSETES.DataSource = dt;
gvASSETES.DataBind();
CompareDiffr(gvASSETES);
}
ViewState["gvASSETES"] = gvASSETES.DataSource;
ViewState["sortdrDetials"] = "Asc";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1' || Request.QueryString.Count == 0)
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (!IsPostBack)
{
if (Request.QueryString.Count == 1)
{
System.Data.DataTable dt;
if (Request.QueryString[0].ToString() == "0")
{
Label1.Text = "تقاطعات تحتاج مراجعة الادخال";
dt = new JpmmsClasses.BL.MainStreet().ApproveInterSections(false);
lblFeedback.Text = "الطول الكلي تقاطعات تحتاج مراجعة للإدخال " + dt.Compute("Sum(TOTALLENGTH)", string.Empty).ToString();
gvRegionSamplesEqupment.DataSource = dt;
gvRegionSamplesEqupment.DataBind();
}
else if (Request.QueryString[0].ToString() == "1")
{
Label1.Text = "تقاطعات جاهزة للإدخال";
dt = new JpmmsClasses.BL.MainStreet().ApproveInterSections(true);
lblFeedback.Text = "الطول الكلي تقاطعات جاهزة للإدخال " + dt.Compute("Sum(TOTALLENGTH)", string.Empty).ToString();
gvRegionSamplesEqupment.DataSource = dt;
gvRegionSamplesEqupment.DataBind();
}
else
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (Request.QueryString.Count == 1)
{
if (Request.QueryString[0].ToString() == "FWD")
{
Label1.Text = "الحمل الساقط";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoFWD();
lblTotal.Text = " عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "GPR")
{
Label1.Text = "سماكات الطبقات";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoGPR();
lblTotal.Text = " عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "SKID")
{
Label1.Text = "مقاومة الإنزلاق";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoSKID();
lblTotal.Text = " عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "ASSETES")
{
Label1.Text = "أصول الطرق الرئيسية";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoASSETS();
lblTotal.Text = " عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "IRIDDF")
{
//LinkErorrSurvey.NavigateUrl += "IRIDDF";
//Label1.Text = "الوعورة - العيوب";
//System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().();
//lblTotal.Text = " عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
//gvErorr.DataSource = dt;
//gvErorr.DataBind();
}
else
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (Request.QueryString.Count == 1)
{
if (Request.QueryString[0].ToString() == "GPR")
{
Label1.Text = "سماكات الطبقات";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetMissingStreetsGPR();
lblFeedback.Text = " اجمالي عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "SKID")
{
Label1.Text = "مقاومة الإنزلاق";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetMissingStreetsSKID();
lblFeedback.Text = " اجمالي عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "ASSETES")
{
Label1.Text = "أصول الطرق الرئيسية ";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetMissingStreetsASSETS();
lblFeedback.Text = " اجمالي عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (Request.QueryString.Count == 1)
{
if (Request.QueryString[0].ToString() == "FWD")
{
LinkErorrSurvey.NavigateUrl += "FWD";
System.Data.DataTable dtErorr = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoFWD();
if (dtErorr.Rows.Count > 0)
{
spanErorrData.Visible = true;
spanErorrData.InnerText = dtErorr.Rows.Count.ToString();
}
else
{
spanErorrData.Visible = false;
spanErorrData.InnerText = string.Empty;
}
Label1.Text = "الحمل الساقط";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().FWD_NotComplete();
lblTotal.Text = " عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
lblSum.Text = " نقط الشوارع " + dt.Compute("Sum(LENGTH)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "GPR")
{
LinkErorrSurvey.NavigateUrl += "GPR";
System.Data.DataTable dtErorr = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoGPR();
if (dtErorr.Rows.Count > 0)
{
spanErorrData.Visible = true;
spanErorrData.InnerText = dtErorr.Rows.Count.ToString();
}
else
{
spanErorrData.Visible = false;
spanErorrData.InnerText = string.Empty;
}
Label1.Text = "سماكات الطبقات";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GPR_NotComplete();
lblTotal.Text = " عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
lblSum.Text = " طول الشوارع " + dt.Compute("Sum(LENGTH)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "SKID")
{
LinkErorrSurvey.NavigateUrl += "SKID";
System.Data.DataTable dtErorr = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoSKID();
if (dtErorr.Rows.Count > 0)
{
spanErorrData.Visible = true;
spanErorrData.InnerText = dtErorr.Rows.Count.ToString();
}
else
{
spanErorrData.Visible = false;
spanErorrData.InnerText = string.Empty;
}
Label1.Text = "مقاومة الإنزلاق";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().SKID_NotComplete();
lblTotal.Text = " اجمالي عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
lblSum.Text = " طول الشوارع " + dt.Compute("Sum(LENGTH)", string.Empty).ToString();
gvErorr.DataSource = dt;
gvErorr.DataBind();
}
else if (Request.QueryString[0].ToString() == "ASSETES")
{
LinkErorrSurvey.NavigateUrl += "ASSETES";
System.Data.DataTable dtErorr = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoASSETS();
if (dtErorr.Rows.Count > 0)
{
spanErorrData.Visible = true;
spanErorrData.InnerText = dtErorr.Rows.Count.ToString();
}
else
{
spanErorrData.Visible = false;
spanErorrData.InnerText = string.Empty;
}
Label1.Text = "أصول الطرق الرئيسية";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().ASSETES_NotComplete();
lblTotal.Text = " اجمالي عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
lblSum.Text = " طول الشوارع " + dt.Compute("Sum(LENGTH)", string.Empty).ToString();
GridView1.DataSource = dt;
GridView1.DataBind();
}
else if (Request.QueryString[0].ToString() == "IRIDDF")
{
LinkErorrSurvey.NavigateUrl += "IRIDDF";
System.Data.DataTable dtErorr = new JpmmsClasses.BL.MainStreet().ErorrSuerveyNoIRIDDF();
if (dtErorr.Rows.Count > 0)
{
spanErorrData.Visible = true;
spanErorrData.InnerText = dtErorr.Rows.Count.ToString();
}
else
{
spanErorrData.Visible = false;
spanErorrData.InnerText = string.Empty;
}
Label1.Text = "الوعورة - العيوب";
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().IRIDDF_NotComplete(null);
lblTotal.Text = " اجمالي عدد الشوارع " + dt.Compute("Count(MAIN_NO)", string.Empty).ToString();
lblSum.Text = " طول الشوارع " + dt.Compute("Sum(LENGTH)", string.Empty).ToString();
gvErorrIRIDDF.DataSource = dt;
gvErorrIRIDDF.DataBind();
}
else
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
}
}
