public async Task <IDataResult <PlReport> > GetReport(PlReportFilterModel plReportFilterModel)
{
try
{
using (var connection = CreateConnection())
{
DataTable projectCodes = new DataTable();
projectCodes.Columns.Add("TextValue");
DataRow workRow;
foreach (var item in plReportFilterModel.ProjectCode)
{
workRow = projectCodes.NewRow();
workRow[0] = item;
projectCodes.Rows.Add(workRow);
}
var data = await connection.QueryAsync <PlReport>("Pr_PlPeportValues", new { plReportFilterModel.Moment, plReportFilterModel.PlReportType, plReportFilterModel.Month, plReportFilterModel.Currency, projectCodes }, commandType : CommandType.StoredProcedure);
return(new SuccessDataResult <PlReport>(data.FirstOrDefault()));
}
}
catch (Exception)
{
return(new ErrorDataResult <PlReport>());
}
}
public async Task <IDataResult <IEnumerable <ActualRawData> > > GetRawData(PlReportFilterModel plReportFilterModel)
{
try
{
using (var connection = CreateConnection())
{
//DataTable projectCodes = new DataTable();
//projectCodes.Columns.Add("TextValue");
//DataRow workRow;
//foreach (var item in plReportFilterModel.ProjectCode)
//{
// workRow = projectCodes.NewRow();
// workRow[0] = item;
// projectCodes.Rows.Add(workRow);
//}
var data = await connection.QueryAsync <ActualRawData>("Pr_ActualRawData", commandType : CommandType.StoredProcedure);
//foreach (var item in data)
//{
// item.Id = i++;
//}
return(new SuccessDataResult <IEnumerable <ActualRawData> >(data.ToList()));
}
}
catch (Exception ex)
{
return(new ErrorDataResult <IEnumerable <ActualRawData> >(ex.Message));
}
}
public async Task <IActionResult> GetPlReportDetailValues(PlReportFilterModel plReportFilterModel)
{
var resultData = await _plReportManager.GetReportValuesDetails(plReportFilterModel);
if (resultData.Success)
{
return(Ok(resultData.Data.ToList()));
}
else
{
return(NoContent());
}
}
public async Task <IActionResult> GetPlReportWithDetailValues(PlReportFilterModel plReportFilterModel)
{
var resultData = await _plReportManager.GetReportWithDetails(plReportFilterModel);
foreach (var item in resultData.Data)
{
item.SubCode2 = item.SubCode;
}
if (resultData.Success)
{
return(Ok(resultData.Data.ToList()));
}
else
{
return(NoContent());
}
}
public async Task <IDataResult <IEnumerable <PlReportDetailForBudgetOrCost> > > GetReportValuesDetails(PlReportFilterModel plReportFilterModel)
{
try
{
using (var connection = CreateConnection())
{
DataTable projectCodes = new DataTable();
projectCodes.Columns.Add("TextValue");
DataRow workRow;
foreach (var item in plReportFilterModel.ProjectCode)
{
workRow = projectCodes.NewRow();
workRow[0] = item;
projectCodes.Rows.Add(workRow);
}
var data = await connection.QueryAsync <PlReportDetailForBudgetOrCost>("Pr_PlPeportValuesDetails",
new { plReportFilterModel.Moment, plReportFilterModel.SubCode, plReportFilterModel.BudgetOrCostType,
plReportFilterModel.Month, plReportFilterModel.Currency, projectCodes, plReportFilterModel.BranchCode },
commandType : CommandType.StoredProcedure);
int i = 1;
foreach (var item in data)
{
item.Id = i++;
}
return(new SuccessDataResult <IEnumerable <PlReportDetailForBudgetOrCost> >(data.ToList()));
}
}
catch (Exception ex)
{
return(new ErrorDataResult <IEnumerable <PlReportDetailForBudgetOrCost> >(ex.Message));
}
}
