public void SaveGuideChanges(NewGuideModel model) { var guide = _db.guide.FirstOrDefault(e => e.Id == model.Id); if (guide == null) { throw new MyException(Errors.UserNotFound); } model.CopyTo(ref guide); //editor.user.Password = StringTransformationProvider.Md5(model.Password); guide.user.Email = StringTransformationProvider.TransformEmail(model.Email); guide.user.Deleted = model.Deleted; //сохранение новых прав _db.country_permission.RemoveRange(guide.user.country_permission); _db.city_permission.RemoveRange(guide.user.city_permission); //_db.region_permission.RemoveRange(guide.user.region_permission); _db.country_permission.AddRange( model.PermittedCountries.Select(c => new country_permission { CountryId = c, UserId = guide.UserId })); _db.city_permission.AddRange( model.PermittedCities.Select(c => new city_permission { CityId = c, UserId = guide.UserId })); // _db.region_permission.AddRange( // model.PermittedRegions.Select(c => new region_permission { RegionId = c, UserId = guide.UserId })); _db.SaveChanges(); }
public void AddNewAdmin(NewAdminModel model) { model.Email = StringTransformationProvider.TransformEmail(model.Email); if (_db.user.Any(u => u.Email == model.Email)) { throw new MyException(Errors.UserExists); } var trans = _db.Database.BeginTransaction(); try { var newUser = new user { Guid = Guid.NewGuid().ToString(), Password = StringTransformationProvider.Md5(model.Password), Email = model.Email, UserTypeId = GetUserTypeByTag(UserTypes.Admin), Deleted = false }; _db.user.Add(newUser); _db.SaveChanges(); var admin = new admin(); model.CopyTo(ref admin); admin.UserId = newUser.Id; _db.admin.Add(admin); _db.SaveChanges(); trans.Commit(); } catch (Exception) { trans.Rollback(); throw; } }
public user GetUserByLoginAndPassword(string email, string password) { var md5Pass = StringTransformationProvider.Md5(password); email = StringTransformationProvider.TransformEmail(email); var user = _db.user.FirstOrDefault(u => u.Email == email && md5Pass == u.Password); if (user == null) { throw new MyException(Errors.UserNotFound); } return(user); }
public void SaveTenantChanges(NewTenantModel model) { var tenant = _db.tenant.FirstOrDefault(e => e.Id == model.Id); if (tenant == null) { throw new MyException(Errors.UserNotFound); } model.CopyTo(ref tenant); //editor.user.Password = StringTransformationProvider.Md5(model.Password); tenant.user.Email = StringTransformationProvider.TransformEmail(model.Email); tenant.user.Deleted = model.Deleted; _db.SaveChanges(); }
public void AddNewEditor(NewEditorModel model) { model.Email = StringTransformationProvider.TransformEmail(model.Email); if (_db.user.Any(u => u.Email == model.Email)) { throw new MyException(Errors.UserExists); } var trans = _db.Database.BeginTransaction(); try { var newUser = new user { Guid = Guid.NewGuid().ToString(), Password = StringTransformationProvider.Md5(model.Password), Email = model.Email, UserTypeId = GetUserTypeByTag(UserTypes.Editor), Deleted = model.Deleted }; _db.user.Add(newUser); _db.SaveChanges(); var newEditor = new editor(); model.CopyTo(ref newEditor); newEditor.UserId = newUser.Id; _db.editor.Add(newEditor); _db.country_permission.AddRange( model.PermittedCountries.Select(c => new country_permission { CountryId = c, UserId = newUser.Id })); _db.city_permission.AddRange( model.PermittedCities.Select(c => new city_permission { CityId = c, UserId = newUser.Id })); /* _db.region_permission.AddRange( * model.PermittedRegions.Select(c => new region_permission {RegionId = c, UserId = newUser.Id}));*/ _db.SaveChanges(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw; } }