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 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 List<LmsUser> UserSearch(AdminUserSearch searchName)
{
List<LmsUser> user2 = new List<LmsUser>();
return user2;
}
public AdminUserSearch Search(AdminUserSearch user)
{
var response = new AdminUserSearch();
try
{
response.AdminUserList = _lmsUserRepository.UserSearch(user);
}
catch (Exception ex)
{
}
return response;
}
