public int GetSuiteCRMUsersCount() { using (var connection = Helper.GetConnection(this.services, this.Logger)) using (SuiteCRMUserUnitOfWork userRepository = new SuiteCRMUserUnitOfWork(connection)) { return(userRepository.Count()); } }
public IEnumerable <SuiteCRMUserViewModel> GetUsers(int pageNumber, int pageSize) { List <SuiteCRMUserViewModel> returnValue = new List <SuiteCRMUserViewModel>(); using (var connection = Helper.GetConnection(this.services, this.Logger)) using (SuiteCRMUserUnitOfWork userRepository = new SuiteCRMUserUnitOfWork(connection)) using (SuiteCRMEmailAddressUnitOfWork emailRepository = new SuiteCRMEmailAddressUnitOfWork(connection)) using (SuiteCRMEmailAddressBeanUnitOfWork emailBeanRepository = new SuiteCRMEmailAddressBeanUnitOfWork(connection)) { var suiteUsers = userRepository.GetUsers(pageNumber, pageSize); var ids = suiteUsers.Select(c => c.id).ToArray(); var suiteUserEmailBeans = emailBeanRepository.GetEmailAddressesBean(UsersBean, ids).ToArray(); var suiteUserEmails = emailRepository.GetEmailAddresses(suiteUserEmailBeans.Select(c => c.email_address_id).ToArray()).ToList(); string[] usernames = suiteUsers.Select(c => c.user_name).ToArray(); var orchardUsers = this.services.ContentManager.HqlQuery <UserPart>().Where(c => c.ContentPartRecord <UserPartRecord>(), c => c.In("UserName", usernames)).List(); foreach (var suiteUser in suiteUsers) { var suiteCRMEmailBean = suiteUserEmailBeans.FirstOrDefault(c => c.bean_id == suiteUser.id); if (suiteCRMEmailBean == null) { continue; } var suiteCRMUserEmail = suiteUserEmails.FirstOrDefault(c => c.id == suiteCRMEmailBean.email_address_id); if (suiteCRMUserEmail == null) { continue; } SuiteCRMUserViewModel item = new SuiteCRMUserViewModel(); item.SuiteCRMUsername = suiteUser.user_name; item.SuiteCRMUserId = suiteUser.id; item.SuiteCRMEmail = suiteCRMUserEmail.email_address; var user = orchardUsers.FirstOrDefault(c => c.UserName.ToLower() == suiteUser.user_name.ToLower() && c.Email != null && c.Email.ToLower() == suiteCRMUserEmail.email_address.ToLower()); if (user != null) { item.IsSync = true; item.OrchardUsername = user.UserName; item.OrchardEmail = user.Email; item.OrchardUserId = user.Id; } returnValue.Add(item); } } return(returnValue); }
public IEnumerable <SuiteCRMUserViewModel> CopySuiteCRMUsersToOrchard(CopySuiteCRMUsersToOrchardViewModel model) { List <SuiteCRMUserViewModel> returnValue = new List <SuiteCRMUserViewModel>(); using (var connection = Helper.GetConnection(this.services, this.Logger)) using (SuiteCRMUserUnitOfWork userRepository = new SuiteCRMUserUnitOfWork(connection)) using (SuiteCRMEmailAddressUnitOfWork emailRepository = new SuiteCRMEmailAddressUnitOfWork(connection)) using (SuiteCRMEmailAddressBeanUnitOfWork emailBeanRepository = new SuiteCRMEmailAddressBeanUnitOfWork(connection)) { var ids = model.Users.Where(c => !string.IsNullOrEmpty(c.SuiteCRMUserId)).Select(c => c.SuiteCRMUserId).ToArray(); var suiteUsers = userRepository.GetUsers(ids); var suiteUserEmailBeans = emailBeanRepository.GetEmailAddressesBean(UsersBean, ids).ToArray(); var suiteUserEmails = emailRepository.GetEmailAddresses(suiteUserEmailBeans.Select(c => c.email_address_id).ToArray()).ToList(); var orchardUsers = this.services .ContentManager .GetMany <IUser>(model.Users.Where(c => c.OrchardUserId.HasValue).Select(c => c.OrchardUserId.Value), VersionOptions.Published, new QueryHints()); var operatorRole = this.GetOperatorRole(); foreach (var item in model.Users.Where(c => !string.IsNullOrEmpty(c.SuiteCRMUserId))) { var suiteCRMUser = suiteUsers.FirstOrDefault(c => c.id == item.SuiteCRMUserId); if (suiteCRMUser == null) { continue; } var suiteCRMEmailBean = suiteUserEmailBeans.FirstOrDefault(c => c.bean_id == item.SuiteCRMUserId); if (suiteCRMEmailBean == null) { continue; } var suiteCRMUserEmail = suiteUserEmails.FirstOrDefault(c => c.id == suiteCRMEmailBean.email_address_id); if (suiteCRMUserEmail == null) { continue; } IUser user = orchardUsers.FirstOrDefault(c => c.UserName.ToLower() == suiteCRMUser.user_name.ToLower() || c.Email.ToLower() == suiteCRMUserEmail.email_address.ToLower()); if (user != null) { continue; } var newUser = this.membershipService.CreateUser(new CreateUserParams( suiteCRMUser.user_name, model.DefaultPassword, suiteCRMUserEmail.email_address, null, null, true)); SuiteCRMUserPart suiteCRMUserPart = newUser.As <SuiteCRMUserPart>(); suiteCRMUserPart.ExternalId = suiteCRMUser.id; suiteCRMUserPart.LastSyncTime = DateTime.UtcNow; // Full name var userPart = newUser.ContentItem.Parts.FirstOrDefault(d => d.PartDefinition.Name.ToLower(CultureInfo.InvariantCulture) == "user"); userPart.Store("FullName", string.Format("{0} {1}", suiteCRMUser.first_name, suiteCRMUser.last_name)); // role if (operatorRole != null) { UserRolesPartRecord newUserRole = new UserRolesPartRecord { UserId = newUser.Id, Role = new RoleRecord { Id = operatorRole.Id } }; this.userRolesPartRecordRepository.Create(newUserRole); } this.services.ContentManager.Publish(newUser.ContentItem); this.userRolesPartRecordRepository.Flush(); returnValue.Add(new SuiteCRMUserViewModel { IsSync = true, OrchardEmail = newUser.Email, OrchardUserId = newUser.Id, SuiteCRMUserId = suiteCRMUser.id, SuiteCRMEmail = suiteCRMUserEmail.email_address, SuiteCRMUsername = suiteCRMUser.user_name, OrchardUsername = newUser.UserName }); } } return(returnValue); }