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 = "فشلت عملية الحساب";
}
}
