/// <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 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); } }