/// <summary> /// Adds a single event to the database /// </summary> /// <param name="sgEvent">The single event to add</param> /// <returns></returns> public static bool AddEvent(SendGridEvent sgEvent) { using(var ctx = new DataContext()) { ctx.SendGridEvents.Add(sgEvent); return ctx.SaveChanges() > 0; } }
/// <summary> /// Gets a list of events (by date descending) from the database /// </summary> /// <param name="numberToSkip">The starting record (used for paging)</param> /// <param name="numberToTake">The number of records to return (used for paging)</param> /// <returns></returns> public static List<SendGridEvent> GetEvents(int numberToSkip, int numberToTake) { using (var ctx = new DataContext()) { var ret = ctx.SendGridEvents.OrderByDescending(sgEvent => sgEvent.EventDate) .Skip(numberToSkip) .Take(numberToTake) .ToList(); return ret; } }