//public static void CreatePurchaseOrderAfterReceive(int VendorID, int ProductID, int Quantity)
//{
// if (GeneralMethods.CreateNewPurchaseOrder())
// {
// DataTable Products = new DataTable();
// Products = GeneralMethods.GetProductsTable();
// GeneralMethods.CreatePurchaseOrder();
// int ID = GeneralMethods.GetPurchaseOrderID();
// GeneralMethods.CreatePurchaseOrderTransaction(ID, VendorID, ProductID, Quantity);
// }
// else if (!(GeneralMethods.CreateNewPurchaseOrder()))
// {
// int ID = GeneralMethods.GetPurchaseOrderID();
// DataTable Products = new DataTable();
// DataTable PurchaseOrders = new DataTable();
// DataTable Transactions = new DataTable();
// Products = GeneralMethods.GetProductsTable();
// PurchaseOrders = GeneralMethods.GetPurchaseOrders();
// Transactions = GeneralMethods.GetPurchaseOrderTransactionTable(ID);
// GeneralMethods.CreatePurchaseOrderTransaction(ID, VendorID, ProductID, Quantity);
// //GeneralMethods.CreatePurchaseOrder();
// }
//}
public static void CreatePurchaseOrderMethod()
{
//if (GeneralMethods.CreateNewPurchaseOrder())
//{
DataTable Products = new DataTable();
Products = GeneralMethods.GetProductsTable();
//GeneralMethods.CreatePurchaseOrder();
//int ID = GeneralMethods.GetPurchaseOrderID();
int j = GetMaxVendorID();
if (j < 1)
{
return;
}
for (int i = 1; i <= j; i++)
{
bool CreateOrder = true;
foreach (DataRow row in Products.Rows)
{
if ((Convert.ToInt32(row["quantity"])) <= 5 && (Convert.ToInt32(row["vid"])) == i)
{
//int ID = 0;
if (CreateOrder)
{
GeneralMethods.CreatePurchaseOrder(i);
CreateOrder = false;
}
int ID = GetPurchaseOrderID();
int PID = (Convert.ToInt32(row["pid"]));
int VID = (Convert.ToInt32(row["vid"]));
int Quantity = 10;
GeneralMethods.CreatePurchaseOrderTransaction(ID, PID, Quantity);
}
}
}
//}
//else if (!(GeneralMethods.CreateNewPurchaseOrder()))
//{
// int ID = GeneralMethods.GetPurchaseOrderID();
// DataTable Products = new DataTable();
// DataTable PurchaseOrders = new DataTable();
// DataTable Transactions = new DataTable();
// Products = GeneralMethods.GetProductsTable();
// PurchaseOrders = GeneralMethods.GetPurchaseOrders();
// Transactions = GeneralMethods.GetPurchaseOrderTransactionTable(ID);
// //GeneralMethods.CreatePurchaseOrder();
// foreach (DataRow prow in Products.Rows)
// {
// if (((int)(prow["quantity"])) <= 5)
// {
// bool NotExists = true;
// int tquantity = 0;
// int tid = 0;
// foreach (DataRow trow in Transactions.Rows)
// {
// if ((int)prow["pid"] == (int)trow["pid"])
// {
// NotExists = false;
// tquantity = ((int)(trow["potquantity"]));
// tid = ((int)trow["potid"]);
// break;
// }
// }
// if (NotExists)
// {
// int PID = ((int)(prow["pid"]));
// int VID = ((int)(prow["vid"]));
// int Quantity = 10;
// GeneralMethods.CreatePurchaseOrderTransaction(ID, VID, PID, Quantity);
// }
// //else if (!(NotExists))
// //{
// // if(tquantity < 10)
// // {
// // int PID = ((int)(prow["pid"]));
// // int VID = ((int)(prow["vid"]));
// // UpdatePurchaseOrderTransaction(tid, GetPurchaseOrderID(), VID, PID, 10);
// // }
// //}
// }
// }
//}
}
