/// <summary>
/// Creates a new customer and adds them to the database.
/// </summary>
/// <param name="input">User input.</param>
/// <param name="db">Database reference.</param>
void CreateNewCustomer(IUserInput input, BaB_DbContext db)
{
//create variables to hold user input during creation
String newFirstName;
String newLastName;
String newUsername;
String newPassword;
//Thank the user
Console.WriteLine("Thank you for signing up!");
//Collect and store first and last names (okay to be duplicated)
Console.Write("Please enter your first name: ");
newFirstName = input.GetInput();
Console.Write("Please enter your last name: ");
newLastName = input.GetInput();
do //Username loop -- repeat until available name
{
Console.Write("Please enter your desired username: "******"go back") || (newUsername.ToLower() == "goback") || String.IsNullOrWhiteSpace(newUsername)) //Username cannot be "Go back" or empty
{
Console.WriteLine("We're sorry, that cannot be used for your username. Please try a different username. ");
}
else //valid username input
{
//query database for matching usernames
var usernameAvailabilityCheck =
(from check in db.CustomersDB
where (check.CustUsername == newUsername)
select check);
if (usernameAvailabilityCheck.Count() == 0) //if the username does not exist yet
{
//inform user name is available
Console.Write("Username available! ");
//request desired password
Console.Write("Please enter your desired password: "******"We're sorry, that username is unavailable. Please select a different name.");
}
}
} while (true);
//create a new customer object using the input information
Customer newCustomer = new Customer(newFirstName, newLastName, newUsername, newPassword);
db.Add(newCustomer);
db.SaveChanges();
//query database for newly created Customer's customerID
loggedInCustomer = newCustomer;
}
public void TestIncorrectCustomerSearch()
{
//Arrange
var options = new DbContextOptionsBuilder <BaB_DbContext>()
.UseInMemoryDatabase(databaseName: "Test2DB")
.Options;
//Act
Customer testCustomer;
#region Test database seeding
using (var context = new BaB_DbContext(options))
{
//Add user to the database for testing
testCustomer = new Customer
{
CustFirstName = "Annie",
CustLastName = "Admin",
CustUsername = "******",
CustPassword = "******"
};
context.Add(testCustomer);
context.SaveChanges();
}
#endregion
//Create object to hold the LogIn reference
LogIn testLogInObject = new LogIn();
//Call sign-in method with given credentials, using in-memory database
using (var context = new BaB_DbContext(options))
{
testLogInObject.LogInStart(new UnitTest2Inputs(), context);
}
//Assert
using (var context = new BaB_DbContext(options))
{
//var testCustomer = context.CustomersDB.Where(c => c.CustUsername == "testUser").FirstOrDefault();
Assert.Equal(testCustomer.CustomerID, testLogInObject.LoggedInCustomer.CustomerID);
}
}
public void TestSubmitEmptyOrder()
{
//Arrange
var options = new DbContextOptionsBuilder <BaB_DbContext>()
.UseInMemoryDatabase(databaseName: "Test8Db")
.Options;
//Act
Customer testCustomer;
#region Test database seeding
using (var context = new BaB_DbContext(options))
{
#region Customers
//Add customers to database for sampling from
Customer testCustomer1 = new Customer
{
CustFirstName = "Annie",
CustLastName = "Admin",
CustUsername = "******",
CustPassword = "******"
};
Customer testCustomer2 = new Customer
{
CustFirstName = "Becky",
CustLastName = "Boss",
CustUsername = "******",
CustPassword = "******"
};
context.Add(testCustomer1);
context.Add(testCustomer2);
#endregion
#region LocationCountry
//Add Location Country to the test database
LocationCountry testLocationCountry = new LocationCountry
{
Country = "USA"
};
context.Add(testLocationCountry);
#endregion
#region LocationState
//Add Location State to the test database
LocationState testLocationState = new LocationState
{
State = "Illinois"
};
context.Add(testLocationState);
#endregion
#region Locations
//Add locations to the test database
Location testLocation1 = new Location
{
LocationAddress = "1 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
Location testLocation2 = new Location
{
LocationAddress = "2 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
context.Add(testLocation1);
context.Add(testLocation2);
#endregion
testCustomer = testCustomer1;
context.SaveChanges();
}
#endregion
PlaceOrder testPlaceOrder = new PlaceOrder();
using (var context = new BaB_DbContext(options))
{
testPlaceOrder.CreateOrder(new UnitTest8Inputs(), context, testCustomer);
}
//Assert
using (var context = new BaB_DbContext(options))
{
Assert.Equal(0, context.OrderLineItemsDB.Count());
}
}
public void TestOrderLookupCustomerLastName()
{
//Arrange
var options = new DbContextOptionsBuilder <BaB_DbContext>()
.UseInMemoryDatabase(databaseName: "Test7DB")
.Options;
//Act
Order testOrder;
#region Test database seeding
using (var context = new BaB_DbContext(options))
{
#region Customers
//Add customers to database for sampling from
Customer testCustomer1 = new Customer
{
CustFirstName = "Annie",
CustLastName = "Admin",
CustUsername = "******",
CustPassword = "******"
};
Customer testCustomer2 = new Customer
{
CustFirstName = "Becky",
CustLastName = "Boss",
CustUsername = "******",
CustPassword = "******"
};
context.Add(testCustomer1);
context.Add(testCustomer2);
#endregion
#region Products
//Add a product to the database for building with
Product testProduct = new Product
{
ProductName = "Test product",
ProductPrice = 1
};
context.Add(testProduct);
#endregion
#region LocationCountry
//Add Location Country to the test database
LocationCountry testLocationCountry = new LocationCountry
{
Country = "USA"
};
context.Add(testLocationCountry);
#endregion
#region LocationState
//Add Location State to the test database
LocationState testLocationState = new LocationState
{
State = "Illinois"
};
context.Add(testLocationState);
#endregion
#region Locations
//Add locations to the test database
Location testLocation1 = new Location
{
LocationAddress = "1 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
Location testLocation2 = new Location
{
LocationAddress = "2 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
context.Add(testLocation1);
context.Add(testLocation2);
#endregion
#region Orders
//Add orders to the database for testing
Order testOrder1 = new Order
{
OrderCustomer = testCustomer1,
OrderLocation = testLocation2,
OrderDate = DateTime.Now,
//OrderTotal = 3
};
Order testOrder2 = new Order
{
OrderCustomer = testCustomer2,
OrderLocation = testLocation1,
OrderDate = DateTime.Now,
//OrderTotal = 7
};
context.Add(testOrder1);
context.Add(testOrder2);
#endregion
#region Line Items
//Add line items to the database for building with
OrderLineItem testLineItem1 = new OrderLineItem
{
LineItemOrder = testOrder1,
LineItemProduct = testProduct,
Quantity = 1,
LinePrice = 1
};
OrderLineItem testLineItem2 = new OrderLineItem
{
LineItemOrder = testOrder1,
LineItemProduct = testProduct,
Quantity = 2,
LinePrice = 2
};
OrderLineItem testLineItem3 = new OrderLineItem
{
LineItemOrder = testOrder2,
LineItemProduct = testProduct,
Quantity = 3,
LinePrice = 3
};
OrderLineItem testLineItem4 = new OrderLineItem
{
LineItemOrder = testOrder2,
LineItemProduct = testProduct,
Quantity = 4,
LinePrice = 4
};
context.Add(testLineItem1);
context.Add(testLineItem2);
context.Add(testLineItem3);
context.Add(testLineItem4);
#endregion
//fill in testOrder with one of the pre-seeded values
testOrder = testOrder1;
context.SaveChanges();
}
#endregion
//Create object to hold the OrderLookup reference
SearchPastOrders testOrderLookupObject = new SearchPastOrders();
using (var context = new BaB_DbContext(options))
{
testOrderLookupObject.OrderLookup(new UnitTest7Inputs(), context);
}
//Assert
using (var context = new BaB_DbContext(options))
{
Assert.Equal(testOrder.OrderID, testOrderLookupObject.QueriedOrder.OrderID);
}
}
public void TestRemoveItemFromOrder()
{
//Arrange
var options = new DbContextOptionsBuilder <BaB_DbContext>()
.UseInMemoryDatabase(databaseName: "Test10Db")
.Options;
//Act
Customer testCustomer;
#region Test database seeding
using (var context = new BaB_DbContext(options))
{
#region Customers
//Add customers to database for sampling from
Customer testCustomer1 = new Customer
{
CustFirstName = "Annie",
CustLastName = "Admin",
CustUsername = "******",
CustPassword = "******"
};
Customer testCustomer2 = new Customer
{
CustFirstName = "Becky",
CustLastName = "Boss",
CustUsername = "******",
CustPassword = "******"
};
context.Add(testCustomer1);
context.Add(testCustomer2);
#endregion
#region LocationCountry
//Add Location Country to the test database
LocationCountry testLocationCountry = new LocationCountry
{
Country = "USA"
};
context.Add(testLocationCountry);
#endregion
#region LocationState
//Add Location State to the test database
LocationState testLocationState = new LocationState
{
State = "Illinois"
};
context.Add(testLocationState);
#endregion
#region Products
//Add a product to the database for building with
Product testProduct1 = new Product
{
ProductName = "Test product 1",
ProductPrice = 1
};
Product testProduct2 = new Product
{
ProductName = "Test product 2",
ProductPrice = 1
};
Product testProduct3 = new Product
{
ProductName = "Test product 3",
ProductPrice = 1
};
context.Add(testProduct1);
context.Add(testProduct2);
context.Add(testProduct3);
#endregion
#region Locations
//Add locations to the test database
Location testLocation1 = new Location
{
LocationAddress = "1 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
Location testLocation2 = new Location
{
LocationAddress = "2 Street",
LocationState = testLocationState,
LocationCountry = testLocationCountry
};
context.Add(testLocation1);
context.Add(testLocation2);
#endregion
#region Inventory
//Add inventory to locations
Inventory testInventory1 = new Inventory
{
InventoryLocation = testLocation1,
InventoryProduct = testProduct1,
QuantityAvailable = 15
};
Inventory testInventory2 = new Inventory
{
InventoryLocation = testLocation1,
InventoryProduct = testProduct2,
QuantityAvailable = 15
};
Inventory testInventory3 = new Inventory
{
InventoryLocation = testLocation1,
InventoryProduct = testProduct3,
QuantityAvailable = 15
};
Inventory testInventory4 = new Inventory
{
InventoryLocation = testLocation2,
InventoryProduct = testProduct1,
QuantityAvailable = 15
};
Inventory testInventory5 = new Inventory
{
InventoryLocation = testLocation2,
InventoryProduct = testProduct2,
QuantityAvailable = 15
};
Inventory testInventory6 = new Inventory
{
InventoryLocation = testLocation2,
InventoryProduct = testProduct3,
QuantityAvailable = 15
};
context.Add(testInventory1);
context.Add(testInventory2);
context.Add(testInventory3);
context.Add(testInventory4);
context.Add(testInventory5);
context.Add(testInventory6);
#endregion
testCustomer = testCustomer1;
context.SaveChanges();
}
#endregion
PlaceOrder testPlaceOrder = new PlaceOrder();
using (var context = new BaB_DbContext(options))
{
testPlaceOrder.CreateOrder(new UnitTest11Inputs(), context, testCustomer);
}
//Assert
using (var context = new BaB_DbContext(options))
{
Assert.Equal(0, context.OrderLineItemsDB.Count());
Assert.Equal(0, context.OrdersDB.Count());
}
}
/// <summary>
/// This method creates, fills out, and submits orders according to user input.
/// </summary>
/// <param name="input">User input.</param>
/// <param name="db">Database reference.</param>
/// <param name="customer">The currently logged in customer</param>
public void CreateOrder(IUserInput input, BaB_DbContext db, Customer customer)
{
//Order to store the location and customer info
Order currentOrder = new Order(customer);
//List to hold Line Order objects
List <OrderLineItem> orderLineItems = new List <OrderLineItem>();
//place order formatting
Console.WriteLine("-----------------------------");
Console.WriteLine(" Place an Order");
Console.WriteLine("-----------------------------");
Console.WriteLine("Locations:");
//query database for list of locations
var locationsLookup = db.LocationsDB.Include(loc => loc.LocationState).Include(loc => loc.LocationCountry).ToList();
//iterate through list, printing out each location
foreach (Location loc in locationsLookup)
{
Console.WriteLine($"{loc.LocationID}: {loc.LocationAddress}, {loc.LocationState.State}, {loc.LocationCountry.Country}");
}
//method logic
do
{
Console.Write("Please select a location's number, or \"Go back\" to return to the previous menu: ");
userInput = input.GetInput();
if ((userInput.ToLower() == "go back") || (userInput.ToLower() == "goback")) //User input: "Go Back"
{
return; //Close out of the method
}
else //User selected a location
{
try
{
int userLocationChoice = int.Parse(userInput); //parse user's input as int
if ((userLocationChoice < 1) || (locationsLookup.Count() < userLocationChoice)) //if input is out of range...
{
throw new ArgumentOutOfRangeException(); //pre-emptively throw exception
}
else
{
foreach (Location loc in locationsLookup) //loop through locations, finding the matching one
{
if (userLocationChoice == loc.LocationID)
{
currentOrder.OrderLocation = loc; //add location to constructed Order
}
}
//reiterate user's location back to them.
Console.WriteLine($"Your location selection: {currentOrder.OrderLocation.LocationAddress}, {currentOrder.OrderLocation.LocationState.State}, {currentOrder.OrderLocation.LocationCountry.Country}");
//Query database for current inventory stocks
var inv = db.InventoryDB
.Include(loc => loc.InventoryLocation)
.Include(prod => prod.InventoryProduct)
.Where(loc => loc.InventoryLocation.LocationID == userLocationChoice);
//Start Order Line Item loop
do
{
//counter to hold item number (generalizes number for ease of user selection)
int itemNumber = 1;
Console.WriteLine("Current location inventory: ");
foreach (var stock in inv)
{
//List items in inventory at location, then increment counter
Console.WriteLine($"Item #{itemNumber}: {stock.InventoryProduct.ProductName} -- Number available: {stock.QuantityAvailable}");
itemNumber++;
}
Console.Write("Enter \"Add Item\" to add an item to your order, \"Remove Item\" to remove an item from your order, \"View Order\" to see your current order, or \"Check Out\" to submit your order: ");
//inner loop for controlling console spam during selection
do
{
userInput = input.GetInput(); //Get user input
if ((userInput.ToLower() == "add item") || (userInput.ToLower() == "additem")) //User input: Add Item to order
{
//Lock into add item loop
do
{
Console.Write("Please enter the ID Number of the product you would like to add to your order, or \"Go Back\" to return to order menu: ");
userInput = input.GetInput();
if ((userInput.ToLower() == "go back") || (userInput.ToLower() == "goback")) //back out of add item menu
{
goto ActionComplete;
}
else //Enter an item ID
{
try
{
var userProductChoice = int.Parse(userInput); //parse user input to int
if ((userProductChoice < 0) || (userProductChoice > inv.Count())) //check if input is within range
{
throw new ArgumentOutOfRangeException(); //pre-emptively throw exception
}
else //valid item ID
{
//counter for iterating through IQueryable and finding the correct item
int prodCounter = 1;
foreach (var prod in inv)
{
if (prodCounter == userProductChoice) //Check each item in inventory query to see if it matches
{
Console.Write("Please enter the quantity you would like to add to your order: ");
userInput = input.GetInput();
try
{
var userQuantityChoice = int.Parse(userInput); //parse input to int
if ((userQuantityChoice < 0) || (userQuantityChoice > prod.QuantityAvailable)) //Check if input is out of range
{
throw new ArgumentOutOfRangeException(); //pre-emptively throw exception
}
else //valid input
{
//create line item with information provided (order, product, quantity, line price
//Source: https://docs.microsoft.com/en-us/dotnet/csharp/programming-guide/classes-and-structs/how-to-implement-a-lightweight-class-with-auto-implemented-properties
orderLineItems.Add(OrderLineItem.CreateLineItem(currentOrder, prod.InventoryProduct, userQuantityChoice, (prod.InventoryProduct.ProductPrice * userQuantityChoice)));
//decrease inventory counts by same amount
prod.QuantityAvailable -= userQuantityChoice;
//Wait for user input
Console.WriteLine("Item added to order! Press enter to continue...");
input.GetInput();
goto ActionComplete;
}
}
catch (ArgumentOutOfRangeException) //Input greater than remaining inventory
{
Console.WriteLine("There is not sufficient inventory left to fill that order.");
break;
}
catch (Exception) //Catch other exceptions that slip through the cracks
{
Console.WriteLine("Invalid selection. Please verify your input and try again.");
}
}
else //If item does not match, increate counter
{
prodCounter++;
}
}
}
}
catch (Exception)
{
Console.WriteLine("Invalid selection. Please verify your input and try again.");
}
}
} while (true);
}
else if ((userInput.ToLower() == "remove item") || (userInput.ToLower() == "removeitem")) //User input: Remove Item from order
{
if (orderLineItems.Count() == 0) //Order is empty
{
Console.WriteLine("No items currently contained within order.");
}
else //Order contains elements available to be removed
{
Console.WriteLine("Items currently in order: ");
//Iterate through, writing out elements in order
for (int i = 0; i < orderLineItems.Count(); i++)
{
Console.WriteLine($"{i+1}: {orderLineItems[i].Quantity} units of {orderLineItems[i].LineItemProduct.ProductName}");
}
//Lock in to input loop until completed or backed out of
do
{
Console.Write("Please enter the number of the item you would like to remove, or \"Go Back\" to return to order menu: ");
userInput = input.GetInput();
if ((userInput.ToLower() == "go back") || (userInput.ToLower() == "goback")) //Return to top menu
{
goto ActionComplete;
}
else //Enter an item to remove
{
try
{
var userLineChoice = int.Parse(userInput); //Parse user input to integer
if ((userLineChoice < 1) || (userLineChoice > orderLineItems.Count())) //Verify user input is in range
{
throw new ArgumentOutOfRangeException(); //pre-emptively throw exception
}
else //Valid user input
{
orderLineItems.Remove(orderLineItems[userLineChoice - 1]); //Remove line item from order
//Wait for user input
Console.WriteLine("Item removed. Press enter to continue...");
input.GetInput();
goto ActionComplete;
}
}
catch (Exception) //Catch invalid input
{
Console.WriteLine("Invalid selection. Please verify your input and try again.");
}
}
} while (true);
}
break;
}
else if ((userInput.ToLower() == "view order") || (userInput.ToLower() == "vieworder")) //User input: View order
{
if (orderLineItems.Count() == 0) //Order empty
{
Console.WriteLine("No items currently contained within order.");
}
else //Order has contents to view
{
Console.WriteLine("Items currently in order: ");
//iterate through list of line items, printing them to console
for (int i = 0; i < orderLineItems.Count(); i++)
{
Console.WriteLine($"{i + 1}: {orderLineItems[i].Quantity} units of {orderLineItems[i].LineItemProduct.ProductName}");
}
}
//Wait for user input before exiting
Console.WriteLine("Press enter to continue...");
input.GetInput();
goto ActionComplete;
}
else if ((userInput.ToLower() == "check out") || (userInput.ToLower() == "checkout")) //User input: Check Out order
{
Console.WriteLine("Check out order:");
if (orderLineItems.Count() == 0) //order is empty
{
Console.WriteLine("The order is empty. The existing order will be closed, with no action taken.");
}
else //Order has content to submit to database
{
//Complete Order object, then add to database
currentOrder.OrderDate = DateTime.Now;
db.Add(currentOrder);
db.SaveChanges();
//Iterate through Line Items, adding them to database
foreach (var line in orderLineItems)
{
db.Add(line);
}
db.SaveChanges();
//Iterate through inventory reference, updating database
foreach (var stock in inv)
{
db.Update(stock);
}
db.SaveChanges();
Console.WriteLine("Order successfully submitted!");
}
//Return out of method on order submission, successful or not
Console.Write("\nPress enter to continue when you are finished with this order: ");
userInput = input.GetInput();
return;
}
else //Command not recognized as valid
{
Console.WriteLine("Invalid command. Please verify your input and try again.");
}
} while (true);
ActionComplete :; // Provides a consistent exit location after each action is completed, to smooth the order loop
} while (true);
}
}
catch (ArgumentOutOfRangeException) //Invalid location input
{
Console.WriteLine("Please select a valid location number.");
}
catch (Exception e) //Catch any other exceptions that slip through, writing to console
{
Console.WriteLine("Error: please check your input, and try again.");
Console.WriteLine(e);
}
}
} while (true);
}