protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
if (radSection.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveysWithNotes(JobType.Section);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radSection");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsNotesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radIntersection.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveysWithNotes(JobType.Intersection);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radIntersection");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsNotesReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radRegionSecondary.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveysWithNotes(JobType.RegionSecondaryStreets);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radRegionSecondary");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsNotesReport.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
{
lblFeedback.Text = "";
if (!bool.Parse(Session["canEdit"].ToString()))
{
throw new Exception(Feedback.NoPermissions());
}
if (raddtpIssueDate.SelectedDate == null)
{
throw new Exception("الرجاء إدخال تاريخ الاستلام");
}
else if (raddtpDeliveryDate.SelectedDate != null && (raddtpIssueDate.SelectedDate > raddtpDeliveryDate.SelectedDate))
{
throw new Exception("تاريخ التسليم لايمكن أن يكون سابقا لتاريخ الاستلام");
}
else if (rntxtSurveyNo.Value == null)
{
throw new Exception(Feedback.NoSurveyNum());
}
bool saved = new SurveyorSubmitJob().Insert(int.Parse(ddlSurveyor.SelectedValue), raddtpIssueDate.SelectedDate, raddtpDeliveryDate.SelectedDate,
int.Parse(rntxtSurveyNo.Text), txtNotes.Text, ddlRegions.SelectedValue, JobType.RegionSecondaryStreets);
if (saved)
{
btnCancel_Click(sender, e);
lblFeedback.Text = Feedback.InsertSuccessfull();
gvSurveyorJob.DataBind();
}
else
{
lblFeedback.Text = Feedback.InsertException();
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
ClearResults();
SurveyorSubmitJob job = new SurveyorSubmitJob();
DataTable dt = job.GetSurveyorSectionSurveys(int.Parse(ddlSurveyor.SelectedValue), (DateTime)raddtpFrom.SelectedDate, (DateTime)raddtpTo.SelectedDate);
gvSurveyedSections.DataSource = dt;
gvSurveyedSections.DataBind();
DataTable dt2 = job.GetSurveyorIntersectionSurveys(int.Parse(ddlSurveyor.SelectedValue), (DateTime)raddtpFrom.SelectedDate, (DateTime)raddtpTo.SelectedDate);
gvSurveyedIntersects.DataSource = dt2;
gvSurveyedIntersects.DataBind();
DataTable dt3 = job.GetSurveyorRegionSurveys(int.Parse(ddlSurveyor.SelectedValue), (DateTime)raddtpFrom.SelectedDate, (DateTime)raddtpTo.SelectedDate);
gvSurveyedRegion.DataSource = dt3;
gvSurveyedRegion.DataBind();
decimal totalSections = job.GetSurveyorSectionSurveysTotal(int.Parse(ddlSurveyor.SelectedValue), (DateTime)raddtpFrom.SelectedDate, (DateTime)raddtpTo.SelectedDate);
decimal totalIntersects = job.GetSurveyorIntersectionSurveysTotal(int.Parse(ddlSurveyor.SelectedValue), (DateTime)raddtpFrom.SelectedDate, (DateTime)raddtpTo.SelectedDate);
decimal totalRegions = job.GetSurveyorRegionSurveysTotal(int.Parse(ddlSurveyor.SelectedValue), (DateTime)raddtpFrom.SelectedDate, (DateTime)raddtpTo.SelectedDate);
lblSectionsTotal.Text = totalSections.ToString("N2");
lblIntersectsTotal.Text = totalIntersects.ToString("N2");
lblRegionsTotal.Text = totalRegions.ToString("N2");
lblTotal.Text = (totalSections + totalIntersects + totalRegions).ToString("N2");
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
if (!bool.Parse(Session["canEdit"].ToString()))
{
throw new Exception(Feedback.NoPermissions());
}
if (ddlRegions.SelectedValue == "0")
{
throw new Exception("الرجاء إدخال المنطقة");
}
if (ddlSurveyor.SelectedValue == "0")
{
throw new Exception("الرجاء إدخال إسم المساح");
}
if (raddtpIssueDate.SelectedDate == null)
{
throw new Exception("الرجاء إدخال تاريخ الاستلام");
}
else if (raddtpDeliveryDate.SelectedDate != null && (raddtpIssueDate.SelectedDate > raddtpDeliveryDate.SelectedDate))
{
throw new Exception("تاريخ التسليم لايمكن أن يكون سابقا لتاريخ الاستلام");
}
else if (rntxtSurveyNo.Value == null)
{
throw new Exception(Feedback.NoSurveyNum());
}
if (ddlDataEntry.SelectedValue == "0")
{
throw new Exception("الرجاء اختيار المدخل");
}
if (ddlReportMonth.SelectedValue == "0")
{
throw new Exception("الرجاء إدخال شهر التقرير");
}
if (RadNumericStreets.Value == null)
{
throw new Exception("الرجاء إدخال عدد الشوارع");
}
if (RadNumericRegionSum.Value == null)
{
throw new Exception("الرجاء إدخال مساحه المنطقة");
}
if (RadNumericStreetsAdd.Value == null)
{
throw new Exception("الرجاء إدخال عدد الشوارع المضافة");
}
if (RadNumericStreetDelete.Value == null)
{
throw new Exception("الرجاء إدخال عدد الشوارع المحذوفة");
}
else if (rntxtSurveyNo.Value < 3)
{
throw new Exception("قيمه المسح اقل من 3");
}
int ReportYear = int.Parse(DrpDwnYear.SelectedValue);
//switch (rntxtSurveyNo.Value.ToString())
//{
// case "3":
// ReportYear = 1;
// break;
// case "4":
// ReportYear = 2;
// break;
// case "5":
// ReportYear = 3;
// break;
// default:
// ReportYear = 1;
// break;
//}
bool SavedOne = new SurveyorSubmitJob().Insert(int.Parse(ddlSurveyor.SelectedValue), raddtpIssueDate.SelectedDate, raddtpDeliveryDate.SelectedDate,
int.Parse(rntxtSurveyNo.Text), txtNotes.Text, ddlRegions.SelectedValue, JobType.RegionSecondaryStreets);
if (SavedOne)
{
bool SavedTwo = new SystemUsers().InsertReportQc(Session["UserID"].ToString(), int.Parse(ddlRegions.SelectedValue), RadNumericStreets.Text,
RadNumericRegionSum.Text, rntxtSurveyNo.Text, int.Parse(ddlReportMonth.SelectedValue),
ReportYear, ddlSurveyor.SelectedItem.Text, ddlDataEntry.SelectedItem.Text, RadNumericStreetsAdd.Text, RadNumericStreetDelete.Text);
bool SavedThree = new SystemUsers().InsertReceivedFiles(ddlRegions.SelectedValue, ddlDataEntry.SelectedValue);
btnCancel_Click(sender, e);
lblFeedback.Text = Feedback.InsertSuccessfull();
gvSurveyorJob.DataBind();
}
else
{
lblFeedback.Text = Feedback.InsertException();
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
protected void btnShowReport_Click(object sender, EventArgs e)
{
try
{
lblFeedback.Text = "";
//if (ddlSurveyor.SelectedValue == "0")
// throw new Exception(Feedback.NoSurveyorSelected(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());
if (radSection.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveyorProductivityByQtyDelivery(JobType.Section, int.Parse(ddlSurveyor.SelectedValue), raddtpFrom.SelectedDate, raddtpTo.SelectedDate);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radSection");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsQtyDelivery.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
lblFeedback.Text = Feedback.NoData();
}
else if (radIntersection.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveyorProductivityByQtyDelivery(JobType.Intersection, int.Parse(ddlSurveyor.SelectedValue), raddtpFrom.SelectedDate, raddtpTo.SelectedDate);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radIntersection");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsQtyDelivery.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
lblFeedback.Text = Feedback.NoData();
}
else if (radRegionSecondary.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveyorProductivityByQtyDelivery(JobType.RegionSecondaryStreets, int.Parse(ddlSurveyor.SelectedValue), raddtpFrom.SelectedDate, raddtpTo.SelectedDate);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radRegionSecondary");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsQtyDelivery.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 = "";
lblTotal.Visible = false;
//if (ddlSurveyor.SelectedValue == "0")
// throw new Exception(Feedback.NoSurveyorSelected(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());
}
if (radSection.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveyorProductivity(JobType.Section, int.Parse(ddlSurveyor.SelectedValue), raddtpFrom.SelectedDate, raddtpTo.SelectedDate);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radSection");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsProductionReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radIntersection.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveyorProductivity(JobType.Intersection, int.Parse(ddlSurveyor.SelectedValue), raddtpFrom.SelectedDate, raddtpTo.SelectedDate);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radIntersection");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsProductionReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radRegionSecondary.Checked)
{
DataTable dt = new SurveyorSubmitJob().GetSurveyorProductivity(JobType.RegionSecondaryStreets, int.Parse(ddlSurveyor.SelectedValue), raddtpFrom.SelectedDate, raddtpTo.SelectedDate);
if (dt.Rows.Count > 0)
{
Session.Add("option", "radRegionSecondary");
Session.Add("ReportData", dt);
string url = " ViewSurveyorsProductionReport.aspx";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "RedirectScriptCoupon", "window.open('" + url + "', '_blank')", true);
}
else
{
lblFeedback.Text = Feedback.NoData();
}
}
else if (radTotal.Checked)
{
lblTotal.Visible = true;
SurveyorsDeliveryTotal total = new SurveyorSubmitJob().GetSurveyorsDeliveryTotals();
lblTotal.Text = string.Format("مقاطع: {0} م2 \n تقاطعات: {1} م2 \n مناطق فرعية: {2} م2 \n المجموع: {3} م2", total.SectionsTotal.ToString("N2"),
total.IntersectsTotal.ToString("N2"), total.RegionsTotal.ToString("N2"), total.Total.ToString("N2"));
}
}
catch (Exception ex)
{
lblFeedback.Text = ex.Message;
}
}
