// GET: NebsConcurrency public ActionResult Index() { var viewModel = new NebsConcurrencyIndexViewModel(); using (var nebsdb = new NebsContext()) { // all NEBS BudgetPeriod/Dept/Div queries specify a BudgetPeriod greater than 5 because there were invalid Dept/Div records // attached to some of the older BudgetPeriods in the NEBS database viewModel.NebsBudgetPeriods = nebsdb.NebsBudgetPeriods.Where(b => b.ID > 5).ToList(); viewModel.NebsDepts = nebsdb.NebsDepts.Where(b => b.NebsBudgetPeriodID > 5).ToList(); viewModel.NebsDivs = nebsdb.NebsDivs.Where(b => b.NebsBudgetPeriodID > 5).ToList(); } using (var localdb = new ApplicationDbContext()) { viewModel.LocalBudgetPeriods = localdb.BudgetPeriods.ToList(); viewModel.LocalDepts = localdb.Depts.ToList(); viewModel.LocalDivs = localdb.Divs.ToList(); } return(View(viewModel)); }
public ActionResult SyncDivs() { //var viewModel = new NebsConcurrencyIndexViewModel(); var nebsdb = new NebsContext(); var nebsDivs = nebsdb.NebsDivs.Where(b => b.NebsBudgetPeriodID > 5).ToList(); nebsdb.Dispose(); var localdb = new ApplicationDbContext(); var localDivs = localdb.Divs.ToList(); localdb.Dispose(); var localDeptsHS = new HashSet <decimal>(localDivs.Select(d => d.ID)); using (var context = new ApplicationDbContext()) { foreach (var div in nebsDivs) { if (!localDeptsHS.Contains(div.ID)) { context.Divs.Add( new Div { ID = div.ID, BudgetPeriodID = div.NebsBudgetPeriodID, DeptID = div.NebsDeptID, Code = div.Code, Description = div.Description, SortOrder = div.SortOrder } ); context.SaveChanges(); } } } return(RedirectToAction("Index")); }
public ActionResult SyncBudgetPeriods() { var nebsdb = new NebsContext(); var nebsBudgetPeriods = nebsdb.NebsBudgetPeriods.Where(b => b.ID > 5).ToList(); nebsdb.Dispose(); var localdb = new ApplicationDbContext(); var localBudgetPeriods = localdb.BudgetPeriods.ToList(); localdb.Dispose(); var localBudgetPeriodsHS = new HashSet <decimal>(localBudgetPeriods.Select(d => d.ID)); using (var context = new ApplicationDbContext()) { foreach (var budgetPeriod in nebsBudgetPeriods) { if (!localBudgetPeriodsHS.Contains(budgetPeriod.ID)) { context.BudgetPeriods.Add( new BudgetPeriod { ID = budgetPeriod.ID, Description = budgetPeriod.Description, ActualYear = budgetPeriod.ActualYear, WorkProgramYear = budgetPeriod.WorkProgramYear, BeginYear = budgetPeriod.BeginYear, EndYear = budgetPeriod.EndYear } ); context.SaveChanges(); } } } return(RedirectToAction("Index")); }
public DeptsController() { _nebsDb = new NebsContext(); }