//
//
//search depot plainte
//
//
//
public List <depot_plaint> seardepot_plainte(string id)
{
List <depot_plaint> cc = new List <depot_plaint>();
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("select dc.id_depot,dc.id_plainte,cc.nom,ad.nom as[nom_adv],dc.num_check,dc.montant from depot_plgn dc,plaignant cc,par_plaignant ad where dc.id_plainte like '" + id + "%' and dc.id_par_plaignant=ad.id_par_plaignant and dc.id_plaignant=cc.id_plaignant", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
depot_plaint c = new depot_plaint();
c.Id_depot = (int)reader["id_depot"];
c.Id_plainte = (string)reader["id_plainte"];
c.Nom = (string)reader["nom"];
c.Nom_adv = (string)reader["nom_adv"];
c.Num_check = (int)reader["num_check"];
c.Montant = float.Parse(reader["montant"].ToString());
cc.Add(c);
}
cn.Close();
return(cc);
}
//
//
//get all depot_plainte
//
public List <depot_plaint> get_depot_plainte()
{
List <depot_plaint> depot_plaint = new List <depot_plaint>();
try
{
if (cn.State == ConnectionState.Closed)
{
cn.Open();
}
SqlCommand sqlCommand = new SqlCommand("select dp.id_depot,dp.id_plainte,p.nom,pp.nom as [nom_adv],dp.num_check,dp.montant from depot_plgn dp,plaignant p ,par_plaignant pp where p.id_plaignant=dp.id_plaignant and pp.id_par_plaignant=dp.id_par_plaignant", cn);
SqlDataReader reader = sqlCommand.ExecuteReader();
while (reader.Read())
{
depot_plaint p = new depot_plaint();
p.Id_depot = (int)reader["id_depot"];
p.Id_plainte = (String)reader["id_plainte"];
p.Nom = (String)reader["nom"];
p.Nom_adv = (String)reader["nom_adv"];
p.Num_check = (int)reader["num_check"];
p.Montant = float.Parse(reader["montant"].ToString());
depot_plaint.Add(p);
}
cn.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
return(depot_plaint);
}
