public async Task <IActionResult> CloseSale(int?transId)
{
var transHeader = await this._context.TransaccionHeaders.AsNoTracking().Include(t => t.TransDetails).AsNoTracking().Include(t => t.Recibos).AsNoTracking().FirstOrDefaultAsync(t => t.TransID == transId);
if (transHeader != null)
{
TransaccionHeaderHist histHeader = new TransaccionHeaderHist()
{
TransID = transHeader.TransID,
VendedorID = transHeader.VendedorID,
ClienteID = transHeader.ClienteID,
SedeID = transHeader.SedeID,
EmpresaID = transHeader.EmpresaID,
TipoPago = transHeader.TipoPago,
TipoTransaccion = transHeader.TipoTransaccion,
Fecha = transHeader.Fecha,
Eliminada = transHeader.Eliminada,
AceptadaHacienda = transHeader.AceptadaHacienda,
ClaveHacienda = transHeader.ClaveHacienda,
EnviadaHacienda = transHeader.EnviadaHacienda,
ConsecutivoHacienda = transHeader.ConsecutivoHacienda
};
//Create Details
List <TransaccionDetailHist> histDetails = new List <TransaccionDetailHist>();
transHeader.TransDetails.ToList().ForEach(detail =>
{
TransaccionDetailHist histDetail = new TransaccionDetailHist()
{
ID = detail.ID,
TransID = detail.TransID,
VINVehiculo = detail.VINVehiculo,
PrecioAcordado = detail.PrecioAcordado
};
histDetails.Add(histDetail);
//Set ApartadoYN = false
Vehiculo vehiculo = this._context.Vehiculos.AsNoTracking().FirstOrDefault(v => v.VIN == detail.VINVehiculo);
if (vehiculo != null)
{
vehiculo.ApartadoYN = true;
vehiculo.VendidoYN = true;
this._context.Vehiculos.Update(vehiculo);
this._context.SaveChanges();
}
});
//Create Receipts
List <ReciboHist> histReceipts = new List <ReciboHist>();
transHeader.Recibos.ToList().ForEach(recibo =>
{
ReciboHist histReceipt = new ReciboHist()
{
ID = recibo.ID,
TransID = recibo.TransID,
Descripcion = recibo.Descripcion,
Abono = recibo.Abono,
Fecha = recibo.Fecha
};
histReceipts.Add(histReceipt);
});
List <Comision> comisiones = await this._context.Comisiones.Where(c => c.TransID == transId).ToListAsync();
List <ComisionHist> histComm = new List <ComisionHist>();
comisiones.ForEach(comm =>
{
ComisionHist hist = new ComisionHist()
{
ID = comm.ID,
Descripcion = comm.Descripcion,
Monto = comm.Monto,
Nombre = comm.Nombre,
TipoComision = comm.TipoComision,
TransID = comm.TransID
};
histComm.Add(hist);
});
//Update Header
await this._context.TransHistoryHeader.AddRangeAsync(histHeader);
//Update Details
await this._context.TransDetailHistory.AddRangeAsync(histDetails);
//Update Receipts
await this._context.ReciboHistory.AddRangeAsync(histReceipts);
//Update Commission Receipts
await this._context.ComisionHistory.AddRangeAsync(histComm);
await _context.SaveChangesAsync();
this._context.TransaccionDetails.RemoveRange(transHeader.TransDetails);
this._context.Recibos.RemoveRange(transHeader.Recibos);
this._context.TransaccionHeaders.Remove(transHeader);
this._context.Comisiones.RemoveRange(comisiones);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(NotFound());
}
public async Task <IActionResult> CloseReserve(int?transId)
{
var transHeader = await this._context.TransaccionHeaders.AsNoTracking().Include(t => t.TransDetails).AsNoTracking().Include(t => t.Recibos).AsNoTracking().FirstOrDefaultAsync(t => t.TransID == transId);
if (transHeader != null)
{
TransaccionHeaderHist histHeader = new TransaccionHeaderHist()
{
TransID = transHeader.TransID,
VendedorID = transHeader.VendedorID,
ClienteID = transHeader.ClienteID,
SedeID = transHeader.SedeID,
EmpresaID = transHeader.EmpresaID,
TipoPago = transHeader.TipoPago,
TipoTransaccion = transHeader.TipoTransaccion,
Fecha = transHeader.Fecha,
Eliminada = transHeader.Eliminada
};
//Create Details
List <TransaccionDetailHist> histDetails = new List <TransaccionDetailHist>();
transHeader.TransDetails.ToList().ForEach(detail =>
{
TransaccionDetailHist histDetail = new TransaccionDetailHist()
{
ID = detail.ID,
TransID = detail.TransID,
VINVehiculo = detail.VINVehiculo,
PrecioAcordado = detail.PrecioAcordado
};
histDetails.Add(histDetail);
//Set ApartadoYN = false
Vehiculo vehiculo = this._context.Vehiculos.AsNoTracking().FirstOrDefault(v => v.VIN == detail.VINVehiculo);
if (vehiculo != null)
{
vehiculo.ApartadoYN = false;
this._context.Vehiculos.Update(vehiculo);
this._context.SaveChanges();
}
});
//Create Receipts
List <ReciboHist> histReceipts = new List <ReciboHist>();
transHeader.Recibos.ToList().ForEach(recibo =>
{
ReciboHist histReceipt = new ReciboHist()
{
ID = recibo.ID,
TransID = recibo.TransID,
Descripcion = recibo.Descripcion,
Abono = recibo.Abono,
Fecha = recibo.Fecha
};
histReceipts.Add(histReceipt);
});
//Update Header
await this._context.TransHistoryHeader.AddAsync(histHeader);
//Update Details
await this._context.TransDetailHistory.AddRangeAsync(histDetails);
//Update Receipts
await this._context.ReciboHistory.AddRangeAsync(histReceipts);
await _context.SaveChangesAsync();
this._context.TransaccionDetails.RemoveRange(transHeader.TransDetails);
this._context.Recibos.RemoveRange(transHeader.Recibos);
this._context.TransaccionHeaders.Remove(transHeader);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(NotFound());
}
