public IHttpActionResult Getallportfolio(int userid)
{
List <Portfolio> portlist = PortfolioDao.getPortfoliosByUserId(userid);
List <Portfilioandpnl> list = new List <Portfilioandpnl>();
foreach (Portfolio p in portlist)
{
list.Add(new Portfilioandpnl(p.PortfolioId, p.Name, PortfolioHistoryDao.getLastPortfolioHistorysByPId(p.PortfolioId).PNL));
}
return(Ok(list));
}
public IHttpActionResult Getallportfolio(int userid)
{
List <Portfolio> portlist = PortfolioDao.getPortfoliosByUserId(userid);
List <Portfilioandpnl> list = new List <Portfilioandpnl>();
foreach (Portfolio p in portlist)
{
list.Add(new Portfilioandpnl(p.PortfolioId, p.Name, PortfolioHistoryDao.getLastPortfolioHistorysByPId(p.PortfolioId).PNL.ToString("P")));
}
var query = from p in list
orderby p.PortfolioID descending
select p;
return(Ok(query));
}
public IHttpActionResult Getbestportfolio(int userid)
{
List <Portfolio> portlist = PortfolioDao.getPortfoliosByUserId(userid);
List <Portfilioandpnl> list = new List <Portfilioandpnl>();
foreach (Portfolio p in portlist)
{
list.Add(new Portfilioandpnl(p.PortfolioId, p.Name, PortfolioHistoryDao.getLastPortfolioHistorysByPId(p.PortfolioId).PNL));
}
var query = from p in list
orderby p.PNL descending
select new { p.portfolioname, p.PNL };
return(Ok(query.Take(1)));
}
public IHttpActionResult GetWorstmanagers()
{
List <User> alluser = UserDao.getUsers();
List <ManagerInfo> manager = new List <ManagerInfo>();
foreach (User u in alluser)
{
List <Portfolio> allportfolio = PortfolioDao.getPortfoliosByUserId(u.UserId);
double sum = 0;
int i = 0;
foreach (Portfolio p in allportfolio)
{
sum += PortfolioHistoryDao.getLastPortfolioHistorysByPId(p.PortfolioId).PNL;
i++;
}
manager.Add(new ManagerInfo(u.UserId, u.FirstName + " " + u.LastName, (sum / i).ToString("P")));
}
var query = from m in manager
orderby m.PNLAvg
select m;
return(Ok(query.Take(3)));
}
public IHttpActionResult Getbestportfolio()
{
List <Portfolio> portlist = PortfolioDao.getPortfolios();
List <Portfolioandpnl> list = new List <Portfolioandpnl>();
foreach (Portfolio p in portlist)
{
list.Add(new Portfolioandpnl(p.PortfolioId, p.Name, UserDao.getUsersById(p.UserId).FirstName + " " +
UserDao.getUsersById(p.UserId).LastName, PortfolioHistoryDao.getLastPortfolioHistorysByPId(p.PortfolioId).PNL.ToString("P")));
}
var query = from p in list
orderby p.PNL descending
select p;
return(Ok(query.Take(1)));
}
public IHttpActionResult Get()
{
List <Portfolio> list = PortfolioDao.getPortfolios();
List <Portfolioinfo> returnlist = new List <Portfolioinfo>();
foreach (Portfolio p in list)
{
returnlist.Add(new Portfolioinfo(p.PortfolioId, p.Name, UserDao.getUsersById(p.UserId).FirstName + " "
+ UserDao.getUsersById(p.UserId).LastName, PortfolioHistoryDao.getLastPortfolioHistorysByPId(p.PortfolioId).PNL.ToString("P")));
}
return(Ok(returnlist));
}