private void btnUpdate_Click(object sender, EventArgs e)
{
try
{
BusinessManager BM = new BusinessManager();
BOProduct BOP = new BOProduct();
BOInventory BOI = new BOInventory();
BOP.ConfigID = txtConfigID.Text;
BOI.InventoryID = txtInventoryID.Text;
BOI.InventoryDate = dtpInventoryDate.Text;
BOI.TotalPrice = txtTotalPrice.Text;
BOI.Quantity = txtQuantity.Text;
int RowsAffected = BM.BALUpdateIntoInventory(BOP, BOI);
MessageBox.Show("Successfully updated", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnUpdate.Enabled = false;
getData();
//frmMainMenu frm = new frmMainMenu();
//frm.GetData();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
try
{
BusinessManager BM = new BusinessManager();
BOProduct BOP = new BOProduct();
BOInventory BOI = new BOInventory();
BOP.ConfigID = txtConfigID.Text;
BOI.InventoryID = txtInventoryID.Text;
BOI.InventoryDate = dtpInventoryDate.Text;
BOI.TotalPrice = txtTotalPrice.Text;
BOI.Quantity = txtQuantity.Text;
int RowsAffected = BM.BALUpdateIntoInventory(BOP, BOI);
if (RowsAffected > 0)
{
MessageBox.Show("Successfully updated", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnUpdate.Enabled = false;
getData();
}
else
{
MessageBox.Show("Record couldn't be updated", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void Delete()
{
try
{
BusinessManager BM = new BusinessManager();
BOInventory BOI = new BOInventory();
BOI.InventoryID = txtInventoryID.Text;
int RowsAffected = BM.BALDeleteFromInventory(BOI);
if (RowsAffected > 0)
{
MessageBox.Show("The record has been successfully deleted", "Successfully Deleted", MessageBoxButtons.OK, MessageBoxIcon.Information);
New();
}
else
{
MessageBox.Show("No record found", "No Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
New();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
BusinessManager BM = new BusinessManager();
BOSales BOS = new BOSales();
BOProduct BOP = new BOProduct();
BOInventory BOI = new BOInventory();
BOS.GrandTotal = txtGrandTotal.Text;
BOS.TotalPayment = txtTotalPayment.Text;
BOS.PaymentDue = txtPaymentDue.Text;
BOS.Remarks = txtRemarks.Text;
BOS.InvoiceNo = txtInvoiceNo.Text;
try
{
BM.BALUpdateSales(BOS);
for (int i = 0; i <= listView1.Items.Count - 1; i++)
{
BOP.ProductQuantity = listView1.Items[i].SubItems[4].Text;
BOP.Price = listView1.Items[i].SubItems[3].Text;
BOP.TotalAmount = listView1.Items[i].SubItems[5].Text;
BOS.InvoiceNo = txtInvoiceNo.Text;
BOP.ConfigID = listView1.Items[i].SubItems[1].Text;
BM.BALUpdateProductSold(BOS, BOP);
}
for (int i = 0; i <= listView1.Items.Count - 1; i++)
{
BOS.InvoiceNo = txtInvoiceNo.Text;
BOP.ConfigID = listView1.Items[i].SubItems[1].Text;
BOP.ProductQuantity = listView1.Items[i].SubItems[4].Text;
BOP.Price = listView1.Items[i].SubItems[3].Text;
BOP.TotalAmount = listView1.Items[i].SubItems[5].Text;
BM.BALInsertIntoProductSold(BOS, BOP);
}
for (int i = 0; i <= listView1.Items.Count - 1; i++)
{
BOI.TotalPrice = listView1.Items[i].SubItems[5].Text;
BOP.ConfigID = listView1.Items[i].SubItems[1].Text;
BM.BALUpdateInventoryTotalPrice(BOI, BOP);
}
dataGridView1.DataSource = BM.BALGetInvoiceData();
btnUpdate.Enabled = false;
MessageBox.Show("Successfully updated", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnRegister_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
if (txtProductName.Text == "")
{
MessageBox.Show("Please select a product name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtProductName.Focus();
return;
}
if (txtQuantity.Text == "")
{
MessageBox.Show("Please enter a quantity", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtQuantity.Focus();
return;
}
try
{
BusinessManager BM = new BusinessManager();
BOProduct BOP = new BOProduct();
BOInventory BOI = new BOInventory();
BOP.ConfigID = txtConfigID.Text;
BOI.InventoryDate = dtpInventoryDate.Text;
auto_generate();
BOI.InventoryID = txtInventoryID.Text;
BOI.Quantity = txtQuantity.Text;
BOI.TotalPrice = txtTotalPrice.Text;
bool res = BM.BALVerifyInventoryName(BOP);
if (res == true)
{
MessageBox.Show("Record already exists!" + "\n" + "Please update the stock of product", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int rowsAffected = BM.BALInsertIntoInventory(BOP, BOI);
if (rowsAffected > 0)
{
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
btnRegister.Enabled = false;
getData();
//frmMainMenu frm = new frmMainMenu();
//frm.GetData();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
try
{
if (txtCustID.Text == "")
{
MessageBox.Show("Please retrieve Customer ID", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCustID.Focus();
return;
}
if (txtVAT.Text == "")
{
MessageBox.Show("Please enter VAT percentage", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtVAT.Focus();
return;
}
if (txtTotalPayment.Text == "")
{
MessageBox.Show("Please enter total payment", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTotalPayment.Focus();
return;
}
if (listView1.Items.Count == 0)
{
MessageBox.Show("Sorry no product added", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
auto_generate_id();
BusinessManager BM = new BusinessManager();
BOSales BOS = new BOSales();
BOCustomer BOC = new BOCustomer();
BOProduct BOP = new BOProduct();
BOInventory BOI = new BOInventory();
BOS.InvoiceNo = txtInvoiceNo.Text;
BOS.InvoiceDate = dtpInvoiceDate.Text;
BOC.CustomerID = txtCustID.Text;
BOS.SubTotal = txtSubTotal.Text;
BOS.VATPercent = txtVAT.Text;
BOS.VATAmount = txtVatAmount.Text;
BOS.GrandTotal = txtGrandTotal.Text;
BOS.TotalPayment = txtTotalPayment.Text;
BOS.PaymentDue = txtPaymentDue.Text;
BOS.Remarks = txtRemarks.Text;
bool res = BM.BALVerifyInvoiceNumber(BOS);
if (res == true)
{
MessageBox.Show("Invoice No. already exists", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
BM.BALInsertIntoSales(BOS, BOC);
}
for (int i = 0; i <= listView1.Items.Count - 1; i++)
{
BOS.InvoiceNo = txtInvoiceNo.Text;
BOP.ConfigID = listView1.Items[i].SubItems[1].Text;
BOP.ProductQuantity = listView1.Items[i].SubItems[4].Text;
BOP.Price = listView1.Items[i].SubItems[3].Text;
BOP.TotalAmount = listView1.Items[i].SubItems[5].Text;
BM.BALInsertIntoProductSold(BOS, BOP);
}
for (int i = 0; i <= listView1.Items.Count - 1; i++)
{
BOI.Quantity = listView1.Items[i].SubItems[4].Text;
BOP.ConfigID = listView1.Items[i].SubItems[1].Text;
BM.BALUpdateInventoryQuantity(BOI, BOP);
}
for (int i = 0; i <= listView1.Items.Count - 1; i++)
{
BOI.TotalPrice = listView1.Items[i].SubItems[5].Text;
BOP.ConfigID = listView1.Items[i].SubItems[1].Text;
BM.BALUpdateInventoryTotalPrice(BOI, BOP);
}
btnSave.Enabled = false;
btnPrint.Enabled = true;
dataGridView1.DataSource = BM.BALGetInvoiceData();
MessageBox.Show("Successfully saved", "Record", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void BALUpdateInventoryTotalPrice(BOInventory Inventory, BOProduct Product)
{
DBManager DALObject = new DBManager();
DALObject.UpdateInventoryTotalPrice(Inventory, Product);
}
public void BALUpdateInventoryQuantity(BOInventory Inventory, BOProduct Product)
{
DBManager DALObject = new DBManager();
DALObject.UpdateInventoryQuantity(Inventory, Product);
}
public int BALUpdateIntoInventory(BOProduct Product, BOInventory Inventory)
{
DBManager DALObject = new DBManager();
return(DALObject.UpdateIntoInventory(Product, Inventory));
}
public int BALDeleteFromInventory(BOInventory Inventory)
{
DBManager DALObject = new DBManager();
return(DALObject.DeleteFromInventory(Inventory));
}
