public async Task <DatabaseResponse> GetSharedContentReport(SharedContentInput sharedContentInput)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@ContentId", SqlDbType.Int),
new SqlParameter("@ContentTypeId", SqlDbType.Int),
new SqlParameter("@UserId", SqlDbType.Int)
};
parameters[0].Value = sharedContentInput.ContentId == null || sharedContentInput.ContentId == 0 ? null : sharedContentInput.ContentId;
parameters[1].Value = sharedContentInput.ContentTypeId;
parameters[2].Value = sharedContentInput.UserId == null || sharedContentInput.UserId == 0 ? null : sharedContentInput.UserId;
_DataHelper = new DataAccessHelper("sps_GetContentCountInfo", parameters, _configuration);
DataSet ds = new DataSet();
int result = await _DataHelper.RunAsync(ds);
SharedContentInfo sharedContentInfo = new SharedContentInfo();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
sharedContentInfo = (from model in ds.Tables[0].AsEnumerable()
select new SharedContentInfo()
{
ContentCount = model.Field <int?>("ContentCount"),
UserSharedCount = model.Field <int?>("UserSharedCount"),
}).FirstOrDefault();
}
return(new DatabaseResponse {
ResponseCode = result, Results = sharedContentInfo
});
}
catch (Exception ex)
{
Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical));
throw;
}
finally
{
_DataHelper.Dispose();
}
}
public async Task <IActionResult> GetSharedContentReport(SharedContentInput sharedContentInput)
{
try
{
ReportDataAccess _reportAccess = new ReportDataAccess(_iconfiguration);
DatabaseResponse response = await _reportAccess.GetSharedContentReport(sharedContentInput);
if (response.ResponseCode == (int)DbReturnValue.RecordExists)
{
return(Ok(new OperationResponse
{
HasSucceeded = true,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists),
ReturnedObject = response.Results
}));
}
else
{
Log.Error(EnumExtensions.GetDescription(DbReturnValue.NoRecords));
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.NoRecords)
}));
}
}
catch (Exception ex)
{
Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical));
return(Ok(new OperationResponse
{
HasSucceeded = false,
Message = StatusMessages.ServerError,
StatusCode = ((int)ResponseStatus.ServerError).ToString(),
IsDomainValidationErrors = false
}));
}
}
