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