public async Task RemoveAssignment(Assignment assignment)
{
using (var database = new BereauDbContext(_context))
{
database.Assignments.Remove(assignment);
await database.SaveChangesAsync();
}
}
public async Task RemoveModel(Model model)
{
using (var database = new BereauDbContext(_context))
{
database.Models.Remove(model);
await database.SaveChangesAsync();
}
}
public async Task <ObservableCollection <Model> > GetAllModels()
{
using (var database = new BereauDbContext(_context))
{
//var models = await database.Models.ToListAsync();
return(new ObservableCollection <Model>(await database.Models.ToListAsync()));
}
}
public async Task AddModel(Model model)
{
using (var database = new BereauDbContext(_context))
{
await database.Models.AddAsync(model);
await database.SaveChangesAsync();
}
}
public async Task <ObservableCollection <Assignment> > GetAllAssignments()
{
using (var database = new BereauDbContext(_context))
{
var assignments = await database.Assignments.ToListAsync();
return(new ObservableCollection <Assignment>(assignments));
}
}
public async Task RemoveModelAssignment(Model model, Assignment assignment)
{
using (var database = new BereauDbContext(_context))
{
var toRemove = database.ModelAssignments.Find(new { model.ModelId, assignment.AssignmentId });
database.ModelAssignments.Remove(toRemove);
await database.SaveChangesAsync();
}
}
public async Task <ObservableCollection <Assignment> > GetUnplannedAssignments()
{
using (var database = new BereauDbContext(_context))
{
var assignments = await database.Assignments
.Where(a => a.Planned == false)
.ToListAsync();
return(new ObservableCollection <Assignment>(assignments));
}
}
public bool CreateDatabase()
{
using (var database = new BereauDbContext(_context))
{
if (true && (database.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists())
{
return(false);
}
database.Database.EnsureDeleted();
return(database.Database.EnsureCreated());
}
}
public async Task AddModelToAssignment(Model model, Assignment assignment)
{
var modelassignment = new ModelAssignment
{
AssignmentId = assignment.AssignmentId,
ModelId = model.ModelId
};
using (var database = new BereauDbContext(_context))
{
await database.ModelAssignments.AddAsync(modelassignment);
assignment.ModelsNeeded -= 1;
if (assignment.ModelsNeeded == 0)
{
assignment.Planned = true;
}
database.Assignments.Update(assignment);
await database.SaveChangesAsync();
}
}
