}//GetPortfolioDetailsList public TopPortfoliosViewModel GetPortfolioDetailsList(GetPortfolioQuery query) { TopPortfoliosViewModel vm = new TopPortfoliosViewModel(); List <PortfolioDetails> res = new List <PortfolioDetails>(); var parameters = new Dictionary <string, Tuple <object, NHibernate.Type.IType> >(); parameters.Add("UserId", new Tuple <object, NHibernate.Type.IType>(query.userId, NHibernate.NHibernateUtil.Int64)); repository.Execute(session => { vm.NumOfRecords = session.Query <Entities.dbo.Portfolio>().Where(x => x.userId == query.userId && x.iSecsNum > 0).Count(); }); int startRow = (query.pageNumber - 1) * query.pageSize; parameters.Add("offset", new Tuple <object, NHibernate.Type.IType>(startRow, NHibernate.NHibernateUtil.Int32)); parameters.Add("count", new Tuple <object, NHibernate.Type.IType>(query.pageSize, NHibernate.NHibernateUtil.Int32)); parameters.Add("sortField", new Tuple <object, NHibernate.Type.IType>(query.sortField, NHibernate.NHibernateUtil.String)); var portfolios = repository.ExecuteSp <UserPortfolio>("dataGetUserPortfolio", parameters); vm.Portfolios = AutoMapper.Mapper.Map <List <PortfolioDetails> >(portfolios); foreach (var item in vm.Portfolios) { item.PreferedRisk = m_objPortfolio.GetRisk(item.InitRisk); } vm.Portfolios = vm.Portfolios.OrderByDescending(x => x.DateCreated).ToList(); return(vm); }
public TopPortfoliosViewModel GetPortolios(GetPortfolioQuery query) { TopPortfoliosViewModel vm = new TopPortfoliosViewModel(); vm = cPortHandler.GetPortfolioDetailsList(query); return(vm); }
public HttpResponseMessage Get([FromUri] GetPortfolioQuery query) { query.userId = user.UserID; TopPortfoliosViewModel res = null; //CacheHelper.Get(base.user.Username + "portfolio") as PortfolioViewModel; if (res == null) { res = service.GetPortolios(query); //CacheHelper.Add(base.user.Username + "portfolio", res, DateTime.Now.AddMinutes(30)); } return(Request.CreateResponse(HttpStatusCode.OK, res)); }
//public BacktestingPortfolioViewModel GetPortolios(long userId) //{ // List<PortfolioDetails> res = new List<PortfolioDetails>(); // res = cPortHandler.GetPortfolioDetailsList(userId); // BacktestingPortfolioViewModel vm = new BacktestingPortfolioViewModel(); // vm.Details = res; // return vm; //}//GetPortolios public BacktestingPortsViewModel GetPortolios(GetPortfolioQuery query) { TopPortfoliosViewModel ports = new TopPortfoliosViewModel(); ports = cPortHandler.GetPortfolioDetailsList(query); List <BacktestingPort> res = new List <BacktestingPort>(); for (int iPorts = 0; iPorts < ports.Portfolios.Count; iPorts++) { BacktestingPort newPort = new BacktestingPort(); newPort.Details = ports.Portfolios[iPorts]; newPort.StartDate = newPort.Details.StartDate; newPort.EndDate = newPort.Details.EndDate; newPort.BenchmarkNames = cPortHandler.getPortfolioBenchmarkNames(newPort.Details.ID); res.Add(newPort); } BacktestingPortsViewModel vm = new BacktestingPortsViewModel(); vm.Ports = res; vm.NumOfRecords = ports.NumOfRecords; return(vm); }//GetPortolios