Example #1
0
        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();
            }
        }