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 CalculateUdiRegionsALL()
{
DataTable dt;
bool result = true;
RegionSecondaryStUDI udiRegions = new RegionSecondaryStUDI();
string user = Session["UserName"].ToString();
dt = new SystemUsers().GetReceivedReports();
foreach (DataRow dr in dt.Rows)
{
result &= udiRegions.CalculateRegionSecondaryStreetsUDI(int.Parse(dr["ID"].ToString()), user, true);
}
dt = new DataTable();
ThreadResults.Add(RequestID, dt);
}
protected void SpecificDate()
{
if (raddtpFrom.SelectedDate == null)
{
throw new Exception(Feedback.NoSearchBeginDate());
}
else if (raddtpTo.SelectedDate == null)
{
throw new Exception(Feedback.NoSearchEndDate());
}
else if (raddtpFrom.SelectedDate > raddtpTo.SelectedDate)
{
throw new Exception(Feedback.SearchBeginDateAfterEndDate());
}
DataTable dt = new RegionSecondaryStUDI().GetDataBySpecificDate(raddtpFrom.SelectedDate, raddtpTo.SelectedDate.Value.AddDays(1));
//if (dt.Rows.Count > 0)
//{
// Session.Add("option", "radByRegionDistress");
// Session.Add("ReportData", dt);
// string url = "ViewPavementEvalRegionsReport.aspx";
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
//}
//else
// lblFeedback.Text = Feedback.NoData();
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionName");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
if (radByRegion.Checked)
{
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyDateNum()); int.Parse(radlOldSurveys.SelectedValue)
int secondID = (string.IsNullOrEmpty(ddlRegionSecondaryStreets.SelectedValue) || ddlRegionSecondaryStreets.SelectedValue == "0") ? 0 : int.Parse(ddlRegionSecondaryStreets.SelectedValue);
if (chkWithDistresses.Checked)
{
DataTable dt = new RegionSecondaryStUDI().GetRegionUdiReport(int.Parse(ddlRegions.SelectedValue), true, radAllDists.Checked, secondID);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionDistress");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else
{ // RegionsUDI int.Parse(radlOldSurveys.SelectedValue),
DataTable dt = new RegionSecondaryStUDI().GetRegionUdiReport(int.Parse(ddlRegions.SelectedValue), false, radAllDists.Checked, secondID);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegion");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
}
else if (radByRegionTotal.Checked)
{
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyNum()); int.Parse(radlOldSurveys.SelectedValue),
DataTable dt = new RegionSecondaryStUDI().GetRegionTotalUdiReport(int.Parse(ddlRegions.SelectedValue), radAllDists.Checked);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionTotal");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionNameTotal.Checked)
{
if (ddlRegionNames.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegionNames.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyNum()); int.Parse(radlOldSurveys.SelectedValue), RegionSecondaryStUDI.
DataTable dt = new RegionSecondaryStUDI().GetRegionTotalUdiReport(ddlRegionNames.SelectedValue, radAllDists.Checked, RegionReportLevel.Subdistrict);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionTotal");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionsAreaNameTotal.Checked)
{
if (ddlDistrict.SelectedValue == "0" || string.IsNullOrEmpty(ddlDistrict.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyNum()); int.Parse(radlOldSurveys.SelectedValue),
DataTable dt = new RegionSecondaryStUDI().GetRegionTotalUdiReport(ddlDistrict.SelectedValue, radAllDists.Checked, RegionReportLevel.District);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionTotal");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radbyMunicTotal.Checked)
{
if (ddlMunic.SelectedValue == "0" || string.IsNullOrEmpty(ddlMunic.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyNum()); int.Parse(radlOldSurveys.SelectedValue),
DataTable dt = new RegionSecondaryStUDI().GetRegionTotalUdiReport(ddlMunic.SelectedValue, radAllDists.Checked, RegionReportLevel.Municipality);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionTotal");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionName.Checked)
{
if (ddlRegionNames.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegionNames.SelectedValue))
{
throw new Exception(Feedback.NoRegionNameSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyDateNum());
DataTable dt = new RegionSecondaryStUDI().getRegionTotalUdiReportBy(ddlRegionNames.SelectedValue, radAllDists.Checked, RegionReportLevel.Subdistrict);
//getRegionTotalUdiReportBySubdistrict(ddlRegionNames.SelectedValue, int.Parse(radlOldSurveys.SelectedValue), radAllDists.Checked);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionName");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionsAreaName.Checked)
{
if (ddlDistrict.SelectedValue == "0" || string.IsNullOrEmpty(ddlDistrict.SelectedValue))
{
throw new Exception(Feedback.NoRegionsAreaNameSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyDateNum());
//DataTable dt = new RegionSecondaryStUDI().getRegionTotalUdiReportByDistrict(ddlDistrict.SelectedValue, int.Parse(radlOldSurveys.SelectedValue), radAllDists.Checked);
DataTable dt = new RegionSecondaryStUDI().getRegionTotalUdiReportBy(ddlDistrict.SelectedValue, radAllDists.Checked, RegionReportLevel.District);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionsAreaName");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radbyMunicName.Checked)
{
if (ddlMunic.SelectedValue == "0" || string.IsNullOrEmpty(ddlMunic.SelectedValue))
{
throw new Exception("الرجاء اختيار البلدية الفرعية");
}
//DataTable dt = new RegionSecondaryStUDI().GetMunicUdiReport(ddlMunic.SelectedValue, int.Parse(radlOldSurveys.SelectedValue), radAllDists.Checked);
DataTable dt = new RegionSecondaryStUDI().getRegionTotalUdiReportBy(ddlMunic.SelectedValue, radAllDists.Checked, RegionReportLevel.Municipality);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radbyMunicName");
Session.Add("ReportData", dt);
string url = "ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
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 = "فشلت عملية الحساب";
}
}
