private void BtnEditDetail_Click(object sender, EventArgs e) { InvoiceDetailModel detaliuModificat = new InvoiceDetailModel(); BLInvoiceDetails bLInvoiceDetails = new BLInvoiceDetails(); try { detaliuModificat.InvoiceDetailId = this.EditDetailId; detaliuModificat.Price = Convert.ToDecimal(tbPrice.Text); detaliuModificat.Qtty = Convert.ToDecimal(tbQtty.Text); detaliuModificat.Amount = Convert.ToDecimal(tbAmount.Text); detaliuModificat.Observations = tbObservations.Text; detaliuModificat.Articol.ItemId = Convert.ToInt32(cbItems.SelectedValue); DialogResult dialogResult = MessageBox.Show("Sigur doriti sa modificati detaliul?", "Modificare Detaliu Factura", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { bLInvoiceDetails.UpdateInvoiceDetail(detaliuModificat, out bool status, out string message); MessageBox.Show(message, "Status", MessageBoxButtons.OK, MessageBoxIcon.Information); panel1.Visible = false; initializareDataGrid(this.factura.InvoiceId); } else if (dialogResult == DialogResult.No) { this.Hide(); } } catch (Exception ex) { Console.WriteLine("EROARE UPDATE DETAIL! " + ex.Message); } }
private void BtnAdd_Click(object sender, EventArgs e) { InvoiceDetailModel detaliu = new InvoiceDetailModel(); BLInvoiceDetails blInvoice = new BLInvoiceDetails(); if (String.IsNullOrWhiteSpace(tbPrice.Text)) { errorProvider1.SetError(tbPrice, "Camp obligatoriu!"); } else if (String.IsNullOrWhiteSpace(tbQtty.Text)) { errorProvider1.SetError(tbPrice, "Camp obligatoriu!"); } else { try { detaliu.Price = Convert.ToDecimal(tbPrice.Text); detaliu.Qtty = Convert.ToDecimal(tbQtty.Text); detaliu.Amount = Convert.ToDecimal(tbAmount.Text); detaliu.Observations = tbObservations.Text; detaliu.Factura.InvoiceId = factura.InvoiceId; detaliu.Articol.ItemId = Convert.ToInt32(cbItems.SelectedValue); blInvoice.InsertInvoiceDetail(detaliu, out bool status, out string message); MessageBox.Show(message, "Status", MessageBoxButtons.OK, MessageBoxIcon.Information); panel1.Visible = false; initializareDataGrid(this.factura.InvoiceId); } catch (Exception ex) { Console.WriteLine("EROARE INSERARE DETALIU! " + ex.Message); } } }
public void initializareDataGrid(int id) { try { BLInvoiceDetails bLInvoiceDetails = new BLInvoiceDetails(); DataTable dt = new DataTable(); dt = bLInvoiceDetails.GetDetails(id); dataGridViewDetalii.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void BtnDelete_Click(object sender, EventArgs e) { if (filled) { if (dataGridViewFacturi.SelectedRows.Count > 0) { int invoiceId = -2; BLInvoices blInvoices = new BLInvoices(); BLInvoiceDetails bLInvoiceDetails = new BLInvoiceDetails(); foreach (DataGridViewRow row in dataGridViewFacturi.SelectedRows) { invoiceId = Convert.ToInt32(row.Cells[0].Value.ToString()); } DialogResult dialogResult = MessageBox.Show("Sigur doriti sa stergeti datele facturii selectate?", "Stergere Factura", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { bLInvoiceDetails.DeleteAllDetails(invoiceId, out string errormessage); blInvoices.DeleteInvoice(invoiceId, out string message); MessageBox.Show(message, "Status", MessageBoxButtons.OK, MessageBoxIcon.Information); initializareDataGridView(); } else if (dialogResult == DialogResult.No) { this.Hide(); } } else { MessageBox.Show("Selectati o factura pentru stergere!", "Status", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Lista facturi goala! Efectuati o cautare!", "Status", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
private void BtnDelete_Click(object sender, EventArgs e) { InvoiceDetailModel detaliuModificat = new InvoiceDetailModel(); BLInvoiceDetails bLInvoiceDetails = new BLInvoiceDetails(); int detId = -2; foreach (DataGridViewRow row in dataGridViewDetalii.SelectedRows) { detId = Convert.ToInt32(row.Cells[0].Value.ToString()); } DialogResult dialogResult = MessageBox.Show("Sigur doriti sa stergeti detaliul?", "Stergere Detaliu Factura", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { bLInvoiceDetails.DeleteSelectedDetail(detId, out string errorMessage); MessageBox.Show(errorMessage, "Status", MessageBoxButtons.OK, MessageBoxIcon.Information); initializareDataGrid(this.factura.InvoiceId); } else if (dialogResult == DialogResult.No) { this.Hide(); } }