public List <UBIGEO> ListarDistrito(string idprovi, string iddepacomer) { string findAll = "select*from v_Distrito where IdProvincia='" + idprovi + "'and IdDepartamento='" + iddepacomer + "'order by DISTRITO"; List <UBIGEO> listapro = new List <UBIGEO>(); try { string cnx = db.Database.Connection.ConnectionString; con = new SqlConnection(cnx); comando = new SqlCommand(findAll, con); con.Open(); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { UBIGEO objpro = new UBIGEO(); objpro.UBIGEO1 = reader[0].ToString(); objpro.DISTRITO = reader[1].ToString(); listapro.Add(objpro); } } catch (Exception) { throw; } finally { con.Close(); } return(listapro); }
public List <UBIGEO> ListarDepartamento() { string findAll = "select*from v_Departamento order by DEPARTAM"; List <UBIGEO> listapro = new List <UBIGEO>(); try { string cnx = db.Database.Connection.ConnectionString; con = new SqlConnection(cnx); comando = new SqlCommand(findAll, con); con.Open(); SqlDataReader reader = comando.ExecuteReader(); while (reader.Read()) { UBIGEO objpro = new UBIGEO(); objpro.UBIGEO1 = reader[0].ToString(); objpro.DEPARTAM = reader[1].ToString(); listapro.Add(objpro); } } catch (Exception) { throw; } finally { con.Close(); } return(listapro); }