private void BindItems()
 {
     IStock.BLL.PurchaseOrderDetails details = new IStock.BLL.PurchaseOrderDetails();
     details.GetPurchaseOrderDetails(CurrentPurchaseOrder.PurchaseOrderID);
     uiGridViewItems.DataSource = details.DefaultView;
     uiGridViewItems.DataBind();
     uiTextBoxTotal.Text = CurrentPurchaseOrder.GetPurchaseOrderTotals(CurrentPurchaseOrder.PurchaseOrderID).ToString();
 }
        protected void uiGridViewOrders_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "EditOrder")
            {
                IStock.BLL.PurchaseOrders objData = new IStock.BLL.PurchaseOrders();
                objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));

                uiTextBoxCode.Text = objData.PurchaseOrderNo;
                uiTextBoxDate.Text = objData.PurchaseOrderDate.ToString("dd/MM/yyy");
                uiDropDownListSuppliers.SelectedValue = objData.SupplierID.ToString();

                uiPanelAllOrders.Visible = false;
                uiPanelEditPurchaseOrder.Visible = true;
                uiPanelItems.Visible = true;
                CurrentPurchaseOrder = objData;
                BindItems();
                EnableDisableControls();

            }
            else if (e.CommandName == "DeleteOrder")
            {
                try
                {
                    IStock.BLL.PurchaseOrders objData = new IStock.BLL.PurchaseOrders();
                    objData.LoadByPrimaryKey(Convert.ToInt32(e.CommandArgument.ToString()));

                    IStock.BLL.PurchaseOrderDetails details = new IStock.BLL.PurchaseOrderDetails();
                    details.GetPurchaseOrderDetails(objData.PurchaseOrderID);
                    /*
                    if (details.RowCount > 0)
                    {
                        for(int i=0;i<details.RowCount;i++)
                        {
                            IStock.BLL.Items item = new IStock.BLL.Items();
                            item.LoadByPrimaryKey(details.ItemID);
                            item.Quantity -= details.NoOfPackages * details.ItemOnPackages;
                            item.Save();
                            details.MoveNext();
                        }
                    }
                    */
                    details.MarkAsDeleted();
                    details.Save();

                    objData.MarkAsDeleted();
                    objData.Save();
                    CurrentPurchaseOrder = null;
                    BindOrders();
                }
                catch (Exception ex)
                {
                    uipanelError.Visible = true;
                }
            }
        }
        protected void uiLinkButtonConfirm_Click(object sender, EventArgs e)
        {
            CurrentPurchaseOrder.Confirmed = true;
            CurrentPurchaseOrder.Save();
            uiLinkButtonConfirm.Enabled = false;

            IStock.BLL.PurchaseOrderDetails details = new IStock.BLL.PurchaseOrderDetails();
            details.GetPurchaseOrderDetails(CurrentPurchaseOrder.PurchaseOrderID);
            for (int i = 0; i < details.RowCount; i++)
            {
                IStock.BLL.Items item = new IStock.BLL.Items();
                item.LoadByPrimaryKey(details.ItemID);
                if (item.IsColumnNull("Quantity"))
                    item.SetColumn("Quantity", details.NoOfPackages * details.ItemOnPackages);
                else
                    item.Quantity += details.NoOfPackages * details.ItemOnPackages;
                item.Save();
                details.MoveNext();
            }
            EnableDisableControls();
            BindItems();
        }