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