/// <summary> /// Displays the data of particular option /// </summary> /// <param name="op"></param> private void SqlDataRead(UserChoiceEnum op) { UserBusiness userBusiness = new UserBusiness(); SqlDataReader tab = userBusiness.GetUserDetails(op); Console.WriteLine(StringLiterals.TableData); while (tab.Read()) { for (int i = 0; i < tab.FieldCount; i++) { Console.Write(tab.GetValue(i) + "\t"); } Console.WriteLine(); } }
public List <UserModel> GetUserDetails(UserChoiceEnum role) { if (role == UserChoiceEnum.Student) { return(DataSource._userList.Where(m => m.IsStudent).ToList()); } else if (role == UserChoiceEnum.Other) { return(DataSource._userList.Where(m => !m.IsStudent).ToList()); } else { return(DataSource._userList); } }
/// <summary> /// method to get user details /// </summary> /// <param name="role">user choice enumeration</param> /// <returns></returns> public List <UserModel> GetUserDetails(UserChoiceEnum role) { return(_userData.GetUserDetails(role)); }
/// <summary> /// method to get user details /// </summary> /// <param name="role">user choice enumeration</param> /// <returns></returns> public SqlDataReader GetUserDetails(UserChoiceEnum role) { return(_userData.GetUserDetails(role)); }
/// <summary> /// GEts the details /// </summary> /// <param name="role">Enumeration</param> /// <returns>data returned in form of sqlDataReader</returns> internal SqlDataReader GetUserDetails(UserChoiceEnum role) { return(_userBusiness.GetUserDetails(role)); }