public SpecialEvent SpecialEventByEventCode(string eventcode)
{
using (eResturauntContext context = new eResturauntContext())
{
return(context.SpecialEvents.Find(eventcode));
}
}
public List <Reservation> ReservationbyEvent(string eventcode)
{
using (eResturauntContext context = new eResturauntContext())
{
return(context.Reservations.Where(anItem => anItem.EventCode == eventcode).ToList());
}
}
public Waiter WaiterByWaiterID(int waiterID)
{
using (eResturauntContext context = new eResturauntContext())
{
return(context.Waiters.Find(waiterID));
}
}
public List <Waiter> Waiter_List()
{
using (eResturauntContext context = new eResturauntContext())
{
return(context.Waiters.ToList());
}
}
public List <Reservation> Reservation_List()
{
//interfacing with our Context Class
using (eResturauntContext context = new eResturauntContext())
{
return(context.Reservations.ToList());
}
}
public void Waiter_Update(Waiter item)
{
using (eResturauntContext context = new eResturauntContext()){
context.Entry <Waiter>(context.Waiters.Attach(item)).State
= System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void SpecialEvents_Delete(SpecialEvent item)
{
using (eResturauntContext context = new eResturauntContext())
{
SpecialEvent existing = context.SpecialEvents.Find(item.EventCode);
context.SpecialEvents.Remove(existing);
context.SaveChanges();
}
}
public void SpecialEvents_Update(SpecialEvent item)
{
using (eResturauntContext context = new eResturauntContext())
{
context.Entry <SpecialEvent>(context.SpecialEvents.Attach(item)).State
= System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void Waiter_Delete(Waiter item)
{
using (eResturauntContext context = new eResturauntContext())
{
Waiter existing = context.Waiters.Find(item.WaiterID);
context.Waiters.Remove(existing);
context.SaveChanges();
}
}
public void Waiter_Add(Waiter item)
{
using (eResturauntContext context = new eResturauntContext())
{
Waiter added = null;
added = context.Waiters.Add(item);
context.SaveChanges();
}
}
public void SpecialEvents_Add(SpecialEvent item)
{
using (eResturauntContext context = new eResturauntContext())
{
SpecialEvent added = null;
added = context.SpecialEvents.Add(item);
// commits the add to the database
// evaluates the anotations(validations) on your entity
//[Required],[StringLength],[Range]...
context.SaveChanges();
}
}
public List <SpecialEvent> SpecialEvent_List()
{
//interfacing with our Context Class
using (eResturauntContext context = new eResturauntContext())
{
//using Context DBSet to get Entity Data
//return context.SpecialEvents.ToList();
//get a list of instancesfor entity using LINQ
var results = from item in context.SpecialEvents select item;
return(results.ToList());
}
}
public List <CategoryMenuItems> GetCategoryMenuItems()
{
using (eResturauntContext context = new eResturauntContext())
{
var results = from cat in context.MenuCategories
orderby cat.Description
select new CategoryMenuItems()
{
Description = cat.Description,
MenuItems = from item in cat.Items
where item.Active
select new MenuItem()
{
Description = item.Description,
Price = item.CurrentPrice,
Calories = item.Calories,
Comment = item.Comment
}
};
return(results.ToList());
}
}
