private void edit_button_Click(object sender, EventArgs e)
{
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cause ca = new cause();
Session se = new Session();
ca.Id_client = int.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
ca.Id_adv = int.Parse(dataGridView2.SelectedRows[0].Cells[0].Value.ToString());
ca.Id_cause = txtMarjiaCause1.Text;
ca.Date_session = dateTimePickeDateCause.Value;
ca.Nom_avocat = textBoxCauseProfMoukalaf.Text;
ca.Signe_cause = txt_signe_cause.Text;
ca.Type_cause = txt_type_cause.Text;
ca.Juge = txt_juge.Text;
ca.Avocat_adversaire = txt_avocat_adversaire.Text;
ca.Type_tribunal = comboBoxTypeTribunal.Text;
ca.Ville = comboBoxVilleCause.Text;
ca.Num_cause_tribunal = txtNumCause.Text;
ca.Poursuite = cb_porsuit.Text;
ca.Commisaire_judiciaire = txt_commisaire_judiciaire.Text;
ca.Appel = cb_appel.Text;
ca.Duree = (int)txt_duree.Value;
co.updateCause(ca);
this.abc();
//this.fm_Refresh_gv();
history.AddHistory(" الموضوع", "التعديل", txtMarjiaCause1.Text);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//update cause
public void updateCause(cause c)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("update cause set date_session=@a,id_client=@z,nom_avocat=@e,juge=@r,signe_cause=@t,type_cause=@y,avocat_adv=@u,tribunal=@i,id_adv=@o,poursuite=@p,ville=@q,num_cause_tribunal=@s,commisaire_judiciaire=@d,appel=@f,duree=@h where id_cause=@x", cn);
SqlParameter c1 = new SqlParameter("@a", c.Date_session);
SqlParameter c2 = new SqlParameter("@z", c.Id_client);
SqlParameter c3 = new SqlParameter("@e", c.Nom_avocat);
SqlParameter c4 = new SqlParameter("@r", c.Juge);
SqlParameter c5 = new SqlParameter("@t", c.Signe_cause);
SqlParameter c6 = new SqlParameter("@y", c.Type_cause);
SqlParameter c7 = new SqlParameter("@u", c.Avocat_adversaire);
SqlParameter c8 = new SqlParameter("@i", c.Type_tribunal);
SqlParameter c9 = new SqlParameter("@o", c.Id_adv);
SqlParameter c10 = new SqlParameter("@p", c.Poursuite);
SqlParameter c11 = new SqlParameter("@q", c.Ville);
SqlParameter c12 = new SqlParameter("@s", c.Num_cause_tribunal);
SqlParameter c13 = new SqlParameter("@d", c.Commisaire_judiciaire);
SqlParameter c14 = new SqlParameter("@f", c.Appel);
SqlParameter c16 = new SqlParameter("@h", c.Duree);
SqlParameter c15 = new SqlParameter("@x", c.Id_cause);
cmd.Parameters.Add(c1);
cmd.Parameters.Add(c2);
cmd.Parameters.Add(c3);
cmd.Parameters.Add(c4);
cmd.Parameters.Add(c5);
cmd.Parameters.Add(c6);
cmd.Parameters.Add(c7);
cmd.Parameters.Add(c8);
cmd.Parameters.Add(c9);
cmd.Parameters.Add(c10);
cmd.Parameters.Add(c11);
cmd.Parameters.Add(c12);
cmd.Parameters.Add(c13);
cmd.Parameters.Add(c14);
cmd.Parameters.Add(c15);
cmd.Parameters.Add(c16);
cmd.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
//MessageBox.Show("تم التعديل بنجاح ");
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("تم التعديل بنجاح", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
}
}
public void add_cause(cause ca, Session se)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand Command = new SqlCommand("SELECT * FROM cause where id_cause='" + ca.Id_cause + "'", cn);
SqlDataReader reader1 = Command.ExecuteReader();
Command.Dispose();
if (reader1.HasRows)
{
//MessageBox.Show("existe dans base donnée");
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("هده القضية متواجدة في سجل البيانات", "تنبيه", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
else
{
Command.Dispose();
reader1.Close();
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into cause(id_cause,date_session,date_creation,id_client,nom_avocat,juge,signe_cause,type_cause,avocat_adv,tribunal,id_adv,poursuite,ville,num_cause_tribunal,commisaire_judiciaire,appel,duree,total_paiement,etat)values(@a,@z,getdate(),@e,@r,@t,@y,@u,@i,@o,@p,@q,@s,@d,@f,@g,@h,@n,'non archivé')", cn);
SqlCommand cm1 = new SqlCommand("insert into sessione(date_session,id_cause,decision)values(@w,@x,@c)", cn);
SqlParameter p0 = new SqlParameter("@a", ca.Id_cause);
SqlParameter p1 = new SqlParameter("@z", ca.Date_session);
SqlParameter p2 = new SqlParameter("@e", ca.Id_client);
SqlParameter p3 = new SqlParameter("@r", ca.Nom_avocat);
SqlParameter p4 = new SqlParameter("@t", ca.Juge);
SqlParameter p5 = new SqlParameter("@y", ca.Signe_cause);
SqlParameter p6 = new SqlParameter("@u", ca.Type_cause);
SqlParameter p7 = new SqlParameter("@i", ca.Avocat_adversaire);
SqlParameter p8 = new SqlParameter("@o", ca.Type_tribunal);
SqlParameter p9 = new SqlParameter("@p", ca.Id_adv);
SqlParameter p10 = new SqlParameter("@q", ca.Poursuite);
SqlParameter p11 = new SqlParameter("@s", ca.Ville);
SqlParameter p12 = new SqlParameter("@d", ca.Num_cause_tribunal);
SqlParameter p13 = new SqlParameter("@f", ca.Commisaire_judiciaire);
SqlParameter p14 = new SqlParameter("@g", ca.Appel);
SqlParameter p18 = new SqlParameter("@h", ca.Duree);
SqlParameter p19 = new SqlParameter("@n", ca.Montant);
//SqlParameter p20 = new SqlParameter("@b", ca.Montant);
//SqlParameter p20 = new SqlParameter("@v", "getdate()");
SqlParameter p15 = new SqlParameter("@w", se.Date_session);
SqlParameter p16 = new SqlParameter("@x", se.Id_cause);
SqlParameter p17 = new SqlParameter("@c", se.Decision);
cmd.Parameters.Add(p0);
cmd.Parameters.Add(p1);
cmd.Parameters.Add(p2);
cmd.Parameters.Add(p3);
cmd.Parameters.Add(p4);
cmd.Parameters.Add(p5);
cmd.Parameters.Add(p6);
cmd.Parameters.Add(p7);
cmd.Parameters.Add(p8);
cmd.Parameters.Add(p9);
cmd.Parameters.Add(p10);
cmd.Parameters.Add(p11);
cmd.Parameters.Add(p12);
cmd.Parameters.Add(p13);
cmd.Parameters.Add(p14);
cmd.Parameters.Add(p18);
cmd.Parameters.Add(p19);
// cmd.Parameters.Add(p20);
cm1.Parameters.Add(p15);
cm1.Parameters.Add(p16);
cm1.Parameters.Add(p17);
cmd.Transaction = tx;
cm1.Transaction = tx;
cmd.ExecuteNonQuery();
cm1.ExecuteNonQuery();
tx.Commit();
//MessageBox.Show("تمت الإضافة بنجاح");
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("تمت الإضافة بنجاح", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
}
}
cn.Close();
}
private void simpleButtonAjouterCause_Click(object sender, EventArgs e)
{
bool x = IsNumeric(txt_duree.Text);
co = new Cause_Operations();
if (txtMarjiaCause1.Text == "" || comboBoxTypeTribunal.Text == "" || comboBoxVilleCause.Text == "" || textBoxNomClient.Text == "" || textBoxNomAdv.Text == "")
{
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("يجب ادخال المعلومات الضرورية", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
else
{
try
{
//MessageBox.Show( txt_duree.Value.ToString());
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
cause ca = new cause();
Session se = new Session();
ca.Id_client = int.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
ca.Id_adv = int.Parse(dataGridView2.SelectedRows[0].Cells[0].Value.ToString());
ca.Id_cause = txtMarjiaCause1.Text;
ca.Date_session = dateTimePickeDateCause.Value;
ca.Nom_avocat = textBoxCauseProfMoukalaf.Text;
ca.Signe_cause = txt_signe_cause.Text;
ca.Type_cause = txt_type_cause.Text;
ca.Juge = txt_juge.Text;
ca.Avocat_adversaire = txt_avocat_adversaire.Text;
ca.Type_tribunal = comboBoxTypeTribunal.Text;
ca.Ville = comboBoxVilleCause.Text;
ca.Num_cause_tribunal = txtNumCause.Text;
ca.Poursuite = cb_porsuit.Text;
ca.Commisaire_judiciaire = txt_commisaire_judiciaire.Text;
ca.Appel = cb_appel.Text;
ca.Duree = int.Parse(txt_duree.Text);
if (txt_montant.Text != "")
{
ca.Montant = float.Parse(txt_montant.Text);
}
else
{
}
se.Date_session = dateTimePickeDateCause.Value;
se.Id_cause = txtMarjiaCause1.Text;
se.Decision = "اول جلسة";
co.add_cause(ca, se);
if (u == 1)
{
foreach (string fileName in of.FileNames)
{
try
{
FileInfo fi = new FileInfo(fileName);
PJ_cause pjCause = new PJ_cause();
byte[] img = null;
FileStream f = new FileStream(of.FileName, FileMode.Open);
BinaryReader br = new BinaryReader(f);
img = br.ReadBytes((int)f.Length);
f.Close();
pjCause.Id_cause = ca.Id_cause;
pjCause.Photo = img;
pjCause.Titre = Path.GetFileName(of.FileName);
pjCause.Date_enregistrement = dateTimePickeDateCause.Value;
// listBox1.Items.Add(pjCause.Titre);
co.add_piece_jointe_cause(pjCause);
}
catch (Exception ex)
{
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
}
}
u = 0;
}
history.AddHistory(" الموضوع", "الاضافة", txtMarjiaCause1.Text);
//
cn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
