protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string imageFileName = "";
lblOperation.Text = "";
if (!bool.Parse(Session["canEdit"].ToString()))
{
throw new Exception(Feedback.NoPermissions());
}
if (updDistressImage.HasFile)
{
string datetimePart = DateTime.Now.ToString("ddMMyyyyHHmm");
imageFileName = string.Format("{0}_{1}", datetimePart, Path.GetFileName(updDistressImage.FileName));
string strPath = MapPath("~/Uploads/") + imageFileName;
updDistressImage.SaveAs(strPath);
bool saved = new DistressEntry().EditDistressImage(imageFileName, int.Parse(Request.QueryString["DistID"]));
if (saved)
{
lblOperation.Text = Feedback.UpdateSuccessfull();
imgPhoto.ImageUrl = "~/Uploads/" + imageFileName;
}
else
{
lblOperation.Text = Feedback.UpdateException();
}
}
}
catch (Exception ex)
{
lblOperation.Text = ex.Message;
}
}
protected void btnNewSurveySave_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
if (!bool.Parse(Session["canEdit"].ToString()))
{
throw new Exception(Feedback.NoPermissions());
}
int newSurveyNo = (int)rntxtSurveyNo.Value;
string user = Session["UserName"].ToString();
int userID = int.Parse(Session["UserID"].ToString());
bool saved = new DistressEntry().InsertNewSectionSampleSurvey(int.Parse(gvLaneSamples.SelectedValue.ToString()), int.Parse(ddlMainStreetSection.SelectedValue),
newSurveyNo, ((DateTime)rdtpSurveyDate.SelectedDate).ToString("dd/MM/yyyy"), user, userID, int.Parse(ddlMainStreets.SelectedValue));
if (saved)
{
radlOldSurveys.Items.Clear();
radlOldSurveys.DataBind();
radlOldSurveys.SelectedIndex = (radlOldSurveys.Items.Count > 0) ? 0 : -1;
pnlDistressDetails.Visible = true;
btnCancelDistress_Click(sender, e);
radOldSurvey.Checked = true;
radNewSurvey.Checked = false;
radOldSurvey_CheckedChanged(sender, e);
radlOldSurveys.Visible = true;
pnlNewSurvey.Visible = false;
lbtnAddDistress.Visible = true;
lblSurveysCount.Text = radlOldSurveys.Items.Count.ToString();
lblSurveyNo.Text = rntxtSurveyNo.Text;
lblSurveyDate.Text = ((DateTime)rdtpSurveyDate.SelectedDate).ToString("dd/MM/yyyy");
radlOldSurveys.SelectedValue = newSurveyNo.ToString();
radlOldSurveys_SelectedIndexChanged(sender, e);
}
else
{
lblFeedback.Text = Feedback.InsertException();
pnlDistressDetails.Visible = false;
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(Request.QueryString["DistID"]))
{
string image = new DistressEntry().GetDistressImage(int.Parse(Request.QueryString["DistID"]));
imgPhoto.ImageUrl = "~/Uploads/" + image;
}
else
{
Response.Redirect("SectionDistresses.aspx", false);
}
}
catch (Exception ex)
{
lblOperation.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Session["Permissions"] == null || Session["Permissions"].ToString()[0] != '1')
{
Response.Redirect("~/ASPX/Default.aspx", false);
}
if (!string.IsNullOrEmpty(Request.QueryString["DistID"]))
{
string image = new DistressEntry().GetDistressImage(int.Parse(Request.QueryString["DistID"]));
imgPhoto.ImageUrl = "~/Uploads/" + image;
}
else
{
Response.Redirect("Regiondistresses.aspx", false);
}
}
catch (Exception ex)
{
lblOperation.Text = ex.Message;
}
}
protected void btnSaveDistress_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
lblDistressFeedback.Text = "";
if (!bool.Parse(Session["canEdit"].ToString()))
{
throw new Exception(Feedback.NoPermissions());
}
//string imageFileName = "";
if (radlOldSurveys.SelectedValue == "")
{
throw new Exception(Feedback.NoSurveyDateNum());
}
else if (gvLaneSamples.SelectedValue == null)
{
throw new Exception(Feedback.NoSectionSampleSelected());
}
else if (ddlDistresses.SelectedValue == "-1")
{
throw new Exception(Feedback.NoDistressSelected());
}
else if (rntxtArea.Value == null)
{
throw new Exception("الرجاء إدخال مساحة العيب");
}
else if (int.Parse(ddlDistresses.SelectedValue) > 0 && ddlDistressSeverity.SelectedValue == "N")
{
throw new Exception(Feedback.NoDistressSeveritySelected());
}
// saving the distress
string user = Session["UserName"].ToString();
string sectionNo = ((Label)frvSectionInfo.FindControl("SECTION_NOLabel")).Text;
double?sampleArea = double.Parse(gvLaneSamples.Rows[gvLaneSamples.SelectedIndex].Cells[4].Text);
int userID = int.Parse(Session["UserID"].ToString());
int surveyNum = int.Parse(lblSurveyNo.Text);
int sampleID = int.Parse(gvLaneSamples.SelectedValue.ToString());
// imageFileName,
bool saved = new DistressEntry().InsertSectionDistress(sampleID, lblSurveyDate.Text, surveyNum, ddlDistresses.SelectedItem.Text,
ddlDistressSeverity.SelectedValue[0], rntxtArea.Value, sampleArea, sectionNo, txtDistressNotes.Text, user,
int.Parse(ddlMainStreetSection.SelectedValue), userID, int.Parse(ddlMainStreets.SelectedValue));
if (saved)
{
btnCancelDistress_Click(sender, e);
lblDistressFeedback.Text = Feedback.InsertSuccessfull();
gvDistresses.DataBind();
}
else
{
lblDistressFeedback.Text = Feedback.InsertException();
}
}
catch (Exception ex)
{
lblDistressFeedback.Text = ex.Message;
}
finally
{
Session["PhotoChanged"] = false;
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
//if (ddlDistresses.SelectedValue == "0")
// throw new Exception(Feedback.NoDistressSelected());
string reportType = "";
DistressQntyReportType type = DistressQntyReportType.None;
if (radSections.Checked)
{
reportType = "radSections";
type = DistressQntyReportType.MainStreetSections;
}
else if (radIntersects.Checked)
{
reportType = "radIntersects";
type = DistressQntyReportType.MainStreetIntersects;
}
else if (radRegion.Checked)
{
reportType = "radRegion";
type = DistressQntyReportType.Region;
}
else if (radSubdist.Checked)
{
reportType = "radRegion";
type = DistressQntyReportType.Subdistrict;
}
else if (radDist.Checked)
{
reportType = "radRegion";
type = DistressQntyReportType.District;
}
else if (radMunic.Checked)
{
reportType = "radRegion";
type = DistressQntyReportType.Municipality;
}
else if (radMunicSections.Checked)
{
reportType = "radSections";
type = DistressQntyReportType.SectionsInMunicipality;
}
DataTable dt = new DistressEntry().GetDistressQnty(type, int.Parse(ddlMainStreets.SelectedValue), int.Parse(ddlRegions.SelectedValue), ddlSubDist.SelectedValue,
ddlDistrict.SelectedValue, ddlMunic.SelectedValue, int.Parse(ddlDistresses.SelectedValue));
if (dt.Rows.Count > 0 && !string.IsNullOrEmpty(reportType))
{
Session.Add("ReportData", dt);
Session.Add("option", reportType);
string url = "ViewDistressQuantitiesReport.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 (radByIntersection.Checked)
{
if (ddlMainStreetIntersection.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreetIntersection.SelectedValue))
{
throw new Exception(Feedback.NoIntersectionSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyDateNum()); // int.Parse(radlOldSurveys.SelectedValue)
DataTable dt = new DistressEntry().GetIntersectionDistressesReport(int.Parse(ddlMainStreetIntersection.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByIntersection");
Session.Add("ReportData", dt);
string url = "ViewIntersectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radbyMainStreet.Checked)
{
if (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))
{
throw new Exception(Feedback.NoMainStreetSelected());
}
DataTable dt = new DistressEntry().GetMainStreetInersectionsDistressesReport(int.Parse(ddlMainStreets.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radbyMainStreet");
Session.Add("ReportData", dt);
string url = "ViewIntersectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByMunic.Checked)
{
if (ddlMunic.SelectedValue == "0" || string.IsNullOrEmpty(ddlMunic.SelectedValue))
{
throw new Exception(Feedback.NoMuniciplaitySelected());
}
DataTable dt = new DistressEntry().GetIntersectionDistressesReport(ddlMunic.SelectedValue);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByIntersection");
Session.Add("ReportData", dt);
string url = "ViewIntersectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
//else if (radByStreetDistressArea.Checked)
//{
// if (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))
// throw new Exception(Feedback.NoMainStreetSelected());
// DataTable dt = new DistressEntry().GetMainStreetIntersectionsDistressArea(int.Parse(ddlMainStreets.SelectedValue));
// if (dt.Rows.Count > 0)
// {
// Session.Add("option", "radByStreetDistressArea");
// Session.Add("ReportData", dt);
// string url = "ViewIntersectionDistressesReport.aspx";
// ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
// }
// else
// lblFeedback.Text = Feedback.NoData();
//}
else if (radByStreetDistressAreaTotal.Checked)
{
if (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))
{
throw new Exception(Feedback.NoMainStreetSelected());
}
DataTable dt = new DistressEntry().GetMainStreetIntersectionsDistressAreaTotal(int.Parse(ddlMainStreets.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByStreetDistressAreaTotal");
Session.Add("ReportData", dt);
string url = "ViewIntersectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByStreetAreaTotal.Checked)
{
if (ddlDistresses.SelectedValue == "0")
{
throw new Exception(Feedback.NoDistressSelected());
}
DataTable dt = new DistressEntry().GetMainStreetIntersectionDistressesTotalBydistress(int.Parse(ddlDistresses.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByStreetAreaTotal");
Session.Add("ReportData", dt);
string url = "ViewIntersectionDistressesReport.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 = "";
Session.Remove("ReportData");
if (radbyRegion.Checked)
{
//survey = int.Parse(radlOldSurveys.SelectedValue); survey
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
int secStID = (ddlRegionSecondaryStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegionSecondaryStreets.SelectedValue)) ? 0 : int.Parse(ddlRegionSecondaryStreets.SelectedValue);
DataTable dt = new DistressEntry().GetRegionDistressesReport(int.Parse(ddlRegions.SelectedValue), radPatchDistsOnly.Checked, secStID);
if (dt.Rows.Count > 0)
{
//CrystalReportPartsViewer1.ReportSource = GenerateReport(dt);
//CrystalReportPartsViewer1.DataBind();
//lblFeedback.Text = "Finished";
Session.Add("option", "radbyRegion");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByMuncipality.Checked)
{
if (ddlMunic.SelectedValue == "0" || string.IsNullOrEmpty(ddlMunic.SelectedValue))
{
throw new Exception(Feedback.NoMuniciplaitySelected());
}
DataTable dt = new DistressEntry().GetRegionDistressesReport(ddlMunic.SelectedValue, radPatchDistsOnly.Checked);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radbyRegion");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionDistressArea.Checked)
{
//survey = int.Parse(radlOldSurveys.SelectedValue);
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
DataTable dt = new DistressEntry().GetByRegionDistressArea(int.Parse(ddlRegions.SelectedValue)); // survey
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionDistressArea");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionDistressAreaTotal.Checked)
{
//survey = int.Parse(radlOldSurveys.SelectedValue); survey,
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
DataTable dt = new DistressEntry().GetByRegionDistressAreaTotal(int.Parse(ddlRegions.SelectedValue), radAllDistress.Checked);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionDistressAreaTotal");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionDistressAreaSeverity.Checked)
{
//survey = int.Parse(radlOldSurveys.SelectedValue);
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
DataTable dt = new DistressEntry().GetByRegionDistressAreaSeverity(int.Parse(ddlRegions.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionDistressAreaSeverity");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionDistressAreaSeverityTotal.Checked)
{
//survey = int.Parse(radlOldSurveys.SelectedValue);
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoRegionSelected());
}
DataTable dt = new DistressEntry().GetByRegionDistressAreaSeverityTotal(int.Parse(ddlRegions.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionDistressAreaSeverityTotal");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radAllRegionsDistressArea.Checked)
{
//survey = int.Parse(radlOldSurveys.SelectedValue);
DataTable dt = new DistressEntry().GetAllRegionsDistressArea();
if (dt.Rows.Count > 0)
{
Session.Add("option", "radAllRegionsDistressArea");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByRegionAreaTotal.Checked)
{
//if (ddlDistresses.SelectedValue == "0")
// throw new Exception(Feedback.NoDistressSelected(lang));
//survey = int.Parse(radlOldSurveys.SelectedValue);
DataTable dt = new DistressEntry().GetByRegionAreaTotal(int.Parse(ddlDistresses.SelectedValue), int.Parse(ddlRegions.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByRegionAreaTotal");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByDate.Checked)
{
//if (ddlRegions.SelectedValue == "0")
// throw new Exception(Feedback.NoRegionSelected(lang));
//else
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 DistressEntry().GetRegionDistressesReport(raddtpFrom.SelectedDate, raddtpTo.SelectedDate);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radbyRegion");
Session.Add("ReportData", dt);
string url = "ViewRegionDistressesReport.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 (radBySection.Checked)
{
if (ddlMainStreetSection.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreetSection.SelectedValue))
{
throw new Exception(Feedback.NoSectionSelected());
}
//else if (radlOldSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyNum()); int.Parse(radlOldSurveys.SelectedValue)
DataTable dt = new DistressEntry().GetSectionDistresses(int.Parse(ddlMainStreetSection.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radBySection");
Session.Add("ReportData", dt);
Session.Add("title", "");
string url = "ViewSectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radbyMainStreet.Checked)
{
if (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))
{
throw new Exception(Feedback.NoMainStreetSelected());
}
DataTable dt = new DistressEntry().GetMainStreetDistresses(int.Parse(ddlMainStreets.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radbyMainStreet");
Session.Add("ReportData", dt);
string url = "ViewSectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByStreetDistressArea.Checked)
{
if (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))
{
throw new Exception(Feedback.NoMainStreetSelected());
}
DataTable dt = new DistressEntry().GetMainStreetDistressArea(int.Parse(ddlMainStreets.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByStreetDistressArea");
Session.Add("ReportData", dt);
string url = "ViewSectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByStreetDistressAreaTotal.Checked)
{
if (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))
{
throw new Exception(Feedback.NoMainStreetSelected());
}
DataTable dt = new DistressEntry().GetMainStreetDistressAreaTotal(int.Parse(ddlMainStreets.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByStreetDistressAreaTotal");
Session.Add("ReportData", dt);
string url = "ViewSectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByStreetAreaTotal.Checked)
{
if (ddlDistresses.SelectedValue == "0")
{
throw new Exception(Feedback.NoDistressSelected());
}
DataTable dt = new DistressEntry().GetMainStreetDistressesTotalBydistress(int.Parse(ddlDistresses.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radByStreetAreaTotal");
Session.Add("ReportData", dt);
string url = "ViewSectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radByDate.Checked)
{
DataTable dt = new DistressEntry().GetMainStreetDistresses(int.Parse(ddlMainStreets.SelectedValue), raddtpFrom.SelectedDate, raddtpTo.SelectedDate);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radbyMainStreet");
Session.Add("ReportData", dt);
string url = "ViewSectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radSectionsSurroundingRegion.Checked)
{
if (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))
{
throw new Exception(Feedback.NoSectionSelected());
}
//else if (radlRegionSectionsSurveys.SelectedIndex == -1)
// throw new Exception(Feedback.NoSurveyNum());
//int survey = int.Parse(radlRegionSectionsSurveys.SelectedValue);
DataTable dt = new DistressEntry().GetSectionSurroundingRegionDistresses(int.Parse(ddlRegions.SelectedValue));
if (dt.Rows.Count > 0)
{
Session.Add("option", "radBySection");
Session.Add("title", string.Format("المحيطة بالمنطقة {0}", ddlRegions.SelectedItem.Text));
Session.Add("ReportData", dt);
string url = "ViewSectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
throw new Exception(Feedback.NoData());
}
}
else if (radMunicSections.Checked)
{
if (ddlMunic.SelectedValue == "0" || string.IsNullOrEmpty(ddlMunic.SelectedValue))
{
throw new Exception(Feedback.NoMuniciplaitySelected());
}
DataTable dt = new DistressEntry().GetMunicSectionsDistresses(ddlMunic.SelectedValue);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radBySection");
Session.Add("title", string.Format("ضمن نطاق بلدية {0}", ddlMunic.SelectedItem.Text));
Session.Add("ReportData", dt);
string url = "ViewSectionDistressesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
throw new Exception(Feedback.NoData());
}
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
