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); }
private void RemoveItem(DataRow dr) { var rows = dr.Table.Columns.Contains("ID") ? _dtselectedItemsTable.Select(String.Format("ItemID = {0} and UnitID = {1}", dr["ID"], dr["UnitID"])) : new[] { dr }; foreach (var rw in rows) { if (rw != null && rw["PurchaseOrderDetailID"] != DBNull.Value) { if (XtraMessageBox.Show(@"Are you sure you want to delete the detail from the database?", @"Confirmation", MessageBoxButtons.OKCancel) == DialogResult.OK) { var purchaseorderdetail = new PurchaseOrderDetail(); purchaseorderdetail.LoadByPrimaryKey(Convert.ToInt32((rw["PurchaseOrderDetailID"]))); purchaseorderdetail.MarkAsDeleted(); purchaseorderdetail.Save(); _dtselectedItemsTable.Rows.Remove(rw); } continue; } _dtselectedItemsTable.Rows.Remove(rw); } }
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; }
private void BindInvoiceDetailByPO(int POID) { _dtReceiptInvoiceDetail.Rows.Clear(); var poDetail = new PurchaseOrderDetail(); poDetail.LoadByPo(POID); foreach (DataRowView rowView in poDetail.DefaultView) { var newrow = _dtReceiptInvoiceDetail.NewRow(); newrow["FullItemName"] = rowView["FullItemName"]; newrow["Unit"] = rowView["Unit"]; newrow["Manufacturer"] = rowView["Manufacturer"]; newrow["OrderedQuantity"] = rowView["Quantity"]; newrow["OrderedAmount"] = rowView["Amount"]; newrow["ItemID"] = Convert.ToInt32(rowView["ItemID"]); newrow["UnitOfIssueID"] = Convert.ToInt32(rowView["UnitOfIssueID"]); newrow["ManufacturerID"] = Convert.ToInt32(rowView["PreferredManufacturerID"]); newrow["UnitPrice"] = 0; newrow["Margin"] = 0; newrow["IsSaved"] = false; newrow["GUID"] = Guid.NewGuid(); _dtReceiptInvoiceDetail.Rows.Add(newrow); } _dtReceiptInvoiceDetail.DefaultView.Sort = "FullItemName, Unit, Manufacturer, ExpiryDate DESC, BatchNumber DESC"; gridInvoiceDetail.DataSource = _dtReceiptInvoiceDetail; }