private void MainForm_Load(object sender, EventArgs e) { infoLabel.Text = string.Format($"Sub Total :\nGST :\nPST :\nGrand Total :\n\n\n\nAverage :\nMaximum :\nMinimum :"); legendLabel.Text = null; invoiceDetailVM = new InvoiceDetailViewModel(); invoiceDetailVM.InvoiceDetails = InvoiceCRUDRepository.GetInvoiceDetails(); errorProvider = new ErrorProvider(); set_Bindings(); }
//function to refresh gridView private void loadDataGridView() { invoiceDetailVM.InvoiceDetails = InvoiceCRUDRepository.GetInvoiceDetails(); if (invoiceDetailVM.InvoiceDetails.Count > 0) { invoiceDetailListBox.DataSource = invoiceDetailVM.InvoiceDetails; invoiceDetailListBox.DisplayMember = "Sku"; legendLabel.TextAlign = ContentAlignment.MiddleRight; legendLabel.Text = string.Format($"{invoiceDetailVM.InvoiceDetails.SubTotal:C2}\n{invoiceDetailVM.InvoiceDetails.Gst:C2}\n{invoiceDetailVM.InvoiceDetails.Pst:C2}\n{invoiceDetailVM.InvoiceDetails.GrandTotal:C2}\n\n\n\n{invoiceDetailVM.InvoiceDetails.Average:C2}\n{invoiceDetailVM.InvoiceDetails.Maximum:C2}\n{invoiceDetailVM.InvoiceDetails.Minimum:C2}"); } }
public static int DeleteInvoiceDetail(InvoiceDetail invoiceDetail) { if (Validate(invoiceDetail)) { return(InvoiceCRUDRepository.DeleteInvoice(invoiceDetail)); } else { return(-1); } }
private void deleteButton_Click(object sender, EventArgs e) { try { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete?", "Confirm Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning); if (dialogResult == DialogResult.OK) { int index = invoiceDetailListBox.SelectedIndex; int result = 0; InvoiceDetail invoiceDetail = new InvoiceDetail { DetailId = Int16.Parse(invoiceIdTextBox.Text) }; result = InvoiceCRUDRepository.DeleteInvoice(invoiceDetail); if (result > 0) { loadDataGridView(); } } } catch (SqlException ex) { MessageBox.Show(ex.Message, "DB ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public static InvoiceDetailCollection GetInvoiceDetails() { return(InvoiceCRUDRepository.GetInvoiceDetails()); }