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