public ActionResult Create([Bind(Include = "Id,id_compra,fecha_limite,abono_inicial")] tblCxP tblCxP)
{
UpdateEstadosCxP();
if (ModelState.IsValid)
{
if (tblCxP.fecha_limite >= DateTime.Now)
{
tblCxP.estado = "Activo";
}
else
{
tblCxP.estado = "Vencido";
}
tblCxP.abonado = tblCxP.abono_inicial;
db.tblCxP.Add(tblCxP);
db.tblPagos.Add(new tblPagos
{
id_cxp = tblCxP.Id,
fecha = db.tblCompra.Find(tblCxP.id_compra).fecha,
abono = tblCxP.abono_inicial
});
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_compra = new SelectList(db.tblCompra, "Id", "Id", tblCxP.id_compra);
return(View(tblCxP));
}
public ActionResult DeleteConfirmed(int id)
{
tblCxP tblCxP = db.tblCxP.Find(id);
db.tblPagos.RemoveRange(db.tblPagos.Where(p => p.id_cxp == id));
db.tblCxP.Remove(tblCxP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: CxP/Details/5
public ActionResult Details(int?id)
{
UpdateEstadosCxP();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblCxP tblCxP = db.tblCxP.Find(id);
if (tblCxP == null)
{
return(HttpNotFound());
}
return(View(tblCxP));
}
// GET: CxP/Edit/5
public ActionResult Edit(int?id)
{
UpdateEstadosCxP();
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblCxP tblCxP = db.tblCxP.Find(id);
if (tblCxP == null)
{
return(HttpNotFound());
}
ViewBag.id_compra = new SelectList(db.tblCompra.Where(c => c.Id == tblCxP.id_compra || c.id_metodopago == 2 && !db.tblCxP.Where(p => p.id_compra == c.Id).Any()), "Id", "Id", tblCxP.id_compra);
return(View(tblCxP));
}
public ActionResult Edit([Bind(Include = "Id,id_compra,fecha_limite,abono_inicial")] tblCxP tblCxP)
{
if (ModelState.IsValid)
{
if (tblCxP.fecha_limite >= DateTime.Now)
{
tblCxP.estado = "Activo";
}
else
{
tblCxP.estado = "Vencido";
}
db.Entry(tblCxP).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_compra = new SelectList(db.tblCompra, "Id", "Id", tblCxP.id_compra);
return(View(tblCxP));
}
