// get all user records
public List <UserDTO> GetAllUser()
{
// list for storing user objects
List <UserDTO> userList = new List <UserDTO>();
try
{
// get all rows in the table using query
tabUserTableAdapter.Fill(tabUserDataTable);
// convert rows into objects
foreach (DataRow userRow in tabUserDataTable.Rows)
{
UserDTO user = new UserDTO
{
UID = (int)userRow[0],
UserName = (string)userRow[1],
Password = (string)userRow[2],
UserLevel = (int)userRow[3],
UserEmail = (string)userRow[4]
};
userList.Add(user);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(userList);
}
/// <summary>
/// Get all data from TabUser
/// </summary>
/// <returns>Return the data to the dataset</returns>
/// <exception cref="Exception"></exception>
public DataSet1.TabUserDataTable GetUser()
{
try
{
_tableUserTableAdapter.Fill(_userDataSet.TabUser);
return(_userDataSet.TabUser);
}
catch (Exception ex)
{
throw ex;
}
}
