public ICollection <ItemDTO> CreateItem(ItemDTO newItem)
        {
            _validator.ValidateAndThrow(newItem);

            var mappedItem = _mapper.Map <Item>(newItem);

            if (mappedItem != null)
            {
                mappedItem.IsDeleted      = false;
                mappedItem.LastModifiedOn = DateTime.Now;
                _context.Item.Add(mappedItem);
                _context.SaveChanges();
                return(GetAllItems());
            }

            throw new NullReferenceException();
        }
Example #2
0
        public static void CleanupData()
        {
            //startup
            var all = dbContext.Item.ToList();

            dbContext.RemoveRange(all);
            dbContext.Database
            .ExecuteSqlRaw("UPDATE SQLITE_SEQUENCE SET SEQ= '0' WHERE NAME='Item';");
            dbContext.SaveChanges();
        }