/// <summary>
/// Initializes a new instance of the <see cref="T:SiaqodbMVVM.SiaqoDbManager"/> class.
/// </summary>
/// <param name="database">Database.</param>
public SiaqoDbManager(string database = "DEFAULTDB")
{
siaqodb = DependencyService.Get <ISiaqo>().GetInstance(database);
//Getting the count of a type in the database..
if (siaqodb.LoadAll <TaskItem>().Count() < 1)
{
LoadInitialData();
}
}
private void LoadAndUpdate()
{
var query = from Company comp in siaqodb
where comp.Name.StartsWith("First")
select comp;
//Following companies has name that starts with 'First' string
foreach (var e in query)
{
e.Address = "Address changed";
siaqodb.StoreObject(e);//update will occur
}
siaqodb.Flush();
//load all objects of type Company from DB
IObjectList <Company> allCompanies = siaqodb.LoadAll <Company>();
foreach (Company comp in allCompanies)
{
//see address of FirstCompany is updated
}
}
/// <summary>
/// Gets all the tasks.
/// </summary>
/// <returns>The tasks.</returns>
public List <TaskItem> GetTasks()
{
var tmp = siaqodb.LoadAll <TaskItem>().ToList();
return(tmp);
}