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