public static List <County> SearchCountyOfDistrict(string dd, string concelho, int limit, int offset)
{
string sql = new StringBuilder(BSql)
.Append(" WHERE ")
.Append(string.Format("(`{0}` like @{0})", County.Column.concelho.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.concelho.ToString(), "%" + concelho.Trim().Replace(" ", "%") + "%"));
lp.Add(new MySqlParameter("@" + County.Column.dd.ToString(), dd));
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));
}
protected static List <County> ExecuteQuery(string sql, List <MySqlParameter> param, int limit, int offset)
{
List <County> l = new List <County>();
CpMySql my = new CpMySql();
MySqlDataReader r = my.ExecuteCommand(sql, param, limit, offset);
while (r.Read())
{
County d = new County
{
dd = r.GetString(r.GetOrdinal(County.Column.dd.ToString())),
district = r.GetString(r.GetOrdinal(County.Column.distrito.ToString())),
cc = r.GetString(r.GetOrdinal(County.Column.cc.ToString())),
county = r.GetString(r.GetOrdinal(County.Column.concelho.ToString()))
};
l.Add(d);
}
my.Command.Dispose();
r.Close();
my.Conection.Close();
return(l);
}
public static List <County> GetAll(int limit, int offset)
{
return(County.ExecuteQuery(BSql, new List <MySqlParameter>(), limit, offset));
}
