static int InsertCategory() { Console.WriteLine("Inserting category..."); var category = new Category() { Name = "Processors", Created = Timestamp, Updated = Timestamp }; using (var uow = new TpcUnitOfWork(Context)) { var categoryRepository = uow.GetRepository <Category>(); categoryRepository.Insert(category); return(uow.Commit()); } }
// Methods static List <Item> GetItems() { using (var uow = new TpcUnitOfWork(Context)) { // Insert item... var itemRepository = uow.GetRepository <Item>(); var spec = new ExpressionSpecification <Item>() .Not(i => (i.Header.Title.Contains("H"))) .Or(i => i.Amount >= 300); var include = new PropertyNavigator <Item>() .Include(i => i.Header) .Include(i => i.Entry) .Properties; return(itemRepository .Select(spec, include) .ToList()); } }
static int InsertItem() { Console.WriteLine("Inserting item..."); var header = new Header() { Title = string.Empty.PadRight(50, 'X'), UserId = 1, Created = Timestamp, Updated = Timestamp }; var entry = new Entry() { Message = string.Empty.PadRight(2000, 'Y'), Created = Timestamp, Updated = Timestamp }; var item = new Item() { Header = header, Entry = entry, CategoryId = 2, UserId = 1, Amount = 300, Section = ItemSection.ForSale, Condition = ItemCondition.BrandNew, Warranty = ItemWarranty.Personal, Created = Timestamp, Updated = Timestamp, Expiry = Timestamp.AddDays(30) }; using (var uow = new TpcUnitOfWork(Context)) { // Insert item... var itemRepository = uow.GetRepository <Item>(); itemRepository.Insert(item); return(uow.Commit()); } }
// Methods static List<Item> GetItems() { using (var uow = new TpcUnitOfWork(Context)) { // Insert item... var itemRepository = uow.GetRepository<Item>(); var spec = new ExpressionSpecification<Item>() .Not(i => (i.Header.Title.Contains("H"))) .Or(i => i.Amount >= 300); var include = new PropertyNavigator<Item>() .Include(i => i.Header) .Include(i => i.Entry) .Properties; return itemRepository .Select(spec, include) .ToList(); } }
static int InsertItem() { Console.WriteLine("Inserting item..."); var header = new Header() { Title = string.Empty.PadRight(50, 'X'), UserId = 1, Created = Timestamp, Updated = Timestamp }; var entry = new Entry() { Message = string.Empty.PadRight(2000, 'Y'), Created = Timestamp, Updated = Timestamp }; var item = new Item() { Header = header, Entry = entry, CategoryId = 2, UserId = 1, Amount = 300, Section = ItemSection.ForSale, Condition = ItemCondition.BrandNew, Warranty = ItemWarranty.Personal, Created = Timestamp, Updated = Timestamp, Expiry = Timestamp.AddDays(30) }; using (var uow = new TpcUnitOfWork(Context)) { // Insert item... var itemRepository = uow.GetRepository<Item>(); itemRepository.Insert(item); return uow.Commit(); } }
static int InsertCategory() { Console.WriteLine("Inserting category..."); var category = new Category() { Name = "Processors", Created = Timestamp, Updated = Timestamp }; using (var uow = new TpcUnitOfWork(Context)) { var categoryRepository = uow.GetRepository<Category>(); categoryRepository.Insert(category); return uow.Commit(); } }