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);
}
