public void CreateOrder(OrderDetailDTO order)
{
Order orderToCreate = new Order()
{
CustomerId = order.CustomerId,
StoreId = order.StoreId,
OrderDate = DateTime.Now,
Subtotal = order.Subtotal
};
_context.Add(orderToCreate);
_context.SaveChanges();
Order justCreated = _context.Orders.OrderBy(x => x.OrderId).Last();
var deetsOfJustCreated = _context.OrderDetails.OrderBy(x => x.OrderId).Last();
List <OrderDetail> listOfDeets = new List <OrderDetail>();
foreach (var item in order.Products)
{
var moreInfo = new OrderDetail
{
OrderId = justCreated.OrderId,
ProductId = item.ProductId,
Quantity = item.Quantity
};
listOfDeets.Add(moreInfo);
}
foreach (var deet in listOfDeets)
{
_context.Add(deet);
_context.SaveChanges();
}
}
static void locationHelper(Project1Context context)
{
context.StoreLocations.AddRange(
new StoreLocation
{
Location = "Houston"
},
new StoreLocation
{
Location = "Dallas"
},
new StoreLocation
{
Location = "Austin"
},
new StoreLocation
{
Location = "San Antonio"
},
new StoreLocation
{
Location = "Midland"
}
);
context.SaveChanges();
}
static void storeInventoryHelper(Project1Context context)
{
context.StoreItemInventories.AddRange(
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
},
new StoreItemInventory
{
itemInventory = 10
}
);
context.SaveChanges();
}
static void storeItemHelper(Project1Context context)
{
context.StoreItems.AddRange(
new StoreItem
{
itemName = "German Shepherd",
itemPrice = 600,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 1),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 1)
},
new StoreItem
{
itemName = "Siberian Husky",
itemPrice = 700,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 1),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 2)
},
new StoreItem
{
itemName = "Border Collie",
itemPrice = 850,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 1),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 3)
},
new StoreItem
{
itemName = "Siamese Cat",
itemPrice = 10000,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 2),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 4)
},
new StoreItem
{
itemName = "Persian Cat",
itemPrice = 1200,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 2),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 5)
},
new StoreItem
{
itemName = "Himalayan Cat",
itemPrice = 1250,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 2),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 6)
},
new StoreItem
{
itemName = "Peach Cream Gecko",
itemPrice = 300,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 3),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 7)
},
new StoreItem
{
itemName = "Spotted Viper",
itemPrice = 750,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 3),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 8)
},
new StoreItem
{
itemName = "Red Tarantula",
itemPrice = 150,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 3),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 9)
},
new StoreItem
{
itemName = "Zebra Angel Fish",
itemPrice = 40,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 4),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 10)
},
new StoreItem
{
itemName = "Elephant Nose Fish",
itemPrice = 30,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 4),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 11)
},
new StoreItem
{
itemName = "Royal Purple Discus",
itemPrice = 120,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 4),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 12)
},
new StoreItem
{
itemName = "Colombian Boa",
itemPrice = 275,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 5),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 13)
},
new StoreItem
{
itemName = "King Snake",
itemPrice = 175,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 5),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 14)
},
new StoreItem
{
itemName = "Blood Pythond",
itemPrice = 500,
StoreLocation = context.StoreLocations.First(x => x.StoreLocationId == 5),
StoreItemInventory = context.StoreItemInventories
.First(x => x.StoreItemInventoryId == 15)
}
);
context.SaveChanges();
}