public async Task <DatabaseResponse> UpdateQRCUser(QrcUserMapping qRCUserMapping) { try { SqlParameter[] parameters = { new SqlParameter("@QrcID", SqlDbType.Int), new SqlParameter("@CategoryID", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.Int) }; parameters[0].Value = qRCUserMapping.QRCId; parameters[1].Value = qRCUserMapping.CategoryId; parameters[2].Value = qRCUserMapping.UserId; _DataHelper = new DataAccessHelper("spu_QRCUserMapping", parameters, _configuration); DataTable dt = new DataTable(); int result = await _DataHelper.RunAsync(dt); List <QrcMaster> qrcs = new List <QrcMaster>(); if (dt != null && dt.Rows.Count > 0) { qrcs = (from model in dt.AsEnumerable() select new QrcMaster() { Id = model.Field <int>("Id"), Name = model.Field <string>("Name"), Description = model.Field <string>("Description"), CreatedBy = model.Field <string>("CreatedBy"), CreatedOn = model.Field <DateTime>("CreatedOn"), UpdatedOn = model.Field <DateTime>("UpdatedOn"), UpdatedBy = model.Field <string>("UpdatedBy"), Active = model.Field <bool>("Active") }).ToList(); } return(new DatabaseResponse { ResponseCode = result, Results = qrcs }); } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }
public async Task <IActionResult> UpdateQRCUser(QrcUserMapping qRCUserMapping) { try { QrcDataAccess _qrcAccess = new QrcDataAccess(_iconfiguration, _converter); DatabaseResponse response = await _qrcAccess.UpdateQRCUser(qRCUserMapping); 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 })); } }