public List <Pais_Mdl> PaisSeleccionado(int idPais)
{
List <Pais_Mdl> listapaises = new List <Pais_Mdl>();
MySqlConnection cnObj = new MySqlConnection();
cnObj = objConexion.Conectar();
if (cnObj != null)
{
MySqlCommand cmdObj = new MySqlCommand();
cmdObj.Connection = cnObj;
string strSql;
strSql = "SELECT ";
strSql += "id_pais, ";
strSql += "pais ";
strSql += "FROM ";
strSql += "pais ";
strSql += "WHERE ";
strSql += "id_pais = " + idPais + "";
cmdObj.CommandText = strSql;
MySqlDataReader rdrObj = cmdObj.ExecuteReader();
while (rdrObj.Read())
{
Pais_Mdl objPais = new Pais_Mdl
{
id_pais = rdrObj[0].ToString(),
pais = rdrObj[1].ToString()
};
listapaises.Add(objPais);
}
rdrObj.Close();
cnObj.Close();
}
return(listapaises);
}
public List <Pais_Mdl> ListaPais(string Servidor)
{
List <Pais_Mdl> listapais = new List <Pais_Mdl>();
SqlConnection cnObj = new SqlConnection();
cnObj = objConexion.Conectar_Master(Servidor);
if (cnObj != null)
{
using (cnObj)
{
SqlCommand cmdObj = new SqlCommand();
cmdObj.Connection = cnObj;
string strSql;
strSql = "SELECT ";
strSql += "id_pais, ";
strSql += "pais ";
strSql += "FROM ";
strSql += "pais";
cmdObj.CommandText = strSql;
SqlDataReader rdrObj = cmdObj.ExecuteReader();
while (rdrObj.Read())
{
Pais_Mdl objPais = new Pais_Mdl();
objPais.id_pais = Convert.ToInt32(rdrObj[0].ToString());
objPais.pais = rdrObj[1].ToString();
listapais.Add(objPais);
}
rdrObj.Close();
}
}
return(listapais);
}
