public List <Reservation> GetReservations()
{
using (Entities.AppContext context = new Entities.AppContext())
{
return(context.Reservations.ToList());
}
}
public User GetUserById(int idUser)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
return(appContext.Ratings.FirstOrDefault(p => p.IdUser == idUser).User);
}
}
public List <ChambreReservee> GetAllChambreReservees()
{
using (Entities.AppContext context = new Entities.AppContext())
{
return(context.ChambreReservees.ToList());
}
}
public int GetShopRateById(int idShop)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
return(appContext.Ratings.FirstOrDefault(p => p.IdShop == idShop).Rate);
}
}
public List <Client> GetAllClients()
{
using (Entities.AppContext context = new Entities.AppContext())
{
return(context.Clients.ToList());
}
}
public ChambreReservee GetChambreReservee(int id)
{
using (Entities.AppContext context = new Entities.AppContext())
{
return(context.ChambreReservees.Find(id));
}
}
public RepasJour(DateTime date)
{
List <Repas> lst = new List <Repas>();
using (Entities.AppContext context = new Entities.AppContext())
{
lst = context.Repas.ToList();
}
dateHebdo = date;
int tempnbRepasMatin = 0, tempsnbRepasmidi = 0;
foreach (Repas repas in lst)
{
if (repas.DateRepas.Date == date.Date)
{
if (repas.EstPetitDejeuner)
{
tempnbRepasMatin++;
}
else
{
tempsnbRepasmidi++;
}
}
}
_nbRepasMatin = tempnbRepasMatin;
_nbRepasMidi = tempsnbRepasmidi;
}
public Client GetClient(int?id)
{
using (Entities.AppContext context = new Entities.AppContext())
{
return(context.Clients.Find(id));
}
}
public Address GetAddressById(int idAddress)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
return(appContext.Addresses.FirstOrDefault(p => p.IdAddress == idAddress));
}
}
internal void ChambreEstNettoyee(int numero)
{
using (Entities.AppContext context = new Entities.AppContext())
{
context.Database.ExecuteSqlCommand("UPDATE Chambres SET DateDernierMenage = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' WHERE Chambres.Numero = " + numero);
}
}
public Shop GetShopById(int idShop)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
return(appContext.Shops.FirstOrDefault(p => p.IdShop == idShop));
}
}
public TypeOfShop GetTypeOfShopById(int idTypeOfShop)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
return(appContext.TypeOfShops.FirstOrDefault(p => p.Id == idTypeOfShop));
}
}
public Reservation GetReservation(int id)
{
using (Entities.AppContext context = new Entities.AppContext())
{
return(context.Reservations.Find(id));
}
}
public void AddTypeOfShop(TypeOfShop typeOfShop)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
appContext.TypeOfShops.Add(typeOfShop);
appContext.SaveChanges();
}
}
public void UpdateAddress(Address address)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
appContext.Entry <Address>(address).State = EntityState.Modified;
appContext.SaveChanges();
}
}
public void AddAddress(Address address)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
appContext.Addresses.Add(address);
appContext.SaveChanges();
}
}
public void UpdateTypeOfShop(TypeOfShop typeOfShop)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
appContext.Entry <TypeOfShop>(typeOfShop).State = EntityState.Modified;
appContext.SaveChanges();
}
}
public void AddDemandeOption(DemandeOption opt)
{
using (Entities.AppContext context = new Entities.AppContext())
{
context.DemandeOptions.Add(opt);
context.SaveChanges();
}
}
public bool SignIn(User user)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
return(appContext.Users.Any(p =>
p.Hashpassword == user.Hashpassword && p.Login == user.Login));
}
}
public void UpdateUser(User user)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
appContext.Entry <User>(user).State = EntityState.Modified;
appContext.SaveChanges();
}
}
public void UpdateShop(Shop shop)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
appContext.Entry <Shop>(shop).State = EntityState.Modified;
appContext.SaveChanges();
}
}
public void SignUp(User user)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
appContext.Users.Add(user);
appContext.SaveChanges();
}
}
public void AddShop(Shop shop)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
appContext.Shops.Add(shop);
appContext.SaveChanges();
}
}
public bool CheckData(DemandeOption option)
{
using (Entities.AppContext context = new Entities.AppContext())
{
DemandeOption Dopt = (from opt in context.DemandeOptions where (opt.IdChambreReservee == option.IdChambreReservee) && (opt.IdOption == option.IdOption) select opt).SingleOrDefault <DemandeOption>();
return(Dopt != null);
}
}
public List <ChambreReservee> GetChambresReservées(int?idResa)
{
using (Entities.AppContext context = new Entities.AppContext())
{
return((from cr in context.ChambreReservees
where cr.IdentifiantRes == idResa
select cr).ToList());
}
}
public IEnumerable <TypeOfShop> GetAllTypeOfShops()
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
return(appContext.TypeOfShops
.Include(p => p.Description)
.ToList());
}
}
/// <summary>
/// Permet de recuperer la liste des chambre résérvé avec les chambre associé
/// </summary>
/// <returns></returns>
public List <ChambreReservee> chargerListChambre()
{
List <ChambreReservee> lst = new List <ChambreReservee>();
using (Entities.AppContext context = new Entities.AppContext())
{
lst = context.ChambreReservees.ToList();
}
return(lst);
}
public User GetUserByName(string nameUser)
{
using (Entities.AppContext appContext = new Entities.AppContext())
{
return(appContext.Users
//.Include(p => p.DateOfBirth)
.Include(p => p.ShopList)
.FirstOrDefault(p => p.NameUser == nameUser));
}
}
public List <Client> ChargerClients()
{
List <Client> lst = new List <Client>();
using (Entities.AppContext context = new Entities.AppContext())
{
lst = context.Clients.ToList();
}
return(lst);
}
public List <Chambre> getChambresANettoyer(int numEtage)
{
List <Chambre> chambres = new List <Chambre>();
using (Entities.AppContext context = new Entities.AppContext())
{
chambres = context.Database.SqlQuery <Chambre>("CALL menageByEtage(" + numEtage + ")").ToList();
return(chambres);
}
}
