public void agregarConciliacion(List <Decimal> ids_cupones, TB_Conciliacion objConciliacion) { using (var context = new dbSG2000Entities()) { using (TransactionScope transaction = new TransactionScope()) { objConciliacion.dsUsuario = this._usuarioActivo; objConciliacion.nrCajaAdm = Decimal.Parse(this._cajactiva); objConciliacion.flestado = "A"; objConciliacion.dtModificacion = DateTime.Now; var listadeViajesaConciliar1 = (from c in context.TB_Cupones where ids_cupones.Contains(c.nrCupon) select c ); Console.WriteLine(listadeViajesaConciliar1.ToString()); Trace.TraceInformation(listadeViajesaConciliar1.ToString()); TB_ConciliacionDetalle detalleConciliacion = new TB_ConciliacionDetalle(); double TotalConciliacion = 0.0; foreach (var item in listadeViajesaConciliar1.ToList()) { item.flCobradoalCliente = true; item.dtCobradoalCliente = DateTime.Today; context.TB_ConciliacionDetalle.Add(new TB_ConciliacionDetalle { TB_Conciliacion = objConciliacion, nrCupon = item.nrCupon }); TotalConciliacion = TotalConciliacion + item.vlMontoCupon.Value; } context.TB_Conciliacion.Add(objConciliacion); context.SaveChanges(); GrabarAsientoContable(TotalConciliacion, Decimal.Parse(this._cajactiva), this._usuarioActivo, objConciliacion, context, Conciliacion_de_Viajes, Viajes_con_Tarjeta_a_Bancos); context.SaveChanges(); transaction.Complete(); return; //return listadeViajesaConciliar.ToList(); } } }
public void agregarConciliacion(List<Decimal> ids_cupones, TB_Conciliacion objConciliacion) { using (var context = new dbSG2000Entities()) { using (TransactionScope transaction = new TransactionScope()) { objConciliacion.dsUsuario = this._usuarioActivo; objConciliacion.nrCajaAdm = Decimal.Parse ( this._cajactiva); objConciliacion.flestado = "A"; objConciliacion.dtModificacion = DateTime.Now; var listadeViajesaConciliar1 = (from c in context.TB_Cupones where ids_cupones.Contains(c.nrCupon) select c ); Console.WriteLine(listadeViajesaConciliar1.ToString()); Trace.TraceInformation(listadeViajesaConciliar1.ToString()); TB_ConciliacionDetalle detalleConciliacion = new TB_ConciliacionDetalle(); double TotalConciliacion=0.0; foreach (var item in listadeViajesaConciliar1.ToList()) { item.flCobradoalCliente = true; item.dtCobradoalCliente = DateTime.Today; context.TB_ConciliacionDetalle.Add(new TB_ConciliacionDetalle { TB_Conciliacion = objConciliacion , nrCupon = item.nrCupon }); TotalConciliacion = TotalConciliacion + item.vlMontoCupon.Value ; } context.TB_Conciliacion.Add(objConciliacion); context.SaveChanges(); GrabarAsientoContable(TotalConciliacion, Decimal.Parse(this._cajactiva), this._usuarioActivo, objConciliacion, context, Conciliacion_de_Viajes, Viajes_con_Tarjeta_a_Bancos); context.SaveChanges(); transaction.Complete(); return; //return listadeViajesaConciliar.ToList(); } } }