public static void AddNote(BookingLog note, int roomId, int guestId, int hotelId) { using (var connection = new SqlConnection(_connectionString)) using (var command = connection.CreateCommand()) { try { connection.Open(); command.CommandText = $"INSERT into BookingLog values ('{roomId}','{guestId}'," + $"'{hotelId}','{note.ArrivalDate}','{note.DepartureDate}','{note.Payment}')"; var affectedRows = command.ExecuteNonQuery(); //число строк которые подвергнуты каким либо изменениям if (affectedRows < 1) { throw new Exception("Вставка не была произведена"); } } catch (SqlException exception) { //TODO обработка ошибки Console.WriteLine(exception.Message); //throw; } catch (Exception exception) { Console.WriteLine(exception.Message); //TODO обработка ошибки //throw; } } }
public static void BookingNumber(BookingLog note, Room room, User user, Hotel hotel) { //note.RoomNumber = room.Number; //note.GuestName = user.Login; //note.HotelName = hotel.Name; user.Id = AccountsTableDataService.GetAccountId(user.Login); Console.Write("Please ender data:\n" + "ArrivalDate (dd.mm.yyyy): "); note.ArrivalDate = DateTime.Parse(Console.ReadLine()); Console.Write("DepartureDate (dd.mm.yyyy): "); note.DepartureDate = DateTime.Parse(Console.ReadLine()); Console.WriteLine("\n1) To book \n2) To Pay"); int choice = int.Parse(Console.ReadLine()); if (choice == 1) { note.Payment = 0; } else if (choice == 2) { note.Payment = (note.DepartureDate - note.ArrivalDate).TotalDays * RoomsTableDataService.GetRoomPrice(room.Id); } BookingLogTableDataService.AddNote(note, room.Id, user.Id, hotel.Id); }
public async Task <IActionResult> Edit(int id, [Bind("BookingLogId,CreatedBy,CreatedDate,LastModifiedDate,LastModifiedBy,StaffId,CustomerId,ActivityTypeId")] BookingLog bookingLog) { if (id != bookingLog.BookingLogId) { return(NotFound()); } if (ModelState.IsValid) { try { dataContext.Update(bookingLog); await dataContext.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!BookingLogExists(bookingLog.BookingLogId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["ActivityTypeId"] = new SelectList(dataContext.ActivityType, "ActivityTypeId", "Title,Price,StartDate,EndDate,Vehicle", bookingLog.ActivityTypeId); ViewData["CustomerId"] = new SelectList(dataContext.Customer, "CustomerId", "FirstName", bookingLog.CustomerId); ViewData["StaffId"] = new SelectList(dataContext.Staff, "StaffId", "FirstName", bookingLog.StaffId); return(View(bookingLog)); }
static void Main(string[] args) { User user = new User(); var dataService = new AccountsTableDataService(); while (true) { System.Console.Clear(); System.Console.Write("1) Registration \n" + "2) Authorization \n" + "3) Exit \n" + "Choice: "); int choice = int.Parse(System.Console.ReadLine()); if (choice == 1) { Registration.SignUp(user, dataService); } else if (choice == 2) { Authorization.SignIn(user); List <Hotel> hotels = HotelsTableDataService.GetAllHotels(); for (int i = 0; i < hotels.Count; i++) { System.Console.WriteLine($"{i+1}) {hotels[i].Name}"); } System.Console.Write("Choice: "); int hotelPosition = int.Parse(System.Console.ReadLine()); List <Room> rooms = RoomsTableDataService.GetAvailableRooms(hotels[hotelPosition - 1].Id); System.Console.WriteLine("{0,7} | {1,15} | {2,10}", "№", "Category", "Price"); for (int i = 0; i < rooms.Count; i++) { System.Console.Write($"{i+1}) "); rooms[i].Show(i + 1); } System.Console.Write("Please, make your choice: "); int roomPosition = int.Parse(System.Console.ReadLine()); BookingLog note = new BookingLog(); Reservation.BookingNumber(note, rooms[roomPosition - 1], user, hotels[hotelPosition - 1]); System.Console.ReadLine(); } else { System.Environment.Exit(0); } } }
public async Task <IActionResult> Create([Bind("BookingLogId,CreatedBy,CreatedDate,LastModifiedDate,LastModifiedBy,StaffId,CustomerId,ActivityTypeId")] BookingLog bookingLog) { if (ModelState.IsValid) { dataContext.Add(bookingLog); await dataContext.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["ActivityTypeId"] = new SelectList(dataContext.ActivityType, "ActivityTypeId", "Title", bookingLog.ActivityTypeId); ViewData["CustomerId"] = new SelectList(dataContext.Customer, "CustomerId", "FirstName", bookingLog.CustomerId); ViewData["StaffId"] = new SelectList(dataContext.Staff, "StaffId", "FirstName", bookingLog.StaffId); return(View(bookingLog)); }