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());
}
