public void AddSpecialEvent(SpecialEvent Item)
{
using (var context = new RestarauntContext())
{
//add item to the dbContext
var added = context.SpecialEvents.Add(Item);
//we arent going to do anything with the variable 'added' Just be aware that Add() method will return the newly added object.
//This can be useful in other situations
//Save changes to the database
context.SaveChanges();
}
}
public void DeleteSpecialEvent(SpecialEvent Item)
{
using (var context = new RestarauntContext())
{
//first get a reference to the actual item in the db
//find() is a method to lookup an item by its primary key
var existing = context.SpecialEvents.Find(Item.EventCode);
//second remove the item from the database context
context.SpecialEvents.Remove(existing);
//lastly, save changes
context.SaveChanges();
}
}
public void UpdateSpecialEvent(SpecialEvent Item)
{
using (RestarauntContext context = new RestarauntContext())
{
//first attach the item to the dbContext collection
var attached = context.SpecialEvents.Attach(Item);
//second, get the entry for the existing data that should match for this specific special event
var existing = context.Entry<SpecialEvent>(attached);
//third, mark that the objects values have changed
existing.State = System.Data.Entity.EntityState.Modified;
//lastly, save changes
context.SaveChanges();
}
}