Example #1
0
        protected override void OnModelCreating(ModelBuilder builder)
        {
            builder.Entity <User>(x =>
            {
                x.Property(e => e.Id).HasDefaultValueSql("newid()");
                x.Property(e => e.Created).HasDefaultValueSql("getdate()");
            });

            builder.Entity <Designer>(x =>
            {
                x.Property(e => e.Id).HasDefaultValueSql("newid()");
                x.Property(e => e.Created).HasDefaultValueSql("getdate()");
                x.Property(e => e.LastModified).HasDefaultValueSql("getdate()");
                x.Property(e => e.Deleted).HasDefaultValueSql("0");
            });

            builder.Entity <Style>(x =>
            {
                x.Property(e => e.Id).HasDefaultValueSql("newid()");
                x.Property(e => e.Created).HasDefaultValueSql("getdate()");
                x.Property(e => e.LastModified).HasDefaultValueSql("getdate()");
                x.Property(e => e.Deleted).HasDefaultValueSql("0");
                x.Property(e => e.Discontinued).HasDefaultValueSql("0");
            });

            builder.Entity <SampleInventoryStatusLookup>().HasData(SampleInventoryStatusLookup.Seed());

            builder.Entity <SampleInventoryItem>(x =>
            {
                x.Property(e => e.Id).HasDefaultValueSql("newid()");
                x.Property(e => e.Created).HasDefaultValueSql("getdate()");
                x.Property(e => e.LastModified).HasDefaultValueSql("getdate()");
            });
        }
Example #2
0
        public void AddSampleInventoryItem(
            Style style,
            SampleInventoryStatusLookup inventoryStatus,
            string size,
            string color,
            DateTime dateOrdered,
            DateTime?dateRecieved)
        {
            var item = new SampleInventoryItem()
            {
                Style           = style,
                Size            = size,
                Color           = color,
                DateOrdered     = dateOrdered,
                DateRecieved    = dateRecieved,
                InventoryStatus = inventoryStatus
            };

            base.Add <SampleInventoryItem>(item);
        }