public List <Sucursal> ConsultarSucursales() { using (GOBUSEntities db = new GOBUSEntities()) { return(db.Sucursals.ToList()); } }
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); } }
// GET: Cita public ActionResult AgregarCita() { using (GOBUSEntities db = new GOBUSEntities()) { ViewBag.SucursalId = new SelectList(db.Sucursal, "SucursalId", "Nombre").ToList(); ViewBag.ClienteId = new SelectList(db.Cliente, "ClienteId", "Nombre").ToList(); return(View()); } }
// GET: Sucursal public ActionResult ConsultarSucursal() { List <Sucursal> ls = new List <Sucursal>(); using (GOBUSEntities db = new GOBUSEntities()) { ls = db.Sucursal.ToList(); } return(View(ls)); }
public ActionResult ConsultarCita(int id = 0) { Cita c = new Cita(); using (GOBUSEntities db = new GOBUSEntities()) { c = db.Cita.Find(id); return(View(c)); } }
public ActionResult ConsultarClientes() { List <Cliente> lc = new List <Cliente>(); using (GOBUSEntities db = new GOBUSEntities()) { lc = db.Cliente.ToList(); } return(View(lc)); }
// GET: Cliente public ActionResult ConsultarCliente(int id = 0) { Cliente c = new Cliente(); using (GOBUSEntities db = new GOBUSEntities()) { c = db.Cliente.Find(id); return(View(c)); } }
public ActionResult EditarCliente(int?id) { using (GOBUSEntities db = new GOBUSEntities()) { Cliente c = db.Cliente.Find(id); if (c == null) { return(HttpNotFound()); } return(View(c)); } }
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(int?id) { using (GOBUSEntities db = new GOBUSEntities()) { Cita c = db.Cita.Find(id); if (c == null) { return(HttpNotFound()); } 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 EliminarCita(int?id) { using (GOBUSEntities db = new GOBUSEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Cita c = db.Cita.Find(id); if (c == null) { return(HttpNotFound()); } return(View(c)); } }
public ActionResult BorrarSucursal(int?id) { using (GOBUSEntities db = new GOBUSEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Sucursal s = db.Sucursal.Find(id); if (s == null) { return(HttpNotFound()); } return(View(s)); } }
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 ConsultarCitas() { using (GOBUSEntities db = new GOBUSEntities()) { var q = (from cita in db.Cita join cliente in db.Cliente on cita.ClienteId equals cliente.ClienteId join sucursal in db.Sucursal on cita.SucursalId equals sucursal.SucursalId select new UnionCitaSucursalCliente() { CitaId = cita.CitaId, NombreCliente = cliente.Nombre, ApellidosCliente = cliente.Apellidos, NombreSucursal = sucursal.Nombre, FechaCita = cita.FechaCita, Placas = cita.PlacaNumero }).ToList(); return(View(q)); } }
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()); }