// 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()); }