public ActionResult Editar([Bind(Include = "Permissao_ID,Permissao_Nome")] RBAC_Permissao rBAC_Permissao)
{
if (ModelState.IsValid)
{
db.Entry(rBAC_Permissao).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rBAC_Permissao));
}
public void AddPermission(CriarPermissaoRBACViewModel permissao)
{
using (NimbusAcad_DB_Entities db = new NimbusAcad_DB_Entities())
{
RBAC_Permissao rbacPermissao = new RBAC_Permissao();
rbacPermissao.Permissao_Nome = permissao.PermissaoNm;
db.RBAC_Permissao.Add(rbacPermissao);
db.SaveChanges();
}
}
public ActionResult NovaPermissao([Bind(Include = "Permissao_ID,Permissao_Nome")] RBAC_Permissao rBAC_Permissao)
{
if (ModelState.IsValid)
{
db.RBAC_Permissao.Add(rBAC_Permissao);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rBAC_Permissao));
}
public ActionResult Deletar(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
RBAC_Permissao rBAC_Permissao = db.RBAC_Permissao.Find(id);
if (rBAC_Permissao == null)
{
return(HttpNotFound());
}
return(View(rBAC_Permissao));
}
public bool IsPermissaoEmPerfil(string nmPerfil, string nmPermissao)
{
using (NimbusAcad_DB_Entities db = new NimbusAcad_DB_Entities())
{
RBAC_Permissao permissao = db.RBAC_Permissao.Where(o => o.Permissao_Nome.ToLower().Equals(nmPermissao)).FirstOrDefault();
if (permissao != null)
{
var perfilRBAC = from q in db.RBAC_Link_Perfil_Permissao
join r in db.RBAC_Perfil
on q.Perfil_ID equals r.Perfil_ID
where r.Perfil_Nome.Equals(nmPerfil) && q.Permissao_ID.Equals(permissao.Permissao_ID)
select r.Perfil_Nome;
if (perfilRBAC != null)
{
return(perfilRBAC.Any());
}
}
return(false);
}
}
public void UpdatePermissao(CriarPermissaoRBACViewModel permissao)
{
using (NimbusAcad_DB_Entities db = new NimbusAcad_DB_Entities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
RBAC_Permissao p = db.RBAC_Permissao.Where(o => o.Permissao_ID == permissao.PermissaoID).FirstOrDefault();
p.Permissao_Nome = permissao.PermissaoNm;
db.Entry(p).State = EntityState.Modified;
db.SaveChanges();
dbContextTransaction.Commit();
}
catch
{
dbContextTransaction.Rollback();
}
}
}
}
