private void AddRecords()
{
SqLiteUtilities utilities;
int maxValue = 999;
utilities = new SqLiteUtilities(dbPath);
try
{
utilities.OpenConnection();
for (int i = 0; i <= maxValue; i++)
{
utilities.AddRecord("test", "person", i, "12345678901234567890123456789012345678901234567890");
}
utilities.CloseConnection();
}
catch (Exception ex)
{
var dlgException = new UIAlertView("Error",
string.Format("An error has occurred adding records: " + ex.Message),
new UIAlertViewDelegate(),
"OK");
dlgException.Show();
return;
}
var dlgAlert = new UIAlertView("Success",
string.Format("All records written to database"),
new UIAlertViewDelegate(),
"OK");
dlgAlert.Show();
return;
}
private void AddRecords()
{
var directory = DependencyService.Get<IDirectoryLocation>().Directory;
SqLiteUtilities utilities;
int maxValue = 999;
utilities = new SqLiteUtilities(directory);
try
{
utilities.OpenConnection();
for (int i = 0; i <= maxValue; i++)
{
utilities.AddRecord("test", "person", i, "12345678901234567890123456789012345678901234567890");
}
utilities.CloseConnection();
}
catch (Exception ex)
{
if (DisplayMessage != null)
{
DisplayMessage(this, new DisplayMessageEventArgs(
"Error",
string.Format("An error has occurred adding records: {0}", ex.Message)));
}
return;
}
if (DisplayMessage != null)
{
DisplayMessage(this, new DisplayMessageEventArgs(
"Success",
"All records written to database"));
}
return;
}