public int CancelBooking(Guid bookingGuid, DateTime cancelledDate)
{
string sql = @"dbo.Booking_CancelById @BookingGuid, @CancelledDate";
return(SqlDataAccess.SaveData(sql, new { BookingGuid = bookingGuid, CancelledDate = cancelledDate }));
}
public int CheckOut(Guid bookingGuid, DateTime checkedOutDate)
{
string sql = @"dbo.Booking_CheckOutById @BookingGuid, @CheckedOutDate";
return(SqlDataAccess.SaveData(sql, new { BookingGuid = bookingGuid, CheckedOutDate = checkedOutDate }));
}
public int CreateBooking(Guid id, string name, string phone, string email, DateTime checkInDate, DateTime checkOutDate)
{
string sql = @"dbo.Booking_Insert @Id, @Name, @Phone, @Email, @CheckInDate, @CheckOutDate";
return(SqlDataAccess.SaveData(sql, new { Id = id, Name = name, Phone = phone, Email = email, CheckInDate = checkInDate, CheckOutDate = checkOutDate }));
}