public void Test05ListCustomersViaServiceProductCategoryIdNonNullOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var list = service.GetAll <Product>().Computed().ToList();
//VERIFY
list.Count.ShouldBeGreaterThan(0);
list.Any(x => x.ProductCategoryIDNonNull != 0).ShouldEqual(true);
}
}
public void Test02ListSalesOrdersViaServiceOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var list = service.GetAll<ListSalesOrderDto>().ToList();
//VERIFY
list.Count.ShouldBeGreaterThan(0);
list[0].CustomerCompanyName.ShouldNotEqualNull();
}
}
public void Test02ListSalesOrdersViaServiceOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var list = service.GetAll <ListSalesOrderDto>().ToList();
//VERIFY
list.Count.ShouldBeGreaterThan(0);
list[0].CustomerCompanyName.ShouldNotEqualNull();
}
}
public void Test05ListCustomersViaServiceProductCategoryIdNonNullOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var list = service.GetAll<Product>().Computed().ToList();
//VERIFY
list.Count.ShouldBeGreaterThan(0);
list.Any( x => x.ProductCategoryIDNonNull != 0).ShouldEqual(true);
}
}
public void Test01ListOrderDetailViaServiceOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var list = service.GetAll<CrudSalesOrderDetailDto>().ToList();
//VERIFY
list.Count.ShouldBeGreaterThan(0);
list.First().ProductName.ShouldNotEqualNull();
}
}
public void Test01ListOrderDetailViaServiceOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var list = service.GetAll <CrudSalesOrderDetailDto>().ToList();
//VERIFY
list.Count.ShouldBeGreaterThan(0);
list.First().ProductName.ShouldNotEqualNull();
}
}
public void Check01ListGradesOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService <PostTagGrade, SimplePostTagGradeDto>(db);
var firstGrade = db.PostTagGrades.Include(x => x.TagPart).Include(x => x.PostPart).First();
//ATTEMPT
var list = service.GetAll().ToList();
//VERIFY
list.Count().ShouldEqual(2);
list.First().PostPartTitle.ShouldEqual(firstGrade.PostPart.Title);
list.First().TagPartName.ShouldEqual(firstGrade.TagPart.Name);
}
}
public void Test01ListCustomersCheckIsOnSaleOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var list = service.GetAll<ListProductDto>().Computed().ToList();
//VERIFY
list.Count.ShouldBeGreaterThan(0);
list.Where( c => c.SellStartDate < DateTime.Today && (DateTime.Today <= (c.SellEndDate ?? DateTime.Today))).All( x => x.IsOnSale).ShouldEqual(true);
list.Where(c => !(c.SellStartDate < DateTime.Today && (DateTime.Today <= (c.SellEndDate ?? DateTime.Today)))).All(x => x.IsOnSale).ShouldEqual(false);
}
}
public void Test01ListCustomersCheckIsOnSaleOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var list = service.GetAll <ListProductDto>().Computed().ToList();
//VERIFY
list.Count.ShouldBeGreaterThan(0);
list.Where(c => c.SellStartDate < DateTime.Today && (DateTime.Today <= (c.SellEndDate ?? DateTime.Today))).All(x => x.IsOnSale).ShouldEqual(true);
list.Where(c => !(c.SellStartDate < DateTime.Today && (DateTime.Today <= (c.SellEndDate ?? DateTime.Today)))).All(x => x.IsOnSale).ShouldEqual(false);
}
}
public void Check01ListGradesOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService<PostTagGrade, SimplePostTagGradeDto>(db);
var firstGrade = db.PostTagGrades.Include(x => x.TagPart).Include(x => x.PostPart).First();
//ATTEMPT
var list = service.GetAll().ToList();
//VERIFY
list.Count().ShouldEqual(2);
list.First().PostPartTitle.ShouldEqual(firstGrade.PostPart.Title);
list.First().TagPartName.ShouldEqual(firstGrade.TagPart.Name);
}
}
public void Check02ListPostOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService <Post, SimplePostDto>(db);
//ATTEMPT
var list = service.GetAll().ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Title.ShouldEqual("First great post");
list.First().BloggerName.ShouldEqual("Jon Smith");
list.First().TagNames.ShouldEqual("Ugly post, Good post");
list.First().LastUpdatedUtc.Kind.ShouldEqual(DateTimeKind.Utc);
}
}
public void Test02ListDirectPostOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService<Post>(db);
var firstPost = db.Posts.Include(x => x.Blogger).First();
//ATTEMPT
var list = service.GetAll().Include(x => x.Blogger).ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Title.ShouldEqual(firstPost.Title);
list.First().Blogger.Name.ShouldEqual(firstPost.Blogger.Name);
list.First().Tags.ShouldEqual(null);
}
}
public void Check10ListNestedComputedOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true;
var service = new ListService <Tag, DelegateDecompileNeededPostDto>(db);
var firstTag = db.Tags.Include(x => x.Posts).First();
//ATTEMPT
var list = service.GetAll().OrderBy(x => x.TagId).ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Name.ShouldEqual(firstTag.Name);
list.First().Posts.First().BloggerNameAndEmail.ShouldNotEqualNull();
}
}
public void Check02ListDirectPostOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService <Post>(db);
var firstPost = db.Posts.Include(x => x.Blogger).First();
//ATTEMPT
var list = service.GetAll().Include(x => x.Blogger).ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Title.ShouldEqual(firstPost.Title);
list.First().Blogger.Name.ShouldEqual(firstPost.Blogger.Name);
list.First().Tags.ShouldEqual(null);
}
}
public void Check02NoComputedTakenInDtoDecomplierOnButNoComputedCopiedOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true;
var service = new ListService<Post, SimplePostDto>(db);
var firstPost = db.Posts.Include(x => x.Blogger).OrderBy(x => x.PostId).First();
//ATTEMPT
var list = service.GetAll().OrderBy(x => x.PostId).ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Title.ShouldEqual(firstPost.Title);
list.First().BloggerName.ShouldEqual(firstPost.Blogger.Name);
list.First().Tags.ShouldNotEqualNull();
}
}
public void Check02ListBlogsCheckIncludesPostsOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService<Blog, SimpleBlogWithPostsDto>(db);
//ATTEMPT
var list = service.GetAll().ToList();
//VERIFY
list.Count().ShouldEqual(2);
var firstBlog = db.Blogs.Include(x => x.Posts).AsNoTracking().First();
list.First().Name.ShouldEqual(firstBlog.Name);
list.First().EmailAddress.ShouldEqual(firstBlog.EmailAddress);
list.First().Posts.ShouldNotEqualNull();
CollectionAssert.AreEquivalent(firstBlog.Posts.Select(x => x.PostId), list.First().Posts.Select(x => x.PostId));
}
}
public void Test06ListCustomersPerformanceVer2Ok()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
var log = new List <string>();
db.Database.Log = log.Add;
//ATTEMPT
var query = service.GetAll <ListCustomerVer2Dto>().Where(x => x.HasBoughtBefore);
var customers = query.ToList();
//VERIFY
customers.Count.ShouldBeGreaterThan(0);
customers[0].FullName.ShouldNotEqualNull();
customers.All(x => x.TotalAllOrders > 0).ShouldEqual(true);
}
}
public void Test02ListCustomersViaServiceNoTotalOrdersOk()
{
using (var db = new AdventureWorksLt2012())
{
//SETUP
var service = new ListService(db);
var log = new List<string>();
db.Database.Log = log.Add;
//ATTEMPT
var query = service.GetAll<ListCustomerDto>().Where(x => !x.HasBoughtBefore);
var customers = query.ToList();
//VERIFY
customers.Count.ShouldBeGreaterThan(0);
customers[0].FullName.ShouldNotEqualNull();
customers.All(x => x.TotalAllOrders == 0).ShouldEqual(true);
}
}
public void Check02ListBlogsCheckIncludesPostsOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService <Blog, SimpleBlogWithPostsDto>(db);
//ATTEMPT
var list = service.GetAll().ToList();
//VERIFY
list.Count().ShouldEqual(2);
var firstBlog = db.Blogs.Include(x => x.Posts).AsNoTracking().First();
list.First().Name.ShouldEqual(firstBlog.Name);
list.First().EmailAddress.ShouldEqual(firstBlog.EmailAddress);
list.First().Posts.ShouldNotEqualNull();
CollectionAssert.AreEquivalent(firstBlog.Posts.Select(x => x.PostId), list.First().Posts.Select(x => x.PostId));
}
}
public void Check02NoComputedTakenInDtoDecomplierOnButNoComputedCopiedOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true;
var service = new ListService <Post, SimplePostDto>(db);
var firstPost = db.Posts.Include(x => x.Blogger).OrderBy(x => x.PostId).First();
//ATTEMPT
var list = service.GetAll().OrderBy(x => x.PostId).ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Title.ShouldEqual(firstPost.Title);
list.First().BloggerName.ShouldEqual(firstPost.Blogger.Name);
list.First().Tags.ShouldNotEqualNull();
}
}
public void Check02ListPostDtoOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService(db);
//ATTEMPT
var query = service.GetAll<SimplePostDto>();
var list = query.ToList();
//VERIFY
list.Count.ShouldEqual(3);
list[0].Title.ShouldEqual("First great post");
list[0].BloggerName.ShouldEqual("Jon Smith");
list[0].TagNames.ShouldEqual("Ugly post, Good post");
list[0].LastUpdatedUtc.Kind.ShouldEqual(DateTimeKind.Utc);
}
}
public void Check02ListPostOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService(db);
var firstPost = db.Posts.Include(x => x.Blogger).First();
//ATTEMPT
var query = service.GetAll<Post>().Include(x => x.Blogger);
var list = query.ToList();
//VERIFY
list.Count.ShouldEqual(3);
list[0].Title.ShouldEqual(firstPost.Title);
list[0].Blogger.Name.ShouldEqual(firstPost.Blogger.Name);
list[0].Tags.ShouldEqual(null);
}
}
public async void Check02ListPostOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService <Post, DetailPostDtoAsync>(db);
//ATTEMPT
var list = await service.GetAll().ToListAsync();
//VERIFY
list.Count().ShouldEqual(3);
var firstPost = db.Posts.Include(x => x.Tags).ToList().First(x => x.PostId == list.First().PostId);
list.First().Title.ShouldEqual(firstPost.Title);
list.First().Content.ShouldEqual(firstPost.Content);
list.First().BloggerName.ShouldEqual(firstPost.Blogger.Name);
list.First().TagNames.ShouldEqual("Ugly post, Good post");
list.First().LastUpdatedUtc.Kind.ShouldEqual(DateTimeKind.Utc);
}
}
public void Check05ListComputedOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true;
var service = new ListService <Post, DelegateDecompilePostDto>(db);
var firstPost = db.Posts.Include(x => x.Tags).First();
//ATTEMPT
var list = service.GetAll().OrderBy(x => x.PostId).ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Title.ShouldEqual(firstPost.Title);
list.First().BloggerNameAndEmail.ShouldEndWith("nospam.com)");
list.First().TagNames.ShouldNotEqualNull();
CollectionAssert.AreEqual(firstPost.Tags.Select(x => x.Name), list.First().TagNames);
}
}
public void Check05ListComputedOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true;
var service = new ListService<Post, DelegateDecompilePostDto>(db);
var firstPost = db.Posts.Include(x => x.Tags).First();
//ATTEMPT
var list = service.GetAll().OrderBy(x => x.PostId).ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Title.ShouldEqual(firstPost.Title);
list.First().BloggerNameAndEmail.ShouldEndWith("nospam.com)");
list.First().TagNames.ShouldNotEqualNull();
CollectionAssert.AreEqual(firstPost.Tags.Select(x => x.Name), list.First().TagNames);
}
}
public void Check08UpdateWithListDtoBad()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var listService = new ListService <Post, SimplePostDto>(db);
var firstPostUntracked = listService.GetAll().First();
var service = new UpdateService <Post, SimplePostDto>(db);
//ATTEMPT
firstPostUntracked.Title = "Can't I ask a question?";
var status = service.Update(firstPostUntracked);
firstPostUntracked.LogSpecificName("End");
//VERIFY
status.IsValid.ShouldEqual(false);
status.Errors.Count.ShouldEqual(1);
status.Errors[0].ErrorMessage.ShouldEqual("Sorry, but you can't ask a question, i.e. the title can't end with '?'.");
}
}
public void Check10ListNestedComputedOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
GenericServicesConfig.UseDelegateDecompilerWhereNeeded = true;
var service = new ListService<Tag, DelegateDecompileNeededPostDto>(db);
var firstTag = db.Tags.Include(x => x.Posts).First();
//ATTEMPT
var list = service.GetAll().OrderBy(x => x.TagId).ToList();
//VERIFY
list.Count().ShouldEqual(3);
list.First().Name.ShouldEqual(firstTag.Name);
list.First().Posts.First().BloggerNameAndEmail.ShouldNotEqualNull();
}
}
private static void RunCommand2(IGenericServicesDbContext db)
{
var service = new ListService(db);
var list = service.GetAll <SimplePostDto>().ToList();
}
public IQueryable <TEntity> GetAll()
{
return(ListService.GetAll());
}
//=====================================================
//now the generic versions
public static void ListGSelectDirect <T>(this SampleWebAppDb db, int id) where T : class, new()
{
var service = new ListService(db);
var num = service.GetAll <T>().ToList().Count;
}
//=====================================================
//now the self-selecting
public static void ListGenericDirect <T>(this SampleWebAppDb db, int id) where T : class
{
var service = new ListService <T>(db);
var num = service.GetAll().ToList().Count;
}
public static async Task ListGSelectDirectAsync <T>(this SampleWebAppDb db, int id) where T : class, new()
{
var service = new ListService(db);
var list = await service.GetAll <T>().ToListAsync();
}
public void Check02ListPostOk()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var service = new ListService<Post, DetailPostDto>(db);
//ATTEMPT
var list = service.GetAll().ToList();
//VERIFY
list.Count().ShouldEqual(3);
var firstPost = db.Posts.Include(x => x.Tags).ToList().First(x => x.PostId == list.First().PostId);
list.First().Title.ShouldEqual(firstPost.Title);
list.First().Content.ShouldEqual(firstPost.Content);
list.First().BloggerName.ShouldEqual(firstPost.Blogger.Name);
list.First().TagNames.ShouldEqual("Ugly post, Good post");
list.First().LastUpdatedUtc.Kind.ShouldEqual(DateTimeKind.Utc);
}
}
public void Check09UpdateWithListDtoBad()
{
using (var db = new SampleWebAppDb())
{
//SETUP
var listService = new ListService<Post, SimplePostDto>(db);
var firstPostUntracked = listService.GetAll().First();
var service = new UpdateService<Post, SimplePostDto>(db);
//ATTEMPT
firstPostUntracked.Title = "Can't I ask a question?";
var status = service.Update(firstPostUntracked);
firstPostUntracked.LogSpecificName("End");
//VERIFY
status.IsValid.ShouldEqual(false);
status.Errors.Count.ShouldEqual(1);
status.Errors[0].ErrorMessage.ShouldEqual("Sorry, but you can't ask a question, i.e. the title can't end with '?'.");
}
}
public static void ListPostGenericViaDto(this SampleWebAppDb db, int id)
{
var service = new ListService <Post, SimplePostDto>(db);
var num = service.GetAll().ToList().Count;
}
private static void RunCommand2(IGenericServicesDbContext db)
{
var service = new ListService(db);
var list = service.GetAll<SimplePostDto>().ToList();
}
public static void ListPostGSelectViaDto(this SampleWebAppDb db, int id)
{
var service = new ListService(db);
var num = service.GetAll <SimplePostDto>().ToList().Count;
}
public static async Task ListGenericDirectAsync <T>(this SampleWebAppDb db, int id) where T : class
{
var service = new ListService <T>(db);
var list = await service.GetAll().ToListAsync();
}
public static async Task ListPostGSelectViaDtoAsync(this SampleWebAppDb db, int id)
{
var service = new ListService(db);
var list = await service.GetAll <SimplePostDto>().ToListAsync();
}
