public string Analysis(TransactionAnalysisViewModel transactionAnalysisViewModel) { AnalysisQuery analysisQuery = Mapper.Map <TransactionAnalysisViewModel, AnalysisQuery>(transactionAnalysisViewModel); DataSet analysisResult = expenseRepository.GetAnalysisData(analysisQuery); if (analysisResult.Tables[0].Rows.Count > 0) { return(analysisResult.Tables[0].Rows[0].Field <decimal>("TotalAmountInReturn").GetDefaultValueIfNull <string>("0")); } return(string.Format("{0:N2}", default(float))); // return PartialView(""); }
/// <summary> /// Get result set from analysis. /// </summary> /// <param name="analysisQuery">Analysis query entity.</param> /// <returns>Analysis result set.</returns> public DataSet GetAnalysisData(AnalysisQuery analysisQuery) { object[] objAnalysisQueryParams = new object[8]; objAnalysisQueryParams[0] = analysisQuery.User1; objAnalysisQueryParams[1] = analysisQuery.User2; objAnalysisQueryParams[2] = analysisQuery.GroupId; objAnalysisQueryParams[3] = analysisQuery.ExpenseId; objAnalysisQueryParams[4] = analysisQuery.From; objAnalysisQueryParams[5] = analysisQuery.To; objAnalysisQueryParams[6] = analysisQuery.Action; objAnalysisQueryParams[7] = userSession.CompanyId; return(DataLibrary.ExecuteDataSet(ref objAnalysisQueryParams, "bspGetAnalysisData")); }