public List <User> GetAllUsersWithAward(Award award)
{
try
{
List <User> usersList = new List <User>();
using (SqlConnection connection = new SqlConnection(_connectionString))
{
var stProc = "GetAllPersonsWithAward";
var command = new SqlCommand(stProc, connection)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter idParam = new SqlParameter("@id", award.id);
command.Parameters.Add(idParam);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
usersList.Add(usersDao.GetUserByID(Guid.Parse(reader["personid"] as string)));
}
}
return(usersList);
}
catch (SqlException)
{
return(null);
}
}
public User GetUserByID(int ID)
{
try
{
return(_usersDAO.GetUserByID(ID));
}
catch (Exception ex)
{
Logger.Log.Error(ex.Message);
return(null);
}
}
public User GetUserByID(Guid id) => daoUsers.GetUserByID(id);
public User GetUserByID(int ID)
{
return(_usersDAO.GetUserByID(ID));
}