Services

Task<IEnumerable<BiddingParticipant>> GetAll()

return await _context.BiddingParticipants
    .Include(x => x.Master)
    .ToListAsync();

Task<BiddingParticipant> GetById(int? id)

Task<BiddingParticipant> GetByRef(string reference)

Task<BiddingParticipantDTO> Create(BiddingParticipantCreateDTO model)

var participant = await _biddingParticipantService.Create(new BiddingParticipantCreateDTO
{
    NaturalPerson = true,
    Name = "Juan Pérez",
    IdentificationOrNit = "1234567890",
    Phone = "6045551234",
    Cellular = "3001234567",
    Address = "Calle 10 #20-30",
    City = "Santa Fe de Antioquia",
    Email = "[email protected]",
    Proposals = proposalPdfFile,
    MasterId = 5
});

Boolean DuplicaIdentificationOrNit(string identificationOrNit, int masterId)

Task DeleteConfirmed(int id)

Task<IEnumerable<Master>> GetAll()

var blogs = await _context.Masters
    .AsNoTracking()
    .Where(x => x.Blog == true)
    .OrderByDescending(x => x.DateCreate)
    .ToListAsync();

Task<IEnumerable<Master>> LimitHome()

Task<Master> GetById(int? id)

Task<Master> GetById(string urBlog)

Task<BlogDto> Create(BlogCreateDto model)

var blog = await _blogService.Create(new BlogCreateDto
{
    NameBlog = "Nueva Iniciativa 2026",
    Description = "<p>Contenido HTML del artículo...</p>",
    Author = "Comunicaciones ESP",
    CoverPage = imageFile
});
// Creates URL: /noticias/nueva-iniciativa-2026

Task Edit(int id, BlogEditDto model)

bool DuplicaName(string _stringName)

Task DeleteConfirmed(int id)

Task<IEnumerable<Category>> GetAll()

Task<Category> GetById(int? id)

Task<Category> GetById(string nameCategory)

Task<CategoryDto> Create(CategoryCreateDto model)

var category = await _categoryService.Create(new CategoryCreateDto
{
    NameCategory = "Acueducto y Alcantarillado",
    Description = "<p>Servicios de agua potable...</p>",
    CoverPage = imageFile,
    Statud = true
});
// Creates URL: /servicios/acueducto-y-alcantarillado

Task Edit(int id, CategoryEditDto model)

bool CategoryExists(int id)

bool DuplicaName(string _stringName)

Task<IEnumerable<Document>> GetAll()

return await _context.Documents
    .Include(x => x.FileDocument)
    .OrderByDescending(x => x.CreateDate)
    .ToListAsync();

Task<Document> GetById(int? id)

Task<Document> GetById(string _urlName)

Task Create(DocumentCreateDTO model)

await _documentService.Create(new DocumentCreateDTO
{
    Name = "Plan de Desarrollo 2026",
    Description = "Documento oficial del plan...",
    MasterId = 10,
    RouteFile = new List<IFormFile> { file1, file2, file3 }
});

Task<IEnumerable<FileDocument>> FilesDocuments()

Task DeleteConfirmed(int _id)

bool DocumentExists(int id)

bool DuplicaName(string _stringName)

Task Execute(string subject, string htmlBody, string recipientEmail)

services.AddScoped<IBiddingParticipantService, BiddingParticipantService>();
services.AddScoped<IBlogService, BlogService>();
services.AddScoped<ICategoryService, CategoryService>();
services.AddScoped<IDocumentService, DocumentService>();

var dto = _mapper.Map<BiddingParticipantDTO>(entity);
var entity = _mapper.Map<BiddingParticipant>(createDto);

using var transaction = _context.Database.BeginTransaction();
try
{
    // Operations
    transaction.Commit();
}
catch (Exception ex)
{
    transaction.Rollback();
}

Task<IEnumerable<Master>> GetAll()

return await _context.Masters
    .AsNoTracking()
    .Where(x => x.NacionLicitante == true)
    .ToListAsync();

Task<Master> GetById(int? id)

Task<Master> GetById(string nacionLicitante)

Task<NacionLicitanteDto> Details(int? id)

Task Create(NacionLicitanteCreateDto model)

await _nacionLicitante.Create(new NacionLicitanteCreateDto
{
    NameMaster = "Licitación Pública 001-2026",
    Description = "<p>Detalles de la convocatoria...</p>",
    CoverPage = imageFile,
    NacionLicitantegStartDate = new DateTime(2026, 3, 1),
    NacionLicitanteEndDate = new DateTime(2026, 3, 31),
    NacionLicitantegFile = new List<IFormFile> { pdfFile1, pdfFile2 }
});

Task<IEnumerable<FileDocument>> FilesDocuments()

Task<IEnumerable<Document>> DelatedDocuments(int id)

Task DeleteConfirmed(int id)

bool NacionLicitantegExists(int id)

bool DuplicaName(string _stringName)

Task<IEnumerable<Master>> GetAll()

return await _context.Masters
    .AsNoTracking()
    .Where(x => x.Brigade == true)
    .OrderByDescending(x => x.DateCreate)
    .ToListAsync();

Task<Master> GetById(int? id)

Task<Master> GetById(string urBrigade)

Task<BrigadeDto> Details(int? id)

Task<BrigadeDto> Create(BrigadeCreateDto model)

var brigade = await _brigadeService.Create(new BrigadeCreateDto
{
    NameMaster = "Jornada de Salud Barrio Centro",
    Description = "<p>Atención médica gratuita...</p>",
    Author = "Secretaría de Salud",
    DateBrigade = new DateTime(2026, 4, 15),
    CoverPage = imageFile
});
// Creates URL: /brigadas/jornada-de-salud-barrio-centro

Task DeleteConfirmed(int id)

bool BrigadeExists(int id)

bool DuplicaName(string _stringName)

Task<IEnumerable<Employee>> GetAll()

return await _context.Employees
    .AsNoTracking()
    .OrderByDescending(x => x.DateCreate)
    .ToListAsync();

Task<Employee> GetById(int? id)

Task<EmployeeDto> Details(int? id)

Task<EmployeeDto> Create(EmployeeCreateDto model)

var employee = await _employeeService.Create(new EmployeeCreateDto
{
    Name = "María García López",
    Occupation = "Gerente General",
    CoverPage = photoFile
});

Task DeleteConfirmed(int id)

Task<IEnumerable<Product>> GetAll()

Task<Product> GetById(int? id)

Task<ProductDto> Details(int? id)

Task<ProductDto> Details(string urlProduct)

Task<ProductDto> Create(ProductCreateDto model)

var product = await _productService.Create(new ProductCreateDto
{
    Name = "Instalación de Medidores",
    Icono = "icon-meter",  // Becomes "icon-meter.svg"
    Description = "<p>Servicio de instalación...</p>"
});
// Creates URL: /servicios/instalacion-de-medidores

Task DeleteConfirmed(int id)

bool ProductExists(int id)

bool DuplicaName(string _stringName)

IEnumerable<PQRSD> GetAll()

PQRSD GetById(Guid? id)

PQRSDDto Details(Guid? id)

Task<PQRSDDto> Create(PQRSDCreateDto model)

var pqrsd = await _pqrsdService.Create(new PQRSDCreateDto
{
    NamePerson = "Carlos Ramírez",
    Email = "[email protected]",
    PQRSDName = "Solicitud de instalación de servicio",
    Description = "Requiero instalación...",
    NameSotypeOfRequest = "Petición"
});
// Returns PQRSDID (Guid) for tracking

Boolean Review(Guid id, ReviewCreateDto model)

Task DeleteConfirmed(Guid id)

using var transaction = _context.Database.BeginTransaction();
try
{
    // Multiple database operations
    // File uploads
    transaction.Commit();
}
catch (Exception ex)
{
    transaction.Rollback();
}