예제 #1
0
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using (var context = new MVC_CRUDContext(
                       serviceProvider.GetRequiredService <
                           DbContextOptions <MVC_CRUDContext> >()))
            {
                // Look for any records.
                if (context.Severity.Any())
                {
                    return;   // DB has been seeded
                }

                context.Severity.AddRange(
                    new Severity
                {
                    Id           = 1,
                    SeverityName = "CRITICAL"
                },

                    new Severity
                {
                    Id           = 2,
                    SeverityName = "High"
                },

                    new Severity
                {
                    Id           = 3,
                    SeverityName = "Medium"
                },

                    new Severity
                {
                    Id           = 4,
                    SeverityName = "Low"
                }
                    );
                context.SaveChanges();

                // These add in reverse order, which is a bit weird!
                context.Issue.AddRange(
                    new Issue
                {
                    Name          = "Jeremy Clarkson",
                    Location      = "Clarkson's office",
                    SeverityId    = 2,
                    SubmittedDate = DateTime.Parse("01-04-2021"),
                    ResolvedDate  = DateTime.Parse("02-04-2021"),
                    Description   = "Monitor no work!!",
                    Notes         = "Power button pushed in too hard",
                    Resolution    = "Swapped monitor",
                    Resolved      = true
                },

                    new Issue
                {
                    Name          = "Richard Hammond",
                    Location      = "Garage",
                    SeverityId    = 1,
                    SubmittedDate = DateTime.Parse("05-04-2021"),
                    Description   = "System has crashed again"
                },

                    new Issue
                {
                    Name          = "James May",
                    Location      = "James May",
                    SeverityId    = 4,
                    SubmittedDate = DateTime.Parse("06-04-2021"),
                    Description   = "Requested new gramophone",
                    Notes         = "Ordered to arrive next week, along with the woofers and tweeters"
                },

                    new Issue
                {
                    Name          = "The Stig",
                    Location      = "Stig Cave",
                    SeverityId    = 3,
                    SubmittedDate = DateTime.Parse("07-04-2021"),
                    ResolvedDate  = DateTime.Parse("07-04-2021"),
                    Description   = "...",
                    Resolution    = "Needs more information",
                    Resolved      = true
                }
                    );
                context.SaveChanges();
            }
        }
예제 #2
0
 public HomeController(MVC_CRUDContext context)
 {
     _context = context;
 }