public User Get(int id) { using (var ctx = new CalendarEntities()) { return(ctx.Users.Where(e => e.Id == id).FirstOrDefault <User>()); } }
public Event Get(int id) { using (var ctx = new CalendarEntities()) { return(ctx.Events.Where(e => e.Id == id).FirstOrDefault <Event>()); } }
public void Remove(int id) { using (var ctx = new CalendarEntities()) { var item = ctx.Users.Where(e => e.Id == id).FirstOrDefault <User>(); ctx.Entry(item).State = System.Data.Entity.EntityState.Deleted; ctx.SaveChanges(); } }
public IEnumerable <User> GetAll() { IEnumerable <User> users = null; using (var ctx = new CalendarEntities()) { users = ctx.Users.ToList <User>().AsEnumerable(); } return(users); }
public IEnumerable <Event> GetAll() { IEnumerable <Event> events = null; using (var ctx = new CalendarEntities()) { events = ctx.Events.ToList <Event>().AsEnumerable(); } return(events); }
public User Add(User item) { if (item == null) { throw new ArgumentNullException("item"); } using (var ctx = new CalendarEntities()) { item = ctx.Users.Add(new User() { View = item.View }); ctx.SaveChanges(); } return(item); }
public bool Update(User item) { if (item == null) { throw new ArgumentNullException("item"); } using (var ctx = new CalendarEntities()) { var existingItem = ctx.Users.Where(e => e.Id == item.Id).FirstOrDefault <User>(); if (existingItem == null) { return(false); } existingItem.View = item.View; ctx.SaveChanges(); } return(true); }
public Event Add(Event item) { if (item == null) { throw new ArgumentNullException("item"); } using (var ctx = new CalendarEntities()) { item = ctx.Events.Add(new Event() { Title = item.Title, Start = item.Start, End = item.End, AllDay = item.AllDay, Resource = item.Resource }); ctx.SaveChanges(); } return(item); }
public bool Update(Event item) { if (item == null) { throw new ArgumentNullException("item"); } using (var ctx = new CalendarEntities()) { var existingItem = ctx.Events.Where(e => e.Id == item.Id).FirstOrDefault <Event>(); if (existingItem == null) { return(false); } existingItem.Title = item.Title; existingItem.Start = item.Start; existingItem.End = item.End; existingItem.AllDay = item.AllDay; existingItem.Resource = item.Resource; ctx.SaveChanges(); } return(true); }