public static List<Event> GetList() { using (var db = new CalendarContext()) { return db.Events.ToList(); } }
public static void DeleteEvent(Event eventToDelete) { using (var db = new CalendarContext()) { var currentEvent = db.Events.FirstOrDefault(e => e.Id == eventToDelete.Id); db.Events.Remove(currentEvent); db.SaveChanges(); } }
public static Event AddEvent(Event newEvent) { using (var db = new CalendarContext()) { var book = db.Events.Add(newEvent); db.SaveChanges(); return book; } }
public static bool IsDatesExist(DateTime from, DateTime to, int? eventId) { using (var db = new CalendarContext()) { return db.Events .Where(e => !eventId.HasValue || e.Id != eventId.Value) .Any(e => (from >= e.StartDate && from <= e.EndDate) || (to >= e.StartDate && to <= e.EndDate) || (from <= e.StartDate && to >= e.EndDate)); } }
public static Event UpdateEvent(Event newEvent) { using (var db = new CalendarContext()) { var currentEvent = db.Events.FirstOrDefault(e => e.Id == newEvent.Id); currentEvent.Name = newEvent.Name; currentEvent.StartDate = newEvent.StartDate; currentEvent.EndDate = newEvent.EndDate; db.SaveChanges(); return currentEvent; } }