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