public List <DemandeService> GetDemandesEnCoursBeneficiaire(int idUtilisateur) { SqlConnection cnx = new SqlConnection(); cnx.ConnectionString = connStr; cnx.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnx; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "dbo.GetInfosDemandesEnCoursBeneficiaire"; SqlParameter idUtilisateurPara = new SqlParameter("@IdUtilisateur", idUtilisateur); cmd.Parameters.Add(idUtilisateurPara); SqlDataReader dr = cmd.ExecuteReader(); List <DemandeService> listeDemandes = new List <DemandeService>(); if (dr.HasRows) { while (dr.Read()) { DemandeService demande = new DemandeService((DateTime)dr["date_realisation"], (string)dr["adresse_realisation"], (string)dr["code_postal"], (string)dr["libelle_ville"], (string)dr["libelle_type_service"], (string)dr["nom"] + " " + dr["prenom"], (int)dr["id_demande"]); listeDemandes.Add(demande); } } cnx.Close(); return(listeDemandes); }
public void RechercherParType(int type) { SqlConnection cnx = new SqlConnection(); cnx.ConnectionString = connStr; cnx.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnx; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "SELECT id_emetteur,date_enregistrement,date_realisation,adresse_realisation,id_ville,id_type_service FROM demande_service where id_type_service = @id_type "; cmd.CommandType = System.Data.CommandType.Text; SqlDataReader dr = cmd.ExecuteReader(); List <DemandeService> listeParType = new List <DemandeService>(); if (dr.HasRows) { while (dr.Read()) { DemandeService demande = new DemandeService((int)dr["id_emetteur"]); demande.IdDemande = (int)dr["id_demande"]; demande.DateEnregistrement = (DateTime)dr["date_enregistrement"]; demande.DateRealisation = (DateTime)dr["date_realisation"]; if (dr["adresse_realisation"] != DBNull.Value) { demande.AdresseRealisation = (string)dr["adresse_realisation"]; } if (dr["id_ville"] != DBNull.Value) { demande.VilleRealisation = (int)dr["id_ville"]; } demande.IdTypeService = (int)dr["id_type_service"]; if (dr["date_annulation"] != DBNull.Value) { demande.DateAnnulation = (DateTime)dr["date_annulation"]; } if (dr["date_cloture"] != DBNull.Value) { demande.DateCloture = (DateTime)dr["date_cloture"]; } listeParType.Add(demande); } } cnx.Close(); }
public List <DemandeService> AfficherDemandes() { SqlConnection cnx = new SqlConnection(); cnx.ConnectionString = connStr; cnx.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnx; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "dbo.AfficherDemandesService"; SqlDataReader dr = cmd.ExecuteReader(); List <DemandeService> listeDemandes = new List <DemandeService>(); if (dr.HasRows) { while (dr.Read()) { DemandeService demande = new DemandeService((int)dr["id_emetteur"]); demande.NomPrenomEmetteur = (string)dr["nom"] + " " + (string)dr["prenom"]; demande.IdDemande = (int)dr["id_demande"]; demande.DateEnregistrement = (DateTime)dr["date_enregistrement"]; demande.DateRealisation = (DateTime)dr["date_realisation"]; demande.AdresseRealisation = (string)dr["adresse_realisation"]; demande.LibelleVilleRealisation = (string)dr["libelle_ville"]; demande.LibelleTypeService = (string)dr["libelle_type_service"]; if (dr["date_annulation"] != DBNull.Value) { demande.DateAnnulation = (DateTime)dr["date_annulation"]; } if (dr["date_cloture"] != DBNull.Value) { demande.DateCloture = (DateTime)dr["date_cloture"]; } listeDemandes.Add(demande); } } cnx.Close(); return(listeDemandes); }
public HistoriqueController() { demandeService = new DemandeService(); }
public employeController() { demandeService = new DemandeService(); }
public AnnulerController() { demandeService = new DemandeService(); }
public DemandeController(DemandeService a) { this.a = a; }