public static void AddCours(DateTime coursDebut, DateTime coursFin, string typeCours, string discipline, string niveau, Guid idProfesseur)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
db.AddCours(coursDebut, coursFin, typeCours, discipline, niveau, idProfesseur);
}
}
public static void DeleteCours(Guid idCours)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
db.DeleteCours(idCours);
}
}
public static void DeleteReservation(Guid idReservation)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
db.DeleteReservation(idReservation);
}
}
public static void UpdateCoursParticipant(Guid idCours)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
db.UpdateCoursParticipant(idCours);
}
}
public static void AddUtilisateur(string email, string passwordHash, string prenom, string nom)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
db.AjouterUtilisateur(email, passwordHash, prenom, nom);
}
}
public static void AddProfesseurCours(Guid idProfesseur, string typeCours, string discipline, string niveau)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
db.AjouterProfesseurCours(idProfesseur, typeCours, discipline, niveau);
}
}
public static void AddReservation(Guid idUser, Guid idCours, Guid idCheval)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
db.AddReservation(idUser, idCours, idCheval);
}
}
public static List <GetChevauxFiltre_Result> GetChevauxFiltre(string typecours, string typediscipline, string niveau, Guid id)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetChevauxFiltre(typecours, typediscipline, niveau, id).ToList();
return(lstToReturn);
}
}
public static List <GetFiltreDetail_Result> GetFiltreDetail(Guid id)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetFiltreDetail(id).ToList();
return(lstToReturn);
}
}
public static List <Cour> getAllCours()
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.Cours.ToList();
return(lstToReturn);
}
}
public static List <GetParticipantsCours_Result> GetParticipantsCours(Guid idCours)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetParticipantsCours(idCours).ToList();
return(lstToReturn);
}
}
public static List <GetReservationUser_Result> GetReservationUser(string id)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetReservationUser(id).OrderByDescending(x => x.COURS_debut).ToList();
return(lstToReturn);
}
}
public static List <GetFiltre_Result> getFiltre(string typecours, string typediscipline, string niveau, DateTime date, string username)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetFiltre(typecours, typediscipline, niveau, date, username).ToList();
return(lstToReturn);
}
}
public static List <GetAllCours_Result> getAllCoursEvent()
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetAllCours().ToList();
return(lstToReturn);
}
}
public static List <GetChevauxTable_Result> GetChevauxTable()
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetChevauxTable().ToList();
return(lstToReturn);
}
}
public static List <GetProfesseur_Result> GetProfesseurFiltre(string typecours, string niveau)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetProfesseur(typecours, niveau).ToList();
return(lstToReturn);
}
}
public static Guid GetIdCheval(string nom)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var guidToReturn = db.Chevals.FirstOrDefault(x => x.CHEVAL_nom == nom).CHEVAL_id;
return(guidToReturn);
}
}
public static List <GetUser_Result> GetUserAPI(string username)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
var lstToReturn = db.GetUser(username).ToList();
return(lstToReturn);
}
}
public static Guid AddProfesseur(string prenom, string nom)
{
using (ExamenProjetIntegrationEntities db = new ExamenProjetIntegrationEntities())
{
ObjectParameter objParam = new ObjectParameter("identity", typeof(Guid));
var resultToReturn = db.AjouterProfesseur(prenom, nom, objParam).Count();
return(Guid.Parse(objParam.Value.ToString()));
}
}
