// Key Methods
public int CreateNewKey(int RecordID, string Key)
{
using (HowToDBEntities db = new HowToDBEntities())
{
Key k = new Key
{
TreeID = (short)this.CurrentTree,
NodeID = RecordID,
TypeID = 7,
KeyText = Key
};
db.Keys.Add(k);
db.SaveChanges();
RecordID = k.KeyID;
var keys =
(from ke in db.Keys
where ke.TreeID == 2
orderby ke.KeyText
select new
{
ke.KeyText
}).Distinct();
if (keys.Count() > 0)
{
treelbxKeys.DataSource = keys.ToList();
treelbxKeys.DataBind();
}
}
return(RecordID);
}
public void UpdateNode(int i)
{
using (HowToDBEntities db = new HowToDBEntities())
{
Node node = db.Nodes.FirstOrDefault(n => n.NodeID == i);
node.Heading = treetxtHeading.Text;
node.NodeText = treetxtNodeText.Text;
db.SaveChanges();
}
}
// Node Methods
public int CreateNewNode()
{
int RecordID;
using (HowToDBEntities db = new HowToDBEntities())
{
Node n = new Node
{
TreeID = (short)this.CurrentTree,
TypeID = (short)this.NodeType,
TreeLevel = (short)this.CurrentLevel,
ParentNodeID = this.ParentNode,
Heading = treetxtHeading.Text,
NodeText = treetxtNodeText.Text
};
db.Nodes.Add(n);
db.SaveChanges();
RecordID = n.NodeID;
if (this.CurrentLevel == 1)
{
var nodes =
from no in db.Nodes
where no.TreeID == 2 && no.ParentNodeID == this.ParentNode
orderby no.Heading
select no;
if (nodes.Count() > 0)
{
treelbxNodes.DataSource = nodes.ToList();
treelbxNodes.DataBind();
}
}
else
{
var nodes =
from no in db.Nodes
where no.TreeID == 2 && no.ParentNodeID == this.ParentNode
select no;
if (nodes.Count() > 0)
{
treelbxNodes.DataSource = nodes.ToList();
treelbxNodes.DataBind();
}
}
}
return(RecordID);
}