public StorageViewModel(Services.IStorageServiceFactory storageServiceFactory)
{
_sampleStorage = storageServiceFactory.getStorageForEntity<DB.Sample>();
_sampleStorage.DeleteAll();
_sampleStorage.Insert(new DB.Sample() { Name = "Granat" } );
_sampleStorage.Insert(new DB.Sample() { Name = "Jablko" } );
_sampleStorage.Insert(new DB.Sample() { Name = "Granat" } );
_sampleStorage.Insert(new DB.Sample() { Name = "Hruska" } );
_sampleStorage.Insert(new DB.Sample() { Name = "Granat" } );
// get all items in DB
string query1 = "SELECT * FROM {0}";
List<DB.Sample> list1 = _sampleStorage.QueryItems(query1, new object[] { _sampleStorage.getTableName() });
OriginalItems = new List<string>();
foreach (DB.Sample sample in list1)
{
OriginalItems.Add(sample.Name);
};
// get items in DB with name = Granat
string query2 = "SELECT * FROM {0} WHERE NAME = \"{1}\"";
List <DB.Sample> list2 = _sampleStorage.QueryItems(query2, new object[] { _sampleStorage.getTableName() , "Granat" });
FilteredItems = new List<string>();
foreach (DB.Sample sample in list2) {
FilteredItems.Add(sample.Name);
};
}
public StorageViewModel(Services.IStorageServiceFactory storageServiceFactory)
{
_sampleStorage = storageServiceFactory.getStorageForEntity <DB.Sample>();
_sampleStorage.DeleteAll();
_sampleStorage.Insert(new DB.Sample()
{
Name = "Granat"
});
_sampleStorage.Insert(new DB.Sample()
{
Name = "Jablko"
});
_sampleStorage.Insert(new DB.Sample()
{
Name = "Granat"
});
_sampleStorage.Insert(new DB.Sample()
{
Name = "Hruska"
});
_sampleStorage.Insert(new DB.Sample()
{
Name = "Granat"
});
// get all items in DB
string query1 = "SELECT * FROM {0}";
List <DB.Sample> list1 = _sampleStorage.QueryItems(query1, new object[] { _sampleStorage.getTableName() });
OriginalItems = new List <string>();
foreach (DB.Sample sample in list1)
{
OriginalItems.Add(sample.Name);
}
;
// get items in DB with name = Granat
string query2 = "SELECT * FROM {0} WHERE NAME = \"{1}\"";
List <DB.Sample> list2 = _sampleStorage.QueryItems(query2, new object[] { _sampleStorage.getTableName(), "Granat" });
FilteredItems = new List <string>();
foreach (DB.Sample sample in list2)
{
FilteredItems.Add(sample.Name);
}
;
}
