public JsonResult GridUser(int page, int rows, string search, string sidx, string sord)
{
var data = new List<UserManagerModel>();
var tbl = new DynamicModel("ConnectionString", "aspnet_CustomProfile", "UserId");
dynamic iduser = tbl.Query("SELECT m.ApplicationId, m.UserId, m.Email, cp.Name " +
"FROM aspnet_Membership as m LEFT JOIN aspnet_CustomProfile as cp " +
"ON m.UserId = cp.UserId " +
"inner join aspnet_Applications as a " +
"on a.ApplicationName = @0 and a.ApplicationId = m.ApplicationId " +
"order by cp.Name", Portal.UniqueID);
var table = new DynamicModel("ConnectionString", "aspnet_Roles", "RoleId");
dynamic roles = table.Query("SELECT r.RoleName, ur.UserId " +
"FROM aspnet_Roles r, aspnet_UsersInRoles ur " +
"WHERE r.RoleId = ur.RoleId");
var iRoles = (IEnumerable<dynamic>) roles;
var i = 1;
foreach (var user in iduser)
{
var m = new UserManagerModel();
m.id = i;
m.UserId = user.UserId;
m.UserName = user.Name;
m.UserEmail = user.Email;
var userrolid = Guid.Parse(user.UserId.ToString());
try
{
var roleName = iRoles.Where(r => r.UserId == userrolid);
m.UserRol = roleName.Single().RoleName;
}
catch (Exception e)
{
m.UserRol = "";
}
m.Edit = Builddir(m.UserEmail);
data.Add(m);
i++;
}
if (!string.IsNullOrEmpty(search))
{
return Search(search, page, rows, data);
}
var result = GetRowsFromList(data.AsQueryable(), rows, page);
return result;
}
public static DynamicModel Open(string connectionStringName)
{
dynamic dm = new DynamicModel(connectionStringName);
return(dm);
}
public static DynamicModel Open(string connectionStringName)
{
dynamic dm = new DynamicModel(connectionStringName);
return dm;
}
