public static bool Eliminar(int id) { Context context = new Context(); bool found = false; try{ var mora = context.Moras.Find(id); List <MorasDetalle> viejosDetalles = Buscar(mora.MoraId).Detalle; foreach (MorasDetalle d in viejosDetalles) { Prestamos prestamo = PrestamoBLL.Buscar(d.PrestamoId); prestamo.Mora -= d.Valor; PrestamoBLL.Guardar(prestamo); } if (mora != null) { context.Entry(mora).State = EntityState.Deleted; found = context.SaveChanges() > 0; } } catch { throw; } finally{ context.Dispose(); } return(found); }
private static bool Insertar(Moras mora) { Context context = new Context(); bool found = false; try { context.Moras.Add(mora); found = context.SaveChanges() > 0; List <MorasDetalle> detalles = mora.Detalle; foreach (MorasDetalle d in detalles) { Prestamos prestamo = PrestamoBLL.Buscar(d.PrestamoId); prestamo.Mora += d.Valor; PrestamoBLL.Guardar(prestamo); } } catch { throw; } finally{ context.Dispose(); } return(found); }
public static bool Modificar(Moras mora) { Context context = new Context(); bool found = false; try { List <MorasDetalle> viejosDetalles = Buscar(mora.MoraId).Detalle; foreach (MorasDetalle d in viejosDetalles) { Prestamos prestamo = PrestamoBLL.Buscar(d.PrestamoId); prestamo.Mora -= d.Valor; PrestamoBLL.Guardar(prestamo); } context.Database.ExecuteSqlRaw($"delete from MorasDetalle where MoraId = {mora.MoraId}"); foreach (var anterior in mora.Detalle) { context.Entry(anterior).State = EntityState.Added; } List <MorasDetalle> nuevosDetalles = mora.Detalle; foreach (MorasDetalle d in nuevosDetalles) { Prestamos prestamo = PrestamoBLL.Buscar(d.PrestamoId); prestamo.Mora += d.Valor; PrestamoBLL.Guardar(prestamo); } context.Entry(mora).State = EntityState.Modified; found = context.SaveChanges() > 0; } catch { throw; } finally { context.Dispose(); } return(found); }