public void Add(TrainingDb trainingDb) { using (var context = new QualificationDbContext()) { context.Trainings.Add(trainingDb); context.SaveChanges(); } }
public void Delete(StaffDb staffDb) { using (var context = new QualificationDbContext()) { context.Entry(staffDb).State = EntityState.Deleted; 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 UpdateOperation(OperationDb operationDb) { using (var context = new QualificationDbContext()) { context.Entry(operationDb).State = EntityState.Modified; 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 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 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 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 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(); } }