public IList<StockSummary> GetFundsSummary(int UserId)
        {
            var summaries = new List<StockSummary>();
            try
            {
                using (var entityrepo = new UBSFundsDBEntities())
                {
                    summaries = entityrepo.spGetAllFundsSummary(UserId).Select(s => new StockSummary
                    {
                        StockType =s.StockType,
                        TotalMarketValue =s.TotalMarketValue??0.0M,
                        TotalQuantity =s.TotalQuantity??0,
                        TotalStockWeight =s.TotalStockWeight??0.0M,
                        TypeId =s.TypeId
                        
                    }).ToList();
                }

            }
            catch (Exception ex)
            {
                throw;
            }
            return summaries;
        }