// events table insert/update data
public async Task InsertOrUpdateTableAsyncEvents(Events e)
{
EventsL eventsL = new EventsL();
SQLiteDB db = new SQLiteDB();
List <Events> edb = new List <Events>();
edb = db.GetItemAsyncEvents().Result;
eventsL.Event_Name = e.Event_Name;
eventsL.Event_Description = e.Event_Description;
eventsL.Event_IMG = e.Event_IMG;
eventsL.Event_Location = e.Event_Location;
eventsL.Event_Day = e.Event_Day;
eventsL.Event_Time = e.Event_Time;
bool dupe = false;
//check for duplicates
foreach (var a in edb)
{
if ((a.Event_Day == e.Event_Day) && (a.Event_IMG == e.Event_IMG) && (a.Event_Name == e.Event_Name) &&
(a.Event_Time == e.Event_Time) && (a.Event_Location == e.Event_Location) &&
(a.Event_Description == e.Event_Description))
{
dupe = true;
}
}
//update/insert if not a duplicate
if (dupe == false)
{
if (eventsL.Events_ID != 0)
{
await CreateConnection().UpdateAsync(eventsL);
}
else
{
await CreateConnection().InsertAsync(eventsL);
}
}
}
async Task <List <DBs.FAQ> > GetDB()
{
SQLiteDB dbcon = new SQLiteDB();
return(await dbcon.GetItemAsyncFAQ());
}
