public List <UserData> GetUserDataList()
{
List <UserData> userList = new List <UserData>();
UserData ud = new FuelCenterDB.UserData();
userList = ud.ReturnUserDataList();
return(userList);
}
public List <UserData> GetUsersDataList()
{
List <UserData> userData = new List <UserData>();
DBAccess db = new FuelCenterDB.DBAccess();
SqlConnection sqlConnect = db.CreateFuelDBConnection();
string sql = "uspGetUserList";
SqlCommand sqlCommand = db.SetFuelDBCommandTypeStoredProcedure(sqlConnect, sql);
try
{
using (sqlConnect)
{
sqlConnect.Open();
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
if (sqlReader.HasRows)
{
while (sqlReader.Read())
{
UserData newUser = new FuelCenterDB.UserData((string)sqlReader["First"],
(string)sqlReader["Last"],
(int)sqlReader["UserId"]);
userData.Add(newUser);
}
sqlReader.Close();
}
}
}
catch (Exception ex)
{
Message = new Exceptions(ex);
}
finally
{ db.CloseConnection(ref sqlConnect); }
//UserList = userData;
return(userData);
}
