//search client cause
public List <client_cause> searchclient_cause(string id)
{
List <client_cause> cc = new List <client_cause>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM client_cause where cin like'" + id + "%' or registre_commerce like'" + id + "%' or nom like'" + id + "%'", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
client_cause c = new client_cause();
c.Id_client_cause = (int)reader["id_client_cause"];
c.Type_client = (string)reader["type_client"];
c.Cin = (string)reader["cin"];
c.Nom = (string)reader["nom"];
c.Telephone = (string)reader["telephone"];
c.Representant_legal = (string)reader["representant_legal"];
c.Registre_commerce = (string)reader["registre_commerce"];
c.Adresse = (string)reader["adresse"];
cc.Add(c);
}
cn.Close();
return(cc);
}
//all client cause
public List <client_cause> getAllClients_cause()
{
List <client_cause> cc = new List <client_cause>();
if (cn.State == System.Data.ConnectionState.Closed)
{
cn.Open();
}
//cn.Open();
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM client_cause", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
client_cause c = new client_cause();
c.Id_client_cause = (int)reader["id_client_cause"];
c.Type_client = (string)reader["type_client"];
c.Cin = (string)reader["cin"];
c.Nom = (string)reader["nom"];
c.Telephone = (string)reader["telephone"];
c.Representant_legal = (string)reader["representant_legal"];
c.Registre_commerce = (string)reader["registre_commerce"];
c.Adresse = (string)reader["adresse"];
cc.Add(c);
}
reader.Close();
cn.Close();
return(cc);
}
private void btn_ajouter_Click(object sender, EventArgs e)
{
try
{
if (txb_name.Text == "")
{
MessageBoxManager.OK = "حسنا";
MessageBoxManager.Register();
DialogResult dr = MessageBox.Show("المرجو ملئ الحقل المخصص بالاسم", "", MessageBoxButtons.OK);
MessageBoxManager.Unregister();
}
//else
//{
// if (txb_genre_client.Text == "معنوي" && txb_juridique.Text == "" && txb_num_societe.Text == "" && txb_name.Text=="" && txb_tele.Text=="" && txb_adresse.Text=="")
// {
// // MessageBox.Show("المرجو ملئ الحقل المخصص لالسجل التجاري و الممثل القانوني ");
// MessageBoxManager.OK = "حسنا";
// MessageBoxManager.Register();
// DialogResult dr = MessageBox.Show("المرجو ملئ جميع الحقول", "", MessageBoxButtons.OK);
// MessageBoxManager.Unregister();
// }
// else
// {
// if (txb_genre_client.Text == "طبيعي" && (txb_cin.Text == "" || txb_name.Text=="" || txb_tele.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();
}
client_cause c = new client_cause();
c.Type_client = txb_genre_client.Text;
c.Cin = txb_cin.Text;
c.Nom = txb_name.Text;
c.Telephone = txb_tele.Text;
c.Representant_legal = txb_juridique.Text;
c.Registre_commerce = txb_num_societe.Text;
c.Adresse = txb_adresse.Text;
co.add_client_cause(c);
getDataTable();
ma.getDataTable();
cn.Close();
btn_ajouter.Enabled = false;
}
history.AddHistory(" ادارة الموكلين", "الاضافة", txb_cin.Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//update client cause
public void update_client_cause(client_cause cc)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("update client_cause set type_client=@a,nom=@e,telephone=@r,representant_legal=@t,adresse=@u,registre_commerce=@x,cin=@z where id_client_cause=@m", cn);
SqlParameter c0 = new SqlParameter("@m", cc.Id_client_cause);
SqlParameter c1 = new SqlParameter("@a", cc.Type_client);
SqlParameter c2 = new SqlParameter("@z", cc.Cin);
SqlParameter c3 = new SqlParameter("@e", cc.Nom);
SqlParameter c4 = new SqlParameter("@r", cc.Telephone);
SqlParameter c5 = new SqlParameter("@t", cc.Representant_legal);
SqlParameter c6 = new SqlParameter("@x", cc.Registre_commerce);
SqlParameter c7 = new SqlParameter("@u", 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);
}
}
//
//
//client cause
//
//
//add client cause
public void add_client_cause(client_cause c)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into client_cause(type_client,cin,nom,telephone,representant_legal,registre_commerce,adresse)values(@b,@z,@e,@r,@t,@y,@u)", cn);
SqlParameter p1 = new SqlParameter("@b", c.Type_client);
SqlParameter p2 = new SqlParameter("@z", c.Cin);
SqlParameter p3 = new SqlParameter("@e", c.Nom);
SqlParameter p4 = new SqlParameter("@r", c.Telephone);
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();
//MessageBox.Show("تمت الإضافة بنجاح");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
//Console.WriteLine(e.Message);
}
}
private void btn_edit_Click(object sender, EventArgs e)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
client_cause cc = new client_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_client_cause = int.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
cc.Type_client = txb_genre_client.Text;
cc.Cin = txb_cin.Text;
cc.Nom = txb_name.Text;
cc.Telephone = txb_tele.Text;
cc.Representant_legal = txb_juridique.Text;
cc.Registre_commerce = txb_num_societe.Text;
cc.Adresse = txb_adresse.Text;
co.update_client_cause(cc);
getDataTable();
ma.getDataTable();
vider_champ();
history.AddHistory(" ادارة الموكلين", "التعديل", txb_cin.Text);
cn.Close();
}
}
