public User getUserById(int userId) { User user = new User(); // get our table data from our DAO userTable = userDAO.GetUserById(userId); //go through table data row by row if (userTable.Count == 1) // their should only be one user { //get data foreach (UserDS.TabUserRow userRow in userTable.Rows) { user.setData(userRow.UID, userRow.UserName, userRow.UserLevel, userRow.UserEmail); } } else { user.Id = -1; } //User will be either fully set or have an id of -1 return(user); }
private static void GetListOfUsersFromDataTable(List <UserModel> users, UserDS.TabUserDataTable userTable) { //so, for every row in our table foreach (UserDS.TabUserRow row in userTable.Rows) { //create a user model representing that row UserModel user = UserModel.Parse(row); users.Add(user);//add to our list of users } }
public List <UserModel> GetListOfUsersByUserNameAndPassword(string username, string password) { List <UserModel> users = new List <UserModel>(); UserDS.TabUserDataTable userTable = userDAO.GetUserByUserNamePassword(username, password); GetListOfUsersFromDataTable(users, userTable); return(users); }
public List <UserModel> GetListOfUsers() { List <UserModel> users = new List <UserModel>();//build an empty list of users //get users in form of data table from Data Access layer UserDS.TabUserDataTable userTable = userDAO.GetUserDataTable(); GetListOfUsersFromDataTable(users, userTable); return(users); //give list to whoever asked for it }
public List <UserModel> GetListOfUsersByUserNameAndPassword(string username, string password) { List <UserModel> users = new List <UserModel>();//build an empty list of users //get users in form of data table from Data Access layer UserDS.TabUserDataTable userTable = userDAO.GetUserByUserNamePassword(username, password); GetListOfUsersFromDataTable(users, userTable); return(users); //give list to whoever asked for it }
public List <TabUserModel> GetAllUser() { _users = new List <TabUserModel>(); _tabUserTable = _userDAO.GetAllUser(); foreach (UserDS.TabUserRow row in _tabUserTable.Rows) { _users.Add(TabUserModel.Parse(row)); } return(_users); }
public List <TabUserModel> PerformLogin(string username, string password) { _users = new List <TabUserModel>(); if (password.Length > 0) { _tabUserTable = _userDAO.GetLogin(username, password); foreach (UserDS.TabUserRow row in _tabUserTable.Rows) { _users.Add(TabUserModel.Parse(row)); } } return(_users); }
public List <UserModel> GetListOfUsers() { List <UserModel> users = new List <UserModel>(); //build empty list first userTable = userDAO.GetUserDataTable(); //fill userTable from our userDAO //for each row in our user table... foreach (UserDS.TabUserRow userRow in userTable.Rows) { //conver that row to a userModel and add it to the list UserModel user = UserModel.Parse(userRow); users.Add(user); } return(users); //return list of users :D }
public List <UserModel> GetListOfUsersByLogin(string userName, string password) { List <UserModel> users = new List <UserModel>(); //build empty list first userTable = userDAO.GetUserByUserNamePassword(userName, password); //for each row in our user table... foreach (UserDS.TabUserRow userRow in userTable.Rows) { //conver that row to a userModel and add it to the list UserModel user = UserModel.Parse(userRow); users.Add(user); } return(users); //return list of users :D }
/// <summary> /// Returns all users data from table User. /// </summary> /// <returns>List<TabUserModel></returns> /// <exception cref="ex">Exception</exception> public List <TabUserModel> GetAllUser() { try { _users = new List <TabUserModel>(); _tabUserTable = _userDAO.GetAllUser(); foreach (UserDS.TabUserRow row in _tabUserTable.Rows) { _users.Add(TabUserModel.Parse(row)); } return(_users); } catch (Exception ex) { //Error log simulate Console.WriteLine(ex.ToString()); Console.WriteLine(ex.GetBaseException().ToString()); throw; } }
public List <User> getAllUsers() { List <User> users = new List <User>(); // get our table data from our DAO userTable = userDAO.GetAllUserTab(); //go through table data row by row //get data foreach (UserDS.TabUserRow userRow in userTable.Rows) { User user = new User(); user.setData(userRow.UID, userRow.UserName, userRow.UserLevel, userRow.UserEmail); //add user to list users.Add(user); } return(users); }
public UserLogic() { userDAO = new UserDAO(); userTable = new UserDS.TabUserDataTable(); }
/// <summary> /// Constructor method /// </summary> public UserLogic() { _userDAO = new UserDAO(); _users = new List <TabUserModel>(); _tabUserTable = new UserDS.TabUserDataTable(); }