public List <Test> GetAspNetUser(string search, string sort, string sortdir, int skip, int pagesize, out int totalRecord)
{
using (HelpaEntity dc = new Helpa.HelpaEntity())
{
var v = (from user in dc.AspNetUsers.ToList()
join userLog in dc.UserLogs.ToList()
on user.Id equals userLog.UserId
select new Test
{
Id = user.Id,
RowStatus = user.RowStatus,
UserName = user.UserName,
Email = user.Email,
UserLogId = userLog.UserLogId,
DeviceName = userLog.DeviceId,
LoginTime = userLog.CreatedDate,
UserRole = userLog.AspNetUser.AspNetRoles.Select(x => x.Name).ToString()
}).Where(x => x.UserName.Contains(search) || x.Email.Contains(search)).OrderBy(x => x.UserName).ToList();
string Email = Session["Email"].ToString();
v = v.Where(x => x.Email != Email).ToList();
v = v.Skip(skip).Take(pagesize).ToList();
var k = v.OrderByDescending(x => x.LoginTime).GroupBy(x => x.Email).ToList();
v = new List <Test>();
foreach (var item in k)
{
v.Add(item.FirstOrDefault());
}
totalRecord = v.Count();
return(v);
}
}
public ActionResult Delete(int Id)
{
HelpaEntity obj = new Helpa.HelpaEntity();
AspNetUser Asp = new AspNetUser();
var Data = obj.AspNetUsers.Where(x => x.Id == Id).FirstOrDefault();
obj.AspNetUsers.Remove(Data);
return(RedirectToAction("index"));
}
