private static void CreateHotel() { Console.WriteLine("Please enter hotel name:"); var name = Console.ReadLine(); Console.WriteLine("Please enter hotel address:"); var address = Console.ReadLine(); var hotel = new Hotel { Name = name, Address = address }; using (var context = new HotelAdvisorContext()) { context.Hotels.Add(hotel); context.SaveChanges(); Console.WriteLine("Hotels in our database:"); var query = from h in context.Hotels orderby h.Name select h; foreach (var h in query) { Console.WriteLine(string.Format("Hotel id: {0}, name: {1}, address:{2}", h.Id, h.Name, h.Address)); } Console.WriteLine("Press any key to exit application."); Console.ReadKey(); } }
public void CreateHotel(Hotel hotel) { using (var context = new HotelAdvisorContext()) { context.Hotels.Add(hotel); context.SaveChanges(); } }
public void CreateComment(Comment comment) { using (var context = new HotelAdvisorContext()) { context.Comments.Add(comment); context.SaveChanges(); } }
public void CreateUser(User user) { using (var context = new HotelAdvisorContext()) { context.Users.Add(user); context.SaveChanges(); } }
public void Edit(Hotel newHotel) { using (var dbContext = new HotelAdvisorContext()) { this.hotel = dbContext.Hotels.Find(newHotel.Id); this.Populate(newHotel); dbContext.Entry(hotel).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); } }