Example #1
0
        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);
            }
        }
Example #2
0
        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"
            });
        }
Example #3
0
        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);
        }