public async Task UpdateOrAddCategoryAsync(Category s, CategoryKeepActive keepIsActive) { List <Category> results = await database.QueryAsync <Category>("select * from Category where Name='" + s.Name + "'"); Category current = results.FirstOrDefault <Category>(); if (current != null) { // If we want to retain the current IsActive flag, copy it from the current record // before doing an update. if (keepIsActive == CategoryKeepActive.Keep) { s.IsActive = current.IsActive; } await database.UpdateAsync(s); } else { await database.InsertAsync(s); } }
public async Task UpdateOrAddCategoryAsync(Category s, CategoryKeepActive keepIsActive) { List<Category> results = await database.QueryAsync<Category>("select * from Category where Name='" + s.Name + "'"); Category current = results.FirstOrDefault<Category>(); if (current != null) { // If we want to retain the current IsActive flag, copy it from the current record // before doing an update. if (keepIsActive == CategoryKeepActive.Keep) { s.IsActive = current.IsActive; } await database.UpdateAsync(s); } else { await database.InsertAsync(s); } }