public List <TabUserModel> GetAllUserDetails(int requestLevel)
{
if (requestLevel == 3)
{
_users = new List <TabUserModel>();
try
{
_tabUserTable = _userDAO.GetUser();
foreach (UserDataSet.TabUserRow row in _tabUserTable.Rows)
{
_users.Add(TabUserModel.Parse(row));
}
return(_users);
}
catch (Exception ex)
{
Console.WriteLine("Table could not be filled");
throw ex;
}
}
else
{
//throw access denied exception
throw new MLMSExceptions("Access Denied");
}
}
private static void AddUserModelsToListFromTable(List <UserModel> users, UserDataSet.TabUserDataTable userTable)
{
foreach (UserDataSet.TabUserRow row in userTable.Rows)
{
UserModel user = UserModel.Parse(row);
users.Add(user);
}
}
public List <UserModel> GetAllUsers()
{
List <UserModel> users = new List <UserModel>();
UserDataSet.TabUserDataTable userTable = userDAO.GetAllUsers();
AddUserModelsToListFromTable(users, userTable);
return(users);
}
public List <UserModel> GetUsersByUsernameAndPassword(string username, string password)
{
List <UserModel> users = new List <UserModel>();
UserDataSet.TabUserDataTable userTable = userDAO.GetUsersByUsernameAndPassword(username, password);
AddUserModelsToListFromTable(users, userTable);
return(users);
}
// get the list of borrowed media, including additional information
public List <BorrowDTO> GetBorrowInfo()
{
// list of borrowed media with full info
List <BorrowDTO> BorrowedMediaList = new List <BorrowDTO>();
try
{
// get data from Borrow Table
tabBorrowTableAdapter.SelectBorrow(tabBorrowDataTable);
// assign each data row to an item of BorrowedMediaList
foreach (DataRow borrowRow in tabBorrowDataTable.Rows)
{
int uID = (int)borrowRow["UID"];
int mediaID = (int)borrowRow["MediaID"];
string title = "";
string userName = "";
// get title of borrowed media
MediaDataSet.TabMediaDataTable tabMediaDataTable = new MediaDataSet.TabMediaDataTable();
TabMediaTableAdapter tabMediaTableAdapter = new TabMediaTableAdapter();
tabMediaTableAdapter.SelectMediaByMediaID(tabMediaDataTable, mediaID);
foreach (DataRow mediaRow in tabMediaDataTable.Rows)
{
title = (string)mediaRow["Title"];
}
// get name of user who borrowed the media
UserDataSet.TabUserDataTable tabUserDataTable = new UserDataSet.TabUserDataTable();
TabUserTableAdapter UserAdapter = new TabUserTableAdapter();
UserAdapter.SelectUserByUID(tabUserDataTable, uID);
foreach (DataRow userRow in tabUserDataTable.Rows)
{
userName = (string)userRow["UserName"];
}
BorrowedMediaList.Add(new BorrowDTO(userName, title, borrowRow["BorrowDate"].ToString(), borrowRow["ReturnDate"].ToString(), borrowRow["ActualReturnDate"].ToString()));
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(BorrowedMediaList);
}
// get the list of reserved media, including additional info
public List <ReserveDTO> GetReservedInfo()
{
List <ReserveDTO> ReservedMediaList = new List <ReserveDTO>();
try
{
//Query get reservation records
tabReservedTableAdapter.SelectReserved(tabReservedDataTable);
foreach (DataRow reservedRow in tabReservedDataTable.Rows)
{
int uID = (int)reservedRow["UID"];
int mediaID = (int)reservedRow["MediaID"];
string title = "";
string userName = "";
// get title of reserved media
MediaDataSet.TabMediaDataTable tabMediaDataTable = new MediaDataSet.TabMediaDataTable();
TabMediaTableAdapter tabMediaTableAdapter = new TabMediaTableAdapter();
tabMediaTableAdapter.SelectMediaByMediaID(tabMediaDataTable, mediaID);
foreach (DataRow mediaRow in tabMediaDataTable.Rows)
{
title = (string)mediaRow["Title"];
}
// get name of user who reserved the media
UserDataSet.TabUserDataTable tabUserDataTable = new UserDataSet.TabUserDataTable();
TabUserTableAdapter tabUserTableAdapter = new TabUserTableAdapter();
tabUserTableAdapter.SelectUserByUID(tabUserDataTable, uID);
foreach (DataRow userRow in tabUserDataTable.Rows)
{
userName = (string)userRow["UserName"];
}
ReservedMediaList.Add(new ReserveDTO(userName, title, reservedRow["ReservedDate"].ToString()));
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(ReservedMediaList);
}
public List <TabUserModel> GetLogin(String inputUsername, String inputPassword)
{
_users = new List <TabUserModel>();
try
{
_tabUserTable = _userDAO.GetLogin(inputUsername, inputPassword);
if (_tabUserTable.Count > 0)
{
foreach (UserDataSet.TabUserRow row in _tabUserTable.Rows)
{
_users.Add(TabUserModel.Parse(row));
}
}
return(_users);
}
catch (Exception ex)
{
Console.WriteLine("Exception:" + ex.ToString() + ", captured. Could Not Fill Table");
throw ex;
}
}//end GetLogin
//constructor
public UserLogic()
{
_userDAO = new UserDataAccessObject();
_users = new List <TabUserModel>();
_tabUserTable = new UserDataSet.TabUserDataTable();
}
