public int SetRoomState(int roomID, Base.TableRooms.RoomState state) { try { return(phongDAO.SetRoomState(roomID, state)); }//end try catch { throw; } //end catch } //end method SetRoomState
public int SetRoomState(int roomID, Base.TableRooms.RoomState state) { try { String query = "UPDATE PHONG SET MA_TINH_TRANG=@MA_TINH_TRANG " + "WHERE MA_PHONG=@SO_PHONG"; SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@MA_TINH_TRANG", state); param[1] = new SqlParameter("@SO_PHONG", roomID); return(Program.DBConnection.ExecuteNonQuery(query, param)); }//end try catch { throw; } //end catch } //end method SetRoomState