public DBUserCollection AddOne(long userId, string houseID)
{
var house = _houseService.FindById(houseID);
if (house == null)
{
throw new NotFoundException("房源信息不存在,请刷新页面后重试");
}
if (_context.UserCollections.Any(c => c.HouseID == houseID && c.UserID == userId))
{
throw new UnProcessableException("房源信息已收藏.");
}
var collection = new DBUserCollection();
collection.Source = house.Source;
collection.Title = house.Title;
collection.OnlineURL = house.OnlineURL;
collection.City = house.City;
collection.Id = Tools.GetGuid();
collection.HouseID = houseID;
collection.UserID = userId;
collection.CreateTime = DateTime.Now;
collection.HouseJson = JsonConvert.SerializeObject(house);
_context.UserCollections.Add(collection);
_context.SaveChanges();
return(collection);
}
public void GetUsers()
{
using (DBUserCollection users = new DBUserCollection(new SqlDataProvider()))
{
users.Connection = new MySqlConnection(connString);
users.Connection.Open();
users.Load();
Assert.IsTrue(users.List.Count > 0);
}
}
