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