public ResultModel BookRoom(BookingResultModel bookingModel)
{
var resultModel = new ResultModel();
MySqlConnection conn = new MySqlConnection(connString);
try
{
MySqlCommand cmd = new MySqlCommand("INSERT INTO bookings (user_id, room_id, date, start_time, end_time, status) VALUES " +
"(" + bookingModel.UserId + "," + bookingModel.RoomId + ",'" +
bookingModel.BookingDate.ToString("yyyy-MM-dd") + "','" +
bookingModel.StartTime + "','" + bookingModel.EndTime + "',1)", conn);
conn.Open();
cmd.ExecuteNonQuery();
resultModel.IsSucessful = true;
}
catch (Exception ex)
{
resultModel.IsSucessful = false;
resultModel.ErrorMessage = ex.ToString();
}
finally
{
conn.Close();
}
return(resultModel);
}
public ResultModel DeleteBooking(BookingResultModel bookingModel)
{
var resultModel = new ResultModel();
MySqlConnection conn = new MySqlConnection(connString);
try
{
MySqlCommand cmd = new MySqlCommand("update bookings set status=0 where id=" + bookingModel.Id, conn);
conn.Open();
cmd.ExecuteNonQuery();
resultModel.IsSucessful = true;
}
catch (Exception ex)
{
resultModel.IsSucessful = false;
resultModel.ErrorMessage = ex.ToString();
}
finally
{
conn.Close();
}
return(resultModel);
}
public ResultModel DeleteBooking(BookingResultModel bookingModel)
{
var dal = new ReservationDAL();
return(dal.DeleteBooking(bookingModel));
}
public ResultModel BookRoom(BookingResultModel bookingModel)
{
var dal = new ReservationDAL();
return(dal.BookRoom(bookingModel));
}
