private bool UpdateUserPermission(string type, string id, bool isActive)
{
bool result = false;
if (type == "system")
{
IQueryable <THOK.Authority.DbModel.UserSystem> queryUserSystem = UserSystemRepository.GetQueryable();
Guid sid = new Guid(id);
var system = queryUserSystem.FirstOrDefault(i => i.UserSystemID == sid);
system.IsActive = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
else if (type == "module")
{
IQueryable <THOK.Authority.DbModel.UserModule> queryUserModule = UserModuleRepository.GetQueryable();
Guid mid = new Guid(id);
var module = queryUserModule.FirstOrDefault(i => i.UserModuleID == mid);
module.IsActive = isActive;
RoleModuleRepository.SaveChanges();
result = true;
}
else if (type == "function")
{
IQueryable <THOK.Authority.DbModel.UserFunction> queryUserFunction = UserFunctionRepository.GetQueryable();
Guid fid = new Guid(id);
var system = queryUserFunction.FirstOrDefault(i => i.UserFunctionID == fid);
system.IsActive = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
return(result);
}
public bool UpdateRolePermission(string type, string id, string isActive)
{
bool result = false;
if (type == "system")
{
IQueryable <AUTH_ROLE_SYSTEM> queryRoleSystem = RoleSystemRepository.GetQueryable();
//Guid sid = new Guid(id);
//string sid = id;
var system = queryRoleSystem.FirstOrDefault(i => i.ROLE_SYSTEM_ID == id);
system.IS_ACTIVE = isActive.ToString();
RoleSystemRepository.SaveChanges();
result = true;
}
else if (type == "module")
{
IQueryable <AUTH_ROLE_MODULE> queryRoleModule = RoleModuleRepository.GetQueryable();
//Guid mid = new Guid(id);
var module = queryRoleModule.FirstOrDefault(i => i.ROLE_MODULE_ID == id);
module.IS_ACTIVE = isActive.ToString();
RoleModuleRepository.SaveChanges();
result = true;
}
else if (type == "function")
{
IQueryable <AUTH_ROLE_FUNCTION> queryRoleFunction = RoleFunctionRepository.GetQueryable();
//Guid fid = new Guid(id);
var system = queryRoleFunction.FirstOrDefault(i => i.ROLE_FUNCTION_ID == id);
system.IS_ACTIVE = isActive.ToString();
RoleSystemRepository.SaveChanges();
result = true;
}
return(result);
}
private bool UpdateUserPermission(string type, string id, string isActive)
{
bool result = false;
if (type == "system")
{
IQueryable <AUTH_USER_SYSTEM> queryUserSystem = UserSystemRepository.GetQueryable();
//Guid sid = new Guid(id);
var system = queryUserSystem.FirstOrDefault(i => i.USER_SYSTEM_ID == id);
system.IS_ACTIVE = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
else if (type == "module")
{
IQueryable <AUTH_USER_MODULE> queryUserModule = UserModuleRepository.GetQueryable();
// Guid mid = new Guid(id);
var module = queryUserModule.FirstOrDefault(i => i.USER_MODULE_ID == id);
module.IS_ACTIVE = isActive;
RoleModuleRepository.SaveChanges();
result = true;
}
else if (type == "function")
{
IQueryable <AUTH_USER_FUNCTION> queryUserFunction = UserFunctionRepository.GetQueryable();
//Guid fid = new Guid(id);
var system = queryUserFunction.FirstOrDefault(i => i.USER_FUNCTION_ID == id);
system.IS_ACTIVE = isActive;
RoleSystemRepository.SaveChanges();
result = true;
}
return(result);
}
private void InitRoleSystem(AUTH_ROLE role, AUTH_CITY city, AUTH_SYSTEM system)
{
var roleSystems = role.AUTH_ROLE_SYSTEM.Where(rs => rs.AUTH_CITY.CITY_ID == city.CITY_ID &&
rs.AUTH_SYSTEM.SYSTEM_ID == system.SYSTEM_ID);
if (roleSystems.Count() == 0)
{
AUTH_ROLE_SYSTEM rs = new AUTH_ROLE_SYSTEM()
{
//ROLE_SYSTEM_ID = Guid.NewGuid().ToString(),
ROLE_SYSTEM_ID = RoleSystemRepository.GetNewID("AUTH_ROLE_SYSTEM", "ROLE_SYSTEM_ID"),
AUTH_ROLE = role,
AUTH_CITY = city,
AUTH_SYSTEM = system,
IS_ACTIVE = "0"
};
RoleSystemRepository.Add(rs);
RoleSystemRepository.SaveChanges();
}
var roleSystem = role.AUTH_ROLE_SYSTEM.Single(rs => rs.AUTH_CITY.CITY_ID == city.CITY_ID &&
rs.AUTH_SYSTEM.SYSTEM_ID == system.SYSTEM_ID);
InitRoleModule(roleSystem);
}
private void InitRoleSystem(Role role, City city, THOK.Authority.DbModel.System system)
{
var roleSystems = role.RoleSystems.Where(rs => rs.City.CityID == city.CityID &&
rs.System.SystemID == system.SystemID);
if (roleSystems.Count() == 0)
{
RoleSystem rs = new RoleSystem()
{
RoleSystemID = Guid.NewGuid(),
Role = role,
City = city,
System = system,
IsActive = false
};
RoleSystemRepository.Add(rs);
RoleSystemRepository.SaveChanges();
}
var roleSystem = role.RoleSystems.Single(rs => rs.City.CityID == city.CityID &&
rs.System.SystemID == system.SystemID);
InitRoleModule(roleSystem);
}
