//getAllPlaignant return tous les palaignants
public List <Plaignant> getAllPlaignant()
{
List <Plaignant> plaignants = new List <Plaignant>();
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM plaignant", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
Plaignant p = new Plaignant();
p.IdPlaignant = (int)reader["id_plaignant"];
p.TypePlaignant = (String)reader["type_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"];
p.Telephone = (String)reader["telephone"];
plaignants.Add(p);
}
cn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(plaignants);
}
//chercher un plaignant par id ou CIN
public List <Plaignant> getPlaignantByCinAndId(String mc)
{
List <Plaignant> plaignants = new List <Plaignant>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM plaignant where id_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())
{
Plaignant p = new Plaignant();
p.IdPlaignant = (int)reader["id_plaignant"];
p.TypePlaignant = (String)reader["type_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"];
p.Telephone = (String)reader["telephone"];
plaignants.Add(p);
}
cn.Close();
return(plaignants);
}
private void simpleButton4_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows.Count != 0 && txb_name.Text != "")
{
Plaignant pp = new Plaignant();
pp.IdPlaignant = 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.Telephone = txb_tele.Text;
// pp.TypeParPlaignant=cb_genre_plai.selectedItem
pp.TypePlaignant = cb_genre_plai.SelectedItem.ToString();
op.updatePlaignant(pp);
getDataTable();
chikaya.getDataTablePlaignant();
history.AddHistory("المشتكون", "التعديل", txb_cin.Text);
clearText();
}
else
{
MessageBox.Show("يجب اختيار مشتكي");
}
}
private void dataGridPlaignant_Click(object sender, EventArgs e)
{
String idplaignant = dataGridPlaignant.SelectedRows[0].Cells[1].Value.ToString();
Plaignant p = op.getPlaignantByCinAndId(idplaignant).First();
comboBoxTypeClient.Text = p.TypePlaignant;
textBoxNumClient.Text = p.IdPlaignant.ToString();
textBoxNomClient.Text = p.Nom;
textBoxCINClient.Text = p.Cin;
textBoxTelClient.Text = p.Telephone;
textBoxMoumatilQanouniClient.Text = p.RepresentantLegal;
textBoxSijilTijariClient.Text = p.RegistreDeCommerce1;
textBoxAdresseClient.Text = p.Adresse;
}
private void dataGridView1_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow != null)
{
String idplainte = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
Plainte p = op.getPlanteById(idplainte).First();
Plaignant plaignant = op.getPlaignantByCinAndId(p.IdPlaignant.ToString()).First();
List <PlainteParPlaignant> ppp = op.getPlainteParPlaintes(p.IdPlainte);
dataGridView2.Rows.Clear();
foreach (var par in getParplaintes(ppp))
{
dataGridView2.Rows.Add(par.IdParPlaignant, par.Nom, par.TypeParPlaignant);
}
lblnom.Text = plaignant.Nom;
lbltype.Text = plaignant.TypePlaignant;
}
}
//Methode updatePlaignant : pour modifier des plaignants.
public void updatePlaignant(Plaignant p)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("update plaignant set type_plaignant=@d,cin=@z,nom=@e,telephone=@k,representant_legal=@r,registre_commerce=@t,adresse=@y where id_plaignant=@a", cn);
SqlParameter p0 = new SqlParameter("@a", p.IdPlaignant);
SqlParameter p1 = new SqlParameter("@d", p.TypePlaignant);
SqlParameter p7 = new SqlParameter("@k", p.Telephone);
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.Parameters.Add(p7);
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 plaignats
*
*/
public void addPlaignant(Plaignant p)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into plaignant(type_plaignant,cin,nom,telephone,representant_legal,registre_commerce,adresse)values(@b,@z,@e,@k,@r,@t,@y)", cn);
SqlParameter p1 = new SqlParameter("@b", p.TypePlaignant);
SqlParameter p7 = new SqlParameter("@k", p.Telephone);
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.Parameters.Add(p7);
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
{
Plaignant pp = new 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.Telephone = txb_tele.Text;
// pp.TypeParPlaignant=cb_genre_plai.selectedItem
pp.TypePlaignant = cb_genre_plai.SelectedItem.ToString();
op.addPlaignant(pp);
chikaya.getDataTablePlaignant();
getDataTable();
history.AddHistory("المشتكون", "الاضافة", txb_cin.Text);
}
}
public شكاية(String idplainte)
{
of = new OpenFileDialog();
op = new PlaintesOperations();
listpar = new List <Par_plaignant>();
this.idplainte = idplainte;
Plainte p = op.getPlanteById(this.idplainte).First();
Plaignant plaignant = op.getPlaignantByCinAndId(p.IdPlaignant.ToString()).First();
List <PlainteParPlaignant> ppp = op.getPlainteParPlaintes(p.IdPlainte);
InitializeComponent();
// dataGridParPlaignant.Rows.Clear();
foreach (var pp in getParplaintes(ppp))
{
//dataGridParPlaignant.Rows.Add(pp.TypeParPlaignant, pp.IdParPlaignant, pp.Nom, pp.RegistreDeCommerce1, pp.Cin, pp.Adresse);
listBox1.Items.Add(pp);
}
setDataListbox(p.IdPlainte);
comboBoxTypeClient.Text = plaignant.TypePlaignant;
textBoxNumClient.Text = plaignant.IdPlaignant.ToString();
textBoxNomClient.Text = plaignant.Nom;
textBoxCINClient.Text = plaignant.Cin;
textBoxTelClient.Text = plaignant.Telephone;
textBoxMoumatilQanouniClient.Text = plaignant.RepresentantLegal;
textBoxSijilTijariClient.Text = plaignant.RegistreDeCommerce1;
textBoxAdresseClient.Text = plaignant.Adresse;
txb_num_pl.Text = p.IdPlainte;
date_plai.Text = p.DateCreation.ToString();
date_depot_plainte.Text = p.DateDepotPlainte.ToString();
//p.Decision = txtdecision.Text;
textBoxNumClient.Text = p.IdPlaignant.ToString();
cb_ville.Text = p.Ville;
txb_symbole.Text = p.SignePlainte;
comboBox_tribunal.Text = p.TypeTribunal;
txb_genre_pl.Text = p.TypePlaint;
}
