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