ObservableCollection <Resource> GetResources()
{
Resource grr = new Resource(0, 0, "Some group", "This is the group for my tools", 0, false, 0, null, true, "13/15/13", this);
grr.AddResource(new Resource(0, 0, "Laceses", "This is the laces I will be using for Abbot work", 80, false, 0, null, false, "13/13/13", this));
grr.AddResource(new Resource(0, 0, "Miscal", "This is the laces I will be using for Abbot work", 34, true, 0, null, false, "13/13/13", this));
Resource re = new Resource(0, 0, "Done good with this", "This one's got transactions!", 100, false, 0, null, false, "9:11, 9 November, 2016", this);
re.AddTransaction(new Transaction(0, 0, true, 20, re, "Took these for your dad..", "13/12/11", "hahahah"));
re.AddTransaction(new Transaction(0, 0, false, 5, re, "Took these for your mum..", "15/12/11", "hahahah"));
re.AddTransaction(new Transaction(0, 0, true, 10, re, "Took these for your brother..", "13/12/11", "hahahah"));
re.AddTransaction(new Transaction(0, 0, false, 8, re, "Took these for your sister..", "13/12/11", "hahahah"));
ObservableCollection <Resource> resourcess = new ObservableCollection <Resource>
{
new Resource(0, 0, "Laces", "This is the laces I will be using for Abbot work", 100, false, 0, null, false, "13/13/13", this),
grr,
new Resource(0, 0, "Threads", "This is for sewing", 100, false, 0, null, false, "13/13/13", this),
re
};
DatabaseHandler db = new DatabaseHandler(this);
resources = db.GetResources();
db.Close();
topResources = resources;
if (resources.Count == 0)
{
NoResources(true);
}
else
{
NoResources(false);
}
return(resources);
}
public void AddTransaction(int amount, bool isRemoval, string comment)
{
DatabaseHandler db = new DatabaseHandler(this);
db.Open();
lastSelected.AddTransaction(db.AddTransaction(isRemoval, amount, comment, lastSelected));
db.Close();
}
void PopulateResource(Resource res)
{
if (res.IsGroup)
{
string query = $"select * from {RES_TABLE_NAME} where {COLUMN_PAR_ID} = {res.Id} order by {COLUMN_PINNED_DATE} desc";
SqlCeDataReader reader = ExecuteQuery(query);
while (reader.Read())
{
Resource resource = ReaderToResource(reader);
PopulateResource(resource);
res.AddResource(resource);
}
}
else
{
string query = $"select * from {TRANS_TABLE_NAME} where {COLUMN_PAR_ID} = {res.Id}";
SqlCeDataReader reader = ExecuteQuery(query);
while (reader.Read())
{
Transaction transaction = ReaderToTransaction(reader, res);
res.AddTransaction(transaction);
}
}
}
