public void Get_Returns_Specific_Reservation()
{
// Arrange
LibraryContextMock mockContext = new LibraryContextMock();
ReservationRepository repo = new ReservationRepository(mockContext);
BookRepository bookRepo = new BookRepository(mockContext);
Book newBook = new Book()
{
title = "New title",
author = "New author",
isbn = "22222",
publishDate = "2001"
};
Reservation newReservation1 = new Reservation()
{
id = 0, book = newBook
};
Reservation newReservation2 = new Reservation()
{
id = 1, book = newBook
};
bookRepo.Add(newBook);
repo.Add(newReservation1);
repo.Add(newReservation2);
// Act
Reservation Reservation = repo.Get(1);
// Asert
Assert.Equal(newReservation2, Reservation);
}
public void Add_Doesnt_Insert_If_Times_Clash()
{
// Arrange
LibraryContextMock mockContext = new LibraryContextMock();
ReservationRepository repo = new ReservationRepository(mockContext);
BookRepository bookRepo = new BookRepository(mockContext);
Book newBook = new Book()
{
title = "New title",
author = "New author",
isbn = "22222",
publishDate = "2001"
};
Reservation Reservation1 = new Reservation()
{
book = newBook,
startDate = new System.DateTime(2016, 1, 1, 1, 0, 0),
endDate = new System.DateTime(2016, 1, 1, 2, 0, 0),
};
Reservation Reservation2 = new Reservation()
{
book = newBook,
startDate = new System.DateTime(2016, 1, 1, 1, 30, 0),
endDate = new System.DateTime(2016, 1, 1, 2, 30, 0),
};
bookRepo.Add(newBook);
repo.Add(Reservation1);
Assert.Throws <InvalidOperationException>(() => repo.Add(Reservation2));
IEnumerable <Reservation> Reservations = repo.GetAll();
Assert.Equal(new Reservation[] { Reservation1 }, Reservations.ToArray());
}
public void Get_All_Returns_All_Reservations()
{
// Arrange
LibraryContextMock mockContext = new LibraryContextMock();
ReservationRepository repo = new ReservationRepository(mockContext);
BookRepository bookRepo = new BookRepository(mockContext);
Book newBook = new Book()
{
title = "New title",
author = "New author",
isbn = "22222",
publishDate = "2001"
};
Reservation newReservation1 = new Reservation()
{
book = newBook
};
Reservation newReservation2 = new Reservation()
{
book = newBook
};
bookRepo.Add(newBook);
repo.Add(newReservation1);
repo.Add(newReservation2);
// Act
IEnumerable <Reservation> Reservations = repo.GetAll();
// Asert
Assert.Equal(new Reservation[] { newReservation1, newReservation2 }, Reservations.ToArray());
}
public void WhenAddingReservationToRepoAddToUserAsWell()
{
Reservation testRes = new Reservation(_student, _room1, 4, _from, _to);
_repoReserv.Add(testRes);
List <Reservation> UsersReservations = _student.GetReservations();
Assert.IsTrue(UsersReservations.Contains(testRes));
}
public IActionResult Create([FromBody] Reservation reservation, DateTime start, DateTime end)
{
StringValues headerValues;
//Reservation reservation = new Reservation(startTime, endTime, courtId);
var a = Request.Body;
reservation.StartTime = start;
reservation.EndTime = end;
if (Request.Headers.TryGetValue("Authorization", out headerValues))
{
string token_str = headerValues.First();
string[] token_arr = token_str.Split(" ");
var handler = new JwtSecurityTokenHandler();
var token = handler.ReadJwtToken(token_arr[1]);
var userId = token.Payload["unique_name"];
reservation.UserId = int.Parse(userId.ToString());
return(Ok(_reservationRepository.Add(reservation)));
}
return(BadRequest());
}
public HotelMutation(ReservationRepository reservationRepository)
{
Field <ReservationType>("addReservation",
arguments: new QueryArguments(new QueryArgument <NonNullGraphType <AddReservationInputType> > {
Name = "reservation"
}),
resolve: context =>
{
var reservationInput = context.GetArgument <Reservation>("reservation");
return(reservationRepository.Add(reservationInput));
}
);
Field <ReservationType>("removeReservation",
arguments: new QueryArguments(new QueryArgument <IntGraphType> {
Name = "id"
}),
resolve: context =>
{
var id = context.GetArgument <int>("id");
return(reservationRepository.Remove(id));
}
);
}
public async Task <Reservation> Reserve(String Name, String Email, String Country, int NoOfRooms, String RoomType,
String MealPlanType, DateTime checkIn, DateTime checkOut, int TotalPrice, CancellationToken cancellationToken)
{
Guest guest = AddGuest(Name, Email, Country);
List <Room> rooms = await getFreeRooms(RoomType, checkIn, checkOut, cancellationToken);
rooms = rooms.Take(NoOfRooms).ToList();
MealPlan mealPlan = _mealPlanRepository.GetMealPlanByName(MealPlanType);
RoomType roomType = Booking.converToEnum <RoomType>(RoomType);
Reservation reservation = new Reservation
{
Guest = guest,
Rooms = rooms,
MealPlan = mealPlan,
RoomType = roomType,
StartDate = checkIn,
EndDate = checkOut,
Price = TotalPrice
};
_reservationRepository.Add(reservation);
return(reservation);
}
// POST /api/employees/
// body: JSON
public IHttpActionResult Post([FromBody] dynamic data)
{
Random random = new Random();
BookiAPI.DataAccessLayer.Models.Reservation reservation = new DataAccessLayer.Models.Reservation {
ReservationNo = random.Next(1000000),
DateTimeStart = Convert.ToDateTime(data.Reservation.DateTimeStart.Value),
DateTimeEnd = Convert.ToDateTime(data.Reservation.DateTimeEnd.Value),
State = 1,
CustomerId = (int)data.Reservation.CustomerId.Value,
VenueId = (int)data.Reservation.VenueId.Value,
TableId = (int)data.Reservation.TableId.Value,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
if (IsTableAvailable(reservation.TableId, reservation.DateTimeStart, reservation.DateTimeEnd))
{
int reservationId = _reservationRepository.Add(reservation);
if (reservationId > 0)
{
return(Ok("" + reservationId));
}
else
{
return(BadRequest("Something went wrong .."));
}
}
else
{
return(BadRequest("That table is already booked!"));
}
}
public ActionResult Add(Reservation item)
{
if (ModelState.IsValid)
{
repo.Add(item);
return(RedirectToAction("Index"));
}
return(View("Index"));
}
public ActionResult AddReservation([FromBody] Reservation reservation)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
repo.Add(reservation);
return(Accepted(reservation));
}
public void ReserveRoom()
{
foreach (IRoom room in Reservation.BestOption.RoomList)
{
room.Add(_reservation.ReservationPeriod);
}
_reservationRepository.Add(_reservation);
DataManagementService.Instance.SaveData();
}
public void RoomIsNotAvailable()
{
DateTime from = new DateTime(2017, 05, 01, 13, 0, 0);
DateTime to = new DateTime(2017, 05, 01, 14, 0, 0);
Reservation res = new Reservation(_student, _room1, 3, from, to);
_repoReserv.Add(res);
bool roomAvailable = _room1.IsAvailable(from, to);
Assert.IsFalse(roomAvailable);
}
internal void ReserveRoom(string date, string from, string to, IRoom room, string username)
{
IUser dummyUser = new User(username, "", Permission.Student);
IUser user = _repoUser.Get(dummyUser);
string dateTimeFrom = date + " " + from;
DateTime dateFrom = Convert.ToDateTime(dateTimeFrom);
string dateTimeTo = date + " " + to;
DateTime dateTo = Convert.ToDateTime(dateTimeTo);
_repoReservation.Add(user, room, 0, dateFrom, dateTo);
}
public void TestInitialize()
{
_repoRoom.Clear();
_repoUser.Clear();
_repoReservation.Clear();
_reservationList = new List <Reservation>();
_student = new User("matt2694", "*****@*****.**", Permission.Student);
_teacher = new User("alhe", "*****@*****.**", Permission.Teacher);
_admin = new User("frje", "*****@*****.**", Permission.Admin);
_room1 = new Room('A', 2, 9, 6, Permission.Student);
_room2 = new Room('A', 2, 15, 6, Permission.Teacher);
_room3 = new Room('A', 2, 115, 6, Permission.Admin);
_room4 = new Room('A', 7, 5, 2, Permission.Student);
_room5 = new Room('B', 7, 5, 10, Permission.Student);
_repoUser.Add(_student);
_repoUser.Add(_teacher);
_repoUser.Add(_admin);
_repoRoom.Add(_room1);
_repoRoom.Add(_room2);
_repoRoom.Add(_room3);
_repoRoom.Add(_room4);
_repoRoom.Add(_room5);
_dateFrom = new DateTime(2016, 4, 29, 8, 0, 0);
_dateTo = new DateTime(2016, 4, 29, 16, 0, 0);
_reservation1 = new Reservation(_student, _room1, 6, _dateFrom, _dateTo);
_reservation2 = new Reservation(_teacher, _room2, 6, _dateFrom, _dateTo);
_reservation3 = new Reservation(_admin, _room3, 6, _dateFrom, _dateTo);
_repoReservation.Add(_reservation1);
_repoReservation.Add(_reservation2);
_repoReservation.Add(_reservation3);
}
public ActionResult Add(Reservation reservation)
{
if (ModelState.IsValid)
{
reservationRepository.Add(reservation);
return(RedirectToAction(nameof(Index)));
}
else
{
return(View(reservationRepository.Reservations));
}
}
public void Delete_Removes_Correct_Reservation()
{
// Arrange
LibraryContextMock mockContext = new LibraryContextMock();
ReservationRepository repo = new ReservationRepository(mockContext);
BookRepository bookRepo = new BookRepository(mockContext);
Book newBook = new Book()
{
title = "New title",
author = "New author",
isbn = "22222",
publishDate = "2001"
};
Reservation newReservation1 = new Reservation()
{
id = 0, book = newBook
};
Reservation newReservation2 = new Reservation()
{
id = 1, book = newBook
};
Reservation newReservation3 = new Reservation()
{
id = 2, book = newBook
};
bookRepo.Add(newBook);
repo.Add(newReservation1);
repo.Add(newReservation2);
repo.Add(newReservation3);
// Act
repo.Remove(1);
IEnumerable <Reservation> Reservations = repo.GetAll();
// Asert
Assert.Equal(new Reservation[] { newReservation1, newReservation3 }, Reservations.ToArray());
}
public RedirectToActionResult CreateReservation(ReservationViewModel reservation)
{
if (reservation.CheckInDate < DateTime.Today)
{
return(RedirectToAction("ReservationLate"));
}
else if (reservation.CheckInDate == reservation.CheckOutDate)
{
return(RedirectToAction("ReservationTooShort"));
}
else if (reservation.CheckInDate > reservation.CheckOutDate)
{
return(RedirectToAction("ReservationWronglyScheduled"));
}
else if (context.Reservations.Where(x => x.CheckInDate == reservation.CheckInDate && x.Room.RoomID == reservation.Room.RoomID).Any())
{
return(RedirectToAction("ReservationExists"));
}
else
{
Models.Reservation reservationModel = new Models.Reservation();
reservationModel.Room = context.Rooms.FirstOrDefault(x => x.RoomID == reservation.Room.RoomID);
reservationModel.UserName = userManager.GetUserName(User);
reservationModel.CheckInDate = reservation.CheckInDate;
reservationModel.CheckOutDate = reservation.CheckOutDate;
reservationModel.TotalPrice = reservation.TotalPrice;
reservationModel.CountDays = reservation.CountDays;
if (reservationModel.CheckInDate.HasValue && reservationModel.CheckOutDate.HasValue)
{
DateTime dt1 = reservationModel.CheckInDate.Value;
DateTime dt2 = reservationModel.CheckOutDate.Value;
reservationModel.CountDays = (dt2 - dt1).Days;
reservationModel.TotalPrice = reservationModel.CountDays * reservationModel.Room.Price;
Reservation newReservation = _reservationRepository.Add(reservationModel);
context.SaveChanges();
}
}
return(RedirectToAction("MyReservation"));
}
// TODO: 1 - Create a channel factory for the Frequent Flyer service
public string CreateReservation(ReservationDto request)
{
// Verify the flight is valid
if (request.DepartureFlight == null)
{
throw new FaultException <ReservationCreationFault>(
new ReservationCreationFault
{
Description = "Reservation must include a departure flight",
ReservationDate = request.ReservationDate
},
"Invalid flight info");
}
// Create reservation object with trips
var reservation = new Reservation
{
TravelerId = request.TravelerId,
ReservationDate = request.ReservationDate,
DepartureFlight = new Trip
{
Class = request.DepartureFlight.Class,
Status = request.DepartureFlight.Status,
FlightScheduleID = request.DepartureFlight.FlightScheduleID
}
};
if (request.ReturnFlight != null)
{
reservation.ReturnFlight = new Trip
{
Class = request.ReturnFlight.Class,
Status = request.ReturnFlight.Status,
FlightScheduleID = request.ReturnFlight.FlightScheduleID
};
}
using (IReservationRepository reservationRepository = new ReservationRepository(ConnectionName))
{
reservation.ConfirmationCode = ReservationUtils.GenerateConfirmationCode(reservationRepository);
reservationRepository.Add(reservation);
reservationRepository.Save();
return(reservation.ConfirmationCode);
}
}
private void BtnSave_Click(object sender, EventArgs e)
{
if (lstRooms.SelectedIndex > -1)
{
if (dtpFinishDate.Value > dtpStartDate.Value)
{
Reservation reservation = new Reservation();
reservation.StartDate = dtpStartDate.Value;
reservation.FinishDate = dtpFinishDate.Value;
reservation.CustomerID = currentCustomer.ID;
reservation.RoomID = room.ID;
reservation.Amount = Convert.ToDecimal(room.Price * Convert.ToDecimal((dtpFinishDate.Value - dtpStartDate.Value).TotalDays));
reservationRepository.Add(reservation);
LoadListBox();
}
}
}
private void btnCreateReservation_Click_1(object sender, EventArgs e)
{
int creator;
try
{
Reservation rez = new Reservation();
rez.CustomerID = Convert.ToInt32(lblcustomer.Text);
rez.TableID = Convert.ToInt32(lbltable.Text);
rez.ReservationDate = dtmPickDate.Value;
creator = Convert.ToInt32(lblStaffid.Text);
rez.CreatorID = creator;
ReservationRepository rp = new ReservationRepository();
rp.Add(rez);
}
catch
{
MessageBox.Show("Lütfen Bilglileri Doğru ve Düzgün Giriniz!");
}
Order order = new Order();
order.TableID = Convert.ToInt32(lbltable.Text);
order.CustomerID = Convert.ToInt32(lblcustomer.Text);
creator = Convert.ToInt32(lblStaffid.Text);
order.OrderTakerStaffID = creator;
order.FoodStatusID = 1002;
order.PaymentStatusID = 3;
order.CreatorID = creator;
OrderRepository op = new OrderRepository();
op.Add(order);
try
{
}
catch
{
MessageBox.Show("Hata!");
}
}
public void Update_updates_Correct_Reservation()
{
// Arrange
LibraryContextMock mockContext = new LibraryContextMock();
ReservationRepository repo = new ReservationRepository(mockContext);
BookRepository bookRepo = new BookRepository(mockContext);
Book newBook = new Book()
{
title = "New title",
author = "New author",
isbn = "22222",
publishDate = "2001"
};
Reservation oldReservation = new Reservation()
{
book = newBook,
startDate = new System.DateTime(2016, 1, 1, 1, 0, 0),
endDate = new System.DateTime(2016, 1, 1, 2, 0, 0),
};
Reservation newReservation = new Reservation()
{
book = newBook,
startDate = new System.DateTime(2016, 1, 1, 3, 0, 0),
endDate = new System.DateTime(2016, 1, 1, 4, 0, 0),
};
bookRepo.Add(newBook);
repo.Add(oldReservation);
// Act
repo.Update(newReservation, 0);
IEnumerable <Reservation> Reservations = repo.GetAll();
// Asert
Assert.Equal(new Reservation[] { newReservation }, Reservations.ToArray());
}
public Reservation CreateReservation(Reservation item)
{
return(repo.Add(item));
}
public Reservation CreateReservation(Reservation item)
{
return(_reservationRepository.Add(item));
}
static void Main(string[] args)
{
BeverageRepository _beverageRepository = new BeverageRepository();
CustomerRepository _customerRepository = new CustomerRepository();
EmployeeRepository _employeeRepository = new EmployeeRepository();
ReservationRepository _reservationRepository = new ReservationRepository();
TablePackageRepository _tablePackageRepository = new TablePackageRepository();
ReservationTablePackageRepository _reservationTablePackageRepository = new ReservationTablePackageRepository();
TableRepository _tableRepository = new TableRepository();
VenueHourRepository _venueHourRepository = new VenueHourRepository();
VenueEmployeeRepository _venueEmployeeRepository = new VenueEmployeeRepository();
VenueRepository _venueRepository = new VenueRepository();
Console.WriteLine("Seeding database ..");
_beverageRepository.Truncate();
_reservationTablePackageRepository.Truncate();
_reservationRepository.Truncate();
_tablePackageRepository.Truncate();
_tableRepository.Truncate();
_venueHourRepository.Truncate();
_venueEmployeeRepository.Truncate();
_venueRepository.Truncate();
_customerRepository.Truncate();
_employeeRepository.Truncate();
Console.WriteLine("Seeding venues ..");
Venue venue = new Venue {
Name = "Kongebaren",
Address = "Gammel Kongevej 1",
Zip = 9000,
City = "Aalborg"
};
venue.Id = _venueRepository.Add(venue);
Venue venue1 = new Venue {
Name = "Dronningenbaren",
Address = "Gammel Kongevej 2",
Zip = 9000,
City = "Aalborg"
};
venue1.Id = _venueRepository.Add(venue1);
Console.WriteLine("Seeding employees ..");
Employee employee0 = new Employee
{
Name = "Kongen Kongessen",
Phone = "+4598765432",
Email = "*****@*****.**",
Password = HashingHelper.GenerateHash("12345678"),
EmployeeNo = 1,
Title = "Kongen",
Salt = HashingHelper.RandomString(20)
};
Employee employee1 = new Employee
{
Name = "Dronningen Dronningensen",
Phone = "+4509876543",
Email = "*****@*****.**",
Password = HashingHelper.GenerateHash("12345678"),
EmployeeNo = 1,
Title = "Dronningen",
Salt = HashingHelper.RandomString(20),
};
Employee employee2 = new Employee {
Name = "Prins Prinsen",
Phone = "+4539847837",
Email = "*****@*****.**",
Password = HashingHelper.GenerateHash("12345678"),
EmployeeNo = 1,
Title = "Prinsen",
Salt = HashingHelper.RandomString(20),
};
employee0.Id = _employeeRepository.Add(employee0);
employee1.Id = _employeeRepository.Add(employee1);
employee2.Id = _employeeRepository.Add(employee2);
Console.WriteLine("Seeding venue employees ..");
_venueEmployeeRepository.Add(new VenueEmployee
{
VenueId = venue.Id,
EmployeeId = employee0.Id,
AccessLevel = 1
});
_venueEmployeeRepository.Add(new VenueEmployee
{
VenueId = venue1.Id,
EmployeeId = employee1.Id,
AccessLevel = 1
});
_venueEmployeeRepository.Add(new VenueEmployee {
VenueId = venue.Id,
EmployeeId = employee2.Id,
AccessLevel = 1
});
_venueEmployeeRepository.Add(new VenueEmployee {
VenueId = venue1.Id,
EmployeeId = employee2.Id,
AccessLevel = 1
});
Console.WriteLine("Seeding customers ..");
string salt = HashingHelper.RandomString(20);
Customer customer0 = new Customer {
Name = "Kunde Kundessen",
Phone = "+4512345678",
Email = "*****@*****.**",
Salt = salt,
Password = HashingHelper.GenerateHashWithSalt("12345678", salt),
CustomerNo = 1,
};
salt = HashingHelper.RandomString(20);
Customer customer1 = new Customer
{
Name = "Gæst Gæstessen",
Phone = "+4587654321",
Email = "*****@*****.**",
Salt = salt,
Password = HashingHelper.GenerateHashWithSalt("87654321", salt),
CustomerNo = 2
};
customer0.Id = _customerRepository.Add(customer0);
customer1.Id = _customerRepository.Add(customer1);
Console.WriteLine("Seeding tables ..");
Table table0 = new Table {
NoOfSeats = 4,
Name = "Vinderbordet",
VenueId = venue.Id,
};
Table table1 = new Table
{
NoOfSeats = 6,
Name = "Taberbordet",
VenueId = venue.Id
};
Table table2 = new Table {
NoOfSeats = 7,
Name = "Det gode bord",
VenueId = venue1.Id,
};
Table table3 = new Table {
NoOfSeats = 3,
Name = "Det dårlige bord",
VenueId = venue1.Id
};
table0.Id = _tableRepository.Add(table0);
table1.Id = _tableRepository.Add(table1);
table2.Id = _tableRepository.Add(table2);
table3.Id = _tableRepository.Add(table3);
Console.WriteLine("Seeding table packages ..");
TablePackage tablePackage0 = new TablePackage {
Name = "Den dyre",
Price = 6000,
VenueId = venue.Id,
};
TablePackage tablePackage1 = new TablePackage
{
Name = "Den billige",
Price = 500,
VenueId = venue.Id
};
TablePackage tablePackage2 = new TablePackage {
Name = "Den Gode",
Price = 4000,
VenueId = venue1.Id,
};
TablePackage tablePackage3 = new TablePackage {
Name = "Den Den Dårlige",
Price = 300,
VenueId = venue1.Id
};
tablePackage0.Id = _tablePackageRepository.Add(tablePackage0);
tablePackage1.Id = _tablePackageRepository.Add(tablePackage1);
tablePackage2.Id = _tablePackageRepository.Add(tablePackage2);
tablePackage3.Id = _tablePackageRepository.Add(tablePackage3);
Console.WriteLine("Seeding reservations ..");
Reservation reservation0 = new Reservation
{
ReservationNo = 10001,
DateTimeStart = Convert.ToDateTime("28/12-2019 20:00"),
DateTimeEnd = Convert.ToDateTime("29/12-2019 05:00"),
State = 1,
CustomerId = customer0.Id,
VenueId = venue.Id,
TableId = table0.Id,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
Reservation reservation1 = new Reservation
{
ReservationNo = 10002,
DateTimeStart = Convert.ToDateTime("31/12-2019 20:00"),
DateTimeEnd = Convert.ToDateTime("01/01-2020 05:00"),
State = 1,
CustomerId = customer1.Id,
VenueId = venue1.Id,
TableId = table1.Id,
CreatedAt = DateTime.Now,
UpdatedAt = DateTime.Now
};
reservation0.Id = _reservationRepository.Add(reservation0);
reservation1.Id = _reservationRepository.Add(reservation1);
_reservationTablePackageRepository.Add(new ReservationTablePackage
{
ReservationId = reservation0.Id,
TablePackageId = tablePackage0.Id
});
_reservationTablePackageRepository.Add(new ReservationTablePackage
{
ReservationId = reservation1.Id,
TablePackageId = tablePackage1.Id
});
}
public List <Reservation> AddTicket(Reservation item)
{
rrep.Add(item);
rrep.Save();
return(GetAllReservations());
}
public Reservation PostReservation(Reservation item)
{
return(repo.Add(item));
}
[HttpPost] //added attribute
public Reservation CreateReservation(Reservation item) //changed the method name form PostReservation
{
return(repo.Add(item));
}
public Reservation CreateReservation(Reservation reservation)
{
return(repo.Add(reservation));
}
public Reservation Post(Reservation item) => _repo.Add(item);
public bool Add(Reservation reserves)
{
return(_reserveRepository.Add(reserves));
}
