protected void Page_Load(object sender, EventArgs e)
{
try
{
lblMessage.Text = "";
ddlPages = (DropDownList)GPager.FindControl("ddlPages");
txtGotoPage = (TextBox)GPager.FindControl("txtGotoPage");
lblCurrentPage = (Label)GPager.FindControl("lblCurrentPage");
lblTotalPage = (Label)GPager.FindControl("lblTotalPage");
lblCurrentPageRecCount = (Label)GPager.FindControl("lblCurrentPageRecCount");
lblCurrentTotalRec = (Label)GPager.FindControl("lblCurrentTotalRec");
lblTotalNoOfRec = (Label)GPager.FindControl("lblTotalNoOfRec");
Ajax.Utility.RegisterTypeForAjax(typeof(PendingECommQuotes));
if (!IsPostBack)
{
ViewState["Action"] = "New";
ViewState["Mode"] = "Active"; // Display grid without deleted orders
dtpEndDt.SelectedDate = DateTime.Now.ToShortDateString();
DateTime StartDate = DateTime.Now.AddDays(-1);
if (StartDate.DayOfWeek == DayOfWeek.Sunday)
{
StartDate = StartDate.AddDays(-2);
}
dtpStartDt.SelectedDate = StartDate.ToShortDateString();
BindLocations();
BindOrderType();
GPager.Visible = false;
if (Request.QueryString["UserName"] != null && Request.QueryString["UserName"].ToString().Length > 0)
{
Session["UserName"] = Request.QueryString["UserName"].ToString();
//utility.HighlightDropdownValue(ddlLocation, common.GetUserLoc(Session["UserName"].ToString()));
utility.HighlightDropdownValue(ddlInsideRep, Request.QueryString["UserName"].ToString());
BindDataGrid();
}
else
{
txtCustomerNumber.Focus();
}
}
}
catch (Exception ex)
{
utility.DisplayMessage(MessageType.Failure, ex.ToString(), lblMessage);
pnlStatusMessage.Update();
}
}
private void BindDataGrid()
{
if (DateTime.Parse(dtpStartDt.SelectedDate.ToString()).AddDays(14) < DateTime.Parse(dtpEndDt.SelectedDate.ToString()))
{
dtpStartDt.SelectedDate = DateTime.Parse(dtpEndDt.SelectedDate.ToString()).AddDays(-14).ToShortDateString();
}
if ((ddlInsideRep.SelectedIndex != 0) && (ddlInsideRep.SelectedValue.ToString() != "ALL"))
{
ecommQuotes.UpdateRep(ddlInsideRep.SelectedValue.ToString());
}
DataTable dtPendingOrders = ecommQuotes.ExecutePendingQuotes(
txtCustomerNumber.Text.ToString()
, (ddlLocation.SelectedIndex != 0 ? ddlLocation.SelectedItem.Value : "")
, (ddlInsideRep.SelectedIndex != 0 ? ddlInsideRep.SelectedItem.Value : "")
, (ddlOrderType.SelectedIndex != 0 ? ddlOrderType.SelectedValue : "")
, dtpStartDt.SelectedDate.ToString()
, dtpEndDt.SelectedDate.ToString()
).Tables[0];
if (dtPendingOrders.Rows.Count == 0) // if datatable is empty add new row for display purpose
{
DataRow dr = dtPendingOrders.NewRow();
dtPendingOrders.Rows.Add(dr);
if (Page.IsPostBack && ViewState["Action"] != "Clear")
{
utility.DisplayMessage(MessageType.Failure, noRecordMessage, lblMessage);
pnlStatusMessage.Update();
GPager.Visible = false;
PagerUpdatePanel.Update();
}
}
else
{
utility.DisplayMessage(MessageType.Success, successMessage, lblMessage);
pnlStatusMessage.Update();
gvPendingOrders.DataSource = dtPendingOrders;
GPager.InitPager(gvPendingOrders, LinesPerPage);
GPager.Visible = true;
PagerUpdatePanel.Update();
pnlPendingQuotesGrid.Update();
}
dtPendingOrders.DefaultView.Sort = (hidSort.Value == "") ? "CustNo asc" : hidSort.Value;
Session["PendingECommData"] = dtPendingOrders;
}
