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