private void trvNev_DragDrop(object sender, DragEventArgs e)
{
TreeNode nodeOver = null;
Point p = trvNev.PointToClient(new Point(e.X, e.Y));
nodeOver = trvNev.GetNodeAt(p.X, p.Y);
string teamid = (System.String)e.Data.GetData(typeof(System.String));
if (trans.Tree.VisibleFlag == 1)
{
MessageBox.Show("This tree is used. Can't be added.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
if (!_repo.CheckTeamInTree(trans.Tree.TreeViewId, teamid))
{
nodeOver.TreeView.SelectedNode = nodeOver;
TreeNode nodeChild = new TreeNode(teamid);
nodeChild.Tag = teamid;
nodeOver.Nodes.Add(nodeChild);
nodeOver.Expand();
TeamHierarchyModel model = new TeamHierarchyModel();
model.TreeViewId = trans.Tree.TreeViewId;
model.TeamId = teamid;
model.ParentId = nodeOver.Tag.ToString();
trans.Hierarchy = _repo.InsertTeam(epiSession, model).ToList();
}
else
{
MessageBox.Show("This team [" + teamid + "] has already.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
public IEnumerable <TeamHierarchyModel> InsertTeam(Ice.Core.Session session, TeamHierarchyModel model)
{
string sql = string.Format(@"INSERT INTO Custom_TeamNode
(TreeViewId
,TeamId
,ParentId
,VisibleFlag
,CreateBy
,LastUpdateBy)
VALUES
( {0} --<TreeViewId, int,>
, '{1}' --<TeamId, nvarchar(50),>
, '{2}' --<ParentId, nvarchar(50),>
, {3} --<VisibleFlag, int,>
, '{4}' --<CreateBy, nvarchar(50),>
, '{4}')" + Environment.NewLine
, model.TreeViewId
, model.TeamId
, model.ParentId
, 1
, session.UserID);
Repository.Instance.ExecuteWithTransaction(sql, "Add node");
return(GetAllHierarchy(model.TreeViewId));
}
private void DeleteNodes(TreeNode node)
{
TeamHierarchyModel model = new TeamHierarchyModel();
model.TreeViewId = trans.Tree.TreeViewId;
model.TeamId = node.Tag.ToString();
trans.Hierarchy = _repo.DeleteNode(epiSession, model).ToList();
foreach (TreeNode oSubNode in node.Nodes)
{
DeleteNodes(oSubNode);
}
}
public IEnumerable <TeamHierarchyModel> DeleteNode(Ice.Core.Session session, TeamHierarchyModel model)
{
string sql = string.Format(@"DELETE FROM Custom_AuthTree WHERE TreeViewId = {0} AND TeamId = '{1}' " + Environment.NewLine
, model.TreeViewId
, model.TeamId);
sql = sql + string.Format(@"DELETE FROM Custom_TeamNode WHERE TreeViewId = {0} AND TeamId = '{1}' " + Environment.NewLine
, model.TreeViewId
, model.TeamId);
sql = sql + string.Format(@"DELETE FROM Custom_Authorized WHERE TreeViewId = {0} AND TeamId = '{1}' " + Environment.NewLine
, model.TreeViewId
, model.TeamId);
Repository.Instance.ExecuteWithTransaction(sql, "Delete node");
return(GetAllHierarchy(model.TreeViewId));
}
public TeamHierarchyModel GetHierarchy(TeamHierarchyModel model)
{
throw new NotImplementedException();
}
public IEnumerable <TeamHierarchyModel> GetHierarchiesByFilter(TeamHierarchyModel model)
{
throw new NotImplementedException();
}
