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 BtnStreet_Click(object sender, EventArgs e)
{
if (Session["UserID"].ToString() != "49" && Session["UserID"].ToString() != "55" && Session["UserID"].ToString() != "48")
{
lblFeedback.Text = Feedback.NoPermissions();
}
else
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().CheckErorrInsertLength();
if (dt.Rows.Count == 0)
{
if (new JpmmsClasses.BL.MainStreet().InsertNewStreetsDID(null))
{
lblFeedback.Text = Feedback.StatusUpdateSuccessfull();
gvRegionSamples.DataBind();
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else
{
lblFeedback.Text = "شوارع تحتاج تحديث الاطوال";
gvERorrLength.DataSource = dt;
gvERorrLength.DataBind();
}
}
}
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')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (!IsPostBack)
{
if (Request.QueryString.Count == 1)
{
Label1.Text = "تقاطعات تم استلامها";
DataTable dt = new JpmmsClasses.BL.MainStreet().GetInterSectionsComplete();
DataTable distinctValues = new DataView(dt).ToTable(true, dt.Columns[1].ColumnName, dt.Columns[2].ColumnName);
DropDownList1.DataSource = distinctValues;
DropDownList1.DataTextField = dt.Columns[2].ColumnName;
DropDownList1.DataValueField = dt.Columns[1].ColumnName;
DropDownList1.DataBind();
gvRegionSamplesEqupment.DataSource = dt;
gvRegionSamplesEqupment.DataBind();
}
else
{
Label1.Text = "تقاطعات تحتاج استلام";
DataTable dt = new JpmmsClasses.BL.MainStreet().GetInterSectionsMissing();
DataTable distinctValues = new DataView(dt).ToTable(true, dt.Columns[1].ColumnName, dt.Columns[2].ColumnName);
DropDownList1.DataSource = distinctValues;
DropDownList1.DataTextField = dt.Columns[2].ColumnName;
DropDownList1.DataValueField = dt.Columns[1].ColumnName;
DropDownList1.DataBind();
gvRegionSamplesEqupment.DataSource = dt;
gvRegionSamplesEqupment.DataBind();
}
}
}
protected void BtnFinshedMfv_Click(object sender, EventArgs e)
{
if (Request.QueryString.Count == 1 && Session["UserID"].ToString() == "48" && Request.QueryString[0].ToString() == "DID")
{
System.Data.DataTable dtErorrInsert = new JpmmsClasses.BL.MainStreet().CheckErorrInsertDDF();
if (dtErorrInsert != null && dtErorrInsert.Rows.Count == 0)
{
if (new JpmmsClasses.BL.MainStreet().FinalInsertDDF())
{
lblFeedback.Text = Feedback.UpdateSuccessfull();
gvRegionSamples.DataBind();
}
else
{
lblFeedback.Text = Feedback.UpdateUNSuccessfull();
}
}
else
{
lblFeedback.Text = "بيانات مدخلة خطأ ";
gvRegionSamplesErorr.DataSource = dtErorrInsert;
gvRegionSamplesErorr.DataBind();
}
}
else
{
lblFeedback.Text = Feedback.NoPermissions();
}
}
protected void BtnNewSections_Click(object sender, EventArgs e)
{
if (Session["UserID"].ToString() == "46" || Session["UserID"].ToString() == "54" || Session["UserID"].ToString() == "60")
{
System.Data.DataTable dtErorrUpdate = new JpmmsClasses.BL.MainStreet().CheckUpdateSectionsInfo();
if (dtErorrUpdate != null && dtErorrUpdate.Rows.Count == 0)
{
if (new JpmmsClasses.BL.MainStreet().UpdateSectionsInfo(true))
{
lblFeedback.Text = Feedback.UpdateSuccessfull();
}
else
{
lblFeedback.Text = Feedback.UpdateUNSuccessfull();
}
}
else
{
lblFeedback.Text = "بيانات مقاطع مكررة خطأ ";
gvRegionSamplesErorr.DataSource = dtErorrUpdate;
gvRegionSamplesErorr.DataBind();
}
}
else
{
lblFeedback.Text = Feedback.NoPermissions();
}
}
protected void BtnExport_Click(object sender, EventArgs e)
{
lblFeedback.Text = string.Empty;
DataTable dtIRI = new JpmmsClasses.BL.MainStreet().RoadsUdi(RadioButtonListType.SelectedValue, RadioButtonListSurvey.SelectedValue);
gvRegionSamplesIRI.DataSource = dtIRI;
gvRegionSamplesIRI.DataBind();
ViewState["gvRegionSamplesIRI"] = dtIRI;
}
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{
GridView1.DataSource = new JpmmsClasses.BL.MainStreet().StatisticsToMFV(RadioButtonList1.SelectedValue);
GridView1.DataBind();
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetRecivedMFVNext(RadioButtonList1.SelectedValue);
//gvRegionSamples.DataSource = dt;
//gvRegionSamples.DataBind();
lblFeedback0.Text = dt.Rows.Count.ToString() + " شارع " + RadioButtonList1.SelectedItem.Text;
}
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 RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e)
{
gvRegionIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfoFWD(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue);
gvRegionIRI.DataBind();
gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo((int.Parse(ddlRegions.SelectedValue)));
gvRegionSections.DataBind();
DataTable dtIRI = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsFWD(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue);
DataTable dtSection = new JpmmsClasses.BL.MainStreet().GetStreetsSections(int.Parse(ddlRegions.SelectedValue));
gvRegionSamplesIRI.DataSource = dtIRI;
gvRegionSamplesIRI.DataBind();
for (int i = 0; i < gvRegionSamplesIRI.Rows.Count; i++)
{
if (gvRegionSamplesIRI.Rows[i].RowType == DataControlRowType.DataRow)
{
if (gvRegionSamplesIRI.Rows[i].Cells[1].Text != gvRegionSamplesIRI.Rows[i].Cells[4].Text)
{
if (gvRegionSamplesIRI.Rows[i].Cells[1].Text == " ")
{
gvRegionSamplesIRI.Rows[i].Cells[1].Text = "0";
}
if (gvRegionSamplesIRI.Rows[i].Cells[4].Text == " ")
{
gvRegionSamplesIRI.Rows[i].Cells[4].Text = "0";
}
int value = int.Parse(gvRegionSamplesIRI.Rows[i].Cells[4].Text) - int.Parse(gvRegionSamplesIRI.Rows[i].Cells[1].Text);
gvRegionSamplesIRI.Rows[i].Cells[4].Text = value.ToString();
if (value > 0)
{
gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Green;
}
else
{
gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Yellow;
}
}
if (gvRegionSamplesIRI.Rows[i].Cells[1].Text == gvRegionSamplesIRI.Rows[i].Cells[4].Text && (gvRegionSamplesIRI.Rows[i].BackColor != System.Drawing.Color.Green || gvRegionSamplesIRI.Rows[i].BackColor != System.Drawing.Color.Yellow))
{
gvRegionSamplesIRI.Rows[i].Cells[4].Text = string.Empty;
}
}
}
gvRegionSamplesSECTION.DataSource = dtSection;
gvRegionSamplesSECTION.DataBind();
ViewState["gvRegionSamplesSECTION"] = gvRegionSamplesSECTION.DataSource;
ViewState["gvRegionSamplesIRI"] = gvRegionSamplesIRI.DataSource;
ViewState["sortdrIRI"] = "Asc";
ViewState["sortdr"] = "Asc";
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue != "-1")
{
float SUM = 0f;
float SumHafria = 0f;
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().TOTALSUMGPR();
lblFeedbackTotalArea.Text = " إجمالي الكمية الممسوحة " + dt.Rows[0][0].ToString() + " كيلو متر ";
lblFeedbackTotalStreets.Text = " إجمالي عدد الشوارع " + dt.Rows[0][1].ToString() + " شارع ";
DataSet ds = new JpmmsClasses.BL.MainStreet().CompareGPR(DropDownList1.SelectedValue);
gvRegionSamples.DataSource = ds.Tables[0];
gvRegionSamples.DataMember = ds.Tables[0].TableName;
gvRegionSamples.DataBind();
GridView1.DataSource = ds.Tables[1];
GridView1.DataMember = ds.Tables[1].TableName;
GridView1.DataBind();
for (int i = 0; i < gvRegionSamples.Rows.Count; i++)
{
// if (gvRegionSamples.Rows[i].Cells[4].Text != gvRegionSamples.Rows[i].Cells[5].Text)
// {
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.YellowGreen;
// }
// else if (gvRegionSamples.Rows[i].Cells[2].Text != gvRegionSamples.Rows[i].Cells[3].Text)
// {
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.Red;
// }
if (gvRegionSamples.Rows[i].Cells[6].Text == " ")
{
gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.BlanchedAlmond;
}
SUM += float.Parse(gvRegionSamples.Rows[i].Cells[6].Text == " " ? "0" : gvRegionSamples.Rows[i].Cells[6].Text);
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
SumHafria += float.Parse(GridView1.Rows[i].Cells[1].Text == " " ? "0" : GridView1.Rows[i].Cells[1].Text);
}
lblFeedbackClearance.Text = " عدد " + gvRegionSamples.Rows.Count + " شارع " + Math.Round(SUM, 2) + " كيلو متر ";
lblFeedbackHAFRIAT.Text = " عدد " + GridView1.Rows.Count + " ترخيص " + Math.Round(SumHafria / 1000f, 2) + " كيلو متر ";
GridViewDuplicates();
}
else
{
lblFeedbackHAFRIAT.Text = lblFeedbackClearance.Text = lblFeedbackTotalArea.Text = lblFeedbackTotalStreets.Text = string.Empty;
gvRegionSamples.DataBind();
GridView1.DataBind();
}
}
protected void BtnExport_Click(object sender, EventArgs e)
{
string rptFullPath = Server.MapPath(@".\RptFiles\MachineSurveys\STREETS_SECTIONS_LANE_GIS.rpt");
DataTable dt = new JpmmsClasses.BL.MainStreet().GetSectionsDetailsSYS(ddlRegions.SelectedValue);
ReportDocument rpt = new ReportDocument();
rpt.Load(rptFullPath);
rpt.SetDataSource(dt);
Stream memStream;
Response.Buffer = false;
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
if (false)
{
ExcelFormatOptions excelOptions = new ExcelFormatOptions();
excelOptions.ExcelUseConstantColumnWidth = false;
rpt.ExportOptions.FormatOptions = excelOptions;
memStream = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.ExcelRecord);
Response.ContentType = "application/vnd.ms-excel";
}
else if (false)
{
memStream = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.WordForWindows);
Response.ContentType = "application/doc";
}
else
{
memStream = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
Response.ContentType = "application/pdf";
}
byte[] ArryStream = new byte[memStream.Length + 1];
memStream.Read(ArryStream, 0, System.Convert.ToInt32(memStream.Length));
Response.BinaryWrite(ArryStream);
Response.End();
memStream.Flush();
memStream.Close();
memStream.Dispose();
rpt.Close();
rpt.Dispose();
GC.Collect();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue != "-1")
{
float SUM = 0f;
float SUMLEN = 0f;
float SumHafria = 0f;
lblFeedbackTotal.Text = " إجمالي الممسوح " + new JpmmsClasses.BL.Lookups.MaintDecision().GetAllDecisionsFWD_HAFRIAT() + " نقطة ";
DataSet ds = new JpmmsClasses.BL.MainStreet().CompareFWD(DropDownList1.SelectedValue);
gvRegionSamples.DataSource = ds.Tables[0];
gvRegionSamples.DataMember = ds.Tables[0].TableName;
gvRegionSamples.DataBind();
GridView1.DataSource = ds.Tables[1];
GridView1.DataMember = ds.Tables[1].TableName;
GridView1.DataBind();
for (int i = 0; i < gvRegionSamples.Rows.Count; i++)
{
// if (gvRegionSamples.Rows[i].Cells[4].Text != gvRegionSamples.Rows[i].Cells[5].Text)
// {
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.YellowGreen;
// }
// else if (gvRegionSamples.Rows[i].Cells[2].Text != gvRegionSamples.Rows[i].Cells[3].Text)
// {
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.Red;
// }
SUM += float.Parse(gvRegionSamples.Rows[i].Cells[2].Text);
SUMLEN += float.Parse(gvRegionSamples.Rows[i].Cells[3].Text);
}
for (int i = 0; i < GridView1.Rows.Count; i++)
{
SumHafria += float.Parse(GridView1.Rows[i].Cells[1].Text == " " ? "0" : GridView1.Rows[i].Cells[1].Text);
}
lblFeedbackClearance.Text = " عدد " + gvRegionSamples.Rows.Count + " شارع " + Math.Round(SUM, 2) + " نقطة " + Math.Round(SUMLEN, 2) + " كيلو متر ";
lblFeedbackHAFRIAT.Text = " عدد " + GridView1.Rows.Count + " ترخيص " + Math.Round(SumHafria, 2) + " نقطة ";
GridViewDuplicates();
}
else
{
lblFeedbackHAFRIAT.Text = lblFeedbackClearance.Text = lblFeedbackTotal.Text = string.Empty;
gvRegionSamples.DataBind();
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
else
{
string v1 = new JpmmsClasses.BL.MainStreet().SumReadyFWD(null);
string v2 = new JpmmsClasses.BL.MainStreet().SumReadyFWD(false);
string v3 = new JpmmsClasses.BL.MainStreet().SumReadyFWD(true);
lblSumReadyFWDNULL.Text = " عدد النقاط الناقصة " + v1;
lblSumReadyFWDFalse.Text = " عدد النقاط بالنظام " + v2;
lblSumReadyFWDTrue.Text = " عدد النقاط المنجزة " + v3;
lblSum.Text = " إجمالي عدد النقاط " + (float.Parse(v1) + float.Parse(v2) + float.Parse(v3)).ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[0] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
else
{
int ErorrData = new JpmmsClasses.BL.MainStreet().ValidateUpdateIRI().Rows.Count;
if (ErorrData > 0)
{
spanErorrData.Visible = true;
spanErorrData.InnerText = ErorrData.ToString();
}
else
{
spanErorrData.Visible = false;
spanErorrData.InnerText = string.Empty;
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue != "-1")
{
float SUM = 0f;
lblFeedbackTotal.Text = " إجمالي الممسوح " + new JpmmsClasses.BL.Lookups.MaintDecision().GetAllDecisionsAssets() + " كيلو متر ";
DataTable dTable = new JpmmsClasses.BL.MainStreet().CompareASSETS(DropDownList1.SelectedValue);;
gvRegionSamples.DataSource = dTable;
gvRegionSamples.DataBind();
for (int i = 0; i < gvRegionSamples.Rows.Count; i++)
{
SUM += float.Parse(gvRegionSamples.Rows[i].Cells[2].Text);
}
lblFeedbackClearance.Text = " عدد " + gvRegionSamples.Rows.Count + " شارع " + Math.Round(SUM, 2) + " كيلو متر ";
GridViewDuplicates();
}
else
{
lblFeedbackClearance.Text = lblFeedbackTotal.Text = string.Empty;
gvRegionSamples.DataBind();
}
}
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 ddlRegions_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlRegions.SelectedValue != "0")
{
gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo((int.Parse(ddlRegions.SelectedValue)));
gvRegionSections.DataBind();
DataTable dt = new JpmmsClasses.BL.MainStreet().GetStreetsNotIRI();
RadioButtonList1.SelectedValue = dt.Rows[ddlRegions.SelectedIndex - 1][2].ToString();
RadioButtonList1.DataBind();
DataTable dtIRI = new JpmmsClasses.BL.MainStreet().GetStreetsSections(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue);
DataTable dtSection = new JpmmsClasses.BL.MainStreet().GetStreetsSections(int.Parse(ddlRegions.SelectedValue));
gvRegionSamplesSECTION.DataSource = dtSection;
gvRegionSamplesSECTION.DataBind();
ViewState["gvRegionSamplesSECTION"] = gvRegionSamplesSECTION.DataSource;
ViewState["sortdr"] = "Asc";
}
}
protected void ddlRegions_SelectedIndexChanged(object sender, EventArgs e)
{
BtnFinshed.Visible = false;
lblFeedback.Text = string.Empty;
string v1 = new JpmmsClasses.BL.MainStreet().SumReadyFWD(null);
string v2 = new JpmmsClasses.BL.MainStreet().SumReadyFWD(false);
string v3 = new JpmmsClasses.BL.MainStreet().SumReadyFWD(true);
lblSumReadyFWDNULL.Text = " عدد النقاط الناقصة " + v1;
lblSumReadyFWDFalse.Text = " عدد النقاط بالنظام " + v2;
lblSumReadyFWDTrue.Text = " عدد النقاط المنجزة " + v3;
lblSum.Text = " إجمالي عدد النقاط " + (float.Parse(v1) + float.Parse(v2) + float.Parse(v3)).ToString();
int SumSections = 0, SumFinshed = 0;
gvRegionIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo((int.Parse(ddlRegions.SelectedValue)));
gvRegionIRI.DataBind();
if (gvRegionIRI.Rows.Count > 0)
{
gvFWD.DataSource = new JpmmsClasses.BL.MainStreet().ReadyFWD(ddlRegions.SelectedItem.Text);
gvFWD.DataBind();
bool is_integer = unchecked (gvFWD.Rows.Count / 3f - gvFWD.Rows.Count / 3 == 0);
lblFeedback0.Text = gvFWD.Rows.Count / 3f + " نقطة ";
if (is_integer)
{
CheckBox chkAllDelete = gvFWD.HeaderRow.FindControl("chkSelect") as CheckBox;
chkAllDelete.Visible = false;
for (int i = 0; i < gvFWD.Rows.Count; i++)
{
DropDownList DrpDwnLane = gvFWD.Rows[i].FindControl("DrpDwnListLane") as DropDownList;
DropDownList DrpDwnSection = gvFWD.Rows[i].FindControl("DrpDwnListSection") as DropDownList;
CheckBox ChkBoxSave = gvFWD.Rows[i].FindControl("ChkBoxSave") as CheckBox;
CheckBox ChkBoxDelete = gvFWD.Rows[i].FindControl("ChkBoxDelete") as CheckBox;
CheckBox ChkFinshed = (CheckBox)gvFWD.Rows[i].Cells[14].Controls[0];
ChkBoxSave.Visible = !((CheckBox)gvFWD.Rows[i].Cells[14].Controls[0]).Checked;
ChkBoxDelete.Visible = ((CheckBox)gvFWD.Rows[i].Cells[14].Controls[0]).Checked;
gvFWD.Rows[i].Cells[15].Controls[0].Visible = false;
if (i % 3 == 0)
{
if (gvFWD.Rows[i].Cells[8].Text == "0" && ChkFinshed.Checked == false)
{
SumSections++;
DrpDwnSection.DataSource = new JpmmsClasses.BL.MainStreet().GetSections(ddlRegions.SelectedItem.Text);
DrpDwnSection.DataTextField = "SECTION_NO";
DrpDwnSection.DataValueField = "SECTION_ID";
DrpDwnSection.DataBind();
DrpDwnLane.DataSource = new JpmmsClasses.BL.MainStreet().GetLanes(ddlRegions.SelectedItem.Text);
DrpDwnLane.DataTextField = "LANE_TYPE";
DrpDwnLane.DataValueField = "LANE_TYPE";
DrpDwnLane.DataBind();
}
else if (ChkFinshed.Checked)
{
if (gvFWD.Rows[i].Cells[8].Text == "0")
{
gvFWD.Rows[i].Cells[15].Controls[0].Visible = true;
}
chkAllDelete.Visible = true;
ChkBoxDelete.Enabled = true;
DrpDwnLane.Visible = false;
DrpDwnSection.Visible = false;
gvFWD.Rows[i].Cells[11].Controls[0].Visible = false;
BtnFinshed.Visible = true;
SumFinshed++;
}
else
{
DrpDwnLane.Visible = false;
DrpDwnSection.Visible = false;
gvFWD.Rows[i].Cells[11].Controls[0].Visible = false;
}
}
else
{
// BtnSave.Text = gvFWD.DataKeys[i].Value.ToString();
if (ChkFinshed.Checked)
{
ChkBoxDelete.Enabled = true;
chkAllDelete.Visible = true;
BtnFinshed.Visible = true;
SumFinshed++;
}
DrpDwnLane.Visible = false;
DrpDwnSection.Visible = false;
gvFWD.Rows[i].Cells[11].Controls[0].Visible = false;
}
}
if (SumFinshed == gvFWD.Rows.Count)
{
((CheckBox)gvFWD.HeaderRow.FindControl("chkInsert")).Visible = false;
}
}
else
{
gvFWD.DataSource = null;
gvFWD.DataBind();
}
if (SumSections > 0)
{
lblFeedback.Text = " المقاطع من المعدة " + SumSections.ToString();
}
}
else
{
lblFeedback0.Text = Feedback.NoData();
gvFWD.DataSource = null;
gvFWD.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
else
{
if (Request.QueryString.Count == 1)
{
spanQcMain.Visible = false;
spanQcUdi.Visible = false;
spanRegionsClosedNote.Visible = false;
spanRegionsColsed.Visible = false;
spanRegionsError.Visible = false;
spanRegionsFinshed.Visible = false;
spanRegionsLength.Visible = false;
spanRegionsNotFinshed.Visible = false;
spanRegionsOpend.Visible = false;
spanRegionsOpenedNote.Visible = false;
spanRegionsReportReview.Visible = false;
spanRegionsWidth.Visible = false;
spanSecoundStreets.Visible = false;
spanValidateAREA.Visible = false;
spanValidateReports.Visible = false;
spanNewStreets.Visible = false;
spanNewStreetsQC.Visible = false;
spanDublicateStreets.Visible = false;
}
else
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().CountRegionsUdiMin();
int RegionsClosed = int.Parse(dt.Rows[0]["TOTALRegionsClosed"].ToString());
int RegionsOpend = int.Parse(dt.Rows[0]["TOTALRegionsOpend"].ToString());
int RegionsWidth = int.Parse(dt.Rows[0]["CountStreetWidth"].ToString());
int RegionsLength = int.Parse(dt.Rows[0]["CountStreetLength"].ToString());
int RegionsClosedNote = int.Parse(dt.Rows[0]["CountRegionsClosedNote"].ToString());
int RegionsOpenedNote = int.Parse(dt.Rows[0]["CountRegionsOpenedNote"].ToString());
int SecoundStreets = int.Parse(dt.Rows[0]["CountSECOND_ST"].ToString());
int RegionsError = new JpmmsClasses.BL.Region().GetAllRegionsErorrs().Rows.Count;
int RegionsNotFinshed = int.Parse(dt.Rows[0]["CountRegionsNotFinshed"].ToString());
int RegionsFinshed = int.Parse(dt.Rows[0]["CountRegionFinshed"].ToString());
int RegionsReportReview = int.Parse(dt.Rows[0]["CountRegionsReports"].ToString());
int QcUdi = int.Parse(dt.Rows[0]["CountRegionsNoUdi"].ToString());
int ValidateAREA = int.Parse(dt.Rows[0]["CountAREA"].ToString());
int ValidateReports = int.Parse(dt.Rows[0]["CountReports"].ToString());
int NewStreets = int.Parse(dt.Rows[0]["CountNewStreets"].ToString());
int NewStreetsQC = int.Parse(dt.Rows[0]["CountNewStreetsQC"].ToString());
int DublicateStreets = int.Parse(dt.Rows[0]["GetDublicateStreets"].ToString());
if (DublicateStreets > 0)
{
spanDublicateStreets.Visible = true;
spanDublicateStreets.InnerText = DublicateStreets.ToString();
}
else
{
spanDublicateStreets.Visible = false;
spanDublicateStreets.InnerText = string.Empty;
}
if (NewStreetsQC > 0)
{
spanNewStreetsQC.Visible = true;
spanNewStreetsQC.InnerText = NewStreetsQC.ToString();
}
else
{
spanNewStreetsQC.Visible = false;
spanNewStreetsQC.InnerText = string.Empty;
}
if (NewStreets > 0)
{
spanNewStreets.Visible = true;
spanNewStreets.InnerText = NewStreets.ToString();
}
else
{
spanNewStreets.Visible = false;
spanNewStreets.InnerText = string.Empty;
}
if (ValidateReports > 0)
{
spanValidateReports.Visible = true;
spanValidateReports.InnerText = ValidateReports.ToString();
}
else
{
spanValidateReports.Visible = false;
spanValidateReports.InnerText = string.Empty;
}
if (ValidateAREA > 0)
{
spanValidateAREA.Visible = true;
spanValidateAREA.InnerText = ValidateAREA.ToString();
}
else
{
spanValidateAREA.Visible = false;
spanValidateAREA.InnerText = string.Empty;
}
//int QcMain = int.Parse(dt.Rows[0]["CountRegionsNoMin"].ToString());
int QcMain = 0;// Convert.ToInt32(new JpmmsClasses.BL.MainStreet().CountRegionsNoMin());
if (RegionsReportReview > 0)
{
spanRegionsReportReview.Visible = true;
spanRegionsReportReview.InnerText = RegionsReportReview.ToString();
}
else
{
spanRegionsReportReview.Visible = false;
spanRegionsReportReview.InnerText = string.Empty;
}
if (RegionsFinshed > 0)
{
spanRegionsFinshed.Visible = true;
spanRegionsFinshed.InnerText = RegionsFinshed.ToString();
}
else
{
spanRegionsFinshed.Visible = false;
spanRegionsFinshed.InnerText = string.Empty;
}
if (RegionsNotFinshed > 0)
{
spanRegionsNotFinshed.Visible = true;
spanRegionsNotFinshed.InnerText = RegionsNotFinshed.ToString();
}
else
{
spanRegionsNotFinshed.Visible = false;
spanRegionsNotFinshed.InnerText = string.Empty;
}
if (RegionsError > 0)
{
spanRegionsError.Visible = true;
spanRegionsError.InnerText = RegionsError.ToString();
}
else
{
spanRegionsError.Visible = false;
spanRegionsError.InnerText = string.Empty;
}
if (SecoundStreets > 0)
{
spanSecoundStreets.Visible = true;
spanSecoundStreets.InnerText = SecoundStreets.ToString();
}
else
{
spanSecoundStreets.Visible = false;
spanSecoundStreets.InnerText = string.Empty;
}
if (QcUdi > 0)
{
spanQcUdi.Visible = true;
spanQcUdi.InnerText = QcUdi.ToString();
}
else
{
spanQcUdi.Visible = false;
spanQcUdi.InnerText = string.Empty;
}
if (QcMain > 0)
{
spanQcMain.Visible = true;
spanQcMain.InnerText = QcMain.ToString();
}
else
{
spanQcMain.Visible = false;
spanQcMain.InnerText = string.Empty;
}
if (RegionsClosedNote > 0)
{
spanRegionsClosedNote.Visible = true;
spanRegionsClosedNote.InnerText = RegionsClosedNote.ToString();
}
else
{
spanRegionsClosedNote.Visible = false;
spanRegionsClosedNote.InnerText = string.Empty;
}
if (RegionsOpenedNote > 0)
{
spanRegionsOpenedNote.Visible = true;
spanRegionsOpenedNote.InnerText = RegionsOpenedNote.ToString();
}
else
{
spanRegionsOpenedNote.Visible = false;
spanRegionsOpenedNote.InnerText = string.Empty;
}
if (RegionsClosed > 0)
{
spanRegionsColsed.Visible = true;
spanRegionsColsed.InnerText = RegionsClosed.ToString();
}
else
{
spanRegionsColsed.Visible = false;
spanRegionsColsed.InnerText = string.Empty;
}
if (RegionsOpend > 0)
{
spanRegionsOpend.Visible = true;
spanRegionsOpend.InnerText = RegionsOpend.ToString();
}
else
{
spanRegionsOpend.Visible = false;
spanRegionsOpend.InnerText = string.Empty;
}
if (RegionsWidth > 0)
{
spanRegionsWidth.Visible = true;
spanRegionsWidth.InnerText = RegionsWidth.ToString();
}
else
{
spanRegionsWidth.Visible = false;
spanRegionsWidth.InnerText = string.Empty;
}
if (RegionsLength > 0)
{
spanRegionsLength.Visible = true;
spanRegionsLength.InnerText = RegionsLength.ToString();
}
else
{
spanRegionsLength.Visible = false;
spanRegionsLength.InnerText = string.Empty;
}
}
}
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue != "-1")
{
float SUM = 0f;
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().TOTALSUMSKID();
lblFeedbackTotalArea.Text = " إجمالي الكمية الممسوحة " + dt.Rows[0][0].ToString() + " كيلو متر ";
lblFeedbackTotalStreets.Text = " إجمالي عدد الشوارع " + dt.Rows[0][1].ToString() + " شارع ";
gvRegionSamples.DataSource = new JpmmsClasses.BL.MainStreet().CompareSKID(DropDownList1.SelectedValue);
gvRegionSamples.DataBind();
//bool IRI, SYS = false;
for (int i = 0; i < gvRegionSamples.Rows.Count; i++)
{
//IRI = gvRegionSamples.Rows[i].Cells[7].Text == " " && gvRegionSamples.Rows[i].Cells[5].Text == " " && gvRegionSamples.Rows[i].Cells[3].Text == " ";
//SYS = gvRegionSamples.Rows[i].Cells[6].Text == " " && gvRegionSamples.Rows[i].Cells[4].Text == " " && gvRegionSamples.Rows[i].Cells[2].Text == " ";
//if (gvRegionSamples.Rows[i].Cells[4].Text != gvRegionSamples.Rows[i].Cells[5].Text)
//{
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.YellowGreen;
//}
//else if (gvRegionSamples.Rows[i].Cells[2].Text != gvRegionSamples.Rows[i].Cells[3].Text)
//{
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.Red;
//}
//if (IRI && SYS)
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.Red;
//else if (IRI && SYS == false)
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.YellowGreen;
//else if (SYS && IRI == false)
// gvRegionSamples.Rows[i].BackColor = System.Drawing.Color.BlanchedAlmond;
//if (gvRegionSamples.Rows[i].Cells[7].Text == " " && gvRegionSamples.Rows[i].Cells[6].Text == " ")
// SUM += 0f;
//else if (gvRegionSamples.Rows[i].Cells[7].Text == " ")
// SUM += float.Parse(gvRegionSamples.Rows[i].Cells[6].Text == " " ? "0" : gvRegionSamples.Rows[i].Cells[6].Text);
//else if (gvRegionSamples.Rows[i].Cells[6].Text == " ")
// SUM += float.Parse(gvRegionSamples.Rows[i].Cells[7].Text == " " ? "0" : gvRegionSamples.Rows[i].Cells[7].Text);
//else
// SUM += float.Parse(gvRegionSamples.Rows[i].Cells[7].Text);
SUM += float.Parse(gvRegionSamples.Rows[i].Cells[6].Text);
// SUM += float.Parse(gvRegionSamples.Rows[i].Cells[7].Text == " " ? gvRegionSamples.Rows[i].Cells[6].Text : gvRegionSamples.Rows[i].Cells[7].Text);
}
lblFeedbackClearance.Text = " عدد " + gvRegionSamples.Rows.Count + " شارع " + Math.Round(SUM, 2) + " كيلو متر ";
if (gvRegionSamples.Rows.Count != int.Parse(dt.Rows[0][1].ToString()) && DropDownList1.SelectedValue == "ALL")
{
HyperLinkSKIDIR.Visible = true;
HyperLinkSKIDIR.Text = new JpmmsClasses.BL.MainStreet().SKIDNotIRI().Rows.Count + " " + "شارع يحتاج المسح بـ IRI";
}
else
{
HyperLinkSKIDIR.Visible = false;
}
GridViewDuplicates();
}
else
{
lblFeedbackClearance.Text = lblFeedbackTotalStreets.Text = lblFeedbackTotalArea.Text = string.Empty;
gvRegionSamples.DataBind();
}
}
protected void ddlRegions_SelectedIndexChanged(object sender, EventArgs e)
{
if (Request.QueryString.Count == 1 && ddlRegions.SelectedValue != "0")
{
if (Request.QueryString[0].ToString() == "GPR")
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetStreetsGPR();
dt.PrimaryKey = new System.Data.DataColumn[] { dt.Columns["MAIN_NO"] };
RadioButtonList1.SelectedValue = dt.Rows.Find(ddlRegions.SelectedValue)[2].ToString();
RadioButtonList1.DataBind();
if (dt.Rows.Find(ddlRegions.SelectedValue)[3].ToString() == "1")
{
RadioButtonList1.Enabled = false;
}
else
{
RadioButtonList1.Enabled = true;
}
gvRegionSamplesEqupment.DataSource = new JpmmsClasses.BL.MainStreet().CountValidateGPRIRI(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue);
gvRegionSamplesEqupment.DataBind();
}
else if (Request.QueryString[0].ToString() == "FWD")
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetStreetsFWD();
dt.PrimaryKey = new System.Data.DataColumn[] { dt.Columns["MAIN_NO"] };
RadioButtonList1.SelectedValue = dt.Rows.Find(ddlRegions.SelectedValue)[2].ToString();
RadioButtonList1.DataBind();
if (dt.Rows.Find(ddlRegions.SelectedValue)[3].ToString() == "1")
{
RadioButtonList1.Enabled = false;
}
else
{
RadioButtonList1.Enabled = true;
}
gvRegionSamplesEqupment.DataSource = new JpmmsClasses.BL.MainStreet().CountValidateFWD(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue);
gvRegionSamplesEqupment.DataBind();
}
else if (Request.QueryString[0].ToString() == "SKID")
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetStreetsSKID();
dt.PrimaryKey = new System.Data.DataColumn[] { dt.Columns["MAIN_NO"] };
RadioButtonList1.SelectedValue = dt.Rows.Find(ddlRegions.SelectedValue)[2].ToString();
RadioButtonList1.DataBind();
if (dt.Rows.Find(ddlRegions.SelectedValue)[3].ToString() == "1")
{
RadioButtonList1.Enabled = false;
}
else
{
RadioButtonList1.Enabled = true;
}
gvRegionSamplesEqupment.DataSource = new JpmmsClasses.BL.MainStreet().CountValidateSKIDIRI(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue);
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);
}
else
{
if (Request.QueryString.Count == 1)
{
spanASSETESNoReady.Visible = false;
spanDistreesFWD.Visible = false;
spanDistreesGPR.Visible = false;
spanDistreesSKID.Visible = false;
spanDublicateGPR.Visible = false;
spanDublicateSKID.Visible = false;
spanFWDNoReady.Visible = false;
spanGPRNoReady.Visible = false;
spanSKIDNoReady.Visible = false;
spanValidateFWD.Visible = false;
spanValidateFWDLane.Visible = false;
spanValidateFWDSection.Visible = false;
spanValidateGPR.Visible = false;
spanValidateGPRLane.Visible = false;
spanValidateGPRSections.Visible = false;
spanValidateSKID.Visible = false;
spanValidateSKIDLane.Visible = false;
spanValidateSKIDSection.Visible = false;
spanIRISKID.Visible = false;
spanIRIGPR.Visible = false;
spanFinshedFWD.Visible = false;
spanDistreesDeletedGPR.Visible = false;
spanDistreesDeletedSKID.Visible = false;
spanSectionsMainNOGPR.Visible = false;
spanSectionsMainNOFWD.Visible = false;
spanSectionsMainNOSKID.Visible = false;
spanMFVGPR.Visible = false;
spanMFVSKID.Visible = false;
spanMFVASSETS.Visible = false;
spanCompareASSETS.Visible = false;
}
else
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().CountOthersEquipment(false);
int FWDNoReady = int.Parse(dt.Rows[0]["CountFWDCLEARANCE"].ToString());
int GPRNoReady = int.Parse(dt.Rows[0]["CountGPRCLEARANCE"].ToString());
int SKIDNoReady = int.Parse(dt.Rows[0]["CountSKIDCLEARANCE"].ToString());
int ASSETESNoReady = int.Parse(dt.Rows[0]["CountASSETSCLEARANCE"].ToString());
int DistreesGPR = int.Parse(dt.Rows[0]["CountDistreesGPR"].ToString());
int DistreesFWD = int.Parse(dt.Rows[0]["CountDistreesFWD"].ToString());
int DistreesSKID = int.Parse(dt.Rows[0]["CountDistreesSKID"].ToString());
int ValidateGPRLane = int.Parse(dt.Rows[0]["CountValidateGPRLane"].ToString());
int ValidateFWDLane = int.Parse(dt.Rows[0]["CountValidateFWDLane"].ToString());
int ValidateSKIDLane = int.Parse(dt.Rows[0]["CountValidateSKIDLane"].ToString());
int ValidateGPRSections = int.Parse(dt.Rows[0]["CountValidateGPRSections"].ToString());
int ValidateFWDSections = int.Parse(dt.Rows[0]["CountValidateFWDSections"].ToString());
int ValidateSKIDSections = int.Parse(dt.Rows[0]["CountValidateSKIDSections"].ToString());
int ValidateGPR = int.Parse(dt.Rows[0]["CountValidateGPR"].ToString());
int ValidateFWD = int.Parse(dt.Rows[0]["CountValidateFWD"].ToString());
int ValidateSKID = int.Parse(dt.Rows[0]["CountValidateSKID"].ToString());
int DublicateGPR = int.Parse(dt.Rows[0]["CountDublicateGPR"].ToString());
int DublicateSKID = int.Parse(dt.Rows[0]["CountDublicateSKID"].ToString());
int FinshedFwd = int.Parse(dt.Rows[0]["FinshedReadyFWD"].ToString());
int DeletedSKID = int.Parse(dt.Rows[0]["LanesDeletedSKID"].ToString());
int DeletedGPR = int.Parse(dt.Rows[0]["LanesDeletedGPR"].ToString());
int SectionsMainNOFWD = int.Parse(dt.Rows[0]["CountSectionMainNOFWD"].ToString());
int SectionsMainNOSKID = int.Parse(dt.Rows[0]["CountSectionMainNOSKID"].ToString());
int SectionsMainNOSGPR = int.Parse(dt.Rows[0]["CountSectionMainNOGPR"].ToString());
int IRISKID = new JpmmsClasses.BL.MainStreet().SKIDNotIRI().Rows.Count;
int IRIGPR = new JpmmsClasses.BL.MainStreet().GPRNotIRI().Rows.Count;
int MFVGPR = int.Parse(dt.Rows[0]["CountMFVGPR"].ToString());
int MFVSKID = int.Parse(dt.Rows[0]["CountMFVSKID"].ToString());
int MFVASSETS = int.Parse(dt.Rows[0]["CountMFVASSETS"].ToString());
int CompareASSETS = int.Parse(dt.Rows[0]["CountCompareASSETS"].ToString());
if (CompareASSETS > 0)
{
spanCompareASSETS.Visible = true;
spanCompareASSETS.InnerText = CompareASSETS.ToString();
}
else
{
spanCompareASSETS.Visible = false;
spanCompareASSETS.InnerText = string.Empty;
}
if (MFVGPR > 0)
{
spanMFVGPR.Visible = true;
spanMFVGPR.InnerText = MFVGPR.ToString();
}
else
{
spanMFVGPR.Visible = false;
spanMFVGPR.InnerText = string.Empty;
}
if (MFVSKID > 0)
{
spanMFVSKID.Visible = true;
spanMFVSKID.InnerText = MFVSKID.ToString();
}
else
{
spanMFVSKID.Visible = false;
spanMFVSKID.InnerText = string.Empty;
}
if (MFVASSETS > 0)
{
spanMFVASSETS.Visible = true;
spanMFVASSETS.InnerText = MFVASSETS.ToString();
}
else
{
spanMFVASSETS.Visible = false;
spanMFVASSETS.InnerText = string.Empty;
}
if (SectionsMainNOSGPR > 0)
{
spanSectionsMainNOGPR.Visible = true;
spanSectionsMainNOGPR.InnerText = SectionsMainNOSGPR.ToString();
}
else
{
spanSectionsMainNOGPR.Visible = false;
spanSectionsMainNOGPR.InnerText = string.Empty;
}
if (SectionsMainNOSKID > 0)
{
spanSectionsMainNOSKID.Visible = true;
spanSectionsMainNOSKID.InnerText = SectionsMainNOSKID.ToString();
}
else
{
spanSectionsMainNOSKID.Visible = false;
spanSectionsMainNOSKID.InnerText = string.Empty;
}
if (SectionsMainNOFWD > 0)
{
spanSectionsMainNOFWD.Visible = true;
spanSectionsMainNOFWD.InnerText = SectionsMainNOFWD.ToString();
}
else
{
spanSectionsMainNOFWD.Visible = false;
spanSectionsMainNOFWD.InnerText = string.Empty;
}
if (DeletedGPR > 0)
{
spanDistreesDeletedGPR.Visible = true;
spanDistreesDeletedGPR.InnerText = DeletedGPR.ToString();
}
else
{
spanDistreesDeletedGPR.Visible = false;
spanDistreesDeletedGPR.InnerText = string.Empty;
}
if (DeletedSKID > 0)
{
spanDistreesDeletedSKID.Visible = true;
spanDistreesDeletedSKID.InnerText = DeletedSKID.ToString();
}
else
{
spanDistreesDeletedSKID.Visible = false;
spanDistreesDeletedSKID.InnerText = string.Empty;
}
if (FinshedFwd > 0)
{
spanFinshedFWD.Visible = true;
spanFinshedFWD.InnerText = FinshedFwd.ToString();
}
else
{
spanFinshedFWD.Visible = false;
spanFinshedFWD.InnerText = string.Empty;
}
if (IRISKID > 0)
{
spanIRISKID.Visible = true;
spanIRISKID.InnerText = IRISKID.ToString();
}
else
{
spanIRISKID.Visible = false;
spanIRISKID.InnerText = string.Empty;
}
if (IRIGPR > 0)
{
spanIRIGPR.Visible = true;
spanIRIGPR.InnerText = IRIGPR.ToString();
}
else
{
spanIRIGPR.Visible = false;
spanIRIGPR.InnerText = string.Empty;
}
if (DublicateGPR > 0)
{
spanDublicateGPR.Visible = true;
spanDublicateGPR.InnerText = DublicateGPR.ToString();
}
else
{
spanDublicateGPR.Visible = false;
spanDublicateGPR.InnerText = string.Empty;
}
if (DublicateSKID > 0)
{
spanDublicateSKID.Visible = true;
spanDublicateSKID.InnerText = DublicateSKID.ToString();
}
else
{
spanDublicateSKID.Visible = false;
spanDublicateSKID.InnerText = string.Empty;
}
if (ValidateGPR > 0)
{
spanValidateGPR.Visible = true;
spanValidateGPR.InnerText = ValidateGPR.ToString();
}
else
{
spanValidateGPR.Visible = false;
spanValidateGPR.InnerText = string.Empty;
}
if (ValidateFWD > 0)
{
spanValidateFWD.Visible = true;
spanValidateFWD.InnerText = ValidateFWD.ToString();
}
else
{
spanValidateFWD.Visible = false;
spanValidateFWD.InnerText = string.Empty;
}
if (ValidateSKID > 0)
{
spanValidateSKID.Visible = true;
spanValidateSKID.InnerText = ValidateSKID.ToString();
}
else
{
spanValidateSKID.Visible = false;
spanValidateSKID.InnerText = string.Empty;
}
if (ValidateGPRLane > 0)
{
spanValidateGPRLane.Visible = true;
spanValidateGPRLane.InnerText = ValidateGPRLane.ToString();
}
else
{
spanValidateGPRLane.Visible = false;
spanValidateGPRLane.InnerText = string.Empty;
}
if (ValidateFWDLane > 0)
{
spanValidateFWDLane.Visible = true;
spanValidateFWDLane.InnerText = ValidateFWDLane.ToString();
}
else
{
spanValidateFWDLane.Visible = false;
spanValidateFWDLane.InnerText = string.Empty;
}
if (ValidateSKIDLane > 0)
{
spanValidateSKIDLane.Visible = true;
spanValidateSKIDLane.InnerText = ValidateSKIDLane.ToString();
}
else
{
spanValidateSKIDLane.Visible = false;
spanValidateSKIDLane.InnerText = string.Empty;
}
if (ValidateGPRSections > 0)
{
spanValidateGPRSections.Visible = true;
spanValidateGPRSections.InnerText = ValidateGPRSections.ToString();
}
else
{
spanValidateGPRSections.Visible = false;
spanValidateGPRSections.InnerText = string.Empty;
}
if (ValidateFWDSections > 0)
{
spanValidateFWDSection.Visible = true;
spanValidateFWDSection.InnerText = ValidateFWDSections.ToString();
}
else
{
spanValidateFWDSection.Visible = false;
spanValidateFWDSection.InnerText = string.Empty;
}
if (ValidateSKIDSections > 0)
{
spanValidateSKIDSection.Visible = true;
spanValidateSKIDSection.InnerText = ValidateSKIDSections.ToString();
}
else
{
spanValidateSKIDSection.Visible = false;
spanValidateSKIDSection.InnerText = string.Empty;
}
if (DistreesGPR > 0)
{
spanDistreesGPR.Visible = true;
spanDistreesGPR.InnerText = DistreesGPR.ToString();
}
else
{
spanDistreesGPR.Visible = false;
spanDistreesGPR.InnerText = string.Empty;
}
if (DistreesFWD > 0)
{
spanDistreesFWD.Visible = true;
spanDistreesFWD.InnerText = DistreesFWD.ToString();
}
else
{
spanDistreesFWD.Visible = false;
spanDistreesFWD.InnerText = string.Empty;
}
if (DistreesSKID > 0)
{
spanDistreesSKID.Visible = true;
spanDistreesSKID.InnerText = DistreesSKID.ToString();
}
else
{
spanDistreesSKID.Visible = false;
spanDistreesSKID.InnerText = string.Empty;
}
if (FWDNoReady > 0)
{
spanFWDNoReady.Visible = true;
spanFWDNoReady.InnerText = FWDNoReady.ToString();
}
else
{
spanFWDNoReady.Visible = false;
spanFWDNoReady.InnerText = string.Empty;
}
if (ASSETESNoReady > 0)
{
spanASSETESNoReady.Visible = true;
spanASSETESNoReady.InnerText = ASSETESNoReady.ToString();
}
else
{
spanASSETESNoReady.Visible = false;
spanASSETESNoReady.InnerText = string.Empty;
}
if (GPRNoReady > 0)
{
spanGPRNoReady.Visible = true;
spanGPRNoReady.InnerText = GPRNoReady.ToString();
}
else
{
spanGPRNoReady.Visible = false;
spanGPRNoReady.InnerText = string.Empty;
}
if (SKIDNoReady > 0)
{
spanSKIDNoReady.Visible = true;
spanSKIDNoReady.InnerText = SKIDNoReady.ToString();
}
else
{
spanSKIDNoReady.Visible = false;
spanSKIDNoReady.InnerText = string.Empty;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
else
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().CounMissClearance();
int InterSectionsClearance = int.Parse(dt.Rows[0]["CountInterSectionsClearance"].ToString());
int FWDNoReady = int.Parse(dt.Rows[0]["CountFWDCLEARANCE"].ToString());
int SKIDNoReady = int.Parse(dt.Rows[0]["CountSKIDCLEARANCE"].ToString());
int ASSETESNoReady = int.Parse(dt.Rows[0]["CountASSETSCLEARANCE"].ToString());
int GPRNoReady = int.Parse(dt.Rows[0]["CountGPRCLEARANCE"].ToString());
int IRIDDFCLEARANCE = int.Parse(dt.Rows[0]["CountIRIDDFCLEARANCE"].ToString());
if (IRIDDFCLEARANCE > 0)
{
spanIRIDDFNoReady.Visible = true;
spanIRIDDFNoReady.InnerText = IRIDDFCLEARANCE.ToString();
}
else
{
spanIRIDDFNoReady.Visible = false;
spanIRIDDFNoReady.InnerText = string.Empty;
}
if (InterSectionsClearance > 0)
{
spanInterSectionsClearance.Visible = true;
spanInterSectionsClearance.InnerText = InterSectionsClearance.ToString();
}
else
{
spanInterSectionsClearance.Visible = false;
spanInterSectionsClearance.InnerText = string.Empty;
}
if (FWDNoReady > 0)
{
spanFWDNoReady.Visible = true;
spanFWDNoReady.InnerText = FWDNoReady.ToString();
}
else
{
spanFWDNoReady.Visible = false;
spanFWDNoReady.InnerText = string.Empty;
}
if (SKIDNoReady > 0)
{
spanSKIDNoReady.Visible = true;
spanSKIDNoReady.InnerText = SKIDNoReady.ToString();
}
else
{
spanSKIDNoReady.Visible = false;
spanSKIDNoReady.InnerText = string.Empty;
}
if (ASSETESNoReady > 0)
{
spanASSETESNoReady.Visible = true;
spanASSETESNoReady.InnerText = ASSETESNoReady.ToString();
}
else
{
spanASSETESNoReady.Visible = false;
spanASSETESNoReady.InnerText = string.Empty;
}
if (GPRNoReady > 0)
{
spanGPRNoReady.Visible = true;
spanGPRNoReady.InnerText = GPRNoReady.ToString();
}
else
{
spanGPRNoReady.Visible = false;
spanGPRNoReady.InnerText = string.Empty;
}
}
}
protected void ddlRegions_SelectedIndexChanged(object sender, EventArgs e)
{
lblFeedback0.Text = string.Empty;
lblFeedback.Text = string.Empty;
lblFeedback1.Text = string.Empty;
gvRegionIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfoSKIDNew(ddlRegions.SelectedItem.Text);
gvRegionIRI.DataBind();
gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo((int.Parse(ddlRegions.SelectedValue)));
gvRegionSections.DataBind();
DataTable dtIRI = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLengthSKIDNew(ddlRegions.SelectedItem.Text);
DataTable dtSection = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLength(int.Parse(ddlRegions.SelectedValue));
gvRegionSamplesIRI.DataSource = dtIRI;
gvRegionSamplesIRI.DataBind();
gvRegionSamplesSECTION.DataSource = dtSection;
gvRegionSamplesSECTION.DataBind();
try
{
dtSection.PrimaryKey = new DataColumn[] {
dtSection.Columns["SECTION_NO"],
dtSection.Columns["LANE"]
};
for (int i = 0; i < gvRegionSamplesIRI.Rows.Count; i++)
{
if (gvRegionSamplesIRI.Rows[i].RowType == DataControlRowType.DataRow)
{
if (!dtSection.Rows.Contains(new object[] { gvRegionSamplesIRI.Rows[i].Cells[0].Text, gvRegionSamplesIRI.Rows[i].Cells[1].Text }))
{
gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.YellowGreen;
gvRegionSamplesIRI.Rows[i].Cells[3].Text = "غير موجود بالنظام";
}
}
}
dtIRI.PrimaryKey = new DataColumn[] {
dtIRI.Columns["SECTION_NO"],
dtIRI.Columns["LANE"]
};
for (int i = 0; i < gvRegionSamplesSECTION.Rows.Count; i++)
{
if (gvRegionSamplesSECTION.Rows[i].RowType == DataControlRowType.DataRow)
{
if (!dtIRI.Rows.Contains(new object[] { gvRegionSamplesSECTION.Rows[i].Cells[0].Text, gvRegionSamplesSECTION.Rows[i].Cells[1].Text }))
{
gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.LimeGreen;
gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "غير موجود بالمعدة";
}
}
}
}
catch (Exception ex)
{
lblFeedback0.Text = string.Empty;
if (ex.Message == "Column 'SECTION_NO' has null values in it.")
{
lblFeedback0.Text = "البيانات من النظام يوجد بها مقطع ليس له رقم";
for (int i = 0; i < dtSection.Rows.Count; i++)
{
if (dtSection.Rows[i][1].ToString() == string.Empty)
{
lblFeedback.Text += "LANE_ID : " + dtSection.Rows[i][0].ToString();
}
}
for (int i = 0; i < dtIRI.Rows.Count; i++)
{
if (dtIRI.Rows[i][0].ToString() == string.Empty)
{
lblFeedback.Text += " LANE : " + dtIRI.Rows[i][1].ToString();
lblFeedback0.Text = "البيانات من المعدة يوجد بها مقطع ليس له رقم";
}
}
}
else if (ex.Message == "These columns don't currently have unique values.")
{
DataTable dtIRIErorr = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLengtErorr((int.Parse(ddlRegions.SelectedValue)));
if (dtIRIErorr.Rows.Count > 0)
{
for (int i = 0; i < gvRegionSamplesSECTION.Rows.Count; i++)
{
if (gvRegionSamplesSECTION.Rows[i].Cells[0].Text == dtIRIErorr.Rows[0][0].ToString() &&
gvRegionSamplesSECTION.Rows[i].Cells[1].Text == dtIRIErorr.Rows[0][1].ToString())
{
gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red;
}
}
}
DataTable dtdublicate = new JpmmsClasses.BL.MainStreet().GetStreetsDublicateLanesSKIDNew(ddlRegions.SelectedItem.Text);
if (dtdublicate.Rows.Count > 0)
{
for (int i = 0; i < gvRegionSamplesIRI.Rows.Count; i++)
{
for (int j = 0; j < dtdublicate.Rows.Count; j++)
{
if (gvRegionSamplesIRI.Rows[i].Cells[0].Text == dtdublicate.Rows[j][2].ToString() &&
gvRegionSamplesIRI.Rows[i].Cells[1].Text == dtdublicate.Rows[j][3].ToString())
{
if (gvRegionSamplesIRI.Rows[i].Cells[3].Text == string.Empty)
{
gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red;
gvRegionSamplesIRI.Rows[i].Cells[3].Text = " مكرر ";
}
else
{
gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Salmon;
gvRegionSamplesIRI.Rows[i].Cells[3].Text += " ومكرر ";
}
}
}
}
}
lblFeedback.Text = "البيانات من المعدة يوجد بها تكرار";
}
else
{
lblFeedback.Text = ex.Message;
}
lblFeedback.Focus();
}
//ViewState["gvRegionSamplesSECTION"] = gvRegionSamplesSECTION.DataSource;
//ViewState["gvRegionSamplesIRI"] = gvRegionSamplesIRI.DataSource;
//ViewState["sortdrIRI"] = "Asc";
//ViewState["sortdr"] = "Asc";
}
protected void ddlRegions_SelectedIndexChanged(object sender, EventArgs e)
{
lblFeedback.Text = string.Empty;
if (ddlRegions.SelectedValue != "-1")
{
DataTable dtIRI;
if (RadioButtonList1.SelectedValue == "1")
{
gvRegionSamplesIRI.Visible = true;
gvRegionSamplesNEW.Visible = false;
if (ddlRegions.SelectedValue == "0")
{
dtIRI = new JpmmsClasses.BL.MainStreet().GetSectionsDetailsIRI();
}
else
{
dtIRI = new JpmmsClasses.BL.MainStreet().GetSectionsDetailsIRI(ddlRegions.SelectedValue);
}
gvRegionSamplesIRI.DataSource = dtIRI;
gvRegionSamplesIRI.DataBind();
float value = 0;
for (int i = 0; i < gvRegionSamplesIRI.Rows.Count; i++)
{
value += float.Parse((gvRegionSamplesIRI.Rows[i].Cells[9]).Text);
}
lblFeedback.Text += " طول الشارع " + value.ToString() + " م / حارة ";
ViewState["gvRegionSamplesIRI"] = dtIRI;
}
else if (RadioButtonList1.SelectedValue == "0")
{
gvRegionSamplesIRI.Visible = false;
gvRegionSamplesNEW.Visible = true;
if (ddlRegions.SelectedValue == "0")
{
dtIRI = new JpmmsClasses.BL.MainStreet().GetSectionsDetailsNewIRI();
}
else
{
dtIRI = new JpmmsClasses.BL.MainStreet().GetSectionsDetailsNewIRI(ddlRegions.SelectedValue);
}
gvRegionSamplesNEW.DataSource = dtIRI;
gvRegionSamplesNEW.DataBind();
float value = 0;
for (int i = 0; i < gvRegionSamplesNEW.Rows.Count; i++)
{
value += float.Parse((gvRegionSamplesNEW.Rows[i].Cells[6]).Text);
}
lblFeedback.Text += " طول الشارع " + value.ToString() + " م / حارة ";
ViewState["gvRegionSamplesNEW"] = dtIRI;
}
else if (RadioButtonList1.SelectedValue == "2")
{
gvRegionSamplesIRI.Visible = true;
gvRegionSamplesNEW.Visible = false;
if (ddlRegions.SelectedValue == "0")
{
dtIRI = new JpmmsClasses.BL.MainStreet().GetSectionsDetailsSYS();
}
else
{
dtIRI = new JpmmsClasses.BL.MainStreet().GetSectionsDetailsSYS(ddlRegions.SelectedValue);
}
gvRegionSamplesIRI.DataSource = dtIRI;
gvRegionSamplesIRI.DataBind();
float value = 0;
for (int i = 0; i < gvRegionSamplesIRI.Rows.Count; i++)
{
if ((gvRegionSamplesIRI.Rows[i].Cells[9]).Text == " ")
{
value += float.Parse("0");
gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.BlanchedAlmond;
}
else
{
value += float.Parse((gvRegionSamplesIRI.Rows[i].Cells[9]).Text);
}
}
lblFeedback.Text += " طول الشارع " + value.ToString() + " م / حارة ";
ViewState["gvRegionSamplesIRI"] = dtIRI;
}
}
}
protected void BtnFinshed_Click(object sender, EventArgs e)
{
lblFeedback.Text = string.Empty;
if (Session["UserID"].ToString() == "48")
{
if (ddlRegions.SelectedValue != "-1" && ddlRegions.SelectedValue != string.Empty)
{
if (ddlRegions.SelectedValue == "0")
{
int Total = ddlRegions.Items.Count - 2;
bool Value = false;
if (new JpmmsClasses.BL.MainStreet().Remove_InsertUpdateIRISections())
{
System.Data.DataTable dtErorrUpdate = new JpmmsClasses.BL.MainStreet().CheckUpdateLengthSAMPLES();
if (dtErorrUpdate != null && dtErorrUpdate.Rows.Count == 0)
{
lblFeedbackErorr.Text = string.Empty;
if (new JpmmsClasses.BL.MainStreet().UpdateLengthSAMPLES())
{
Value = true;
}
else
{
Value = false;
}
}
else
{
lblFeedbackErorr.Text = "بيانات مدخلة خطأ ";
gvRegionSamplesErorr.DataSource = dtErorrUpdate;
gvRegionSamplesErorr.DataBind();
}
}
else
{
Value = false;
}
//}
//else
// Value = false;
if (Value)
{
ddlRegions.SelectedValue = "-1";
lblFeedback.Text = "تم تحديث جميع الأطوال";
}
else
{
ddlRegions.SelectedValue = "-1";
lblFeedback.Text = Feedback.UpdateUNSuccessfull();
}
}
else
{
if (new JpmmsClasses.BL.MainStreet().RemoveIRILength())
{
if (new JpmmsClasses.BL.MainStreet().InsertLengthDDF(ddlRegions.SelectedValue))
{
lblFeedback.Text = new JpmmsClasses.BL.MainStreet().UpdateLengthSAMPLESOld() == true ? "تم تحديث الأطوال" : Feedback.UpdateUNSuccessfull();
ddlRegions.SelectedValue = "-1";
}
else
{
ddlRegions.SelectedValue = "-1";
lblFeedback.Text = Feedback.UpdateUNSuccessfull();
}
}
else
{
ddlRegions.SelectedValue = "-1";
lblFeedback.Text = Feedback.UpdateUNSuccessfull();
}
}
}
}
else
{
lblFeedback.Text = Feedback.NoPermissions();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
else
{
if (Request.QueryString.Count == 1)
{
spanInterSectionsExcellent.Visible = false;
spanInterSectionsPoor.Visible = false;
spanInterSectionWorkorderMin.Visible = false;
spanInterSectionWorkorderUdi.Visible = false;
spanRegionsExcellent.Visible = false;
spanRegionsPoor.Visible = false;
spanRegionsWorkorderMin.Visible = false;
spanRegionsWorkorderUdi.Visible = false;
spanSectionsExcellent.Visible = false;
spanSectionsPoor.Visible = false;
spanSectionWorkorderMin.Visible = false;
spanSectionWorkorderUdi.Visible = false;
}
else
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().CountUDI();
System.Data.DataTable dtMinRegions = new JpmmsClasses.BL.Lookups.SystemUsers().GetReceivedMaintinanceStreets();
int SectionsExcellent = 0;
int SectionsPoor = 0;
int SectionWorkorderMin = 0;
int SectionWorkorderUdi = 0;
int RegionsExcellent = int.Parse(dt.Rows[0]["CountRegionsExcellent"].ToString());
int RegionsPoor = int.Parse(dt.Rows[0]["CountRegionsPoor"].ToString());
int RegionsWorkorderUdi = int.Parse(dt.Rows[0]["TOTALUDI"].ToString());
int RegionsWorkorderMin = dtMinRegions.Rows.Count;
int InterSectionsExcellent = 0;
int InterSectionsPoor = 0;
int InterSectionWorkorderMin = 0;
int InterSectionWorkorderUdi = 0;
if (SectionsExcellent > 0)
{
spanSectionsExcellent.Visible = true;
spanSectionsExcellent.InnerText = SectionsExcellent.ToString();
}
else
{
spanSectionsExcellent.Visible = false;
spanSectionsExcellent.InnerText = string.Empty;
}
if (SectionsPoor > 0)
{
spanSectionsPoor.Visible = true;
spanSectionsPoor.InnerText = SectionsPoor.ToString();
}
else
{
spanSectionsPoor.Visible = false;
spanSectionsPoor.InnerText = string.Empty;
}
if (SectionWorkorderMin > 0)
{
spanSectionWorkorderMin.Visible = true;
spanSectionWorkorderMin.InnerText = SectionWorkorderMin.ToString();
}
else
{
spanSectionWorkorderMin.Visible = false;
spanSectionWorkorderMin.InnerText = string.Empty;
}
if (SectionWorkorderUdi > 0)
{
spanSectionWorkorderUdi.Visible = true;
spanSectionWorkorderUdi.InnerText = SectionWorkorderUdi.ToString();
}
else
{
spanSectionWorkorderUdi.Visible = false;
spanSectionWorkorderUdi.InnerText = string.Empty;
}
if (RegionsExcellent > 0)
{
spanRegionsExcellent.Visible = true;
spanRegionsExcellent.InnerText = RegionsExcellent.ToString();
}
else
{
spanRegionsExcellent.Visible = false;
spanRegionsExcellent.InnerText = string.Empty;
}
if (RegionsPoor > 0)
{
spanRegionsPoor.Visible = true;
spanRegionsPoor.InnerText = RegionsPoor.ToString();
}
else
{
spanRegionsPoor.Visible = false;
spanRegionsPoor.InnerText = string.Empty;
}
if (RegionsWorkorderUdi > 0)
{
spanRegionsWorkorderUdi.Visible = true;
spanRegionsWorkorderUdi.InnerText = RegionsWorkorderUdi.ToString();
}
else
{
spanRegionsWorkorderUdi.Visible = false;
spanRegionsWorkorderUdi.InnerText = string.Empty;
}
if (RegionsWorkorderMin > 0)
{
RegionsWorkorderMin = 0;
for (int i = 0; i < dtMinRegions.Rows.Count; i++)
{
if (dtMinRegions.Rows[i][1].ToString() != (int.Parse(dtMinRegions.Rows[i][0].ToString()) + int.Parse(dtMinRegions.Rows[i][2].ToString())).ToString())
{
RegionsWorkorderMin++;
}
}
spanRegionsWorkorderMin.Visible = true;
spanRegionsWorkorderMin.InnerText = RegionsWorkorderMin.ToString();
}
else
{
spanRegionsWorkorderMin.Visible = false;
spanRegionsWorkorderMin.InnerText = string.Empty;
}
if (InterSectionsExcellent > 0)
{
spanInterSectionsExcellent.Visible = true;
spanInterSectionsExcellent.InnerText = SectionsExcellent.ToString();
}
else
{
spanInterSectionsExcellent.Visible = false;
spanInterSectionsExcellent.InnerText = string.Empty;
}
if (InterSectionsPoor > 0)
{
spanInterSectionsPoor.Visible = true;
spanInterSectionsPoor.InnerText = InterSectionsPoor.ToString();
}
else
{
spanInterSectionsPoor.Visible = false;
spanInterSectionsPoor.InnerText = string.Empty;
}
if (InterSectionWorkorderMin > 0)
{
spanInterSectionWorkorderMin.Visible = true;
spanInterSectionWorkorderMin.InnerText = InterSectionWorkorderMin.ToString();
}
else
{
spanInterSectionWorkorderMin.Visible = false;
spanInterSectionWorkorderMin.InnerText = string.Empty;
}
if (InterSectionWorkorderUdi > 0)
{
spanInterSectionWorkorderUdi.Visible = true;
spanInterSectionWorkorderUdi.InnerText = InterSectionWorkorderUdi.ToString();
}
else
{
spanInterSectionWorkorderUdi.Visible = false;
spanInterSectionWorkorderUdi.InnerText = string.Empty;
}
}
}
}
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);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[1] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
else
{
if (Request.QueryString.Count == 1)
{
spanIntersectionsEditReady.Visible = false;
spanIntersectionsReady.Visible = false;
spanInterSectionsFinshed.Visible = false;
spanInterSectionsNotFinshed.Visible = false;
spanInterSectionsReportReview.Visible = false;
spanInterSectionsClearance.Visible = false;
spanInterSectionsMissing.Visible = false;
spanValidateAREA.Visible = false;
spanInsertGis.Visible = false;
spanQcUdi.Visible = false;
spanIntersectionArea.Visible = false;
}
else
{
System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().CounIntersectionsUdiMin();
int IntersectionsEditReady = int.Parse(dt.Rows[0]["TOTALIntersectionsEditReady"].ToString());
int IntersectionsReady = int.Parse(dt.Rows[0]["TOTALIntersectionsReady"].ToString());
int InterSectionsNotFinshed = int.Parse(dt.Rows[0]["CountInterSectionsNotFinshed"].ToString());
int InterSectionsFinshed = int.Parse(dt.Rows[0]["CountInterSectionsFinshed"].ToString());
int InterSectionsReportReview = int.Parse(dt.Rows[0]["CountInterSectionsReports"].ToString());
int InterSectionsClearance = int.Parse(dt.Rows[0]["CountInterSectionsClearance"].ToString());
int InterSectionsMissing = int.Parse(dt.Rows[0]["CountInterSectionsMissing"].ToString());
int ValidateAREA = int.Parse(dt.Rows[0]["CountAREA"].ToString());
int InsertGis = int.Parse(dt.Rows[0]["CountGis"].ToString());
int IntersectionArea = int.Parse(dt.Rows[0]["CountExceedArea"].ToString());
int QcUdi = int.Parse(dt.Rows[0]["CountQcUDI"].ToString());
if (QcUdi > 0)
{
spanQcUdi.Visible = true;
spanQcUdi.InnerText = QcUdi.ToString();
}
else
{
spanQcUdi.Visible = false;
spanQcUdi.InnerText = string.Empty;
}
if (IntersectionArea > 0)
{
spanIntersectionArea.Visible = true;
spanIntersectionArea.InnerText = IntersectionArea.ToString();
}
else
{
spanIntersectionArea.Visible = false;
spanIntersectionArea.InnerText = string.Empty;
}
if (InsertGis > 0)
{
spanInsertGis.Visible = true;
spanInsertGis.InnerText = InsertGis.ToString();
}
else
{
spanInsertGis.Visible = false;
spanInsertGis.InnerText = string.Empty;
}
if (ValidateAREA > 0)
{
spanValidateAREA.Visible = true;
spanValidateAREA.InnerText = ValidateAREA.ToString();
}
else
{
spanValidateAREA.Visible = false;
spanValidateAREA.InnerText = string.Empty;
}
if (InterSectionsMissing > 0)
{
spanInterSectionsMissing.Visible = true;
spanInterSectionsMissing.InnerText = InterSectionsMissing.ToString();
}
else
{
spanInterSectionsMissing.Visible = false;
spanInterSectionsMissing.InnerText = string.Empty;
}
if (InterSectionsClearance > 0)
{
spanInterSectionsClearance.Visible = true;
spanInterSectionsClearance.InnerText = InterSectionsClearance.ToString();
}
else
{
spanInterSectionsClearance.Visible = false;
spanInterSectionsClearance.InnerText = string.Empty;
}
if (InterSectionsNotFinshed > 0)
{
spanInterSectionsNotFinshed.Visible = true;
spanInterSectionsNotFinshed.InnerText = InterSectionsNotFinshed.ToString();
}
else
{
spanInterSectionsNotFinshed.Visible = false;
spanInterSectionsNotFinshed.InnerText = string.Empty;
}
if (InterSectionsFinshed > 0)
{
spanInterSectionsFinshed.Visible = true;
spanInterSectionsFinshed.InnerText = InterSectionsFinshed.ToString();
}
else
{
spanInterSectionsFinshed.Visible = false;
spanInterSectionsFinshed.InnerText = string.Empty;
}
if (InterSectionsReportReview > 0)
{
spanInterSectionsReportReview.Visible = true;
spanInterSectionsReportReview.InnerText = InterSectionsReportReview.ToString();
}
else
{
spanInterSectionsReportReview.Visible = false;
spanInterSectionsReportReview.InnerText = string.Empty;
}
if (IntersectionsEditReady > 0)
{
spanIntersectionsEditReady.Visible = true;
spanIntersectionsEditReady.InnerText = IntersectionsEditReady.ToString();
}
else
{
spanIntersectionsEditReady.Visible = false;
spanIntersectionsEditReady.InnerText = string.Empty;
}
if (IntersectionsReady > 0)
{
spanIntersectionsReady.Visible = true;
spanIntersectionsReady.InnerText = IntersectionsReady.ToString();
}
else
{
spanIntersectionsReady.Visible = false;
spanIntersectionsReady.InnerText = string.Empty;
}
}
}
}
