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);
}
