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();
}
}
