protected void ddlRegions_SelectedIndexChanged(object sender, EventArgs e) { if (ddlRegions.SelectedValue != "0") { lblFeedback.Text = string.Empty; DataTable dt1 = new JpmmsClasses.BL.MainStreet().GetStreetsIRI(); RadioButtonList1.Items.Clear(); RadioButtonList1.Items.AddRange(new SharedClass().CreateRadioBtnSurveys(dt1.Rows[ddlRegions.SelectedIndex - 1][3].ToString())); RadioButtonList1.SelectedValue = dt1.Rows[ddlRegions.SelectedIndex - 1][2].ToString(); RadioButtonList1.DataBind(); gvRegionSamplesIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsSampleDublicateIRI(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionSamplesIRI.DataBind(); if (gvRegionSamplesIRI.Rows.Count > 0) { lblFeedback0.Text = string.Empty; DataTable dt = new JpmmsClasses.BL.MainStreet().GetStreetsInfo(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); DataColumn d = new DataColumn("DublicateIRI"); d.DefaultValue = gvRegionSamplesIRI.Rows.Count; dt.Columns.Add(d); gvRegionIRI.DataSource = dt; gvRegionIRI.DataBind(); } else { lblFeedback0.Text = Feedback.NoData(); gvRegionIRI.DataSource = null; gvRegionIRI.DataBind(); } } }
protected void ddlMainStreets_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) { DataTable dtx = new JpmmsClasses.BL.MainStreet().GetStreetsAssets(); RadioButtonList1.Items.Clear(); RadioButtonList1.Items.AddRange(new SharedClass().CreateRadioBtnSurveys(dtx.Rows[ddlMainStreets.SelectedIndex - 1][3].ToString())); RadioButtonList1.SelectedValue = dtx.Rows[ddlMainStreets.SelectedIndex - 1][2].ToString(); RadioButtonList1.DataBind(); }
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { if (ddlRegions.SelectedValue != "0") { gvRegionIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo(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().GetStreetsSections(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"; } }
private void CalculateMainStreetsMinWithDate() { bool result = true; MaintenanceDecisions maintD = new MaintenanceDecisions(); string user = Session["UserName"].ToString(); DataTable dt = new JpmmsClasses.BL.MainStreet().FinshedMFVMaintenanceWithDate("02/01/2020", "3"); foreach (DataRow dr in dt.Rows) { result &= maintD.PrepareMainStreetSectionsMaintenanceDecisions(int.Parse(dr["STREET_ID"].ToString()), user, true); } dt = new DataTable(); ThreadResults.Add(RequestID, dt); }
private void CalculateMainStreetsMin() { bool result = true; MaintenanceDecisions maintD = new MaintenanceDecisions(); string user = Session["UserName"].ToString(); DataTable dt = new JpmmsClasses.BL.MainStreet().FinshedRrturnToMFVMaintenance();//.CustomMunicpilityMaintenance(); foreach (DataRow dr in dt.Rows) { result &= maintD.PrepareMainStreetSectionsMaintenanceDecisions(int.Parse(dr["STREET_ID"].ToString()), user, false); } dt = new DataTable(); ThreadResults.Add(RequestID, dt); }
private void CalculateMainStreetsUdi() { bool result = true; SectionsUDI udiSections = new SectionsUDI(); string user = Session["UserName"].ToString(); DataTable dt = new JpmmsClasses.BL.MainStreet().FinshedRrturnToMFVUDI();//.CustomMunicpilityUdi();// foreach (DataRow dr in dt.Rows) { result &= udiSections.CalculateMainStreetSectionsUDI(int.Parse(dr["STREET_ID"].ToString()), user, false); } dt = new DataTable(); ThreadResults.Add(RequestID, dt); }
protected void RadioBtnListSYS_SelectedIndexChanged(object sender, EventArgs e) { if (ddlRegions.SelectedValue != "0") { System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetStreetsIRI(); RadioButtonList1.Items.Clear(); RadioButtonList1.Items.AddRange(new SharedClass().CreateRadioBtnSurveys(dt.Rows[ddlRegions.SelectedIndex - 1][3].ToString())); RadioButtonList1.SelectedValue = dt.Rows[ddlRegions.SelectedIndex - 1][2].ToString(); RadioButtonList1.DataBind(); if (RadioBtnListSYS.SelectedValue == "1") { gvERorrLanes.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsDublicateLanesIRI(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvERorrLanes.DataBind(); if (gvERorrLanes.Rows.Count > 0) { lblFeedback.Text = string.Empty; } else { lblFeedback.Text = Feedback.NoData(); } } else { gvERorrLanes.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsDublicateLanes(ddlRegions.SelectedItem.Text); gvERorrLanes.DataBind(); if (gvERorrLanes.Rows.Count > 0) { lblFeedback.Text = string.Empty; } else { lblFeedback.Text = Feedback.NoData(); } } } }
protected void RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { gvRegionIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfoSKID(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionIRI.DataBind(); gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionSections.DataBind(); DataTable dtIRI = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLengthSKID(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); DataTable dtSection = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLength(ddlRegions.SelectedItem.Text, RadioButtonList1.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 = "غير موجود IRI"; } } } 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 = "غير موجود SKID"; } } } } 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().GetStreetsDublicateLanesSKID(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(); } }
protected void ddlRegions_SelectedIndexChanged(object sender, EventArgs e) { System.Data.DataTable dt = new JpmmsClasses.BL.MainStreet().GetStreetsGPR(); RadioButtonList1.Items.Clear(); RadioButtonList1.Items.AddRange(new SharedClass().CreateRadioBtnSurveys(dt.Rows[ddlRegions.SelectedIndex - 1][3].ToString())); RadioButtonList1.SelectedValue = dt.Rows[ddlRegions.SelectedIndex - 1][2].ToString(); RadioButtonList1.DataBind(); if (dt.Rows[ddlRegions.SelectedIndex - 1][3].ToString() == "1") { RadioButtonList1.Enabled = false; } else { RadioButtonList1.Enabled = true; } gvRegionIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfoGPR(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionIRI.DataBind(); gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionSections.DataBind(); DataTable dtIRI = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsGPR(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); DataTable dtSection = new JpmmsClasses.BL.MainStreet().GetStreetsSections(ddlRegions.SelectedItem.Text, RadioButtonList1.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 gvRegionSamplesSECTION_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { if (Session["UserID"].ToString() == "55" || Session["UserID"].ToString() == "49" || Session["UserID"].ToString() == "48") { if (new JpmmsClasses.BL.MainStreet().DeleteCleanDDF(gvRegionSamplesSECTION.Rows[e.NewSelectedIndex].Cells[0].Text, gvRegionSamplesSECTION.Rows[e.NewSelectedIndex].Cells[1].Text, RadioButtonList1.SelectedValue)) { lblFeedback.Text = Feedback.UpdateSuccessfull(); DataTable dtSection = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLengthDDFCLEAN(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); dtSection.PrimaryKey = new DataColumn[] { dtSection.Columns["SECTION_NO"], dtSection.Columns["LANE"] }; gvRegionSamplesSECTION.DataSource = dtSection; gvRegionSamplesSECTION.DataBind(); for (int i = 0; i < gvRegionSamplesSECTION.Rows.Count; i++) { if (gvRegionSamplesSECTION.Rows[i].RowType == DataControlRowType.DataRow) { if (gvRegionSamplesSECTION.Rows[i].Cells[2].Text != "0") { gvRegionSamplesSECTION.Rows[i].Cells[4].Visible = false; } else { gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.LimeGreen; gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "تم اضافة نظيف"; gvRegionSamplesSECTION.Rows[i].Cells[2].Text = string.Empty; } } } 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 = "غير موجود بــ DDF"; gvRegionSamplesIRI.Rows[i].Cells[4].Visible = true; } else { gvRegionSamplesIRI.Rows[i].Cells[4].Visible = false; } } } gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfoDDF(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionSections.DataBind(); e.Cancel = true; } else { e.Cancel = true; lblFeedback.Text = Feedback.UpdateUNSuccessfull(); } } else { e.Cancel = true; lblFeedback.Text = Feedback.NoPermissions(); } }
protected void ddlRegions_SelectedIndexChanged(object sender, EventArgs e) { if (ddlRegions.SelectedValue != "0") { lblFeedback0.Text = string.Empty; lblFeedback.Text = string.Empty; DataTable dt = new JpmmsClasses.BL.MainStreet().GetStreetsDDF(); RadioButtonList1.Items.Clear(); RadioButtonList1.Items.Add(new SharedClass().CreateRadioBtnMaxSurveys(dt.Rows[ddlRegions.SelectedIndex - 1][2].ToString())); RadioButtonList1.SelectedValue = dt.Rows[ddlRegions.SelectedIndex - 1][2].ToString(); RadioButtonList1.DataBind(); gvRegionIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionIRI.DataBind(); gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfoDDF(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionSections.DataBind(); DataTable dtIRI = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLength(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); DataTable dtSection = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLengthDDFCLEAN(ddlRegions.SelectedItem.Text, RadioButtonList1.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 = "غير موجود بــ DDF"; } else { gvRegionSamplesIRI.Rows[i].Cells[4].Visible = false; } } } 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 = "غير موجود بــ IRI"; } if (gvRegionSamplesSECTION.Rows[i].Cells[2].Text != "0") { gvRegionSamplesSECTION.Rows[i].Cells[4].Visible = false; } else { gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.LimeGreen; gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "تم اضافة نظيف"; gvRegionSamplesSECTION.Rows[i].Cells[2].Text = string.Empty; } } } } 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(); } } } 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; } } lblFeedback.Text = "البيانات من النظام يوجد بها تكرار"; } else { 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 RadioButtonList1_SelectedIndexChanged(object sender, EventArgs e) { if (ddlRegions.SelectedValue != "0") { lblFeedback0.Text = string.Empty; lblFeedback.Text = string.Empty; lblFeedback1.Text = string.Empty; gvRegionIRI.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionIRI.DataBind(); gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfoDDF(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); gvRegionSections.DataBind(); gvRegionSections.DataSource = new JpmmsClasses.BL.MainStreet().GetStreetsInfo((int.Parse(ddlRegions.SelectedValue))); gvRegionSections.DataBind(); DataTable dtIRI = new JpmmsClasses.BL.MainStreet().GetStreetsSectionsLength(ddlRegions.SelectedItem.Text, RadioButtonList1.SelectedValue); 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"] }; dtIRI.PrimaryKey = new DataColumn[] { dtIRI.Columns["SECTION_NO"], dtIRI.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 })) { int SectionLenth = int.Parse( dtSection.Rows.Find(new object[] { gvRegionSamplesIRI.Rows[i].Cells[0].Text, gvRegionSamplesIRI.Rows[i].Cells[1].Text }).ItemArray[3].ToString()); if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 4000)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "4000 تجاوز الطول"; gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 3000)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "3000 تجاوز الطول"; gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 2000)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "2000 تجاوز الطول"; gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 1000)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "1000 تجاوز الطول"; gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 600)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "600 تجاوز الطول"; gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 450)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "450 تجاوز الطول"; gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 300)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "300 تجاوز الطول"; gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 200)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "200 تجاوز الطول"; gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 75)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "75 تجاوز الطول"; //gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.BlueViolet; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 50)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "50 تجاوز الطول"; //gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.Aqua; } else if ((System.Math.Abs(int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - SectionLenth) > 25)) { gvRegionSamplesIRI.Rows[i].Cells[3].Text = "25 تجاوز الطول"; //gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.AntiqueWhite; } //if ((int.Parse(gvRegionSamplesIRI.Rows[i].Cells[2].Text) - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text) > 25)) //{ // gvRegionSamplesIRI.Rows[i].Cells[3].Text = " تجاوز الطول"; // gvRegionSamplesIRI.Rows[i].BackColor = System.Drawing.Color.BlueViolet; // gvRegionSamplesSECTION.Rows[i].Cells[3].Text = " تجاوز الطول"; // gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.BlueViolet; //} } } } 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 })) { int SectionLenth = int.Parse( dtIRI.Rows.Find(new object[] { gvRegionSamplesSECTION.Rows[i].Cells[0].Text, gvRegionSamplesSECTION.Rows[i].Cells[1].Text }).ItemArray[2].ToString()); if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 4000)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "4000 تجاوز الطول"; gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 3000)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "3000 تجاوز الطول"; gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 2000)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "2000 تجاوز الطول"; gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 1000)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "1000 تجاوز الطول"; gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 600)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "600 تجاوز الطول"; gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 450)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "450 تجاوز الطول"; gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 300)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "300 تجاوز الطول"; gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 200)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "200 تجاوز الطول"; gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Red; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 75)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "75 تجاوز الطول"; //gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.BlueViolet; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 50)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "50 تجاوز الطول"; //gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.Aqua; } else if ((System.Math.Abs(SectionLenth - int.Parse(gvRegionSamplesSECTION.Rows[i].Cells[2].Text)) > 25)) { gvRegionSamplesSECTION.Rows[i].Cells[3].Text = "25 تجاوز الطول"; //gvRegionSamplesSECTION.Rows[i].BackColor = System.Drawing.Color.AntiqueWhite; } } } } } catch { } } }