public ActionResult Edit(abonocapital abonocapital, string empresaId, string creditoId)
{
ModelState.Clear();
abonocapital.CreditoId = Convert.ToInt32(MiUtil.desEncriptar(HttpUtility.UrlDecode(creditoId)));
TryValidateModel(abonocapital);
if (ModelState.IsValid)
{
string ok = "";
var q = @"update cuota a,backup_cuota b
set a.ajusteAbonoCapital=b.ajusteAbonoCapital,
a.ajusteAbonoInteres=b.ajusteAbonoInteres
where a.cuotaid=b.cuotaid";
q = q + " and b.abonocapitalid='" + abonocapital.AbonoCapitalId + "'";
//credito cre = db.credito.Find(Convert.ToInt32(MiUtil.desEncriptar(HttpUtility.UrlDecode(creditoId))));
db.Entry(abonocapital).State = EntityState.Modified;
if (abonocapital.Estado == false)
{
db.Database.ExecuteSqlCommand(q);
}
db.SaveChanges();
return(RedirectToAction("Index", new { creditoId = creditoId }));
//}
//else
// ModelState.AddModelError("", ok);
}
ViewBag.empresaId = empresaId;
ViewBag.creditoId = creditoId;
//new SelectList(db.credito.Where(c => c.Estado == true).OrderBy(e => e.TipoCuotaId), "CreditoId", "TipoCuotaId", abonocapital.CreditoId);
return(View(abonocapital));
}
public ActionResult Create(abonocapital abonocapital, string empresaId, string creditoId)
{
ModelState.Clear();
abonocapital.CreditoId = Convert.ToInt32(MiUtil.desEncriptar(HttpUtility.UrlDecode(creditoId)));
TryValidateModel(abonocapital);
if (ModelState.IsValid)
{
string ok = "";
consecutivo consec = db.consecutivo.Find(Convert.ToInt32(MiUtil.desEncriptar(HttpUtility.UrlDecode(empresaId))));
consec.AbonoCapitalNro = consec.AbonoCapitalNro + 1;
abonocapital.AbonoCapitalNro = consec.AbonoCapitalNro;
credito cre = db.credito.Find(Convert.ToInt32(MiUtil.desEncriptar(HttpUtility.UrlDecode(creditoId))));
List <cuota> cuotas = db.cuota.Where(c => c.CreditoId == abonocapital.CreditoId).ToList();
backup_cuota(abonocapital, cuotas);
ok = cre.abonoACapital(abonocapital.Fecha, abonocapital.Valor);
if (ok == "")
{
db.abonocapital.Add(abonocapital);
db.SaveChanges();
return(RedirectToAction("Index", new { creditoId = creditoId }));
}
else
{
ModelState.AddModelError("", ok);
}
}
ViewBag.empresaId = empresaId;
ViewBag.creditoId = creditoId;
//ViewBag.CreditoId = new SelectList(db.credito.Where(c=>c.Estado==true).OrderBy(e=>e.TipoCuotaId), "CreditoId", "TipoCuotaId", abonocapital.CreditoId);
return(View(abonocapital));
}
public ActionResult DeleteConfirmed(int id)
{
abonocapital abonocapital = db.abonocapital.Find(id);
db.abonocapital.Remove(abonocapital);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: AbonoCapital/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
abonocapital abonocapital = db.abonocapital.Find(id);
if (abonocapital == null)
{
return(HttpNotFound());
}
return(View(abonocapital));
}
// GET: AbonoCapital/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(id));
int intId = Convert.ToInt32(idDecrypted);
abonocapital abonocapital = db.abonocapital.Find(intId);
if (abonocapital == null)
{
return(HttpNotFound());
}
return(View(abonocapital));
}
public void backup_cuota(abonocapital abonocapital, List <cuota> cuotas)
{
// List<cuota> cuotas = db.cuota.Where(c => c.CreditoId == abonocapital.CreditoId).ToList();
foreach (cuota c in cuotas)
{
backup_cuota bak = new backup_cuota
{
CreditoId = c.CreditoId,
CuotaId = c.CuotaId,
Numero = c.Numero,
Fecha = c.Fecha,
AbonoCapital = c.AbonoCapital,
AbonoInteres = c.AbonoInteres,
AjusteAbonoCapital = c.AjusteAbonoCapital,
AjusteAbonoInteres = c.AjusteAbonoInteres,
SaldoCapital = c.SaldoCapital,
SaldoInteres = c.SaldoInteres
};
abonocapital.backup_cuota.Add(bak);
}
}
// GET: AbonoCapital/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
string idDecrypted = MiUtil.desEncriptar(HttpUtility.UrlDecode(id));
int intId = Convert.ToInt32(idDecrypted);
abonocapital abonocapital = db.abonocapital.Find(intId);
if (abonocapital == null)
{
return(HttpNotFound());
}
ViewBag.creditoId = MiUtil.encriptar(abonocapital.CreditoId.ToString());
//new SelectList(db.credito.Where(c=>c.Estado==true).OrderBy(e=>e.TipoCuotaId), "CreditoId", "TipoCuotaId", abonocapital.CreditoId);
credito cr = db.credito.Find(abonocapital.CreditoId);
ViewBag.empresaId = MiUtil.encriptar(cr.EmpresaId.ToString());
return(View(abonocapital));
}
