public static void Initialize(ApplicationDbContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.ApplicationUsers.Any()) { return; // DB has been seeded } var ApplicationUsers = new ApplicationUser[] { new ApplicationUser { Email = "*****@*****.**", FirstName = "Carson", LastName = "Alexander" }, new ApplicationUser { Email = "*****@*****.**", FirstName = "Meredith", LastName = "Alonso" }, new ApplicationUser { Email = "*****@*****.**", FirstName = "Arturo", LastName = "Anand" }, new ApplicationUser { Email = "*****@*****.**", FirstName = "Gytis", LastName = "Barzdukas" }, new ApplicationUser { Email = "*****@*****.**", FirstName = "Yan", LastName = "Li" }, new ApplicationUser { Email = "*****@*****.**", FirstName = "Peggy", LastName = "Justice" }, new ApplicationUser { FirstName = "Laura", LastName = "Norman" }, new ApplicationUser { FirstName = "Nino", LastName = "Olivetto" } }; foreach (ApplicationUser s in ApplicationUsers) { context.ApplicationUsers.Add(s); } context.SaveChanges(); var protocols = new Protocol[] { new Protocol { Description = "Chemistry" }, new Protocol { Description = "Microeconomics" }, new Protocol { Description = "Macroeconomics" }, new Protocol { Description = "Calculus" }, new Protocol { Description = "Trigonometry" }, new Protocol { Description = "Composition" }, new Protocol { Description = "Literature" } }; foreach (Protocol c in protocols) { context.Protocols.Add(c); } context.SaveChanges(); var Tasks = new Models.Task[] { new Models.Task { ProtocolID = 1, Description = "Contrary to popular belief, Lorem Ipsum is not simply random text", Deadline = DateTime.Parse("2002-09-01") }, new Models.Task { ProtocolID = 1, Description = "It has roots in a piece of classical Latin literature from 45 BC", Deadline = DateTime.Parse("2002-09-01") }, new Models.Task { ProtocolID = 1, Description = "making it over 2000 years old. Richard McClintock, a Latin ", Deadline = DateTime.Parse("2003-09-01") }, new Models.Task { ProtocolID = 2, Description = "professor at Hampden-Sydney College in Virginia, looked up one of ", Deadline = DateTime.Parse("2002-09-01") }, new Models.Task { ProtocolID = 2, Description = "the more obscure Latin words, consectetur, from a Lorem Ipsum ", Deadline = DateTime.Parse("2002-09-01") }, new Models.Task { ProtocolID = 2, Description = "passage, and going through the cites of the word in classical ", Deadline = DateTime.Parse("2001-09-01") }, new Models.Task { ProtocolID = 3, Description = "literature, discovered the undoubtable source. Lorem Ipsum ", Deadline = DateTime.Parse("2003-09-01") }, new Models.Task { ProtocolID = 4, Description = "comes from sections 1.10.32 and 1.10.33 of de Finibus Bonorum", Deadline = DateTime.Parse("2005-09-01") }, }; foreach (Models.Task e in Tasks) { context.Tasks.Add(e); } context.SaveChanges(); var ApplicationUser_has_Protocols = new ApplicationUser_has_Protocol[] { new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Alexander").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Alexander").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Alexander").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Alonso").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Alonso").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Alonso").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Anand").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Anand").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Barzdukas").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Li").AppID, ProtocolID = 1 }, new ApplicationUser_has_Protocol { AppID = ApplicationUsers.Single(s => s.LastName == "Justice").AppID, ProtocolID = 1 } }; foreach (ApplicationUser_has_Protocol e in ApplicationUser_has_Protocols) { context.ApplicationUser_Has_Protocols.Add(e); } context.SaveChanges(); var ApplicationUser_has_Tasks = new ApplicationUser_has_Task[] { new ApplicationUser_has_Task { TaskID = 1, AppID = ApplicationUsers.Single(i => i.LastName == "Kapoor").AppID }, new ApplicationUser_has_Task { TaskID = 1, AppID = ApplicationUsers.Single(i => i.LastName == "Harui").AppID }, new ApplicationUser_has_Task { TaskID = 2, AppID = ApplicationUsers.Single(i => i.LastName == "Zheng").AppID }, new ApplicationUser_has_Task { TaskID = 2, AppID = ApplicationUsers.Single(i => i.LastName == "Zheng").AppID }, new ApplicationUser_has_Task { TaskID = 3, AppID = ApplicationUsers.Single(i => i.LastName == "Fakhouri").AppID }, new ApplicationUser_has_Task { TaskID = 3, AppID = ApplicationUsers.Single(i => i.LastName == "Harui").AppID }, new ApplicationUser_has_Task { TaskID = 4, AppID = ApplicationUsers.Single(i => i.LastName == "Abercrombie").AppID }, new ApplicationUser_has_Task { TaskID = 4, AppID = ApplicationUsers.Single(i => i.LastName == "Abercrombie").AppID }, }; foreach (ApplicationUser_has_Task ci in ApplicationUser_has_Tasks) { context.ApplicationUser_Has_Tasks.Add(ci); } context.SaveChanges(); }
public async Task <IActionResult> Create(CreateViewModel model) { //var userID = User.Identity.GetUserId(); string query = "SELECT * FROM Protocol WHERE Id = {0}"; Protocol pro = await _context.Protocols.FromSql(query, model.ProtocolID) .AsNoTracking() .SingleOrDefaultAsync(); Console.WriteLine("&&&&&& ProtName = {0}******", pro.Description); Models.Task task = new Models.Task { ProtocolID = model.ProtocolID, Description = model.Description, Deadline = model.Deadline }; if (ModelState.IsValid) { _context.Add(task); await _context.SaveChangesAsync(); for (int i = 0; i < model.Filters.Count(); i++) { if (model.Filters[i].Selected) { ApplicationUser_has_Task has_Task = new ApplicationUser_has_Task { AppID = model.Filters[i].ID, Task = task, TaskID = task.Id }; Console.WriteLine("&&&&&& Filters[i] = {0}******", model.Filters[i]); _context.Add(has_Task); task.ApplicationUser_has_Tasks.Add(has_Task); _context.Update(task); var user = await _context.ApplicationUsers .SingleOrDefaultAsync(m => m.AppID == model.Filters[i].ID); user.ApplicationUser_has_Tasks.Add(has_Task); _context.Update(user); await _context.SaveChangesAsync(); } } return(RedirectToAction("Index", "Task", new { id = model.ProtocolID })); } ////Redirect to "Create" I guess CreateViewModel mod = new CreateViewModel(); mod.Protocols = _context.Protocols .Select(h => new Protocol { Id = h.Id, Description = h.Description, }) .ToList(); mod.ApplicationUsers = _context.ApplicationUsers .Select(h => new ApplicationUser { AppID = h.AppID, FirstName = h.FirstName, Email = h.Email }) .ToList(); List <Filter> asd = _context.ApplicationUsers .Select(h => new Filter { ID = h.AppID, Name = h.Email, Selected = false }).ToList(); mod.Filters = asd.ToArray(); return(View(mod)); }