public List <Cust> findUser()
{
DbStoreContext db = new DbStoreContext();// set up dbcontext
Cust findUser = new Cust();
while (true)
{
//prompts user to enter first name
Console.WriteLine("Enter your first name");
test = Console.ReadLine();
//checks to make sure input is valid
if (Regex.IsMatch(test, regNameTest))
{
break;
}
Console.WriteLine("Invalid input. Please use letters only for this field.");
}
//adds first name to user
findUser.Fname = test;
while (true)
{
//prompts user to enter last name
Console.WriteLine($"Hi, {newUser.Fname}! Please enter your last name");
test = Console.ReadLine();
//checks input
if (Regex.IsMatch(test, regNameTest))
{
break;
}
Console.WriteLine("Invalid input. Please use letters only for this field.");
}
//adds Last name
findUser.Lname = test;
var searchResults = db.Cust.Where(cust => cust.Fname == findUser.Fname && cust.Lname == findUser.Lname).ToList();
return(searchResults);
}
public List <Order> findUserOrderHistory()
{
DbStoreContext db = new DbStoreContext();// set up dbcontext
Cust find = new Cust();
while (true)
{
//prompts user to enter id
Console.WriteLine("Enter User ID");
test = Console.ReadLine();
//checks to make sure input is valid
if (Regex.IsMatch(test, idTest))
{
break;
}
Console.WriteLine("Invalid input. Please use numbers only for this field.");
}
//adds id to user
find.CustId = int.Parse(test);
//get query results
var searchResults = db.Order.Where(ord => ord.CustId == find.CustId).ToList();
return(searchResults);
}
public void runStore()
{
DbStoreContext db = new DbStoreContext(); // set up dbcontext
bool broken = true; // bool to get us out of loop
ConsoleKey input; // intial console key
//Menu options
string[] menu = new string[] { "Create new order", "Create new user",
"Search User by name", "Look up your Order history", "Update inventory",
"Create new product", "Look up location order history", "Exit Program" };
Console.WriteLine("Welcome to the Outdoor Store");
do
{
//loop through menu options
for (int i = 0; i < menu.Length; i++)
{
int num = i + 1;
Console.WriteLine(num + " " + menu[i]);
}
input = Console.ReadKey().Key;
//Create Order
if (input == ConsoleKey.D1)
{ //initialize order
Order newOrder = createOrder();
//check that it is not null
if (newOrder == null)
{
Console.WriteLine();
Console.WriteLine($"Order cancelled.");
}
else if (newOrder != null)
{// Add new Order to the db
newOrder.OrderTime = DateTime.Now;
db.Add(newOrder);
db.SaveChanges();
Console.WriteLine();
Console.WriteLine($"Order added as order {newOrder.OrderID}");
}
}
//Create user
else if (input == ConsoleKey.D2)
{
newUser = createNewUser();
Console.WriteLine("Her is you User ID: " + newUser.CustId);
}
//User search
else if (input == ConsoleKey.D3)
{
List <Cust> searchResults = findUser();
if (searchResults.Count >= 1)
{
foreach (Cust p in searchResults)
{
//Print results
p.PrintUserInfo();
}
}
else
{
Console.WriteLine("Loooks like nothing came up." +
" Try to create a new user!");
Console.WriteLine();
}
}
//Location search
else if (input == ConsoleKey.D4)
{
List <Order> searchResults = findUserOrderHistory();
if (searchResults.Count >= 1)
{
//loop through to include product name
for (int i = 0; i < searchResults.Count; i++)
{
List <Product> hold = db.Product.Where(prod => prod.ProductID == searchResults[i].Productid).ToList();
Console.WriteLine(searchResults[i].ToString() + hold[i].Name);
}
}
else
{
Console.WriteLine("Loooks like nothing came up." +
" Try to create a new Order!");
Console.WriteLine();
}
}
//Adjust inventory
else if (input == ConsoleKey.D5)
{
adjustInventory();
//Update inventory
}
//create new Product
else if (input == ConsoleKey.D6)
{
createProduct();
}
//StoreLocation order history
else if (input == ConsoleKey.D7)
{
List <Order> searchResults = findLocalOrderHistory();
if (searchResults.Count >= 1)
{
//loops through to print out product names
for (int i = 0; i < searchResults.Count; i++)
{
List <Product> hold = db.Product.Where(prod => prod.ProductID == searchResults[i].Productid).ToList();
Console.WriteLine(searchResults[i].ToString() + hold[i].Name);
}
}
else
{
Console.WriteLine("Loooks like nothing came up." +
" Try to create a new order!");
Console.WriteLine();
}
}
//exit the loop
else if (input == ConsoleKey.D8)
{
broken = false;
Console.WriteLine();
Console.WriteLine(broken);
}
else
{
Console.WriteLine(broken);
Console.WriteLine("Whoops. Please press a valid key");
}
} while (broken == true);
}