}//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
