public static void Initialize(MacheteContext c) { if (c.TransportProviders.Count() == 0) { c.Database.ExecuteSqlCommand(@"insert into dbo.TransportProviders ( [key], text_EN, text_ES, defaultAttribute, sortorder, active, datecreated, dateupdated, Createdby, Updatedby ) select [key], text_EN, text_ES, selected, sortorder, active, datecreated, dateupdated, Createdby, Updatedby from dbo.Lookups where category = 'transportmethod'"); c.SaveChanges(); } if (c.TransportProvidersAvailability.Count() == 0) { var providers = c.TransportProviders.ToList(); foreach (var p in providers) { p.AvailabilityRules = new List <TransportProviderAvailability>(); for (var i = 0; i < 7; i++) { p.AvailabilityRules.Add(new Domain.TransportProviderAvailability { transportProviderID = p.ID, day = i, available = i == 0 ? p.key == "transport_pickup" ? true : false : true, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); } } c.SaveChanges(); } }
// // public static void Initialize(MacheteContext context) { _cache.ForEach(u => { u.datecreated = DateTime.Now; u.dateupdated = DateTime.Now; u.createdby = "Init T. Script"; u.updatedby = "Init T. Script"; context.Lookups.Add(u); }); context.SaveChanges(); }
public static void Initialize(MacheteContext context) { foreach (var c in list) { c.datecreated = DateTime.Now; c.dateupdated = DateTime.Now; c.createdby = "Init T. Script"; c.updatedby = "Init T. Script"; context.Configs.Add((Config)c.Clone()); context.SaveChanges(); } }
// // public static void Initialize(MacheteContext context) { _cache.ForEach(u => { u.datecreated = DateTime.Now; u.dateupdated = DateTime.Now; u.createdby = "Init T. Script"; u.updatedby = "Init T. Script"; context.Lookups.Add(u); }); context.Database.OpenConnection(); if (context.Database.GetDbConnection().GetType().Name == "SqlServerConnection") { context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Lookups ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT dbo.Lookups OFF"); } else { context.SaveChanges(); } }