public Boolean create(ProductDTO productDTO) { var product = EFModelToDTOUtil.ToProductMap(productDTO); product.CreationDate = DateTime.Now; Product insertedProduct = pocEntities.Products.Add(product); int savedObjects = pocEntities.SaveChanges(); return(savedObjects > 0 && insertedProduct.Id != 0); }
public ContainerDTO <ProductDTO> findAll(int start, int length) { int total = pocEntities.Products.Count(); var productList = pocEntities.Products.OrderBy(p => p.Id).Skip(start).Take(length).ToList(); var productDTOList = productList.Select(p => EFModelToDTOUtil.ToProductDTOMap(p)).ToList(); return(new ContainerDTO <ProductDTO>() { list = productDTOList, total = total }); }
public Boolean update(ProductDTO productDTO) { var productOldValues = pocEntities.Products.Single(p => p.Id == productDTO.Id); var productNewValues = EFModelToDTOUtil.ToProductMap(productDTO); productNewValues.CreationDate = productOldValues.CreationDate; // We don't want the user to change the CreationDate pocEntities.Entry(productOldValues).CurrentValues.SetValues(productNewValues); int savedObjects = pocEntities.SaveChanges(); return(savedObjects > 0); }
public IList <ProductDTO> findByCreationDate(DateTime creationDate) { var productList = pocEntities.Products.Where(p => p.CreationDate.Value == creationDate).ToList(); return(productList.Select(p => EFModelToDTOUtil.ToProductDTOMap(p)).ToList()); }
public ProductDTO findById(int id) { var product = pocEntities.Products.Single(p => p.Id == id); return(EFModelToDTOUtil.ToProductDTOMap(product)); }
public IList <ProductDTO> findAll() { var productList = pocEntities.Products.ToList(); return(productList.Select(p => EFModelToDTOUtil.ToProductDTOMap(p)).ToList()); }