public List <User> userVerify(string userName, string password)
{
User newUser = new User();
var userData = new UserData.TabUserDataTable();
var userTableAdapter = new TabUserTableAdapter();
List <User> userValue = new List <User>();
int rowCount = 0;
if (userName != null && password != null)
{
rowCount = userTableAdapter.ValidateUsers(userData, userName, password);
}
if (rowCount > 0)
{
foreach (DataRow dr in userData.Rows)
{
newUser.UID = int.Parse(dr["UID"].ToString());
newUser.userEmail = dr["UserEmail"].ToString();
newUser.userLevel = int.Parse(dr["UserLevel"].ToString());
userValue.Add(newUser);
}
return(userValue);
}
return(null);
}
public int UpdateUser(int UID, string userName, string userEmail, int userLevel, string password)
{
var userData = new UserData.TabUserDataTable();
var userTableAdapter = new TabUserTableAdapter();
if (UID > 0)
{
int countRow = userTableAdapter.UpdateUser(userName, password, userLevel, userEmail, UID);
return(countRow);
}
return(0);
}
public int InsertUser(string userName, string userEmail, int userLevel, string password)
{
var userData = new UserData.TabUserDataTable();
var userTableAdapter = new TabUserTableAdapter();
if (userName != null && password != null)
{
int countRow = userTableAdapter.InsertUser(userName, password, userLevel, userEmail);
return(countRow);
}
else
{
return(0);
}
}
// 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);
}
public bool userVerify(string userName, string password)
{
User newUser = new User();
var userData = new UserData.TabUserDataTable();
var userTableAdapter = new TabUserTableAdapter();
int rowCount = userTableAdapter.ValidateUsers(userData, userName, password);
if (rowCount > 0)
{
foreach (DataRow dr in userData.Rows)
{
newUser.UID = int.Parse(dr["UID"].ToString());
newUser.userEmail = dr["UserEmail"].ToString();
newUser.userLevel = int.Parse(dr["UserLevel"].ToString());
}
}
return(newUser.UID > 0 ? true : false);
}
// 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 bool UserValidate(string username, string password)
{
bool accessUser = false;
try // Using try and catch statement to find error if there is any.
{
// Connecting to a Database(UserMediaData) table
TabUserTableAdapter tabUserTableAdapter = new TabUserTableAdapter();
int loginStatus = (int)tabUserTableAdapter.LoginQuery(username, password); //Using Custome made query
if (loginStatus == 1)
{
accessUser = true;
}
}
catch (Exception e)
{
Console.WriteLine("Database Error" + e.Message); // Error Message
}
return(accessUser);
}
List <User> IUserManager.getUsers()
{
List <User> users = new List <User>();
var userData = new UserData.TabUserDataTable();
var userDataAdapter = new TabUserTableAdapter();
userDataAdapter.GetUsersBy(userData);
foreach (DataRow dr in userData.Rows)
{
User newUser = new User();
newUser.UID = int.Parse(dr["UID"].ToString());
newUser.userName = dr["UserName"].ToString();
newUser.password = dr["Password"].ToString();
newUser.userEmail = dr["UserEmail"].ToString();
newUser.userLevel = int.Parse(dr["UserLevel"].ToString());
users.Add(newUser);
}
return(users);
}
private TabUserTableAdapter tabUserAdapter; //this class was autogenerated by our userDS query configure stage
public UserDAO()
{
userDataSet = new UserDS();
tabUserAdapter = new TabUserTableAdapter();
}
private TabUserTableAdapter tabUserTableAdapter; //uses sql to talk to db tables and DataTables
public UserDAO()
{
//build objs to reference of these types
userDataSet = new UserDS();
tabUserTableAdapter = new TabUserTableAdapter();
}
public void DeleteUser(int UID)
{
var userData = new UserData.TabUserDataTable();
var userTableAdapter = new TabUserTableAdapter();
int countRow = userTableAdapter.DeleteUser(UID);
}
//constructor method to instantiate private variables
public UserDataAccessObject()
{
_userDataSet = new UserDataSet();
_tabUserTableAdapter = new TabUserTableAdapter();
}
public UserDAO()
{
//Initialize objects
_userDataSet = new UserDS();
_tabUserTableAdapter = new TabUserTableAdapter();
}
public UserDataAccessObject()
{
userTableAdapter = new TabUserTableAdapter();
}
public UserDAO()
{
_userDataSet = new DataSet1();
_tableUserTableAdapter = new TabUserTableAdapter();
}
