public long AddAdminUser(string name, string phoneNum, string password, string email, long?cityId) { using (RhDbContext ctx = new RhDbContext()) { CommonService <AdminUserEntity> commonService = new CommonService <AdminUserEntity>(ctx); //假如手机号已被注册,就返回-1 if (commonService.GetAll().Any(a => a.PhoneNum == phoneNum)) { return(-1); } //密码盐 可以用生成验证码的那个随机算一个出来 string pwdSalt = CommonHelper.GenerateCaptchaCode(5); AdminUserEntity newAdminUser = new AdminUserEntity() { Name = name, PhoneNum = phoneNum, CityId = cityId, PasswordSalt = pwdSalt, PasswordHash = CommonHelper.CalcMd5(password + pwdSalt), Email = email, }; ctx.AdminUsers.Add(newAdminUser); ctx.SaveChanges(); return(newAdminUser.Id); } }
public long AddNew(HouseAddNewDTO house) { using (RhDbContext ctx = new RhDbContext()) { HouseEntity houseEntity = new HouseEntity(); CommonService <AttachmentEntity> attCs = new CommonService <AttachmentEntity>(ctx); //拿到传进来的DTO的attachmentIds为主键的房屋配套设施 var atts = attCs.GetAll().Where(a => house.AttachmentIds.Contains(a.Id)); foreach (var att in atts) { houseEntity.Attachments.Add(att); } houseEntity.Address = house.Address; houseEntity.Area = house.Area; houseEntity.CommunityId = house.CommunityId; houseEntity.CheckInDateTime = house.CheckInDateTime; houseEntity.Description = house.Description; houseEntity.DecorateStatusId = house.DecorateStatusId; houseEntity.Direction = house.Direction; houseEntity.FloorIndex = house.FloorIndex; houseEntity.TotalFloorCount = house.TotalFloorCount; houseEntity.LookableDateTime = house.LookableDateTime; houseEntity.MonthRent = house.MonthRent; houseEntity.OwnerName = house.OwnerName; houseEntity.OwnerPhoneNum = house.OwnerPhoneNum; houseEntity.RoomTypeId = house.RoomTypeId; houseEntity.StatusId = house.StatusId; houseEntity.TypeId = house.TypeId; ctx.Houses.Add(houseEntity); ctx.SaveChanges(); return(houseEntity.Id); } }
public void ResetLoginError(long id) { using (RhDbContext ctx = new RhDbContext()) { CommonService <AdminUserEntity> commonService = new CommonService <AdminUserEntity>(ctx); var adminUser = commonService.GetById(id); adminUser.LoginErrorTimes = 0; ctx.SaveChanges(); } }
public long AddNew(string roleName) { using (RhDbContext ctx = new RhDbContext()) { RoleEntity role = new RoleEntity(); role.Name = roleName; ctx.Roles.Add(role); ctx.SaveChanges(); return(role.Id); } }
public void RecordLoginError(long id) { using (RhDbContext ctx = new RhDbContext()) { CommonService <AdminUserEntity> commonService = new CommonService <AdminUserEntity>(ctx); var adminUser = commonService.GetById(id); adminUser.LoginErrorTimes = adminUser.LoginErrorTimes++; adminUser.LastLoginErrorDateTime = DateTime.Now; ctx.SaveChanges(); } }
public void AddNewLog(long adminUserId, string message) { using (RhDbContext ctx = new RhDbContext()) { ctx.AdminUserLogs.Add(new AdminLogEntity() { AdminUserId = adminUserId, Message = message }); ctx.SaveChanges(); } }
public long AddNewHousePic(HousePicDTO housePic) { using (RhDbContext ctx = new RhDbContext()) { HousePicEntity housePicEntity = new HousePicEntity(); housePicEntity.Url = housePic.Url; housePicEntity.ThumbUrl = housePic.ThumbUrl; housePicEntity.HouseId = housePic.HouseId; ctx.HousePics.Add(housePicEntity); ctx.SaveChanges(); return(housePicEntity.Id); } }
public int MarkDeleted(long id) { T en = GetById(id); if (en != null) { en.IsDeleted = true; return(_dbContext.SaveChanges()); } else { return(-1); } }
public void SetUserCityId(long userId, long cityId) { using (RhDbContext ctx = new RhDbContext()) { CommonService <UserEntity> cs = new CommonService <UserEntity>(ctx); UserEntity user = cs.GetById(userId); if (user == null) { throw new ArgumentException("用户不存在 " + userId); } user.CityId = cityId; ctx.SaveChanges(); } }
public void Update(long roleId, string roleName) { using (RhDbContext ctx = new RhDbContext()) { CommonService <RoleEntity> cs = new CommonService <RoleEntity>(ctx); var role = cs.GetById(roleId); if (role == null) { throw new ArgumentException("此角色不存在"); } role.Name = roleName; ctx.SaveChanges(); } }
public long AddNew(string typeName, string name) { using (RhDbContext ctx = new RhDbContext()) { IdNameEntity idName = new IdNameEntity() { Name = name, TypeName = typeName }; //TODO:检查重复的情况 ctx.IdNames.Add(idName); ctx.SaveChanges(); return(idName.Id); } }
public void IncrLoginError(long id) { using (RhDbContext ctx = new RhDbContext()) { CommonService <UserEntity> cs = new CommonService <UserEntity>(ctx); UserEntity user = cs.GetById(id); if (user == null) { throw new ArgumentException("用户不存在 " + id); } user.LastLoginErrorDateTime = DateTime.Now; user.LoginErrorTimes++; ctx.SaveChanges(); } }
public void UpdatePermission(long id, string permName, string description) { using (RhDbContext ctx = new RhDbContext()) { CommonService <PermissionEntity> cs = new CommonService <PermissionEntity>(ctx); var permEntity = cs.GetById(id); if (permEntity == null) { throw new ArgumentException("id不存在 " + id); } permEntity.Name = permName; permEntity.Description = description; ctx.SaveChanges(); } }
public long AddNew(long?userId, string name, string phoneNum, long houseId, DateTime visitDate) { HouseAppointmentEntity ha = new HouseAppointmentEntity(); ha.UserId = userId; ha.Name = name; ha.PhoneNum = phoneNum; ha.Status = "未处理"; //这个忘了 ha.HouseId = houseId; ha.VisitDate = visitDate; using (RhDbContext ctx = new RhDbContext()) { ctx.HouseAppointments.Add(ha); ctx.SaveChanges(); return(ha.Id); } }
public void UpdatePwd(long userId, string newPassword) { using (RhDbContext ctx = new RhDbContext()) { CommonService <UserEntity> cs = new CommonService <UserEntity>(ctx); UserEntity user = cs.GetById(userId); if (user == null) { throw new ArgumentException("用户不存在 " + userId); } string salt = CommonHelper.GenerateCaptchaCode(5); user.PasswordSalt = salt; user.PasswordHash = CommonHelper.CalcMd5(salt + newPassword); ctx.SaveChanges(); } }
public void AddRoleIds(long adminUserId, long[] roleIds) { using (RhDbContext ctx = new RhDbContext()) { CommonService <AdminUserEntity> adminUserCs = new CommonService <AdminUserEntity>(ctx); var adminUser = adminUserCs.GetById(adminUserId); if (adminUser == null) { throw new ArgumentException("管理员用户Id不存在 " + adminUserId); } CommonService <RoleEntity> roleCs = new CommonService <RoleEntity>(ctx); var roles = roleCs.GetAll().Where(a => roleIds.Contains(a.Id)).ToList().ToArray(); foreach (var role in roles) { adminUser.Roles.Add(role); } ctx.SaveChanges(); } }
public long AddPermission(string permName, string description) { using (RhDbContext ctx = new RhDbContext()) { CommonService <PermissionEntity> cs = new CommonService <PermissionEntity>(ctx); var exists = cs.GetAll().Any(a => a.Name == permName); if (exists) { throw new ArgumentException("此权限项已存在"); } PermissionEntity permissionEntity = new PermissionEntity() { Name = permName, Description = description }; ctx.Permissions.Add(permissionEntity); ctx.SaveChanges(); return(permissionEntity.Id); } }
public void AddPermIds(long roleId, long[] permIds) { using (RhDbContext ctx = new RhDbContext()) { CommonService <RoleEntity> roleCs = new CommonService <RoleEntity>(ctx); RoleEntity role = roleCs.GetById(roleId); if (role == null) { throw new ArgumentException("roleId不存在 " + roleId); } CommonService <PermissionEntity> permCs = new CommonService <PermissionEntity>(ctx); var perms = permCs.GetAll().Where(a => permIds.Contains(a.Id)).ToArray(); foreach (var perm in perms) { role.Permissions.Add(perm); } ctx.SaveChanges(); } }
public void UpdateAdminUser(long id, string name, string phoneNum, string password, string email, long?cityId) { using (RhDbContext ctx = new RhDbContext()) { CommonService <AdminUserEntity> commonService = new CommonService <AdminUserEntity>(ctx); var adminUser = commonService.GetById(id); if (adminUser == null) { throw new ArgumentException("找不到id为" + id + "的管理员"); } adminUser.Name = name; adminUser.PhoneNum = phoneNum; if (!string.IsNullOrEmpty(password)) { adminUser.PasswordHash = CommonHelper.CalcMd5(password + adminUser.PasswordSalt); } adminUser.Email = email; adminUser.CityId = cityId; ctx.SaveChanges(); } }
//新增或更改配置信息 public void SetValue(string name, string value) { using (RhDbContext ctx = new RhDbContext()) { CommonService <SettingEntity> cs = new CommonService <SettingEntity>(ctx); var settingEntity = cs.GetAll().SingleOrDefault(a => a.Name == name); if (settingEntity == null) //没有则新增 { ctx.Settings.Add(new SettingEntity() { Name = name, Value = value }); } else { settingEntity.Value = value; } ctx.SaveChanges(); } }
public long AddNew(string cityName) { using (RhDbContext ctx = new RhDbContext()) { CommonService <CityEntity> baseService = new CommonService <CityEntity>(ctx); //判断是否存在任何一条数据满足 c.Name == cityName //即存在这样一个名字的城市 //如果只是判断“是否存在”,那么用Any效率比Where().count()效率 if (baseService.GetAll().Any(c => c.Name == cityName)) { throw new ArgumentException("城市已存在"); } CityEntity city = new CityEntity { Name = cityName }; ctx.Cities.Add(city); ctx.SaveChanges(); return(city.Id); } }
public long AddNew(string phoneNum, string password) { using (RhDbContext ctx = new RhDbContext()) { //检查手机号不能重复 CommonService <UserEntity> cs = new CommonService <UserEntity>(ctx); bool exists = cs.GetAll().Any(a => a.PhoneNum == phoneNum); if (exists) { throw new ArgumentException("手机号已存在"); } string salt = CommonHelper.GenerateCaptchaCode(5); string pwdHash = CommonHelper.CalcMd5(salt + password); UserEntity user = new UserEntity(); user.PhoneNum = phoneNum; user.PasswordSalt = salt; user.PasswordHash = pwdHash; ctx.Users.Add(user); ctx.SaveChanges(); return(user.Id); } }