public async Task <IActionResult> Post(AnnouncementsCreate announcementsCreate) { try { AnnouncementsDataAccess _notificationsDataAccess = new AnnouncementsDataAccess(_configuration); DatabaseResponse response = await _notificationsDataAccess.PostAsync(announcementsCreate); 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.CreationFailed), 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 <DatabaseResponse> PostAsync(AnnouncementsCreate announcementsCreate) { try { SqlParameter[] parameters = { new SqlParameter("@Text", SqlDbType.NVarChar), new SqlParameter("@CreatedBy", SqlDbType.Int), new SqlParameter("@Active", SqlDbType.Bit), new SqlParameter("@Text_Ar", SqlDbType.NVarChar) }; parameters[0].Value = announcementsCreate.Text; parameters[1].Value = announcementsCreate.CreatedBy; parameters[2].Value = announcementsCreate.Active; parameters[3].Value = announcementsCreate.Text_Ar; _DataHelper = new DataAccessHelper("spi_Announcements", parameters, _configuration); DataTable dt = new DataTable(); int result = await _DataHelper.RunAsync(dt); return(new DatabaseResponse { ResponseCode = result }); } catch (Exception ex) { Log.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical)); throw; } finally { _DataHelper.Dispose(); } }