public static DataTable GetDataTableRoomGenderGroupBy(int gender)
{
string cmd = "select roomName from Room where gender=" + gender;
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTableBedNoStatus(string roomName)
{
string cmd = "select bedNo from Bed where status = 0 AND roomName='" + roomName + "'";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTableRoomBeds()
{
string cmd = "select Room.roomName,Room.gender,Bed.bedNo,Bed.status from Room,Bed where Room.roomName=Bed.roomName";
return(DAO.GetDataTable(cmd));
}
//them nha
public static DataTable GetDataTableRoomGroupBy()
{
string cmd = "select roomName from Room group by roomName";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTableByStuID(string stuID)
{
string cmd = "select * from Request where stuID = '" + stuID + "'";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTableRoom()
{
string cmd = "select * from Room";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select * from Request";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTableByRoom(string roomName)
{
string cmd = "select * from ElectricityWaterBills where roomName = '" + roomName + "'";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTableByStuId(string stuId)
{
string cmd = "select * from HistoryPayment where stuID = '" + stuId + "'";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select top 1 * from AvailibleBookingTime";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select * from HistoryPayment";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTableByUsername(string username)
{
string cmd = "select * from Manager where username = '******'";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select * from Manager";
return(DAO.GetDataTable(cmd));
}
} // -------------
public static DataTable GetDataTableBedNoByRoomName(string roomName) // Minh them
{
string cmd = "select bedNo from Bed where roomName = '" + roomName + "'";
return(DAO.GetDataTable(cmd));
} // -------------
public static DataTable GetDataTableByRequestID(int requestID)
{
string cmd = "select * from Request where requestID = " + requestID;
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTableByRoomName(string room)
{
string cmd = "select Room.roomName,Room.gender,Bed.bedNo,Bed.status from Room,Bed where Room.roomName=Bed.roomName AND Room.roomName = '" + room + "'";
return(DAO.GetDataTable(cmd));
}
public static DataTable GetDataTable()
{
string cmd = "select * from ElectricityWaterBills";
return(DAO.GetDataTable(cmd));
}