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(); } }
public static void Initialize(MacheteContext DB) { IdentityResult ir; var rm = new RoleManager <IdentityRole> (new RoleStore <IdentityRole>(DB)); ir = rm.Create(new IdentityRole("Administrator")); ir = rm.Create(new IdentityRole("Manager")); ir = rm.Create(new IdentityRole("Check-in")); ir = rm.Create(new IdentityRole("PhoneDesk")); ir = rm.Create(new IdentityRole("Teacher")); ir = rm.Create(new IdentityRole("User")); ir = rm.Create(new IdentityRole("Hirer")); // This role is used exclusively for the online hiring interface var um = new UserManager <MacheteUser>( new UserStore <MacheteUser>(DB)); var admin = new MacheteUser() { UserName = "******", IsApproved = true, Email = "*****@*****.**" }; var user = new MacheteUser() { UserName = "******", IsApproved = true, Email = "*****@*****.**" }; ir = um.Create(admin, "ChangeMe"); ir = um.AddToRole(admin.Id, "Administrator"); //Default Administrator, edit to change ir = um.AddToRole(admin.Id, "Teacher"); //Required to make tests work ir = um.Create(user, "ChangeMe"); ir = um.AddToRole(admin.Id, "User"); //Default Administrator, edit to change DB.SaveChanges(); }
public static void Initialize(MacheteContext c) { c.TransportRules.Add(new TransportRule { ID = 1, key = "bus_inside_zone", lookupKey = "transport_bus", zoneLabel = "inside", zipcodes = "98101,98102,98103,98104,98105,98106,98107,98108,98109,98112,98115,98116,98117,98118,98119,98121,98122,98125,98126,98133,98134,98136,98144,98146,98154,98161,98164,98168,98174,98178,98195,98199", datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); var biz = c.TransportRules.Find(1); biz.costRules = new List <TransportCostRule>(); biz.costRules.Add(new TransportCostRule { ID = 1, minWorker = 0, maxWorker = 100, cost = 5, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); c.TransportRules.Add(new TransportRule { ID = 2, key = "bus_outside_zone", lookupKey = "transport_bus", zoneLabel = "outside", zipcodes = "98001,98003,98004,98005,98006,98007,98008,98020,98026,98027,98028,98029,98030,98031,98032,98033,98034,98037,98039,98040,98043,98052,98055,98056,98057,98059,98074,98075,98155,98158,98166,98168,98188", datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); var boz = c.TransportRules.Find(2); boz.costRules = new List <TransportCostRule>(); boz.costRules.Add(new TransportCostRule { ID = 2, minWorker = 0, maxWorker = 100, cost = 10, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); c.TransportRules.Add(new TransportRule { ID = 3, key = "van_inside_zone", lookupKey = "transport_van", zoneLabel = "inside", zipcodes = "98101,98102,98103,98104,98105,98106,98107,98108,98109,98112,98115,98116,98117,98118,98119,98121,98122,98125,98126,98133,98134,98136,98144,98146,98154,98161,98164,98168,98174,98177,98178,98195,98199", datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); var viz = c.TransportRules.Find(3); viz.costRules = new List <TransportCostRule>(); viz.costRules.Add(new TransportCostRule { ID = 3, minWorker = 0, maxWorker = 1, cost = 15, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); viz.costRules.Add(new TransportCostRule { ID = 4, minWorker = 1, maxWorker = 2, cost = 5, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); viz.costRules.Add(new TransportCostRule { ID = 5, minWorker = 2, maxWorker = 10, cost = 0, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); c.TransportRules.Add(new TransportRule { ID = 4, key = "van_outside_zone", lookupKey = "transport_van", zoneLabel = "outside", zipcodes = "98001,98003,98004,98005,98006,98007,98008,9801198020,98021,98026,98027,98028,98029,98030,98031,98032,98033,98034,98037,98039,98040,98043,98052,98055,98056,98057,98059,98074,98075,98155,98158,98166,98168", datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); var voz = c.TransportRules.Find(4); voz.costRules = new List <TransportCostRule>(); voz.costRules.Add(new TransportCostRule { ID = 6, minWorker = 0, maxWorker = 1, cost = 25, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); voz.costRules.Add(new TransportCostRule { ID = 7, minWorker = 1, maxWorker = 10, cost = 0, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); c.TransportRules.Add(new TransportRule { ID = 5, key = "pickup", lookupKey = "transport_pickup", zoneLabel = "all", zipcodes = "*", datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); var p = c.TransportRules.Find(5); p.costRules = new List <TransportCostRule>(); p.costRules.Add(new TransportCostRule { ID = 8, minWorker = 0, maxWorker = 100, cost = 0, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); // // Schedule Rules for (var i = 0; i < 7; i++) { c.ScheduleRules.Add(new ScheduleRule() { day = i, leadHours = 48, minStartMin = 420, maxEndMin = 1020, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }); c.SaveChanges(); } }