public async Task <IActionResult> Historial(RecargaSearch filtro)
{
var semana = filtro.semana;
var year = filtro.year;
var s = $"{year}-W{semana}";
var textsemana = semana < 10 ? $"0{semana}" : semana.ToString();
ViewBag.Semana = $"{year}-W{textsemana}";
ViewBag.Numero = filtro.numero;
ViewBag.PrimerDiaSemana = s.FirstDateOfWeek().AddDays(0).ToEasternStandardTime().ToString("dddd, dd MMMM yyyy", CultureInfo.CreateSpecificCulture("es-ES"));
ViewBag.UltimoDiaSemana = s.FirstDateOfWeek().AddDays(6).ToEasternStandardTime().ToString("dddd, dd MMMM yyyy", CultureInfo.CreateSpecificCulture("es-ES"));
var model = await _context.RT_Recargas.Where(x => x.idCuenta == Logged.IdCuenta && x.status == RecargaStatus.success && x.year == year && x.semana == semana).ToListAsync();
if (!string.IsNullOrEmpty(filtro.numero))
{
model = await _context.RT_Recargas.Where(x => x.idCuenta == Logged.IdCuenta && x.status == RecargaStatus.success && x.year == year && x.semana == semana && x.numero.Contains(filtro.numero)).ToListAsync();
}
if (model.Any())
{
ViewBag.TotalPagado = model.Sum(x => x.monto);
ViewBag.TotalRecibido = model.Sum(x => x.recibe);
}
return(View(model));
}
public async Task <IActionResult> Facturacion(RecargaSearch filtro)
{
IsLogged();
var semana = filtro.semana;
var year = filtro.year;
ViewBag.Semana = filtro.input;
var s = $"{year}-W{semana}";
ViewBag.PrimerDiaSemana = s.FirstDateOfWeek().AddDays(0).ToEasternStandardTime().ToString("dddd, dd MMMM yyyy", CultureInfo.CreateSpecificCulture("es-ES"));
ViewBag.UltimoDiaSemana = s.FirstDateOfWeek().AddDays(6).ToEasternStandardTime().ToString("dddd, dd MMMM yyyy", CultureInfo.CreateSpecificCulture("es-ES"));
var model = new Facturacion();
var recargas = await _context.RT_Recargas.Where(x => x.idCuenta == Logged.IdCuenta && x.status == RecargaStatus.success && x.year == year && x.semana == semana).ToListAsync();
model.Recargas = recargas;
var cuentas = await _context.RT_Cuentas.Where(x => x.IdCuentaPadre == Logged.IdCuenta).ToListAsync();
model.cuentas = cuentas;
foreach (var item in model.cuentas)
{
item.Recargas = await _context.RT_Recargas.Where(x => x.idCuenta == item.IdCuenta && x.status == RecargaStatus.success && x.year == year && x.semana == semana).ToListAsync();
}
return(View(model));
}
public async Task <IActionResult> Index(RecargaSearch filtro)
{
var semana = filtro.semana;
var year = filtro.year;
var s = $"{year}-W{semana}";
var textsemana = semana < 10 ? $"0{semana}" : semana.ToString();
ViewBag.Semana = $"{year}-W{textsemana}";
ViewBag.Numero = filtro.numero;
ViewBag.PrimerDiaSemana = s.FirstDateOfWeek().AddDays(0).ToEasternStandardTime().ToString("dddd, dd MMMM yyyy", CultureInfo.CreateSpecificCulture("es-ES"));
ViewBag.UltimoDiaSemana = s.FirstDateOfWeek().AddDays(6).ToEasternStandardTime().ToString("dddd, dd MMMM yyyy", CultureInfo.CreateSpecificCulture("es-ES"));
var vendedores = await _context.RT_Cuentas.Where(x => x.IdCuentaPadre == Logged.IdCuenta).ToListAsync();
foreach (var item in vendedores)
{
item.Recargas = await _context.RT_Recargas.Where(x => x.idCuenta == item.IdCuenta && x.status == RecargaStatus.success && x.year == year && x.semana == semana).ToListAsync();
item.Subvendedores = await _context.RT_Cuentas.Where(x => x.IdCuentaPadre == item.IdCuenta).ToListAsync();
foreach (var subvendedor in item.Subvendedores)
{
subvendedor.Recargas = await _context.RT_Recargas.Where(x => x.idCuenta == subvendedor.IdCuenta && x.status == RecargaStatus.success && x.year == year && x.semana == semana).ToListAsync();
}
}
ViewBag.Vendedores = vendedores;
return(View());
}
public async Task <IActionResult> Index(RecargaSearch filtro)
{
var semana = filtro.semana;
var year = filtro.year;
var s = $"{year}-W{semana}";
var textsemana = semana < 10 ? $"0{semana}" : semana.ToString();
ViewBag.Semana = $"{year}-W{textsemana}";
ViewBag.Numero = filtro.numero;
var primerdia = s.FirstDateOfWeek().AddDays(0).ToEasternStandardTime();
var ultimodia = s.FirstDateOfWeek().AddDays(6).ToEasternStandardTime();
ViewBag.PrimerDiaSemana = primerdia.ToString("dddd, dd MMMM yyyy", CultureInfo.CreateSpecificCulture("es-ES"));
ViewBag.UltimoDiaSemana = ultimodia.ToString("dddd, dd MMMM yyyy", CultureInfo.CreateSpecificCulture("es-ES"));
var model = await _context.RT_Movimientos.Where(x => x.fecha >= primerdia && x.fecha <= ultimodia).ToListAsync();
if (filtro.idCuenta.HasValue)
{
model = await _context.RT_Movimientos.Where(x => x.idUserLogged == filtro.idCuenta && x.fecha >= primerdia && x.fecha <= ultimodia).ToListAsync();
}
foreach (var item in model)
{
var userLog = _context.RT_Cuentas.Where(x => x.IdCuenta == item.idUserLogged).FirstAsync().Result.Nombre;
var cuenta = _context.RT_Cuentas.Where(x => x.IdCuenta == item.idCuenta).FirstAsync().Result.Nombre;
item.UsuarioLoggado = userLog;
item.Cuenta = cuenta;
}
ViewBag.Cuentas = await _context.RT_Cuentas.Where(x => x.Rol == RolesSistema.Administrador.ToString() || x.Rol == RolesSistema.Vendedor.ToString()).ToListAsync();
return(View(model.OrderByDescending(x => x.fecha).ThenBy(x => x.UsuarioLoggado).ToList()));
}
