//Rechercher une plante par id_plante
public List <Plainte> getPlanteById(String id_plante)
{
List <Plainte> plaintes = new List <Plainte>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM plainte where id_plainte like @x", cn);
sqlCommand.Parameters.Add("@x", "%" + id_plante + "%");
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
Plainte p = new Plainte();
p.IdPlainte = (String)reader["id_plainte"];
p.DateCreation = (DateTime)reader["date_creation"];
p.SignePlainte = (String)reader["signe_plainte"];
p.IdPlaignant = (int)reader["id_plaignant"];
p.Ville = (String)reader["ville"];
p.TypeTribunal = (String)reader["tribunal"];
p.TypePlaint = (String)reader["type_plainte"];
p.DateDepotPlainte = (DateTime)reader["date_depot_plainte"];
plaintes.Add(p);
}
cn.Close();
return(plaintes);
}
private void btnModif_Click(object sender, EventArgs e)
{
if (isvalidate())
{
PlaintesOperations op = new PlaintesOperations();
Plainte p = new Plainte();
p.IdPlainte = txb_num_pl.Text;
p.DateCreation = date_plai.Value;
//p.Decision = txtdecision.Text;
p.IdPlaignant = int.Parse(textBoxNumClient.Text);
p.Ville = cb_ville.Text;
p.SignePlainte = txb_symbole.Text;
p.TypeTribunal = comboBox_tribunal.Text;
p.TypePlaint = txb_genre_pl.Text;
//Console.WriteLine("Test1: "+p.DateCreation+" "+p.TypeTribunal);
// MessageBox.Show("Test1: " + p.DateCreation + " " + p.TypeTribunal);
op.updatePlainte(p);
op.deleteplainteParpLainte(p.IdPlainte);
foreach (Par_plaignant item in listBox1.Items)
{
PlainteParPlaignant ppp = new PlainteParPlaignant();
ppp.IdParPlaignant = item.IdParPlaignant;
ppp.IdPlainte = p.IdPlainte;
op.addPlainteParPlaignant(ppp);
}
history.AddHistory("شكاية", "تعديل", txb_num_pl.Text);
}
}
//getAllPlante return tous les Plaintes archiveé
public List <Plainte> getAllPlanteArchivé()
{
List <Plainte> plaintes = new List <Plainte>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("SELECT * FROM plainte where etat='archivé'", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
Plainte p = new Plainte();
p.Num_archive = (string)reader["num_archive"];
p.IdPlainte = (String)reader["id_plainte"];
p.DateCreation = (DateTime)reader["date_creation"];
p.SignePlainte = (String)reader["signe_plainte"];
p.IdPlaignant = (int)reader["id_plaignant"];
p.Ville = (String)reader["ville"];
p.TypeTribunal = (String)reader["tribunal"];
p.TypePlaint = (String)reader["type_plainte"];
p.DateDepotPlainte = (DateTime)reader["date_depot_plainte"];
plaintes.Add(p);
}
cn.Close();
return(plaintes);
}
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;
}
}
SqlConnection cn = connection.getConnection(); //Instanciation de la connection a partire d'une classe connection.
//addPlainte est une methode qui nous donne le droit d'ajouter des nouveaux planites
public void addPlainte(Plainte p)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("insert into plainte(id_plainte,date_creation,signe_plainte,id_plaignant,ville,tribunal,type_plainte,date_depot_plainte)values(@a,@datep,@e,@r,@t,@y,@typePlainte,@ddp)", cn);
SqlParameter p1 = new SqlParameter("@a", p.IdPlainte);
SqlParameter p8 = new SqlParameter("@datep", p.DateCreation);
SqlParameter p3 = new SqlParameter("@e", p.SignePlainte);
SqlParameter p4 = new SqlParameter("@r", p.IdPlaignant);
SqlParameter p5 = new SqlParameter("@t", p.Ville);
SqlParameter p6 = new SqlParameter("@y", p.TypeTribunal);
SqlParameter p7 = new SqlParameter("@typePlainte", p.TypePlaint);
SqlParameter p9 = new SqlParameter("@ddp", p.DateDepotPlainte);
cmd.Parameters.Add(p1);
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.Transaction = tx;
cmd.ExecuteNonQuery();
tx.Commit();
cn.Close();
MessageBox.Show("تمت الإضافة بنجاح");
}
catch (Exception e)
{
tx.Rollback();
MessageBox.Show(e.Message);
//Console.WriteLine(e.Message);
}
}
//Methode deletePlainte : pour supprimer des plaintes.
public void updatePlainte(Plainte p)
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlTransaction tx = cn.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("update plainte set date_creation=@d,signe_plainte=@e,id_plaignant=@r,ville=@t,tribunal=@y,date_depot_plainte=@dd where id_plainte=@a", cn);
SqlParameter p0 = new SqlParameter("@d", p.DateCreation);
SqlParameter p1 = new SqlParameter("@a", p.IdPlainte);
SqlParameter p3 = new SqlParameter("@e", p.SignePlainte);
SqlParameter p4 = new SqlParameter("@r", p.IdPlaignant);
SqlParameter p5 = new SqlParameter("@t", p.Ville);
SqlParameter p6 = new SqlParameter("@y", p.TypeTribunal);
SqlParameter p7 = new SqlParameter("@dd", p.DateDepotPlainte);
cmd.Parameters.Add(p0);
cmd.Parameters.Add(p1);
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);
}
}
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;
}
private void btn_ajouter_Click(object sender, EventArgs e)
{
if (isvalidate())
{
PlaintesOperations op = new PlaintesOperations();
Plainte p = new Plainte();
p.IdPlainte = txb_num_pl.Text;
p.DateCreation = date_plai.Value;
p.DateDepotPlainte = date_depot_plainte.Value;
//p.Decision = txtdecision.Text;
p.IdPlaignant = int.Parse(textBoxNumClient.Text);
p.Ville = cb_ville.Text;
p.SignePlainte = txb_symbole.Text;
p.TypeTribunal = comboBox_tribunal.Text;
p.TypePlaint = txb_genre_pl.Text;
//Console.WriteLine("Test1: "+p.DateCreation+" "+p.TypeTribunal);
// MessageBox.Show("Test1: " + p.DateCreation + " " + p.TypeTribunal);
op.addPlainte(p);
Decision d = new Decision();
d.Decision1 = "فتح الملف";
d.Id_plainte = p.IdPlainte;
op.addDecisionPlainte(d);
foreach (Par_plaignant item in listBox1.Items)
{
PlainteParPlaignant ppp = new PlainteParPlaignant();
ppp.IdParPlaignant = item.IdParPlaignant;
ppp.IdPlainte = p.IdPlainte;
op.addPlainteParPlaignant(ppp);
}
//save PJ setup
if (u == 1)
{
foreach (string fileName in of.FileNames)
{
try
{
FileInfo fi = new FileInfo(fileName);
PjPlainte pjplaint = new PjPlainte();
byte[] img = null;
FileStream f = new FileStream(of.FileName, FileMode.Open);
BinaryReader br = new BinaryReader(f);
img = br.ReadBytes((int)f.Length);
f.Close();
pjplaint.Id_plainte = p.IdPlainte;
pjplaint.Photo = img;
pjplaint.Titre = Path.GetFileName(of.FileName);
pjplaint.Date_enregistrement = date_plai.Value;
// pjOrder1.id_order = ord.id_order;
op.addPjPalainte(pjplaint);
history.AddHistory("شكاية", "اضافة", txb_num_pl.Text);
}
catch (Exception ex)
{
MessageBox.Show("Error: Could not read file from disk. Original error: " + ex.Message);
}
}
u = 0;
}
}
else
{
MessageBox.Show("أحد الحقول فارغة أو المعلومات خاطئة");
}
}
