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 string ReadSingle(int id)
{
using (ItEventsParserDbContext context = new ItEventsParserDbContext())
{
if (context.Events.Any())
{
var ptx = context.Events.Find(id);
return($" name: {ptx.Name} \n date: {ptx.Date} \n desc: {ptx.Description} \n link: {ptx.Link} \n city: {ptx.City} \n sent: {ptx.HasSentEmail}");
}
else
{
return("Table is empty");
}
}
}
public IEnumerable <DB.Events> ReadAllToList()
{
using (ItEventsParserDbContext context = new ItEventsParserDbContext())
{
if (context.Events.Any())
{
var ptx = (from r in context.Events select r);
var newList = ptx.ToList <DB.Events>();
return(newList);
}
else
{
throw new ArgumentException("Table is empty");
}
}
}
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();
}
}
}
