示例#1
0
        public async Task <IActionResult> UpdateAsync([FromBody] PQRSDTO modelDto)
        {
            Response <bool> response = new Response <bool>();

            try
            {
                if (modelDto == null)
                {
                    return(BadRequest());
                }

                response = await _Application.UpdateAsync(modelDto);

                if (response.IsSuccess)
                {
                    return(Ok(response));
                }
                else
                {
                    return(BadRequest(response));
                }
            }
            catch (Exception ex)
            {
                response.Data      = false;
                response.IsSuccess = false;
                response.Message   = ex.Message;

                return(BadRequest(response));
            }
        }
        public PQRSDTO BuscarPorId(int id)
        {
            try {
                Conexion.Abrir();
                string sql = "SELECT TOP(1) * " +
                             "FROM PQRS " +
                             "WHERE PQRSId = " + id;
                SqlCommand    cmd    = new SqlCommand(sql, Conexion.Conn);
                SqlDataReader reader = cmd.ExecuteReader();

                if (reader.Read())
                {
                    PQRSDTO pqrs = new PQRSDTO(
                        Convert.ToInt32(reader["PQRSId"].ToString()),
                        reader["RemitentePQRS"].ToString(),
                        reader["MensajePQRS"].ToString(),
                        new TipoPQRSDAO().BuscarPorId(Convert.ToInt32(reader["TipoPQRSId"].ToString())),
                        new EstadoPQRSDAO().BuscarPorId(Convert.ToInt32(reader["EstadoPQRSId"].ToString()))
                        );
                    pqrs.Respuesta = (reader["RespuestaPQRS"] != null) ? reader["RespuestaPQRS"].ToString() : null;
                    pqrs.Usuario   = (reader["UsuarioId"] != null) ? new UsuarioDAO().BuscarPorId(Convert.ToInt32(reader["UsuarioId"].ToString())) : null;
                    return(pqrs);
                }
                else
                {
                    return(null);
                }
            } catch (SqlException e) {
                Console.WriteLine(e.StackTrace);
                return(null);
            } finally {
                if (Conexion.Conn != null)
                {
                    Conexion.Cerrar();
                }
            }
        }
示例#3
0
        public async Task <Response <bool> > UpdateAsync(PQRSDTO modelDto)
        {
            var response = new Response <bool>();

            try
            {
                var resp = _mapper.Map <PQRS>(modelDto);
                response.Data = await _Domain.UpdateAsync(resp);

                if (response.Data)
                {
                    response.IsSuccess = true;
                    response.Message   = "Registro Exitoso!";
                }
            }
            catch (Exception ex)
            {
                response.Data      = false;
                response.IsSuccess = false;
                response.Message   = ex.Message;
            }

            return(response);
        }
 public void ResponderPQRS(PQRSDTO pqrs)
 {
     throw new NotImplementedException();
 }
 public void Ingresar(PQRSDTO obj)
 {
     throw new NotImplementedException();
 }
 public void Eliminar(PQRSDTO obj)
 {
     throw new NotImplementedException();
 }