/// <summary>
/// Nuevo registro en tblPerfil, se agrega solo si el perfil no existe
/// </summary>
/// <param name="perfil"></param>
/// <param name="descripcion"></param>
/// <param name="estado"></param>
/// <returns>True=Registro exitoso || False=Error en registro</returns>
public bool agregar(string perfil, string descripcion, bool estado)
{
bool agrego = false;
try
{
if (existe(perfil) == false)
{
using (var db = new SeguimientoPermanenciaEntities())
{
tblPerfil per = new tblPerfil()
{
perfil = perfil,
descripcion = descripcion,
estado = estado,
};
db.tblPerfil.Add(per);
db.SaveChanges();
}
agrego = true;
}
}catch (Exception ex)
{
agrego = false;
throw ex;
}
return(agrego);
}
public ActionResult DeleteConfirmed(int id)
{
tblPerfil tblPerfil = db.tblPerfil.Find(id);
db.tblPerfil.Remove(tblPerfil);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Perfiles")] tblPerfil tblPerfil)
{
if (ModelState.IsValid)
{
db.Entry(tblPerfil).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(db.tblUsuario, "Id", "Usuario", tblPerfil.Id);
return(View(tblPerfil));
}
public ActionResult Create([Bind(Include = "Id,Perfiles")] tblPerfil tblPerfil)
{
if (ModelState.IsValid)
{
db.tblPerfil.Add(tblPerfil);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Id = new SelectList(db.tblUsuario, "Id", "Usuario", tblPerfil.Id);
return(View(tblPerfil));
}
// GET: Perfiles/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblPerfil tblPerfil = db.tblPerfil.Find(id);
if (tblPerfil == null)
{
return(HttpNotFound());
}
return(View(tblPerfil));
}
// GET: Perfiles/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblPerfil tblPerfil = db.tblPerfil.Find(id);
if (tblPerfil == null)
{
return(HttpNotFound());
}
ViewBag.Id = new SelectList(db.tblUsuario, "Id", "Usuario", tblPerfil.Id);
return(View(tblPerfil));
}
public JsonResult GuardarPerfil(tblPerfil Perfil)
{
JsonResult jr = new JsonResult();
try
{
var Registro = (from p in db.tblPerfil where p.id == Perfil.id select p).FirstOrDefault();
if (Registro == null)
{
if (ModelState.IsValid)
{
db.tblPerfil.Add(Perfil);
db.SaveChanges();
}
}
else
{
Registro.nombre = Perfil.nombre;
if (ModelState.IsValid)
{
db.SaveChanges();
}
}
var Perfiles = (from p in db.tblPerfil select new { p.id, p.nombre }).ToList();
jr.Data = new { Perfiles = Perfiles, Res = true };
return(jr);
}
catch (Exception ex)
{
var Perfiles = (from p in db.tblPerfil select new { p.id, p.nombre }).ToList();
jr.Data = new { Perfiles = Perfiles, Res = false };
return(jr);
}
}
