public static DataTable getArea()
{
string sql = @"Select * from Area";
return(DAO.GetDataBySQL(sql));
}
public static DataTable getTopic(string s)
{
string sql = @"Select * from Topic";
return(DAO.GetDataBySQL(sql));
}
public static DataTable getAllPost()
{
string sql = @"select * from Post";
return(DAO.GetDataBySQL(sql));
}
public static DataTable getTop1Post()
{
string sql = @" select top 1 * from Post order by date desc";
return(DAO.GetDataBySQL(sql));
}
public static DataTable GetAllAccount()
{
string sql = @"select id,username, password,email, role from Account";
return(DAO.GetDataBySQL(sql));
}