public void LogOut(int userid) { using (var myen = new AccessEntities()) { myen.DoLogout(userid); } }
public List <Role> ListOfRolesOfUser(int userid, bool isactive) { using (AccessEntities myen = new AccessEntities()) { return(myen.ListRolesOfUser(userid, isactive).ToList <Role>()); } }
public List <Department> GetUserDepartments(int UserID) { using (var context = new AccessEntities()) { return(context.ListDeparmentsOfUser(UserID).ToList <Department>()); } }
public bool ValidEntity_Right(string roles, string ServiceName, string EntityName) { using (var myen = new AccessEntities()) { int result = myen.Right_EntityValidRoles(roles, ServiceName, EntityName).FirstOrDefault().Value; return(result == 1 ? true : false); } }
public List <Entity> GetEntities_Right(int RoleId, string ServiceName) { using (var myen = new AccessEntities()) { List <Entity> getright = myen.Right_EntityGet(RoleId, ServiceName).ToList <Entity>(); return(getright); } }
public List <Group> ListOfGroup() { using (AccessEntities myen = new AccessEntities()) { var query = myen.Database.SqlQuery <Group>("select * from [asc].[Group]"); return(query.ToList()); } }
public int SetParrentId(int ID, int?ParrentID) { using (var myen = new AccessEntities()) { int res = myen.SetOrganizationRoleParrentID(ID, ParrentID); return(res); } }
public int CheckLogin(string username, string password) { using (var myen = new AccessEntities()) { ObjectParameter Result = new ObjectParameter("ReturnValue", typeof(string)); myen.LoginCheck(username, password, Result); return(Result.Value.ToInt32()); } }
//public static T GetProccudereWithOutput<T>(string StoreName,string ReturnParameterName,Dictionary<string,object> parameters) //{ // ObjectParameter Result = new ObjectParameter(ReturnParameterName, typeof(T)); // System.Collections.Generic.List<ObjectParameter> param = new List<ObjectParameter>(); // foreach (string paramname in parameters.Keys) // { // param.Add(new ObjectParameter(paramname, parameters.Where(x => x.Key == paramname).FirstOrDefault().Value)); // } // return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("GetRolesOfUser", userIdParameter, isActiveParameter, roles); //} public string GetRolesOfUser(int userid, bool isactive) { using (var myen = new AccessEntities()) { ObjectParameter Result = new ObjectParameter("RolesIds", typeof(string)); myen.GetRolesOfUser(userid, isactive, Result); if (Result.Value != null) { string res = Result.Value.ToString(); return(res); } return(null); } }
public List <Department> GetDepartments(string[] includes, int depid) { using (var context = new AccessEntities()) { IQueryable <Department> department = context.Departments.AsQueryable(); if (includes != null) { foreach (string inc in includes) { department = department.Include(inc); } } return(department.Where(x => x.IsVisible == true && x.ID == depid).ToList()); } }
public List <User> GetAllUsers(string [] includes) { using (var db = new AccessEntities()) { var query = db.Users.AsQueryable(); if (includes != null) { foreach (string inc in includes) { query = query.Include(inc); } } return(query.ToList <User>()); } }
public List <Role> ListOfAllRoles(string [] includes) { _myen = new AccessEntities(); lock (_myen) { IQueryable <Role> _role = _myen.Roles.AsQueryable <Role>(); if (includes != null) { foreach (string inc in includes) { _role = _role.Include(inc); } } return(_role.Where(x => x.IsActive == true).ToList <Role>()); } }
public User GetUserById(int userid, string [] includes) { using (var db = new AccessEntities()) { var query = db.Users.AsQueryable(); if (includes != null) { foreach (string inc in includes) { query = query.Include(inc); } } return(query.Where(x => x.ID == userid).FirstOrDefault() ?? new User { ID = -1 }); } }
public static IQueryable <Role> GetRoles() { AccessEntities myen = new AccessEntities(); return(myen.Roles.Where(x => x.IsActive == true)); }
public static IQueryable <OrganiztionRole> GetOrganizationRoles( ) { AccessEntities myen = new AccessEntities(); return(myen.OrganiztionRoles); }