//Permite consultar los detalles en el catalogo de formas de empaque
public CatTypeFormPack ConsultarListatipoFormPack(int?id)
{
CatTypeFormPack TipoForn = new CatTypeFormPack();
Conexion conn = new Conexion();
try
{
SqlCommand comando = new SqlCommand();
SqlDataReader leer = null;
comando.Connection = conn.AbrirConexion();
comando.CommandText = "SELECT * FROM CAT_TYPE_FORM_PACK WHERE ID_TYPE_FORM_PACK='" + id + "'";
leer = comando.ExecuteReader();
while (leer.Read())
{
TipoForn.IdTipoFormPack = Convert.ToInt32(leer["ID_TYPE_FORM_PACK"]);
TipoForn.TipoFormPack = leer["TYPE_FORM_PACK"].ToString();
}
}
finally
{
conn.CerrarConexion();
conn.Dispose();
}
return(TipoForn);
}
//Listado del catalogo de tipo de forma de empaque
public IEnumerable <CatTypeFormPack> ListaTipoFormaPack()
{
List <CatTypeFormPack> listTipoFormPack = new List <CatTypeFormPack>();
Conexion conn = new Conexion();
try
{
SqlCommand comando = new SqlCommand();
SqlDataReader leer = null;
comando.Connection = conn.AbrirConexion();
comando.CommandText = "SELECT * FROM CAT_TYPE_FORM_PACK ";
leer = comando.ExecuteReader();
while (leer.Read())
{
CatTypeFormPack packing = new CatTypeFormPack()
{
IdTipoFormPack = Convert.ToInt32(leer["ID_TYPE_FORM_PACK"]),
TipoFormPack = leer["TYPE_FORM_PACK"].ToString()
};
listTipoFormPack.Add(packing);
}
leer.Close();
}
finally
{
conn.CerrarConexion();
conn.Dispose();
}
return(listTipoFormPack);
}
