protected void DataBindUsers()
{
System.Data.Objects.ObjectParameter total = new System.Data.Objects.ObjectParameter("total", typeof(int));
string keywords = null;
if (txtSearch.Text.Trim() != string.Empty && txtSearch.Text.Trim().ToLower() != "Търсене")
{
keywords = txtSearch.Text;
}
GridViewExistingUsers.DataSource = entities.GetAllUsers(keywords, SortingColumn, SortingDirection == "sortingasc" ? "ASC" : "DESC", base.StartRow, base.PageSize, total);
GridViewExistingUsers.DataBind();
base.TotalRows = (int)total.Value;
lblTotalUsers.Text = "Брой: " + total.Value.ToString();
}
protected void DataBindUsers()
{
System.Data.Objects.ObjectParameter total = new System.Data.Objects.ObjectParameter("total", typeof(int));
var result = entities.GetAllUsers(null, "FirstName", "ASC", 1, 100000, total);
DataTable allUsers = new DataTable();
allUsers.Columns.Add("Name", typeof(string));
allUsers.Columns.Add("currentUserName", typeof(string));
foreach (var user in result)
{
string name = user.FirstName + " " + user.LastName;
string currentUserName = user.currentUserName.ToString();
allUsers.Rows.Add(name, currentUserName);
}
ddlUsers.DataSource = allUsers;
ddlUsers.DataTextField = "Name";
ddlUsers.DataValueField = "currentUserName";
ddlUsers.DataBind();
}