private void btn_edit_Click(object sender, EventArgs e)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
adversaire_cause cc = new adversaire_cause();
if (txb_cin.Text == "" && txb_num_societe.Text == "")
{
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("يجب إختيار السجل المراد تعديله", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
//MessageBox.Show("يجب إختيار السجل المراد تعديله");
}
else
{
cc.Id_adv_cause = int.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
cc.Type_adversaire = CB_genre_Adv.Text;
cc.Cin = txb_cin.Text;
cc.Nom = txb_name.Text;
cc.Adjoint = txt_adjoint.Text;
cc.Representant_legal = txb_juridique.Text;
cc.Registre_commerce = txb_num_societe.Text;
cc.Adresse = txb_adresse.Text;
co.update_adversaire_cause(cc);
getDataTable();
ma.getDataTable();
vider_champ();
}
history.AddHistory(" ادارة الخصوم", "التعديل", txb_name.Text);
cn.Close();
}
//search adversaire cause
public List <adversaire_cause> searchAdversaire_cause(string id)
{
List <adversaire_cause> adv = new List <adversaire_cause>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM adversaire_cause where cin_adv like'" + id + "%' or registre_commerce_adv like'" + id + "%' or nom_adv like'" + id + "%'", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
adversaire_cause c = new adversaire_cause();
c.Id_adv_cause = (int)reader["id_adversaire_cause"];
c.Type_adversaire = (string)reader["type_adv"];
c.Cin = (string)reader["cin_adv"];
c.Nom = (string)reader["nom_adv"];
c.Adjoint = (string)reader["adjoint_adv"];
c.Representant_legal = (string)reader["representant_legal_adv"];
c.Registre_commerce = (string)reader["registre_commerce_adv"];
c.Adresse = (string)reader["adresse_adv"];
adv.Add(c);
}
cn.Close();
return(adv);
}
//update adversaire cause
public void update_adversaire_cause(adversaire_cause cc)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("update adversaire_cause set type_adv=@a,nom_adv=@e,representant_legal_adv=@r,adjoint_adv=@f,adresse_adv=@y,cin_adv=@x,registre_commerce_adv=@t where id_adversaire_cause=@m", cn);
SqlParameter c0 = new SqlParameter("@m", cc.Id_adv_cause);
SqlParameter c1 = new SqlParameter("@a", cc.Type_adversaire);
SqlParameter c2 = new SqlParameter("@x", cc.Cin);
SqlParameter c3 = new SqlParameter("@e", cc.Nom);
SqlParameter c4 = new SqlParameter("@f", cc.Adjoint);
SqlParameter c5 = new SqlParameter("@r", cc.Representant_legal);
SqlParameter c6 = new SqlParameter("@t", cc.Registre_commerce);
SqlParameter c7 = new SqlParameter("@y", cc.Adresse);
cmd.Parameters.Add(c0);
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.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("تم التعديل بنجاح", "تنبيه", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
// MessageBox.Show("تم التعديل بنجاح ");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
}
}
//
//
//adversaire cause
//
//
//add adversaire cause
public void add_adversaire_cause(adversaire_cause c)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into adversaire_cause(type_adv,cin_adv,nom_adv,adjoint_adv,representant_legal_adv,registre_commerce_adv,adresse_adv)values(@b,@z,@e,@r,@t,@y,@u)", cn);
SqlParameter p1 = new SqlParameter("@b", c.Type_adversaire);
SqlParameter p2 = new SqlParameter("@z", c.Cin);
SqlParameter p3 = new SqlParameter("@e", c.Nom);
SqlParameter p4 = new SqlParameter("@r", c.Adjoint);
SqlParameter p5 = new SqlParameter("@t", c.Representant_legal);
SqlParameter p6 = new SqlParameter("@y", c.Registre_commerce);
SqlParameter p7 = new SqlParameter("@u", c.Adresse);
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.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("تمت الإضافة بنجاح", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
}
}
private void btn_ajouter_Click(object sender, EventArgs e)
{
try
{
if (CB_genre_Adv.Text == "")
{
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("المرجو ملئ جميع الحقول", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
else
{
if (CB_genre_Adv.Text == "معنوي" && (txb_name.Text == "" || txb_adresse.Text == "" || txt_adjoint.Text == "" || txb_num_societe.Text == ""))
{
//MessageBox.Show("المرجو ملئ الحقل المخصص لالسجل التجاري و الممثل القانوني ");
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("المرجو ملئ جميع الحقول", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
else
{
if (CB_genre_Adv.Text == "طبيعي" && (txb_cin.Text == "" || txb_name.Text == "" || txb_adresse.Text == ""))
{
//MessageBox.Show("المرجو ملئ الحقل المخصص لرقم البطاقة الوطنية ");
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("المرجو ملئ الحقل المخصص لرقم البطاقة الوطنية", "تنبيه", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
else
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
adversaire_cause c = new adversaire_cause();
c.Type_adversaire = CB_genre_Adv.Text;
c.Cin = txb_cin.Text;
c.Adjoint = txt_adjoint.Text;
c.Nom = txb_name.Text;
c.Representant_legal = txb_juridique.Text;
c.Registre_commerce = txb_num_societe.Text;
c.Adresse = txb_adresse.Text;
co.add_adversaire_cause(c);
getDataTable();
ma.getDataTable1();
history.AddHistory(" ادارة الخصوم", "الاضافة", txb_name.Text);
cn.Close();
btn_ajouter.Enabled = false;
}
}
}
}
catch (Exception)
{
throw;
}
}
