Ejemplos de MarkomApplicationDBEntities.spProductSearch en C# (CSharp)

Ejemplo n.º 1

        public static List <ProductViewModel> GetListProduct(ProductViewModel paramSearch)
        {
            List <ProductViewModel> result = new List <ProductViewModel>();

            using (var context = new MarkomApplicationDBEntities())
            {
                var res = context.spProductSearch(paramSearch.code, paramSearch.name, paramSearch.description, paramSearch.createDate2, paramSearch.createBy);

                List <ProductViewModel> comList = res.Select(c => new ProductViewModel
                {
                    id          = c.id,
                    code        = c.code,
                    name        = c.name,
                    description = c.description,
                    createDate  = c.create_date,
                    createBy    = c.create_by
                }).ToList();

                result = comList;
            }

            return(result);
        }