protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
DataTable dt = new SecondaryStreets().AdvancedSearch(ddlMunic.SelectedValue, int.Parse(ddlRegions.SelectedValue), txtStNo.Text, txtStName.Text, radUsesConsider.Checked,
ChkHousing.Checked, ChkCommercial.Checked, ChkPublics.Checked, ChkIndisterial.Checked, ChkGarden.Checked, ChkRest_House.Checked, chkNewlyBuilt.Checked,
chkSchools.Checked, chkMasjid.Checked, chkSport.Checked, chkHospital.Checked, chkOtherUtils.Checked, radHolesConsider.Checked, ChkDrinage_CBs.Checked,
ChkDrinage_MH.Checked, ChkSTC_MH.Checked, ChkElect_MH.Checked, ChkWater_MH.Checked, ChkSewage_MH.Checked, radDrillingsConsider.Checked, chkDrillingSTC.Checked,
chkDrillingElec.Checked, chkDrillingWater.Checked, ChkSewage_MH.Checked, !radSoilBoth.Checked, radSoilExists.Checked, !radLightBoth.Checked, radLightingExists.Checked,
!radConcreteBlocksBoth.Checked, radConcreteBlocksExists.Checked, !radBumpsBoth.Checked, radBumpsExists.Checked, !radSurveyedBoth.Checked, radSurveyed.Checked);
if (dt.Rows.Count > 0)
{
// prepare to show report
Session.Add("ReportData", dt);
string url = "ViewSecondaryStInfoReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void UpdateButton_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
lblFeedbackInsert.Text = "";
if (!bool.Parse(Session["canEdit"].ToString()))
{
throw new Exception(Feedback.NoPermissions());
}
if (!DataAreValid())
{
return;
}
if (new Region().CheckRegionSurveyorNotSaved(int.Parse(ddlRegions.SelectedValue)))
{
lblFeedback.Text = "الرجاء تسجيل بيانات المسح أولا ومن ثم حفظ البيانات الوصفية";
gvSurveyorJob.DataBind();
pnlSurveyor.Visible = true;
pnlSecondarySt.Visible = false;
}
bool saved = new SecondaryStreets().Update(txtSecondStArName.Text, rntxtLength.Text, rntxtWidth.Text, rntxtUnpavedLength.Text, ChkLight.Checked, txtLightLocation.Text,
ChkHousing.Checked, ChkCommercial.Checked, ChkPublics.Checked, ChkGarden.Checked, ChkIndisterial.Checked, ChkRest_House.Checked, chkNewlyBuilt.Checked,
chkSchools.Checked, chkHospital.Checked, chkMasjid.Checked, chkSport.Checked, chkOtherUtils.Checked, txtOtherDetails.Text, ChkDrinage_MH.Checked,
rntxtDrinage_MH_Good.Text, ChkDrinage_CBs.Checked, rntxtDrinage_CBGood.Text, ChkSewage_MH.Checked, rntxtSewage_MH_Good.Text, ChkElect_MH.Checked,
rnTxtElect_MH_Good.Text, ChkSTC_MH.Checked, rntxtSTC_MH_Good.Text, ChkWater_MH.Checked, rnTxtWater_MH_Good.Text, chkSpeedBumps.Checked, chkLegal.Checked,
chkIllegal.Checked, rntxtSpeedBumpsCount.Text, int.Parse(ddlRegionSecondaryStreets.SelectedValue), Session["UserName"].ToString(), chkConcreteBlocks.Checked,
rntxtConcreteBlocks.Text, chkDrillingSTC.Checked, chkDrillingElec.Checked, chkDrillingWater.Checked, chkDrillingSewage.Checked, rntxtDrillingSTC.Text,
rntxtDrillingElec.Text, rntxtDrillingWater.Text, rntxtDrillingSewage.Text, rntxtDrinage_CBFair.Text, rntxtDrinage_CBPoor.Text, rntxtDrinage_MH_Fair.Text,
rntxtDrinage_MH_Poor.Text, rnTxtElect_MH_Fair.Text, rnTxtElect_MH_Poor.Text, rntxtSTC_MH_Fair.Text, rntxtSTC_MH_Poor.Text, rntxtSewage_MH_Fair.Text,
rntxtSewage_MH_Poor.Text, rnTxtWater_MH_Fair.Text, rnTxtWater_MH_Poor.Text, chkMidGood.Checked, chkMidFair.Checked, chkMidPoor.Checked, chkSideGood.Checked,
chkSideFair.Checked, chkSidePoor.Checked, int.Parse(ddlSpeedBumpType.SelectedValue), rntxtLightGood.Text, rntxtLightFair.Text, rntxtLightPoor.Text, txtNotes.Text,
ChkMidIsland.Checked, ChkSideWalk.Checked, rdtpSurveyDate.SelectedDate);
//rntxtLightCount.Text,
lblFeedback.Text = saved ? Feedback.UpdateSuccessfull() : Feedback.UpdateException();
lblFeedbackInsert.Text = lblFeedback.Text;
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
lblFeedbackInsert.Text = lblFeedback.Text;
}
}
protected void gvRegionSamples_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (gvRegionSamples.SelectedValue != null)
{
lblFeedback.Text = "";
lblDistressFeedback.Text = "";
pnlSurvey.Visible = true;
pnlDistressDetails.Visible = false;
bool sampleHasSurveys = new DistressSurvey().SecondaryStreetSampleHasSurveys(int.Parse(gvRegionSamples.SelectedValue.ToString()));
bool sampleAreaReady = SecondaryStreets.SecondaryStreetSampleReadyForDistressEntry(int.Parse(gvRegionSamples.SelectedValue.ToString()));
if (sampleAreaReady)
{
if (sampleHasSurveys)
{
radNewSurvey.Checked = false;
radOldSurvey.Checked = true;
radOldSurvey_CheckedChanged(sender, e);
}
else
{
radOldSurvey.Checked = false;
radNewSurvey.Checked = true;
radNewSurvey_CheckedChanged(sender, e);
}
}
else
{
pnlSurvey.Visible = false;
lblFeedback.Text = Feedback.NonReadySample(); // "العينة غير جاهزة لعدم حساب المساحة، لايمكن إدخال العيوب عليها";
}
}
else
{
pnlSurvey.Visible = false;
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
lblFeedback.Text = Feedback.NoRegionSelected();
}
else
{
DataTable dt = new SecondaryStreets().GetRegionSecondaryStreetsTable(int.Parse(ddlRegions.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "SecondaryStreetsTable");
Session.Add("ReportData", dt);
string url = "../reports/ViewPavementEvalRegionsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!bool.Parse(Session["canEdit"].ToString()))
{
throw new Exception(Feedback.NoPermissions());
}
if (updDistressImage.HasFile)
{
int secondStID = int.Parse(Request.QueryString["SecondStID"]);
ImageFormat imageFormat = new ImageFormat(new Guid());
FileInfo file = new FileInfo(updDistressImage.FileName);
if (file.Extension.ToLower() == ".jpg" || file.Extension.ToLower() == ".jpeg")
{
imageFormat = System.Drawing.Imaging.ImageFormat.Jpeg;
}
else if (file.Extension.ToLower() == ".gif")
{
imageFormat = System.Drawing.Imaging.ImageFormat.Gif;
}
else if (file.Extension.ToLower() == ".png")
{
imageFormat = System.Drawing.Imaging.ImageFormat.Png;
}
string secStTitle = "";
DataTable dt = new SecondaryStreets().GetSecondaryStreetInfo(secondStID);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
secStTitle = string.Format("{0} - {1} - {2} ", dr["REGION_NO"].ToString(), dr["SUBDISTRICT"].ToString(), dr["SECOND_ST_NO"].ToString());
string datetimePart = DateTime.Now.ToString("ddMMyyyyHHmm");
string imageFileName = string.Format("{0}_{1}", datetimePart, Path.GetFileName(updDistressImage.FileName));
string newFileNameThumb = string.Format("{0}_{2}{3}_{1}", datetimePart, Path.GetFileName(updDistressImage.FileName), dr["REGION_NO"].ToString(), dr["SECOND_ST_NO"].ToString());
string fullImagePath = Server.MapPath("~/Uploads/") + imageFileName;
updDistressImage.SaveAs(fullImagePath);
using (FileStream fi = File.OpenRead(Server.MapPath("~/Uploads/") + imageFileName))
{
using (FileStream resizedImage = File.Create(Server.MapPath("~/Uploads/") + newFileNameThumb))
{
string strDatetime = File.GetCreationTime(Server.MapPath("~/Uploads/") + newFileNameThumb).ToString("dd/MM/yyyy HH:mm");
ImagesClass.ResizeImagePutWatermark(fi, resizedImage, imageFormat, 1600, 1200, true, secStTitle + ' ' + strDatetime);
resizedImage.Dispose();
}
//ImagesClass.ResizeImage(fi, resizedImage, imageFormat, 1600, 1200);
fi.Close();
}
File.Delete(Server.MapPath("~/Uploads/") + imageFileName);
bool saved = new ImagesGallery().AddImage(secondStID, newFileNameThumb, txtImageDetails.Text, RoadType.RegionSecondarySt);
if (saved)
{
txtImageDetails.Text = "";
lblOperation.Text = Feedback.UpdateSuccessfull();
//gvImages.DataBind();
lvwImages.DataBind();
}
else
{
lblOperation.Text = Feedback.UpdateException();
}
}
else
{
throw new Exception("الرجاء اختيار ملف الصورة");
}
}
else
{
throw new Exception("الرجاء اختيار المنطقة الفرعية");
}
}
catch (Exception ex)
{
lblOperation.Text = ex.Message;
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
string formType = radDetailsForm.Checked ? "Details" : (radSurveyForm.Checked ? "Survey" : "Map");
DataTable dt = new DataTable();
if ((radSection.Checked || radIntersects.Checked) && (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue)))
{
throw new Exception(Feedback.NoMainStreetSelected());
}
else if (radRegions.Checked && (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue)))
{
throw new Exception(Feedback.NoRegionSelected());
}
if (radSection.Checked)
{
if (radSurveyForm.Checked)
{
dt = new LaneSample().AdvancedSearch(int.Parse(ddlMainStreets.SelectedValue));
}
else if (radDetailsForm.Checked)
{
dt = new MainStreetSection().GetMainStSectionsFullInfo(int.Parse(ddlMainStreets.SelectedValue));
}
else if (radSectionMap.Checked)
{
dt = new MainStreetSection().GetMainStreetSections(int.Parse(ddlMainStreets.SelectedValue));
}
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radSection");
Session.Add("type", formType);
string url = "ViewSurveyingFormsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radIntersects.Checked)
{
if (radSurveyForm.Checked)
{
dt = new IntersectionSamples().GetIntersectionSamplesByMainStreet(int.Parse(ddlMainStreets.SelectedValue));
}
else if (radDetailsForm.Checked)
{
dt = new Intersection().GetMainStIntersectionsFullInfo(int.Parse(ddlMainStreets.SelectedValue));
}
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radIntersects");
Session.Add("type", formType);
string url = "ViewSurveyingFormsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radRegions.Checked)
{
dt = new SecondaryStreets().GetRegionSecondaryStreetsFullInfoNEW(int.Parse(ddlRegions.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radRegions");
Session.Add("type", formType);
string url = "ViewSurveyingFormsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void ddlRegionSecondaryStreets_SelectedIndexChanged(object sender, EventArgs e)
{
lblFeedback.Text = "";
lblFeedbackInsert.Text = "";
try
{
if (ddlRegions.SelectedValue != "0" && new Region().CheckRegionSurveyorNotSaved(int.Parse(ddlRegions.SelectedValue)))
{
lblFeedback.Text = "الرجاء تسجيل بيانات المسح أولا ومن ثم حفظ البيانات الوصفية";
gvSurveyorJob.DataBind();
pnlSurveyor.Visible = true;
pnlSecondarySt.Visible = false;
}
else
{
int id = int.Parse(ddlRegionSecondaryStreets.SelectedValue);
if (id != 0)
{
pnlSurveyor.Visible = false;
pnlSecondarySt.Visible = false;
DataTable dt = new SecondaryStreets().GetSecondaryStreetInfo(id);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lnkGallery.NavigateUrl = string.Format("SecondStImages.aspx?SecondStID={0}", id);
txtSecondStArName.Text = dr["SECOND_AR_NAME"].ToString();
txtSecondStNo.Text = dr["SECOND_ST_NO"].ToString();
rntxtLength.Text = dr["SECOND_ST_LENGTH"].ToString();
rntxtWidth.Text = dr["SECOND_ST_WIDTH"].ToString();
rntxtSectionWidth_TextChanged(sender, e);
rntxtUnpavedLength.Text = dr["DIRT_LENGTH"].ToString();
ChkLight.Checked = bool.Parse(dr["LIGHTING_TRUE"].ToString());
ChkLight_CheckedChanged(sender, e);
txtLightLocation.Text = dr["LIGHTING_LOC"].ToString();
rntxtLightGood.Text = dr["LIGHT_GOOD_COUNT"].ToString();
rntxtLightFair.Text = dr["LIGHT_FAIR_COUNT"].ToString();
rntxtLightPoor.Text = dr["LIGHT_POOR_COUNT"].ToString();
//rntxtLightCount.Text = dr["LIGHT_COUNT"].ToString();
ChkHousing.Checked = bool.Parse(dr["houses"].ToString());
ChkCommercial.Checked = bool.Parse(dr["Commerial"].ToString());
ChkPublics.Checked = bool.Parse(dr["publics"].ToString());
ChkGarden.Checked = bool.Parse(dr["gardens"].ToString());
ChkRest_House.Checked = bool.Parse(dr["rest_house"].ToString());
ChkIndisterial.Checked = bool.Parse(dr["indisterial"].ToString());
chkNewlyBuilt.Checked = bool.Parse(dr["NEW_BUILDINGS"].ToString());
chkSchools.Checked = bool.Parse(dr["SCHOOL"].ToString());
chkMasjid.Checked = bool.Parse(dr["MASJID"].ToString());
chkSport.Checked = bool.Parse(dr["SPORT_CLUB"].ToString());
chkHospital.Checked = bool.Parse(dr["HOSPITAL"].ToString());
chkOtherUtils.Checked = bool.Parse(dr["OTHER_UTIL"].ToString());
chkOtherUtils_CheckedChanged(sender, e);
ChkDrinage_CBs.Checked = bool.Parse(dr["drinage_cb_True"].ToString());
ChkDrinage_CBs_CheckedChanged(sender, e);
ChkDrinage_MH.Checked = bool.Parse(dr["drinage_mh_True"].ToString());
ChkDrinage_MH_CheckedChanged(sender, e);
ChkSewage_MH.Checked = bool.Parse(dr["Sewage_mh_True"].ToString());
ChkSewage_MH_CheckedChanged(sender, e);
ChkElect_MH.Checked = bool.Parse(dr["elect_mh_True"].ToString());
ChkElect_MH_CheckedChanged(sender, e);
ChkSTC_MH.Checked = bool.Parse(dr["stc_mh_True"].ToString());
ChkSTC_MH_CheckedChanged(sender, e);
ChkWater_MH.Checked = bool.Parse(dr["water_valve_True"].ToString());
ChkWater_MH_CheckedChanged(sender, e);
//rntxtDrinage_CBCount.Text = dr["drinage_cb_Count"].ToString();
//rntxtDrinage_MHCount.Text = dr["drinage_mh_Count"].ToString();
//rntxtSewage_MHCount.Text = dr["Sewage_mh_Count"].ToString();
//rnTxtElect_MHCount.Text = dr["Elect_mh_Count"].ToString();
//rntxtSTC_MHCount.Text = dr["stc_mh_Count"].ToString();
//rnTxtWater_MHCount.Text = dr["water_valve_Count"].ToString();
rntxtDrinage_CBGood.Text = dr["drinage_cb_Count"].ToString();
rntxtDrinage_CBFair.Text = dr["DRAIN_CB_FAIR"].ToString();
rntxtDrinage_CBPoor.Text = dr["DRAIN_CB_POOR"].ToString();
rntxtDrinage_MH_Good.Text = dr["drinage_mh_Count"].ToString();
rntxtDrinage_MH_Fair.Text = dr["DRAIN_CB_FAIR"].ToString();
rntxtDrinage_MH_Poor.Text = dr["DRAIN_MH_POOR"].ToString();
rntxtSewage_MH_Good.Text = dr["Sewage_mh_Count"].ToString();
rntxtSewage_MH_Fair.Text = dr["SEWAGE_MH_FAIR"].ToString();
rntxtSewage_MH_Poor.Text = dr["SEWAGE_MH_POOR"].ToString();
rnTxtElect_MH_Good.Text = dr["Elect_mh_Count"].ToString();
rnTxtElect_MH_Fair.Text = dr["ELEC_MH_FAIR"].ToString();
rnTxtElect_MH_Poor.Text = dr["ELEC_MH_POOR"].ToString();
rntxtSTC_MH_Good.Text = dr["stc_mh_Count"].ToString();
rntxtSTC_MH_Fair.Text = dr["STC_MH_FAIR"].ToString();
rntxtSTC_MH_Poor.Text = dr["STC_MH_POOR"].ToString();
rnTxtWater_MH_Good.Text = dr["water_valve_Count"].ToString();
rnTxtWater_MH_Fair.Text = dr["WATER_MH_FAIR"].ToString();
rnTxtWater_MH_Poor.Text = dr["WATER_MH_POOR"].ToString();
ChkMidIsland.Checked = bool.Parse(dr["mid_island_True"].ToString());
ChkMidIsland_CheckedChanged(sender, e);
chkMidGood.Checked = bool.Parse(dr["MID_ISLAND_GOOD"].ToString());
chkMidFair.Checked = bool.Parse(dr["MID_ISLAND_FAIR"].ToString());
chkMidPoor.Checked = bool.Parse(dr["MID_ISLAND_POOR"].ToString());
ChkSideWalk.Checked = bool.Parse(dr["side_Curb_True"].ToString());
ChkSideWalk_CheckedChanged(sender, e);
chkSideGood.Checked = bool.Parse(dr["SIDE_CURB_GOOD"].ToString());
chkSideFair.Checked = bool.Parse(dr["SIDE_CURB_FAIR"].ToString());
chkSidePoor.Checked = bool.Parse(dr["SIDE_CURB_POOR"].ToString());
chkSpeedBumps.Checked = bool.Parse(dr["SPEED_BUMPS_TRUE"].ToString());
chkSpeedBumps_CheckedChanged(sender, e);
chkLegal.Checked = bool.Parse(dr["SPEED_BUMPS_LEGAL"].ToString());
chkIllegal.Checked = bool.Parse(dr["SPEED_BUMPS_ILLEGAL"].ToString());
rntxtSpeedBumpsCount.Text = dr["SPEED_BUMPS_COUNT"].ToString();
ddlSpeedBumpType.Items.Clear();
ddlSpeedBumpType.Items.Add(new ListItem("اختيار", "0"));
ddlSpeedBumpType.DataBind();
ddlSpeedBumpType.SelectedValue = dr["SPEED_BUMP_TYPE_ID"].ToString();
chkConcreteBlocks.Checked = bool.Parse(dr["CONCRETE_BLOCKS"].ToString());
chkConcreteBlocks_CheckedChanged(sender, e);
rntxtConcreteBlocks.Text = dr["CONCRETE_BLOCKS_COUNT"].ToString();
chkDrillingElec.Checked = bool.Parse(dr["DRILLINGS_ELEC"].ToString());
chkDrillingElec_CheckedChanged(sender, e);
rntxtDrillingElec.Text = dr["DRILLINGS_ELEC_LENGTH"].ToString();
chkDrillingSewage.Checked = bool.Parse(dr["DRILLINGS_SEWAGE"].ToString());
chkDrillingSewage_CheckedChanged(sender, e);
rntxtDrillingSewage.Text = dr["DRILLINGS_SEWAG_LENGTH"].ToString();
chkDrillingSTC.Checked = bool.Parse(dr["DRILLINGS_STC"].ToString());
chkDrillingSTC_CheckedChanged(sender, e);
rntxtDrillingSTC.Text = dr["DRILLINGS_STC_LENGTH"].ToString();
chkDrillingWater.Checked = bool.Parse(dr["DRILLINGS_WATER"].ToString());
chkDrillingWater_CheckedChanged(sender, e);
rntxtDrillingWater.Text = dr["DRILLINGS_WATER_LENGTH"].ToString();
txtNotes.Text = dr["NOTES"].ToString();
if (string.IsNullOrEmpty(dr["SURVEY_DATE"].ToString()))
{
rdtpSurveyDate.SelectedDate = null;
}
else
{
rdtpSurveyDate.SelectedDate = DateTime.Parse(dr["SURVEY_DATE"].ToString());
}
pnlSecondarySt.Visible = true;
pnlSurveyor.Visible = false;
BoldUnBoldLinks(1);
}
else
{
lblFeedback.Text = Feedback.NoData();
pnlSecondarySt.Visible = false;
pnlSurveyor.Visible = false;
}
}
else
{
pnlSecondarySt.Visible = false;
pnlSurveyor.Visible = false;
}
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
if (radByMainLanes.Checked)
{
if (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))
{
throw new Exception(Feedback.NoMainStreetSelected());
}
DataTable dt = new MainStreetSection().GetAllSectionsReport(false, false, true, int.Parse(ddlMainStreets.SelectedValue), false, 0);
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByMainLanes");
string url = "ViewMonitoringRoundsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByIntersections.Checked)
{
if (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))
{
throw new Exception(Feedback.NoMainStreetSelected());
}
DataTable dt = new IntersectionSamples().GetIntersectionSamplesByMainStreet(int.Parse(ddlMainStreets.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByIntersections");
string url = "ViewMonitoringRoundsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionNo.Checked)
{
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
DataTable dt = new SecondaryStreets().Search(int.Parse(ddlRegions.SelectedValue), "", "", "");
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByRegionNo");
string url = "ViewMonitoringRoundsReport.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());
}
DataTable dt = new SecondaryStreets().Search(0, ddlRegionNames.SelectedValue, "", "");
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByRegionName");
string url = "ViewMonitoringRoundsReport.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());
}
DataTable dt = new SecondaryStreets().Search(0, "", ddlDistrict.SelectedValue, "");
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByRegionsAreaName");
string url = "ViewMonitoringRoundsReport.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(Feedback.NoMuniciplaitySelected());
}
DataTable dt = new SecondaryStreets().Search(0, "", "", ddlMunic.SelectedValue);
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByMunicName");
string url = "ViewMonitoringRoundsReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void btnShow_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
if (radAllSectionsOrderBySectionNo.Checked || radAllSectionsOrderByStreet.Checked || radSectionsbyStreet.Checked || radSectionsSurroundingRegion.Checked)
{
DataTable dt = new MainStreetSection().GetAllSectionsReport(radAllSectionsOrderBySectionNo.Checked, radAllSectionsOrderByStreet.Checked,
radSectionsbyStreet.Checked, int.Parse(ddlMainStreets.SelectedValue), radSectionsSurroundingRegion.Checked, int.Parse(ddlRegionSurrounding.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("type", "section");
Session.Add("ReportData", dt);
string url = "ViewNetworkInfoReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radAllIntersectionsOrderBySectionNo.Checked || radAllIntersectionsOrderByStreet.Checked || radMainstIntersects.Checked)
{
DataTable dt = new Intersection().PrepareIntersectionsInfoReport(radAllIntersectionsOrderBySectionNo.Checked, int.Parse(ddlMainStreets.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("type", "intersect");
Session.Add("ReportData", dt);
string url = "ViewNetworkInfoReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radAllOrderByDistrict.Checked || radAllOrderByRegion.Checked || radByRegionDistMunic.Checked)
{
DataTable dt = new SecondaryStreets().PrepareRegionSecondaryStreetsInfoReport(radAllOrderByRegion.Checked, radByRegionDistMunic.Checked, ddlRegionWise.SelectedValue,
radRegion.Checked, radSubdist.Checked, radDist.Checked, radMunic.Checked);
if (dt.Rows.Count > 0)
{
Session.Add("Type", ((radAllOrderByRegion.Checked) ? "Region" : "District"));
Session.Add("ReportData", dt);
string url = "ViewNetworkInfoReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
if (radByMainLanes.Checked || radByIntersections.Checked)
{
DataTable dt = new MainStreetSection().GetStatsReport(int.Parse(ddlMainStreets.SelectedValue), radByIntersections.Checked, int.Parse(ddlMainStreetSection.SelectedValue),
int.Parse(ddlMainStreetIntersection.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", (radByIntersections.Checked ? "radByIntersections" : "radByMainLanes"));
Session.Add("type", (radByIntersections.Checked ? "marks" :
(radLenWid.Checked ? "widths" : (radServiceMarks.Checked ? "marks" : (radLandMarks.Checked ? "landMarks" : "")))));
string url = "ViewRoadPartsCountReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionNo.Checked)
{
if (ddlRegions.SelectedValue == "0")
{
throw new Exception(Feedback.NoRegionSelected());
}
DataTable dt = new SecondaryStreets().GetStatsReport(int.Parse(ddlRegions.SelectedValue), "", "", "");
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByRegionNo");
Session.Add("type", "widths");
string url = "ViewRoadPartsCountReport.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")
{
throw new Exception(Feedback.NoRegionNameSelected());
}
DataTable dt = new SecondaryStreets().GetStatsReport(0, ddlRegionNames.SelectedValue, "", "");
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByRegionName");
Session.Add("type", "widths");
string url = "ViewRoadPartsCountReport.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")
{
throw new Exception(Feedback.NoRegionsAreaNameSelected());
}
DataTable dt = new SecondaryStreets().GetStatsReport(0, "", ddlDistrict.SelectedValue, "");
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByRegionsAreaName");
Session.Add("type", "widths");
string url = "ViewRoadPartsCountReport.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")
{
throw new Exception(Feedback.NoMuniciplaitySelected());
}
DataTable dt = new SecondaryStreets().GetStatsReport(0, "", "", ddlMunic.SelectedValue);
if (dt.Rows.Count > 0)
{
Session.Add("ReportData", dt);
Session.Add("option", "radByMunicName");
Session.Add("type", "widths");
string url = "ViewRoadPartsCountReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
