public void Insert(IEnumerable <EventClasses.Event> eventsList) { var parsedList = ParseToDbEventList(eventsList); using (ItEventsParserDbContext context = new ItEventsParserDbContext()) { if (!(context.Events.Any())) { foreach (var item in parsedList) { item.HasSentEmail = "Yes"; context.Events.Add(item); context.SaveChanges(); } } else { foreach (var item in parsedList) { if (!(context.Events.Any(obj => obj.Name == item.Name && obj.Link == item.Link))) { context.Events.Add(item); context.SaveChanges(); } } } } }
public void UpdateEvent(int dbEventId, DB.Events newEvent) { using (ItEventsParserDbContext context = new ItEventsParserDbContext()) { if (context.Events.Any()) { var dep = context.Events.First(item => item.id == dbEventId); if (newEvent.Name != null) { dep.Name = newEvent.Name; } if (newEvent.City != null) { dep.City = newEvent.City; } if (newEvent.Date != null) { dep.Date = newEvent.Date; } if (newEvent.Description != null) { dep.Description = newEvent.Description; } if (newEvent.Link != null) { dep.Link = newEvent.Link; } if (newEvent.HasSentEmail != null) { dep.HasSentEmail = newEvent.HasSentEmail; } context.SaveChanges(); } } }
public void DeleteSingle(string name) { using (ItEventsParserDbContext context = new ItEventsParserDbContext()) { if (context.Events.Any()) { DB.Events db = new DB.Events() { Name = name }; context.Events.Attach(db); context.Events.Remove(db); context.SaveChanges(); } } }
public void DeleteSingle(int id) { using (ItEventsParserDbContext context = new ItEventsParserDbContext()) { if (context.Events.Any()) { DB.Events db = new DB.Events() { id = id }; context.Events.Attach(db); context.Events.Remove(db); context.SaveChanges(); } } }