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 UploadNarrativeMessage()
{
SQLAccess db = new SQLAccess();
db.Procedure = "InsertNarrativeMessage";
db.Parameters.Add(@"@contents", Contents);
db.Parameters.Add(@"@created", Created);
db.Parameters.Add(@"@guid", Guid);
db.Parameters.Add(@"@errors", HasErrors);
db.Parameters.Add(@"@narrative_id", NarrativeId);
db.ExecuteProcedure();
}
public override void PopulateContents()
{
SQLAccess db = new SQLAccess();
db.Procedure = "GetPeople";
db.ExecuteProcedure();
if (db.HasData)
{
foreach (DataRow person in db.Response.Rows)
{
this.Contents.Add(new Person(person));
}
}
}
private void RetreiveId()
{
SQLAccess db = new SQLAccess();
db.Procedure = "GetNarrativeObjectId";
db.Parameters.Add(@"@guid", Guid);
db.Parameters.Add(@"scan_object_id", ScanObject.Id);
db.ExecuteProcedure();
if (db.HasData)
Id = (long)db.Response.Rows[0][0];
}
public void Insert()
{
SQLAccess db = new SQLAccess();
db.Procedure = "InsertNarrativeObject";
db.Parameters.Add(@"@guid", Guid);
db.Parameters.Add(@"scan_object_id", ScanObject.Id);
db.Parameters.Add(@"created", Created);
db.ExecuteProcedure();
}
internal void Insert()
{
SQLAccess db = new SQLAccess();
db.Procedure = "InsertScanObject";
db.Parameters.Add(@"@name", Name);
db.Parameters.Add(@"@description", Description);
db.Parameters.Add(@"@url", Url);
db.Parameters.Add(@"@page_status", PageStatus);
db.Parameters.Add(@"@page_source", PageSource);
db.Parameters.Add(@"@crawl_depth", CrawlDepth);
db.Parameters.Add(@"@screenshot", screenshot);
db.Parameters.Add(@"@parent_id", ParentId);
db.Parameters.Add(@"@guid", Guid);
db.ExecuteProcedure();
}
internal ScanObject GetNext()
{
SQLAccess db = new SQLAccess();
db.Procedure = "NextScanObject";
db.ExecuteProcedure();
if (db.HasData)
return new ScanObject(db.Response.Rows[0]);
else return new ScanObject();
}
public void Update()
{
SQLAccess db = new SQLAccess();
db.Procedure = "UpdateScanObject";
db.Parameters.Add(@"@id", Id);
db.Parameters.Add(@"@name", Name);
db.Parameters.Add(@"@description", Description);
db.Parameters.Add(@"@url", Url);
db.Parameters.Add(@"@page_status", PageStatus);
db.Parameters.Add(@"@page_source", PageSource);
db.Parameters.Add(@"@crawl_depth", CrawlDepth);
//db.Parameters.Add(@"@screenshot", screenshot);
db.Parameters.Add(@"@parent_id", ParentId);
db.ExecuteProcedure();
}
public ScanObject FindById(long id)
{
SQLAccess db = new SQLAccess();
db.Procedure = "ScanObjectById";
db.Parameters.Add(@"@id", id);
db.ExecuteProcedure();
if (db.HasData)
return new ScanObject(db.Response.Rows[0]);
else return new ScanObject();
}
