/// <summary>
/// Updates the invoice.
/// </summary>
/// <param name="i">Invoice to be updated.</param>
public static void Update(Invoice i)
{
using (LumberContext context = new LumberContext())
{
context.Entry(i).State = EntityState.Modified;
context.SaveChanges();
}
}
/// <summary>
/// Adds an invoice line item to the database.
/// </summary>
/// <param name="invoiceLineItems">Invoice line item to be added.</param>
public static void AddInvoiceLineItem(InvoiceLineItems invoiceLineItems)
{
using (LumberContext context = new LumberContext())
{
context.InvoiceLineItems.Add(invoiceLineItems);
context.SaveChanges();
}
}
/// <summary>
/// Updates an individual unit of lumber.
/// </summary>
/// <param name="p">The product.</param>
public static Product Update(Product p)
{
using (LumberContext context = new LumberContext())
{
context.Entry(p).State = EntityState.Modified;
context.SaveChanges();
return(p);
}
}
/// <summary>
/// Gets all the Invoices.
/// </summary>
/// <returns></returns>
public static List <Invoice> GetAllInvoices()
{
using (LumberContext context = new LumberContext())
{
List <Invoice> invoices = (from i in context.Invoices
select i).Include(c => c.Customers).ToList();
return(invoices);
}
}
/// <summary>
/// Grabs all customers from database.
/// </summary>
/// <returns></returns>
public static List <Customer> GetAllCustomers()
{
using (LumberContext context = new LumberContext())
{
List <Customer> customers = (from c in context.Customers
select c).ToList();
return(customers);
}
}
/// <summary>
/// Adds customer to database.
/// </summary>
/// <param name="c">The customer to be added.</param>
/// <returns></returns>
public static Customer AddCustomer(Customer c)
{
using (LumberContext context = new LumberContext())
{
context.Customers.Add(c);
context.SaveChanges();
return(c);
}
}
/// <summary>
/// Adds an invoice to the database.
/// </summary>
/// <param name="i">The invoice to be added.</param>
/// <returns></returns>
public static Invoice Add(Invoice i)
{
using (LumberContext context = new LumberContext())
{
context.Invoices.Add(i);
context.Customers.Attach(i.Customers[0]);
context.SaveChanges();
return(i);
}
}
/// <summary>
/// Gets all of the invoice line items.
/// </summary>
/// <param name="id">invoice line items to show.</param>
/// <returns></returns>
public static List <InvoiceLineItems> GetInvoiceQuantities(int id)
{
using (LumberContext context = new LumberContext())
{
List <InvoiceLineItems> invoiceLineItems = (from i in context.InvoiceLineItems
where i.InvoiceID == id
select i).ToList();
return(invoiceLineItems);
}
}
/// <summary>
/// Grabs a single customer from the database.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Customer GetCustomer(int id)
{
using (LumberContext context = new LumberContext())
{
Customer customer = (from c in context.Customers
where c.CustomerID == id
select c).Single();
return(customer);
}
}
/// <summary>
/// Grabs the product from an invoice.
/// </summary>
/// <param name="id">The product to show.</param>
/// <returns></returns>
public static List <Product> GetInvoiceProducts(int id)
{
using (LumberContext context = new LumberContext())
{
List <Product> products = (from p in context.Products
join i in context.InvoiceLineItems on p.ProductID equals i.ProductID
where i.InvoiceID == id
select p).Include(c => c.Category).ToList();
return(products);
}
}
/// <summary>
/// Grabs a single category
/// </summary>
/// <param name="id">The Id for the category</param>
/// <returns></returns>
public static Category GetCategory(int id)
{
using (LumberContext context = new LumberContext())
{
Category category =
(from c in context.Categories
where c.CategoryID == id
select c).Single();
return(category);
}
}
/// <summary>
/// Grabs all products that are <= to the current product.
/// </summary>
/// <param name="height">Height of the board</param>
/// <param name="width">Width of the board</param>
/// <param name="length">Length of the board</param>
public static List <Product> GetProductsInRange(int id, int height, int width, int length)
{
using (LumberContext context = new LumberContext())
{
List <Product> allProducts =
(from p in context.Products
where p.Height <= height && p.Width <= width && p.Length <= length && p.ProductID != id
orderby p.Height, p.Width, p.Length
select p).ToList();
return(allProducts);
}
}
/// <summary>
/// Deletes a unit of lumber.
/// </summary>
/// <param name="id">id of the product.</param>
public static void Delete(int id)
{
using (LumberContext context = new LumberContext())
{
Product prodToDelete =
(from p in context.Products
where p.ProductID == id
select p).Single();
context.Entry(prodToDelete).State = EntityState.Deleted;
context.SaveChanges();
}
}
/// <summary>
/// This method adds the product to the database.
/// </summary>
/// <param name="p">The product to be added.</param>
/// <returns></returns>
public static Product Add(Product p)
{
using (LumberContext context = new LumberContext())
{
context.Products.Add(p);
for (int i = 0; i < p.Category.Count; i++)
{
context.Categories.Attach(p.Category[i]);
}
context.SaveChanges();
return(p);
}
}
/// <summary>
/// Selects all products from the product table.
/// </summary>
/// <returns></returns>
public static List <Product> GetAllProducts()
{
using (LumberContext context = new LumberContext())
{
List <Product> allProducts =
(from p in context.Products
select p).Include(nameof(Product.Category)).ToList();
allProducts = allProducts.OrderBy(p => p.Height)
.ThenBy(p => p.Width)
.ThenBy(p => p.Length)
.ThenBy(p => p.Category[0].CategoryName).ToList();
return(allProducts);
}
}
/// <summary>
/// Checks to see if product already exists in database.
/// </summary>
/// <param name="p">The product to be checked.</param>
/// <returns></returns>
public static bool CheckForExistingProduct(Product p)
{
using (LumberContext context = new LumberContext())
{
List <Product> product = (from prod in context.Products
where prod.Height == p.Height && prod.Width == p.Width &&
prod.Length == p.Length
select prod).Include(c => c.Category).ToList();
for (int i = 0; i < product.Count; i++)
{
for (int j = 0; j < p.Category.Count && product[i].Category.Count == p.Category.Count; j++)
{
if (product[i].Category[j].CategoryID == p.Category[j].CategoryID)
{
return(true);
}
}
}
return(false);
}
}
