/// <summary>
/// Serach fpr district
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <param name="limit"></param>
/// <param name="offset"></param>
/// <returns></returns>
protected static List <District> ExecuteQuery(string sql, List <MySqlParameter> param, int limit, int offset)
{
List <District> l = new List <District>();
CpMySql my = new CpMySql();
MySqlDataReader r = my.ExecuteCommand(sql, param, limit, offset);
while (r.Read())
{
District d = new District();
d.dd = r.GetString(r.GetOrdinal(District.Column.dd.ToString()));
d.district = r.GetString(r.GetOrdinal(District.Column.distrito.ToString()));
l.Add(d);
}
my.Command.Dispose();
r.Close();
my.Conection.Close();
return(l);
}
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);
}
/// <summary>
/// Serach fpr distrito
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <param name="limit"></param>
/// <param name="offset"></param>
/// <returns></returns>
protected static List <CPostal> ExecuteQuery(string sql, List <MySqlParameter> param, int limit, int offset)
{
List <CPostal> l = new List <CPostal>();
CpMySql my = new CpMySql();
MySqlDataReader r = my.ExecuteCommand(sql, param, limit, offset);
while (r.Read())
{
CPostal c = new CPostal
{
art_desig = r.GetString(r.GetOrdinal(CPostal.Column.art_desig.ToString())),
art_local = r.GetString(r.GetOrdinal(CPostal.Column.art_local.ToString())),
art_tipo = r.GetString(r.GetOrdinal(CPostal.Column.art_tipo.ToString())),
art_titulo = r.GetString(r.GetOrdinal(CPostal.Column.art_titulo.ToString())),
cc = r.GetString(r.GetOrdinal(CPostal.Column.cc.ToString())),
cliente = r.GetString(r.GetOrdinal(CPostal.Column.cliente.ToString())),
cod_arteria = r.GetString(r.GetOrdinal(CPostal.Column.cod_arteria.ToString())),
cod_localidade = r.GetString(r.GetOrdinal(CPostal.Column.cod_localidade.ToString())),
concelho = r.GetString(r.GetOrdinal(CPostal.Column.concelho.ToString())),
cp3 = r.GetString(r.GetOrdinal(CPostal.Column.cp3.ToString())),
cp4 = r.GetString(r.GetOrdinal(CPostal.Column.cp4.ToString())),
cpalf = r.GetString(r.GetOrdinal(CPostal.Column.cpalf.ToString())),
dd = r.GetString(r.GetOrdinal(CPostal.Column.dd.ToString())),
distrito = r.GetString(r.GetOrdinal(CPostal.Column.distrito.ToString())),
localidade = r.GetString(r.GetOrdinal(CPostal.Column.localidade.ToString())),
morada = r.GetString(r.GetOrdinal(CPostal.Column.morada.ToString())),
porta = r.GetString(r.GetOrdinal(CPostal.Column.porta.ToString())),
pri_prep = r.GetString(r.GetOrdinal(CPostal.Column.pri_prep.ToString())),
seg_prep = r.GetString(r.GetOrdinal(CPostal.Column.seg_prep.ToString())),
troco = r.GetString(r.GetOrdinal(CPostal.Column.troco.ToString()))
};
l.Add(c);
}
my.Command.Dispose();
r.Close();
my.Conection.Close();
return(l);
}
