public async Task<bool> Save()
{
var db = new SQLite.SQLiteAsyncConnection(app.DBPath);
int success = 0;
try
{
Account existingAccount = await (db.Table<Account>().Where(
a => a.Id == Id)).FirstOrDefaultAsync();
if (existingAccount != null)
{
existingAccount.Name = Name;
existingAccount.Description = Description;
existingAccount.CurrentBalance = CurrentBalance;
success = await db.UpdateAsync(existingAccount);
}
else
{
success = await db.InsertAsync(new Account()
{
Name = this.Name,
Description = this.Name,
Type = this.Type,
CurrentBalance = this.CurrentBalance,
DateCreated = DateTime.Now
});
}
}
catch
{
success = 0;
}
return success != 0;
}
public async Task AddCategoryAsync(Category categoryDetails)
{
if (_dbConnection != null)
{
try
{
var allCategories = from category in _dbConnection.Table <Category>() where category.CategoryName.ToLower() == categoryDetails.CategoryName.ToLower() && category.Language.ToLower() == categoryDetails.Language.ToLower() select category;
if (allCategories != null && await allCategories.CountAsync() >= 1)
{
await _dbConnection.UpdateAsync(categoryDetails);
}
else
{
await _dbConnection.InsertAsync(categoryDetails);
}
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
}
else
{
Debug.WriteLine("failed to get sqlite connection");
}
}
public async Task <bool> UpdateDBAsync(FreeDiscItemDownload freeDiscDownloader)
{
if (freeDiscDownloader == null)
{
#if DEBUG
Debug.Write("UpdateDBAsync: freeDiscDownloader == null");
#endif
return(false);
}
Debug.Write("UpdateDB: ID" + freeDiscDownloader.DBID + " Title: " + freeDiscDownloader?.Title + " Status: " + freeDiscDownloader?.ItemStatus.ToString());
if (freeDiscDownloader.DBID == 0)
{
Debug.Write("UpdateDBAsync: freeDiscDownloader.DBID == 0 !");
return(false);
}
try
{
var conn = new SQLite.SQLiteAsyncConnection(App.AppSetting.DBDownloadPath);
await conn.CreateTableAsync <FreeDiscItemDownload>();
await conn.UpdateAsync(freeDiscDownloader);
}
catch (Exception e)
{
Debug.Write("UpdateDBAsync: Update error !");
return(false);
}
return(true);
}
private async void Save_Clicked(object sender, EventArgs e)
{
// validate input
// assume that the input is in the correct format
if (string.IsNullOrWhiteSpace(firstNameInput.Text) && string.IsNullOrWhiteSpace(surnameInput.Text))
{
await DisplayAlert("Invalid contact", "Please enter the name of your contact", "OK");
return;
}
var contact = BindingContext as Contact;
if (contact.Id == 0)
{
await _connection.InsertAsync(contact);
ContactAdded?.Invoke(this, contact);
}
else
{
await _connection.UpdateAsync(contact);
ContactUpdated?.Invoke(this, contact);
}
await Navigation.PopAsync();
}
private Task <int> SaveItemAsync(DummyTable item)
{
if (item.Id != 0)
{
return(_db.UpdateAsync(item));
}
else
{
return(_db.InsertAsync(item));
}
}
public Task<int> UpdateLogAsync(Logs log)
{
return DataBase.UpdateAsync(log);
}
async public Task UpdateItem(ItemViewModel itemViewModel)
{
SQLite.SQLiteAsyncConnection context = new SQLite.SQLiteAsyncConnection(connectionString);
List<ItemViewModel> result = new List<ItemViewModel>();
Item item = await context.Table<Item>().Where(p => p.Identifier == itemViewModel.Identifier).FirstOrDefaultAsync();
item.Title = itemViewModel.Title;
item.Description = itemViewModel.Description;
item.Cost = itemViewModel.Cost;
item.Category = itemViewModel.Category;
if (item != null)
{
await context.UpdateAsync(item);
}
}
async public Task UpdateTrip(TripViewModel trip)
{
SQLite.SQLiteAsyncConnection context = new SQLite.SQLiteAsyncConnection(connectionString);
List<ItemViewModel> result = new List<ItemViewModel>();
Item item = await context.Table<Item>().Where(p => p.Identifier == trip.Identifier).FirstOrDefaultAsync();
item.Image = trip.LocalPathImage;
item.Title = trip.Title;
item.Description = trip.Description;
item.Cost = trip.Cost;
item.StartDate = trip.StartDate;
if (item != null)
{
await context.UpdateAsync(item);
}
}
private async Task addOldMessage(OldMessageSettings settings)
{
var db = new SQLite.SQLiteAsyncConnection(this.DBPath);
OldMessageSettings existingMessage;
try
{
existingMessage = await (db.Table<OldMessageSettings>().Where(m => m.ID == settings.ID).FirstAsync());
}
catch
{
existingMessage = null;
}
if (existingMessage != null)
{
existingMessage.FontSize = settings.FontSize;
existingMessage.AnimateMessage = settings.AnimateMessage;
existingMessage.Duration = settings.Duration;
existingMessage.Message = settings.Message;
existingMessage.ShowCountdown = settings.ShowCountdown;
existingMessage.Added = DateTime.Now;
int success = await db.UpdateAsync(existingMessage);
}
else
{
settings.Added = DateTime.Now;
int success = await db.InsertAsync(OldMessageSettings.CreateOldMessageSettings(settings));
}
}
public async void Update(Cliente cliente)
{
await _connection.UpdateAsync(cliente);
}
public Task <int> SaveUserAsync(User user)
{
// User.ID == 0 until database gives it an ID
return(user.ID == 0 ? _database.InsertAsync(user) : _database.UpdateAsync(user));
}
