public static void Initialize(MyRestaurantContext context)
{
TransactionTypeInitializer.Initialize(context);
PaymentTypeInitializer.Initialize(context);
if (!context.Transactions.Any())
{
var transactions = new List <Transaction>
{
new Transaction {
TransactionTypeId = 1,
PaymentTypeId = 2,
Date = DateTime.Now.AddDays(-10),
Description = "Peanuts in Coke",
Amount = 6.5m,
Cashflow = Cashflow.Expense,
CreatedAt = DateTime.Now
},
new Transaction {
TransactionTypeId = 10,
PaymentTypeId = 1,
Date = DateTime.Now.AddDays(-5),
Description = "Income from sale",
Amount = 110.5m,
Cashflow = Cashflow.Income,
CreatedAt = DateTime.Now
}
};
context.Transactions.AddRange(transactions);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
RoleInitialize(context);
UserInitialize(context);
UserRoleInitialize(context);
UserClaimInitialize(context);
}
public static void Initialize(MyRestaurantContext context)
{
GoodsReceivedNoteInitializer.Initialize(context);
if (!context.GoodsReceivedNoteFreeItems.Any())
{
var goodsReceivedNoteFreeItems = new List <GoodsReceivedNoteFreeItem>
{
new GoodsReceivedNoteFreeItem {
Id = 1,
GoodsReceivedNoteId = 1,
ItemId = 8,
ItemUnitPrice = 250,
Quantity = 1,
Nbt = 0.1m,
Vat = 0.1m,
Discount = 0.1m
},
new GoodsReceivedNoteFreeItem
{
Id = 2,
GoodsReceivedNoteId = 2,
ItemId = 19,
ItemUnitPrice = 30,
Quantity = 5,
Nbt = 0.1m,
Vat = 0.1m,
Discount = 0.1m
}
};
context.GoodsReceivedNoteFreeItems.AddRange(goodsReceivedNoteFreeItems);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
if (!context.UnitOfMeasures.Any())
{
var unitOfMeasures = new List <UnitOfMeasure>
{
new UnitOfMeasure {
Code = "kg", Description = "kg units"
},
new UnitOfMeasure {
Code = "g", Description = "g units"
},
new UnitOfMeasure {
Code = "ml", Description = "ml units"
},
new UnitOfMeasure {
Code = "l", Description = "l units"
},
new UnitOfMeasure {
Code = "none", Description = ""
}
};
context.UnitOfMeasures.AddRange(unitOfMeasures);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
UserInitializer.Initialize(context);
SupplierInitializer.Initialize(context);
if (!context.PurchaseOrders.Any())
{
var orders = new List <PurchaseOrder>
{
new PurchaseOrder
{
OrderNumber = "PO_20210130_8d8c510caee6a4b",
SupplierId = 1,
RequestedBy = context.Users.First(d => d.FirstName == "Normal").Id,
RequestedDate = DateTime.Now.AddDays(-10),
ApprovalStatus = Status.Approved,
ApprovedBy = context.Users.First(d => d.FirstName == "Admin").Id,
ApprovedDate = DateTime.Now,
Description = "Test",
ApprovalReason = "Items are required"
},
new PurchaseOrder
{
OrderNumber = "PO_20210130_8d8c512f7cd7920",
SupplierId = 2,
RequestedBy = context.Users.First(d => d.FirstName == "Admin").Id,
RequestedDate = DateTime.Now.AddDays(-5),
ApprovalStatus = Status.Pending,
ApprovedBy = Guid.Empty,
ApprovedDate = default,
public static void Initialize(MyRestaurantContext context)
{
PaymentTypeInitializer.Initialize(context);
UnitOfMeasureInitializer.Initialize(context);
StockTypeInitializer.Initialize(context);
StockItemInitializer.Initialize(context);
SupplierInitializer.Initialize(context);
UserInitializer.Initialize(context);
PurchaseOrderInitializer.Initialize(context);
PurchaseOrderItemInitializer.Initialize(context);
if (!context.GoodsReceivedNotes.Any())
{
var goodsReceivedNotes = new List <GoodsReceivedNote>
{
new GoodsReceivedNote {
PurchaseOrderId = 1,
InvoiceNumber = "INV_20210132_01",
PaymentTypeId = 1,
Nbt = 0.5m,
Vat = 0.5m,
Discount = 0.5m,
ReceivedBy = context.Users.First(d => d.FirstName == "Admin").Id,
ReceivedDate = DateTime.Now.AddDays(-5),
ApprovedBy = Guid.Empty,
ApprovalStatus = Status.Pending,
ApprovedDate = default,
public MyRestaurantContextTestBase()
{
var options = new DbContextOptionsBuilder <MyRestaurantContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString())
.Options;
_myRestaurantContext = new MyRestaurantContext(options);
_myRestaurantContext.Database.EnsureCreated();
}
public DatabaseFixture()
{
ConnectionString = $"Server={_sereverName},1433;Database={Guid.NewGuid()};User={_userName};Password={_password}";
WrongConnectionString = $"Server=Test,1433;Database=Test;User=Test;Password=Test";
var builder = new DbContextOptionsBuilder <MyRestaurantContext>();
builder.UseSqlServer(ConnectionString);
_myRestaurantContext = new MyRestaurantContext(builder.Options);
}
public static void Initialize(MyRestaurantContext context)
{
if (!context.RefreshTokens.Any())
{
var refreshTokens = new List <RefreshToken>
{
new RefreshToken
{
UserId = context.Users.First(d => d.FirstName == "Admin").Id,
Token = "token1",
Expires = DateTime.Now.AddHours(2),
Created = DateTime.Now,
CreatedByIp = "0.0.0.1",
},
new RefreshToken
{
UserId = context.Users.First(d => d.FirstName == "Normal").Id,
Token = "eyJhbGciOiJodHRwOi8vd3d3LnczLm9yZy8yMDAxLzA0L3htbGRzaWctbW9yZSNobWFjLXNoYTUxMiIsInR5cCI6IkpXVCJ9.eyJuYmYiOjE2MDk3NDc5ODAsImV4cCI6MTYwOTc2OTU4MCwiaXNzIjoiaHR0cHM6Ly9sb2NhbGhvc3Q6NDQzMDEiLCJhdWQiOiJodHRwczovL2xvY2FsaG9zdDo0NDMwMSJ9.kvX-GbWYLkgEY3Kl9RaRvESbNRkl8NDBxGNTcTFUGBpaLwSM8oWt9U6bKQNoPbcAbNui3ubvbCapkmc3SWVmfg",
Expires = DateTime.Now.AddDays(-10).AddHours(2),
Revoked = null,
Created = DateTime.Now.AddDays(-10),
CreatedByIp = "0.0.0.1",
},
new RefreshToken
{
UserId = context.Users.First(d => d.FirstName == "Report").Id,
Token = "token3",
Expires = DateTime.Now.AddHours(2),
Created = DateTime.Now,
CreatedByIp = "0.0.0.1",
},
new RefreshToken
{
UserId = context.Users.First(d => d.FirstName == "Golden").Id,
Token = "token4",
Expires = DateTime.Now.AddHours(2),
Created = DateTime.Now,
CreatedByIp = "0.0.0.1",
}
};
context.RefreshTokens.AddRange(refreshTokens);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
if (!context.ServiceTypes.Any())
{
var serviceTypes = new List <ServiceType>
{
new ServiceType {
Type = "Take Away"
},
new ServiceType {
Type = "Dine In"
}
};
context.ServiceTypes.AddRange(serviceTypes);
context.SaveChanges();
}
}
private static void UserRoleInitialize(MyRestaurantContext context)
{
if (!context.UserRoles.Any())
{
var dbRoles = context.Roles.ToList();
var dbUsers = context.Users.ToList();
var userRoles = new List <UserRole> {
};
foreach (var user in dbUsers)
{
if (user.FirstName == "Golden")
{
foreach (var role in dbRoles)
{
userRoles.Add(new UserRole {
UserId = user.Id, RoleId = role.Id
});
}
}
if (user.FirstName == "Admin")
{
userRoles.Add(new UserRole {
UserId = user.Id, RoleId = dbRoles.First(d => d.Name == "Admin").Id
});
}
if (user.FirstName == "Report")
{
userRoles.Add(new UserRole {
UserId = user.Id, RoleId = dbRoles.First(d => d.Name == "Report").Id
});
}
if (user.FirstName == "Normal")
{
userRoles.Add(new UserRole {
UserId = user.Id, RoleId = dbRoles.First(d => d.Name == "Normal").Id
});
}
}
context.UserRoles.AddRange(userRoles);
context.SaveChanges();
}
}
public static void Insert(MyRestaurantContext context)
{
//context.AspNetUsers.AddOrUpdate(
//p => p.Id,
//new Model.Models.AspNetUsers
//{
// Id = "1F109894-9942-4D28-89CD-3BD7B9993F4D",
// Email = "*****@*****.**",
// EmailConfirmed = true,
// PasswordHash = "ABSGD9MfeFY5CskhCR6GRwrghxv77rUyDBoY9A2mxdoK7S0k3u4WHD8Fu1H+f6IjGQ==",
// SecurityStamp = "d121f3f0-1018-4f63-a8ae-6405da74a0f7",
// PhoneNumberConfirmed = false,
// TwoFactorEnabled = false,
// LockoutEnabled = false,
// LockoutEndDateUtc = DateTime.Now,
// AccessFailedCount = 0,
// UserName = "******",
//});
//context.SaveChanges();
}
public static void Initialize(MyRestaurantContext context)
{
if (!context.StockTypes.Any())
{
var stockTypes = new List <StockType>
{
new StockType {
Type = "Grocery", Description = ""
},
new StockType {
Type = "Beverage", Description = ""
},
new StockType {
Type = "Stationery"
}
};
context.StockTypes.AddRange(stockTypes);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
if (!context.PaymentTypes.Any())
{
var paymentTypes = new List <PaymentType>
{
new PaymentType {
Name = "Cash", CreditPeriod = 0
},
new PaymentType {
Name = "Credit", CreditPeriod = 30
},
new PaymentType {
Name = "Credit100", CreditPeriod = 100
},
};
context.PaymentTypes.AddRange(paymentTypes);
context.SaveChanges();
}
}
private static void UserClaimInitialize(MyRestaurantContext context)
{
if (!context.UserClaims.Any())
{
var dbUsers = context.Users.ToList();
var claims = new List <IdentityUserClaim <Guid> > {
};
foreach (var user in dbUsers)
{
if (user.FirstName == "Golden")
{
claims.Add(new IdentityUserClaim <Guid> {
UserId = user.Id, ClaimType = "AccessCategory", ClaimValue = "SuperAdmin"
});
}
if (user.FirstName == "Admin")
{
claims.Add(new IdentityUserClaim <Guid> {
UserId = user.Id, ClaimType = "AccessCategory", ClaimValue = "Admin"
});
}
if (user.FirstName == "Report")
{
claims.Add(new IdentityUserClaim <Guid> {
UserId = user.Id, ClaimType = "AccessCategory", ClaimValue = "Report"
});
}
if (user.FirstName == "Normal")
{
claims.Add(new IdentityUserClaim <Guid> {
UserId = user.Id, ClaimType = "AccessCategory", ClaimValue = "Normal"
});
}
}
context.UserClaims.AddRange(claims);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
StockItemInitializer.Initialize(context);
PurchaseOrderInitializer.Initialize(context);
if (!context.PurchaseOrderItems.Any())
{
var items = new List <PurchaseOrderItem>
{
new PurchaseOrderItem {
PurchaseOrderId = 1, ItemId = 1, ItemUnitPrice = 540, Quantity = 5
},
new PurchaseOrderItem {
PurchaseOrderId = 2, ItemId = 2, ItemUnitPrice = 30, Quantity = 10
},
new PurchaseOrderItem {
PurchaseOrderId = 1, ItemId = 3, ItemUnitPrice = 50, Quantity = 5
},
new PurchaseOrderItem {
PurchaseOrderId = 2, ItemId = 4, ItemUnitPrice = 260, Quantity = 6
},
new PurchaseOrderItem {
PurchaseOrderId = 3, ItemId = 15, ItemUnitPrice = 8500, Quantity = 1
},
new PurchaseOrderItem {
PurchaseOrderId = 4, ItemId = 21, ItemUnitPrice = 3240, Quantity = 3
},
new PurchaseOrderItem {
PurchaseOrderId = 5, ItemId = 29, ItemUnitPrice = 450, Quantity = 40
},
new PurchaseOrderItem {
PurchaseOrderId = 6, ItemId = 28, ItemUnitPrice = 320, Quantity = 20
}
};
context.PurchaseOrderItems.AddRange(items);
context.SaveChanges();
}
}
private static void UserInitialize(MyRestaurantContext context)
{
var superAdminUser = new User {
FirstName = "Golden", LastName = "Dining", Email = "*****@*****.**"
};
var adminUser = new User {
FirstName = "Admin", LastName = "Access", Email = "*****@*****.**"
};
var reportUser = new User {
FirstName = "Report", LastName = "Access", Email = "*****@*****.**"
};
var normalUser = new User {
FirstName = "Normal", LastName = "Access", Email = "*****@*****.**"
};
if (!context.Users.Any())
{
var dbRoles = context.Roles.ToList();
superAdminUser.UserRoles.Add(new UserRole {
User = superAdminUser, Role = dbRoles.First(x => x.Name == "SuperAdmin")
});
adminUser.UserRoles.Add(new UserRole {
User = adminUser, Role = dbRoles.First(x => x.Name == "Admin")
});
reportUser.UserRoles.Add(new UserRole {
User = reportUser, Role = dbRoles.First(x => x.Name == "Report")
});
normalUser.UserRoles.Add(new UserRole {
User = normalUser, Role = dbRoles.First(x => x.Name == "Normal")
});
var users = new List <User> {
superAdminUser, adminUser, reportUser, normalUser
};
context.Users.AddRange(users);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
if (!context.PaymentTypes.Any())
{
var restaurantInfo = new List <RestaurantInfo>
{
new RestaurantInfo
{
Id = 1,
Name = "Golden Dining",
Address = "Kandy Road, Kaithady",
City = "Jaffna",
Country = "Sri Lanka",
LandLine = "+9423454544",
Mobile = "+94567876786",
Email = "*****@*****.**"
}
};
context.RestaurantInfos.AddRange(restaurantInfo);
context.SaveChanges();
}
}
private static void RoleInitialize(MyRestaurantContext context)
{
var superAdmin = new Role {
Name = "SuperAdmin"
};
var admin = new Role {
Name = "Admin"
};
var report = new Role {
Name = "Report"
};
var normal = new Role {
Name = "Normal"
};
if (!context.Roles.Any())
{
var roles = new List <Role> {
superAdmin, admin, report, normal
};
context.Roles.AddRange(roles);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
if (!context.TransactionTypes.Any())
{
var transactionTypes = new List <TransactionType>
{
new TransactionType {
Type = "Food"
},
new TransactionType {
Type = "Transportation"
},
new TransactionType {
Type = "Shopping"
},
//new TransactionType { Type = "Mortgage/Rent" },
new TransactionType {
Type = "Mortgage"
},
new TransactionType {
Type = "Clothing"
},
new TransactionType {
Type = "Housing"
},
new TransactionType {
Type = "Utilities"
},
new TransactionType {
Type = "Bills"
},
new TransactionType {
Type = "Personal Care"
},
new TransactionType {
Type = "Extra Income"
},
new TransactionType {
Type = "Miscellaneous"
},
new TransactionType {
Type = "Health Care"
},
new TransactionType {
Type = "Interests"
},
new TransactionType {
Type = "Insurance"
},
new TransactionType {
Type = "Business"
},
new TransactionType {
Type = "Tax"
},
//new TransactionType { Type = "Salary" },
new TransactionType {
Type = "Education"
}
};
context.TransactionTypes.AddRange(transactionTypes);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
UnitOfMeasureInitializer.Initialize(context);
StockTypeInitializer.Initialize(context);
if (!context.StockItems.Any())
{
var stockItems = new List <StockItem>
{
new StockItem {
TypeId = 1, Name = "Rice", ItemUnit = 10, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 1, Name = "Chilli Powder", ItemUnit = 250, UnitOfMeasureId = 2
},
new StockItem {
TypeId = 2, Name = "Water", ItemUnit = 1, UnitOfMeasureId = 4
},
new StockItem {
TypeId = 3, Name = "Blue Pen", ItemUnit = 10, UnitOfMeasureId = 5
},
new StockItem {
TypeId = 3, Name = "Oats", ItemUnit = 186, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 1, Name = "Cheese", ItemUnit = 88, UnitOfMeasureId = 2
},
new StockItem {
TypeId = 1, Name = "Pasta", ItemUnit = 52, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 1, Name = "Chips", ItemUnit = 21, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 1, Name = "Nut butter", ItemUnit = 167, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 1, Name = "Popcorn", ItemUnit = 101, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 3, Name = "Mouse", ItemUnit = 5, UnitOfMeasureId = 5
},
new StockItem {
TypeId = 1, Name = "Sausages", ItemUnit = 72, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 1, Name = "Flour ", ItemUnit = 99, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 1, Name = "Chips Large", ItemUnit = 116, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 3, Name = "Table Large", ItemUnit = 1, UnitOfMeasureId = 5
},
new StockItem {
TypeId = 2, Name = "Vinegar", ItemUnit = 125, UnitOfMeasureId = 4
},
new StockItem {
TypeId = 2, Name = "Ketchup", ItemUnit = 199, UnitOfMeasureId = 3
},
new StockItem {
TypeId = 1, Name = "Mustard", ItemUnit = 73, UnitOfMeasureId = 2
},
new StockItem {
TypeId = 1, Name = "Butter", ItemUnit = 60, UnitOfMeasureId = 2
},
new StockItem {
TypeId = 1, Name = "Dried fruit", ItemUnit = 120, UnitOfMeasureId = 2
},
new StockItem {
TypeId = 3, Name = "Table", ItemUnit = 2, UnitOfMeasureId = 5
},
new StockItem {
TypeId = 2, Name = "Cooking Oil", ItemUnit = 148, UnitOfMeasureId = 4
},
new StockItem {
TypeId = 1, Name = "Garlic", ItemUnit = 143, UnitOfMeasureId = 2
},
new StockItem {
TypeId = 3, Name = "Towels", ItemUnit = 20, UnitOfMeasureId = 5
},
new StockItem {
TypeId = 3, Name = "Gloves", ItemUnit = 30, UnitOfMeasureId = 5
},
new StockItem {
TypeId = 3, Name = "Keyboard", ItemUnit = 5, UnitOfMeasureId = 5
},
new StockItem {
TypeId = 2, Name = "Honey", ItemUnit = 87, UnitOfMeasureId = 3
},
new StockItem {
TypeId = 1, Name = "Sugar", ItemUnit = 142, UnitOfMeasureId = 1
},
new StockItem {
TypeId = 1, Name = "Tuna", ItemUnit = 177, UnitOfMeasureId = 2
}
};
context.StockItems.AddRange(stockItems);
context.SaveChanges();
}
}
public static void Initialize(MyRestaurantContext context)
{
if (!context.Suppliers.Any())
{
var suppliers = new List <Supplier>
{
new Supplier
{
Name = "ABC Pvt Ltd", Address1 = "American Mission School Road", Address2 = "Madduvil South",
City = "Chavakachcheri", Country = "Sri Lanka", Telephone1 = "0765554345", Telephone2 = "0766554567",
Fax = "", Email = "*****@*****.**", ContactPerson = "James"
},
new Supplier
{
Name = "VBT Pvt Ltd", Address1 = "VBT Road", Address2 = "VBTt",
City = "Jaffna", Country = "Sri Lanka", Telephone1 = "0777113644", Telephone2 = "",
Fax = "", Email = "*****@*****.**", ContactPerson = "James"
},
new Supplier
{
Name = "Defense & Space", Address1 = "170 Blick Trail", Address2 = "New Hampshire",
City = "West Camrynport", Country = "Colombia", Telephone1 = "679-846-5956", Telephone2 = "523-275-0788",
Fax = "971-812-9638", Email = "*****@*****.**", ContactPerson = "Deanna"
},
new Supplier
{
Name = "Dairy", Address1 = "941 Jarod Camp", Address2 = "Wyoming",
City = "Charleston", Country = "New Caledonia", Telephone1 = "912-369-3329", Telephone2 = "090-234-3464",
Fax = "934-688-9150", Email = "*****@*****.**", ContactPerson = "Nicklaus"
},
new Supplier
{
Name = "Construction", Address1 = "95102 Rogahn Loaf", Address2 = "Wyoming",
City = "Charleston", Country = "New Caledonia", Telephone1 = "050-853-8227", Telephone2 = "515-785-8383",
Fax = "928-570-9780", Email = "*****@*****.**", ContactPerson = "Larissa"
},
new Supplier
{
Name = "Recreational", Address1 = "73429 Richard Course", Address2 = "South Carolina",
City = "East Constantin", Country = "Ecuador", Telephone1 = "832-319-6315", Telephone2 = "586-173-3164",
Fax = "477-916-9881", Email = "*****@*****.**", ContactPerson = "Lue"
},
new Supplier
{
Name = "Accounting", Address1 = "55693 Berge Walk", Address2 = "Alabama",
City = "Mullerchester", Country = "Sudan", Telephone1 = "192-637-6273", Telephone2 = "074-655-7364",
Fax = "311-587-2726", Email = "*****@*****.**", ContactPerson = "Emmalee"
},
new Supplier
{
Name = "Political Organization", Address1 = "58204 Renner Divide", Address2 = "Maryland",
City = "North Nikko", Country = "Gabon", Telephone1 = "538-881-6913", Telephone2 = "932-546-7844",
Fax = "173-733-1304", Email = "*****@*****.**", ContactPerson = "Prudence"
},
new Supplier
{
Name = "Automotive", Address1 = "424 Cesar Walks", Address2 = "New Mexico",
City = "Port Manleyland", Country = "Cyprus", Telephone1 = "188-694-9543", Telephone2 = "485-188-2440",
Fax = "203-944-7683", Email = "*****@*****.**", ContactPerson = "Audie"
},
new Supplier
{
Name = "Executive Office", Address1 = "32433 Shaun Inlet", Address2 = "Florida",
City = "Lueilwitzmouth", Country = "Switzerland", Telephone1 = "908-867-1023", Telephone2 = "730-452-3702",
Fax = "436-099-9286", Email = "*****@*****.**", ContactPerson = "Candace"
},
new Supplier
{
Name = "Architecture & Planning", Address1 = "51220 Quigley Estate", Address2 = "Hawaii",
City = "Marianaside", Country = "Burkina Faso", Telephone1 = "768-250-5153", Telephone2 = "812-707-9313",
Fax = "814-374-0668", Email = "*****@*****.**", ContactPerson = "Dawson"
},
new Supplier
{
Name = "Renewables & Environment", Address1 = "09101 Alvera Rapids", Address2 = "Kentucky",
City = "Marcusside", Country = "Armenia", Telephone1 = "071-193-7154", Telephone2 = "587-668-3800",
Fax = "835-177-1774", Email = "*****@*****.**", ContactPerson = "Marilou"
},
new Supplier
{
Name = "Philanthropy", Address1 = "5697 Collins Spurs", Address2 = "Mississippi",
City = "Eastvale", Country = "Dominican Republic", Telephone1 = "344-135-7771", Telephone2 = "459-745-5501",
Fax = "361-907-8030", Email = "*****@*****.**", ContactPerson = "Coralie"
},
new Supplier
{
Name = "Executive Office", Address1 = "6847 Steuber Mount", Address2 = "Minnesota",
City = "Fargo", Country = "Vietnam", Telephone1 = "879-576-7067", Telephone2 = "333-751-8481",
Fax = "415-199-1971", Email = "*****@*****.**", ContactPerson = "Julianne"
},
new Supplier
{
Name = "Utilities", Address1 = "3818 McCullough Ridges", Address2 = "Missouri",
City = "North Highlands", Country = "Somalia", Telephone1 = "286-643-2457", Telephone2 = "669-049-9251",
Fax = "487-362-9802", Email = "*****@*****.**", ContactPerson = "Johnnie"
},
new Supplier
{
Name = "Civil Engineering", Address1 = "7658 Carey Ways", Address2 = "Louisiana",
City = "Hellerbury", Country = "Mali", Telephone1 = "096-069-1543", Telephone2 = "085-480-9084",
Fax = "294-839-6064", Email = "*****@*****.**", ContactPerson = "Dariana"
},
new Supplier
{
Name = "Tobacco", Address1 = "7729 Marietta Estate", Address2 = "Illinois",
City = "Lake Evans", Country = "Afghanistan", Telephone1 = "789-029-7980", Telephone2 = "678-944-6380",
Fax = "293-028-8740", Email = "*****@*****.**", ContactPerson = "Stephen"
},
new Supplier
{
Name = "Translation & Localization", Address1 = "80228 Feest Loaf", Address2 = "Tennessee",
City = "Trantowshire", Country = "Pakistan", Telephone1 = "901-358-0826", Telephone2 = "660-927-3749",
Fax = "125-987-0988", Email = "*****@*****.**", ContactPerson = "Ivy"
},
new Supplier
{
Name = "Graphic Design", Address1 = "62070 Gabriella Key", Address2 = "Kansas",
City = "Harveymouth", Country = "Tuvalu", Telephone1 = "732-060-9477", Telephone2 = "162-490-2457",
Fax = "472-110-7266", Email = "*****@*****.**", ContactPerson = "Efrain"
},
new Supplier
{
Name = "Entertainment", Address1 = "163 Paula Plaza", Address2 = "Massachusetts",
City = "Genevievebury", Country = "Switzerland", Telephone1 = "983-958-1244", Telephone2 = "973-925-5438",
Fax = "039-246-0901", Email = "*****@*****.**", ContactPerson = "Silas"
},
new Supplier
{
Name = "Executive Office", Address1 = "7227 Schroeder Club", Address2 = "Hawaii",
City = "Lombard", Country = "Norway", Telephone1 = "146-035-4135", Telephone2 = "079-664-5145",
Fax = "455-125-3578", Email = "*****@*****.**", ContactPerson = "Hayden"
},
new Supplier
{
Name = "Computer Software", Address1 = "8084 Noe Highway", Address2 = "South Dakota",
City = "New Leonieshire", Country = "Yemen", Telephone1 = "719-837-6088", Telephone2 = "493-282-1487",
Fax = "583-786-1752", Email = "*****@*****.**", ContactPerson = "Macy"
},
new Supplier
{
Name = "Banking", Address1 = "56290 Kovacek Underpass", Address2 = "Arkansas",
City = "North Richland Hills", Country = "Guatemala", Telephone1 = "967-857-5255", Telephone2 = "535-449-7505",
Fax = "850-149-5994", Email = "*****@*****.**", ContactPerson = "Shanie"
},
new Supplier
{
Name = "Wholesale", Address1 = "339 Daphnee Turnpike", Address2 = "Nebraska",
City = "Hellerland", Country = "Palau", Telephone1 = "431-705-1593", Telephone2 = "793-778-6576",
Fax = "683-841-3526", Email = "*****@*****.**", ContactPerson = "Evangeline"
},
new Supplier
{
Name = "Nonprofit Organization Management", Address1 = "706 Kertzmann Port", Address2 = "Florida",
City = "West Brooke", Country = "Palestinian Territory", Telephone1 = "775-366-3840", Telephone2 = "159-564-5886",
Fax = "167-239-3145", Email = "*****@*****.**", ContactPerson = "Asha"
},
new Supplier
{
Name = "Entertainment", Address1 = "0374 Jocelyn Springs", Address2 = "Iowa",
City = "Tacoma", Country = "Sri Lanka", Telephone1 = "574-031-4037", Telephone2 = "044-453-9539",
Fax = "998-167-7334", Email = "*****@*****.**", ContactPerson = "Demario"
},
new Supplier
{
Name = "Computer Software", Address1 = "41108 Wuckert Harbor", Address2 = "Tennessee",
City = "Lake Valentin", Country = "Aruba", Telephone1 = "933-064-1967", Telephone2 = "123-209-5865",
Fax = "936-416-0079", Email = "*****@*****.**", ContactPerson = "Karley"
}
};
context.Suppliers.AddRange(suppliers);
context.SaveChanges();
}
}