public void AssignTeams(List <StudentAssignment> data)
{
// Step 0 - Business Rules:
// - The smallest team size is four students
// - The largest team size is seven students
// - Clients with more than seven students must be broken into separate teams, each with a team letter(starting with 'A').
// - Only assign students to clients that have been confirmed as participating.
// Step 1 - OLTP
using (var context = new CapstoneContext())
{
foreach (var item in data)
{
var assignment = new TeamAssignment();
assignment.ClientId = item.ClientId;
assignment.StudentId = item.StudentId;
assignment.TeamNumber = item.TeamLetter;
context.TeamAssignments.Add(assignment);
}
// And... Commit all the changes
context.SaveChanges(); // OLTP all done
}
}
public UserRepository(UserContext userContext, CapstoneContext capstoneContext, DayContext dayContext, TaskContext taskContext)
{
_context = userContext;
capstoneRepository = new CapstoneRepository(capstoneContext, dayContext, taskContext);
dayRepository = new DayRepository(dayContext, taskContext);
taskRepository = new TaskRepository(taskContext);
}
public static void RemoveDbSetDataDatabase(this CapstoneContext context, DbSet set)
{
var dataDeleter = new DatabaseDataDeleter(context);
RemoveDbSetData(set);
context.SaveChanges();
dataDeleter.DeleteAllObjects();
}
public static void AssemblyInit(CapstoneContext context)
{
AppDomain.CurrentDomain.SetData("DataDirectory", Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ""));
Database.SetInitializer(new DropCreateDatabaseAlways <CapstoneContext>());
Database.SetInitializer(new MigrateDatabaseToLatestVersion <CapstoneContext, Configuration>());
Console.WriteLine("Assembly setup: creating LocalDb database");
Trace.WriteLine(String.Format("Location of localdb : {0}", AppDomain.CurrentDomain.GetData("DataDirectory")));
context.Database.Delete();
context.Database.Initialize(true);
}
public List <StudentInfo> ListAllStudents()
{
using (var context = new CapstoneContext())
{
var results = from person in context.Students
select new StudentInfo
{
StudentId = person.StudentId,
FullName = person.FirstName + " " + person.LastName
};
return(results.ToList());
}
}
public static void RemoveAllDbSetDataDatabase(this CapstoneContext context)
{
var dataDeleter = new DatabaseDataDeleter(context);
RemoveDbSetData(context.Events);
RemoveDbSetData(context.EventType);
RemoveDbSetData(context.Category);
RemoveDbSetData(context.Registrations);
RemoveDbSetData(context.Statuses);
context.SaveChanges();
dataDeleter.DeleteAllObjects();
}
public List <ClientInfo> ListCapstoneClients()
{
using (var context = new CapstoneContext())
{
var results = from company in context.CapstoneClients
where company.Confirmed
select new ClientInfo
{
ClientId = company.Id,
Company = company.CompanyName
};
return(results.ToList());
}
}
public UserController(UserContext userContext, CapstoneContext capstoneContext, DayContext dayContext, TaskContext taskContext, IConfiguration configuration)
{
_userContext = userContext;
_capstoneContext = capstoneContext;
_dayContext = dayContext;
_taskContext = taskContext;
_configuration = configuration;
userRepository = new UserRepository(_userContext, _capstoneContext, _dayContext, _taskContext);
capstoneRepository = new CapstoneRepository(_capstoneContext, _dayContext, _taskContext);
dayRepository = new DayRepository(_dayContext, _taskContext);
taskRepository = new TaskRepository(_taskContext);
}
public UserService(CapstoneContext context)
{
_context = context;
}
public RegistrantsController(CapstoneContext context)
{
_context = context;
}
public PrimaryContactsController(CapstoneContext context)
{
_context = context;
}
public DetectionErrorRepository(CapstoneContext context) : base(context)
{
}
public BookRepository(CapstoneContext context) : base(context)
{
_context = context;
}
public EventsController(CapstoneContext context, IHostingEnvironment hostingEnvironment)
{
_context = context;
_hostingEnvironment = hostingEnvironment;
imageService = new ImageService();
}
public FeedbackRepository(CapstoneContext context) : base(context)
{
}
public DrawerDetectionRepository(CapstoneContext context) : base(context)
{
}
public RoleRepository(CapstoneContext context) : base(context)
{
}
public StaffRepository(CapstoneContext context) : base(context)
{
}
public BorrowBookRepository(CapstoneContext context) : base(context)
{
}
public ReturnBookRepository(CapstoneContext context) : base(context)
{
}
public LocationRepository(CapstoneContext context) : base(context)
{
}
public CapstoneRepository(CapstoneContext context, DayContext dayContext, TaskContext taskContext)
{
_context = context;
dayRepository = new DayRepository(dayContext, taskContext);
taskRepository = new TaskRepository(taskContext);
}
public BookGroupRepository(CapstoneContext context) : base(context)
{
}
public BaseRepository(CapstoneContext context)
{
_context = context;
_entities = context.Set <T>();
}
public ImageRepository(CapstoneContext context) : base(context)
{
}
public UnitOfWork(CapstoneContext context)
{
_context = context;
}
public HomeController(CapstoneContext context)
{
_context = context;
}
public CustomerRepository(CapstoneContext context) : base(context)
{
}
public PayrollItemController(CapstoneContext context)
{
_context = context;
}
public BorrowDetailRepository(CapstoneContext context) : base(context)
{
}
