void Btn_SubmitPrint_Click(object sender, EventArgs e) { if (int.TryParse(Txt_CurrentUsage.Text, out int CurrUsage) && CurrUsage >= TOTAL_USAGE) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to release the " + DateTime.Now.ToShortDateString() + " invoice for the customer #" + CUSTOMER_ID + "?" + Environment.NewLine + "Customer should pay " + Txt_Total.Text + "L.L.", "Adding a new Customer!", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { int INVOICE_ID = GenID("invoice", "invoice_id"); ExecuteQuery("INSERT INTO invoice VALUES(" + INVOICE_ID + ", date(), " + TOTAL_USAGE + ", " + CurrUsage + ", " + MONTHLY_COST + ", " + (CurrUsage - TOTAL_USAGE) + ", " + PRICE_ID + ", " + CUSTOMER_ID + ")"); MessageBox.Show("Invoice #" + INVOICE_ID + " release."); Frm_Report_Invoice frm = new Frm_Report_Invoice(INVOICE_ID, CUT_HOURS); frm.ShowDialog(); Dispose(); } } else { MessageBox.Show("Please fill all required data correctly!"); } }
void DGV_Invoices_Click(object sender, EventArgs e) { if (ShowingUnreleased) { if (DGV_Invoices.SelectedRows.Count > 0) { Frm_ReleaseInvoice frm = new Frm_ReleaseInvoice(int.Parse(DGV_Invoices.SelectedRows[0].Cells[1].Value.ToString()), int.Parse(Txt_CutHours.Text)); frm.ShowDialog(); frm.Dispose(); ShowUnreleased(); if (DGV_Invoices.Rows.Count == 0) { Btn_ShowUnreleased.PerformClick(); } int NumberOfUnreleasedInvoices = getUnreleasedCount(); if (NumberOfUnreleasedInvoices > 0) { Lbl_NoOfUnreleased.Text = "You have " + NumberOfUnreleasedInvoices + " unreleased invoice(s)"; Lbl_NoOfUnreleased.ForeColor = Color.Red; Btn_ShowUnreleased.Enabled = true; } else { Lbl_NoOfUnreleased.Text = "All this month's invoices are released!"; Lbl_NoOfUnreleased.ForeColor = Color.Green; Btn_ShowUnreleased.Enabled = false; } } } else { if (DGV_Invoices.SelectedRows.Count > 0) { Frm_Report_Invoice Frm = new Frm_Report_Invoice(int.Parse(DGV_Invoices.SelectedRows[0].Cells[2].Value.ToString()), int.Parse(Txt_CutHours.Text)); Frm.ShowDialog(); } } }