Example #1
0
        public DataTable GetFundValue(GetFundValueRequst getFundValueRequest)
        {
            List <SqlParameter> parameters = new List <SqlParameter>();

            parameters.Add(new SqlParameter()
            {
                DbType = DbType.Int32, ParameterName = "portfolio", Value = getFundValueRequest.PortfolioId
            });
            parameters.Add(new SqlParameter()
            {
                DbType = DbType.Int32, ParameterName = "schemaCode", Value = getFundValueRequest.SchemaCode
            });
            parameters.Add(new SqlParameter()
            {
                DbType = DbType.Int32, ParameterName = "folioId", Value = getFundValueRequest.FolioId
            });
            parameters.Add(new SqlParameter()
            {
                DbType = DbType.Int32, ParameterName = "optionId", Value = getFundValueRequest.OptionId
            });


            DataSet ds = SQLHelper.ExecuteProcedure("PersonalFinance", "GetFundValue", CommandType.StoredProcedure, parameters);

            if (ds != null)
            {
                return(ds.Tables[0]);
            }
            return(null);
        }
        public FundValueResponse GetFundValue(GetFundValueRequst getFundValueRequest)
        {
            DataTable dtResult = _mutualFundsDataAccess.GetFundValue(getFundValueRequest);

            return(MapFundValue(dtResult));
        }
Example #3
0
        public HttpResponseMessage GetFundValue(GetFundValueRequst _getFundValueRequest)
        {
            FundValueResponse response = _mutualFundsRepository.GetFundValue(_getFundValueRequest);

            return(Request.CreateResponse(HttpStatusCode.OK, response));
        }