public ActionResult Search(AdminUserSearch user)
{
var model = _lmsUserManager.Search(user);
var roleRepo = new SqlLmsRoleRepository();
model.CreateRole(roleRepo.RoleGetAll());
return(View(model));
}
public ActionResult Search()
{
var roleRepo = new SqlLmsRoleRepository();
AdminUserSearch model = new AdminUserSearch();
model.CreateRole(roleRepo.RoleGetAll());
return(View(model));
}
public AdminUserSearch Search(AdminUserSearch user)
{
var response = new AdminUserSearch();
try
{
response.AdminUserList = _lmsUserRepository.UserSearch(user);
}
catch (Exception ex)
{
}
return(response);
}
public List <LmsUser> UserSearch(AdminUserSearch searchName)
{
List <LmsUser> users = new List <LmsUser>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("UserSearch", cn);
cmd.CommandType = CommandType.StoredProcedure;
if (!string.IsNullOrEmpty(searchName.FirstName))
{
cmd.Parameters.Add(new SqlParameter("@FirstNamePartial", searchName.FirstName));
}
if (!string.IsNullOrEmpty(searchName.LastName))
{
cmd.Parameters.Add(new SqlParameter("@LastNamePartial", searchName.LastName));
}
if (!string.IsNullOrEmpty(searchName.Email))
{
cmd.Parameters.Add(new SqlParameter("@EmailPartial", searchName.Email));
}
if (!string.IsNullOrEmpty(searchName.SelectedRoleID))
{
cmd.Parameters.Add(new SqlParameter("@RoleID", searchName.SelectedRoleID));
}
cn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var user = new LmsUser();
user.UserID = (int)dr["UserID"];
user.FirstName = dr["FirstName"].ToString();
user.LastName = dr["LastName"].ToString();
user.Email = dr["Email"].ToString();
users.Add(user);
}
}
}
return(users);
}
public async Task <Pagination <AdminUser> > Search(AdminUserSearch search, Pager pager)
{
Expression <Func <AdminUser, bool> > predicate = x => x.IsValid && x.IsDeleted == false;
if (!string.IsNullOrWhiteSpace(search.UserName))
{
predicate = predicate.And(x => x.UserName.Contains(search.UserName.Trim()));
}
int total = await _adminUserRepository.CountAsync(predicate);
var data = await _adminUserRepository.Query(predicate)
.OrderByDescending(x => x.Id)
.Offset(pager.Offset)
.Take(pager.Limit)
.ToListAsync();
var ret = new Pagination <AdminUser>(total, data, pager);
return(ret);
}
public List <LmsUser> UserSearch(AdminUserSearch searchName)
{
List <LmsUser> user2 = new List <LmsUser>();
return(user2);
}
