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