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