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; }