public bool CreateReservation(CreateReserveInputModel inputModel, string currentMemberID)
{
var currentMember = _memberRepository.FindBy(x => x.EmailAddress ==
currentMemberID).SingleOrDefault();
var checkReservation = _reservationRepository.FindBy(x => x.MemberID ==
currentMember.ID &&
x.TeeTimeID == inputModel.TeetimeId).SingleOrDefault();
if (checkReservation == null)
{
//Create Reservation For Current Member
var reservationMember = new Reservations
{
DateCreated = DateTime.UtcNow,
Status = ReservationStatus.Accepted,
MemberID = currentMember.ID,
TeeTimeID = inputModel.TeetimeId
};
_reservationRepository.Add(reservationMember);
_reservationRepository.SaveChanges();
if (inputModel.Reservations.Count > 0)
{
foreach (var reservation in inputModel.Reservations)
{
var check = _reservationRepository.FindBy(x => x.MemberID ==
reservation.MemberId &&
x.TeeTimeID == inputModel.TeetimeId).SingleOrDefault();
if (check == null)
{
var newReservation = new Reservations
{
DateCreated = DateTime.UtcNow,
Status = (ReservationStatus)reservation.CurrentStatus,
MemberID = reservation.MemberId,
TeeTimeID = inputModel.TeetimeId
};
_reservationRepository.Add(newReservation);
_reservationRepository.SaveChanges();
}
}
}
return(true);
}
return(false);
}
private static List <string> GenerateMail(Reservations reservations)
{
List <string> output = new List <string>();
string subject = "About your reservation";
output.Add(subject);
string body = $"Hello {reservations.Name} {reservations.Lastname}!" + Environment.NewLine;
body += $"Your reservation for the flight has been booked successfully.";
output.Add(body);
return(output);
}
public Database()
{
string connectionString = @"Server=LAPTOP-LSE8ACET\SQL_SERVER;Database=TransportReservation;User Id=sa;Password=12345;";
SqlConnection conn = new SqlConnection(connectionString);
Authentication = new Authentication(conn);
Managers = new Managers(conn);
Sellers = new Sellers(conn);
Tickets = new Tickets(conn);
Customers = new Customers(conn);
Buses = new Buses(conn);
Admins = new Admins(conn);
Reservations = new Reservations(conn);
}
public ActionResult Edit([Bind(Include = "ReservationID,CarID,CostumerID,ReservStatsID,StartDate,EndDate,Location,CouponCode")] Reservations reservations)
{
if (ModelState.IsValid)
{
db.Entry(reservations).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CarID = new SelectList(db.Cars, "CarID", "Plate", reservations.CarID);
ViewBag.CouponCode = new SelectList(db.Coupons, "CouponCode", "Description", reservations.CouponCode);
ViewBag.CostumerID = new SelectList(db.Customers, "CostumerID", "Name", reservations.CostumerID);
ViewBag.ReservStatsID = new SelectList(db.ReservationStatuses, "ReservStatsID", "Name", reservations.ReservStatsID);
return(View(reservations));
}
public IHttpActionResult AddReservations(Reservations reservations)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//reservations.MeetingRooms = db.MeetingRooms.Find(reservations.MeetingRoom_Id);
//reservations.Users = db.Users.Find(reservations.User_Id);
db.Reservations.Add(reservations);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = reservations.Id }, reservations));
}
public void CanBeCancelledBy_UserIsAdmin_ReturnsTrue()
{
//Arrange
var reservations = new Reservations();
//Act
var result = reservations.CanBeCancelledBy(new User {
IsAdmin = true
});
//Assert
//Assert.IsTrue(result);
//Assert.That(result, Is.True);
Assert.That(result == true);
}
// GET: Reservations/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reservations reservations = db.Reservations.Find(id);
if (reservations == null)
{
return(HttpNotFound());
}
return(View(reservations));
}
public async Task <IActionResult> DeleteCarReservation(int id)
{
Reservations carItem = _context.CarReservations.Find(id);
if (carItem == null)
{
return(NotFound());
}
_context.CarReservations.Remove(carItem);
await _context.SaveChangesAsync();
return(NoContent());
}
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reservations roomUsage = await db.RoomUsages.FindAsync(id);
if (roomUsage == null)
{
return(HttpNotFound());
}
return(View(roomUsage));
}
public HttpResponseMessage Delete(int id)
{
var reservation = Reservations.GetSingle(id);
// returning 404 if the entity doesn't exist
if (reservation == null)
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
Reservations.Delete(reservation);
Reservations.Save();
return(Request.CreateResponse(HttpStatusCode.OK));
}
public void CanBeCancelledBy_AnotherUser_ReturnsFalse()
{
//Arrange
var user = new User();
var reservations = new Reservations {
MadeBy = user
};
//Act
var result = reservations.CanBeCancelledBy(new User());
//Assert
Assert.IsFalse(result);
}
public async Task <IHttpActionResult> DeleteReservations(int id)
{
Reservations reservations = await db.Reservations.FindAsync(id);
if (reservations == null)
{
return(NotFound());
}
db.Reservations.Remove(reservations);
await db.SaveChangesAsync();
return(Ok(reservations));
}
private void goAccueil(object dest)
{
UserControl destUC = null;
switch ((string)dest)
{
case "accueil":
destUC = ListPages.FirstOrDefault(x => x is Accueil);
if (destUC == null)
{
destUC = new Accueil();
}
break;
case "clients":
destUC = ListPages.FirstOrDefault(x => x is Clients);
if (destUC == null)
{
destUC = new Clients();
}
break;
case "reservations":
destUC = ListPages.FirstOrDefault(x => x is Reservations);
if (destUC == null)
{
destUC = new Reservations();
}
break;
case "repas":
destUC = ListPages.FirstOrDefault(x => x is Repas);
if (destUC == null)
{
destUC = new Repas();
}
break;
case "menages":
destUC = ListPages.FirstOrDefault(x => x is Menages);
if (destUC == null)
{
destUC = new Menages();
}
break;
}
CurrentPage = destUC;
}
/// <summary>
/// After we find the query through the FindReservationByKeys method we can update it with the new instance of model.
/// With instance methog excepts the parameters ID's to find query.
///
/// Next we have to check if car was changed. If so:
/// Old car set available and new car set busy
/// </summary>
/// <param name="reservation"></param>
/// <param name="oldCustomerID"></param>
/// <param name="oldCarID"></param>
/// <param name="oldStartDate"></param>
public void UpdateReservation(Reservations reservation, int oldCustomerID, int oldCarID, DateTime oldStartDate)
{
string firstExpression =
@"UPDATE Reservations SET CarID=@CarID, CustomerID=@CustomerID,
StartDate=@StartDate, EndDate=@EndDate, Location=@Location
WHERE CustomerID=@oldCustomerID AND CarID=@oldCarID AND StartDate=@oldStartDate";
using (SqlCommand cmd = new SqlCommand(firstExpression, connection)) {
cmd.Parameters.AddWithValue("@oldCarID", oldCarID);
cmd.Parameters.AddWithValue("@oldCustomerID", oldCustomerID);
cmd.Parameters.AddWithValue("@oldStartDate", oldStartDate);
cmd.Parameters.AddWithValue("@CarID", reservation.CarID);
cmd.Parameters.AddWithValue("@CustomerID", reservation.CustomerID);
cmd.Parameters.AddWithValue("@StartDate", reservation.StartDate);
cmd.Parameters.AddWithValue("@EndDate", reservation.EndDate);
cmd.Parameters.AddWithValue("@Location", reservation.Location);
connection.Open();
cmd.ExecuteNonQuery();
//Console.WriteLine("Reservation was updated");
}
if (oldCarID == reservation.CarID)
{
connection.Close();
return;
}
string secondExpression =
@"UPDATE Cars SET Cars.IsBusy=@IsBusy WHERE CarID=@oldCarID";
using (SqlCommand cmd = new SqlCommand(secondExpression, connection)) {
cmd.Parameters.AddWithValue("@oldCarID", oldCarID);
cmd.Parameters.AddWithValue("@IsBusy", false);
cmd.ExecuteNonQuery();
Console.WriteLine("{0} Car with ID is available now", oldCarID);
}
string thirdExpression =
@"UPDATE Cars SET Cars.IsBusy=@IsBusy WHERE CarID=@CarID";
using (SqlCommand cmd = new SqlCommand(thirdExpression, connection)) {
cmd.Parameters.AddWithValue("@CarID", reservation.CarID);
cmd.Parameters.AddWithValue("@IsBusy", true);
cmd.ExecuteNonQuery();
Console.WriteLine("{0} Car with ID is reserved", reservation.CarID);
connection.Close();
}
}
public async Task <IActionResult> GetReservationsById(int id)
{
try
{
Reservations ret = await _repository.Reservations.GetReservationsByIdAsync(id);
_logger.LogInfo($"Returned reservation by id from database.");
return(Ok(ret));
}
catch (Exception ex)
{
_logger.LogError($"Something went wrong inside GetReservationsById action: {ex.Message}");
return(StatusCode(500, "Internal server error" + ex));
}
}
public async Task <bool> IsRoomFreeInPeriod(Room room, DateTime begin, DateTime end, string currReservId = null)
{
var reservs = await Reservations.Where(x => x.Room.Id == room.Id && currReservId != x.Id).ToListAsync();
foreach (var reserv in reservs)
{
if ((begin >= reserv.CheckInTime && begin <= reserv.CheckOutTime) ||
(end >= reserv.CheckInTime && end <= reserv.CheckOutTime) ||
(begin <= reserv.CheckOutTime && end >= reserv.CheckOutTime))
{
return(false);
}
}
return(true);
}
private void Refresh()
{
ClearFilter();
Reservations.Refresh(App.Model.Reservations);
if (showId != null)
{
Show = (from s in App.Model.Shows where s.Id == showId select s).FirstOrDefault();
}
else if (clientId != null)
{
Client = (from c in App.Model.Clients where c.Id == clientId select c).FirstOrDefault();
}
SelectedReservation = null;
SetMode();
}
public IActionResult AddRSVP(int weddingID)
{
int?UserID = HttpContext.Session.GetInt32("UserID");
// var DelReservation = _context.reservations.Where(p => p.weddingsid == weddingID).ToList();
// var DelReservation = _context.reservations.Where(p => p.id == reservationID).SingleOrDefault();
Reservations myReservation = new Reservations();
myReservation.created_at = DateTime.Now;
myReservation.updated_at = DateTime.Now;
myReservation.usersid = (int)UserID;
myReservation.weddingsid = weddingID;
_context.reservations.Add(myReservation);
_context.SaveChanges();
return(RedirectToAction("Dashboard"));
}
public HttpResponseMessage Get(int id)
{
var reservation = Reservations.GetSingle(id);
// Handling the HTTP status codes
if (reservation != null)
{
return(Request.CreateResponse <ReservationDTO>
(HttpStatusCode.OK, reservation.ToReservationDTO()));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound));
}
}
public void CanBeCancelledBy_SameUserCancellingReservation_ReturnsTrue()
{
//Arrange => Test edecegimiz metodun ait oldugu sinifitan obje yaratma bolumu
var user = new User();
var reservations = new Reservations {
MadeBy = user
};
//Act => yarattigimiz objeler uzerinden test edilecek olan metodlara ulasiriz
var result = reservations.CanBeCancelledBy(user);
//Assert
Assert.IsTrue(result);
Assert.That(result, Is.True);
}
//public Cars Find(int CarID)
//{
// Cars c = car.Find(p => p.CarID == CarID);
// if (c != null)
// {
// return c;
// }
// else
// {
// throw new Exception("Customer not found!");
// }
//}
public ActionResult Edit(int CarID, int Id, DateTime StartDate)
{
//Reservations rent = context.Find(p => (p.CarID == IdCar) && (p.Id == Id) && (p.StartDate == dt));
Reservations rent = context.Find(CarID, Id, StartDate);
if (rent == null)
{
return(HttpNotFound());
}
else
{
return(View(rent));
}
}
public void CheckTimes_SelectedEndTimeIsAfterSunIsUp_ReturnFalse()
{
Reservations reservation = new Reservations();
TimeSpan sunUp = new TimeSpan(8, 0, 0);
TimeSpan sunDown = new TimeSpan(16, 0, 0);
List <TimeSpan> beginTimes = new List <TimeSpan>();
List <TimeSpan> endTimes = new List <TimeSpan>();
TimeSpan selectedBeginTime = new TimeSpan(12, 0, 0);
TimeSpan selectedEndTime = new TimeSpan(17, 0, 0);
// Act
var result = reservation.CheckTime(selectedBeginTime, selectedEndTime, beginTimes, endTimes, sunUp, sunDown, true);
// Assert
Assert.IsFalse(result);
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Reservations reservations = db.Reservations.Find(id);
if (reservations == null)
{
return(HttpNotFound());
}
this.AddNotification("Are you sure you want to delete the reservation?", NotificationType.WARNING);
return(View(reservations));
}
public void CancelReservation(Reservation reservation)
{
if (Reservations.Contains <Reservation>(reservation))
{
IList <Table> tables = reservation.ReservedList.ToList <Table>();
foreach (Table t in tables)
{
reservation.RemoveReservable(t);
}
Reservations.Remove(reservation);
reservation.Delete();
}
}
private ReservViewModels PopulateViewModel(Reservations reservation)
{
var reservationViewModel = new ReservViewModels
{
ID = reservation.ID,
DateCreated = reservation.DateCreated,
TeeTimeID = reservation.TeeTimeID,
GolfCourse = reservation.TeeTime.GolfCourse.CourseName,
TeeTimeStartDate = reservation.TeeTime.StartDate,
TeeTimeEndDate = reservation.TeeTime.EndDate,
Status = reservation.Status
};
return(reservationViewModel);
}
public async Task Test_GetReservationById_ValidId_ShouldReturn_Object()
{
var reservation = Reservations.First();
_mockingHelper.RepositoryTicket.Setup(_ => _.GetReservationByIdAsync(reservation.Id))
.ReturnsAsync(reservation);
var result = await _reservationService.GetReservationByIdAsync(1L);
result.Should().NotBeNull();
result.Id.Should().Be(reservation.Id);
result.ScheduleId.Should().Be(reservation.ScheduleId);
result.TicketId.Should().Be(reservation.TicketId);
_mockingHelper.RepositoryTicket.Verify(_ => _.GetReservationByIdAsync(reservation.Id), Times.Once);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["id"] == null)
{
Response.Redirect("Activity.aspx");
return;;
}
String id = Request.Params["id"].ToString();
Player player = Reservations.FindPlayerById(id);
bool mark = false;
this.DetailTable.Caption = player.Name;
if (!IsPostBack)
{
this.PasscodeTb.Text = player.Passcode;
this.NameTb.Text = player.Name;
mark = player.Marked;
}
this.DeleteUserLbl.Visible = true;
this.DeleteUserBtn.Visible = true;
this.DeleteUserBtn.CommandArgument = player.Id;
TableRow row = new TableRow();
TableCell labelCell = new TableCell();
labelCell.Text = "Change Name";
row.Cells.Add(labelCell);
TableCell valueCell = new TableCell();
valueCell.HorizontalAlign = HorizontalAlign.Right;
// PasscodeTb.Font.Size = new FontUnit("1.2em");
valueCell.Controls.Add(NameTb);
PasscodeTb.Font.Size = FontUnit.XXLarge;
row.Cells.Add(valueCell);
TableCell saveCell = new TableCell();
saveCell.HorizontalAlign = HorizontalAlign.Right;
ImageButton imageBtn = new ImageButton();
imageBtn.ID = id + "," + this.DetailTable.Caption + ",saveNameBtn";
imageBtn.ImageUrl = "~/Icons/Save.png";
imageBtn.Width = new Unit(Constants.IMAGE_BUTTON_SIZE);
imageBtn.Height = new Unit(Constants.IMAGE_BUTTON_SIZE);
imageBtn.Click += new ImageClickEventHandler(SaveName_Click);
saveCell.Controls.Add(imageBtn);
row.Cells.Add(saveCell);
this.DetailTable.Rows.Add(row);
}
public void Update(Type t)
{
if (t == typeof(Movie))
{
var _actualMovies = _db.GetObjects <Movie>();
Movies.Clear();
foreach (var movie in _actualMovies)
{
Movies.Add(movie);
}
var _actualShows = _db.GetObjects <Show>();
RemoveFilter();
Shows.Clear();
foreach (var show in _actualShows)
{
Shows.Add(show);
}
var _day = DateTime.ParseExact(_showDateFilter, "dd/MM/yyyy", null);
ApplyDateFilter(_day);
}
else if (t == typeof(Show))
{
var _actualShows = _db.GetObjects <Show>();
Shows.Clear();
// RemoveFilter();
foreach (var show in _actualShows)
{
Shows.Add(show);
}
var day = DateTime.ParseExact(_showDateFilter, "dd/MM/yyyy", null);
// ApplyDateFilter(day);
}
else if (t == typeof(Reservation))
{
var _actualReservations = _db.GetObjects <Reservation>();
App.Current.Dispatcher.Invoke(delegate
{
Reservations.Clear();
foreach (var reservation in _actualReservations)
{
Reservations.Add(reservation);
}
});
}
}
private void ReserveAgain_Click(object sender, RoutedEventArgs e)
{
//get data from correct row
var r = ((FrameworkElement)sender).DataContext as Reservations;
//Check if member has already 2 reservations
if (Reservations.CheckAmountReservations(MemberId) >= 2)
{
MessageBox.Show("U kunt geen nieuwe reservering plaatsen omdat u al 2 aankomende reserveringen heeft.", "Opnieuw reserveren", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
SelectDateOfReservation.Screen = SelectDateOfReservation.PreviousScreen.ReservationsScreen;
Switcher.Switch(new SelectDateOfReservation(r.BoatId, r.BoatName, r.BoatType, AccessLevel, FullName, MemberId));
}
}
private void SendReservationEmail(Reservations res)
{
var subject = " Beach House Reservation ID:" + res.Id + " has been created!";
var to = new EmailAddress(res.User.Email.Trim(), res.User.FirstName.Trim() + " " + res.User.LastName.Trim());
var toAdmin = GetAdminEmailAddress();
var plainTextContent = "Reservation ID:" + res.Id + " date: " + res.Date.ToShortDateString() + " nights: " + res.ReservationDetails.Count();
var htmlContent = "<p>Hello <strong> " + res.User.FirstName.Trim() + " " + res.User.LastName.Trim() + "</strong>,</p><p> Thanks for reserving the ASEITHSMUS Bejuco Beach House.This is your reservation summary:<p>" +
getCheckInCheckOut(res) + "<br>" + "<strong> Total Nights:</strong> " + res.ReservationDetails.Count() + " <strong> Total Charge:</strong> $" + res.ReservationDetails.Sum(x => x.Rate) + " (USD) <br/> " +
"<a href = " + getTAndCUrl() + "> Terms and Conditions</a></p><p> Please remember that cancellations are allowed until one week before the Check In date, right after that date no cancellations can be made.</p> " +
"<p> Bejuco Beach House Google Maps link <a href =" + getTAndCUrl() + "> here </a></p><p> Regards,<br/><strong> Bejuco Beach House Administration Team</strong></p>";
var emailToUser = SendEmailAsync(subject, to, plainTextContent, htmlContent);
var emailToAdmin = SendEmailAsync(subject, toAdmin, plainTextContent, htmlContent);
}
