public static List <County> SearchCounty(string county, int limit, int offset)
{
string sql = new StringBuilder(BSql)
.Append(" WHERE ")
.Append(string.Format("(`{0}` like @{0})", County.Column.concelho.ToString()))
.ToString();
List <MySqlParameter> lp = new List <MySqlParameter>();
lp.Add(new MySqlParameter("@" + County.Column.concelho.ToString(), "%" + county.Trim().Replace(" ", "%") + "%"));
return(County.ExecuteQuery(sql, lp, limit, offset));
}
public static List <County> GetCounty(string dd, string cc, int limit, int offset)
{
string sql = new StringBuilder(BSql)
.Append(" WHERE ")
.Append(string.Format("(`{0}` = @{0})", County.Column.cc.ToString()))
.Append(" AND ")
.Append(string.Format("(`{0}` = @{0})", County.Column.dd.ToString()))
.ToString();
List <MySqlParameter> lp = new List <MySqlParameter>();
lp.Add(new MySqlParameter("@" + County.Column.cc.ToString(), cc));
lp.Add(new MySqlParameter("@" + County.Column.dd.ToString(), dd));
return(County.ExecuteQuery(sql, lp, limit, offset));
}
public static List <County> GetAll(int limit, int offset)
{
return(County.ExecuteQuery(BSql, new List <MySqlParameter>(), limit, offset));
}
