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