private void btnEditar_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtRol.Text))
{
MessageBox.Show("Debe de llenar los campos", "Completar", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
try
{
using (SICOVE1Entities2 db = new SICOVE1Entities2())
{
string Id = dgvRoles.CurrentRow.Cells[0].Value.ToString();
int IdC = int.Parse(Id);
roles = db.tb_Roles.Where(VerificarId => VerificarId.IdRol == IdC).First();
roles.Nombre = txtRol.Text;
db.Entry(roles).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
MessageBox.Show("El Rol se ha Actuliazado con éxito");
dgvRoles.Rows.Clear();
cargardatos();
txtRol.Clear();
txtRol.Focus();
btnGuardar.Enabled = true;
btnNuevo.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("Algo salio mal " + ex.ToString());
}
}
}
private void btnEminiar_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtRol.Text))
{
MessageBox.Show("Debe de llenar los campos", "Completar", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
else
{
try
{
using (SICOVE1Entities2 db = new SICOVE1Entities2())
{
string Id = dgvRoles.CurrentRow.Cells[0].Value.ToString();
roles = db.tb_Roles.Find(int.Parse(Id));
db.tb_Roles.Remove(roles);
db.SaveChanges();
}
MessageBox.Show("El Rol se ha Eliminado con éxito");
dgvRoles.Rows.Clear();
cargardatos();
txtRol.Clear();
txtRol.Focus();
btnNuevo.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show("Algo salio mal " + ex.ToString());
}
}
}
public ActionResult DeleteConfirmed(int id)
{
tb_Roles tb_Roles = db.tb_Roles.Find(id);
db.tb_Roles.Remove(tb_Roles);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(tb_Roles entity)
{
if (ModelState.IsValid)
{
Dao.Update(entity);
}
return(View(entity));
}
public ActionResult Add(tb_Roles entity)
{
if (ModelState.IsValid)
{
Dao.Insert(entity);
return(RedirectToAction("Index"));
}
return(View(entity));
}
public ActionResult Edit([Bind(Include = "RoleID,RoleName")] tb_Roles tb_Roles)
{
if (ModelState.IsValid)
{
db.Entry(tb_Roles).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tb_Roles));
}
public ActionResult CreateRole([Bind(Include = "RoleID,RoleName")] tb_Roles Roles)
{
if (ModelState.IsValid)
{
db.tb_Roles.Add(Roles);
db.SaveChanges();
return(RedirectToAction("CreateMemberRoles"));
}
return(View(Roles));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tb_Roles tb_Roles = db.tb_Roles.Find(id);
if (tb_Roles == null)
{
return(HttpNotFound());
}
return(View(tb_Roles));
}
/// <summary>
/// 根据角色ID删除角色
/// </summary>
/// <param name="roleID">角色ID</param>
public static void DeleteRole(long roleID)
{
try
{
tb_Roles role = DataContext.tb_Roles.Where(t => t.RoleID == roleID).FirstOrDefault();
DataContext.tb_Roles.DeleteObject(role);
DataContext.SaveChanges();
}
catch (Exception ex)
{
LogHelper.g_Logger.ErrorFormat("删除角色失败！错误信息：{0}", ex.Message);
throw ex;
}
}
/// <summary>
/// 根据角色ID修改角色基本内容
/// </summary>
/// <param name="roleID"></param>
/// <param name="roleName"></param>
/// <param name="memo"></param>
public static void UpdateRole(long roleID, string roleName, string memo)
{
try
{
tb_Roles role = GetRoleByID(roleID);
role.RoleName = roleName;
role.Memo = memo;
DataContext.SaveChanges();
}
catch (Exception ex)
{
LogHelper.g_Logger.ErrorFormat("修改角色失败！错误信息：{0}", ex.Message);
throw ex;
}
}
/// <summary>
/// 添加新的角色
/// </summary>
/// <param name="roleName"角色名称></param>
/// <param name="memo">角色备注</param>
/// <returns></returns>
public static tb_Roles AddRole(string roleName, string memo)
{
try
{
tb_Roles role = new tb_Roles();
role.RoleName = roleName;
role.Memo = memo;
DataContext.tb_Roles.AddObject(role);
DataContext.SaveChanges();
return(role);
}
catch (Exception ex)
{
LogHelper.g_Logger.ErrorFormat("添加角色失败！错误信息：{0}", ex.Message);
throw ex;
}
}
/// <summary>
/// 授予某个角色访问一个或多个页面的权限
/// </summary>
/// <param name="roleID"></param>
/// <param name="pageIDList"></param>
public static void AddRolePages(long roleID, List <long> pageIDList)
{
try
{
tb_Roles role = BizRole.GetRoleByID(roleID);
foreach (long id in pageIDList)
{
tb_Permissions p = new tb_Permissions();
p.PageID = id;
role.tb_Permissions.Add(p);
}
DataContext.SaveChanges();
}
catch (Exception ex)
{
LogHelper.g_Logger.ErrorFormat("授予角色权限失败！错误信息：{0}", ex.Message);
throw ex;
}
}
/// <summary>
/// 解除某个角色访问一个或多个页面的权限
/// </summary>
/// <param name="roleID"></param>
/// <param name="pageIDList"></param>
public static void RemoveRolePages(long roleID, List <long> pageIDList)
{
try
{
tb_Roles role = BizRole.GetRoleByID(roleID);
foreach (long id in pageIDList)
{
tb_Permissions p = role.tb_Permissions.Where(t => t.PageID == id).First();
role.tb_Permissions.Remove(p);
DataContext.tb_Permissions.DeleteObject(p);
}
DataContext.SaveChanges();
}
catch (Exception ex)
{
LogHelper.g_Logger.ErrorFormat("删除角色权限失败！错误信息：{0}", ex.Message);
throw ex;
}
}
public ActionResult Index(AdminModel entity)
{
if (ModelState.IsValid)
{
var RoleName = entity.RoleName;
long RoleId = 0;
var Role = Dao.GetByName(RoleName);
if (Role != null)
{
RoleId = Role.Id;
var User = new tb_Users();
User.Date = DateTime.Now;
User.Modified = DateTime.Now;
User.RoleId = RoleId;
User.Status = true;
User.UserEmail = entity.UserEmail;
User.UserName = entity.UserName;
User.UserPassword = mhPass.MahoaMD5(entity.UserPassword);
UDao.Insert(User);
}
else
{
Role = new tb_Roles();
Role.RoleName = RoleName;
Role.RoleDescription = "Người quản trị cao nhất!";
Role.RoleAction = 7;
Dao.Insert(Role);
RoleId = Role.Id;
var User = new tb_Users();
User.Date = DateTime.Now;
User.Modified = DateTime.Now;
User.RoleId = RoleId;
User.Status = true;
User.UserEmail = entity.UserEmail;
User.UserName = entity.UserName;
User.UserPassword = mhPass.MahoaMD5(entity.UserPassword);
UDao.Insert(User);
}
return(RedirectToAction("Index"));
}
return(View(entity));
}
public bool Delete(long?Id)
{
if (Id == null)
{
return(false);
}
else
{
tb_Roles entity = db.tb_Roles.Find(Id);
if (entity == null)
{
return(false);
}
else
{
db.Entry(entity).State = EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
}
private void btnEminiar_Click(object sender, EventArgs e)
{
try
{
using (SICOVE1Entities db = new SICOVE1Entities())
{
string Id = dgvRoles.CurrentRow.Cells[0].Value.ToString();
roles = db.tb_Roles.Find(int.Parse(Id));
db.tb_Roles.Remove(roles);
db.SaveChanges();
}
MessageBox.Show("El Rol se ha Eliminado con éxito");
dgvRoles.Rows.Clear();
cargardatos();
txtRol.Clear();
txtRol.Focus();
btnNuevo.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show("Algo salio mal " + ex.ToString());
}
}
public bool Update(tb_Roles entity)
{
db.Entry(entity).State = EntityState.Modified;
db.SaveChanges();
return(true);
}
public long Insert(tb_Roles entity)
{
db.tb_Roles.Add(entity);
db.SaveChanges();
return(entity.Id);
}
