private void BindGroupUsers(int GroupID)
{
lbUsers.Items.Clear();
DataTable dt = GetResTable;
int RoleId = -1;
if (ddRole.Items.Count > 0)
{
RoleId = int.Parse(ddRole.SelectedValue);
}
//int RoleId = int.Parse(ddRole.SelectedValue);
using (IDataReader rdr = SecureGroup.GetListActiveUsersInGroup(GroupID))
{
while (rdr.Read())
{
DataRow[] dr = dt.Select("PrincipalId = " + (int)rdr["UserId"] + " AND RoleId = " + RoleId);
if (dr.Length == 0)
{
lbUsers.Items.Add(new ListItem(rdr["LastName"].ToString() +
" " + rdr["FirstName"].ToString(), rdr["UserId"].ToString()));
}
}
}
}
private void BindGroupUsers(int groupId)
{
lbUsers.Items.Clear();
DataTable dt = (DataTable)ViewState["Resources"];
if (groupId > 0)
{
using (IDataReader reader = SecureGroup.GetListActiveUsersInGroup(groupId))
{
while (reader.Read())
{
DataRow[] dr = dt.Select("UserId = " + (int)reader["UserId"]);
if (dr.Length == 0)
{
lbUsers.Items.Add(new ListItem((string)reader["LastName"] + ", " + (string)reader["FirstName"], reader["UserId"].ToString()));
}
}
}
}
else // Favorites
{
DataTable favorites = Mediachase.IBN.Business.Common.GetListFavoritesDT(ObjectTypes.User);
foreach (DataRow row in favorites.Rows)
{
DataRow[] dr = dt.Select("UserId = " + (int)row["ObjectId"]);
if (dr.Length == 0)
{
lbUsers.Items.Add(new ListItem((string)row["Title"], row["ObjectId"].ToString()));
}
}
}
}
private void BindGroupUsers(int groupId)
{
lbAvailable.Items.Clear();
ArrayList alSelected = new ArrayList();
foreach (ListItem liSelected in lbSelected.Items)
{
alSelected.Add(int.Parse(liSelected.Value));
}
if (groupId > 0)
{
using (IDataReader reader = SecureGroup.GetListActiveUsersInGroup(groupId))
{
while (reader.Read())
{
if (!alSelected.Contains((int)reader["UserId"]))
{
lbAvailable.Items.Add(new ListItem(reader["LastName"].ToString() + " " + reader["FirstName"].ToString(), reader["UserId"].ToString()));
}
}
}
}
else if (groupId == 0) // Favorites
{
DataTable favorites = Mediachase.IBN.Business.Common.GetListFavoritesDT(ObjectTypes.User);
foreach (DataRow row in favorites.Rows)
{
if (!alSelected.Contains((int)row["ObjectId"]))
{
lbAvailable.Items.Add(new ListItem((string)row["Title"], row["ObjectId"].ToString()));
}
}
}
else
{
using (IDataReader reader = Project.GetListTeamMemberNamesWithManager(-groupId))
{
while (reader.Read())
{
if (!alSelected.Contains((int)reader["UserId"]))
{
lbAvailable.Items.Add(new ListItem(reader["LastName"].ToString() + " " + reader["FirstName"].ToString(), reader["UserId"].ToString()));
}
}
}
}
}
private void BindGroupUsers(int groupId)
{
lbUsers.Items.Clear();
DataTable dt = (DataTable)ViewState["Participants"];
if (groupId > 0)
{
btnAddGroup.Visible = true;
using (IDataReader reader = SecureGroup.GetListActiveUsersInGroup(groupId))
{
while (reader.Read())
{
DataRow[] dr = dt.Select("PrincipalId = " + (int)reader["UserId"]);
if (dr.Length == 0)
{
lbUsers.Items.Add(new ListItem((string)reader["LastName"] + " " + (string)reader["FirstName"], reader["UserId"].ToString()));
}
}
}
}
else if (groupId == 0) // Favorites
{
DataTable favorites = Mediachase.IBN.Business.Common.GetListFavoritesDT(ObjectTypes.User);
foreach (DataRow row in favorites.Rows)
{
DataRow[] dr = dt.Select("PrincipalId = " + (int)row["ObjectId"]);
if (dr.Length == 0)
{
lbUsers.Items.Add(new ListItem((string)row["Title"], row["ObjectId"].ToString()));
}
}
}
else
{
btnAddGroup.Visible = false;
using (IDataReader reader = Project.GetListTeamMemberNamesWithManager(-groupId))
{
while (reader.Read())
{
DataRow[] dr = dt.Select("PrincipalId = " + (int)reader["UserId"]);
if (dr.Length == 0)
{
lbUsers.Items.Add(new ListItem((string)reader["LastName"] + " " + (string)reader["FirstName"], reader["UserId"].ToString()));
}
}
}
}
}
private void BindGroupUsers(int GroupID)
{
lbUsers.Items.Clear();
DataTable dt = (DataTable)ViewState["Participants"];
using (IDataReader rdr = SecureGroup.GetListActiveUsersInGroup(GroupID))
{
while (rdr.Read())
{
DataRow[] dr = dt.Select("UserId = " + (int)rdr["UserId"]);
if (dr.Length == 0)
{
lbUsers.Items.Add(new ListItem(rdr["LastName"].ToString() + " " + rdr["FirstName"].ToString(), rdr["UserId"].ToString()));
}
}
}
}
private void BindGroupUsers(int GroupID)
{
lbUsers.Items.Clear();
using (IDataReader rdr = SecureGroup.GetListActiveUsersInGroup(GroupID))
{
string str = "";
while (rdr.Read())
{
str += rdr["UserId"].ToString() + ",";
ListItem lItm = lstSelected.Items.FindByValue(rdr["UserId"].ToString());
if (lItm == null)
{
lbUsers.Items.Add(new ListItem((string)rdr["LastName"] + " " + (string)rdr["FirstName"], rdr["UserId"].ToString()));
}
}
iGroupFields.Value = str;
}
}
