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 })); }