private void Calculate() { DataTable dt; bool result = true; MaintenanceDecisions maintD = new MaintenanceDecisions(); string user = Session["UserName"].ToString(); dt = new MainStreet().GetMainStreetsHavingSurveyDistresses(); foreach (DataRow dr in dt.Rows) { result &= maintD.PrepareMainStreetSectionsMaintenanceDecisions(int.Parse(dr["STREET_ID"].ToString()), user, true); // id3 } dt = new MainStreet().GetMainStreetsHavingIntersectionsSurveyDistresses(); foreach (DataRow dr in dt.Rows) { result &= maintD.PrepareMainStreetIntersectionsMaintenanceDecisions(int.Parse(dr["STREET_ID"].ToString()), user, true); } dt = new Region().GetSurveyedRegions(); foreach (DataRow dr in dt.Rows) { result &= maintD.PrepareRegionSecondaryStreetsMaintenanceDecisions(int.Parse(dr["REGION_ID"].ToString()), user, true); } dt = new DataTable(); ThreadResults.Add(RequestID, dt); }
protected void UpdateButton_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; if (!bool.Parse(Session["canEdit"].ToString())) { throw new Exception(Feedback.NoPermissions()); } bool saved = new MainStreet().Update(MAIN_NAMETextBox.Text, MAIN_EN_NAMETextBox.Text, int.Parse(ddlContractors.SelectedValue), chkIsR4.Checked, radFully.Checked, radPartially.Checked, radNot.Checked, txtDetails.Text, int.Parse(ddlCategories.SelectedValue), lblMainNo.Text, chkIntersectSamples.Checked, int.Parse(ddlMainSt.SelectedValue), txtOfficialNum.Text); if (saved) { lblFeedback.Text = Feedback.UpdateSuccessfull(); pnlEdit.Visible = false; ddlMainSt.Items.Clear(); ddlMainSt.Items.Add(new ListItem("اختيار", "0")); ddlMainSt.DataBind(); } else { lblFeedback.Text = Feedback.UpdateException(); } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }
private void Calculate() { DataTable dt; bool result = true; SectionsUDI udiSections = new SectionsUDI(); IntersectionUDI udiIntersect = new IntersectionUDI(); RegionSecondaryStUDI udiRegions = new RegionSecondaryStUDI(); string user = Session["UserName"].ToString(); dt = new MainStreet().GetMainStreetsHavingSurveyDistresses(); foreach (DataRow dr in dt.Rows) result &= udiSections.CalculateMainStreetSectionsUDI(int.Parse(dr["STREET_ID"].ToString()), user, true); dt = new MainStreet().GetMainStreetsHavingIntersectionsSurveyDistresses(); foreach (DataRow dr in dt.Rows) result &= udiIntersect.CalculateMainStreetIntersectionsUDI(int.Parse(dr["STREET_ID"].ToString()), user, true); dt = new Region().GetSurveyedRegions(); foreach (DataRow dr in dt.Rows) result &= udiRegions.CalculateRegionSecondaryStreetsUDI(int.Parse(dr["REGION_ID"].ToString()), user, true); dt = new DataTable(); ThreadResults.Add(RequestID, dt); }
private void CalculateMainStreets() { DataTable dt; bool result = true; SectionsUDI udiSections = new SectionsUDI(); string user = Session["UserName"].ToString(); dt = new MainStreet().GetMainStreetsHavingSurveyDistresses(); foreach (DataRow dr in dt.Rows) { result &= udiSections.CalculateMainStreetSectionsUDI(int.Parse(dr["STREET_ID"].ToString()), user, true); } dt = new DataTable(); ThreadResults.Add(RequestID, dt); }
protected void btnShowReport_Click(object sender, EventArgs e) { //DataTable dt = new MainStreet().GetAssets("0013"); DataSet ds = new MainStreet().GetAssetsTotal(ddlMainStreets.SelectedItem.Text, RadioButtonList1.SelectedValue); if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { Session.Add("option", "radByMainLanes"); Session.Add("ReportDataDs", ds); string url = "ViewAssets.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = Feedback.NoData(); } }
protected void btnSearch_Click(object sender, EventArgs e) { try { lblError.Text = ""; DataTable dt = new MainStreet().Search(txtNumSearch.Text, radByNumber.Checked); Session["search"] = dt; gvSearch.DataSource = dt; gvSearch.DataBind(); lblError.Text = (dt.Rows.Count == 0) ? Feedback.NoData() : ""; } catch (Exception ex) { lblError.Text = ex.Message; } }
protected void gvMainSt_SelectedIndexChanged(object sender, EventArgs e) { lblFeedback.Text = ""; //frvMainStEdit.DataBind(); if (ddlMainSt.SelectedValue != "0") { DataTable dt = new MainStreet().GetByID(int.Parse(ddlMainSt.SelectedValue)); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lblMainNo.Text = dr["MAIN_NO"].ToString(); MAIN_NAMETextBox.Text = dr["MAIN_NAME"].ToString(); MAIN_EN_NAMETextBox.Text = dr["MAIN_EN_NAME"].ToString(); txtDetails.Text = dr["OWNERSHIP_DETAILS"].ToString(); txtOfficialNum.Text = dr["OFFICIAL_MUNIC_NUM"].ToString(); ddlCategories.SelectedValue = dr["MAINST_CATEGORY_ID"].ToString(); ddlContractors.SelectedValue = dr["CONTRACTOR_ID"].ToString(); radFully.Checked = bool.Parse(dr["FULLY_MUNIC_OWNED"].ToString()); radPartially.Checked = bool.Parse(dr["PARTIALLY_MUNIC_OWNED"].ToString()); radNot.Checked = bool.Parse(dr["NOT_MUNIC_OWNED"].ToString()); chkIntersectSamples.Checked = bool.Parse(dr["ALL_INTERSAMP_OWNED_MUNIC"].ToString()); chkIsR4.Checked = bool.Parse(dr["IS_R4"].ToString()); pnlEdit.Visible = true; } else { pnlEdit.Visible = false; } } else { pnlEdit.Visible = 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) { spanDEquipStreet.Visible = false; spanDistressmanuale.Visible = false; spanDrawStreet.Visible = false; spanDrawUpdateStreet.Visible = false; spanEditStreet.Visible = false; spanEquipStreet.Visible = false; spanErorrIRI.Visible = false; spanExiststStreet.Visible = false; spanExiststStreetNext.Visible = false; spanFDrawStreet.Visible = false; spanFinshStreet.Visible = false; spanGisStreet.Visible = false; spanLaneDublicate.Visible = false; spanLaneDublicateIRI.Visible = false; spanLaneSampleErorr.Visible = false; spanLaneSecErorr.Visible = false; spanMainErorr.Visible = false; spanMinStreet.Visible = false; spanMinStreetSampleDelete.Visible = false; spanMissSample.Visible = false; spanNewStreet.Visible = false; spanNewStreetGIS.Visible = false; spanQDistrssStreet.Visible = false; spanQDrawStreet.Visible = false; spanSampleDublicate.Visible = false; spanSamplesAreaStreet.Visible = false; spanSecFromTO.Visible = false; spanSectionsErorrDistress.Visible = false; spanStreetsDeleted.Visible = false; spanStreetsErorr.Visible = false; spanUdiStreet.Visible = false; spanUpdateStreet.Visible = false; spanSectionsMainNOIRI.Visible = false; spanSectionsMainNODDF.Visible = false; spanErorrData.Visible = false; spanISNotComplete.Visible = false; } else { System.Data.DataTable dt = new MainStreet().CountMFV(); int ISNotComplete = int.Parse(dt.Rows[0]["GetIsNotComplete"].ToString()); int GisStreetOK = int.Parse(dt.Rows[0]["GetNewStreetsGisOK"].ToString()); int NewStreetGIS = int.Parse(dt.Rows[0]["GetNewStreetsGis"].ToString()); int NewStreet = int.Parse(dt.Rows[0]["GetFinshedSTREETSMFVCount"].ToString()); int EditStreet = int.Parse(dt.Rows[0]["GetRecivedEditingIRI"].ToString()); int UpdateStreet = int.Parse(dt.Rows[0]["GetRecivedEditIRI"].ToString()); int FinshStreet = int.Parse(dt.Rows[0]["GetRecivedFinshedIRI"].ToString()); int DrawStreet = int.Parse(dt.Rows[0]["GetRecivedDrawingIRI"].ToString()); int FDrawStreet = int.Parse(dt.Rows[0]["GetRecivedCompleteDrawingIRI"].ToString()); int QDrawStreet = int.Parse(dt.Rows[0]["GetRecivedFinshedIRIANALYZE"].ToString()); int EquipStreet = int.Parse(dt.Rows[0]["FinshedRrturnToMFV"].ToString()); int DEquipStreet = int.Parse(dt.Rows[0]["FinshedRrturnToMFVDelete"].ToString()); int LaneDublicate = int.Parse(dt.Rows[0]["GetStreetsDublicateLanes"].ToString()); int LaneSecErorr = int.Parse(dt.Rows[0]["GetErorrSectionLane"].ToString()); int LaneSampleErorr = int.Parse(dt.Rows[0]["GetStreetsSampleExceed"].ToString()); int ExiststStreet = int.Parse(dt.Rows[0]["GetRecivedMFV"].ToString()); int ExiststStreetNext = int.Parse(dt.Rows[0]["GetRecivedMFVNext"].ToString()); int ErorrIRI = int.Parse(dt.Rows[0]["GetStreetsUpdateErorrIRI"].ToString()); int SampleDublicate = int.Parse(dt.Rows[0]["GetStreetsSampleDublicateIRI"].ToString()); int StreetsErorr = int.Parse(dt.Rows[0]["GetStreetsERorrIRI"].ToString()); int QDistrssStreet = int.Parse(dt.Rows[0]["GetDistressCount"].ToString()); int UdiStreet = int.Parse(dt.Rows[0]["GetUDICount"].ToString()); int MinStreet = int.Parse(dt.Rows[0]["GetMINCount"].ToString()); int DrawUpdateStreet = int.Parse(dt.Rows[0]["GetDrawUpdateSections"].ToString()); int SampleDelete = int.Parse(dt.Rows[0]["GetDeletedSamples"].ToString()); int Distressmanuale = int.Parse(dt.Rows[0]["Distressmanuale"].ToString()); int StreetsDeleted = int.Parse(dt.Rows[0]["GetStreetDeleted"].ToString()); int ErorrData = int.Parse(dt.Rows[0]["CountErorrData"].ToString()); int SamplesAreaStreet = 0, MissSample = 0, LaneDublicateIRI = 0, SectionsErorrDistress = 0; if (DrawStreet > 0 || FinshStreet > 0 || DrawStreet > 0 || EditStreet > 0 || QDrawStreet > 0) { MissSample = new MainStreet().GetStreetsSampleNotFoundIRI().Rows.Count; LaneDublicateIRI = new MainStreet().GetStreetsDublicateLanesIRI(null).Rows.Count; System.Data.DataTable dtDistressIRI = new MainStreet().CountSectionsErorrDistressIRI(); SectionsErorrDistress = dtDistressIRI.Rows.Count == 1 && dtDistressIRI.Rows[0][0].ToString() == "0" ? 0 : int.Parse(dtDistressIRI.Rows[0][0].ToString()); if (QDrawStreet > 0 || FinshStreet > 0) { if (new MainStreet().CheckGetLaneSamplesArea()) { System.Data.DataTable dtArea = new MainStreet().GetLaneSamplesArea(true); SamplesAreaStreet = dtArea.Rows.Count == 1 && dtArea.Rows[0][0].ToString() == "0" ? 0 : int.Parse(dtArea.Rows[0][0].ToString()); } } } if (ISNotComplete > 0) { spanISNotComplete.Visible = true; spanISNotComplete.InnerText = ISNotComplete.ToString(); } else { spanISNotComplete.Visible = false; spanISNotComplete.InnerText = string.Empty; } if (ErorrData > 0) { spanErorrData.Visible = true; spanErorrData.InnerText = ErorrData.ToString(); } else { spanErorrData.Visible = false; spanErorrData.InnerText = string.Empty; } if (StreetsDeleted > 0) { spanStreetsDeleted.Visible = true; spanStreetsDeleted.InnerText = StreetsDeleted.ToString(); } else { spanStreetsDeleted.Visible = false; spanStreetsDeleted.InnerText = string.Empty; } if (Distressmanuale > 0) { spanDistressmanuale.Visible = true; spanDistressmanuale.InnerText = Distressmanuale.ToString(); } else { spanDistressmanuale.Visible = false; spanDistressmanuale.InnerText = string.Empty; } if (SampleDelete > 0) { spanMinStreetSampleDelete.Visible = true; spanMinStreetSampleDelete.InnerText = SampleDelete.ToString(); } else { spanMinStreetSampleDelete.Visible = false; spanMinStreetSampleDelete.InnerText = string.Empty; } if (NewStreetGIS > 0) { spanNewStreetGIS.Visible = true; spanNewStreetGIS.InnerText = NewStreetGIS.ToString(); } else { spanNewStreetGIS.Visible = false; spanNewStreetGIS.InnerText = string.Empty; } if (GisStreetOK > 0) { spanGisStreet.Visible = true; spanGisStreet.InnerText = GisStreetOK.ToString(); } else { spanGisStreet.Visible = false; spanGisStreet.InnerText = string.Empty; } if (NewStreet > 0) { spanNewStreet.Visible = true; spanNewStreet.InnerText = NewStreet.ToString(); } else { spanNewStreet.Visible = false; spanNewStreet.InnerText = string.Empty; } if (EditStreet > 0) { spanEditStreet.Visible = true; spanEditStreet.InnerText = EditStreet.ToString(); } else { spanEditStreet.Visible = false; spanEditStreet.InnerText = string.Empty; } if (UpdateStreet > 0) { spanUpdateStreet.Visible = true; spanUpdateStreet.InnerText = UpdateStreet.ToString(); } else { spanUpdateStreet.Visible = false; spanUpdateStreet.InnerText = string.Empty; } if (FinshStreet > 0) { spanFinshStreet.Visible = true; spanFinshStreet.InnerText = FinshStreet.ToString(); } else { spanFinshStreet.Visible = false; spanFinshStreet.InnerText = string.Empty; } if (DrawStreet > 0) { spanDrawStreet.Visible = true; spanDrawStreet.InnerText = DrawStreet.ToString(); } else { spanDrawStreet.Visible = false; spanDrawStreet.InnerText = string.Empty; } if (QDrawStreet > 0) { spanQDrawStreet.Visible = true; spanQDrawStreet.InnerText = QDrawStreet.ToString(); } else { spanQDrawStreet.Visible = false; spanQDrawStreet.InnerText = string.Empty; } if (FDrawStreet > 0) { spanFDrawStreet.Visible = true; spanFDrawStreet.InnerText = FDrawStreet.ToString(); } else { spanFDrawStreet.Visible = false; spanFDrawStreet.InnerText = string.Empty; } if (EquipStreet > 0) { spanEquipStreet.Visible = true; spanEquipStreet.InnerText = EquipStreet.ToString(); } else { spanEquipStreet.Visible = false; spanEquipStreet.InnerText = string.Empty; } if (DEquipStreet > 0) { spanDEquipStreet.Visible = true; spanDEquipStreet.InnerText = DEquipStreet.ToString(); } else { spanDEquipStreet.Visible = false; spanDEquipStreet.InnerText = string.Empty; } if (ExiststStreet > 0) { spanExiststStreet.Visible = true; spanExiststStreet.InnerText = ExiststStreet.ToString(); } else { spanExiststStreet.Visible = false; spanExiststStreet.InnerText = string.Empty; } if (ExiststStreetNext > 0) { spanExiststStreetNext.Visible = true; spanExiststStreetNext.InnerText = ExiststStreetNext.ToString(); } else { spanExiststStreetNext.Visible = false; spanExiststStreetNext.InnerText = string.Empty; } if (SampleDublicate > 0) { spanSampleDublicate.Visible = true; spanSampleDublicate.InnerText = SampleDublicate.ToString(); } else { spanSampleDublicate.Visible = false; spanSampleDublicate.InnerText = string.Empty; } if (LaneDublicate > 0) { spanLaneDublicate.Visible = true; spanLaneDublicate.InnerText = LaneDublicate.ToString(); } else { spanLaneDublicate.Visible = false; spanLaneDublicate.InnerText = string.Empty; } if (MissSample > 0) { spanMissSample.Visible = true; spanMissSample.InnerText = MissSample.ToString(); } else { spanMissSample.Visible = false; spanMissSample.InnerText = string.Empty; } if (LaneSecErorr > 0) { spanLaneSecErorr.Visible = true; spanLaneSecErorr.InnerText = LaneSecErorr.ToString(); } else { spanLaneSecErorr.Visible = false; spanLaneSecErorr.InnerText = string.Empty; } if (ErorrIRI > 0) { spanErorrIRI.Visible = true; spanErorrIRI.InnerText = ErorrIRI.ToString(); } else { spanErorrIRI.Visible = false; spanErorrIRI.InnerText = string.Empty; } if (LaneDublicateIRI > 0) { spanLaneDublicateIRI.Visible = true; spanLaneDublicateIRI.InnerText = LaneDublicateIRI.ToString(); } else { spanLaneDublicateIRI.Visible = false; spanLaneDublicateIRI.InnerText = string.Empty; } if (LaneSampleErorr > 0) { spanLaneSampleErorr.Visible = true; spanLaneSampleErorr.InnerText = LaneSampleErorr.ToString(); } else { spanLaneSampleErorr.Visible = false; spanLaneSampleErorr.InnerText = string.Empty; } if (StreetsErorr > 0) { spanStreetsErorr.Visible = true; spanStreetsErorr.InnerText = StreetsErorr.ToString(); } else { spanStreetsErorr.Visible = false; spanStreetsErorr.InnerText = string.Empty; } if (QDistrssStreet > 0) { spanQDistrssStreet.Visible = true; spanQDistrssStreet.InnerText = QDistrssStreet.ToString(); } else { spanQDistrssStreet.Visible = false; spanQDistrssStreet.InnerText = string.Empty; } if (UdiStreet > 0) { spanUdiStreet.Visible = true; spanUdiStreet.InnerText = UdiStreet.ToString(); } else { spanUdiStreet.Visible = false; spanUdiStreet.InnerText = string.Empty; } if (MinStreet > 0) { spanMinStreet.Visible = true; spanMinStreet.InnerText = MinStreet.ToString(); } else { spanMinStreet.Visible = false; spanMinStreet.InnerText = string.Empty; } if (DrawUpdateStreet > 0) { spanDrawUpdateStreet.Visible = true; spanDrawUpdateStreet.InnerText = DrawUpdateStreet.ToString(); } else { spanDrawUpdateStreet.Visible = false; spanDrawUpdateStreet.InnerText = string.Empty; } if (SamplesAreaStreet > 0) { spanSamplesAreaStreet.Visible = true; spanSamplesAreaStreet.InnerText = SamplesAreaStreet.ToString(); } else { spanSamplesAreaStreet.Visible = false; spanSamplesAreaStreet.InnerText = string.Empty; } if (SectionsErorrDistress > 0) { spanSectionsErorrDistress.Visible = true; spanSectionsErorrDistress.InnerText = SectionsErorrDistress.ToString(); } else { spanSectionsErorrDistress.Visible = false; spanSectionsErorrDistress.InnerText = string.Empty; } } } }
private void CalculateUDI(int survey, int mainStID) { string user = Session["UserName"].ToString(); bool result = true; MaintenanceDecisions md = new MaintenanceDecisions(); if (radByMainLanes.Checked) { if (ddlMainStreets.SelectedValue == "0") { DataTable dt = new MainStreet().GetMainStreetsHavingSurveyDistresses(); foreach (DataRow dr in dt.Rows) { if (survey != 0) { result &= md.PrepareMainStreetSectionsMaintenanceDecisions(int.Parse(dr["STREET_ID"].ToString()), survey, user); } else { result &= md.PrepareMainStreetSectionsMaintenanceDecisions(int.Parse(dr["STREET_ID"].ToString()), user, false); } } } else { if (survey != 0) { result &= md.PrepareMainStreetSectionsMaintenanceDecisions(mainStID, survey, user); } else { result &= md.PrepareMainStreetSectionsMaintenanceDecisions(mainStID, user, false); } } if (result) { lblFeedback.Text = "تم الحساب بنجاح"; DataTable dt = md.GetMainStreetSectionLaneSamplesMaintenanceDecisions(mainStID, survey); //, true); ThreadResults.Add(RequestID, dt); } else { lblFeedback.Text = "فشلت عملية الحساب"; } } else if (radByIntersections.Checked) { if (ddlMainStreets.SelectedValue == "0") { DataTable dt = new MainStreet().GetMainStreetsHavingIntersectionsSurveyDistresses(); foreach (DataRow dr in dt.Rows) { if (survey != 0) { result &= md.PrepareMainStreetIntersectionsMaintenanceDecisions(int.Parse(dr["STREET_ID"].ToString()), survey, user); // id3 } else { result &= md.PrepareMainStreetIntersectionsMaintenanceDecisions(int.Parse(dr["STREET_ID"].ToString()), user, false); } } } else { if (survey != 0) { result &= md.PrepareMainStreetIntersectionsMaintenanceDecisions(mainStID, survey, user); } else { result &= md.PrepareMainStreetIntersectionsMaintenanceDecisions(mainStID, user, false); } } if (result) { lblFeedback.Text = "تم الحساب بنجاح"; DataTable dt = md.GetMainStreetIntersectionSamplesMaintenanceDecisions(mainStID, survey); ThreadResults.Add(RequestID, dt); } else { lblFeedback.Text = "فشلت عملية الحساب"; } } else { if (radByRegionNo.Checked) { if (ddlRegions.SelectedValue == "0") { DataTable dt = new Region().GetSurveyedRegions(); foreach (DataRow dr in dt.Rows) { if (survey != 0) { result = md.PrepareRegionSecondaryStreetsMaintenanceDecisions(int.Parse(dr["REGION_ID"].ToString()), survey, user); } else { result &= md.PrepareRegionSecondaryStreetsMaintenanceDecisions(int.Parse(dr["REGION_ID"].ToString()), user, false); } } } else { int regionID = int.Parse(ddlRegions.SelectedValue); if (survey != 0) { result = md.PrepareRegionSecondaryStreetsMaintenanceDecisions(regionID, survey, user); } else { result &= md.PrepareRegionSecondaryStreetsMaintenanceDecisions(regionID, user, false); } } } else if (radByRegionName.Checked) { if (ddlRegionNames.SelectedValue == "0") { throw new Exception("الرجاء اختيار الحي الفرعي"); } else { if (survey != 0) { result = md.PrepareSubdistrictSecondaryStreetsMaintenanceDecisions(ddlRegionNames.SelectedValue, survey, user); } else { result &= md.PrepareSubdistrictSecondaryStreetsMaintenanceDecisions(ddlRegionNames.SelectedValue, user); } } } else if (radByRegionsAreaName.Checked) { if (ddlDistrict.SelectedValue == "0") { throw new Exception("الرجاء اختيار الحي"); } else { if (survey != 0) { result = md.PrepareDistrictSecondaryStreetsMaintenanceDecisions(ddlDistrict.SelectedValue, survey, user); } else { result &= md.PrepareDistrictSecondaryStreetsMaintenanceDecisions(ddlDistrict.SelectedValue, user); } } } else if (radByMunicName.Checked) { if (ddlMunic.SelectedValue == "0") { throw new Exception("الرجاء اختيار البلدية الفرعية"); } else { if (survey != 0) { result = md.PrepareMunicipalitySecondaryStreetsMaintenanceDecisions(ddlMunic.SelectedValue, survey, user); } else { result &= md.PrepareMunicipalitySecondaryStreetsMaintenanceDecisions(ddlMunic.SelectedValue, user); } } } if (result) { lblFeedback.Text = "تم الحساب بنجاح"; DataTable dt = new DataTable(); if (radByRegionNo.Checked) { dt = md.GetRegionSecondaryStreetsMaintenanceDecisions(int.Parse(ddlRegions.SelectedValue), survey); } else if (radByRegionName.Checked) { dt = md.GetSubdistrictSecondaryStreetsMaintenanceDecisions(ddlRegionNames.SelectedValue, survey); } else if (radByRegionsAreaName.Checked) { dt = md.GetDistrictSecondaryStreetsMaintenanceDecisions(ddlDistrict.SelectedValue, survey); } else if (radByMunicName.Checked) { dt = md.GetMunicipalitySecondaryStreetsMaintenanceDecisions(ddlMunic.SelectedValue, survey); } ThreadResults.Add(RequestID, dt); } else { lblFeedback.Text = "فشلت عملية الحساب"; } } }
private void CalculateUDI() { int survey = int.Parse(ddlOldSurveys.SelectedValue); string user = Session["UserName"].ToString(); bool result = true; if (radByMainLanes.Checked) { int mainStID = int.Parse(ddlMainStreets.SelectedValue); SectionsUDI udi = new SectionsUDI(); if (ddlMainStreets.SelectedValue == "0") { DataTable dt = new MainStreet().GetMainStreetsHavingSurveyDistresses(); foreach (DataRow dr in dt.Rows) { if (survey != 0) result &= udi.CalculateMainStreetSectionsUDI(int.Parse(dr["STREET_ID"].ToString()), survey, user); // id3 else result &= udi.CalculateMainStreetSectionsUDI(int.Parse(dr["STREET_ID"].ToString()), user, false); } } else { if (survey != 0) result &= udi.CalculateMainStreetSectionsUDI(mainStID, survey, user); else result &= udi.CalculateMainStreetSectionsUDI(mainStID, user, false); } if (result) { lblFeedback.Text = "تم الحساب بنجاح"; DataTable dt = udi.GetSectionsUdiByMainStreet(mainStID, survey, true); ThreadResults.Add(RequestID, dt); } else lblFeedback.Text = "فشلت عملية الحساب"; } else if (radByIntersections.Checked) { int mainStID = int.Parse(ddlMainStreets.SelectedValue); IntersectionUDI udi = new IntersectionUDI(); if (ddlMainStreets.SelectedValue == "0") { DataTable dt = new MainStreet().GetMainStreetsHavingIntersectionsSurveyDistresses(); foreach (DataRow dr in dt.Rows) { if (survey != 0) result &= udi.CalculateMainStreetIntersectionsUDI(int.Parse(dr["STREET_ID"].ToString()), survey, user); else result &= udi.CalculateMainStreetIntersectionsUDI(int.Parse(dr["STREET_ID"].ToString()), user, false); } } else { if (survey != 0) result &= udi.CalculateMainStreetIntersectionsUDI(mainStID, survey, user); else result &= udi.CalculateMainStreetIntersectionsUDI(mainStID, user, false); } if (result) { lblFeedback.Text = "تم الحساب بنجاح"; DataTable dt = udi.GetMainStreetIntersectionUDI(mainStID, survey); ThreadResults.Add(RequestID, dt); } else lblFeedback.Text = "فشلت عملية الحساب"; } else { RegionSecondaryStUDI udi = new RegionSecondaryStUDI(); if (radByRegionNo.Checked) { if (ddlRegions.SelectedValue == "0") { DataTable dt = new Region().GetSurveyedRegions(); foreach (DataRow dr in dt.Rows) { if (survey != 0) result = udi.CalculateRegionSecondaryStreetsUDI(int.Parse(dr["REGION_ID"].ToString()), survey, user); else result &= udi.CalculateRegionSecondaryStreetsUDI(int.Parse(dr["REGION_ID"].ToString()), user, false); } } else { int regionID = int.Parse(ddlRegions.SelectedValue); if (survey != 0) result = udi.CalculateRegionSecondaryStreetsUDI(regionID, survey, user); else result &= udi.CalculateRegionSecondaryStreetsUDI(regionID, user, false); } } else if (radByRegionName.Checked) { if (ddlRegionNames.SelectedValue == "0") { throw new Exception("الرجاء اختيار الحي الفرعي"); //DataTable dt = new Region().GetSurveyedSubdistricts(); //foreach (DataRow dr in dt.Rows) //{ // if (survey != 0) // result = udi.CalculateRegionSecondaryStreetsUDI(dr["subdistrict"].ToString(), survey, user); // else // result &= udi.CalculateRegionSecondaryStreetsUDI(dr["subdistrict"].ToString(), user); //} } else { if (survey != 0) result = udi.CalculateRegionSecondaryStreetsUDI_BySubdistrict(ddlRegionNames.SelectedValue, survey, user); else result &= udi.CalculateRegionSecondaryStreetsUDI_BySubdistrict(ddlRegionNames.SelectedValue, user); } } else if (radByRegionsAreaName.Checked) { if (ddlDistrict.SelectedValue == "0") { throw new Exception("الرجاء اختيار الحي"); //DataTable dt = new Region().GetSurveyedDistricts(); //foreach (DataRow dr in dt.Rows) //{ // if (survey != 0) // result = udi.CalculateRegionSecondaryStreetsUDI_ByDistrict(dr["DIST_NAME"].ToString(), survey, user); // else // result &= udi.CalculateRegionSecondaryStreetsUDI_ByDistrict(dr["DIST_NAME"].ToString(), user); //} } else { if (survey != 0) result = udi.CalculateRegionSecondaryStreetsUDI_ByDistrict(ddlDistrict.SelectedValue, survey, user); else result &= udi.CalculateRegionSecondaryStreetsUDI_ByDistrict(ddlDistrict.SelectedValue, user); } } else if (radByMunicName.Checked) { if (ddlMunic.SelectedValue == "0") { throw new Exception("الرجاء اختيار البلدية الفرعية"); //DataTable dt = new Region().GetSurveyedMunicipalities(); //foreach (DataRow dr in dt.Rows) //{ // if (survey != 0) // result = udi.CalculateRegionSecondaryStreetsUDI_ByDistrict(dr["MUNIC_NAME"].ToString(), survey, user); // else // result &= udi.CalculateRegionSecondaryStreetsUDI_ByDistrict(dr["MUNIC_NAME"].ToString(), user); //} } else { if (survey != 0) result = udi.CalculateRegionSecondaryStreetsUDI_ByMunicipality(ddlMunic.SelectedValue, survey, user); else result &= udi.CalculateRegionSecondaryStreetsUDI_ByMunicipality(ddlMunic.SelectedValue, user); } } if (result) { lblFeedback.Text = "تم الحساب بنجاح"; DataTable dt = new DataTable(); if (radByRegionNo.Checked) dt = udi.GetSecondaryStreetsUdiByRegion(int.Parse(ddlRegions.SelectedValue), survey); else if (radByRegionName.Checked) dt = udi.GetSecondaryStreetsUdiByRegion(ddlRegionNames.SelectedValue, survey); else if (radByRegionsAreaName.Checked) dt = udi.GetSecondaryStreetsUdiByDistrict(ddlDistrict.SelectedValue, survey); else if (radByMunicName.Checked) dt = udi.GetSecondaryStreetsUdiByMuniciplaity(ddlMunic.SelectedValue, survey); ThreadResults.Add(RequestID, dt); } else lblFeedback.Text = "فشلت عملية الحساب"; } }