public List <TrainingDb> GetAll()
{
using (var context = new QualificationDbContext())
{
return(context.Trainings.ToList());
}
}
public List <SelfCheckDb> GetAll()
{
using (var context = new QualificationDbContext())
{
return(context.SelfChecks.ToList());
}
}
public List <StaffDb> GetAll()
{
using (var context = new QualificationDbContext())
{
return(context.Staffs.ToList());
}
}
public void UpdateOperation(OperationDb operationDb)
{
using (var context = new QualificationDbContext())
{
context.Entry(operationDb).State = EntityState.Modified;
context.SaveChanges();
}
}
public void DeleteModel(ModelDb modelDb)
{
using (var context = new QualificationDbContext())
{
context.Entry(modelDb).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void DeleteProject(ProjectDb projectDb)
{
using (var context = new QualificationDbContext())
{
context.Entry(projectDb).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void DeleteDocument(DocumentDb documentDb)
{
using (var context = new QualificationDbContext())
{
context.Entry(documentDb).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Delete(StaffDb staffDb)
{
using (var context = new QualificationDbContext())
{
context.Entry(staffDb).State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Add(TrainingDb trainingDb)
{
using (var context = new QualificationDbContext())
{
context.Trainings.Add(trainingDb);
context.SaveChanges();
}
}
public void AddModel(ModelDb modelDb, Guid projectId)
{
using (var context = new QualificationDbContext())
{
var projectDb = context.Projects.Include(p => p.Models).FirstOrDefault(p => p.Id == projectId);
projectDb.Models.Add(modelDb);
context.SaveChanges();
}
}
public ProjectDb AddProject(ProjectDb projectDb)
{
using (var context = new QualificationDbContext())
{
context.Projects.Add(projectDb);
context.SaveChanges();
return(projectDb);
}
}
public void DeleteOperation(Guid operationId)
{
using (var context = new QualificationDbContext())
{
var operationDb = context.Operations.FirstOrDefault(o => o.Id == operationId);
context.Operations.Remove(operationDb);
context.SaveChanges();
}
}
public StaffDb Add(StaffDb staffDb) // вернуть обновленный staffDb
{
using (var context = new QualificationDbContext())
{
var entity = context.Staffs.Add(staffDb);
context.SaveChanges();
return(entity);
}
}
public SelfCheckDb Add(SelfCheckDb selfCheckDb)
{
using (var context = new QualificationDbContext())
{
var selfCheckDbWithId = context.SelfChecks.Add(selfCheckDb);
context.SaveChanges();
return(selfCheckDbWithId);
}
}
public DocumentDb AddDocument(DocumentDb documentDb, Guid operationId)
{
using (var context = new QualificationDbContext())
{
var operationDb = context.Operations.Include(o => o.Documents).FirstOrDefault(o => o.Id == operationId);
operationDb.Documents.Add(documentDb);
context.SaveChanges();
}
return(documentDb);
}
public OperationDb AddOperation(OperationDb operationDb, Guid modelId)
{
using (var context = new QualificationDbContext())
{
var modelDb = context.Models.Include(m => m.Operations).FirstOrDefault(m => m.Id == modelId);
modelDb.Operations.Add(operationDb);
context.SaveChanges();
}
return(operationDb);
}
public List <ProjectDb> GetAll()
{
using (var context = new QualificationDbContext())
{
return(context.Projects
.Include(p => p.Models
.Select(m => m.Operations
.Select(o => o.Documents)))
.ToList());
}
}
public ProjectDb GetProject(Guid projectId)
{
using (var context = new QualificationDbContext())
{
return(context.Projects
.Include(p => p.Models
.Select(m => m.Operations
.Select(o => o.Documents)))
.FirstOrDefault(p => p.Id == projectId));
}
}
public void Update(SelfCheckDb selfCheckDbChanged)
{
using (var context = new QualificationDbContext())
{
var selfCheckDbCurrent = context.SelfChecks.Find(selfCheckDbChanged.Id);
selfCheckDbCurrent.TrainingDbId = selfCheckDbChanged.TrainingDbId;
selfCheckDbCurrent.ResponsiblePersonId = selfCheckDbChanged.ResponsiblePersonId;
selfCheckDbCurrent.Date = selfCheckDbChanged.Date;
context.Entry(selfCheckDbCurrent).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Update(StaffDb staffDbChanged)
{
using (var context = new QualificationDbContext())
{
var staffDbCurrent = context.Staffs.Find(staffDbChanged.Id);
staffDbCurrent.LastName = staffDbChanged.LastName;
staffDbCurrent.FirstName = staffDbChanged.FirstName;
staffDbCurrent.MiddleName = staffDbChanged.MiddleName;
staffDbCurrent.Position = staffDbChanged.Position;
context.Entry(staffDbCurrent).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Update(TrainingDb trainingDbChanged)
{
using (var context = new QualificationDbContext())
{
var trainingDbCurrent = context.Trainings.Find(trainingDbChanged.Id);
trainingDbCurrent.StaffDbId = trainingDbChanged.StaffDbId;
trainingDbCurrent.TrainerId = trainingDbChanged.TrainerId;
trainingDbCurrent.ProjectId = trainingDbChanged.ProjectId;
trainingDbCurrent.ModelId = trainingDbChanged.ModelId;
trainingDbCurrent.OperationId = trainingDbChanged.OperationId;
trainingDbCurrent.StartDate = trainingDbChanged.StartDate;
trainingDbCurrent.EndDate = trainingDbChanged.EndDate;
context.Entry(trainingDbCurrent).State = EntityState.Modified;
context.SaveChanges();
}
}
