public void Update(HouseDTO house) { using (WarmHomeContext ctx = new WarmHomeContext()) { BaseService <HouseEntity> bs = new BaseService <HouseEntity>(ctx); HouseEntity entity = bs.GetById(house.Id); entity.Address = house.Address; entity.Area = house.Area; //2,3,4 entity.Attachments.Clear();//先删再加 var atts = ctx.Attachments.Where(a => a.IsDeleted == false && house.AttachmentIds.Contains(a.Id)); foreach (AttachmentEntity att in atts) { entity.Attachments.Add(att); } //3,4,5 entity.CheckInDateTime = house.CheckInDateTime; entity.CommunityId = house.CommunityId; entity.DecorateStatusId = house.DecorateStatusId; entity.Description = house.Description; entity.Direction = house.Direction; entity.FloorIndex = house.FloorIndex; entity.LookableDateTime = house.LookableDateTime; entity.MonthRent = house.MonthRent; entity.OwnerName = house.OwnerName; entity.OwnerPhoneNum = house.OwnerPhoneNum; entity.RoomTypeId = house.RoomTypeId; entity.StatusId = house.StatusId; entity.TotalFloorCount = house.TotalFloorCount; entity.TypeId = house.TypeId; ctx.SaveChanges(); } }
public long AddNew(HouseAddNewDTO house) { HouseEntity entity = new HouseEntity(); entity.Address = house.Address; entity.Area = house.Area; using (WarmHomeContext db = new WarmHomeContext()) { BaseService <AttachmentEntity> service = new BaseService <AttachmentEntity>(db); var atts = service.GetAll().Where(e => house.AttachmentIds.Contains(e.Id)); foreach (var att in atts) { entity.Attachments.Add(att); } entity.CheckInDateTime = house.CheckInDateTime; entity.CommunityId = house.CommunityId; entity.DecorateStatusId = house.DecorateStatusId; entity.Description = house.Description; entity.Direction = house.Direction; entity.FloorIndex = house.FloorIndex; //houseEntity.HousePics 新增后再单独添加 entity.LookableDateTime = house.LookableDateTime; entity.MonthRent = house.MonthRent; entity.OwnerName = house.OwnerName; entity.OwnerPhoneNum = house.OwnerPhoneNum; entity.RoomTypeId = house.RoomTypeId; entity.StatusId = house.StatusId; entity.TotalFloorCount = house.TotalFloorCount; entity.TypeId = house.TypeId; db.Houses.Add(entity); db.SaveChanges(); return(entity.Id); } }
public void DeleteHousePic(long housePicId) { using (WarmHomeContext db = new WarmHomeContext()) { HousepicEntity entity = new HousepicEntity(); entity.Id = housePicId; db.Entry(entity).State = EntityState.Deleted; db.SaveChanges(); } }
public void SetUserCityId(long userId, long cityId) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <UserEntity> service = new BaseService <UserEntity>(db); var user = service.GetById(userId); if (user == null) { throw new ArgumentException("不存在Id为" + userId + "的用户"); } user.CityId = cityId; db.SaveChanges(); } }
public long AddNewHousePic(HousePicDTO housePic) { using (WarmHomeContext db = new WarmHomeContext()) { HousepicEntity entity = new HousepicEntity() { ThumbUrl = housePic.ThumbUrl, Url = housePic.Url, HouseId = housePic.HouseId }; db.Housepics.Add(entity); db.SaveChanges(); return(entity.Id); } }
public void UpdatePwd(long userId, string newPassword) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <UserEntity> service = new BaseService <UserEntity>(db); var user = service.GetById(userId); if (user == null) { throw new ArgumentException("不存在Id为" + userId + "的用户"); } string pwd = CommonHelper.CalcMD5(newPassword + user.PasswordSalt); user.PasswordHash = pwd; db.SaveChanges(); } }
public void UpdateRegion(long id, long cityId, string name) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <RegionEntity> service = new BaseService <RegionEntity>(db); var data = service.GetById(id); if (data == null) { throw new ArgumentException("此" + name + "区域不存在"); } data.CityId = cityId; data.Name = name; db.SaveChanges(); } }
public void AddCommunity(CommunityDTO community) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <CommunityEntity> service = new BaseService <CommunityEntity>(db); CommunityEntity entity = new CommunityEntity() { RegionId = community.RegionId, Name = community.Name, Location = community.Location, BuiltYear = community.BuiltYear, Traffic = community.Traffic }; db.Communities.Add(entity); db.SaveChanges(); } }
public void UpdataRole(long roleId, string name) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <RolesEntity> service = new BaseService <RolesEntity>(db); var role = service.GetById(roleId); if (role == null) { throw new ArgumentException("不存在" + roleId + "的角色"); } else { role.Name = name; db.SaveChanges(); } } }
public void Edit(long id, string name, string desc) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <PermissionEntity> service = new BaseService <PermissionEntity>(db); var per = service.GetAll().Where(e => e.Id == id).SingleOrDefault(e => e.Name == name); if (per != null) { per.Name = name; per.Description = desc; db.SaveChanges(); } else { throw new ArgumentException("不存在id为:" + id + "的权限"); } } }
public void UpdateCommunity(CommunityDTO community) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <CommunityEntity> service = new BaseService <CommunityEntity>(db); var data = service.GetById(community.Id); if (data == null) { throw new ArgumentException("此" + community.Id + "的小区不存在"); } data.Location = community.Location; data.Name = community.Name; data.RegionId = community.RegionId; data.Traffic = community.Traffic; data.BuiltYear = community.BuiltYear; db.SaveChanges(); } }
public long AddHouseAppointment(long?userid, string name, string phoneNum, long houseId, DateTime visiteDate) { using (WarmHomeContext db = new WarmHomeContext()) { HouseAppointmentEntity house = new HouseAppointmentEntity() { UserId = userid, Name = name, PhoneNum = phoneNum, HouseId = houseId, Status = "未处理", VisitDate = visiteDate }; db.HouseAppointments.Add(house); db.SaveChanges(); return(house.Id); } }
public void AddRegion(long cityId, string name) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <RegionEntity> service = new BaseService <RegionEntity>(db); bool exists = service.GetAll().Any(e => e.Name == name); if (exists) { throw new ArgumentException("此" + name + "小区已存在"); } RegionEntity entity = new RegionEntity() { Name = name, CityId = cityId }; db.Regions.Add(entity); db.SaveChanges(); } }
public void AddPermission(string name, string desc) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <PermissionEntity> service = new BaseService <PermissionEntity>(db); bool exists = service.GetAll().Any(e => e.Name == name); if (exists) { throw new ArgumentException("此" + name + "权限已存在"); } PermissionEntity entity = new PermissionEntity() { Name = name, Description = desc }; db.Permissions.Add(entity); db.SaveChanges(); }; }
static void Main(string[] args) { using (WarmHomeContext db = new WarmHomeContext()) { AdminUserEntity admin = new AdminUserEntity() { Email = "*****@*****.**", Name = "简约态度", PasswordHash = "123", PasswordSalt = "123", PhoneNum = "13991414185", LoginErrorTimes = 1, LastLoginErrorDateTime = DateTime.Now }; db.AdminUsers.Add(admin); db.SaveChanges(); System.Console.WriteLine("创建成功"); } }
public long AddRole(string name) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <RolesEntity> service = new BaseService <RolesEntity>(db); var role = service.GetAll().SingleOrDefault(e => e.Name == name); if (role != null) { throw new ArgumentException("此" + name + "角色已存在"); } else { RolesEntity entity = new RolesEntity(); entity.Name = name; db.Roles.Add(entity); db.SaveChanges(); return(entity.Id); } } }
public void AddPermissions(long roleId, long[] permisId) { using (WarmHomeContext db = new WarmHomeContext()) { BaseService <RolesEntity> service = new BaseService <RolesEntity>(db); var role = service.GetById(roleId); if (role == null) { throw new ArgumentException("没用" + roleId + "的角色"); } else { BaseService <PermissionEntity> per = new BaseService <PermissionEntity>(db); var permissions = per.GetAll().Where(e => permisId.Contains(e.Id)).ToList(); foreach (var item in permissions) { role.Permissions.Add(item); } db.SaveChanges(); } } }