private void InitializeTransactionComponents()
{
this.db = new Models.V1.Database.CodeFirst();
this.transaction = new Transaction()
{
Db = this.db
};
this.customerTransaction = new CustomerTransaction()
{
TransactionToDb = this.transaction
};
}
public void RecalculateCostByNullification(
ref Sadara.Models.V1.POCO.Kardex currentPostItemKardex,
ref Sadara.Models.V1.POCO.Kardex itemKardexToRemove,
ref Sadara.Models.V1.Database.CodeFirst db,
ref decimal accumulatedCostToDebit,
ref decimal accumulatedCostToAcredit
)
{
string serieId = currentPostItemKardex.IDSERIE;
string nDocumento = currentPostItemKardex.N_DOCUMENTO;
string existenciaId = currentPostItemKardex.IDEXISTENCIA;
switch (currentPostItemKardex.OPERACION)
{
case "COMPRA CONTADO":
case "COMPRA CREDITO":
this.RecalculateQuantityToDebit(ref currentPostItemKardex, ref itemKardexToRemove, ref accumulatedCostToDebit, ref accumulatedCostToAcredit);
break;
case "VENTA CONTADO":
case "VENTA CREDITO":
this.RecalculateQuantityToAcredit(ref currentPostItemKardex, ref itemKardexToRemove, ref accumulatedCostToDebit, ref accumulatedCostToAcredit, true);
var saleDetail = (from c in db.Ventas
join d in db.VentasDetalles on c.IDVENTA equals d.IDVENTA
where c.IDSERIE == serieId && c.CONSECUTIVO == nDocumento && d.IDEXISTENCIA == existenciaId
select d).FirstOrDefault();
if (saleDetail != null)
{
//aquí se calcula el costo
if (saleDetail.CMONEDA.Equals(this.CordobaLabel))
{
saleDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO :
currentPostItemKardex.COSTO_PROMEDIO * currentPostItemKardex.TAZACAMBIO);
}
else
{
saleDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO / currentPostItemKardex.TAZACAMBIO :
currentPostItemKardex.COSTO_PROMEDIO);
}
db.Entry(saleDetail).State = EntityState.Modified;
}
break;
case "ENTRADA":
this.RecalculateQuantityToDebit(ref currentPostItemKardex, ref itemKardexToRemove, ref accumulatedCostToDebit, ref accumulatedCostToAcredit, true);
var entryDetail = (from c in db.Entradas
join d in db.EntradasDetalles on c.IDENTRADA equals d.IDENTRADA
where c.IDSERIE == serieId && c.CONSECUTIVO == nDocumento && d.IDEXISTENCIA == existenciaId
select d).FirstOrDefault();
if (entryDetail != null)
{
//aquí se calcula el costo
if (entryDetail.CMONEDA.Equals(this.CordobaLabel))
{
entryDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO :
currentPostItemKardex.COSTO_PROMEDIO * currentPostItemKardex.TAZACAMBIO);
}
else
{
entryDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO / currentPostItemKardex.TAZACAMBIO :
currentPostItemKardex.COSTO_PROMEDIO);
}
db.Entry(entryDetail).State = EntityState.Modified;
}
break;
case "SALIDA":
this.RecalculateQuantityToAcredit(ref currentPostItemKardex, ref itemKardexToRemove, ref accumulatedCostToDebit, ref accumulatedCostToAcredit, true);
var outputDetail = (from c in db.Salidas
join d in db.SalidasDetalles on c.IDSALIDA equals d.IDSALIDA
where c.IDSERIE == serieId && c.CONSECUTIVO == nDocumento && d.IDEXISTENCIA == existenciaId
select d).FirstOrDefault();
if (outputDetail != null)
{
//aquí se calcula el costo
if (outputDetail.CMONEDA.Equals(this.CordobaLabel))
{
outputDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO :
currentPostItemKardex.COSTO_PROMEDIO * currentPostItemKardex.TAZACAMBIO);
}
else
{
outputDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO / currentPostItemKardex.TAZACAMBIO :
currentPostItemKardex.COSTO_PROMEDIO);
}
db.Entry(outputDetail).State = EntityState.Modified;
}
break;
case "TRASLADO":
if (currentPostItemKardex.DEBER > 0)
{
this.RecalculateQuantityToDebit(ref currentPostItemKardex, ref itemKardexToRemove, ref accumulatedCostToDebit, ref accumulatedCostToAcredit, true);
}
if (currentPostItemKardex.HABER > 0)
{
this.RecalculateQuantityToAcredit(ref currentPostItemKardex, ref itemKardexToRemove, ref accumulatedCostToDebit, ref accumulatedCostToAcredit, true);
}
var transferDetail = (from c in db.Traslados
join d in db.TrasladosDetalles on c.IDTRASLADO equals d.IDTRASLADO
where c.IDSERIE == serieId && c.CONSECUTIVO == nDocumento && d.IDEXISTENCIA == existenciaId
select d).FirstOrDefault();
if (transferDetail != null)
{
//aquí se calcula el costo
if (transferDetail.CMONEDA.Equals(this.CordobaLabel))
{
transferDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO :
currentPostItemKardex.COSTO_PROMEDIO * currentPostItemKardex.TAZACAMBIO);
}
else
{
transferDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO / currentPostItemKardex.TAZACAMBIO :
currentPostItemKardex.COSTO_PROMEDIO);
}
db.Entry(transferDetail).State = EntityState.Modified;
}
break;
case "DEVOLUCION VENTA":
this.RecalculateQuantityToDebit(ref currentPostItemKardex, ref itemKardexToRemove, ref accumulatedCostToDebit, ref accumulatedCostToAcredit, true);
var saleReturnDetail = (from c in db.VentasDevoluciones
join d in db.VentasDevolucionesDetalles on c.IDDEVOLUCION equals d.IDDEVOLUCION
where c.IDSERIE == serieId && c.CONSECUTIVO == nDocumento && d.IDEXISTENCIA == existenciaId
select d).FirstOrDefault();
if (saleReturnDetail != null)
{
//aquí se calcula el costo
if (saleReturnDetail.CMONEDA.Equals(this.CordobaLabel))
{
saleReturnDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO :
currentPostItemKardex.COSTO_PROMEDIO * currentPostItemKardex.TAZACAMBIO);
}
else
{
saleReturnDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO / currentPostItemKardex.TAZACAMBIO :
currentPostItemKardex.COSTO_PROMEDIO);
}
db.Entry(saleReturnDetail).State = EntityState.Modified;
}
break;
case "DEVOLUCION COMPRA":
this.RecalculateQuantityToAcredit(ref currentPostItemKardex, ref itemKardexToRemove, ref accumulatedCostToDebit, ref accumulatedCostToAcredit, true);
var purchaseReturnDetail = (from c in db.ComprasDevoluciones
join d in db.ComprasDevolucionesDetalles on c.IDDEVOLUCION equals d.IDDEVOLUCION
where c.IDSERIE == serieId && c.CONSECUTIVO == nDocumento && d.IDEXISTENCIA == existenciaId
select d).FirstOrDefault();
if (purchaseReturnDetail != null)
{
//aquí se calcula el costo
if (purchaseReturnDetail.CMONEDA.Equals(this.CordobaLabel))
{
purchaseReturnDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO :
currentPostItemKardex.COSTO_PROMEDIO * currentPostItemKardex.TAZACAMBIO);
}
else
{
purchaseReturnDetail.COSTO = (currentPostItemKardex.CMONEDA.Equals(this.CordobaLabel) ?
currentPostItemKardex.COSTO_PROMEDIO / currentPostItemKardex.TAZACAMBIO :
currentPostItemKardex.COSTO_PROMEDIO);
}
db.Entry(purchaseReturnDetail).State = EntityState.Modified;
}
break;
}
}