private static void SeedCustomer(OisysDbContext context)
{
if (!context.Customers.Any())
{
context.Customers.Add(new Customer
{
Name = "Mickey Mouse",
Email = "*****@*****.**",
ContactNumber = "399-39-39",
ContactPerson = "Mr. Mickey",
Address = "Disneyland Tokyo",
CityId = 3,
ProvinceId = 1,
Terms = "term1",
Discount = 10m,
PriceList = PriceList.WalkInPrice,
Keywords = "Mickey Mouse"
});
context.Customers.Add(new Customer
{
Name = "Mario Cart",
Email = "*****@*****.**",
ContactNumber = "383-33-00",
ContactPerson = "Mr. Luigi",
Address = "Japan Nintendo Park",
CityId = 5,
ProvinceId = 2,
Terms = "term2",
Discount = 5m,
PriceList = PriceList.MainPrice,
Keywords = "Mario Cart"
});
}
}
private static void SeedUsers(OisysDbContext context)
{
if (!context.Users.Any())
{
var rowVersion = "Dcf9Zu/SChO4DF9eQxKWnw==";
var newUser = new ApplicationUser {
Username = "******", Firstname = "Admin", Lastname = "User", AccessRights = "admin,canView,canWrite,canDelete", RowVersion = Convert.FromBase64String(rowVersion)
};
var password = new PasswordHasher <ApplicationUser>().HashPassword(newUser, "Admin");
newUser.PasswordHash = password;
context.Users.Add(newUser);
}
}
public static void Seed(OisysDbContext context, IHostingEnvironment env)
{
if (env.IsDevelopment() || env.IsEnvironment("Kube"))
{
//context.Database.EnsureDeleted();
context.Database.EnsureCreated();
SeedCategories(context);
SeedProvincesAndCities(context);
context.SaveChanges();
SeedCustomer(context);
SeedItems(context);
}
SeedUsers(context);
context.SaveChanges();
}
private static void SeedCategories(OisysDbContext context)
{
if (!context.Categories.Any())
{
var categories = new List <Category>
{
new Category {
Name = "Material"
},
new Category {
Name = "Paint"
},
new Category {
Name = "Stainless"
},
new Category {
Name = "Vacuum"
},
};
context.Categories.AddRange(categories);
}
}
private static void SeedProvincesAndCities(OisysDbContext context)
{
if (!context.Provinces.Any())
{
var provinces = new List <Province>
{
new Province
{
Name = "NCR",
Cities = new List <City>
{
new City {
Name = "Manila"
},
new City {
Name = "Makati"
},
new City {
Name = "Las Pinas"
},
new City {
Name = "Paranaque"
},
},
},
new Province
{
Name = "Cavite",
Cities = new List <City>
{
new City {
Name = "Tanza"
},
new City {
Name = "Indang"
},
new City {
Name = "Gen Trias"
},
},
},
new Province
{
Name = "Bulacan",
Cities = new List <City>
{
new City {
Name = "Malolos"
},
new City {
Name = "Bocaue"
},
new City {
Name = "Obando"
},
},
},
};
context.Provinces.AddRange(provinces);
}
}
private static void SeedItems(OisysDbContext context)
{
if (!context.Items.Any())
{
var items = new List <Item>
{
new Item
{
Code = "0001", Name = "Item Number 1", CategoryId = 1, Description = "Item 1. This is item 1", Quantity = 100, StockQuantity = 100, Unit = "pcs.", MainPrice = 1919.99m, NEPrice = 2929.99m, WalkInPrice = 3939.39m,
TransactionHistory = new List <ItemHistory> {
new ItemHistory {
Date = DateTime.Now, Quantity = 100, Remarks = Constants.AdjustmentRemarks.InitialQuantity
}
}
},
new Item
{
Code = "0002", Name = "Item Number 2", CategoryId = 2, Description = "Item 2. This is item 2", Quantity = 200, StockQuantity = 200, Unit = "stacks", MainPrice = 919.99m, NEPrice = 929.99m, WalkInPrice = 939.39m,
TransactionHistory = new List <ItemHistory> {
new ItemHistory {
Date = DateTime.Now, Quantity = 200, Remarks = Constants.AdjustmentRemarks.InitialQuantity
}
}
},
new Item
{
Code = "0003", Name = "Item Number 3", CategoryId = 1, Description = "Item 3. This is item 3", Quantity = 3000, StockQuantity = 3000, Unit = "makes", MainPrice = 111m, NEPrice = 222m, WalkInPrice = 333m,
TransactionHistory = new List <ItemHistory> {
new ItemHistory {
Date = DateTime.Now, Quantity = 3000, Remarks = Constants.AdjustmentRemarks.InitialQuantity
}
}
},
new Item
{
Code = "0004", Name = "Item Number 4", CategoryId = 3, Description = "Item 4. This is item 4", Quantity = 1200, StockQuantity = 1200, Unit = "pc", MainPrice = 12.50m, NEPrice = 29.50m, WalkInPrice = 39.50m,
TransactionHistory = new List <ItemHistory> {
new ItemHistory {
Date = DateTime.Now, Quantity = 1200, Remarks = Constants.AdjustmentRemarks.InitialQuantity
}
}
},
new Item
{
Code = "0005", Name = "Item Number 5", CategoryId = 4, Description = "Item 5. This is item 5", Quantity = 20020, StockQuantity = 20020, Unit = "shards", MainPrice = 400m, NEPrice = 500m, WalkInPrice = 600m,
TransactionHistory = new List <ItemHistory> {
new ItemHistory {
Date = DateTime.Now, Quantity = 20020, Remarks = Constants.AdjustmentRemarks.InitialQuantity
}
}
},
new Item
{
Code = "0006", Name = "Item Number 6", CategoryId = 4, Description = "Item 6. This is item 6", Quantity = 2000, StockQuantity = 2000, Unit = "rolls", MainPrice = 1211m, NEPrice = 1222m, WalkInPrice = 1233m,
TransactionHistory = new List <ItemHistory> {
new ItemHistory {
Date = DateTime.Now, Quantity = 2000, Remarks = Constants.AdjustmentRemarks.InitialQuantity
}
}
},
};
context.Items.AddRange(items);
}
}