public async Task <IActionResult> ReadStringDataManual() { hotelsContext hotelsContext = new hotelsContext(); int id = hotelsContext.Reservation.Max(h => (int)h.Id) + 1; string name = Request.Form["name"]; string surname = Request.Form["surname"]; string email = Request.Form["email"]; DateTime datefrom = DateTime.ParseExact(Request.Form["datefrom"], "yyyy-MM-dd", CultureInfo.InvariantCulture); DateTime dateto = DateTime.ParseExact(Request.Form["dateto"], "yyyy-MM-dd", CultureInfo.InvariantCulture); int roomid = Convert.ToInt32(Request.Form["roomid"]); var r = new Reservation { Id = id, Name = name, Surname = surname, Email = email, DateFrom = datefrom, DateTo = dateto, RoomId = roomid }; hotelsContext.Reservation.Add(r); hotelsContext.SaveChanges(); return(Redirect("/")); }
public async Task <IActionResult> Index(string searchString) { hotelsContext hotelsContext = new hotelsContext(); hotelsContext.Hotels .GroupJoin(hotelsContext.Countries, h => h.CountryId, c => c.Id, (ho, co) => new { Hotels = ho, Countries = co }).ToList(); var hotels = from h in hotelsContext.Hotels select h; if (!String.IsNullOrEmpty(searchString)) { hotels = hotels.Where(h => h.Name.Contains(searchString)); } ViewData["hotels"] = hotels; return(View()); }
public async Task <IActionResult> Index(int id) { hotelsContext hotelsContext = new hotelsContext(); hotelsContext.Hotels .GroupJoin(hotelsContext.Countries, h => h.CountryId, c => c.Id, (ho, co) => new { Hotels = ho, Countries = co }).ToList(); hotelsContext.Rooms .GroupJoin(hotelsContext.Hotels, r => r.HotelId, h => h.Id, (ro, ho) => new { Hotels = ho, Countries = ro }).ToList(); var rooms = from r in hotelsContext.Rooms where r.HotelId == id select r; ViewData["rooms"] = rooms; var hotel = from r in hotelsContext.Hotels where r.Id == id select r; ViewData["hotel"] = hotel; return(View()); }