public void UpdateUser(UserModel user, Guid currentUserId) { using (var _db = new CoreEntities()) { using (var dbContextTransaction = _db.Database.BeginTransaction()) { try { _db.User_Update(user.UserId, user.FirstName, user.LastName, user.MiddleName, user.DateOfBirth, user.PlaceOfBirth, currentUserId); if (user.Address != null && user.Address.Count > 0) { foreach (var add in user.Address) { _db.Address_Update(add.Id, add.Address1, add.Address2, add.City, add.State, add.Zip, add.Country); } } if (user.Emails != null) { foreach (var email in user.Emails) { _db.Email_Update(email.EmailId, email.EmailAddress, email.EmailType, true); } } if (user.Phones != null) { foreach (var phone in user.Phones) { if (phone.PhoneId == Guid.Empty) { _db.User_Add_Phone(user.UserId, currentUserId, Guid.NewGuid(), phone.PhoneNumber, phone.PhoneType, phone.Description); } else { _db.Phone_Update(phone.PhoneId, phone.PhoneNumber, phone.Description, phone.PhoneType); } } } /* * * if (user.Occupations != null) * { * foreach (var oc in user.Occupations) * { * _db.User_Add_Occupation(user.UserId, currentUserId, Guid.NewGuid(), oc, "", DateTime.Now, DateTime.Now, true); * } * } */ dbContextTransaction.Commit(); } catch (Exception ex) { dbContextTransaction.Rollback(); } } } }
public void ClearTest() { Effort.Provider.EffortProviderConfiguration.RegisterProvider(); var Connection = ConfigurationManager.ConnectionStrings["CoreEntities"]; connection = Effort.EntityConnectionFactory.CreateTransient(Connection.ConnectionString); context = new CoreEntities(connection); InitializeSeed(); }
public static AuthenticationResult Authenticate(string userName, string password, out Account account, bool passwordIsHashed = false) { if (string.IsNullOrWhiteSpace(userName)) { throw new ArgumentNullException("userName"); } if (string.IsNullOrWhiteSpace(password)) { throw new ArgumentNullException("password"); } int authenticationAttemptID = 0; AuthenticationStatus result = AuthenticationStatus.Failure_Unknown; using (ICoreRepositoryManager repository = CoreServiceLocator.GetRepositoryManager()) { CoreEntities ctx = repository.DataModel; account = null; //lets patch up the username and remove any leading or trailing spaces. userName = userName.Trim(); //lets look and see if the userName is an email address. account = ctx.Accounts.SingleOrDefault(p => p.UserName == userName && !p.Voided); if (account != null) { //check account approved/disabled result = account.Approved ? AuthenticationStatus.Success : AuthenticationStatus.Failure_AccountNotApproved; result = account.Disabled ? AuthenticationStatus.Failure_AccountDisabled : AuthenticationStatus.Success; result = account.Password == null ? AuthenticationStatus.Failure_NoPassword : AuthenticationStatus.Success; //if so far we are approved and not disabled, and password is not null, then lets check the password against the input. if (result == AuthenticationStatus.Success && !VerifyPasswordMatch(password, account.Password, passwordIsHashed)) { result = AuthenticationStatus.Failure_IncorrectPassword; } } else { result = AuthenticationStatus.Failure_AccountNotExist; } if (account != null) { //detach the contact so we don't have to worry about duplicates being committed into the database since this context is going out of scope *very* soon. ctx.Detach(account); } } return(new AuthenticationResult(result, authenticationAttemptID)); }
public SolicitudController() { if (core == null) { core = new CoreEntities(_ctx); } if (coreDetail == null) { coreDetail = new DetalleSolicitudCore(_ctx); } if (coreAuto == null) { coreAuto = new AutosCore(_ctx); } }
public RoleService(ContextContainer Context) { this.Context = Context; db = Context.CoreEntities; }
public List <UserModel> GetUsers(PostUsersRequest req, Guid currentUser) { var users = new List <UserModel>(); using (var _db = new CoreEntities()) { users = (from u in _db.User_Get(req.FirstName, req.LastName, null, null, null, null, null, currentUser) select UsersAdapter.ToClientUser(u)).ToList(); foreach (var user in users) { var addresses = (from a in _db.UserAddress_GET(user.UserId) where a != null select AddressAdapter.toServiceAddress(a) ).ToList(); foreach (var ad in addresses) { if (ad != null) { user.Address.Add(ad); } } var emails = (from e in _db.Email_Get(user.UserId) where e != null && e.Id != null select new Email() { EmailAddress = e.Email, EmailType = e.EmailType, EmailId = (Guid)e.Id }).ToList(); foreach (var em in emails) { if (em != null) { user.Emails.Add(em); } } var phones = (from ph in _db.Phone_Get(user.UserId) where ph != null && ph.Id != null select new Phone() { PhoneId = (Guid)ph.Id, Description = ph.PhoneDescription, PhoneNumber = ph.PhoneNumber, PhoneType = ph.PhoneType, IsPrimaryPhone = true }).ToList(); foreach (var ph in phones) { if (ph != null) { user.Phones.Add(ph); } } var ChildrenRelations = (from r in _db.UserRelations_Get(user.UserId, null) select new UserRelation() { ToUserId = (Guid)r.ToUserId, FromUserId = (Guid)r.FromUserId, Type = r.RelationType }).ToList(); foreach (var ch in ChildrenRelations) { ch.User = (from u in _db.User_Get(null, null, null, null, null, null, ch.ToUserId, currentUser) select UsersAdapter.ToClientUser(u)).FirstOrDefault(); user.Relations.Add(ch); } var parentsRelations = (from r in _db.UserRelations_Get(null, user.UserId) select new UserRelation() { ToUserId = (Guid)r.ToUserId, FromUserId = (Guid)r.FromUserId, Type = r.RelationType }).ToList(); foreach (var prt in parentsRelations) { prt.User = (from u in _db.User_Get(null, null, null, null, null, null, prt.FromUserId, currentUser) select UsersAdapter.ToClientUser(u)).FirstOrDefault(); user.Relations.Add(prt); } } } return(users); }
//protected ILog log; public BaseController() { CoreContext = CoreEntities.Create(); CoreContext.Configuration.ProxyCreationEnabled = false; Context = new ContextContainer(); }