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