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