// // //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); }