protected void btnSave_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; if (!bool.Parse(Session["canEdit"].ToString())) { throw new Exception(Feedback.NoPermissions()); } if (!ValidateData()) { return; } bool saved = new TrafficEnhances().Insert(PROPOSE_TITLETextBox.Text, ucProposeDate.SelectedGregDate, ddlLetterFrom.SelectedValue, ucLetterDate.SelectedGregDate, LETTER_NOTextBox.Text, COMMITTE_HEAD_NAMETextBox.Text, NOTESTextBox.Text, ddlMunic.SelectedValue, ucProposeDate.SelectedHijriDate, ucLetterDate.SelectedHijriDate); if (saved) { Response.Redirect("SearchTrafficEnhances.aspx?msg=1", false); } else { lblFeedback.Text = Feedback.InsertException(); } } catch (Exception ex) { lblFeedback.Text = ex.Message; } }
protected void btnShowReport_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; if (radMainSt.Checked && (ddlMainStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreets.SelectedValue))) { throw new Exception("الرجاء اختيار الطريق الرئيسي"); } else if (radRegion.Checked && (ddlRegions.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegions.SelectedValue))) { throw new Exception("الرجاء اختيار المنطقة الفرعية"); } DataTable dt = new DataTable(); if (radTrafficEnhanceLocations.Checked) { Session.Add("option", "radTrafficEnhance"); string id = radAllRoads.Checked ? "0" : (radMainSt.Checked ? ddlMainStreets.SelectedValue : ddlRegions.SelectedValue); dt = new TrafficEnhances().SearchTrafficEnahnce(txtDetail.Text, raddtpFrom.SelectedDate, raddtpFrom.SelectedDate, radMainSt.Checked, int.Parse(id), radAllRoads.Checked, radTrafficEnhanceLocations.Checked); } else if (radMaintOrder.Checked) { Session.Add("option", "radMaintOrder"); string id = radMainSt.Checked ? ddlMainStreets.SelectedValue : ddlRegions.SelectedValue; dt = new MaintenanceOrders().Search(txtDetail.Text, int.Parse(ddlContractors.SelectedValue), raddtpFrom.SelectedDate, raddtpFrom.SelectedDate, radMainSt.Checked, int.Parse(id), radAllRoads.Checked); } else if (radTrafficEnhanceDetails.Checked) { Session.Add("option", "radTrafficEnhanceDetails"); string id = radAllRoads.Checked ? "0" : (radMainSt.Checked ? ddlMainStreets.SelectedValue : ddlRegions.SelectedValue); dt = new TrafficEnhances().SearchTrafficEnahnce(txtDetail.Text, raddtpFrom.SelectedDate, raddtpFrom.SelectedDate, radMainSt.Checked, int.Parse(id), radAllRoads.Checked, radTrafficEnhanceLocations.Checked); } if (dt.Rows.Count > 0) { Session.Add("ReportData", dt); string url = "ViewTrafficEnhancesMaintOrdersReport.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 btnAddLocation_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; lblAddFeedback.Text = ""; if (!bool.Parse(Session["canEdit"].ToString())) { throw new Exception(Feedback.NoPermissions()); } bool saved = false; //int maintOrderDetailID = int.Parse(gvMaintainOrdersDetails.SelectedValue.ToString()); int trafficEnhanceID = int.Parse(Request.QueryString["ID"]); int sectionID = int.Parse(ddlMainStreetSection.SelectedValue); int mainStID = int.Parse(ddlMainStreets.SelectedValue); int intersectID = int.Parse(ddlMainStreetIntersection.SelectedValue); if (radSection.Checked) { saved = new TrafficEnhances().AddTrafficEnhanceLocationsForMainStreets(trafficEnhanceID, radSection.Checked, radIntersect.Checked, mainStID, sectionID); } else if (radIntersect.Checked) { saved = new TrafficEnhances().AddTrafficEnhanceLocationsForMainStreets(trafficEnhanceID, radSection.Checked, radIntersect.Checked, mainStID, intersectID); } else if (radRegion.Checked) { saved = new TrafficEnhances().AddTrafficEnhanceLocationsforRegions(trafficEnhanceID, int.Parse(ddlRegions.SelectedValue), int.Parse(ddlSecST.SelectedValue), chkLandUse.Checked, txtLandUseDetails.Text); } if (saved) { lblAddFeedback.Text = Feedback.InsertSuccessfull(); gvLocations.DataBind(); btnCancelLocation_Click(sectionID, e); } else { lblAddFeedback.Text = Feedback.InsertException(); } } catch (Exception ex) { lblAddFeedback.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(Request.QueryString["ID"])) { Response.Redirect("SearchTrafficEnhances.aspx", false); } try { if (!IsPostBack) { if (Session["Permissions"] == null || Session["Permissions"].ToString()[8] != '1') { Response.Redirect("~/ASPX/Default.aspx", false); } // load data to edit DataTable dt = new TrafficEnhances().GetByID(int.Parse(Request.QueryString["ID"])); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; PROPOSE_TITLETextBox.Text = dr["PROPOSE_TITLE"].ToString(); ucProposeDate.SelectedGregDate = dr["APPROVE_DATE"].ToString(); ucProposeDate.SelectedHijriDate = dr["APPROVE_DATE_H"].ToString(); ddlMunic.SelectedValue = dr["MUNIC_NAME"].ToString(); ddlLetterFrom.SelectedValue = dr["LETTER_FROM"].ToString(); LETTER_NOTextBox.Text = dr["LETTER_NO"].ToString(); ucLetterDate.SelectedGregDate = dr["LETTER_DATE"].ToString(); ucLetterDate.SelectedHijriDate = dr["LETTER_DATE_H"].ToString(); COMMITTE_HEAD_NAMETextBox.Text = dr["COMMITTE_HEAD_NAME"].ToString(); NOTESTextBox.Text = dr["NOTES"].ToString(); } 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) { ImageFormat imageFormat = new ImageFormat(new Guid()); FileInfo file = new FileInfo(updDistressImage.FileName); string datetimePart = DateTime.Now.ToString("ddMMyyyyHHmm"); string imageFileName = string.Format("{0}_{1}", datetimePart, Path.GetFileName(updDistressImage.FileName)); //string newFileNameThumb = string.Format("{0}_thumb_{1}", datetimePart, Path.GetFileName(updDistressImage.FileName)); string fullImagePath = Server.MapPath("~/Uploads/") + imageFileName; updDistressImage.SaveAs(fullImagePath); bool saved = new TrafficEnhances().AddImage(int.Parse(Request.QueryString["ID"]), imageFileName, txtImageDetails.Text); if (saved) { txtImageDetails.Text = ""; lblOperation.Text = Feedback.UpdateSuccessfull(); gvIntersectImages.DataBind(); } else { lblOperation.Text = Feedback.UpdateException(); } } else { throw new Exception("الرجاء اختيار الملف"); } } catch (Exception ex) { lblOperation.Text = ex.Message; } }