public void SignU(string name, string login, string password, bookingContext db) { var id = db.Users.OrderByDescending(u => u.Id).FirstOrDefault().Id + 1; var user = new User { Id = id, Name = name, Login = login, Password = password }; db.Users.Add(user); db.SaveChanges(); }
void IReserve.Reserve(int?id, bookingContext db, string login) { User user = db.Users.FirstOrDefault(u => u.Login == login); Room room = db.Rooms.FirstOrDefault(r => r.Id == id); booking book = new booking(); book.Idofroom = id; book.Begindate = UserBooking.bd; book.Enddate = UserBooking.ed; book.Userid = user.Id; book.IdofroomNavigation = room; book.User = user; book.Idofhotel = room.HId; book.Id = db.Bookings.Max(a => a.Id) + 1; db.Bookings.Add(book); db.SaveChanges(); }
public UserBooking getBooking(bookingContext _bookingContext, string userName) { Console.WriteLine(userName); if (userName != null && _bookingContext.Bookings != null) { User bookUs = _bookingContext.Users.FirstOrDefault(u => u.Login == userName); var book = _bookingContext.Bookings.Where(u => u.Userid == bookUs.Id).ToList(); if (book.Count == 0) { return(new UserBooking(bookUs, null, null, null)); } var rooms = _bookingContext.Rooms.Where(u => u.Id == book[0].Idofroom).ToList(); for (int i = 1; i < book.Count; i++) { rooms.Add(_bookingContext.Rooms.FirstOrDefault(u => u.Id == book[i].Idofroom)); } if (rooms.Count == 0) { return(new UserBooking(bookUs, null, null, null)); } var hotels = _bookingContext.Hotels.Where(u => u.Id == rooms[0].HId).ToList(); for (int i = 1; i < rooms.Count; i++) { hotels.Add(_bookingContext.Hotels.FirstOrDefault(u => u.Id == rooms[i].HId)); } if (hotels == null) { return(new UserBooking(bookUs, rooms, null, null)); } var bookings = _bookingContext.Bookings.Where(u => u.Userid == bookUs.Id).ToList(); Console.WriteLine(_bookingContext.Users.FirstOrDefault(u => u.Login == userName).Name); UserBooking ub = new UserBooking(bookUs, rooms, hotels, bookings); return(ub); } return(null); }
public HomeController(ILogger <HomeController> logger, bookingContext context) { _logger = logger; _bookingContext = context; }
public BookingController(bookingContext context, IReserve reserve) { _bookingContext = context; _reserve = reserve; }
public UsersAuth(bookingContext context, IProfile _profile, ISign sign) { _bookingContext = context; profile = _profile; _sign = sign; }