//chercher un parplaignant par id_par_plaignant ou cin
public List <Par_plaignant> getParPlaignantByIdAndCIN(String mc)
{
List <Par_plaignant> parplaignants = new List <Par_plaignant>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM par_plaignant where id_par_plaignant like @x or cin like @z", cn);
sqlCommand.Parameters.Add("@x", "%" + mc + "%");
sqlCommand.Parameters.Add("@z", "%" + mc + "%");
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
Par_plaignant p = new Par_plaignant();
p.IdParPlaignant = (int)reader["id_par_plaignant"];
p.TypeParPlaignant = (String)reader["type_par_plaignant"];
p.Cin = (String)reader["cin"];
p.Nom = (String)reader["nom"];
p.RepresentantLegal = (String)reader["representant_legal"];
p.RegistreDeCommerce1 = (String)reader["registre_commerce"];
p.Adresse = (String)reader["adresse"];
parplaignants.Add(p);
}
cn.Close();
return(parplaignants);
}
private void button1_Click(object sender, EventArgs e)
{
int i = 0;
List <DataGridViewRow> rows_with_checked_column = new List <DataGridViewRow>();
foreach (DataGridViewRow row in dataGridParPlaignant.Rows)
{
// MessageBox.Show(row.Cells[Column11.Name].Value.ToString());
if (row.Cells[Column11.Name].Value == null)
{
}
else
{
if (row.Cells[Column11.Name].Value.ToString() == "True")
{
Par_plaignant pp = new Par_plaignant();
pp.IdParPlaignant = int.Parse(row.Cells[Column6.Name].Value.ToString());
pp.Nom = row.Cells[Column7.Name].Value.ToString();
if (isexist(pp))
{
}
else
{
listBox1.Items.Add(pp);
}
i++;
}
}
}
}
//getAllParpLaignant return tous les plaignant
public List <Par_plaignant> getAllParPlaignant()
{
List <Par_plaignant> parplaignants = new List <Par_plaignant>();
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM par_plaignant", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
Par_plaignant p = new Par_plaignant();
p.IdParPlaignant = (int)reader["id_par_plaignant"];
p.TypeParPlaignant = (String)reader["type_par_plaignant"];
p.Cin = (String)reader["cin"];
p.Nom = (String)reader["nom"];
p.RepresentantLegal = (String)reader["representant_legal"];
p.RegistreDeCommerce1 = (String)reader["registre_commerce"];
p.Adresse = (String)reader["adresse"];
parplaignants.Add(p);
}
cn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(parplaignants);
}
private List <Par_plaignant> getParplaintes(List <PlainteParPlaignant> ppp)
{
List <Par_plaignant> parplains = new List <Par_plaignant>();
foreach (PlainteParPlaignant item in ppp)
{
Par_plaignant pp = op.getParPlaignantByIdAndCIN(item.IdParPlaignant.ToString()).First();
parplains.Add(pp);
}
return(parplains);
}
private void simpleButton4_Click(object sender, EventArgs e)
{
Par_plaignant pp = new Par_plaignant();
pp.IdParPlaignant = int.Parse(dataGridView1.SelectedRows[0].Cells[0].Value.ToString());
pp.Cin = txb_cin.Text;
pp.Nom = txb_name.Text;
pp.RegistreDeCommerce1 = txb_num_societe.Text;
pp.RepresentantLegal = txb_juridique.Text;
pp.Adresse = txb_adresse.Text;
// pp.TypeParPlaignant=cb_genre_plai.selectedItem
pp.TypeParPlaignant = cb_genre_plai.SelectedItem.ToString();
op.updateParPlaignant(pp);
getDataTable();
chikaya.getDataTableParPlaignant();
history.AddHistory("المشتكون بهم", "التعديل", txb_cin.Text);
}
private Boolean isexist(Par_plaignant pp)
{
Boolean b = false;
foreach (Par_plaignant item in listBox1.Items)
{
if (item.IdParPlaignant == pp.IdParPlaignant)
{
b = true;
break;
}
else
{
b = false;
}
}
return(b);
}
//Methode update : pour supprimer des plaintes.
public void updateParPlaignant(Par_plaignant p)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("update par_plaignant set type_par_plaignant=@d,cin=@z,nom=@e,representant_legal=@r,registre_commerce=@t,adresse=@y where id_par_plaignant=@a", cn);
SqlParameter p0 = new SqlParameter("@a", p.IdParPlaignant);
SqlParameter p1 = new SqlParameter("@d", p.TypeParPlaignant);
SqlParameter p2 = new SqlParameter("@z", p.Cin);
SqlParameter p3 = new SqlParameter("@e", p.Nom);
SqlParameter p4 = new SqlParameter("@r", p.RepresentantLegal);
SqlParameter p5 = new SqlParameter("@t", p.RegistreDeCommerce1);
SqlParameter p6 = new SqlParameter("@y", p.Adresse);
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.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
MessageBox.Show("تم التعديل بنجاح ");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
//Console.WriteLine(e.Message);
}
}
/*
*
* partie de par_plaignats
*
*/
public void addParPlaignant(Par_plaignant p)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into par_plaignant(type_par_plaignant,cin,nom,representant_legal,registre_commerce,adresse)values(@b,@z,@e,@r,@t,@y)", cn);
SqlParameter p1 = new SqlParameter("@b", p.TypeParPlaignant);
SqlParameter p2 = new SqlParameter("@z", p.Cin);
SqlParameter p3 = new SqlParameter("@e", p.Nom);
SqlParameter p4 = new SqlParameter("@r", p.RepresentantLegal);
SqlParameter p5 = new SqlParameter("@t", p.RegistreDeCommerce1);
SqlParameter p6 = new SqlParameter("@y", p.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.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
MessageBox.Show("تمت الإضافة بنجاح");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
//Console.WriteLine(e.Message);
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
if (cb_genre_plai.Text == "" || txb_name.Text == "")
{
MessageBox.Show("المرجو ملا الخانات");
}
else
{
Par_plaignant pp = new Par_plaignant();
pp.Cin = txb_cin.Text;
pp.Nom = txb_name.Text;
pp.RegistreDeCommerce1 = txb_num_societe.Text;
pp.RepresentantLegal = txb_juridique.Text;
pp.Adresse = txb_adresse.Text;
// pp.TypeParPlaignant=cb_genre_plai.selectedItem
pp.TypeParPlaignant = cb_genre_plai.SelectedItem.ToString();
op.addParPlaignant(pp);
chikaya.getDataTableParPlaignant();
getDataTable();
simpleButton1.Enabled = false;
history.AddHistory("المشتكون بهم", "الاضافة", txb_cin.Text);
}
}
private void dataGridPlaignant_DoubleClick(object sender, EventArgs e)
{
String idparplaignant = dataGridParPlaignant.SelectedRows[0].Cells[1].Value.ToString();
Par_plaignant p = op.getParPlaignantByIdAndCIN(idparplaignant).First();
}
