public string GetJsonDataSource(string nodeId)
{
List <JsonTreeNode> nodes = new List <JsonTreeNode>();
int userIMGroupId = 0;
DataTable dt = null;
JsonTreeNode node;
if (!IMGroup.CanCreate())
{
using (IDataReader rdr = Mediachase.IBN.Business.User.GetUserInfo(Mediachase.IBN.Business.Security.CurrentUser.UserID))
{
rdr.Read();
userIMGroupId = (int)rdr["IMGroupId"];
}
dt = IMGroup.GetListIMGroupsYouCanSee(userIMGroupId);
string imGroupName = IMGroup.GetIMGroupName(userIMGroupId, null);
if (imGroupName != null)
{
DataRow dr = dt.NewRow();
dr["IMGroupId"] = userIMGroupId;
dr["IMGroupName"] = imGroupName;
dt.Rows.InsertAt(dr, 0);
}
}
else
{
dt = IMGroup.GetListIMGroup();
}
foreach (DataRow dr in dt.Rows)
{
int imGroupId = (int)dr["IMGroupId"];
node = new JsonTreeNode();
node.icon = "../../../Layouts/Images/icons/ibngroup.gif";
node.iconCls = "iconStdCls";
node.text = dr["IMGroupName"].ToString();
node.cls = "nodeCls";
node.href = "../../../Directory/Directory.aspx?Tab=1&IMGroupID=" + imGroupId.ToString();
node.hrefTarget = "right";
node.leaf = true;
nodes.Add(node);
}
if (nodes.Count > 0)
{
return(UtilHelper.JsonSerialize(nodes));
}
else
{
return(String.Empty);
}
}
private void BindSavedData()
{
int id = 0;
if (GroupID > 0)
{
id = GroupID;
}
else if (CloneGroupID > 0)
{
id = CloneGroupID;
}
if (id > 0)
{
using (DataTable table = IMGroup.GetGroup(id))
{
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
if (CloneGroupID == 0)
{
tbGroupTitle.Text = HttpUtility.HtmlDecode(row["IMGroupName"].ToString());
}
tbColor.Text = HttpUtility.HtmlDecode(row["Color"].ToString());
}
}
using (DataTable table = IMGroup.GetListIMGroupsYouCanSee(id))
{
foreach (DataRow row in table.Rows)
{
CommonHelper.SafeMultipleSelect(lbVisible, ((int)row["IMGroupId"]).ToString(CultureInfo.InvariantCulture));
}
}
using (DataTable table = IMGroup.GetListIMGroupsCanSeeYou(id))
{
foreach (DataRow row in table.Rows)
{
CommonHelper.SafeMultipleSelect(lbCU, ((int)row["IMGroupId"]).ToString(CultureInfo.InvariantCulture));
}
}
}
}
private void BinddgGroupsUsers()
{
dgUsers.Columns[1].HeaderText = LocRM.GetString("GroupUser");
dgUsers.Columns[2].HeaderText = LocRM.GetString("Email");
if (GroupID == 0)
{
dgUsers.Columns[2].Visible = false;
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ID", typeof(int)));
dt.Columns.Add(new DataColumn("Type", typeof(int))); //0-IMGroup, 1- User
dt.Columns.Add(new DataColumn("GroupName", typeof(string)));
dt.Columns.Add(new DataColumn("Email", typeof(string)));
dt.Columns.Add(new DataColumn("ActionEdit", typeof(string)));
dt.Columns.Add(new DataColumn("ActionDelete", typeof(string)));
DataView dv;
DataRow dr;
if (GroupID > 0) // Bind Users
{
// [..]
dr = dt.NewRow();
dr["ID"] = 0;
dr["Type"] = 0;
dr["GroupName"] = "<span style='padding-left:30px'> </span><a href='../Directory/directory.aspx?Tab=1&IMGroupID=0'>[..]</a>";
dt.Rows.Add(dr);
using (IDataReader rdr = IMGroup.GetListUsers(GroupID))
{
while (rdr.Read())
{
dr = dt.NewRow();
int iUserId = (int)rdr["UserId"];
dr["ID"] = iUserId;
dr["Type"] = 1;
dr["Email"] = rdr["Email"].ToString();
if (User.CanUpdateUserInfo(iUserId))
{
dr["ActionEdit"] = String.Format("<a href='../Directory/UserEdit.aspx?UserID={0}'><img alt='{1}' src='../Layouts/Images/edit.gif' title='{1}'/></a>", iUserId.ToString(), LocRM.GetString("Edit"));
}
if (User.CanDelete(iUserId))
{
dr["ActionDelete"] = String.Format("<a href='javascript:DeleteUser({0})'><img alt='{1}' src='../Layouts/Images/delete.gif' title='{1}'/></a>", iUserId.ToString(), LocRM.GetString("Delete"));
}
dt.Rows.Add(dr);
}
}
dv = dt.DefaultView;
}
else // Bind IMGroups
{
int userIMGroupId = 0;
if (!IMGroup.CanCreate())
{
using (IDataReader rdr = User.GetUserInfo(Security.CurrentUser.UserID))
{
rdr.Read();
if (rdr["IMGroupId"] != DBNull.Value)
{
userIMGroupId = (int)rdr["IMGroupId"];
}
}
if (userIMGroupId > 0)
{
using (DataTable table = IMGroup.GetListIMGroupsYouCanSee(userIMGroupId))
{
foreach (DataRow row in table.Rows)
{
dr = dt.NewRow();
int groupId = (int)row["IMGroupId"];
dr["ID"] = groupId;
dr["Type"] = 0;
dr["GroupName"] = row["IMGroupName"].ToString();
if (IMGroup.CanUpdate())
{
dr["ActionEdit"] = String.Format("<a href='../Directory/AddIMGroup.aspx?GroupID={0}'><img alt='{1}' src='../Layouts/Images/edit.gif' title='{1}'/></a>", groupId, LocRM.GetString("Edit"));
}
if (IMGroup.CanDelete(groupId))
{
dr["ActionDelete"] = String.Format("<a href='javascript:DeleteGroup({0})'><img alt='{1}' src='../Layouts/Images/delete.gif' title='{1}'/></a>", groupId, LocRM.GetString("Delete"));
}
dt.Rows.Add(dr);
}
}
string imGroupName = IMGroup.GetIMGroupName(userIMGroupId, null);
if (imGroupName != null)
{
dr = dt.NewRow();
dr["ID"] = userIMGroupId;
dr["Type"] = 0;
dr["GroupName"] = imGroupName;
if (IMGroup.CanUpdate())
{
dr["ActionEdit"] = String.Format("<a href='../Directory/AddIMGroup.aspx?GroupID={0}'><img alt='{1}' src='../Layouts/Images/edit.gif' title='{1}'/></a>", userIMGroupId, LocRM.GetString("Edit"));
}
dt.Rows.Add(dr);
}
}
}
else
{
using (DataTable table = IMGroup.GetListIMGroup())
{
foreach (DataRow row in table.Rows)
{
dr = dt.NewRow();
int groupId = (int)row["IMGroupId"];
dr["ID"] = groupId;
dr["Type"] = 0;
dr["GroupName"] = row["IMGroupName"].ToString();
if (IMGroup.CanUpdate())
{
dr["ActionEdit"] = string.Format("<a href='../Directory/AddIMGroup.aspx?GroupID={0}'><img alt='{1}' src='../Layouts/Images/edit.gif' title='{1}'/></a>", groupId, LocRM.GetString("Edit"));
}
if (IMGroup.CanDelete(groupId))
{
dr["ActionDelete"] = string.Format("<a href='javascript:DeleteGroup({0})'><img alt='{1}' src='../Layouts/Images/delete.gif' title='{1}'/></a>", groupId, LocRM.GetString("Delete"));
}
dt.Rows.Add(dr);
}
}
}
dv = dt.DefaultView;
dv.Sort = "GroupName";
}
dgUsers.DataSource = dv;
dgUsers.DataBind();
}