private void EditPurchaseOrderDetail(DataTable datasource) { var pdetail = new PurchaseOrderDetail(); pdetail.LoadByPo(_poid); var iunit = new ItemUnitBase(); if (_dtselectedItemsTable != null) { _dtselectedItemsTable.Clear(); } pdetail.Rewind(); while (!pdetail.EOF) { if (datasource != null) { iunit.LoadUnit(pdetail.UnitOfIssueID, pdetail.ItemID); DataRow[] dataRows = datasource.Select(String.Format("ItemID = {0} and UnitID = {1}", pdetail.ItemID, iunit.ID)); if (dataRows.Length > 0) { // _dtselectedItemsTable.ImportRow(dataRows[0]); var selectedRow = _dtselectedItemsTable.NewRow(); selectedRow["FullItemName"] = dataRows[0]["FullItemName"]; selectedRow["StockCode"] = dataRows[0]["StockCode"]; selectedRow["Unit"] = dataRows[0]["Unit"]; selectedRow["UnitID"] = iunit.ID; selectedRow["ItemID"] = pdetail.ItemID; selectedRow["Quantity"] = pdetail.Quantity; selectedRow["Amount"] = pdetail.Amount; selectedRow["PreferredManufacturerID"] = pdetail.PreferredManufacturerID; selectedRow["PurchaseOrderDetailID"] = pdetail.PurchaseOrderDetailID; //Check all dataRows[0]["IsSelected"] = true; _dtselectedItemsTable.Rows.Add(selectedRow); } } pdetail.MoveNext(); } gridItemsList.DataSource = datasource.DefaultView; gridSelectedItems.DataSource = _dtselectedItemsTable.DefaultView; }
public void SavePoDetail() { if (!ValidateOrderDetails()) { return; } var itemData = (DataView)gridSelectedItemsView.DataSource; foreach (DataRowView row in itemData) { if (row["PurchaseOrderDetailID"] == DBNull.Value) { _poDetail.AddNew(); } else { _poDetail.LoadByPrimaryKey(Convert.ToInt32(row["PurchaseOrderDetailID"])); } var itemUnit = new ItemUnitBase(); var unitID = Convert.ToInt32(row["UnitID"]); itemUnit.LoadByPrimaryKey(unitID); _poDetail.PurchaseOrderID = _poid; _poDetail.ItemID = Convert.ToInt32(row["ItemID"]); _poDetail.Quantity = Convert.ToDecimal(row["Quantity"]); _poDetail.Remark = string.Empty; _poDetail.UnitOfIssueID = itemUnit.UnitOfIssueID; _poDetail.Rowguid = Guid.NewGuid(); _poDetail.ApprovedQuantity = 0; _poDetail.Amount = Convert.ToDecimal(row["Amount"]); if (row["PreferredManufacturerID"] != DBNull.Value) { _poDetail.PreferredManufacturerID = Convert.ToInt32(row["PreferredManufacturerID"]); } _poDetail.Save(); } MessageBox.Show("Order detail saved!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); Close(); }
private void simpleButton1_Click(object sender, EventArgs e) { var dt = (DataView)gridView1.DataSource; dt.RowFilter = "Requested >0"; if (dt == null) { return; } var po = new PO(); po.AddNew(); var serverDateTime = DateTimeHelper.ServerDateTime; po.PODate = serverDateTime; po.DateOfEntry = serverDateTime; po.PurchaseType = POType.INTERNAL; po.PaymentTypeID = PaymentType.Constants.STV; po.TermOfPayement = TermOfPayment.List[6].ID; po.PurchaseOrderStatusID = 9; //PurchaseOrderStatus ==> Processed po.SavedbyUserID = CurrentContext.LoggedInUser.ID; po.Save(); var purchaseOrderDetail = new PurchaseOrderDetail(); foreach (DataRowView dr in dt) { var itemUnit = new ItemUnitBase(); itemUnit.LoadByPrimaryKey(Convert.ToInt32(dr["UnitID"])); purchaseOrderDetail.AddNew(); purchaseOrderDetail.ItemID = Convert.ToInt32(dr["ItemID"]); purchaseOrderDetail.UnitOfIssueID = itemUnit.UnitOfIssueID; purchaseOrderDetail.Quantity = Convert.ToInt32(dr["Requested"]); purchaseOrderDetail.PurchaseOrderID = po.ID; purchaseOrderDetail.Rowguid = Guid.NewGuid(); purchaseOrderDetail.ApprovedQuantity = 0; } purchaseOrderDetail.Save(); lookUpEdit1_EditValueChanged(null, null); }