public void Delete_Worker_test() { //Arrange DbContextOptions <WorkersContext> opt; var builder = new DbContextOptionsBuilder <WorkersContext>(); builder.UseInMemoryDatabase(databaseName: "database_test"); opt = builder.Options; var MoqContext = new WorkersContext(opt); var MoqRepo = new SQLrequest(MoqContext, new Logger <SQLrequest>(new LoggerFactory())); MoqRepo.Create(new WorkersModel { Id = 3, Name = "Sveta", Surname = "Svetlanovna", Email = "*****@*****.**", Login = "******", Password = "******", Role = "Worker", Place = "לעס", Culture = "en" }); var worker_delete = MoqRepo.GetWorkers(3); if (worker_delete != null) { MoqRepo.Remove(worker_delete); } }
public void Create_Worker_Test() { //Arrange DbContextOptions <WorkersContext> opt; var builder = new DbContextOptionsBuilder <WorkersContext>(); builder.UseInMemoryDatabase(databaseName: "database_test"); opt = builder.Options; var MoqContext = new WorkersContext(opt); var MoqRepo = new SQLrequest(MoqContext, new Logger <SQLrequest>(new LoggerFactory())); //Act MoqRepo.Create(new WorkersModel { Id = 1, Name = "Diana", Surname = "Vahomskaya", Email = "*****@*****.**", Login = "******", Password = "******", Role = "Admin", Place = "לעס", Culture = "ru" }); }
public void Edit_Worker_Test() { //Arrange DbContextOptions <WorkersContext> opt; var builder = new DbContextOptionsBuilder <WorkersContext>(); builder.UseInMemoryDatabase(databaseName: "database_test"); opt = builder.Options; var MoqContext = new WorkersContext(opt); var MoqRepo = new SQLrequest(MoqContext, new Logger <SQLrequest>(new LoggerFactory())); MoqRepo.Create(new WorkersModel { Id = 2, Name = "Mariya", Surname = "Polovinkina", Email = "*****@*****.**", Login = "******", Password = "******", Role = "Worker", Place = "לודאפמם", Culture = "ru" }); if (MoqRepo.GetWorkers(2) != null) { var WorkerEdit = MoqRepo.GetWorkers(2); WorkerEdit.Name = "Dima"; MoqRepo.Edit(WorkerEdit); } var worker = MoqRepo.GetWorkers_workers(); var workerEdit = MoqRepo.GetWorkers(2); Assert.AreEqual(2, worker.Count()); Assert.AreEqual("Dima", workerEdit.Name); }