Example #1
0
 public AdminController(UsuarioService usuarioService, DocumentoServices documentoServices, IHostingEnvironment hostingEnvironment, ApplicationDbContext context)
 {
     _context            = context;
     _usuarioService     = usuarioService;
     _documentoServices  = documentoServices;
     _hostingEnvironment = hostingEnvironment;
 }
        [HttpGet("GetDocumentos")] // GET api/Documento/GetDocumentos
        public ActionResult GetDocumentos([FromQuery(Name = "PageNumber")] int PageNumber,
                                          [FromQuery(Name = "Rows")] int Rows)
        {
            DocumentoServices    documentoServices = new DocumentoServices();
            List <InfoDocumento> documentos        = documentoServices.returnDocumentos(PageNumber, Rows);
            int total = 0;

            string query = "SELECT COUNT(*) AS 'TOTAL' FROM [adpruebas_de_timbrado].[dbo].[admDocumentos];";

            string connString = DatabaseServices.GetConnString();

            using (SqlConnection sqlConnection = new SqlConnection(connString))
            {
                SqlCommand cmd = new SqlCommand(query, sqlConnection);
                sqlConnection.Open();
                using (SqlDataReader reader = cmd.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        total = reader.GetInt32(0);
                    }
                }
            }

            ListOfDocuments listOfDocuments = new ListOfDocuments(documentos, PageNumber, total);
            string          jsonString;

            jsonString = JsonSerializer.Serialize(listOfDocuments);

            return(Ok(jsonString));
        }
        [HttpPost] // POST api/Documento/
        public ActionResult Post([FromBody] Documento documento)
        {
            DocumentoServices documentoServices = new DocumentoServices();

            if (!documentoServices.createDocumento(documento))
            {
                return(StatusCode(500, documentoServices.errorMessage));
            }

            return(StatusCode(201));
        }
 public HomeController(DocumentoServices documentoServices, IHostingEnvironment hostingEnvironment, ApplicationDbContext context)
 {
     _context            = context;
     _documentoServices  = documentoServices;
     _hostingEnvironment = hostingEnvironment;
 }