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); } } }