public ActionResult EliminarClienteConfirmar(int id) { try { using (GOBUSEntities db = new GOBUSEntities()) { if (db.Cita.Where(x => x.ClienteId == id).Count() > 0) { ViewBag.Errorm = true; return(View()); } else { var q = db.Cliente.Find(id); db.Cliente.Remove(q); db.SaveChanges(); } } } catch (SqlException ex) { ViewBag.Message = ex.Message; } return(RedirectToAction("ConsultarClientes")); }
public bool BorrarSucursal(int id) { using (GOBUSEntities db = new GOBUSEntities()) { var query = db.Sucursals.Where(x => x.SucursalId == id).Single(); db.Sucursals.Remove(query); return(db.SaveChanges() > 0); } }
public ActionResult EditarCliente(Cliente c) { using (GOBUSEntities db = new GOBUSEntities()) { if (ModelState.IsValid) { db.Entry(c).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ConsultarClientes")); } return(View(c)); } }
public bool ModificarSucursal(Sucursal s) { using (GOBUSEntities db = new GOBUSEntities()) { db.Sucursals.Attach(s); //permite actualzar el registro //siempre debe incluir el ID del objeto(primary key) db.Entry(s).State = EntityState.Modified; //refrescamos modelo de base de datos return(db.SaveChanges() > 0); } }
public ActionResult ModificarCita(Cita c) { using (GOBUSEntities db = new GOBUSEntities()) { ModelState.Clear(); if (ModelState.IsValid) { db.Cita.Attach(c); db.Entry(c).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ConsultarCitas")); } ViewBag.SucursalId = new SelectList(db.Sucursal, "SucursalId", "Nombre", c.SucursalId).ToList(); ViewBag.ClienteId = new SelectList(db.Cliente, "ClienteId", "Nombre", c.ClienteId).ToList(); return(View(c)); } }
public ActionResult AgregarCita(Cita c) { //[Bind(Include = "CitaId,PlacaNumero,FechaCita,ClienteId,SucursalId")] using (GOBUSEntities db = new GOBUSEntities()) { if (ModelState.IsValid) { db.Cita.Add(c); db.SaveChanges(); ModelState.Clear(); return(RedirectToAction("ConsultarCitas")); } ViewBag.SucursalId = new SelectList(db.Sucursal, "SucursalId", "Nombre", c.SucursalId).ToList(); ViewBag.ClienteId = new SelectList(db.Cliente, "ClienteId", "Nombre", c.ClienteId).ToList(); return(View(c)); } }
public ActionResult EliminarCitaConfirmar(int id) { try { using (GOBUSEntities db = new GOBUSEntities()) { var q = db.Cita.Find(id); db.Cita.Remove(q); db.SaveChanges(); } } catch (SqlException ex) { ViewBag.Message = ex.Message; } return(RedirectToAction("ConsultarCitas")); }
public ActionResult RegistrarSucursal(Sucursal s) { if (ModelState.IsValid) { try { ModelState.Clear(); using (GOBUSEntities db = new GOBUSEntities()) { db.Sucursal.Add(s); db.SaveChanges(); ViewBag.exitoso = true; } }catch (SqlException ex) { ViewBag.Message = ex.Message; } } return(View()); }
public ActionResult AgregarCliente(Cliente c) { if (ModelState.IsValid) { try { ModelState.Clear(); using (GOBUSEntities db = new GOBUSEntities()) { db.Cliente.Add(c); db.SaveChanges(); ViewBag.exitoso = true; } } catch (SqlException ex) { ViewBag.Message = ex.Message; } } return(View()); }