public static void AddDetail(string firstName, string lastName)
{
using (var context = new FinalExamEntities())
{
var query = from user in context.Customers
where user.CustFirstName == firstName
select user.CustNum;
int id = query.FirstOrDefault();
string username = lastName;
string password = CreatePassword(firstName, lastName);
Customer_Detail newDet = new Customer_Detail()
{
CustNum = id,
CustUserName = username,
CustPassword = password
};
context.Customer_Detail.Add(newDet);
context.SaveChanges();
Console.WriteLine($"Your username is {username}");
Console.WriteLine($"Your password is {password}");
}
}
public static void ValidateQuantity(int quantity, string itemChoice, int id)
{
if (quantity > 0)
{
using (var context = new FinalExamEntities())
{
var result = context.Products.Where(item => item.Descr == itemChoice).Select(item => item.Onhand).FirstOrDefault();
if (result >= quantity)
{
//insert record in Sales
Sale.NewSale(id);
//insert record in SalesInvoice
SalesInvoice.NewSaleInvoice(id, quantity, itemChoice);
//reduce onhand by quantity purchased
var prod = context.Products.Where(item => item.Descr == itemChoice).FirstOrDefault <Product>();
prod.Onhand = prod.Onhand - quantity;
context.SaveChanges();
Console.WriteLine("Thank you for your purchase!");
}
else
{
Console.WriteLine("Sorry, not enough stock.");
}
}
}
else
{
Console.WriteLine("Sorry, quantity must be greater than 0.");
}
}
public static void DisplayPrice(string productSelection)
{
using (var context = new FinalExamEntities())
{
var result = context.Products.Where(item => item.Descr == productSelection).Select(item => item.MSRP).Distinct();
foreach (var item in result)
{
Console.WriteLine($"{productSelection}: {item}");
}
}
}
public static int GetId(string username)
{
using (var context = new FinalExamEntities())
{
var query = from user in context.Customer_Detail
where user.CustUserName == username
select user.CustNum;
int id = query.FirstOrDefault();
return(id);
}
}
public static void ProductsAvailable(string prodType)
{
using (var context = new FinalExamEntities())
{
var result = context.Products.Where(item => item.ProductType == prodType).Select(item => item.Descr).Distinct();
int i = 1;
foreach (var item in result)
{
Console.WriteLine($"{i}: {item}");
i++;
}
}
}
public static void GetProductTypes()
{
using (var context = new FinalExamEntities())
{
var result = context.Products.Select(item => item.ProductType).Distinct();
int i = 1;
foreach (var item in result)
{
Console.WriteLine($"{i}: {item}");
i++;
}
}
}
public static Boolean IsCheckCredentials(string username, string password)
{
using (var context = new FinalExamEntities())
{
var query = context.Customer_Detail.Where(user => user.CustUserName == username).FirstOrDefault <Customer_Detail>();
var query2 = context.Customer_Detail.Where(user => user.CustPassword == password).FirstOrDefault <Customer_Detail>();
if (query != null && query2 != null)
{
return(true);
}
else
{
return(false);
}
}
}
public static void NewSaleInvoice(int id, int quantity, string desc)
{
using (var context = new FinalExamEntities())
{
var salesNum = context.Sales.Where(user => user.CustNum == id).Select(user => user.SalesNum).FirstOrDefault();
var prodNum = context.Products.Where(user => user.Descr == desc).Select(user => user.ProductNum).FirstOrDefault();
var price = context.Products.Where(user => user.Descr == desc).Select(user => user.MSRP).FirstOrDefault();
SalesInvoice invoice = new SalesInvoice()
{
SalesNum = salesNum,
ProductNum = prodNum,
Quantity = quantity,
SalesPrice = price * quantity
};
context.SalesInvoices.Add(invoice);
context.SaveChanges();
}
}
