public ActionResult Edit(int id)
{
try
{
using (var db = new ReservacionesEntities())
{
//Alumno al = db.Alumno.Where(a => a.id == id).FirstOrDefault();
Motivo al2 = db.Motivoes.Find(id);
return(View(al2));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error al Editar al Alumno", ex);
return(View());
}
}
public ActionResult Details(Auditoria al)
{
try
{
using (var db = new ReservacionesEntities())
{
Auditoria alu = db.Auditorias.Find(al.Id);
return(View(alu));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error al Encontrar Historial", ex);
return(View());
}
}
public ActionResult Index()
{
try
{
string sql = @"SELECT Usuario.Cedula AS IDusuario, Auditoria.Fecha, Auditoria.Descripcion,
Auditoria.TbAuditoria, Auditoria.Hora FROM Auditoria
INNER JOIN Usuario ON Auditoria.IdUsuario = Usuario.Cedula";
using (var db = new ReservacionesEntities())
{
return(View(db.Database.SqlQuery <CEAuditoria>(sql).ToList()));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Index()
{
try
{
string sql = @"SELECT *FROM Roles";
using (var db = new ReservacionesEntities())
{
/*var K = db.Usuarios.Single(u => u.Estado == "1");
* if (K != null)
* {
* Auditoria(K.Cedula, "Rol", "VISUALIZO LISTA DE ROLES");
* }*/
return(View(db.Database.SqlQuery <Role>(sql).ToList()));
}
}
catch (Exception)
{
throw;
}
}
// GET: Escuela
public ActionResult Index()
{
try
{
string sql = @"SELECT *FROM Profesion";
using (var db = new ReservacionesEntities())
{
var K = db.Usuarios.Single(u => u.Estado == "1");
if (K != null)
{
Auditoria(K.Cedula, "Profesion", "VISUALIZO LISTA DE PROFESIONES");
}
return(View(db.Database.SqlQuery <Profesion>(sql).ToList()));
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Details(Role al)
{
try
{
using (var db = new ReservacionesEntities())
{
Role alu = db.Roles.Find(al.Id);
var K = db.Usuarios.Single(u => u.Estado == "1");
if (K != null)
{
Auditoria(K.Cedula, "Rol", "DETALLE DE ROLES");
}
return(View(alu));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error al Encontrar al Usuario", ex);
return(View());
}
}
public ActionResult Delete(Reserva usu)
{
try
{
using (var db = new ReservacionesEntities())
{
usu = db.Reservas.Find(usu.Id);
db.Reservas.Remove(usu);
var K = db.Usuarios.Single(u => u.Estado == "1");
if (K != null)
{
Auditoria(K.Cedula, "Reserva", "ELIMINO UNA RESERVA");
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch
{
return(View());
}
}
