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 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 HomeController(
IGenerateWorkersList generateWorkersList,
WorkersContext context
)
{
_generateWorkersData = generateWorkersList;
_context = context;
}
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);
}
public DeleteProject(WorkersContext context)
{
_context = context;
}
public CreateProject(WorkersContext context)
{
_context = context;
}
public ProjectsPage(WorkersContext context)
{
_context = context;
}
public WorkerService(WorkersContext context)
{
_context = context;
}
public SQLrequest(WorkersContext workersContext, ILogger <SQLrequest> logger)
{
WorkersContext = workersContext;
_logger = logger;
_logger.LogDebug("Data base");
}
public EditWorker(WorkersContext context)
{
_context = context;
}
public AddProject(WorkersContext context)
{
_context = context;
}
public WorkersPage(WorkersContext context)
{
_context = context;
}
public UnlinkProject(WorkersContext context)
{
_context = context;
}
public CreateWorker(WorkersContext context)
{
_context = context;
}
public EditProject(WorkersContext context)
{
_context = context;
}
public WorkerRepository(WorkersContext context)
{
_context = context;
}
public RatingModel(WorkersContext context)
{
_context = context;
}
public DeleteWorker(WorkersContext context)
{
_context = context;
}
public WorkersViewModel GenerateWorkersData(WorkersContext workersContext)
{
//var daysData = new Days
//{
// Day = DateTime.Now
//};
//workersContext.Days.Add(daysData);
//daysData = new Days
//{
// Day = DateTime.Now.AddDays(1)
//};
//workersContext.Days.Add(daysData);
//workersContext.SaveChanges();
//var testCheck1 = workersContext.DaysOfWork.ToList();
//var workersData = new Workers
//{
// Name = "Antek",
// Surname = "Walentynowicz",
// PhoneNumber = "234432234",
// Position = "Medic",
// Shift = "2",
// Unity = "1",
//};
//workersContext.Workers.Add(workersData);
//workersData = new Workers
//{
// Name = "Bartosz",
// Surname = "Walenrod",
// PhoneNumber = "345654789",
// Position = "Enginerr",
// Shift = "1",
// Unity = "2",
//};
//workersContext.Workers.Add(workersData);
var dateTime = DateTime.Now;
var allWorkersList = workersContext.Workers.Select(t => t).ToList();
var daysOfWorkIds = workersContext.Days
//.Where(y => y.Day.Day == dateTime.Day || y.Day.Day == dateTime.AddDays(1).Day)
.ToList();
var dayOfWorkData = workersContext.DaysOfWork.Select(t => t).ToList();
var workersAssigmentData = dayOfWorkData.Join(daysOfWorkIds,
dw => dw.DayId,
d => d.Id,
(dw, d) => new { d.Day, dw.Unity, dw.Shift, dw.WorkerId })
.Join(allWorkersList,
dw => dw.WorkerId,
wc => wc.Id,
(dw, wc) => new { wc.Name, wc.Surname, wc.Position, dw.Day, dw.Shift, dw.Unity })
.Select(x => new WorkersAssigmentData {
Name = x.Name, Surname = x.Surname, Position = x.Position, Shift = x.Shift, Unity = x.Unity, Day = x.Day
})
.ToList();
var data = new WorkersViewModel
{
AllWorkersList = allWorkersList,
WorkersAssigmentData = workersAssigmentData
};
return(data);
}
