public void TestNumberProducts()
{
using (var dbContext = new storeApplicationContext())
{
int numOfProducts = dbContext.Product.Count();
Assert.Equal(expected: 8, actual: numOfProducts);
}
}
public void TestNumberOfStores()
{
using (var dbContext = new storeApplicationContext())
{
int numOfStores = dbContext.Store.Count();
Assert.Equal(expected: 7, actual: numOfStores);
}
}
public void TestNumberOfCustomers()
{
using (var dbContext = new storeApplicationContext())
{
int numOfCustomer = dbContext.Customer.Count();
Assert.Equal(expected: 13, actual: numOfCustomer);
}
}
/// <summary>
/// A void method that dissplays the stores to the console.
/// </summary>
public static void display()
{
using (var dbContext = new storeApplicationContext())
{
Console.WriteLine("These are stores in the system:");
Console.WriteLine("----------------------------------");
foreach (var store in dbContext.Store)
{
Console.WriteLine(store.Location);
}
}
}
public void searchCustomer(string firstName, string lastName)
{
using (var dbContext = new storeApplicationContext())
{
foreach (var customer in dbContext.Customer)
{
if (customer.FirstName.Equals(firstName) && customer.LastName.Equals(lastName))
{
Assert.Equal($"{firstName} {lastName}", $"{customer.FirstName} {customer.LastName}");
}
}
}
}
/// <summary>
/// adds a customer to the system.
/// </summary>
public static void Add()
{
using (var dbContext = new storeApplicationContext())
{
var customer = new Customer();
Console.WriteLine("Enter a customer's first name");
string firstName = Console.ReadLine();
Console.WriteLine("Enter a customer's last name");
string lastName = Console.ReadLine();
Console.WriteLine("Enter a customer's gender");
string sex = Console.ReadLine();
customer.FirstName = firstName;
customer.LastName = lastName;
customer.Sex = sex;
dbContext.Add(customer);
dbContext.SaveChanges();
} Console.WriteLine("Successfully entered the customer in the system");
}
/// <summary>
/// A void method that searches a customer in the system
/// </summary>
/// <returns></returns>
public static bool searchCustomer()
{
using (var dbContext = new storeApplicationContext())
{
Console.WriteLine("Enter customer's first name");
string inputfirstName = Console.ReadLine(); // first name
Console.WriteLine("Enter customer's last name");
string inputLastName = Console.ReadLine(); // last name
var customer = new Customer();
customer.FirstName = inputfirstName;
customer.LastName = inputLastName;
foreach (var cust in dbContext.Customer)
{
if (customer.FirstName.Equals(cust.FirstName) && customer.LastName.Equals(cust.LastName))
{
Console.WriteLine($"{customer.FirstName} {customer.LastName} is in the system");
return(true);
}
}
} Console.WriteLine("The customer is not in the system");
return(false);
}
/// <summary>
/// places an order for the customer.
/// </summary>
public static void addOrder()
{
using (var dbContext = new storeApplicationContext())
{
StoreRep.display();
Console.WriteLine("------------------------------------");
Console.WriteLine("Select a store");
Console.WriteLine("------------------------------------------");
string selectedStore = Console.ReadLine();
Console.WriteLine("---------------------------------------------");
int storeID = 0; //storing this for later use
int proID = 0; //storing the ID for later use
int inventory = 0; //storing the stock for later use
foreach (var store in dbContext.Store)
{
if (store.Location.Equals(selectedStore))
{
storeID = +store.StoreId;
}
}
foreach (var inventory_stock in dbContext.InventoryStocked)
{
if (inventory_stock.StoreId == storeID)
{
proID += inventory_stock.ProdId;
inventory += (int)inventory_stock.Stock; //casting to int
}
}
foreach (var product in dbContext.Product)
{
if (product.ProdId == proID)
{
Console.WriteLine($"{selectedStore} has the following product and its quantity/stock");
Console.WriteLine($"Product name: {product.Name}");
Console.WriteLine($"Stock: {inventory}");
Console.WriteLine("--------------------------------------------");
}
}
Console.WriteLine("Enter your first and last name to continue with order");
string FName = Console.ReadLine();
string LName = Console.ReadLine();
int id = 0; //store the id of a selected customer.
foreach (var customer in dbContext.Customer)
{
if (customer.FirstName.Equals(FName) && customer.LastName.Equals(LName))
{
id += customer.CustId;
}
}
var order = new Orders(); // instantiate a new order
order.CustId = id; //Assigning the foreign key CustId in the order to the id of the selected customer.
dbContext.Add(order); // adding the new order in the system
dbContext.SaveChanges();
Console.WriteLine("Enter the number of products to put in your cart:");
int num = int.Parse(Console.ReadLine());
Console.WriteLine("-----------------------------------------");
var order_details = new OrderDetails();
order_details.OrderId = order.OrderId;
order_details.ProdId = proID;
order_details.Qty = num;
dbContext.AddAsync(order_details);
Console.WriteLine("Order has been successfully placed");
Console.WriteLine("--------------------------------------------------");
}
}
