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();
}
}
}
