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