/// <summary> /// 获取权限组数据 /// </summary> /// <returns>返回管理员日志数据集</returns> public List <MasterRole> GetAllMasterRole() { List <MasterRole> list = new List <MasterRole>(); try { string sql = "select * from manager_role"; using (SqlDataReader reder = db.GetReader(sql)) { while (reder.Read()) { MasterRole ml = new MasterRole(); ml.RoleId = (int)reder["id"]; ml.RoleName = reder["role_name"].ToString(); list.Add(ml); } } } catch (SqlException ex) { throw new Exception("数据库异常!原因:" + ex.Message); } catch (Exception ex) { throw new Exception("未知异常!原因:" + ex.Message); } return(list); }
/// <summary> /// 通过分页获取权限组数据 /// </summary> /// <param name="PageSize">页大小</param> /// <param name="PageNum">页码</param> /// <param name="WhereStr">条件</param> /// <param name="OrderBy">排序</param> /// <returns>返回管理员日志数据集</returns> public List <MasterRole> GetAllMasterRole(int PageSize, int PageNum, string WhereStr, string OrderBy) { List <MasterRole> list = new List <MasterRole>(); try { SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@PageSize", PageSize), new SqlParameter("@PageNum", PageNum), new SqlParameter("@TableName", "manager_role"), new SqlParameter("@WhereStr", WhereStr), new SqlParameter("@OrderBy", OrderBy) }; using (SqlDataReader reder = db.GetReaderByProc("Proc_Page", sp)) { while (reder.Read()) { MasterRole ml = new MasterRole(); ml.RoleId = (int)reder["id"]; ml.RoleName = reder["role_name"].ToString(); list.Add(ml); } } } catch (SqlException ex) { throw new Exception("数据库异常!原因:" + ex.Message); } catch (Exception ex) { throw new Exception("未知异常!原因:" + ex.Message); } return(list); }
protected void gvRoles_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ClearPageData(); GridViewRow selectedRow = gvRoles.Rows[Convert.ToInt32(e.CommandArgument)]; selectedRow.Style["background-color"] = "skyblue"; Label lblRolename = (Label)selectedRow.Cells[1].FindControl("lblRolename"); MasterRole objMasterRole = new MasterRole(); objMasterRole.RoleID = Convert.ToInt32(gvRoles.DataKeys[selectedRow.RowIndex]["RoleID"]); objMasterRole.RoleName = lblRolename.Text; objMasterRole.Description = selectedRow.Cells[2].Text; objMasterRole.RoleStatus = new UsersRoleDAL().GetRoles().Where(x => x.RoleID == objMasterRole.RoleID).Select(y => y.RoleStatus).FirstOrDefault(); Session["SelectedMasterRole"] = objMasterRole; ddlRole.SelectedValue = Convert.ToString(objMasterRole.RoleID); txtDesc.Text = objMasterRole.Description; ddlStatus.SelectedIndex = -1; ddlStatus.Items.FindByValue(new Helper().GetItemStatusEnumName(Convert.ToChar(objMasterRole.RoleStatus))).Selected = true; GetDualListData(objMasterRole); EditForm.Visible = true; } }
/// <summary> /// 获取用户组 /// </summary> /// <param name="RoleId">用户组Id</param> /// <returns>返回用户组</returns> public MasterRole GetRole(int RoleId) { MasterRole role = null; try { string sql = "select * from manager_role where id=@RoleId"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@RoleId", RoleId) }; using (SqlDataReader reder = db.GetReader(sql, sp)) { while (reder.Read()) { role = new MasterRole((int)reder["id"], reder["role_name"].ToString()); } } } catch (SqlException ex) { throw new Exception("数据库异常!原因:" + ex.Message); } catch (Exception ex) { throw new Exception("未知异常!原因:" + ex.Message); } return(role); }
// GET: CourseManager public ActionResult Index() { ViewBag.Items = dbc.MasterRoles.ToList(); var model = new MasterRole(); ViewBag.RoleId = new SelectList(dbc.Roles, "Id", "Name"); ViewBag.MasterId = new SelectList(dbc.Masters, "Id", "Username"); return(View(model)); }
public void Save(MasterRole data) { if (data.RoleId == 0) { data.InstitutionId = _securityService.GetCurrentInstitutionId(); } _roleRepository.Save(data); _roleRepository.Commit(); }
public ActionResult InsertRole(MasterRole model) { dict.Clear(); dict.Add("@Role", model.RoleName); dict.Add("@mode", "InsertRole"); int i = common_Class.return_nonquery(dict, "Proc_role"); var Result = i > 0 ? Convert.ToBoolean(true).ToString() : Convert.ToBoolean(false).ToString(); return(Json(Result, JsonRequestBehavior.AllowGet)); }
public ActionResult AddRole() { List <MasterRole> RolesList = new List <MasterRole>(); List <StateMasterModal> StateList = new List <StateMasterModal>(); List <ZoneMastermodal> ZoneList = new List <ZoneMastermodal>(); List <DropdownLit> DropList = new List <DropdownLit>(); dict.Clear(); dict.Add("@mode", "GetRoleRecord"); DataSet dt = common_Class.return_dataset(dict, "Proc_role"); int r = Convert.ToInt32(dt.Tables.Count); if (r > 0) { for (int i = 0; i < dt.Tables[0].Rows.Count; i++) { MasterRole master = new MasterRole(); master.Id = Convert.ToInt32(dt.Tables[0].Rows[i]["id"]); master.RoleName = dt.Tables[0].Rows[i]["Role"].ToString(); master.active = Convert.ToInt32(dt.Tables[0].Rows[i]["Active"]).ToString() == "1" ? "Active" : "Deactive"; master.InsertedDate = dt.Tables[0].Rows[i]["inserted_on"].ToString(); RolesList.Add(master); } for (int j = 0; j < dt.Tables[1].Rows.Count; j++) { StateMasterModal state = new StateMasterModal(); state.Id = Convert.ToInt32(dt.Tables[1].Rows[j]["id"]); state.StateName = dt.Tables[1].Rows[j]["state"].ToString(); state.Active = Convert.ToInt32(dt.Tables[1].Rows[j]["Active"]).ToString() == "1" ? "Active" : "Deactive"; StateList.Add(state); } for (int k = 0; k < dt.Tables[2].Rows.Count; k++) { ZoneMastermodal zone = new ZoneMastermodal(); zone.Id = Convert.ToInt32(dt.Tables[2].Rows[k]["id"]); zone.StateId = Convert.ToInt32(dt.Tables[2].Rows[k]["State_id"]); zone.ZoneName = dt.Tables[2].Rows[k]["Zone"].ToString(); zone.StateName = dt.Tables[2].Rows[k]["state"].ToString(); zone.Active = Convert.ToInt32(dt.Tables[2].Rows[k]["active"]).ToString() == "1" ? "Active" : "Deactive"; ZoneList.Add(zone); } for (int l = 0; l < dt.Tables[3].Rows.Count; l++) { DropdownLit DDLState = new DropdownLit(); DDLState.Id = Convert.ToInt32(dt.Tables[3].Rows[l]["id"]); DDLState.DropName = dt.Tables[3].Rows[l]["state"].ToString(); DropList.Add(DDLState); } ViewBag.DropListState = DropList; ViewBag.GetZoneList = ZoneList; ViewBag.GetRoleList = RolesList; ViewBag.GetStateList = StateList; } return(View()); }
protected void LocalDBCheck() { SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["BPSecurity"].ConnectionString); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Roles", conn); DataTable dt = new DataTable(); da.Fill(dt); for (int r = 0; r < dt.Rows.Count; r++) { Guid roleid = (Guid)dt.Rows[r]["RoleId"]; string rolename = dt.Rows[r]["RoleName"].ToString(); if (!new UsersRoleDAL().GetRoles().Select(x => x.RoleName).Contains(rolename)) { MasterRole roleObj = new MasterRole(); roleObj.RUID = roleid; roleObj.RoleName = rolename; roleObj.RoleStatus = "A"; if (rolename == "Admin") { roleObj.Description = "Control the setting of the system."; } if (rolename == "Preparer") { roleObj.Description = "Prepare the budget."; } if (rolename == "Reviewer") { roleObj.Description = "Review the prepared budget."; } if (rolename == "Approver") { roleObj.Description = "Approved the budget after prepared or reviewed."; } if (rolename == "Viewer") { roleObj.Description = "Display the result."; } //add role. backend process - start if (!new UsersRoleDAL().InsertMasterRole(roleObj)) { ((SiteMaster)this.Master).ShowMessage("Failure", "An error occurred while saving User Role"); } //add role. backend process - end } } }
public ActionResult AddOrDelete(MasterRole model) { try { var MasterRole = dbc.MasterRoles .Single(mr => mr.RoleId == model.RoleId && mr.MasterId == model.MasterId); dbc.MasterRoles.Remove(MasterRole); } catch { dbc.MasterRoles.Add(model); } dbc.SaveChanges(); return(Content("Đã cập nhật vai trò")); }
public ActionResult Insert(MasterRole model) { try { dbc.MasterRoles.Add(model); dbc.SaveChanges(); TempData["Message"] = "Thêm mới thành công!"; return(RedirectToAction("Index")); } catch { TempData["Message"] = "Thêm mới thất bại!"; ViewBag.Items = dbc.MasterRoles.ToList(); return(View("Index", model)); } }
public IHttpActionResult Delete(MasterRole data) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { _roleService.Delete(data); return(Ok()); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public ActionResult Update(MasterRole model) { try { dbc.Entry(model).State = EntityState.Modified; dbc.SaveChanges(); TempData["Message"] = "Cập nhật thành công!"; return(RedirectToAction("Edit", new { model.Id })); } catch { TempData["Message"] = "Cập nhật thất bại!"; ViewBag.Items = dbc.MasterRoles.ToList(); return(View("Index", model)); } }
public ActionResult AddOrDelete(MasterRole model) { var message = ""; try { var ms = dbc.MasterRoles.Single(mr => mr.MasterId == model.MasterId && mr.RoleId == model.RoleId); dbc.MasterRoles.Remove(ms); message = "Xoa Thanh Cong"; } catch { dbc.MasterRoles.Add(model); message = "Them Thanh Cong"; } dbc.SaveChanges(); return(Content(message)); }
public void GetDualListData(MasterRole _Role) { try { List <int> RoleUserId = new UsersRoleDAL().ListUserRole().Where(x => x.RoleID == _Role.RoleID).Select(y => Convert.ToInt32(y.UserID)).ToList(); var SelectedItems = new List <DualListClass>(); for (int i = 0; i < RoleUserId.Count(); i++) { SelectedItems.Add( new DualListClass { Id = RoleUserId[i], Name = DAL.UsersDAL.StaticUserId(RoleUserId[i], "").UserName }); } Session["SelectedDualList"] = SelectedItems; List <MasterUser> lst = new UsersDAL().GetUsers(); var items = new List <DualListClass>(); for (int i = 0; i < lst.Count(); i++) { items.Add( new DualListClass { Id = lst[i].UserID, Name = lst[i].UserName }); } Session["DualList"] = items; BindDualList(); } catch (Exception ex) { ((SiteMaster)this.Master).ShowMessage("Error", "An error occurred", ex, true); } }
public ActionResult EditRole(MasterRole model) { dict.Clear(); dict.Add("@id", model.Id); if (model.Id > 0 && model.RoleName != null) { dict.Add("@Role", model.RoleName); dict.Add("@mode", "UpdateRole"); int i = common_Class.return_nonquery(dict, "Proc_role"); var Result = i > 0 ? Convert.ToBoolean(true).ToString() : Convert.ToBoolean(false).ToString(); return(Json(Result, JsonRequestBehavior.AllowGet)); } else if (model.Id > 0 && model.RoleName == null) { dict.Add("@mode", "RoleActive/Diactivate"); DataTable dt = common_Class.return_datatable(dict, "Proc_role"); int Result2 = Convert.ToInt32(dt.Rows[0][0].ToString()); return(Json(Result2, JsonRequestBehavior.AllowGet)); } return(Json(3, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> Delete(MasterRole model) { try { RoleRepository Repository = new RoleRepository(); var result = await Repository.DeleteRoleMMaster(model.RoleID, User.Identity.Name); if (result == true) { return(await GetList()); } else { return(View(result)); } } catch { return(View(false)); } }
public Boolean DoAddMasterRole() { if (Session[Keys.SESSION_ADMIN_INFO] == null) { return(false); } else { Master master = Session[Keys.SESSION_ADMIN_INFO] as Master; if (rcm.GetRoleCompetence(master.RoleId, 1452)) { string RItem = Request["RItem"]; string RoleName = Request["RoleName"]; if (mm.AddMasterRole(RoleName)) { MasterRole mr = new MasterRole(); mr = mm.GetMasterRole(RoleName); Boolean IsSuccess = false; string[] re = RItem.Split(','); foreach (string rc in re) { IsSuccess = rcm.AddCompentence(mr.RoleId, int.Parse(rc)); if (!IsSuccess) { rcm.DelAllCom(mr.RoleId); } } return(IsSuccess); } else { return(false); } } else { return(false); } } }
public async Task <ActionResult> Create(MasterRole model) { try { RoleRepository Repository = new RoleRepository(); var result = await Repository.CreateRoleMaster(model.Name, User.Identity.Name); if (result == true) { return(await GetList()); } else { return(View(result)); } } catch (Exception e) { Console.WriteLine("{0} Exception caught.", e); return(View(false)); } }
public ActionResult EditRole(int R) { if (Session[Keys.SESSION_ADMIN_INFO] == null) { return(RedirectToAction("Login", "Admin")); } else { Master master = Session[Keys.SESSION_ADMIN_INFO] as Master; if (rcm.GetRoleCompetence(master.RoleId, 1452)) { MasterRole mr = new MasterRole(); mr = mm.GetMasterRole(R); ViewData["RoleId"] = mr.RoleId; ViewData["RoleName"] = mr.RoleName; ViewData["Function"] = "UpdateData('/Master/UpdateMasterRole')"; return(View()); } else { return(RedirectToAction("Login", "Admin")); } } }
// Code By Nitin public ActionResult Index() { List <Area> area_list = new List <Area>(); //Add by lucky List <MasterRole> RolesList = new List <MasterRole>(); List <StateMasterModal> StateList = new List <StateMasterModal>(); List <ZoneMastermodal> ZoneList = new List <ZoneMastermodal>(); List <DropdownLit> DropList = new List <DropdownLit>(); //End dict.Clear(); //dict.Add("",""); dict.Add("@mode", "getAll_Area"); //DataTable dt = common_class.return_datatable(dict, "proc_Area"); DataSet dt = common_class.return_dataset(dict, "proc_Area"); int j = dt.Tables.Count; if (j > 0) { for (int i = 0; i < dt.Tables[0].Rows.Count; i++) { Area area = new Area(); area.id = Convert.ToInt32(dt.Tables[0].Rows[i]["id"].ToString()); area.Area_Name = dt.Tables[0].Rows[i]["Area_name"].ToString(); area.Zone_id = dt.Tables[0].Rows[i]["Zone"].ToString(); area.State_id = dt.Tables[0].Rows[i]["State"].ToString(); area.pincode = Convert.ToInt32(dt.Tables[0].Rows[i]["Pincode"].ToString()); area_list.Add(area); } //Add by lucky for (int k = 0; k < dt.Tables[1].Rows.Count; k++) { MasterRole master = new MasterRole(); master.Id = Convert.ToInt32(dt.Tables[1].Rows[k]["id"]); master.RoleName = dt.Tables[1].Rows[k]["Role"].ToString(); master.active = Convert.ToInt32(dt.Tables[1].Rows[k]["Active"]).ToString() == "1" ? "Active" : "Deactive"; master.InsertedDate = dt.Tables[1].Rows[k]["inserted_on"].ToString(); RolesList.Add(master); } for (int l = 0; l < dt.Tables[2].Rows.Count; l++) { StateMasterModal state = new StateMasterModal(); state.Id = Convert.ToInt32(dt.Tables[2].Rows[l]["id"]); state.StateName = dt.Tables[2].Rows[l]["state"].ToString(); state.Active = Convert.ToInt32(dt.Tables[2].Rows[l]["Active"]).ToString() == "1" ? "Active" : "Deactive"; StateList.Add(state); } for (int m = 0; m < dt.Tables[3].Rows.Count; m++) { ZoneMastermodal zone = new ZoneMastermodal(); zone.Id = Convert.ToInt32(dt.Tables[3].Rows[m]["id"]); zone.StateId = Convert.ToInt32(dt.Tables[3].Rows[m]["State_id"]); zone.ZoneName = dt.Tables[3].Rows[m]["Zone"].ToString(); zone.StateName = dt.Tables[3].Rows[m]["state"].ToString(); zone.Active = Convert.ToInt32(dt.Tables[3].Rows[m]["active"]).ToString() == "1" ? "Active" : "Deactive"; ZoneList.Add(zone); } for (int n = 0; n < dt.Tables[4].Rows.Count; n++) { DropdownLit DDLState = new DropdownLit(); DDLState.Id = Convert.ToInt32(dt.Tables[4].Rows[n]["id"]); DDLState.DropName = dt.Tables[4].Rows[n]["state"].ToString(); DropList.Add(DDLState); } ViewBag.DropListState = DropList; ViewBag.GetZoneList = ZoneList; ViewBag.GetRoleList = RolesList; ViewBag.GetStateList = StateList; //End ViewBag.list_Area = area_list; } return(View(area_list)); }
public void Delete(MasterRole data) { _roleRepository.Delete(data); _roleRepository.Commit(); }
public static string OnSubmit(string roleid, string dlbox, string desc, string stats) { string json; var ReturnObj = new { status = "", result = "" }; try { MasterRole roleObj = new MasterRole(); roleObj.RoleID = Convert.ToInt32(roleid); roleObj.RoleName = new UsersRoleDAL().GetRoles().Where(x => x.RoleID == Convert.ToInt32(roleid)).Select(y => y.RoleName).FirstOrDefault(); roleObj.Description = desc.Trim(); roleObj.RoleStatus = new Helper().GetItemStatusEnumValueByName(stats.Trim()); List <string> RolesUname = Roles.GetUsersInRole(roleObj.RoleName).ToList(); string[] usersSelected = dlbox.Split(','); List <string> SelectedUname = new List <string>(); if (usersSelected.Count() == 0 || dlbox == "null") { SelectedUname = new List <string>(); } else { for (int u = 0; u < usersSelected.Count(); u++) { SelectedUname.Add(new UsersDAL().GetUserDataByID(Convert.ToInt32(usersSelected[u])).UserName); } } if (SelectedUname.Count() > RolesUname.Count()) { List <string> OnlyInSelectedList = SelectedUname.Except(RolesUname).ToList(); foreach (string username in OnlyInSelectedList) { string[] getRoles = Roles.GetRolesForUser(username); if (getRoles.Count() > 0) { Roles.RemoveUserFromRoles(username, getRoles); if (!new UsersRoleDAL().DeleteUserRole(username, getRoles)) { throw new Exception("Fail to authenticated selected users-list. Please re-enter your values and try again."); } } Roles.AddUserToRole(username, roleObj.RoleName); //add to local db JuncUserRole userrole = new JuncUserRole(); userrole.RoleID = Convert.ToInt32(roleid); userrole.UserID = DAL.UsersDAL.StaticUserId(0, username).UserID; userrole.Status = new Helper().GetItemStatusEnumValueByName(stats.Trim()); if (!new UsersRoleDAL().InsertUserRole(userrole)) { throw new Exception("Fail to authenticated selected users-list. Please re-enter your values and try again."); } } //Update MasterRole if (new UsersRoleDAL().UpdateMasterRole(roleObj)) { ReturnObj = new { status = "Success", result = "User successfully added to roles." }; } else { throw new Exception("Fail to authenticated selected users-list & role. Please re-enter your values and try again."); } } else { if (SelectedUname.Count() == RolesUname.Count()) { //double check List <string> OnlyInSelectedList = SelectedUname.Except(RolesUname).ToList(); foreach (string username in OnlyInSelectedList) { string[] getRoles = Roles.GetRolesForUser(username); if (getRoles.Count() > 0) { Roles.RemoveUserFromRoles(username, getRoles); if (!new UsersRoleDAL().DeleteUserRole(username, getRoles)) { throw new Exception("Fail to authenticated selected users-list. Please re-enter your values and try again."); } } Roles.AddUserToRole(username, roleObj.RoleName); //add to local db JuncUserRole userrole = new JuncUserRole(); userrole.RoleID = Convert.ToInt32(roleid); userrole.UserID = DAL.UsersDAL.StaticUserId(0, username).UserID; userrole.Status = new Helper().GetItemStatusEnumValueByName(stats.Trim()); if (!new UsersRoleDAL().InsertUserRole(userrole)) { throw new Exception("Fail to authenticated selected users-list. Please re-enter your values and try again."); } } List <string> UnusedUserList = RolesUname.Except(SelectedUname).ToList(); foreach (string username in UnusedUserList) { string[] getRoles = Roles.GetRolesForUser(username); if (getRoles.Count() > 0) { Roles.RemoveUserFromRoles(username, getRoles); if (!new UsersRoleDAL().DeleteUserRole(username, getRoles)) { throw new Exception("Fail to authenticated selected users-list. Please re-enter your values and try again."); } } } } else { List <string> UnusedUserList = RolesUname.Except(SelectedUname).ToList(); foreach (string username in UnusedUserList) { string[] getRoles = Roles.GetRolesForUser(username); if (getRoles.Count() > 0) { Roles.RemoveUserFromRoles(username, getRoles); if (!new UsersRoleDAL().DeleteUserRole(username, getRoles)) { throw new Exception("Fail to authenticated selected users-list. Please re-enter your values and try again."); } } } } //Update MasterRole if (new UsersRoleDAL().UpdateMasterRole(roleObj)) { ReturnObj = new { status = "Success", result = "User successfully added to roles." }; } else { throw new Exception("Fail to authenticated selected users-list & role. Please re-enter your values and try again."); } } } catch (Exception ex) { ReturnObj = new { status = "Fail", result = "An error occurred. Error Message: " + ex.Message }; } return(json = JsonConvert.SerializeObject(ReturnObj, Formatting.Indented)); }