Exemple #1
0
 public static void VerifySeed()
 {
     if (FilamentContext.GetSetting(s => s.Name == "SeedData") is Setting setting)
     {
         if (setting == InitialSeed)
         {
             if (DataContext.FilamentContext.GetAllFilaments()?.FirstOrDefault() is FilamentDefn definition)
             {
                 System.Diagnostics.Debug.WriteLine($"Filament Type : {definition.MaterialType}, Density : {definition.DensityAlias?.Density}, Density Type : {definition.DensityAlias.DensityType}");
             }
         }
     }
 }
Exemple #2
0
        private static void SeedVendorData <TContext>(Setting setting, FilamentContext filamentContext) where TContext : DbContext, new()
        {
            System.Diagnostics.Debug.WriteLine("Seeding VendorDefns");
            var seedVendors = DataDefinitions.Seed.InitialVendorDefinitions();

            foreach (var item in seedVendors)
            {
                item.UpdateItem <TContext>();
            }
            //System.Diagnostics.Debug.Assert(insertCount == seedVendors.Length, "Not all vendor definitions were inserted into the database.");
            setting.SetValue(AddVendorDefn);

            filamentContext.Entry(setting).State = EntityState.Modified;
            filamentContext.Update(setting);
            filamentContext.SaveChanges();
        }
Exemple #3
0
        private static void InitialSeeding()
        {
            System.Diagnostics.Debug.WriteLine("Performing initial seeding of FilamentDefns");
            var filamentDefns = DataDefinitions.Seed.InitialFilamentDefinitions();

            foreach (var item in filamentDefns)
            {
                item.UpdateItem <FilamentContext>();
            }
            FilamentContext.AddAll(new Setting("SeedData", InitialSeed));
            //DataContext.FilamentContext.AddAll(filamentDefns, );
            //FilamentDefn[] startingFilaments = InitialFilamentDefinitions();
            //ctx.AddRange(startingFilaments);
            //ctx.Add(new Setting("SeedData", InitialSeed));
            //ctx.SaveChanges();
        }
 public static List <Setting> GetAllSettings()
 {
     using (FilamentContext ctx = new FilamentContext())
     {
         if (ctx != null)
         {
             return(ctx.Settings?
                    .AsNoTracking()
                    .ToList());
         }
         else
         {
             return(null);
         }
     }
 }
 public static List <Setting> GetSettings(Func <Setting, bool> predicate)
 {
     using (FilamentContext context = new FilamentContext())
     {
         if (context != null)
         {
             return(context.Settings?
                    .AsNoTracking()
                    .Where(predicate)
                    .ToList());
         }
         else
         {
             return(null);
         }
     }
 }
 public static Setting GetSetting(Func <Setting, bool> predicate)
 {
     using (FilamentContext context = new FilamentContext())
     {
         if (context != null)
         {
             return(context.Settings?
                    .AsNoTracking()
                    .Where <Setting>(predicate)
                    .SingleOrDefault());
         }
         else
         {
             return(null);
         }
     }
 }
 public static List <FilamentDefn> GetAllFilaments()
 {
     using (FilamentContext ctx = new FilamentContext())
     {
         if (ctx != null)
         {
             return(ctx.FilamentDefn?
                    .Include("DensityAlias")
                    .Include("DensityAlias.MeasuredDensity")
                    .AsNoTracking()
                    .ToList());
         }
         else
         {
             return(null);
         }
     }
 }
 public static List <VendorDefn> GetAllVendors()
 {
     using (FilamentContext ctx = new FilamentContext())
     {
         if (ctx != null)
         {
             return(ctx.VendorDefns?
                    .AsNoTracking()
                    .Include("SpoolDefns")
                    .Include("SpoolDefns.Inventory")
                    .Include("SpoolDefns.Inventory.DepthMeasurements")
                    .ToList());
         }
         else
         {
             return(null);
         }
     }
 }
 public static List <FilamentDefn> GetFilaments(Func <FilamentDefn, bool> predicate)
 {
     using (FilamentContext ctx = new FilamentContext())
     {
         if (ctx != null)
         {
             return(ctx.FilamentDefn?
                    .AsNoTracking()
                    .Include("DensityAlias")
                    .Include("DensityAlias.MeasuredDensity")
                    .Where <FilamentDefn>(predicate)
                    .ToList());
         }
         else
         {
             return(null);
         }
     }
 }
 public static List <VendorDefn> GetSomeVendors(Func <VendorDefn, bool> predicate)
 {
     using (FilamentContext ctx = new FilamentContext())
     {
         if (ctx != null)
         {
             return(ctx.VendorDefns?
                    .AsNoTracking()
                    .Include("SpoolDefns")
                    .Include("SpoolDefns.Inventory")
                    .Include("SpoolDefns.Inventory.DepthMeasurements")
                    .Where(predicate)
                    .ToList());
         }
         else
         {
             return(null);
         }
     }
 }
 internal static void UpdateItems(params object[] items)
 {
     using (FilamentContext ctx = new FilamentContext())
     {
         foreach (var item in items)
         {
             if (item is IEnumerable enumerable)
             {
                 foreach (var ele in enumerable)
                 {
                     ctx.Entry(ele).State = EntityState.Modified;
                     ctx.Update(ele);
                 }
             }
             else
             {
                 ctx.Entry(item).State = EntityState.Modified;
                 ctx.Update(item);
             }
         }
         ctx.SaveChanges();
     }
 }
        //protected override void OnModelCreating(ModelBuilder modelBuilder)
        //{
        //    modelBuilder.Entity<FilamentDefn>()
        //        .HasOne(fd => fd.DensityAlias)
        //        .WithOne(da => da.FilamentDefn)
        //        .HasForeignKey<DensityAlias>(da => da.FilamentDefnId);

        //    //modelBuilder.Entity<SpoolDefn>()
        //    //     .HasOne<VendorDefn>()
        //    //     .WithMany(sd=>sd.SpoolDefns)
        //    //     .HasForeignKey(sd=>sd.VendorDefnId);

        //}
        //public Setting GetSetting(Func<Setting,bool> func)
        //{
        //    if (func != null)
        //        return Settings.FirstOrDefault(s => func(s));
        //    else
        //        return null;
        //}
        internal static void AddAll(params object[] items)
        {
            using (FilamentContext context = new FilamentContext())
            {
                foreach (object item in items)
                {
                    if (item is IEnumerable enumerable)
                    {
                        foreach (var ele in enumerable)
                        {
                            context.Entry(ele).State = EntityState.Added;
                            context.Add(ele);
                        }
                    }
                    else
                    {
                        context.Entry(item).State = EntityState.Added;
                        context.Add(item);
                    }
                }
                context.SaveChanges();
            }
        }