public IList<StockDetail> GetAllStocks(int UserId)
        {
            var stocks = new List<StockDetail>();
            try 
	            {

                    using (var entityrepo = new UBSFundsDBEntities())
                    {
                        stocks = entityrepo.spGetAllFundsByUserId(UserId).Select(s => new StockDetail()
                        {
                            StockId = s.BlotterId,
                            StockName = s.StockName,
                            StockTypeId = s.StockTypeId??0,
                            Type = s.StockType,
                            MarketValue = s.MarketValue ?? 0.0M,
                            Price = s.Price ?? 0.0M,
                            Quantity = s.Quantity ?? 0,
                            StockWieght = s.StockWieght ?? 0.0M,
                            TransactionCost = s.TransactionCost ?? 0.0M,
                        }).ToList();
                    }
            
	            }
	            catch (Exception ex)
	            {
		
		            throw;
	            }
            return stocks;
        }