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); } } }