private void BindDataGrid()
    {
        DataTable dtPendingOrders = pendingOrderAndQuotes.GetPendingOrders(BuildWhereClause());

        if (dtPendingOrders != null && dtPendingOrders.Rows.Count == 0) // if datatable is empty add new row for display purpose
        {
            DataRow dr = dtPendingOrders.NewRow();
            dtPendingOrders.Rows.Add(dr);
        }

        dtPendingOrders.DefaultView.Sort = "OrderNo asc";
        gvPendingOrders.DataSource       = dtPendingOrders.DefaultView.ToTable();
        gvPendingOrders.DataBind();

        // Hide Deleted Date Column base on mode
        gvPendingOrders.Columns[10].Visible = (ViewState["Mode"].ToString() != "ShowAll" ? false : true);
    }
Esempio n. 2
0
    private void BindDataGrid()
    {
        DataTable dtPendingOrders = pendingOrderAndQuotes.GetPendingOrders(BuildWhereClause());

        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();
            }
        }
        else
        {
            utility.DisplayMessage(MessageType.Success, successMessage, lblMessage);
            pnlStatusMessage.Update();
        }

        dtPendingOrders.DefaultView.Sort = (hidSort.Value == "") ? "OrderNo asc" : hidSort.Value;
        gvPendingOrders.DataSource       = dtPendingOrders.DefaultView.ToTable();
        gvPendingOrders.DataBind();


        // Hide Deleted Date Column base on mode
        gvPendingOrders.Columns[10].Visible = (ViewState["Mode"].ToString() == "Active" ? false : true);
        pnlPendingOrderGrid.Update();

        // Create Post url for utility dialog
        hidPrintURL.Value = Server.UrlEncode("PendingOrdersAndQuotesExport.aspx?CustomerNo=" + txtCustomerNumber.Text +
                                             "&LocDesc=" + (ddlLocation.SelectedIndex != 0 ? ddlLocation.SelectedItem.Text : "") +
                                             "&loccode=" + (ddlLocation.SelectedIndex != 0 ? ddlLocation.SelectedItem.Value : "") +
                                             "&OrderTypeDesc=" + (ddlOrderType.SelectedIndex != 0 ? ddlOrderType.SelectedItem.Text : "") +
                                             "&OrderTypeValue=" + (ddlOrderType.SelectedIndex != 0 ? ddlOrderType.SelectedItem.Value : "") +
                                             "&UserID=" + ddlUserID.SelectedItem.Value +
                                             "&UserName="******"&StartDate=" + dtpStartDt.SelectedDate +
                                             "&EndDate=" + dtpEndDt.SelectedDate +
                                             "&ShowDelRecord=" + ViewState["Mode"].ToString());
    }