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 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 NewCustomer(string firstName, string lastName, string city, decimal creditLimit)
{
using (var context = new FinalExamEntities())
{
Customer cust = new Customer()
{
CustFirstName = firstName,
CustLastName = lastName,
City = city,
CreditLimit = creditLimit
};
context.Customers.Add(cust);
context.SaveChanges();
}
}
public static void NewSale(int id)
{
DateTime today = DateTime.Today;
using (var context = new FinalExamEntities())
{
Sale sale = new Sale()
{
SalesDate = today,
Filled = false,
CustNum = id
};
context.Sales.Add(sale);
context.SaveChanges();
}
}
public static void EditCity(string username, string city)
{
using (var context = new FinalExamEntities())
{
//get customer number
var query = from user in context.Customer_Detail
where user.CustUserName == username
select user.CustNum;
int id = query.FirstOrDefault();
var cust = context.Customers.Where(user => user.CustNum == id).FirstOrDefault <Customer>();
cust.City = city;
context.SaveChanges();
Console.WriteLine("City Updated.");
}
}
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();
}
}
