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"));
}
