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.Commit(); } 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.Commit(); } }
// // 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.Commit(); }
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(c); context.Commit(); } }
public static void Initialize(MacheteContext context) { string cfgValue; list.ForEach(u => { try { cfgValue = ConfigurationManager.AppSettings[u.old]; } catch { cfgValue = "NULL"; } var o = new Config { key = u.cur, value = cfgValue ?? "NULL", // <--- offending line category = u.cat, datecreated = DateTime.Now, dateupdated = DateTime.Now, createdby = "Init T. Script", updatedby = "Init T. Script" }; context.Configs.Add(o); context.Commit(); }); var offset = ConfigurationManager.AppSettings["TimeZoneDifferenceFromPacific"]; if (offset == null) { offset = "0"; } context.Database.ExecuteSqlCommand(@"update dbo.workersignins set timeZoneOffset = @timezone", new SqlParameter { ParameterName = "timezone", Value = offset }); context.Database.ExecuteSqlCommand(@"update dbo.activitysignins set timeZoneOffset = @timezone", new SqlParameter { ParameterName = "timezone", Value = offset }); context.Database.ExecuteSqlCommand(@"update dbo.workorders set timeZoneOffset = @timezone", new SqlParameter { ParameterName = "timezone", Value = offset }); }
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.Commit(); }
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.Commit(); 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.Commit(); 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.Commit(); 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.Commit(); 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.Commit(); 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.Commit(); 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.Commit(); 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.Commit(); 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.Commit(); 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.Commit(); // // 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.Commit(); } }