private void btnCreatePO_Click(object sender, EventArgs e)
{
List <SupplierObj> Suppliers = (dgvSupplier.DataSource as List <SupplierObj>).FindAll(x => x.Isordered == true);
if (Suppliers.Count == 0)
{
MessageBox.Show("there is no Purchases order to created");
return;
}
List <InventoryRecord> InventoryRecords = (dgvItems.DataSource as List <InventoryRecord>).FindAll(x => x.ISordered == true);
foreach (SupplierObj Supplier in Suppliers)
{
List <InventoryRecord> InventoryRecordsToinsert = InventoryRecords.FindAll(x => x.SupplierID == Supplier.SupplierID.ToString());
int i = 1;
PurchaseOrders.Insert(Supplier, "WithoutSend Mail", dtpDue.Value, InventoryRecordsToinsert.Sum(x => x.Cost));
foreach (InventoryRecord inventoryrecord in InventoryRecordsToinsert)
{
inventoryrecord.Cost = inventoryrecord.HideCost * inventoryrecord.QtyToOrder;
inventoryrecord.ExtendedCost = inventoryrecord.HideCost * inventoryrecord.QtyToOrder;
inventoryrecord.IsAuto = IsAuto;
PurchaseOrderDetails.Insert(inventoryrecord, i, dtpExpected.Value);
POHistory.Insert(inventoryrecord, i, txtCancel.Text);
Inventory.AddToLogAccDB(inventoryrecord);
i++;
}
}
MessageBox.Show("purchase order created successfully");
this.Close();
}
public void clbOrderNumbers_ItemCheck(object sender, ItemCheckEventArgs e)
{
PurchaseOrdersObj purchaseorder = PurchaseOrders.GetByID((int)clbOrderNumbers.Items[e.Index]);
if (e.NewValue == CheckState.Checked)
{
foreach (PurchaseOrderDetailsObj item in PurchaseOrderDetails.GetByPONumber(purchaseorder.PONumber).FindAll(m => m.QuantityRemaining != 0))
{
bs.Add(item);
}
foreach (POHistoryobj item in POHistory.GetReceivedItems(purchaseorder.PONumber))
{
rbs.Add(item);
}
foreach (POLogObj item in POLog.GetAll(Convert.ToInt32(cbSupplier.SelectedValue),purchaseorder.PONumber).FindAll(m=>m.IsUpdated == false))
{
nbs.Add(item);
}
}
else
{
foreach (PurchaseOrderDetailsObj item in purchaseorderdetailslist.FindAll(m => m.PONumber == purchaseorder.PONumber))
{
bs.Remove(item);
}
foreach (POHistoryobj item in ReceivingList.FindAll(m => m.PONumber == purchaseorder.PONumber))
{
rbs.Remove(item);
}
foreach (POLogObj item in NotReceivingList.FindAll(m => m.PONumber == purchaseorder.PONumber))
{
nbs.Remove(item);
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int x = 1;
int q = 0;
frmMain.receivedreport.ReportDataSet.Clear();
for (int i = 0; i < dgvReceiving.Rows.Count; i++)
{
POHistoryobj poh = new POHistoryobj();
ReceiveObj rcv = ReceivingList[i];
poh.Cost = rcv.Cost;
poh.EnteredBy = txtOperationName.Text;
poh.ItemNumber = rcv.ItemNumber;
poh.LocalSKU = rcv.LocalSKU;
poh.PONumber = rcv.PONumber;
poh.Quantity = rcv.QtyReceived;
poh.SuppliersSKU = rcv.SupplierSKU;
POHistory.Insert(poh);
Inv.UpdatePrice(rcv.LocalSKU, rcv.Price, rcv.Price2, rcv.Price3, rcv.QtyReceived);
string res = "";
InventoryRecord ir = Inv.GetData(rcv.LocalSKU, rcv.LocalSKU, ref res);
ReportDataSet.InventoryRow r = frmMain.receivedreport.ReportDataSet.Inventory.NewInventoryRow();
r.Barcode = ir.Barcode;
r.BarcodeImage = "file:///" + Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "//SIO//BI//" + ir.Barcode + ".jpg";
r.ID = x;
r.ItemName = ir.ProductName;
r.Location = ir.Location;
r.Price = "$" + Math.Round(ir.Price, 2).ToString();
r.Price3 = "$" + Math.Round(ir.Price3, 2).ToString();
r.Qty = rcv.QtyReceived;
q += rcv.QtyReceived;
r.SKU = ir.SKU;
r.OrderNumber = rcv.OrderNumber.ToString();
frmMain.receivedreport.ReportDataSet.Tables[0].Rows.Add(r);
if (checkBox1.Checked)
{
dgvReceiving_CellContentClick(dgvReceiving, new DataGridViewCellEventArgs(dgvReceiving.Columns["clm2QuickPrint"].Index, i));
}
}
frmMain.receivedreport.WindowState = FormWindowState.Normal;
frmMain.receivedreport.StartPosition = FormStartPosition.CenterScreen;
frmMain.receivedreport.reportViewer1.RefreshReport();
foreach (POLogObj item in pologlist)
{
POLog.Update(item.POLogID);
}
frmMain.receivedreport.ShowDialog();
ResetAll((Control)cbSupplier);
}
