/// <summary>
/// Adds new product object to database
/// </summary>
/// <param name="newProduct"></param>
/// <returns></returns>
public static Products AddProduct(Products newProduct)
{
using (var context = new OurRestaurantModel())
{
context.Products.Add(newProduct);
context.SaveChanges();
return(newProduct);
}
}
/// <summary>
/// Adds new server to database
/// </summary>
/// <param name="newServer"></param>
public static Servers AddServer(Servers newServer)
{
using (var context = new OurRestaurantModel())
{
context.Servers.Add(newServer);
context.SaveChanges();
return(newServer);
}
}
/// <summary>
/// Deletes a server from the database
/// </summary>
/// <param name="server"></param>
public static bool DeleteServer(Servers server)
{
using (var context = new OurRestaurantModel())
{
context.Servers.Add(server);
context.Entry(server).State = EntityState.Deleted;
int rowsAffected = context.SaveChanges();
return(rowsAffected > 0);
}
}
/// <summary>
/// Adds a new payment to the database
/// </summary>
/// <param name="newPayment"></param>
/// <returns></returns>
public static PaymentInfo AddPayment(PaymentInfo newPayment)
{
using (var context = new OurRestaurantModel())
{
context.PaymentInfo.Add(newPayment);
context.SaveChanges();
return(newPayment);
}
}
/// <summary>
/// Adds an individual transaction to the database
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public static Transactions AddTransaction(Transactions order)
{
using (var context = new OurRestaurantModel())
{
/////////////////////////////////////
// Need to keep for tracking items ALREADY IN database
// Without this, items will be re-added to the database
// with identical rows but for the ID column
// DO NOT TAKE OUT
foreach (var item in order.Products)
{
context.Entry(item).State = EntityState.Unchanged;
}
context.Entry(order.Server).State = EntityState.Unchanged;
/////////////////////////////////////
context.Transactions.Add(order);
context.SaveChanges();
return(order);
}
}