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; }