private void btnAddnewPurchase_Click(object sender, EventArgs e)
{
try
{
if (txtRef.Text == string.Empty || txtBuyerName.Text == string.Empty || dgvProducts.Rows.Count == 0)
{
MessageBox.Show("Remplir tous les champs!");
}
else
{
DataTable dtInvoiceDetail = new DataTable();
dtInvoiceDetail.Columns.Add("P_ID");
dtInvoiceDetail.Columns.Add("P_Price");
foreach (DataGridViewRow dr in dgvProducts.Rows)
{
dtInvoiceDetail.Rows.Add(dr.Cells[0].Value, dr.Cells[4].Value);
}
CLASS_INVOICE.SP_INVOICEINSERT(txtRef.Text, dtpFacture.Value.Date, decimal.Parse(txtTotal.Text), int.Parse(txtID.Text), txtBuyerName.Text, dtInvoiceDetail);
MessageBox.Show("La facture a été ajoutée avec succès");
PrintPurchase.Enabled = true;
clearzone();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void PrintPurchase_Click(object sender, EventArgs e)
{
int I = CLASS_INVOICE.SP_MAXIDINVOICE();
RPT.FORM_RPT FRM = new RPT.FORM_RPT();
RPT.Print_SelectedInvoice SELECTEDINVOICE = new RPT.Print_SelectedInvoice();
SELECTEDINVOICE.SetParameterValue("@I_ID", I);
FRM.crystalReportViewer1.ReportSource = SELECTEDINVOICE;
FRM.ShowDialog();
}
private void btnDelete_Click(object sender, EventArgs e)
{
int i = int.Parse(dgvFacture.CurrentRow.Cells[0].Value.ToString());
DialogResult R = MessageBox.Show("Voulez vous vraiment supprimer cette facture?", "Notification", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (R == DialogResult.Yes)
{
CLASS_INVOICE.SP_DELETEINVOICE(i);
MessageBox.Show("Facture supprimer avec succes!");
}
}
private void btnSEarch_Click(object sender, EventArgs e)
{
DataTable dt = CLASS_INVOICE.SP_SEARCHINVOICE(txtsearch.Text);
dgvFacture.DataSource = dt;
}
private void btnDisplay_Click(object sender, EventArgs e)
{
DataTable dt = CLASS_INVOICE.SP_DISPLAYALLINVOICE();
dgvFacture.DataSource = dt;
}
