Esempio n. 1
0
        public List <Proveedor> ListarProveedores()
        {
            List <Proveedor> results = new List <Proveedor>();

            try
            {
                using (ListaNegraDataContext dc = new ListaNegraDataContext(Helper.ConnectionString()))
                {
                    var query = from item in dc.stp_ListarProveedores()
                                select new Proveedor
                    {
                        iProveedorId = item.iProveedorId,
                        strNombre    = item.vchDescripcion
                    };
                    results.AddRange(query);
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(results);
        }
Esempio n. 2
0
 public List<Proveedor> ListarProveedores()
 {
     List<Proveedor> results = new List<Proveedor>();
     try
     {
         using (ListaNegraDataContext dc = new ListaNegraDataContext(Helper.ConnectionString()))
         {
             var query = from item in dc.stp_ListarProveedores()
                         select new Proveedor
                         {
                             iProveedorId = item.iProveedorId,
                             strNombre = item.vchDescripcion
                         };
             results.AddRange(query);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
     return results;
 }