public IHttpActionResult Updatestockprice(dynamic price) { PriceHistory history = new PriceHistory(); history.Isin = price.isin; history.OfferPrice = price.OfferPrice; history.Type = "Stock"; history.BidPrice = price.BidPrice; history.Date = DateTime.Now; int changeline = PriceHistoryDao.setPriceHistory(history); List <Position> positions = PositionDao.getPositionsByIsin(history.Isin); Portfolio portfolio = new Portfolio(); int changline = 0; foreach (Position p in positions) { portfolio = PortfolioDao.getPortfoliosById(p.PortfolioId); double pnl = Getportfoliopnl(portfolio.PortfolioId); PortfolioHistory porthistory = new PortfolioHistory(); porthistory.PNL = pnl; porthistory.Date = DateTime.Now; porthistory.PortfolioId = portfolio.PortfolioId; int line = PortfolioHistoryDao.setPortfolioHistory(porthistory); changline++; } return(Ok("success")); }
public IHttpActionResult addPortfolioHistorys(PortfolioHistory c) { PortfolioHistory c1 = new PortfolioHistory { Id = 1, PortfolioId = 1, Date = Convert.ToDateTime("1992-03-20"), PNL = 0.387 }; int changeLine = PortfolioHistoryDao.setPortfolioHistory(c); return(Ok(changeLine)); }
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 Get(int id) { PortfolioHistory p = PortfolioHistoryDao.getPortfolioHistorysById(id); if (p != null) { return(Ok(p)); } else { return(NotFound()); } }
public IHttpActionResult GetOnePortfolioHis(int portid) { List <PortfolioHistory> p = PortfolioHistoryDao.getPortfolioHistorysByPId(portid); List <double> pnl = new List <double>(); List <string> time = new List <string>(); foreach (PortfolioHistory record in p) { pnl.Add(record.PNL); time.Add(record.Date.ToString("D")); } return(Ok(new OnePortfolioResult(time, pnl))); }
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 addPortfolios(Portfolio c) { int changeLine = PortfolioDao.addPortfolio(c); PortfolioHistory inital = new PortfolioHistory(); inital.Date = DateTime.Now; inital.PNL = 0; inital.PortfolioId = PortfolioDao.getPortfolioBySomething(c).PortfolioId; int addpnlresult = PortfolioHistoryDao.setPortfolioHistory(inital); if (changeLine == 1 && addpnlresult == 1) { return(Ok("Success")); } return(NotFound()); }
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 deletePortfolioHistorys(PortfolioHistory c) { int changeLine = PortfolioHistoryDao.deletePortfolioHistorys(c); return(Ok(changeLine)); }
public IHttpActionResult Get() { return(Ok(PortfolioHistoryDao.getPortfolioHistorys())); }
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)); }