public void Search() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseInMemoryDatabase(databaseName: "Search") .Options; AppDbContext context = new AppDbContext(options); var service = new ReportRepository(context); service.CreateReport(report2); service.CreateReport(report3); context.SaveChanges(); Search search1 = new Search() { FirstName = "Report 2" }; Search search2 = new Search() { LastName = "Blogs" }; Search search3 = new Search() { FirstName = "Mary" }; List <Reports> Result1 = service.Search(search1); List <Reports> Result2 = service.Search(search2); List <Reports> Result3 = service.Search(search3); Assert.AreEqual(1, Result1.Count()); Assert.AreEqual("Report 2", Result1.First().Subject.FirstName); Assert.AreEqual(2, Result2.Count()); Assert.AreEqual(0, Result3.Count()); }
public void Remove() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseInMemoryDatabase(databaseName: "Remove") .Options; AppDbContext context = new AppDbContext(options); var service = new ReportRepository(context); service.CreateReport(report); service.CreateReport(report2); context.SaveChanges(); Assert.AreEqual(2, context.Reports.Count()); service.RemoveReport(report); Assert.AreEqual(1, context.Reports.Count()); Assert.AreEqual("Report 2", context.Reports.First().Subject.FirstName); }
public void GetPending() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseInMemoryDatabase(databaseName: "GetPending") .Options; AppDbContext context = new AppDbContext(options); var service = new ReportRepository(context); service.CreateReport(report); service.CreateReport(report2); service.CreateReport(report3); context.SaveChanges(); Assert.AreEqual(2, service.GetPending("1")); Assert.AreEqual(1, service.GetPending("2")); Assert.AreEqual(0, service.GetPending("3")); }
public void GetReportByID() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseInMemoryDatabase(databaseName: "Database") .Options; AppDbContext context = new AppDbContext(options); var service = new ReportRepository(context); service.CreateReport(report); service.CreateReport(report2); service.CreateReport(report3); context.SaveChanges(); Reports Result1 = service.GetReportById(report.ReportId); Reports Result2 = service.GetReportById(report2.ReportId); Reports Result3 = service.GetReportById(report3.ReportId); Assert.AreEqual(report, Result1); Assert.AreNotEqual(report2, Result1); Assert.AreEqual(report3, Result3); }
public void Update() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseInMemoryDatabase(databaseName: "Update") .Options; AppDbContext context = new AppDbContext(options); var service = new ReportRepository(context); service.CreateReport(report2); report2.Subject.FirstName = "ReportB"; service.UpdateReport(report2); Assert.AreEqual("ReportB", context.Reports.First().Subject.FirstName); Assert.AreEqual(true, context.Reports.First().Complete); }
public void Create() { var options = new DbContextOptionsBuilder <AppDbContext>() .UseInMemoryDatabase(databaseName: "Tempory DataBase") .Options; AppDbContext context = new AppDbContext(options); var service = new ReportRepository(context); service.CreateReport(report); context.SaveChanges(); Assert.AreEqual(1, context.Reports.Count()); Assert.AreEqual(report.ReportId, context.Reports.First().ReportId); }