protected void btnShowMaintDecUdi_Click(object sender, EventArgs e) { try { lblAddFeedback.Text = ""; DataTable dt = new DataTable(); DataTable dtMaintOrders = new MaintenanceOrders().GetMaintenanceOrdersByLocation(radSection.Checked, radIntersect.Checked, radRegion.Checked, ddlMainStreetSection.SelectedValue, ddlMainStreetIntersection.SelectedValue, ddlRegionSecondaryStreets.SelectedValue); DataTable dtFeedbacks = new MaintenanceFeedback().Search(radSection.Checked, radIntersect.Checked, radRegion.Checked, ddlMainStreets.SelectedValue, ddlMainStreetSection.SelectedValue, ddlMainStreetIntersection.SelectedValue, "0", ddlRegions.SelectedValue, ddlRegionSecondaryStreets.SelectedValue); if (radSection.Checked) { if (ddlMainStreetSection.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreetSection.SelectedValue)) { throw new Exception(Feedback.NoSectionSelected()); } dt = new MaintenanceDecisions().GetMaintDecisionUdi(true, false, false, int.Parse(ddlMainStreetSection.SelectedValue)); } else if (radIntersect.Checked) { if (ddlMainStreetIntersection.SelectedValue == "0" || string.IsNullOrEmpty(ddlMainStreetIntersection.SelectedValue)) { throw new Exception(Feedback.NoIntersectionSelected()); } dt = new MaintenanceDecisions().GetMaintDecisionUdi(false, true, false, int.Parse(ddlMainStreetIntersection.SelectedValue)); } else if (radRegion.Checked) { if (ddlRegionSecondaryStreets.SelectedValue == "0" || string.IsNullOrEmpty(ddlRegionSecondaryStreets.SelectedValue)) { throw new Exception(Feedback.NoSecondaryStreetSelected()); } dt = new MaintenanceDecisions().GetMaintDecisionUdi(false, false, true, int.Parse(ddlRegionSecondaryStreets.SelectedValue)); } gvMaintDecUdi.DataSource = dt; gvMaintDecUdi.DataBind(); gvMaintOrders.DataSource = dtMaintOrders; gvMaintOrders.DataBind(); gvFeedbacks.DataSource = dtFeedbacks; gvFeedbacks.DataBind(); } catch (Exception ex) { lblAddFeedback.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 btnSave_Click(object sender, EventArgs e) { DataTable dt = new MaintenanceOrders().GetMaintOrders(ddlContractors.SelectedValue); if (dt.Rows.Count > 0) { lblFeedback.Text = ""; GridView1.DataSource = dt; GridView1.DataBind(); } else { lblFeedback.Text = Feedback.NoData(); } }
protected void btnCancel_Click(object sender, EventArgs e) { DataTable dt = new MaintenanceOrders().GetMaintOrders(ddlContractors.SelectedValue); if (dt.Rows.Count > 0) { Session.Add("ReportData", dt); Session.Add("option", "WorkOrders"); string url = "ViewWorkOrders.aspx"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true); } else { lblFeedback.Text = Feedback.NoData(); } }
protected void btnAddContract_Click(object sender, EventArgs e) { try { lblFeedback.Text = ""; if (!bool.Parse(Session["canEdit"].ToString())) { throw new Exception(Feedback.NoPermissions()); } if (DataAreValid()) { return; } bool saved = new MaintenanceOrders().Insert(CONTRACT_NOTextBox.Text, CONTRACT_NAMETextBox.Text, int.Parse(ddlContractors.SelectedValue), raddtpBegin.SelectedDate, raddtpWorkBegin.SelectedDate, raddtpEnd.SelectedDate, int.Parse(ddlWorkStatus.SelectedValue)); //radWorking.Checked, radStopped.Checked, radCancelled.Checked); //bool saved = new MaintenanceOrders().Insert(CONTRACT_NOTextBox.Text, CONTRACT_NAMETextBox.Text, int.Parse(ddlContractors.SelectedValue), // ((DateTime)raddtpBegin.SelectedDate).ToString("dd/MM/yyyy"), ((DateTime)raddtpWorkBegin.SelectedDate).ToString("dd/MM/yyyy"), // ((DateTime)raddtpEnd.SelectedDate).ToString("dd/MM/yyyy")); if (saved) { btnCancelContract_Click(sender, e); lblFeedback.Text = Feedback.InsertSuccessfull(); gvMaintainOrders.DataBind(); } else { lblFeedback.Text = Feedback.InsertException(); } } 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 sectionID = string.IsNullOrEmpty(ddlMainStreetSection.SelectedValue) ? 0 : int.Parse(ddlMainStreetSection.SelectedValue); int mainStID = string.IsNullOrEmpty(ddlMainStreets.SelectedValue) ? 0 : int.Parse(ddlMainStreets.SelectedValue); int intersectID = string.IsNullOrEmpty(ddlMainStreetIntersection.SelectedValue) ? 0 : int.Parse(ddlMainStreetIntersection.SelectedValue); int regionID = string.IsNullOrEmpty(ddlRegions.SelectedValue) ? 0 : int.Parse(ddlRegions.SelectedValue); int secStID = string.IsNullOrEmpty(ddlRegionSecondaryStreets.SelectedValue) ? 0 : int.Parse(ddlRegionSecondaryStreets.SelectedValue); if (radSection.Checked) { saved = new MaintenanceOrders().AddMaintenanceOrdersDetailLocations(maintOrderDetailID, radSection.Checked, radIntersect.Checked, radRegion.Checked, mainStID, sectionID, radDistricts.Checked, radMunics.Checked, ""); } else if (radIntersect.Checked) { saved = new MaintenanceOrders().AddMaintenanceOrdersDetailLocations(maintOrderDetailID, radSection.Checked, radIntersect.Checked, radRegion.Checked, mainStID, intersectID, radDistricts.Checked, radMunics.Checked, ""); } else if (radRegion.Checked) { saved = new MaintenanceOrders().AddMaintenanceOrdersDetailLocations(maintOrderDetailID, radSection.Checked, radIntersect.Checked, radRegion.Checked, regionID, secStID, radDistricts.Checked, radMunics.Checked, ""); } else if (radDistricts.Checked) { saved = new MaintenanceOrders().AddMaintenanceOrdersDetailLocations(maintOrderDetailID, radSection.Checked, radIntersect.Checked, radRegion.Checked, regionID, secStID, radDistricts.Checked, radMunics.Checked, ddlRegionNames.SelectedValue); } else if (radMunics.Checked) { saved = new MaintenanceOrders().AddMaintenanceOrdersDetailLocations(maintOrderDetailID, radSection.Checked, radIntersect.Checked, radRegion.Checked, regionID, secStID, radDistricts.Checked, radMunics.Checked, ddlMunic.SelectedValue); } if (saved) { lblAddFeedback.Text = Feedback.InsertSuccessfull(); gvLocations.DataBind(); } else { lblAddFeedback.Text = Feedback.InsertException(); } } catch (Exception ex) { lblAddFeedback.Text = ex.Message; } }