public static DataTable GetDataCityByName(string name)
{
return(DAO.GetDataTable("SELECT * FROM Cities WHERE CityName = N\'" + name + "\' ORDER BY CityID"));
}
public static DataTable GetDataUsersByEmail(string email)
{
return(DAO.GetDataTable("SELECT * FROM Users WHERE Email LIKE '%" + email + "%'"));
}
/// <summary>
/// Get cities
/// </summary>
/// <returns></returns>
public static DataTable GetDataCity()
{
return(DAO.GetDataTable("SELECT * FROM Cities ORDER BY CityID"));
}
/// <summary>
/// Get all users
/// </summary>
/// <returns>user datatable</returns>
public static DataTable GetDataUsers()
{
return(DAO.GetDataTable("SELECT * FROM Users"));
}