public static void AddressData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.addresses.AddRange(
new Data.Address {
AddressLine1 = "127/71", AddressLine2 = "saket nagar", City = "Kanpur", State = "UP", Pincode = "208014"
},
new Data.Address {
AddressLine1 = "b-31", AddressLine2 = "AWAS VIKAS ", City = "Kanpur", State = "UP", Pincode = "208014"
},
new Data.Address {
AddressLine1 = "H-281", AddressLine2 = "Sector 62", City = "Noida", State = "UP", Pincode = "208014"
},
new Data.Address {
AddressLine1 = "127/17", AddressLine2 = "Kidwai nagar", City = "Kanpur", State = "UP", Pincode = "208012"
},
new Data.Address {
AddressLine1 = "123/62", AddressLine2 = "Govind nagar", City = "Lucknow", State = "UP", Pincode = "208011"
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void StaffData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.staffs.AddRange(
new Data.Staff {
First_Name = "Henry", Last_Name = "Dsouza", Gender = "M", Phone_Number = "7865435678", Salary = 5000, RoleId = 2, AddressId = 2
},
new Data.Staff {
First_Name = "Natasha", Last_Name = "Sharma", Gender = "F", Phone_Number = "7865435672", Salary = 3000, RoleId = 1, AddressId = 3
},
new Data.Staff {
First_Name = "Shruti", Last_Name = "Bakshi", Gender = "F", Phone_Number = "7865436678", Salary = 5000, RoleId = 2, AddressId = 4
},
new Data.Staff {
First_Name = "Medha", Last_Name = "Gupta", Gender = "F", Phone_Number = "7865465672", Salary = 3000, RoleId = 1, AddressId = 1
},
new Data.Staff {
First_Name = "Sanjeev", Last_Name = "Sharma", Gender = "M", Phone_Number = "7868435672", Salary = 15000, RoleId = 3, AddressId = 5
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void InventoryData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.inventories.AddRange(
new Data.Inventory {
ProductId = 1, TotalQuantity = 21
},
new Data.Inventory {
ProductId = 2, TotalQuantity = 30
},
new Data.Inventory {
ProductId = 3, TotalQuantity = 12
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void RoleData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.roles.AddRange(
new Data.Role {
Rolename = "Working Staff", Description = "working with products"
},
new Data.Role {
Rolename = "Reception Staff", Description = "biling counter"
},
new Data.Role {
Rolename = "Manager", Description = "management of workers"
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void CategoryData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.categories.AddRange(
new Data.Category {
CategoryName = "Technology Items", CategoryCode = "TECH"
},
new Data.Category {
CategoryName = "Dairy Items", CategoryCode = "DAIR"
},
new Data.Category {
CategoryName = "Wordrobe Items", CategoryCode = "WORD"
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void ProductPriceData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.productPrices.AddRange(
new Data.ProductPrice {
ProductId = 1, CostPrice = 20000, SellingPrice = 23000, IsActive = true, Month = new DateTime(2020, 01, 12)
},
new Data.ProductPrice {
ProductId = 1, CostPrice = 2500, SellingPrice = 2599, IsActive = false, Month = new DateTime(2020, 02, 11)
},
new Data.ProductPrice {
ProductId = 1, CostPrice = 20, SellingPrice = 24, IsActive = true, Month = new DateTime(2020, 05, 23)
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void ProductData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.products.AddRange(
new Data.Product {
ProductName = "Laptop", ProductInStock = true, Manufacturer = "Dell", ProductCode = "LAP0", CategoryId = 1
},
new Data.Product {
ProductName = "Tshirt", ProductInStock = false, Manufacturer = "Allen Solly", ProductCode = "TS10", CategoryId = 3
},
new Data.Product {
ProductName = "Yougurt", ProductInStock = true, Manufacturer = "Amul", ProductCode = "YOG10", CategoryId = 2
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void ProductCategoryData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.productCategories.AddRange(
new Data.ProductCategory {
ProductId = 1, CategoryId = 1
},
new Data.ProductCategory {
ProductId = 2, CategoryId = 3
},
new Data.ProductCategory {
ProductId = 3, CategoryId = 2
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void SupplierProductOrderData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.supplierProductOrders.AddRange(
new Data.SupplierProductOrder {
ProductId = 1, ProductOrderId = 2, SupplierId = 4
},
new Data.SupplierProductOrder {
ProductId = 2, ProductOrderId = 3, SupplierId = 2
},
new Data.SupplierProductOrder {
ProductId = 3, ProductOrderId = 2, SupplierId = 3
},
new Data.SupplierProductOrder {
ProductId = 1, ProductOrderId = 1, SupplierId = 3
});
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void ProductOrderData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.productOrders.AddRange(
new Data.ProductOrder {
OrderTime = new DateTime(2021, 01, 11), Qunatity = 22
},
new Data.ProductOrder {
OrderTime = new DateTime(2021, 05, 15), Qunatity = 10
},
new Data.ProductOrder {
OrderTime = new DateTime(2021, 03, 17), Qunatity = 3
},
new Data.ProductOrder {
OrderTime = new DateTime(2020, 01, 11), Qunatity = 2
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public static void SupplierData()
{
using (DbStoreContext context = new DbStoreContext())
{
context.suppliers.AddRange(
new Data.Supplier {
SupplierName = "Hina", SupplierAge = 29, SupplierEmail = "*****@*****.**", SupplierGender = "F", SupplierPhonenumber = "657853890"
},
new Data.Supplier {
SupplierName = "Akash", SupplierAge = 49, SupplierEmail = "*****@*****.**", SupplierGender = "M", SupplierPhonenumber = "659953890"
},
new Data.Supplier {
SupplierName = "Harsh", SupplierAge = 39, SupplierEmail = "*****@*****.**", SupplierGender = "M", SupplierPhonenumber = "657887890"
},
new Data.Supplier {
SupplierName = "Shvani", SupplierAge = 42, SupplierEmail = "*****@*****.**", SupplierGender = "F", SupplierPhonenumber = "657653890"
}
);
context.SaveChanges();
Console.WriteLine("DATA ADDED");
}
}
public IActionResult postItems(Staff item)
{
_context.staffs.Add(item);
_context.SaveChanges();
return(Ok(item));
}
public IActionResult postProduct(Product item)
{
_context.products.Add(item);
_context.SaveChanges();
return(Ok(item));
}