rolando-r

// Consultas

public async Task<IEnumerable<Empleado>> EmpleadoConMenosDe5Ventas()
    {
        var fechaInicial = new DateTime(2023, 1, 1);
        var fechaFinal = new DateTime(2023, 12, 31);

        var empleadosConMenosDe5Ventas = await _context.Empleados
        .Where(e => e.Ventas
        .Count(v => v.FechaVenta >= fechaInicial && v.FechaVenta <= fechaFinal) < 5)

rolando-r

//Controllers:

[HttpGet("GetAllProveedorConMedicamentoMenos50U")]
    //[Authorize(Roles="")]
    [ProducesResponseType(StatusCodes.Status200OK)]
    [ProducesResponseType(StatusCodes.Status400BadRequest)]

    public async Task<ActionResult<IEnumerable<ProveedorDto>>> GetAllProveedorConMedicamentoMenos50U()
    {
        IEnumerable<Proveedor> Proveedores = await _unitOfWork.Proveedores.ProveedoresMedicamentos();

rolando-r

AspNetCoreRateLimit
AutoMapper.Extensions.Microsoft.DependencyInjection
Microsoft.AspNetCore.Hosting
Microsoft.Extensions.Hosting
Microsoft.AspNetCore.Mvc.Versioning

rolando-r

// API
  Controllers
  Dtos
  Extensions
  Helpers
  Profiles
  Services
  
// Aplicacion
  Repository

rolando-r

// IncidenciasContext

using System.Reflection;
using Dominio;
using Microsoft.EntityFrameworkCore;
namespace Persistencia
{
    public class IncidenciasContext : DbContext
    {
        public IncidenciasContext(DbContextOptions<IncidenciasContext> options) : base(options)

rolando-r

// AreaConfiguration

using Dominio;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata.Builders;

namespace Infrastructure.Data.Configuration;
public class AreaConfiguration : IEntityTypeConfiguration<Area>
{
    public void Configure(EntityTypeBuilder<Area> builder)

rolando-r

// AreaRepository

namespace Dominio.Interfaces;
public interface IAreaRepository : IGenericRepositoryB<Area>
{
    
}

///////////////////////////////////////////////////////////////////////////////////////

rolando-r

// UnitOfWork

using Aplicacion.Repository;
using Dominio;
using Dominio.Interfaces;
using Persistencia;
namespace Aplicacion.UnitOfWork
{
    public class UnitOfWork : IUnitOfWork, IDisposable
    {

rolando-r

//AreaRepository

using Dominio;
using Dominio.Interfaces;
using Microsoft.EntityFrameworkCore;
using Persistencia;

namespace Aplicacion.Repository
{
    public class AreaRepository : GenericRepositoryB<Area>, IAreaRepository

rolando-r

using System.Reflection;
using System.Text;
using ApiIncidencias.Extensions;
using AspNetCoreRateLimit;
using Microsoft.AspNetCore.Authentication.JwtBearer;
using Microsoft.EntityFrameworkCore;
using Microsoft.IdentityModel.Tokens;
using Persistencia;

var builder = WebApplication.CreateBuilder(args);