private void Delete()
{
try
{
BusinessManager BM = new BusinessManager();
BOSales BO = new BOSales();
BO.InvoiceNo = txtInvoiceNo.Text;
int rowsAffected = BM.BALDeleteInvoiceData(BO);
if (rowsAffected > 0)
{
MessageBox.Show("The record has been successfully deleted", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
New();
}
else
{
MessageBox.Show("No Record found", "Sorry", 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 btnPrint_Click(object sender, EventArgs e)
{
//Cursor = Cursors.WaitCursor;
//timer1.Enabled = true;
BusinessManager BM = new BusinessManager();
BOSales BO = new BOSales();
BO.InvoiceNo = txtInvoiceNo.Text;
rptInvoiceReport rpt = new rptInvoiceReport();
rpt.SetDataSource(BM.BALInvoiceReport(BO));
frmInvoiceReport frm = new frmInvoiceReport();
frm.crystalReportViewer1.ReportSource = rpt;
frm.Visible = true;
}
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 BALUpdateProductSold(BOSales Sales, BOProduct Product)
{
DBManager DALObject = new DBManager();
DALObject.UpdateProductSold(Sales, Product);
}
public DataSet BALInvoiceReport(BOSales Sales)
{
DBManager DALObject = new DBManager();
return(DALObject.InvoiceReport(Sales));
}
public void BALUpdateSales(BOSales Sales)
{
DBManager DALObject = new DBManager();
DALObject.UpdateSales(Sales);
}
public void BALInsertIntoProductSold(BOSales Sales, BOProduct Product)
{
DBManager DALObject = new DBManager();
DALObject.InsertIntoProductSold(Sales, Product);
}
public void BALInsertIntoSales(BOSales Sales, BOCustomer Customer)
{
DBManager DALObject = new DBManager();
DALObject.InsertIntoSales(Sales, Customer);
}
public bool BALVerifyInvoiceNumber(BOSales Invoice)
{
DBManager DALObject = new DBManager();
return(DALObject.VerifyInvoiceNumber(Invoice));
}
public int BALDeleteInvoiceData(BOSales Invoice)
{
DBManager DALObject = new DBManager();
return(DALObject.DeleteInvoiceData(Invoice));
}
