public ActionResult DeleteConfirmed(int id)
{
BANCOS bANCOS = db.BANCOS.Find(id);
db.BANCOS.Remove(bANCOS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "ID,NOMBRE,CUENTA,SALDO")] BANCOS bANCOS)
{
if (ModelState.IsValid)
{
db.BANCOS.Add(bANCOS);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bANCOS));
}
// GET: BANCOS/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BANCOS bANCOS = db.BANCOS.Find(id);
if (bANCOS == null)
{
return(HttpNotFound());
}
return(View(bANCOS));
}
public ActionResult AgregarSaldo([Bind(Include = "ID,SALDO")] BANCOS bANCOS)
{
var con = new SqlConnection("Data Source=DESKTOP-I5C9AA0\\SQLEXPRESS2008;Initial Catalog=InventarioUXBD;Integrated Security=True");
con.Open();
int id = bANCOS.ID;
double saldo = bANCOS.SALDO;
var command = new SqlCommand("UPDATE BANCOS SET SALDO = " + saldo + " WHERE ID=" + id + "", con);
command.ExecuteNonQuery();
string fecha = "" + DateTime.Now.Day + "/" + DateTime.Now.Month + "/" + DateTime.Now.Year + "";
var command2 = new SqlCommand("INSERT INTO BANCO_SALDOS (SALDO, FECHA_SALDO, ID_BANCO) VALUES (" + saldo + ", " + fecha + "," + id + ")", con);
command2.ExecuteNonQuery();
return(RedirectToAction("Index"));
}
