protected void displayUsers()
{
DataSet ds = new DataSet();
ds = this.ConnSQL.getUsersList();
UsersList.DataSource = ds.Tables["userslist"].DefaultView;
UsersList.DataBind();
}
private void BindUsers()
{
UsersList.DataSource = repo.GetAllUsers();
UsersList.DataTextField = "FullName";
UsersList.DataValueField = "EntityID";
UsersList.SelectedIndex = 0;
UsersList.DataBind();
BindDetails();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
UsersList.DataSource = DataBaseConnectionRoot.Instance.SelectQueryExecuter("select * from users");
UsersList.DataBind();
}
private void BindUsers()
{
UsersList.Items.Clear();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("UserId", typeof(string))); // 0
dt.Columns.Add(new DataColumn("UserName", typeof(string))); // 1
DataRow dr;
using (IDataReader reader = SecureGroup.GetListAllUsersInGroup(int.Parse(GroupsList.SelectedValue)))
{
while (reader.Read())
{
if ((byte)reader["Activity"] == (byte)Mediachase.IBN.Business.User.UserActivity.Active)
{
dr = dt.NewRow();
dr[0] = reader["UserId"].ToString();
dr[1] = reader["LastName"].ToString() + " " + reader["FirstName"].ToString();
dt.Rows.Add(dr);
}
}
}
if (dt.Rows.Count == 0) // no users in group
{
dr = dt.NewRow();
dr[0] = "-1";
dr[1] = GetGlobalResourceObject("IbnFramework.Project", "NoUsers").ToString();
dt.Rows.Add(dr);
}
DataView dv = dt.DefaultView;
UsersList.DataSource = dv;
UsersList.DataTextField = "UserName";
UsersList.DataValueField = "UserId";
UsersList.DataBind();
//Saved Value
ListItem li = UsersList.Items.FindByValue(UserId);
if (li != null)
{
li.Selected = true;
}
else
{
UsersList.SelectedIndex = 0;
UserId = UsersList.SelectedValue;
}
BindData();
}
private void BindUsers(int GroupId)
{
UsersList.Items.Clear();
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("UserId", typeof(string))); // 0
dt.Columns.Add(new DataColumn("UserName", typeof(string))); // 1
DataRow dr;
dr = dt.NewRow();
dr[0] = allUsers;
dr[1] = LocRM.GetString("All");
dt.Rows.Add(dr);
if (GroupId > 0)
{
using (IDataReader reader = SecureGroup.GetListAllUsersInGroup(GroupId))
{
while (reader.Read())
{
if ((byte)reader["Activity"] == (byte)Mediachase.IBN.Business.User.UserActivity.Active)
{
dr = dt.NewRow();
dr[0] = reader["UserId"].ToString();
dr[1] = reader["LastName"].ToString() + " " + reader["FirstName"].ToString();
dt.Rows.Add(dr);
}
}
}
}
DataView dv = dt.DefaultView;
UsersList.DataSource = dv;
UsersList.DataTextField = "UserName";
UsersList.DataValueField = "UserId";
UsersList.DataBind();
//Saved Value
if (_pc["MV_User"] != null)
{
UsersList.ClearSelection();
try
{
UsersList.SelectedValue = _pc["MV_User"];
}
catch
{
UsersList.SelectedIndex = 0;
_pc["MV_User"] = UsersList.SelectedValue;
}
}
}
private void LoadUsers()
{
State state = new State();
UserController userController = new UserController();
List <UserModel> users = userController.LoadUsers();
//We want to find the user we are logged in as, and remove it from the list
//so we don't accidently remove administrator rights to it.
foreach (UserModel user in users)
{
if (user.Id == state.Cache().GetUser().Id)
{
users.Remove(user);
break;
}
}
UsersList.DataSource = users;
UsersList.DataBind();
}
protected void users_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
UsersList.PageIndex = e.NewPageIndex;
UsersList.DataSource = DataBaseConnectionRoot.Instance.SelectQueryExecuter("select * from users");
UsersList.DataBind();
}
