private void btnCreate_Click(object sender, EventArgs e)
{
if (CartTable.Rows.Count != 0)
{
GeneralMethods.CreateSalesOrder(CustID);
SOID = GeneralMethods.GetSalesOrderID();
int Sum = 0;
foreach (DataRow row in CartTable.Rows)
{
int pid = (Convert.ToInt32(row["ID"]));
int quantity = (Convert.ToInt32(row[2]));
float amount = (Convert.ToSingle(row[3]));
int OldQuantity = GeneralMethods.GetQuantity(pid);
Sum += (int)amount;
GeneralMethods.CreateSalesOrderTransaction(SOID, pid, quantity, amount);
float Price = amount / quantity;
int Profit = GeneralMethods.GetProfitRate(pid);
float SellingPrice = ((Price / 100) * Profit) + Price;
GeneralMethods.UpdateProductQuantityOnSale(pid, (OldQuantity - quantity));
GeneralMethods.CreatePurchaseOrderMethod();
//if ((GeneralMethods.GetPreviousPurchaseOrderQuantity(pid) - quantity) > 0)
//{
// GeneralMethods.CreatePurchaseOrderAfterReceive(GeneralMethods.GetProductVendor(pid), pid, (GeneralMethods.GetPreviousPurchaseOrderQuantity(pid) - quantity));
//}
//GeneralMethods.CreatePurchaseOrderMethod();
}
MessageBox.Show("Your total bill:\t" + Sum + "\nThank You For Shopping!", "Success!");
}
else
{
MessageBox.Show("Please add some items to cart first!", "Error!");
}
}
private void btnAddProduct_Click(object sender, EventArgs e)
{
string ProductName, Description;
int CategoryID = 0, VendorID = 0, ProfitRate;
bool ValidSubmission = true;
if (String.IsNullOrWhiteSpace(cmbCategory.Text))
{
ValidSubmission = false;
MessageBox.Show("Please select a category for the product!", "Error");
}
else if (String.IsNullOrWhiteSpace(cmbVendor.Text))
{
ValidSubmission = false;
MessageBox.Show("Please select a vendor for the product!", "Error");
}
else if (String.IsNullOrWhiteSpace(txtName.Text))
{
ValidSubmission = false;
MessageBox.Show("Please enter a name for the product!", "Error");
}
else if (String.IsNullOrWhiteSpace(txtProfit.Text))
{
ValidSubmission = false;
MessageBox.Show("Please enter a profit rate for the product!", "Error");
}
else if (!(Int32.TryParse(txtProfit.Text, out ProfitRate)))
{
ValidSubmission = false;
MessageBox.Show("Please enter a valid profit rate!", "Error");
}
if (!(GeneralMethods.CheckCategory(cmbCategory.Text)))
{
if (MessageBox.Show("Are you sure you want to add a new category?", "Add New Category", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
GeneralMethods.AddCategory(cmbCategory.Text);
MessageBox.Show("Category added successfuly!", "Success");
}
CategoryID = GeneralMethods.GetCategory(cmbCategory.Text);
}
else if (GeneralMethods.CheckCategory(cmbCategory.Text))
{
CategoryID = GeneralMethods.GetCategory(cmbCategory.Text);
}
if (!(GeneralMethods.CheckVendor(cmbVendor.Text)))
{
if (MessageBox.Show("Are you sure you want to add a new vendor?", "Add New Vendor", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
{
GeneralMethods.AddVendor(cmbVendor.Text);
MessageBox.Show("Vendor added successfuly!", "Success");
}
VendorID = GeneralMethods.GetVendor(cmbVendor.Text);
}
else if (GeneralMethods.CheckVendor(cmbVendor.Text))
{
VendorID = GeneralMethods.GetVendor(cmbVendor.Text);
}
if (ValidSubmission)
{
ProductName = txtName.Text;
ProfitRate = Convert.ToInt32(txtProfit.Text);
Description = rtxtDescription.Text;
GeneralMethods.AddProduct(CategoryID, VendorID, ProductName, ProfitRate, Description);
GeneralMethods.CreatePurchaseOrderMethod();
MessageBox.Show("Product added successfully!", "Success");
//int id = GeneralMethods.GetPurchaseOrderID();
//GeneralMethods.CreatePurchaseOrderTransaction(id, VendorID, GeneralMethods.GetProductID(), 10);
}
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (ProductsReceivedTable.Rows.Count != 0)
{
//if (GeneralMethods.CreateNewReceieveOrder())
//{
GeneralMethods.CreateReceiveOrder(UserID);
ROID = GeneralMethods.GetReceiveOrderID();
//GeneralMethods.CreatePurchaseOrder();
foreach (DataRow row in ProductsReceivedTable.Rows)
{
int pid = (Convert.ToInt32(row["ID"]));
int quantity = (Convert.ToInt32(row[2]));
float amount = (Convert.ToSingle(row[3]));
GeneralMethods.CreateReceiveOrderTransaction(ROID, UserID, pid, quantity, amount);
float Price = amount / quantity;
int Profit = GeneralMethods.GetProfitRate(pid);
float SellingPrice = ((Price / 100) * Profit) + Price;
int OldQuantity = GeneralMethods.GetQuantity(pid);
GeneralMethods.UpdateProductQuantityAndPrice(pid, (quantity + OldQuantity), Price, SellingPrice);
//if ((GeneralMethods.GetPreviousPurchaseOrderQuantity(pid) - quantity) > 0)
//{
// GeneralMethods.CreatePurchaseOrderAfterReceive(GeneralMethods.GetProductVendor(pid), pid, (GeneralMethods.GetPreviousPurchaseOrderQuantity(pid) - quantity));
//}
}
//DataTable LastPurchaseOrder = new DataTable();
//DataTable NewPurchaseOrder = new DataTable();
//LastPurchaseOrder = GeneralMethods.GetPurchaseOrderTransactionTable((GeneralMethods.GetPurchaseOrderID() - 1));
//NewPurchaseOrder = GeneralMethods.GetPurchaseOrderTransactionTable(GeneralMethods.GetPurchaseOrderID());
//foreach (DataRow row in LastPurchaseOrder.Rows)
//{
// bool Present = false;
// int VendorID = 0;
// int Quantity = 0;
// int pid = Convert.ToInt32(row["pid"]);
// foreach (DataRow NewRow in NewPurchaseOrder.Rows)
// {
// int npid = Convert.ToInt32(NewRow["pid"]);
// if (npid == pid)
// {
// Present = true;
// break;
// }
// VendorID = Convert.ToInt32(row["vid"]);
// Quantity = Convert.ToInt32(row["potquantity"]);
// if (!Present)
// {
// GeneralMethods.CreatePurchaseOrderAfterReceive(VendorID, pid, Quantity);
// }
// }
//}
GeneralMethods.CreatePurchaseOrderMethod();
MessageBox.Show("Receive Order Successfully Created!", "Success!");
//}
}
else
{
MessageBox.Show("Please select some items first!", "Error!");
}
}
