private void lstRefNo_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            var dr = (DataRowView)lstRefNo.GetDataRecordByNode(lstRefNo.Selection[0]);

            if (dr == null)
            {
                return;
            }

            string[] ReferenceNo = new string[2];
            ReferenceNo[0] = dr["RefNo"].ToString();
            ReferenceNo[1] = dr["Date"].ToString();
            DataTable dtTransactions;

            if (ReferenceNo[0] != "")
            {
                OrderID = Convert.ToInt32(dr["ID"]);
                if (OrderID != 0)
                {
                    //dtTransactions = iss.GetIssueByRefNo(ReferenceNo[0], Convert.ToInt32(cboStores.EditValue));
                    OrderID = Convert.ToInt32(dr["ID"]);
                    BLL.PickList pl = new BLL.PickList();
                    dtTransactions = pl.GetPickListDetailsForOrder(OrderID).Table;

                    // Fix the column names for the reports to recognize
                    //dtTransactions.Columns["BatchNumber"].ColumnName = "BatchNo";
                    //dtTransactions.Columns["ExpireDate"].ColumnName = "ExpDate";
                    //dtTransactions.Columns["SKUTOPICK"].ColumnName = "QtyInSKU";
                    //dtTransactions.Columns["Packs"].ColumnName = "Pack";
                    //dtTransactions.Columns["Cost"].ColumnName = "CalculatedCost";
                    gridTransactions.DataSource = dtTransactions;
                }
            }
        }
        private void cboIssuedTo_EditValueChanged(object sender, EventArgs e)
        {
            if (lkIssuedTo.EditValue != null && cboStores.EditValue != null)
            {
                BLL.PickList plst = new BLL.PickList();
                DataTable dtRec = new DataTable();

                lstRefNo.DataSource = plst.GetDistinctPickList(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkIssuedTo.EditValue));
                gridTransactions.DataSource = dtRec;
            }
        }
        private void cboIssuedTo_EditValueChanged(object sender, EventArgs e)
        {
            if (lkIssuedTo.EditValue != null && cboStores.EditValue != null)
            {
                BLL.PickList plst  = new BLL.PickList();
                DataTable    dtRec = new DataTable();

                lstRefNo.DataSource         = plst.GetDistinctPickList(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkIssuedTo.EditValue));
                gridTransactions.DataSource = dtRec;
            }
        }
 private void cboStores_EditValueChanged(object sender, EventArgs e)
 {
     if (cboStores.EditValue != null)
     {
         BLL.PickList pl      = new BLL.PickList();
         DataTable    dtIssue = pl.GetDistinctPickList(Convert.ToInt32(cboStores.EditValue));
         // add the current year datarow
         DataRowView drv = dtIssue.DefaultView.AddNew();
         drv["ID"]           = 0;
         drv["RefNo"]        = "Current Year";
         lstRefNo.DataSource = dtIssue;
     }
 }
        private void cboStores_EditValueChanged(object sender, EventArgs e)
        {
            if (cboStores.EditValue != null)
            {
                BLL.PickList pl = new BLL.PickList();
                DataTable dtIssue = pl.GetDistinctPickList(Convert.ToInt32(cboStores.EditValue));
                // add the current year datarow
                DataRowView drv = dtIssue.DefaultView.AddNew();
                drv["ID"] = 0;
                drv["RefNo"] = "Current Year";
                lstRefNo.DataSource = dtIssue;

            }
        }
        private void lstRefNo_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            var dr = (DataRowView)lstRefNo.GetDataRecordByNode(lstRefNo.Selection[0]);
            if (dr == null)
            {
                return;
            }

            string[] ReferenceNo = new string[2];
            ReferenceNo[0] = dr["RefNo"].ToString();
            ReferenceNo[1] = dr["Date"].ToString();
            DataTable dtTransactions;

            if (ReferenceNo[0] != "")
            {
                OrderID = Convert.ToInt32(dr["ID"]);
                if (OrderID != 0)
                {
                    //dtTransactions = iss.GetIssueByRefNo(ReferenceNo[0], Convert.ToInt32(cboStores.EditValue));
                    OrderID = Convert.ToInt32(dr["ID"]);
                    BLL.PickList pl = new BLL.PickList();
                    dtTransactions = pl.GetPickListDetailsForOrder(OrderID).Table;

                    // Fix the column names for the reports to recognize
                    //dtTransactions.Columns["BatchNumber"].ColumnName = "BatchNo";
                    //dtTransactions.Columns["ExpireDate"].ColumnName = "ExpDate";
                    //dtTransactions.Columns["SKUTOPICK"].ColumnName = "QtyInSKU";
                    //dtTransactions.Columns["Packs"].ColumnName = "Pack";
                    //dtTransactions.Columns["Cost"].ColumnName = "CalculatedCost";
                    gridTransactions.DataSource = dtTransactions;
                }

            }
        }