private void gridControl1_DoubleClick(object sender, EventArgs e)
{
DataRow row = gridView1.GetDataRow(gridView1.FocusedRowHandle);
//idfactt = Convert.ToInt32(row[22].ToString());
id_fact = Convert.ToInt32(row[0].ToString());
FacturePfReport report = new FacturePfReport(id_fact);
report.ShowPreviewDialog();
//facturingpf fc = new facturingpf();
//fc.ShowDialog();
}
private void simpleButton4_Click(object sender, EventArgs e)
{
string etat = "validée";
string etatcmd = "";
DataTable dt = new DataTable();
dt = fun.get_cltByDesign(lookUpEdit1.Text);
id_clt = Convert.ToInt32(dt.Rows[0][0]);
test = 0;
string timbre = textBox5.Text;
DataTable dt_num_fp = fun.get_etat_factpfBynum(int.Parse(tnumcommandebase.Text));
if (dt_num_fp.Rows.Count > 0)
{
XtraMessageBox.Show("Il existe une facture avec ce numéro");
}
else
{
int id_pf = get_max_id_pf() + 1;
fun.insert_into_factpf(id_clt.ToString(), etat, lookUpEdit1.Text, tnbcmd.Text, prixtotc.ToString("0.000"), timbre, tva.ToString(), int.Parse(tnumcommandebase.Text), textEdit1.Text);
for (int i = 0; i < gridView1.DataRowCount; i++)
{
DataRow row = gridView1.GetDataRow(i);
/*
* DataTable dat = new DataTable();
* dat = fun.get_piececmdbynump(Convert.ToInt32(row[0]));
* Double quantiterestante = Convert.ToDouble(dat.Rows[0][12].ToString());
* Double qterst = Convert.ToDouble(dat.Rows[0][12].ToString()) - Convert.ToDouble(row[3].ToString());
* Double prremis = Convert.ToDouble(dat.Rows[0][7].ToString()) - Convert.ToDouble(row[7].ToString());
* prixtotc+=prremis;
* fun.update_qterestcommande(qterst.ToString(),row[0].ToString());
*
*/
tva = Convert.ToDouble(row[9].ToString().Replace('.', ','));
fun.insert_piecee_factpf(row[0].ToString(), row[1].ToString(), row[2].ToString(), row[3].ToString(), row[4].ToString(), row[5].ToString(), row[6].ToString(), id_pf.ToString(), row[8].ToString(), row[9].ToString(), row[10].ToString());
}
MessageBox.Show("Facture proformat ajoutée avec succées");
this.Close();
FacturePfReport report = new FacturePfReport(id_pf);
report.ShowPreviewDialog();
this.Close();
}
}
