// Method to Get all Users details with Roles and Country Association.
public static List <UserDetailsBuilder> GetAllUsers()
{
var _allUsers = dbUserAdministration.GetAllUsers();
var _allRoles = dbMasterData.GetallRoles();
var _allCountries = dbMasterData.GetallCountry();
var _allRolesForUser = dbMasterData.GetallRolesForUser();
var _allCountryForUser = dbMasterData.GetallCountryForUsers();
List <UserDetailsBuilder> _finalList = new List <UserDetailsBuilder>();
UserDetailsBuilder _user;
for (int i = 0; i < _allUsers.Count; i++)
{
_user = new UserDetailsBuilder();
int userId = _allUsers[i].User_Id;
_user.Userdetails.UserID = _allUsers[i].User_Id.ToString();
_user.Userdetails.FirstName = _allUsers[i].First_Name;
_user.Userdetails.LastName = _allUsers[i].Last_Name;
_user.Userdetails.UPI = _allUsers[i].UPI.ToString();
_user.Userdetails.FullName = _allUsers[i].First_Name + _allUsers[i].Last_Name;
_user.Userdetails.Email = _allUsers[i].Email_Id;
_user.Userdetails.User511 = _allUsers[i].User_511;
var rolelist = (from h in _allRolesForUser
join r in _allRoles on h.Role_Master_Id equals r.Role_Master_Id
where h.User_Id == userId
select new RolesModel()
{
RoleID = h.User_Roles_Id.ToString(),
RoleName = r.Role_Name
}).OrderBy(x => x.RoleName).ToList();
_user.UserRoles = rolelist;
var userCountryList = (from h in _allCountryForUser
join r in _allUsers on h.User_Id equals r.User_Id
join v in _allCountries on h.Country_Master_Id equals v.Country_Master_Id
where h.User_Id == userId
select new CountryMaster_List()
{
CountryId = (int)h.Country_Master_Id,
CountryName = v.Country_Name
}).OrderBy(x => x.CountryName).ToList();
_user.UserCountry = userCountryList;
_finalList.Add(_user);
}
return(_finalList);
}
public UserDetailsBuilder GetUserNameForDisplay(String UserName)
{
UserDetailsBuilder _UserDetails = new UserDetailsBuilder();
var userdetails = _dbAuthentication.GetUserforADlogonID(UserName);
if (userdetails == null)
{
return(null);
}
else
{
UserModel _user = new UserModel();
_user.FirstName = userdetails.First_Name;
_user.LastName = userdetails.Last_Name;
_UserDetails.Userdetails = _user;
return(_UserDetails);
}
}
public UserDetailsBuilder GetUserDetailswithRoles(String UserName)
{
UserDetailsBuilder _UserDetails = new UserDetailsBuilder();
var userdetails = _dbAuthentication.GetUserforADlogonID(UserName);
if (userdetails == null)
{
List <LDAPUserModel> _ldapUserModel = new List <LDAPUserModel>();
_ldapUserModel = bsUserAdministration.GetUserInfo(UserName.ToUpper(), null);
UserModel _user = new UserModel();
_user.User511 = UserName;
_user.FirstName = _ldapUserModel[0].FirstName;
_user.LastName = _ldapUserModel[0].LastName;
_user.Email = _ldapUserModel[0].Email;
_user.UPI = _ldapUserModel[0].UPI;
_user.IsActive = true;
_user.CreatedDate = DateTime.Now.ToString();
_user.CreatedBy = "ALAGAKX";
_user.RoleIds = "3";
_user.CountryIds = "9";
var insertUser = bsUserAdministration.InsertNewUser(_user);
if (insertUser == 1)
{
_UserDetails = GetUserDetailswithRoles(UserName);
}
return(_UserDetails);
}
else
{
UserModel _user = new UserModel();
_user.UserID = userdetails.User_Id.ToString();
_user.FirstName = userdetails.First_Name;
_user.LastName = userdetails.Last_Name;
_user.MiddleInitial = userdetails.Middle_Initial;
_user.Email = userdetails.Email_Id;
_user.UPI = userdetails.UPI == null ? String.Empty : userdetails.UPI.ToString();
_user.User511 = userdetails.User_511;
_user.IsActive = userdetails.Is_Active;
_user.CreatedBy = userdetails.Created_By;
_user.CreatedDate = userdetails.Created_Date == null ? String.Empty : userdetails.Created_Date.ToString();
_user.ModifiedBy = userdetails.Modified_By;
_user.ModifiedDate = userdetails.Modified_Date == null ? String.Empty : userdetails.Modified_Date.ToString();
_UserDetails.Userdetails = _user;
var userroles = _dbAuthentication.GetRolesforUsers(userdetails.User_Id);
List <RolesModel> _lstUserroles = new List <RolesModel>();
for (int i = 0; i < userroles.Count; i++)
{
RolesModel _role = new RolesModel();
var roledetails = _dbAuthentication.GetRoleDetails(userroles[i].Role_Master_Id);
if (roledetails != null)
{
_role.RoleID = roledetails.Role_Master_Id.ToString();
_role.RoleName = roledetails.Role_Name;
_role.IsActive = roledetails.Is_Active;
_lstUserroles.Add(_role);
}
}
_UserDetails.UserRoles = _lstUserroles;
return(_UserDetails);
}
}
