public MySqlDataReader ExecuteCommand(string sql, List <MySqlParameter> param, int limit, int offset) { StringBuilder sqlLimit = new StringBuilder(sql) .Append(CpMySql.GetLimit(limit, offset)); this.CreateConn().Open(); Command = new MySqlCommand(sqlLimit.ToString(), Conection); foreach (MySqlParameter p in param) { Command.Parameters.Add(p); } return(Command.ExecuteReader()); }
/// <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); }