protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
// ChkMidIsland.Checked, ChkSideIsland.Checked, ChkSideWalk.Checked, radIslandConside.Checked, txtSectionNo.Text,
DataTable dt = new MainStreetSection().AdvancedSearch(int.Parse(ddlMainStreets.SelectedValue), txtSectionTitle.Text, ddlDirection.SelectedValue,
!radSideCurbBoth.Checked, radHasSideCurb.Checked, radTreesConsider.Checked, ChkAg_MID.Checked, ChkAg_SID.Checked, ChkAg_SEC.Checked, radUsesConsider.Checked,
ChkHousing.Checked, ChkCommercial.Checked, ChkPublics.Checked, ChkIndisterial.Checked, ChkGarden.Checked, ChkRest_House.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, chkDrillingSewage.Checked, !radSoilBoth.Checked, radSoilExists.Checked,
!radLightBoth.Checked, radLightingExists.Checked, !radBridgesBoth.Checked, radBridgesExists.Checked, !radTunnelBoth.Checked, radTunnelExists.Checked,
!radR4Both.Checked, radR4Is.Checked, !radR3Both.Checked, radIsR3.Checked, rdtpFrom.SelectedDate, rdtpTo.SelectedDate, rdtpR3From.SelectedDate, rdtpR3To.SelectedDate,
!radPedestBridgeBoth.Checked, radPedestBridgeExists.Checked, !radSurveyedBoth.Checked, radSurveyed.Checked, !radMidIslandBoth.Checked, radHasMidIsland.Checked,
!radSideIslandBoth.Checked, radHasSideIsland.Checked, ddlRegions.SelectedValue);
if (dt.Rows.Count > 0)
{
// prepare to show Intersections Info report
Session.Add("ReportData", dt);
string url = "ViewSectionInfoReport.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 ddlSections_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
ddlLanes.Items.Clear();
ddlLanes.Items.Add(new ListItem("اختيار", "0"));
ddlLanes.DataBind();
lblSectionAreaSum.Text = MainStreetSection.GetSectionSampleAreaSum(int.Parse(ddlSections.SelectedValue)).ToString("N2");
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void ddlMainStreetSection_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
int id = int.Parse(ddlMainStreetSection.SelectedValue);
if (id != 0)
{
string sDate = new MainStreetSection().GetSectionNoPermitTillDate(id);
if (string.IsNullOrEmpty(sDate))
{
lblPermits.Text = "يمكن إصدار رخصة حفريات";
lblPermits.ForeColor = System.Drawing.Color.Green;
}
else
{
DateTime stopTill = DateTime.Parse(sDate);
if (stopTill >= DateTime.Today)
{
lblPermits.Text = "إصدار رخص الحفريات موقوف حتى تاريخ: " + sDate;
lblPermits.ForeColor = System.Drawing.Color.Red;
}
else
{
lblPermits.Text = "يمكن إصدار رخصة حفريات";
lblPermits.ForeColor = System.Drawing.Color.Green;
}
}
}
else
{
lblPermits.Text = "";
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lblError.Text = "";
if (string.IsNullOrEmpty(Session["MainStreetID"].ToString()))
{
throw new Exception("الرجاء اختيار الطريق الرئيسي أولا قبل البحث عن مقطع");
}
DataTable dt = new MainStreetSection().Search(txtNumSearch.Text, radByNumber.Checked, int.Parse(Session["MainStreetID"].ToString()));
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 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 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 btnSave_Click(object sender, EventArgs e)
{
try
{
if (!bool.Parse(Session["canEdit"].ToString()))
{
throw new Exception(Feedback.NoPermissions());
}
if (updDistressImage.HasFile)
{
int sectionID = int.Parse(Request.QueryString["sectionID"]);
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 sectionTitle = "";
DataTable dt = new MainStreetSection().GetSectionInfo(sectionID);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
sectionTitle = string.Format("{0} - {1} ", dr["SECTION_NO"].ToString(), dr["MAIN_NAME"].ToString());
string datetimePart = DateTime.Now.ToString("ddMMyyyyHHmm");
string imageFileName = string.Format("{0}_{1}", datetimePart, Path.GetFileName(updDistressImage.FileName));
string newFileNameThumb = string.Format("{0}_{2}_{1}", datetimePart, Path.GetFileName(updDistressImage.FileName), dr["SECTION_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, sectionTitle + ' ' + strDatetime);
resizedImage.Dispose();
}
//ImagesClass.ResizeImage(fi, resizedImage, imageFormat, 1600, 1200);
fi.Close();
}
File.Delete(Server.MapPath("~/Uploads/") + imageFileName);
bool saved = new ImagesGallery().AddImage(sectionID, newFileNameThumb, txtImageDetails.Text, RoadType.Section);
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 = "";
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;
}
}
