protected void GetSalesOrderProductListById(string salesOrderId)
        {
            SalesOrderBLL salesOrder = new SalesOrderBLL();

            try
            {
                DataTable dt = salesOrder.GetSalesOrderProductListById(salesOrderId);

                if (dt.Rows.Count > 0)
                {
                    salesOrderProductListGridView.DataSource = dt;
                    salesOrderProductListGridView.DataBind();

                    if (salesOrderProductListGridView.Rows.Count > 0)
                    {
                        salesOrderProductListGridView.UseAccessibleHeader = true;
                        salesOrderProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;
                        deliveredButton.Enabled = true;
                    }
                    else
                    {
                        deliveredButton.Enabled = false;
                    }
                }
                else
                {
                    msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
                }
            }
            catch (Exception ex)
            {
                msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = ex.Message;
            }
            finally
            {
                salesOrder = null;
            }
        }
        protected void GetSalesOrderProductListById(string salesOrderId)
        {
            SalesOrderBLL salesOrder = new SalesOrderBLL();

            try
            {
                if (statusLabel.Text != "Pending")
                {
                    salesOrderProductListGridView.Columns[5].Visible = false;
                    salesOrderProductListGridView.Columns[6].Visible = false;
                    salesOrderProductListGridView.Columns[7].Visible = false;
                    salesOrderProductListGridView.Columns[8].Visible = false;
                    salesOrderProductListGridView.Columns[9].Visible = true;
                    salesOrderProductListGridView.Columns[10].Visible = true;
                    salesOrderProductListGridView.Columns[11].Visible = true;
                    salesOrderProductListGridView.Columns[12].Visible = true;
                    //New Add
                    salesOrderProductListGridView.Columns[4].Visible = false;


                }
                else
                {
                    salesOrderProductListGridView.Columns[5].Visible = true;
                    salesOrderProductListGridView.Columns[6].Visible = true;
                    salesOrderProductListGridView.Columns[7].Visible = true;
                    salesOrderProductListGridView.Columns[8].Visible = true;
                    salesOrderProductListGridView.Columns[9].Visible = false;
                    salesOrderProductListGridView.Columns[10].Visible = false;
                    salesOrderProductListGridView.Columns[11].Visible = false;
                    salesOrderProductListGridView.Columns[12].Visible = false;
                    //New add
                    salesOrderProductListGridView.Columns[4].Visible = true;
                }

                DataTable dt = salesOrder.GetSalesOrderProductListById(salesOrderId);

                if (dt.Rows.Count > 0)
                {
                    salesOrderProductListGridView.DataSource = dt;
                    salesOrderProductListGridView.DataBind();

                    if (salesOrderProductListGridView.Rows.Count > 0)
                    {
                        salesOrderProductListGridView.UseAccessibleHeader = true;
                        salesOrderProductListGridView.HeaderRow.TableSection = TableRowSection.TableHeader;


                    }

                }
                else
                {
                    msgbox.Visible = true; msgTitleLabel.Text = "Data Not Found!!!"; msgDetailLabel.Text = "";
                }
            }
            catch (Exception ex)
            {
                msgbox.Visible = true; msgTitleLabel.Text = "Exception!!!"; msgDetailLabel.Text = "Somethings goes wrong in getProduct By ID" + ex.Message;
            }
            finally
            {
                salesOrder = null;
            }
        }