public CreateModel(MegaDeskWebPages.Models.MegaDeskWebPagesContext context)
        {
            _context = context;
            IQueryable <string> matQuery = from m in _context.Material
                                           orderby m.MaterialType
                                           select m.MaterialType;

            IQueryable <string> delQuery = from d in _context.Delivery
                                           orderby d.RushOrderDay
                                           select d.RushOrderDay;

            MaterialList = new SelectList(matQuery.Distinct().ToList());
            DeliveryList = new SelectList(delQuery.Distinct().ToList());
        }
 public IndexModel(MegaDeskWebPages.Models.MegaDeskWebPagesContext context)
 {
     _context = context;
 }
 public CreateModel(MegaDeskWebPages.Models.MegaDeskWebPagesContext context)
 {
     _context = context;
 }
 public DetailsModel(MegaDeskWebPages.Models.MegaDeskWebPagesContext context)
 {
     _context = context;
 }
Esempio n. 5
0
 public EditModel(MegaDeskWebPages.Models.MegaDeskWebPagesContext context)
 {
     _context = context;
 }
Esempio n. 6
0
        public static void Initialize(IServiceProvider serviceProvider)
        {
            using (var context = new MegaDeskWebPagesContext(
                       serviceProvider.GetRequiredService <
                           DbContextOptions <MegaDeskWebPagesContext> >()))
            {
                // Look for any movies.
                if (context.Material.Any())
                {
                    return;   // DB has been seeded
                }

                context.Material.AddRange(
                    new Material
                {
                    MaterialType = "Oak",
                    Price        = 200
                },
                    new Material
                {
                    MaterialType = "Laminate",
                    Price        = 100
                },
                    new Material
                {
                    MaterialType = "Pine",
                    Price        = 50
                },
                    new Material
                {
                    MaterialType = "Veneer",
                    Price        = 125
                },
                    new Material
                {
                    MaterialType = "Oak",
                    Price        = 200
                }
                    );

                context.Delivery.AddRange(
                    new Delivery
                {
                    RushOrderDay = "3 Day",
                    Days         = 3
                },
                    new Delivery
                {
                    RushOrderDay = "5 Day",
                    Days         = 5
                },
                    new Delivery
                {
                    RushOrderDay = "7 Day",
                    Days         = 7
                },
                    new Delivery
                {
                    RushOrderDay = "14 Day (Normal Shipping)",
                    Days         = 14
                }
                    );

                /*
                 *  context.Desk.AddRange(
                 *   new Desk
                 *   {
                 *       Width = 24,
                 *       Depth = 12,
                 *       NumDrawers = 0,
                 *       MaterialID = 1
                 *   },
                 *    new Desk
                 *    {
                 *        Width = 96,
                 *        Depth = 48,
                 *        NumDrawers = 7,
                 *        MaterialID = 3
                 *    },
                 *    new Desk
                 *    {
                 *        Width = 36,
                 *        Depth = 50,
                 *        NumDrawers = 3,
                 *        MaterialID = 4
                 *    },
                 *    new Desk
                 *    {
                 *        Width = 24,
                 *        Depth = 12,
                 *        NumDrawers = 7,
                 *        MaterialID = 3
                 *    }
                 * );
                 * context.DeskQuote.AddRange(
                 *  new DeskQuote
                 *  {
                 *      DeskID = 1,
                 *      DeliveryID = 1,
                 *      CustomerName = "Breena Jones",
                 *      QuoteDate = DateTime.Now,
                 *
                 *
                 *  },
                 *   new DeskQuote
                 *   {
                 *       DeskID = 2,
                 *       DeliveryID = 2,
                 *       CustomerName = "Sam Prettyman",
                 *       QuoteDate = DateTime.Now,
                 *
                 *
                 *   },
                 *  new DeskQuote
                 *  {
                 *      DeskID = 3,
                 *      DeliveryID = 3,
                 *      CustomerName = "Chris Cole",
                 *      QuoteDate = DateTime.Now,
                 *
                 *
                 *  },
                 *   new DeskQuote
                 *   {
                 *       DeskID = 4,
                 *       DeliveryID = 1,
                 *       CustomerName = "Louis Lane",
                 *       QuoteDate = DateTime.Now,
                 *
                 *
                 *   }
                 * );
                 */
                context.SaveChanges();
            }
        }