public List <UserModel> GetUserDetails(UserRoleChoice userRoleChoice) { switch ((int)userRoleChoice) { case 1: _usersList = (List <UserModel>)DataSource._userList.Where(m => m.IsStudent == "true"); break; case 2: _usersList = (List <UserModel>)DataSource._userList.Where(m => m.IsStudent == "false"); break; } return(_usersList); }
/// <summary> /// Getting the user details as per the choice of the user. /// </summary> /// <param name="userRoleChoice"></param> /// <returns></returns> public List <UserModel> GetUserDetails(UserRoleChoice userRoleChoice) { SqlDataAdapter adapter; DataRow[] result; DataSet dataSet; DataTable userTable; using (SqlConnection connection = new SqlConnection(StringLiterals._connectionString)) { using (SqlCommand command = new SqlCommand()) { switch ((int)userRoleChoice) { case 1: adapter = new SqlDataAdapter("SELECT * FROM USERINFO WHERE IsStudent='true'", connection); dataSet = new DataSet(); adapter.Fill(dataSet, "User"); userTable = dataSet.Tables["User"]; result = userTable.Select(); ConvertToList(result); _usersList.Clear(); break; case 2: adapter = new SqlDataAdapter("SELECT * FROM USERINFO WHERE IsStudent='false'", connection); dataSet = new DataSet(); adapter.Fill(dataSet, "User"); userTable = dataSet.Tables["User"]; result = userTable.Select(); ConvertToList(result); _usersList.Clear(); break; case 3: adapter = new SqlDataAdapter("SELECT * FROM USERINFO", connection); dataSet = new DataSet(); adapter.Fill(dataSet, "User"); userTable = dataSet.Tables["User"]; result = userTable.Select(); ConvertToList(result); _usersList.Clear(); break; } } } return(_usersList); }
public List <UserModel> GetUserDetails(UserRoleChoice userRoleChoice) { List <UserModel> usersList = null; switch ((int)userRoleChoice) { case 1: usersList = (List <UserModel>)DataSource._userList.Where(m => m.IsStudent == "yes"); break; case 2: usersList = (List <UserModel>)DataSource._userList.Where(m => m.IsStudent == "no"); break; case 3: usersList = DataSource._userList; break; } return(usersList); }
/// <summary> /// Retrieve User details from the repository /// </summary> /// <param name="userRoleChoice"></param> /// <returns></returns> public List <Model> GetUserDetails(UserRoleChoice userRoleChoice) { List <Model> usersList = null; switch ((int)userRoleChoice) { case (int)UserRoleChoice.User: usersList = (List <Model>)DataSource._userList.Where(m => m.IsStudent == StringLiterals._yes).ToList <Model>(); break; case (int)UserRoleChoice.Other: usersList = (List <Model>)DataSource._userList.Where(m => m.IsStudent == StringLiterals._no).ToList <Model>(); break; case (int)UserRoleChoice.All: usersList = DataSource._userList; break; } return(usersList); }
/// <summary> /// It is used to retrieve the details of userlist /// </summary> /// <param name="userRoleChoice"></param> /// <returns></returns> public List <UserModel> GetUserDetails(UserRoleChoice userRoleChoice) { return(userRepo.GetUserDetails(userRoleChoice)); }
/// <summary> /// For displaying user details /// </summary> /// <param name="userRoleChoice"></param> /// <returns></returns> public List <UserModel> DisplayUsers(UserRoleChoice userRoleChoice) { return(userBusiness.GetUserDetails(userRoleChoice)); }