public int GetCountUserForLevel(Models.vw_All_Level levels, EnterpriseUnitsTypeEnum type)
{
var query = (from usrDataTbl in context.Users
join cat in context.UserCategories on usrDataTbl.UserCategoryId equals cat.Id
where cat.Type == (int)type &&
(usrDataTbl.Level1Id == levels.Level1Id) && (usrDataTbl.Level2Id == levels.Level2Id) && (usrDataTbl.Level3Id == levels.Level3Id) && (usrDataTbl.Level4Id == levels.Level4Id)
select usrDataTbl.Id);
return(query.Count());
}
public ActMembershipUser(Models.User user, Models.vw_All_Level levelResponsibleForMe) : base("ActMembershipProvider", user.UserName, user.Id, user.Email, string.Empty, string.Empty, true, false, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now, DateTime.Now)
{
Id = user.Id;
Level1Id = user.Level1Id;
Level2Id = user.Level2Id;
Level3Id = user.Level3Id;
Level4Id = user.Level4Id;
UserCategoryId = user.UserCategoryId;
JobTitleId = user.JobTitleId;
UserName = user.UserName;
Email = user.Email;
Password = user.Password;
Active = user.Active;
CreatedBy = user.CreatedBy;
CreatedDate = user.CreatedDate;
UpdatedBy = user.UpdatedBy;
UpdatedDate = user.UpdatedDate;
FirstName = user.FirstName;
SecondName = user.SecondName;
ThirdName = user.ThirdName;
LastName = user.LastName;
PhoneNumber = user.PhoneNumber;
AnotherPhoneNumber = user.AnotherPhoneNumber;
GenderId = user.GenderId;
Address = user.Address;
IsSystemAdmin = user.UserCategory?.IsSystemAdmin;
//Check if is Manager for this level
LevelResponsibleForMe = levelResponsibleForMe;
if (LevelResponsibleForMe != null && IsSystemAdmin == true)
{
LevelResponsibleForMe.LevelName = Resources.LocalizedText.Level0;
}
//get my level number
MyLevelNumber = user.Level4Id.HasValue ? 4 :
user.Level3Id.HasValue ? 3 :
user.Level2Id.HasValue ? 2 :
user.Level1Id.HasValue ? 1 :
0;
//set menu permisstion
MenuIdsPermission = new List <int>();
var JobTitlePermisstion = user.JobTitle.MenuPrivelags.Select(x => x.MenuId).ToList();
var UserCategoryPermisstion = user.UserCategory.MenuPrivelags.Select(x => x.MenuId).ToList();
MenuIdsPermission.AddRange(JobTitlePermisstion);
MenuIdsPermission.AddRange(UserCategoryPermisstion);
MenuIdsPermission = MenuIdsPermission.Distinct().ToList();
}
public List <UnitUserJoinUserModel> GetNonUnitUser(decimal unitId, Models.vw_All_Level levels, EnterpriseUnitsTypeEnum type)
{
var query = (from usrDataTbl in context.Users
join usrUnitTbl in context.UnitUsers on usrDataTbl.Id equals usrUnitTbl.UserId into usrs
join cat in context.UserCategories on usrDataTbl.UserCategoryId equals cat.Id
from usr in usrs.DefaultIfEmpty()
join userEnterUnitTbl in context.EnterpriseUnits on usr.UnitId equals userEnterUnitTbl.Id into usersEnter
from usrsEnter in usersEnter.DefaultIfEmpty()
where (usr.UnitId <= 0 || usr.UnitId == null) && cat.Type == (int)type &&
(usrDataTbl.Level1Id == levels.Level1Id) && (usrDataTbl.Level2Id == levels.Level2Id) && (usrDataTbl.Level3Id == levels.Level3Id) && (usrDataTbl.Level4Id == levels.Level4Id)
// ||usr.UnitId != unitId //&& usrDataTbl.UserCategoryId == catId
select new UnitUserJoinUserModel()
{
FullName = usrDataTbl.FirstName + " " + usrDataTbl.SecondName + " " + usrDataTbl.ThirdName + " " + usrDataTbl.LastName,
Id = usrDataTbl.Id,
UserId = usrDataTbl.Id,
UnitId = usr.UnitId,
UnitName = usrsEnter.Name
}
);
return(query.ToList());
}
