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));
}
