public JsonResult GetUsers(string prefix) { BL_RolesRights co = new BL_RolesRights(); connect(); List <UserRights> usersRight = new List <UserRights>(); try { DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand("select upper(LoginName) as LoginName,upper(FullName) as FullName,UserID from Users where LoginName like '" + prefix + "%' and RowStatus = 0", con); con.Open(); SqlDataAdapter ad = new SqlDataAdapter(); ad.SelectCommand = cmd; ad.Fill(ds); foreach (DataRow rdr in ds.Tables[0].Rows) { UserRights user = new UserRights(); user.UserID = Convert.ToInt32(rdr["UserID"]); user.LoginName = rdr["LoginName"].ToString(); user.FullName = rdr["FullName"].ToString(); usersRight.Add(user); } con.Close(); } catch (Exception ex) { con.Close(); ex.ToString(); } return(new JsonResult { Data = usersRight, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult EditRoleRightsLevel2(int RoleID) { List <RolesRights> SerchAdd = new List <Models.Keystone.RolesRights>(); List <RolesRights> objSearch = new List <Models.Keystone.RolesRights>(); BL_RolesRights BLobj = new BL_RolesRights(); RolesRights obj = new RolesRights(); if (RoleID > 0) { obj.GetRights = RolesRights.GetRoleAndRightsByRoleID(RoleID); obj.RoleID = obj.GetRights.Tables[0].Rows[0]["RoleID"].ToString(); obj.RoleName = obj.GetRights.Tables[0].Rows[0]["RoleName"].ToString(); foreach (DataRow dr in obj.GetRights.Tables[0].Rows) { SerchAdd.Add(new RolesRights { ModuleIDchk = Convert.ToInt32(dr["ModuleIDchk"]), ModuleID = Convert.ToInt32(dr["ModuleID"]), // ModuleName = dr["ModuleName"].ToString(), RightCode = Convert.ToInt32(dr["RightCode"]) //=obj.GetRights.Tables[0].Rows[0]["ModuleID"].ToString(); }); } } return(new JsonResult { Data = SerchAdd, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult RoleRightstwo(int RoleID) { BL_RolesRights BLobj = new BL_RolesRights(); RolesRights obj = new RolesRights(); ModelState.Clear(); obj.GetRoleAndRights = BLobj.GetRoleAndRights(); obj.GetRoles = RolesRights.GetAllRols(); return(View(obj)); }
public ActionResult UserRights() { //HospitalLocation Location = new HospitalLocation(); //collection //return View(); UserRights location = new UserRights(); BL_RolesRights BLobj = new BL_RolesRights(); RolesRights obj = new RolesRights(); ModelState.Clear(); obj.GetRoleAndRights = BLobj.GetRoleAndRights(); obj.GetRoles = BLobj.GetAllRols(); return(View(obj)); }
public ActionResult RoleRightsLevel2(int Level1ModuleID) { List <RolesRights> objSearch = new List <Models.Keystone.RolesRights>(); BL_RolesRights BLobj = new BL_RolesRights(); RolesRights obj = new RolesRights(); ModelState.Clear(); obj.GetRoleAndRights = BLobj.GetRoleAndRights(); DataView dataView3 = new DataView(obj.GetRoleAndRights.Tables[0], " ParentModuleID = " + Level1ModuleID + "", "", DataViewRowState.CurrentRows); foreach (DataRow dr in dataView3.ToTable().Rows) { objSearch.Add(new RolesRights { ModuleID = Convert.ToInt32(dr["ModuleID"]), ModuleName = dr["ModuleName"].ToString(), }); } return(new JsonResult { Data = objSearch, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
// // GET: /RoleRightstwo/ public ActionResult RoleRightstwo(int RoleID) { BL_RolesRights BLobj = new BL_RolesRights(); RolesRights obj = new RolesRights(); ModelState.Clear(); obj.GetRoleAndRights = BLobj.GetRoleAndRights(); obj.GetRoles = RolesRights.GetAllRols(); if (RoleID > 0) { obj.GetRights = RolesRights.GetRoleAndRightsByRoleID(RoleID); obj.RoleID = obj.GetRights.Tables[0].Rows[0]["RoleID"].ToString(); obj.RoleName = obj.GetRights.Tables[0].Rows[0]["RoleName"].ToString(); } else { // obj.RoleName = ""; // obj.RoleID = "0"; } return(View(obj)); }