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