public long AddAdminUser(string name, string phoneNum, string password, string email, long?cityId) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> serives = new BaseService <AdminUserEntity>(db); bool exists = serives.GetAll().Any(e => e.PhoneNum == phoneNum); if (exists) { throw new ArgumentException("账号已存在"); } else { string salt = CommonHelper.CreateVerifyCode(4); string pwd = CommonHelper.CalcMD5(password + salt); AdminUserEntity admin = new AdminUserEntity() { CityId = cityId, Email = email, Name = name, PhoneNum = phoneNum, LoginErrorTimes = 0, PasswordSalt = salt, PasswordHash = pwd }; db.AdminUsers.Add(admin); db.SaveChanges(); return(admin.Id); } } }
public IEnumerable <AdminUserDTO> GetAll(long?cityId) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> serives = new BaseService <AdminUserEntity>(db); return(serives.GetAll().Include(e => e.City).AsNoTracking().Select(item => DTO(item)).ToList()); } }
public void MarkDeleted(long id) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> serives = new BaseService <AdminUserEntity>(db); serives.MarkDeleted(id); } }
public void Deleted(long id) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <CityEntity> service = new BaseService <CityEntity>(db); service.MarkDeleted(id); } }
public IEnumerable <AttachmentDTO> GetAll() { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AttachmentEntity> serives = new BaseService <AttachmentEntity>(db); return(serives.GetAll().AsNoTracking().ToList().Select(item => DTO(item))); } }
public void RecordLoginError(long id) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> service = new BaseService <AdminUserEntity>(db); var data = service.GetById(id); data.LoginErrorTimes = data.LoginErrorTimes++; db.SaveChanges(); } }
public void AddAdminLog(long adminUserId, string message) { using (WarmHomeContext db = new WarmHomeContext()) { AdminLogEntity adminLog = new AdminLogEntity() { Msg = message, UserId = adminUserId }; db.AdminLogs.Add(adminLog); } }
public CityDTO GetById(long cityId) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <CityEntity> service = new BaseService <CityEntity>(db); var data = service.GetById(cityId); if (data == null) { return(null); } return(DTO(data)); } }
public bool HasPermission(long adminUserId, string permissionName) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> service = new BaseService <AdminUserEntity>(db); var data = service.GetAll().Include(e => e.Roles).SingleOrDefault(e => e.Id == adminUserId); if (data == null) { throw new ArgumentException("没有id为" + adminUserId + "的管理员用户"); } return(data.Roles.SelectMany(x => x.Permissions).Any(e => e.Name == permissionName)); } }
public bool CheckLogin(string phoneNum, string password) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> serives = new BaseService <AdminUserEntity>(db); var data = serives.GetAll().AsNoTracking().SingleOrDefault(e => e.PhoneNum == phoneNum); if (data == null) { return(false); } return(data.PasswordHash == CommonHelper.CalcMD5(password + data.PasswordSalt)); } }
/// <summary> /// 获取Settings表的所有数据 /// </summary> /// <param name="name"></param> /// <returns></returns> public IEnumerable <SettingsDTO> GetSettings() { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <SettingEntity> serives = new BaseService <SettingEntity>(db); return(serives.GetAll().Select(item => new SettingsDTO() { Id = item.Id, Name = item.Name, Value = item.Value, CreateDateTime = item.CreateDateTime }).ToList()); } }
public void Edit(long id, string name) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <CityEntity> service = new BaseService <CityEntity>(db); var data = service.GetById(id); if (data == null) { throw new ArgumentException("此城市" + id + "不存在"); } data.Name = name; db.SaveChanges(); } }
public IEnumerable <IdNameDTO> GetAll(string typeName) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <IdNameEntity> serives = new BaseService <IdNameEntity>(db); return(serives.GetAll().Where(e => e.TypeName == typeName).ToList().Select(item => new IdNameDTO() { Id = item.Id, Name = item.Name, TypeName = item.TypeName, CreateDateTime = item.CreateDateTime })); } }
public AdminUserDTO GetById(long id) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> serives = new BaseService <AdminUserEntity>(db); var data = serives.GetAll().Include(e => e.City).AsNoTracking().SingleOrDefault(e => e.Id == id); if (data == null) { return(null); } else { return(DTO(data)); } } }
/// <summary> /// 获取值 /// </summary> /// <param name="name">要查询的名称</param> /// <returns></returns> public string GetValue(string name) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <SettingEntity> serives = new BaseService <SettingEntity>(db); var data = serives.GetAll().AsNoTracking().SingleOrDefault(e => e.Name == name); if (data == null) { return(null); } else { return(data.Value); } } }
public IEnumerable <AttachmentDTO> GetHouseId(long houseID) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <HouseEntity> serives = new BaseService <HouseEntity>(db); var data = serives.GetAll().Include(e => e.Attachments).AsNoTracking().SingleOrDefault(e => e.Id == houseID); if (data == null) { throw new ArgumentException("找不到" + houseID + "的数据"); } else { return(data.Attachments.Select(item => DTO(item))); } } }
public void AddAdminUserRole(long id, long[] roleId) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <RolesEntity> service = new BaseService <RolesEntity>(db); var roles = service.GetAll().Include(e => e.Permissions).Where(e => roleId.Contains(e.Id)).ToList(); BaseService <AdminUserEntity> bs = new BaseService <AdminUserEntity>(db); var user = bs.GetById(id); if (user == null) { throw new ArgumentException("不存在id为" + id + "的用户"); } foreach (var item in roles) { user.Roles.Add(item); } db.SaveChanges(); } }
public AdminUserDTO GetByPhoneNum(string phoneNum) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> serives = new BaseService <AdminUserEntity>(db); var data = serives.GetAll().Include(e => e.City).AsNoTracking().Where(e => e.PhoneNum == phoneNum); if (data.Count() <= 0) { return(null); } else if (data.Count() == 1) { return(DTO(data.SingleOrDefault())); } else { throw new ArgumentException("存在多个" + phoneNum + "的用户"); } } }
public void SetValue(string name, string value) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <SettingEntity> serives = new BaseService <SettingEntity>(db); var data = serives.GetAll().SingleOrDefault(e => e.Name == name); if (data == null) { SettingEntity setting = new SettingEntity() { Name = name, Value = value }; db.Settings.Add(setting); } else { data.Value = value; } db.SaveChanges(); } }
public long AddCity(string name) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <CityEntity> serives = new BaseService <CityEntity>(db); var result = serives.GetAll().Any(e => e.Name == name); if (result) { throw new ArgumentException("参数已存在"); } else { CityEntity city = new CityEntity() { Name = name }; db.Cities.Add(city); db.SaveChanges(); return(city.Id); } } }
public void UpdateAdminUser(long id, string name, string phoneNum, string password, string email, long?cityId) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AdminUserEntity> serives = new BaseService <AdminUserEntity>(db); var data = serives.GetById(id); if (data == null) { throw new ArgumentException("数据不存在"); } if (!string.IsNullOrEmpty(password)) { data.PasswordHash = CommonHelper.CalcMD5(password + data.PasswordSalt); } data.Name = name; data.PhoneNum = phoneNum; data.Name = name; data.Email = email; data.CityId = cityId; db.SaveChanges(); } }
public long AddIdName(string typeName, string name) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <IdNameEntity> serives = new BaseService <IdNameEntity>(db); bool esixts = serives.GetAll().Any(e => e.TypeName == typeName && e.Name == name); if (esixts) { throw new ArgumentException("此数据已存在"); } else { IdNameEntity entity = new IdNameEntity() { Name = name, TypeName = typeName }; db.IdNames.Add(entity); db.SaveChanges(); return(entity.Id); } } }
public IdNameDTO GetById(long id) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <IdNameEntity> serives = new BaseService <IdNameEntity>(db); var data = serives.GetById(id); if (data == null) { throw new ArgumentException("没有此数据"); } else { IdNameDTO idName = new IdNameDTO() { Id = data.Id, Name = data.Name, TypeName = data.TypeName, CreateDateTime = data.CreateDateTime }; return(idName); } } }
public BaseService(WarmHomeContext db) { this.db = db; }