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) { }