public AddMFTransactionResponse AddTransaction(AddMFTransactionRequest mfTransactionRequest) { int retVal = -1; AddMFTransactionResponse response = new AddMFTransactionResponse(); DataTable dtResult = _mutualFundsDataAccess.AddTransaction(mfTransactionRequest); if (dtResult == null || dtResult.Rows.Count <= 0) { response = new AddMFTransactionResponse() { ReturnCode = retVal, ReturnMessage = "Failed to update!!" }; } int.TryParse(dtResult.Rows[0][0].ToString(), out retVal); if (retVal == 0) { response = new AddMFTransactionResponse() { ReturnCode = retVal, ReturnMessage = "Success" }; } else { response = new AddMFTransactionResponse() { ReturnCode = retVal, ReturnMessage = "Failed to update!!" }; } return(response); }
public DataTable AddTransaction(AddMFTransactionRequest request) { List <SqlParameter> parameters = new List <SqlParameter>(); parameters.Add(new SqlParameter() { DbType = DbType.Int32, ParameterName = "PortfolioId", Value = request.PortfolioId }); parameters.Add(new SqlParameter() { DbType = DbType.Int32, ParameterName = "houseId", Value = request.FundHouseId }); parameters.Add(new SqlParameter() { DbType = DbType.Int32, ParameterName = "typeId", Value = request.FundTypeId }); parameters.Add(new SqlParameter() { DbType = DbType.Int32, ParameterName = "categoryId", Value = request.FundCategoryId }); parameters.Add(new SqlParameter() { DbType = DbType.Int32, ParameterName = "optionsId", Value = request.FundOptionsId }); parameters.Add(new SqlParameter() { DbType = DbType.Int32, ParameterName = "schemaCode", Value = request.SchemaCode }); parameters.Add(new SqlParameter() { DbType = DbType.Int32, ParameterName = "growthschemaCode", Value = request.GrowthSchemaCode }); parameters.Add(new SqlParameter() { DbType = DbType.String, ParameterName = "fundName", Value = request.FundName }); parameters.Add(new SqlParameter() { DbType = DbType.Date, ParameterName = "PurchaseDate", Value = request.PurchaseDate.Date }); parameters.Add(new SqlParameter() { DbType = DbType.Int32, ParameterName = "FolioId", Value = request.FolioId }); parameters.Add(new SqlParameter() { DbType = DbType.Decimal, ParameterName = "Amount", Value = request.Amount }); parameters.Add(new SqlParameter() { DbType = DbType.Decimal, ParameterName = "PurchaseNAV", Value = request.PurchaseNAV }); parameters.Add(new SqlParameter() { DbType = DbType.Decimal, ParameterName = "Units", Value = request.Units }); parameters.Add(new SqlParameter() { DbType = DbType.String, ParameterName = "SIP", Value = (request.IsSIP == true ? "Y" : "N") }); DataSet ds = SQLHelper.ExecuteProcedure("PersonalFinance", "AddMFPurchase", CommandType.StoredProcedure, parameters); if (ds != null) { return(ds.Tables[0]); } return(null); }
public HttpResponseMessage AddTransaction(AddMFTransactionRequest _mfTransactionRequest) { AddMFTransactionResponse response = _mutualFundsRepository.AddTransaction(_mfTransactionRequest); return(Request.CreateResponse(HttpStatusCode.OK, response)); }