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)); }