// exhibition table insert/update public async Task InsertOrUpdateTableAsyncExhibition(Exhibition ex) { ExhibitionL exhibitionL = new ExhibitionL(); SQLiteDB db = new SQLiteDB(); List <Exhibition> edb = new List <Exhibition>(); edb = db.GetItemAsyncExhibition().Result; exhibitionL.Exhibition_QRCode_Pos = ex.Exhibition_QRCode_Pos; exhibitionL.Exhibition_Description = ex.Exhibition_Description; exhibitionL.Exhibition_IMG_Name = ex.Exhibition_IMG_Name; exhibitionL.Exhibition_IMG = ex.Exhibition_IMG; exhibitionL.Exhibition_Video_Name = ex.Exhibition_Video_Name; exhibitionL.Exhibition_Video = ex.Exhibition_Video; exhibitionL.Exhibition_Name = ex.Exhibition_Name; exhibitionL.QRCodes_Name = ex.QRCodes_Name; bool dupe = false; //check for duplicates foreach (var a in edb) { if ((a.Exhibition_Description == ex.Exhibition_Description) && (a.Exhibition_IMG == ex.Exhibition_IMG) && (a.Exhibition_Name == ex.Exhibition_Name) && (a.Exhibition_Video == ex.Exhibition_Video) && (a.Exhibition_IMG_Name == ex.Exhibition_IMG_Name) && (a.Exhibition_QRCode_Pos == ex.Exhibition_QRCode_Pos) && (a.Exhibition_Video_Name == ex.Exhibition_Video_Name) && (a.QRCodes_Name == ex.QRCodes_Name)) { dupe = true; } } //update/insert if not a duplicate if (dupe == false) { if (exhibitionL.Exhibition_ID != 0) { await CreateConnection().UpdateAsync(exhibitionL); } else { await CreateConnection().InsertAsync(exhibitionL); } } }
// exhibition table insert/update public async Task InsertOrUpdateTableAsyncExhibition(Exhibition ex) { ExhibitionL exhibitionL = new ExhibitionL(); exhibitionL.Exhibition_QRCode_Pos = ex.Exhibition_QRCode_Pos; exhibitionL.Exhibition_Description = ex.Exhibition_Description; exhibitionL.Exhibition_IMG_Name = ex.Exhibition_IMG_Name; exhibitionL.Exhibition_IMG = ex.Exhibition_IMG; exhibitionL.Exhibition_Video_Name = ex.Exhibition_Video_Name; exhibitionL.Exhibition_Video = ex.Exhibition_Video; exhibitionL.Exhibition_Name = ex.Exhibition_Name; exhibitionL.QRCodes_Name = ex.QRCodes_Name; if (exhibitionL.Exhibition_ID != 0) { await CreateConnection().UpdateAsync(exhibitionL); } else { await CreateConnection().InsertAsync(exhibitionL); } }