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