public async Task <IActionResult> FetchAllUsers(int qrcId, int categoryId, int pageNo, int pageSize, int filterCategoryId)
{
QrcDataAccess _qrcAccess = new QrcDataAccess(_iconfiguration, _converter);
DatabaseResponse response = await _qrcAccess.GetUsersToAdd(qrcId, categoryId, pageNo, pageSize, filterCategoryId);
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.CreationFailed));
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists),
ReturnedObject = response.Results
}));
}
}
public async Task <IActionResult> GetCategoryByQRC(int qrcID)
{
QrcDataAccess _qrcAccess = new QrcDataAccess(_iconfiguration, _converter);
DatabaseResponse response = await _qrcAccess.GetCategoryByQRC(qrcID);
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.CreationFailed));
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists),
ReturnedObject = response.Results
}));
}
}
public async Task <IActionResult> Put(int id, [FromBody] UpdateQrcMaster qrc)
{
try
{
if (!ModelState.IsValid)
{
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = true,
StatusCode = ((int)ResponseStatus.BadRequest).ToString(),
Message = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage))
}));
}
QrcDataAccess _qrcAccess = new QrcDataAccess(_iconfiguration, _converter);
DatabaseResponse response = await _qrcAccess.UpdateQrc(qrc, id);
if (response.ResponseCode == (int)DbReturnValue.UpdateSuccess)
{
return(Ok(new OperationResponse
{
HasSucceeded = true,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.UpdateSuccess),
ReturnedObject = response.Results
}));
}
else
{
Log.Error(EnumExtensions.GetDescription(DbReturnValue.UpdationFailed));
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.NotExists),
ReturnedObject = response.Results
}));
}
}
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
}));
}
}
public async Task <IActionResult> GetContentApproval(ContentApprovalRequest contentApprovalRequest)
{
try
{
QrcDataAccess _qrcAccess = new QrcDataAccess(_iconfiguration, _converter);
DatabaseResponse response = await _qrcAccess.GetContentAsync(contentApprovalRequest);
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.NotExists));
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.NotExists),
ReturnedObject = response.Results
}));
}
}
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
}));
}
}
public async Task <IActionResult> AddQRCUserInfo([FromBody] List <QrcUserMapping> objQRCUserMapping)
{
try
{
if (objQRCUserMapping.Count > 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("QRCId", typeof(int));
dt.Columns.Add("CategoryId", typeof(int));
dt.Columns.Add("UserId", typeof(int));
dt.Columns.Add("CreatedBy", typeof(int));
DataRow dr = null;
foreach (var item in objQRCUserMapping)
{
dr = dt.NewRow();
dr["QRCId"] = item.QRCId;
dr["CategoryId"] = item.CategoryId;
dr["UserId"] = item.UserId;
dr["CreatedBy"] = item.CreatedBy;
dt.Rows.Add(dr);
}
QrcDataAccess _qrcAccess = new QrcDataAccess(_iconfiguration, _converter);
DatabaseResponse response = await _qrcAccess.AddQRCUsers(dt, objQRCUserMapping.FirstOrDefault().EmailUrl);
if (response.ResponseCode == (int)DbReturnValue.CreateSuccess)
{
return(Ok(new OperationResponse
{
HasSucceeded = true,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.CreateSuccess),
ReturnedObject = response.Results
}));
}
else
{
Log.Error(EnumExtensions.GetDescription(DbReturnValue.CreationFailed));
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists),
ReturnedObject = response.Results
}));
}
}
else
{
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = false,
Message = EnumExtensions.GetDescription(DbReturnValue.RecordExists),
ReturnedObject = null
}));
}
}
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
}));
}
}
