public List <InfDomicilioBean> sp_Domicilio_Retrieve_Domicilio(int codepost)
{
List <InfDomicilioBean> listInfDomBean = new List <InfDomicilioBean>();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_Domicilio_Retrieve_Domicilio", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add(new SqlParameter("@ctrlCodigoPostal", codepost));
SqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
while (data.Read())
{
InfDomicilioBean infDomBean = new InfDomicilioBean();
infDomBean.sCiudad = data["Ciudad"].ToString();
infDomBean.iIdColonia = Convert.ToInt32(data["IdColonia"].ToString());
infDomBean.sColonia = data["Colonia"].ToString();
infDomBean.iIdMunicipio = Convert.ToInt32(data["IdMunicipio"].ToString());
infDomBean.sMensaje = data["Municipio"].ToString();
infDomBean.sValor = data["Estado"].ToString();
listInfDomBean.Add(infDomBean);
}
}
cmd.Dispose(); cmd.Parameters.Clear(); data.Close(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(listInfDomBean);
}
public List <InfDomicilioBean> sp_CatalogoGeneral_Retrieve_CatalogoGeneral(int catalogid)
{
List <InfDomicilioBean> listInfDomBean = new List <InfDomicilioBean>();
try
{
this.Conectar();
SqlCommand cmd = new SqlCommand("sp_CatalogoGeneral_Retrieve_CatalogoGeneral", this.conexion)
{
CommandType = CommandType.StoredProcedure
};
cmd.Parameters.Add(new SqlParameter("@ctrlCatalogoId", catalogid));
SqlDataReader data = cmd.ExecuteReader();
if (data.HasRows)
{
while (data.Read())
{
InfDomicilioBean infDomBean = new InfDomicilioBean();
infDomBean.iIdValor = Convert.ToInt32(data["IdValor"].ToString());
infDomBean.sValor = data["Valor"].ToString();
infDomBean.iId = Convert.ToInt32(data["id"].ToString());
listInfDomBean.Add(infDomBean);
}
}
cmd.Dispose(); cmd.Parameters.Clear(); data.Close(); conexion.Close();
}
catch (Exception exc)
{
Console.WriteLine(exc);
}
return(listInfDomBean);
}
