public static bool InsertCheckinInfo(string roomName, string staffUsername, long customerID, DateTime checkinDate) { using (var conn = DatabaseManager.Conn) { var checkinInfo = new RentInfo { RoomName = roomName, StaffUsername = staffUsername, CustomerID = customerID, CheckinDate = checkinDate }; try { return(conn.Execute("INSERT INTO rent_info(room_name, staff_username, customer_id, checkin_date) VALUE (@RoomName, @StaffUsername, @CustomerID, @CheckinDate)", checkinInfo) > 0); } catch (Exception) { return(false); } } }
public static bool UpdateRoomStatus(string roomName) { using (var conn = DatabaseManager.Conn) { try { if (RentInfo.FindRoomRented(roomName)) { return(conn.Execute("UPDATE room SET status = @Status WHERE name = @Name", new { Status = "NotAvailable", Name = roomName }) > 0); } else { return(conn.Execute("UPDATE room SET status = @Status WHERE name = @Name", new { Status = "Available", Name = roomName }) > 0); } } catch (Exception) { return(false); } } }
public void RetrieveRentInfo() { _RentInfos = RentInfo.GetAllCurrentByRoomName(Name); }