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