protected override void Seed(CashRegisterContext context)
{
var enumToLookup = new EnumToLookup();
enumToLookup.Apply(context);
base.Seed(context);
}
protected override void Seed(LogDbContext context)
{
var enumToAdd = new EnumToLookup();
var migrationSql = enumToAdd.GenerateMigrationSql(context);
enumToAdd.Apply(context);
base.Seed(context);
}
protected override void Seed(HangManContext context)
{
var enumToLookup = new EnumToLookup()
{
TableNamePrefix = null
};
enumToLookup.Apply(context);
}
protected override void Seed(CarsalesDbContext context)
{
using (var dbContext = new CarsalesDbContext())
{
var enumToLookup = new EnumToLookup();
enumToLookup.NameFieldLength = 25;
enumToLookup.TableNamePrefix = string.Empty;
enumToLookup.Apply(dbContext);
//using (var roleStore = new RoleStore<Role, long, UserRole>(dbContext))
//{
// using (var roleManager = new RoleManager<Role, long>(roleStore))
// {
// roleManager.Create(new Role
// {
// Id = 1,
// Name = "Administrator"
// });
// roleManager.Create(new Role
// {
// Id = 2,
// Name = "User"
// });
// roleManager.Create(new Role
// {
// Id = 3,
// Name = "CustomManager"
// });
// }
//}
//using (var userStore = new CarsalesUserStore(dbContext))
//{
// using (var userManager = new CarsalesUserManager(userStore))
// {
// var user = new User
// {
// Email = "*****@*****.**",
// EmailConfirmed = true,
// PhoneNumber = "0430501022",
// PhoneNumberConfirmed = true,
// AccessFailedCount = 0,
// LockoutEnabled = false,
// UserName = "******",
// SecurityStamp = "7668b7bc-7a5d-4b3b-8388-f2e5c59f3d43",
// PasswordHash = "ABJ1bxk+trJ6PTk4iCBSq/WLDVmhI455FFxZbcXHtH1Xw2NyTKHsJmrWQ1Mbl7S4SQ=="
// };
// userManager.Create(user);
// userManager.AddToRole(user.Id, "Administrator");
// }
//}
dbContext.SaveChanges();
}
}
private static void ConvertirEnTablaLosEnumDelCodigoUtilizadosEnElDbContext(ApplicationDbContext context)
{
var enumToLookup = new EnumToLookup();
var sql = enumToLookup.GenerateMigrationSql(context);
sql = AgregarDboEnLaCreacionDeTablasPorSiNoEsElEsquemaDefault(sql);
context.Database.ExecuteSqlCommand(sql);
context.SaveChanges();
}
private static void TestPrefixConfig(string tableNamePrefix, string testSql)
{
// arrange
var enumToLookup = new EnumToLookup
{
TableNamePrefix = tableNamePrefix
};
TestConfig(testSql, enumToLookup);
}
private static void TestSchemaConfig(string schema, string testSql)
{
// arrange
var enumToLookup = new EnumToLookup
{
TableNamePrefix = null,
Schema = schema
};
TestConfig(testSql, enumToLookup);
}
public void ExampleOfUsingApply()
{
using (var context = new MyDbContext())
{
var enumToLookup = new EnumToLookup();
enumToLookup.NameFieldLength = 42; // optional, example of how to override default values
// This would normally be run inside either a db initializer Seed()
// or the migration Seed() method which both provide access to a context.
enumToLookup.Apply(context);
}
}
private static void TestConfig(string testSql, EnumToLookup enumToLookup)
{
Database.SetInitializer(new TestInitializer(enumToLookup));
using (var context = new MagicContext())
{
var roger = new Rabbit {
Name = "Roger", TehEars = Ears.Pointy
};
context.PeskyWabbits.Add(roger);
context.SaveChanges();
// assert
context.Database.ExecuteSqlCommand(testSql); // should explode if anything is wrong
}
}
public void ExampleOfUsingApply()
{
var enumToLookup = new EnumToLookup();
// enumToLookup.NameFieldLength = 42; // optional, example of how to override default values
//This will prevent spliiting the words
enumToLookup.SplitWords = false;
//Table prefix
enumToLookup.TableNamePrefix = "CAPS_E";
// This would normally be run inside either a db initializer Seed()
// or the migration Seed() method which both provide access to a context.
enumToLookup.Apply(_context);
}
public void ExampleOfGeneratingSql()
{
using (var context = new MyDbContext())
{
var enumToLookup = new EnumToLookup();
// if you need to get at the raw sql to run a migration separately then use:
var migrationSql = enumToLookup.GenerateMigrationSql(context);
// you'd probably want to write this to a file and then add it to source control, but for
// the purpose of demonstration we'll write it to the console instead:
Console.Out.WriteLine(migrationSql);
// at some point you'd then run the sql (probably not like this, but this serves as a test that it's working)
context.Database.ExecuteSqlCommand(migrationSql);
}
}
protected override void Seed(Domain.Models.ApplicationDbContext context)
{
var enumToLookup = new EnumToLookup();
enumToLookup.Apply(context);
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
// );
//
}
protected override void Seed(STM.Common.DataAccess.StmDbContext context)
{
//throw new Exception();
var mt1 = new MessageType
{
Name = "RTZ",
SchemaXSD = "rtz.xsd"
};
var mt2 = new MessageType
{
Name = "TXT",
SchemaXSD = "textMessageSchema.xsd"
};
var mt3 = new MessageType
{
Name = "S124",
SchemaXSD = "s124.xsd"
};
var mt4 = new MessageType
{
Name = "PCM",
SchemaXSD = "port-call-message_v0.16.xsd"
};
if (!context.MessageType.Any())
{
context.MessageType.Add(mt1);
context.MessageType.Add(mt2);
context.MessageType.Add(mt3);
context.MessageType.Add(mt4);
context.SaveChanges();
}
var enumToAdd = new EnumToLookup();
var migrationSql = enumToAdd.GenerateMigrationSql(context);
enumToAdd.Apply(context);
base.Seed(context);
}
protected override void Seed(Models.StripeOnboardingContext context)
{
var enumToLookup = new EnumToLookup();
enumToLookup.Apply(context);
}
protected override void Seed(LynexDbContext context)
{
using (var dbContext = new LynexDbContext())
{
var enumToLookup = new EnumToLookup();
enumToLookup.NameFieldLength = 25;
enumToLookup.TableNamePrefix = string.Empty;
enumToLookup.Apply(dbContext);
using (var roleStore = new RoleStore <Role, string, UserRole>(dbContext))
{
using (var roleManager = new RoleManager <Role>(roleStore))
{
roleManager.Create(new Role
{
Id = Guid.NewGuid().ToString(),
Name = "Administrator"
});
roleManager.Create(new Role
{
Id = Guid.NewGuid().ToString(),
Name = "User"
});
roleManager.Create(new Role
{
Id = Guid.NewGuid().ToString(),
Name = "CustomManager"
});
}
}
using (var userStore = new LynexUserStore(dbContext))
{
using (var userManager = new LynexUserManager(userStore))
{
var user = new User("0efc7c0b-e378-4fc7-9e48-af184f78ee03")
{
Email = "*****@*****.**",
EmailConfirmed = true,
Phone = "0430501022",
PhoneNumber = "0430501022",
PhoneNumberConfirmed = true,
AccessFailedCount = 0,
LockoutEnabled = false,
UserName = "******",
SecurityStamp = "7668b7bc-7a5d-4b3b-8388-f2e5c59f3d43",
PasswordHash = "ABJ1bxk+trJ6PTk4iCBSq/WLDVmhI455FFxZbcXHtH1Xw2NyTKHsJmrWQ1Mbl7S4SQ=="
};
userManager.Create(user);
userManager.AddToRole(user.Id, "Administrator");
var user2 = new User("b1f9c2ce-ad49-4251-9f33-f0dc8a2080c9")
{
Email = "*****@*****.**",
EmailConfirmed = true,
Phone = "0430501022",
PhoneNumber = "0430501022",
PhoneNumberConfirmed = true,
AccessFailedCount = 0,
LockoutEnabled = false,
UserName = "******",
SecurityStamp = "6c5d586d-8390-4d96-9db7-f06bb2c6a6df",
PasswordHash = "ANNNzqwEGjePRrU/8VbqSXnJynL/wP51zG+1Ilf424Pu9nYvLWmfa0owBFtj99fywQ=="
};
userManager.Create(user2);
userManager.AddToRole(user2.Id, "Administrator");
}
}
var site = new Site("5735824c-93cc-4016-b6b3-26f7947bb58e")
{
IsDefault = true,
UserId = "0efc7c0b-e378-4fc7-9e48-af184f78ee03",
Address = "11 Braceby Close",
Country = "Australia",
CreatedDateTime = DateTime.UtcNow,
Name = "Willetton",
Postcode = "6155",
State = "Western Australia",
Suburb = "Willetton",
UpdatedDateTime = DateTime.UtcNow,
SerialNumber = "RuHqYCQezwdrBmueo8ni",
Secret = "MWFX6PvK7TZVXLZ75SWBmzmYpr74VoP7b4etbRe7mizXbzfjiz7B9wnFCpDNDuZJ2XY2dNgJonH8vpmGAGnGQLQEyMfRkxmysXzL"
//{"D":"Z7At6fVvJdIX8QUS5s6qKo1K6YRrikZDCBtmZtFNvsLVDvmB5LNNtQ/TjrcxbmJCxcZCNudlnPSdK298QZFxc3asGpLtPkT9z2zjFOaQA9wpNtvQK7BTP/56QJQP6ioxGfEvilEXVXw+2ERkniu5zgOj5MdLy/T31JTUL6iCIJKsK6x2+pu0QbqCJPnQiZk+GvRB4/Y9VEvtUZl9xJQxuTkR/fYLXRL1sKbOxtWvf1Mimm62T1EH1GmR7cZvKkqdtLKrb/8/gehlcaWZ8ms0rfUWeEJUB1mPvqsCVjH5rvS1rX08j5gPyZtolpRqSoYjvFhk+3y6FQ6EOBX93RHVoQ==","DP":"TniHOfpjiWIuvEY46jdEgXfpycz5qwOBvkT59H551kAZvNjthCi3qaIhwpL+Eitfwe0ReqJKD/UYyojfq/6IDV+2UrKcitgd1f4E6dX5NIzQQ1cLN9Xga6hBPfosq12zZPHLUoHxQRtcNb305+EFHiHmEoYxfQl69RJBM3X3iZE=","DQ":"KR8L8vC8XiAFSg25dFmVrMxPmWT66+YmJKwanN2XV1bw3uajy5EFE0BjP74Ggt1IvnZm/PftBPQHNRRpF5VaQ5npaV6OVW1qDA2gdAOCU4tOh5Hnge1eN3r7bIwZ7S23ZhHBwvIYv3AHrjU9Ek25hqKMZ1B+A9Ghw22kNLB5BB0=","Exponent":"AQAB","InverseQ":"FjYzuUqQ4/EFTsWB2upii23mu5r0bEZ579TKNdbzVeSQkGcbI7tTRI4TrOWo07WkiAiJHe4XJtPxc/yj+vjzGhqqxjaaLWMK18qTwPY6OSOavwRZLEqdl/2kVslwZni8JTON18LY9itRM7uaY5lmmDUI7PNpyibbhJo9q0uBJYI=","Modulus":"mMxzNRkfAUGaa1CX8VGlsM07alr3mBMYbRWbOEz5/CtsrA8h70GMomHw97iTn6kn0/tTaOUUrEOu7bRZUiKLLlswV8Q5uyfukoNuSKR5bQUFGaZ1/WO11nAcdCcH0vmN8gZ9eRZiXfOx5sWA+SJ8YXN0H9DwlglhrRQZg8WA05bZ5jbAcfzeF3+rfkL+3b7CnZic2Yupk9zrR1uxQnD3qNKR2dlXCtSibb4JVzJ4CNSySqWvP0Q6fB0IBHnqLgJbE7lDRhLveW6IP6wcAZDxGFJ7fWys4Q2CGd0iCjviBHWDtkCWOaB57xTbR5Su7/mNhYWie14cuuWji9DiToNgZw==","P":"yx4toDmRKT1nu7MrJeNAbK1VzxxqpoovMiCezDnbv9XGwt2Yk1wejxasPNXVZ3Ca9DBItxZcx+fnKegZh2XzE8O8R+DZuXPEfOOwM+DZNZ5lk5VA/f+9XSjJZJaZeucatap75y4iTpvniuVx6zYIduUteS7Nyor8S3sLFsBch/E=","Q":"wJR9dPtEgb63x0Wdw9VNpRSt0eks6JE3CsLZkI80qnbpdZ5cmxIyDl5ww4t5haYiiJnD/FJIwFItdiH+GOyIaghcQnEMedSZG3iQVF6CvrjNhpymLPHqpg3iECmubyUlf3Q78UoVUl8u+3GEQQekwiHvbGyKq7vB5PziJqX9hdc="}
//Secret = "{\"D\":\"Z7At6fVvJdIX8QUS5s6qKo1K6YRrikZDCBtmZtFNvsLVDvmB5LNNtQ/TjrcxbmJCxcZCNudlnPSdK298QZFxc3asGpLtPkT9z2zjFOaQA9wpNtvQK7BTP/56QJQP6ioxGfEvilEXVXw+2ERkniu5zgOj5MdLy/T31JTUL6iCIJKsK6x2+pu0QbqCJPnQiZk+GvRB4/Y9VEvtUZl9xJQxuTkR/fYLXRL1sKbOxtWvf1Mimm62T1EH1GmR7cZvKkqdtLKrb/8/gehlcaWZ8ms0rfUWeEJUB1mPvqsCVjH5rvS1rX08j5gPyZtolpRqSoYjvFhk+3y6FQ6EOBX93RHVoQ==\",\"DP\":\"TniHOfpjiWIuvEY46jdEgXfpycz5qwOBvkT59H551kAZvNjthCi3qaIhwpL+Eitfwe0ReqJKD/UYyojfq/6IDV+2UrKcitgd1f4E6dX5NIzQQ1cLN9Xga6hBPfosq12zZPHLUoHxQRtcNb305+EFHiHmEoYxfQl69RJBM3X3iZE=\",\"DQ\":\"KR8L8vC8XiAFSg25dFmVrMxPmWT66+YmJKwanN2XV1bw3uajy5EFE0BjP74Ggt1IvnZm/PftBPQHNRRpF5VaQ5npaV6OVW1qDA2gdAOCU4tOh5Hnge1eN3r7bIwZ7S23ZhHBwvIYv3AHrjU9Ek25hqKMZ1B+A9Ghw22kNLB5BB0=\",\"Exponent\":\"AQAB\",\"InverseQ\":\"FjYzuUqQ4/EFTsWB2upii23mu5r0bEZ579TKNdbzVeSQkGcbI7tTRI4TrOWo07WkiAiJHe4XJtPxc/yj+vjzGhqqxjaaLWMK18qTwPY6OSOavwRZLEqdl/2kVslwZni8JTON18LY9itRM7uaY5lmmDUI7PNpyibbhJo9q0uBJYI=\",\"Modulus\":\"mMxzNRkfAUGaa1CX8VGlsM07alr3mBMYbRWbOEz5/CtsrA8h70GMomHw97iTn6kn0/tTaOUUrEOu7bRZUiKLLlswV8Q5uyfukoNuSKR5bQUFGaZ1/WO11nAcdCcH0vmN8gZ9eRZiXfOx5sWA+SJ8YXN0H9DwlglhrRQZg8WA05bZ5jbAcfzeF3+rfkL+3b7CnZic2Yupk9zrR1uxQnD3qNKR2dlXCtSibb4JVzJ4CNSySqWvP0Q6fB0IBHnqLgJbE7lDRhLveW6IP6wcAZDxGFJ7fWys4Q2CGd0iCjviBHWDtkCWOaB57xTbR5Su7/mNhYWie14cuuWji9DiToNgZw==\",\"P\":\"yx4toDmRKT1nu7MrJeNAbK1VzxxqpoovMiCezDnbv9XGwt2Yk1wejxasPNXVZ3Ca9DBItxZcx+fnKegZh2XzE8O8R+DZuXPEfOOwM+DZNZ5lk5VA/f+9XSjJZJaZeucatap75y4iTpvniuVx6zYIduUteS7Nyor8S3sLFsBch/E=\",\"Q\":\"wJR9dPtEgb63x0Wdw9VNpRSt0eks6JE3CsLZkI80qnbpdZ5cmxIyDl5ww4t5haYiiJnD/FJIwFItdiH+GOyIaghcQnEMedSZG3iQVF6CvrjNhpymLPHqpg3iECmubyUlf3Q78UoVUl8u+3GEQQekwiHvbGyKq7vB5PziJqX9hdc=\"}"
};
dbContext.Set <Site>().Add(site);
var site2 = new Site("781af7e0-0fe5-44b0-97c3-63a7ec48e420")
{
IsDefault = false,
UserId = "0efc7c0b-e378-4fc7-9e48-af184f78ee03",
Address = "8 Arklow Glen",
Country = "Australia",
CreatedDateTime = DateTime.UtcNow,
Name = "Canning Vale",
Postcode = "6155",
State = "Western Australia",
Suburb = "Canning Vale",
UpdatedDateTime = DateTime.UtcNow,
SerialNumber = "hcShsFBNtWgP95enHcSM",
Secret = "MWFX6PvK7TZVXLZ75SWBmzmYpr74VoP7b4etbRe7mizXbzfjiz7B9wnFCpDNDuZJ2XY2dNgJonH8vpmGAGnGQLQEyMfRkxmysXzL"
};
dbContext.Set <Site>().Add(site2);
var site3 = new Site("ae8213ef-cdc3-46f9-aff1-845a31f0b39a")
{
IsDefault = false,
UserId = "0efc7c0b-e378-4fc7-9e48-af184f78ee03",
Address = "59 Parry St",
Country = "Australia",
CreatedDateTime = DateTime.UtcNow,
Name = "Office",
Postcode = "6000",
State = "Western Australia",
Suburb = "Perth",
UpdatedDateTime = DateTime.UtcNow,
SerialNumber = "yP93qCe9ZeiRNNNa5ZBK",
Secret = "HgUGCx4sfSpvBvcAhX9p7GKHQc8wpYGg5tSWhtHn4xjQQebEQvQmAg5EWtkuVSSPvqN7EmP7EjnveZtfMJeAEi83u47wc9DKrrD6"
};
dbContext.Set <Site>().Add(site3);
var site4 = new Site("bba331f0-33a1-4a08-bdec-ea8257e807a9")
{
IsDefault = true,
UserId = "b1f9c2ce-ad49-4251-9f33-f0dc8a2080c9",
Address = "11 Braceby Close",
Country = "Australia",
CreatedDateTime = DateTime.UtcNow,
Name = "Willetton",
Postcode = "6155",
State = "Western Australia",
Suburb = "Willetton",
UpdatedDateTime = DateTime.UtcNow,
SerialNumber = "oVCZ49N7jDr6VgrnYHGF",
Secret = "pShhgsaTuXQpyB7g8eKT7i5J3oWJGtkyTD5dBxuPEHvs3wsBzscMW4spNTZnqLDXe2fEP2nVsjUxrATNC3VetJRgBNmR64vK4dMd"
};
dbContext.Set <Site>().Add(site4);
dbContext.SaveChanges();
for (var i = 1; i <= 40; i++)
{
var icon = new Icon
{
Id = i,
Name = i.ToString(),
Url = "/Images/Icons/white_64x64/" + i + ".png"
};
dbContext.Set <Icon>().Add(icon);
}
dbContext.SaveChanges();
var switch1 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "Irrigation",
Status = false,
Type = SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 0,
IconId = 1,
ChipId = "ESP10499465"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch1);
var switch2 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "Pool Pump",
Status = false,
Type = SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 1,
IconId = 2,
ChipId = "ESP10498757"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch2);
var switch3 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "Front Garden",
Status = false,
Type = SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 2,
IconId = 4,
ChipId = "ESP10500253"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch3);
var switch4 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "Pond Feature",
Status = false,
Type = SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 3,
IconId = 1,
ChipId = "ESP10472361"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch4);
var switch5 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "Water Feature",
Status = false,
Type = SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 4,
IconId = 1,
ChipId = "ESP10499179"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch5);
var switch6 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "Test Light",
Status = false,
Type = SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 5,
IconId = 4,
ChipId = "ESP10499464"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch6);
var switch7 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "Feature Water",
Status = false,
Type = SwitchType.SafeValtage,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 6,
IconId = 3,
ChipId = "ESP10488107"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch7);
var switch8 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "Pond Water",
Status = false,
Type = SwitchType.SafeValtage,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 7,
IconId = 3,
ChipId = "ESP10488288"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch8);
var switch9 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "SV 3",
Status = false,
Type = SwitchType.SafeValtage,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 8,
IconId = 1,
ChipId = "ESP104881071"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch9);
var switch10 = new Switch
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
Name = "SV 4",
Status = false,
Type = SwitchType.SafeValtage,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = 9,
IconId = 1,
ChipId = "ESP104881072"//StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(switch10);
for (var i = 1; i <= 4; i++)
{
var theSwitch = new Switch
{
SiteId = "781af7e0-0fe5-44b0-97c3-63a7ec48e420",
CreatedDateTime = DateTime.UtcNow,
Name = "Other Switch " + i,
Status = i % 2 != 0,
Type = i % 2 == 0 ? SwitchType.Normal : SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = i - 1,
IconId = 1,
ChipId = StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(theSwitch);
}
for (var i = 1; i <= 3; i++)
{
var theSwitch = new Switch
{
SiteId = "ae8213ef-cdc3-46f9-aff1-845a31f0b39a",
CreatedDateTime = DateTime.UtcNow,
Name = "Office Switch " + i,
Status = i % 2 != 0,
Type = i % 2 == 0 ? SwitchType.Normal : SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = i - 1,
IconId = 1,
ChipId = StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(theSwitch);
}
for (var i = 1; i <= 6; i++)
{
var theSwitch = new Switch
{
SiteId = "bba331f0-33a1-4a08-bdec-ea8257e807a9",
CreatedDateTime = DateTime.UtcNow,
Name = "Switch " + i,
Status = i % 2 != 0,
Type = i % 2 == 0 ? SwitchType.Normal : SwitchType.PowerMonitoring,
UpdatedDateTime = DateTime.UtcNow,
X = 0,
Y = 0,
Order = i - 1,
IconId = 1,
ChipId = StringExtension.GenerateMACAddress(),
};
dbContext.Set <Switch>().Add(theSwitch);
}
var wall1 = new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 94,
Y = 252,
Angle = 270,
Length = 194,
Type = WallType.Single
};
dbContext.Set <Wall>().Add(wall1);
var wall2 = new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 448,
Y = -100,
Angle = 0,
Length = 104,
Type = WallType.Double
};
dbContext.Set <Wall>().Add(wall2);
var wall3 = new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 1200,
Y = 432,
Angle = 0,
Length = 319.145802349033,
Type = WallType.Single
};
dbContext.Set <Wall>().Add(wall3);
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 703,
Y = 947,
Angle = 90,
Length = 276.828999999999,
Type = WallType.Double
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 699,
Y = 748,
Angle = 360,
Length = 204.493579850322,
Type = WallType.Single
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 95,
Y = 5,
Angle = 270,
Length = 359.000000000007,
Type = WallType.Double
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 1201,
Y = 749,
Angle = 90,
Length = 500.963381096862,
Type = WallType.Single
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 1204,
Y = 432,
Angle = 90,
Length = 504.662845174875,
Type = WallType.Double
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 433,
Y = 747,
Angle = 90,
Length = 339.065299167577,
Type = WallType.Double
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 92,
Y = 437,
Angle = 270,
Length = 610.679000000001,
Type = WallType.Single
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 704,
Y = -100,
Angle = 90,
Length = 254.048950002483,
Type = WallType.Double
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 426,
Y = 747,
Angle = 0,
Length = 205.186,
Type = WallType.Double
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 286,
Y = -1,
Angle = 0,
Length = 251.294,
Type = WallType.Single
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 99,
Y = 753,
Angle = 180,
Length = 753.35,
Type = WallType.Double
});
dbContext.Set <Wall>().Add(new Wall
{
SiteId = "5735824c-93cc-4016-b6b3-26f7947bb58e",
CreatedDateTime = DateTime.UtcNow,
UpdatedDateTime = DateTime.UtcNow,
X = 705,
Y = 438,
Angle = 180,
Length = 539.66,
Type = WallType.Double
});
dbContext.SaveChanges();
var schedule = new Schedule();
schedule.Active = true;
schedule.StartTime = new TimeSpan(6, 00, 0);
schedule.Length = 20;
schedule.Name = "Daily Irrigation";
schedule.Frequency = ScheduleFrequency.Daily;
schedule.SwitchId = switch1.Id;
schedule.Monday = true;
schedule.Tuesday = true;
schedule.Wednesday = true;
schedule.Thursday = true;
schedule.Friday = true;
schedule.Saturday = true;
schedule.Sunday = true;
dbContext.Set <Schedule>().Add(schedule);
var schedule2 = new Schedule();
schedule.Active = true;
schedule.StartTime = new TimeSpan(20, 0, 0);
schedule.Length = 20;
schedule.Name = "Night Irrigation";
schedule.Frequency = ScheduleFrequency.Daily;
schedule.SwitchId = switch1.Id;
schedule.Monday = true;
schedule.Tuesday = true;
schedule.Wednesday = true;
schedule.Thursday = true;
schedule.Friday = true;
schedule.Saturday = true;
schedule.Sunday = true;
dbContext.Set <Schedule>().Add(schedule2);
var schedule3 = new Schedule();
schedule.Active = true;
schedule.StartTime = new TimeSpan(18, 0, 0);
schedule.Length = 359;
schedule.Name = "Night Garden Light";
schedule.Frequency = ScheduleFrequency.Daily;
schedule.SwitchId = switch3.Id;
schedule.Monday = true;
schedule.Tuesday = true;
schedule.Wednesday = true;
schedule.Thursday = true;
schedule.Friday = true;
schedule.Saturday = true;
schedule.Sunday = true;
dbContext.Set <Schedule>().Add(schedule3);
var schedule4 = new Schedule();
schedule.Active = true;
schedule.StartTime = new TimeSpan(20, 0, 0);
schedule.Length = 20;
schedule.Name = "Pond Refill";
schedule.Frequency = ScheduleFrequency.Daily;
schedule.SwitchId = switch8.Id;
schedule.Monday = true;
schedule.Tuesday = true;
schedule.Wednesday = true;
schedule.Thursday = true;
schedule.Friday = true;
schedule.Saturday = true;
schedule.Sunday = true;
dbContext.Set <Schedule>().Add(schedule4);
dbContext.SaveChanges();
}
}
protected override void Seed(CashRegisterContext context)
{
var enumToLookup = new EnumToLookup();
enumToLookup.Apply(context);
var s = new InitHelper(context);
s.AddTab("Øl Fane", 0, "LimeGreen");
s.AddType("Billig Øl Type", 12, "YellowGreen");
s.AddGroup("Billig Øl Gruppe");
s.AddProduct("Ceres Top");
s.AddProduct("Royal Classic");
s.AddType("Special Øl Type", 15, "GreenYellow");
s.AddGroup("Special Øl Gruppe");
s.AddProduct("Royal Export");
s.AddProduct("Blå Thor");
s.AddProduct("Heineken");
s.AddProduct("Stout");
s.AddProduct("Giraf Kalle");
s.AddProduct("Havskum");
s.AddType("Udenlandsk Øl Type", 15, "LawnGreen");
s.AddGroup("Udenlandsk Øl Gruppe");
s.AddProduct("Sol");
s.AddProduct("Edelweiss");
s.AddProduct("Newcastle");
s.AddProduct("Moretti");
s.AddProduct("Krusovice");
s.AddType("Fadøl Type", 18, "Yellow");
s.AddGroup("Fadøl Gruppe");
s.AddProduct("Royal Fad");
s.AddProduct("Jule Fad");
s.AddTab("Drinks", 1, "DodgerBlue");
s.AddType("Billig Drinks Type", 20, "LightSkyBlue");
s.AddGroup("Billig Drinks Gruppe");
s.AddProduct("Brandbil");
s.AddProduct("Tequila Sunrise");
s.AddProduct("Champangne Brus");
s.AddProduct("Piña Colada");
s.AddProduct("Southern Delight");
s.AddProduct("Pawadise");
s.AddProduct("Fidel Castro");
s.AddProduct("Sommer Morgan");
s.AddProduct("Pink Pussy");
s.AddType("30 kr drinks", 30, "SkyBlue");
s.AddGroup("30 kr Drinks Gruppe");
s.AddProduct("Moscow Mule");
s.AddProduct("Fake Cherry");
s.AddProduct("Sweet Bombay");
s.AddProduct("Den Hvide Enke");
s.AddProduct("Irish Coffee");
s.AddProduct("Kaptain Eventyr");
s.AddProduct("White Russian");
s.AddProduct("Vodka Redbull");
s.AddProduct("Labre Larver");
s.AddType("35 kr drinks", 35, "DeepSkyBlue");
s.AddGroup("35 kr Drinks Gruppe");
s.AddProduct("Gøglermælk");
s.AddType("40 kr drinks", 40, "");
s.AddGroup("40 kr Drinks Gruppe");
s.AddProduct("Blå Batman");
s.AddProduct("Party Hamster");
s.AddProduct("Cosmopolitan");
s.AddType("45 kr drinks", 45, "PowderBlue");
s.AddGroup("45 kr Drinks Gruppe");
s.AddProduct("Long Island Iced Tea");
s.AddProduct("Memory Leak");
s.AddProduct("K-Special");
s.AddType("50 kr drinks", 50, "SteelBlue");
s.AddGroup("50 kr Drinks Gruppe");
s.AddProduct("Kold Krig (2 drinks)");
s.AddTab("Shots", 2, "IndianRed");
s.AddType("Billig Shots Type", 10, "DarkOrange");
s.AddGroup("Billig Shots Gruppe");
s.AddProduct("Jägermeister");
s.AddProduct("Sambuca");
s.AddProduct("Små Diverse");
s.AddProduct("Tequila");
s.AddProduct("Vodka");
s.AddProduct("Rom");
s.AddType("Alm Shots Type", 15, "OrangeRed");
s.AddGroup("Alm Shots Gruppe");
s.AddProduct("Arnbitter");
s.AddProduct("Cointreau");
s.AddProduct("Fernet Branca/Menta");
s.AddProduct("Galliano");
s.AddProduct("Gin");
s.AddProduct("Khalua");
s.AddProduct("Pisang Ambon");
s.AddProduct("Southern Comfort");
s.AddProduct("Whiskey");
s.AddProduct("Bailey");
s.AddProduct("Galliano Hotshots");
s.AddType("Dyre Shots Type", 20, "Red");
s.AddGroup("Dyre Shots Gruppe");
s.AddProduct("Jägerbombs");
s.AddProduct("Snefnugg");
s.AddTab("SodaPopz", 3, "Coral");
s.AddType("Sodapop", 25, "DarkSalmon");
s.AddGroup("Sodapop");
s.AddProduct("Blue Desire");
s.AddProduct("Dirty Passion");
s.AddProduct("Pure Exotic");
s.AddProduct("White Lies");
s.AddProduct("Senven Sins");
s.AddProduct("Brezzer Lemon");
s.Save();
base.Seed(context);
}
