internal void NavigateSelection(EntryDisplay selection) { if (!this.IsCreate) { Entry nav = new Entry(); foreach (var entry in EntryCollection) { if (entry.Id == SelectedItem.Id) { nav = entry; } } SQLAccess.Clear(); SQLAccess.Procedure = "EntryCollectionByParentId"; SQLAccess.Parameters.Add(@"@parentId", nav.ParentId); DataTable _entryCollection = SQLAccess.ExecuteProcedure(); GenerateEntrCollectionyFromDataTable(_entryCollection); GenerateDisplayCollection(EntryCollection); Navigation.NavigationService.Navigate(new NewEntryView(Navigation, this)); IsCreate = true; } else { Entry selected = new Entry(); foreach (var entry in EntryCollection) { } } }
internal void Add() { if (string.IsNullOrEmpty(Name)) { Name = Header; } string _header = Header; string _parentId = string.Empty; string _name = string.Empty; string _comment = Comment; DateTime _dateCompleted = DateTime.Now; DateCompleted = _dateCompleted; Entry tmp = null; EntryDisplay tmpDisplay = null; if (EntryCollection.Count > 0) { Header = EntryCollection[0].Header; _parentId = EntryCollection[0].ParentId; _name = EntryCollection[0].Name; tmp = new Entry(_name, _dateCompleted, _header, _comment, _parentId, Guid.NewGuid().ToString()); tmpDisplay = new EntryDisplay(_dateCompleted.ToString("MM/dd/yyyy HH:mm"), FormatHeader(_header), tmp.Id); } else { tmp = new Entry(Name, _dateCompleted, _header, _comment, model.ParentId, Guid.NewGuid().ToString()); tmpDisplay = new EntryDisplay(_dateCompleted.ToString("MM/dd/yyyy HH:mm"), FormatHeader(_header), tmp.Id); } EntryDisplayCollection.Add(tmpDisplay); EntryCollection.Add(tmp); foreach (var entry in EntryCollection) { SQLAccess.Clear(); SQLAccess.Procedure = "CreateEntry"; SQLAccess.Parameters.Add(@"@name", entry.Name); SQLAccess.Parameters.Add(@"@header", entry.Header); SQLAccess.Parameters.Add(@"@comment", entry.Comment); SQLAccess.Parameters.Add(@"@dateCompleted", entry.DateCompleted); SQLAccess.Parameters.Add(@"@parentId", entry.ParentId); SQLAccess.Parameters.Add(@"@id", entry.Id); SQLAccess.Execute(); } Clear(); }
public void Remove() { var _display = EntryDisplayCollection.Single(x => x.Completed == SelectedItem.Completed) as EntryDisplay; Entry _entry = EntryCollection.Single(x => x.Id == SelectedItem.Id) as Entry; EntryDisplayCollection.Remove(_display); EntryCollection.Remove(_entry); SelectedItem = null; //Add Removal logic to sql call SQLAccess.Clear(); SQLAccess.Procedure = "RemoveEntry"; SQLAccess.Parameters.Add(@"@id", _entry.Id); SQLAccess.Execute(); Clear(); }