public void MotoAdDetailsModel_ctor_WithMotoAd_OtherBrand()
{
// Given
City c = new City()
{
Label = "Nouméa"
};
User u = new User()
{
Firstname = "Nicolas"
};
MotoAd ad = new MotoAd()
{
Id = 17,
Title = "title",
Price = 1270,
City = c,
CreatedBy = u,
CreationDate = new DateTime(2012, 05, 12, 17, 26, 08),
Body = "body",
Kilometers = 2000,
Year = 2013,
Brand = new MotoBrand { Label = "Autre" },
OtherBrand = "Batmobile",
};
// When
MotoAdDetailsModel model = new MotoAdDetailsModel(ad);
// Then
Assert.AreEqual("Batmobile", model.Brand);
}
public void OtherVehicleAdDetailsModel_ctor_WithOtherVehicleAd()
{
// Given
City c = new City()
{
Label = "Nouméa"
};
User u = new User()
{
Firstname = "Nicolas"
};
OtherVehicleAd ad = new OtherVehicleAd()
{
Id = 17,
Title = "title",
Price = 1270,
City = c,
CreatedBy = u,
CreationDate = new DateTime(2012, 05, 12, 17, 26, 08),
Body = "body",
Kilometers = 2000,
Year = 2013
};
// When
OtherVehicleAdDetailsModel model = new OtherVehicleAdDetailsModel(ad);
// Then
Assert.AreEqual(17, model.AdId);
Assert.AreEqual(2000, model.Kilometers);
Assert.AreEqual(2013, model.Year);
}
public void CanDeleteAd_AdExistsAndAlreadyDeleted_ReturnFalse()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
AdRepository adRepo = new AdRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Informatique",
LabelUrlPart = "Informatique",
Type = AdTypeEnum.Ad
};
Ad a = new Ad
{
Title = "video game",
Body = "the best!!",
CreatedBy = u,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
IsDeleted = true
};
c.AddAd(a);
cat.AddAd(a);
repo.Save<Province>(p1);
repo.Save<City>(c);
repo.Save<Category>(cat);
long id = repo.Save<Ad, long>(a);
repo.Flush();
#endregion
Assert.IsFalse(adRepo.CanDeleteAd(id));
}
}
public void CarAd_mapping_standalonetable()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
IRepository repo = new Repository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
Province p = new Province { Label = "Province Sud" };
City c = new City { Label = "Nouméa", Province = p, LabelUrlPart = "city" };
p.AddCity(c);
repo.Save(p);
repo.Save(c);
User u = new User
{
Email = "email",
Password = "******"
};
repo.Save(u);
Category cat = new Category
{
Label = "label",
LabelUrlPart = "label"
};
repo.Save(cat);
CarAd carAd = new CarAd()
{
Title = "title",
Body = "bidy",
CreationDate = DateTime.Now,
IsOffer = true,
CreatedBy = u,
City = c,
Category = cat,
Kilometers = 2000,
Year = 2013
};
repo.Save(carAd);
Ad ad = new Ad()
{
Title = "title",
Body = "bidy",
CreationDate = DateTime.Now,
IsOffer = true,
CreatedBy = u,
City = c,
Category = cat
};
repo.Save(ad);
repo.Flush();
}
}
public void AdDetailsModel_ctor()
{
// Given
City c = new City()
{
Label = "Nouméa"
};
User u = new User()
{
Firstname = "Nicolas"
};
Category cat = new Category()
{
Label = "Auto",
LabelUrlPart = "Auto",
ParentCategory = new Category { Label = "Véhicules", LabelUrlPart = "Vehicules" }
};
Ad ad = new Ad()
{
Id = 17,
Title = "title",
Price = 1270,
City = c,
CreatedBy = u,
CreationDate = new DateTime(2012, 05, 12, 17, 26, 08),
Body = "body",
};
cat.AddAd(ad);
ad.Images.Add(new AdImage() { Id = Guid.Parse("e9da8b1e-aa77-401b-84e0-a1290130b7b7") });
ad.Images.Add(new AdImage() { Id = Guid.Parse("e9da8b1e-aa77-401b-84e0-a1290130b7b9") });
// When
AdDetailsModel model = new AdDetailsModel(ad);
// Then
Assert.AreEqual("title", model.Title);
Assert.AreEqual("Nouméa", model.Location);
Assert.AreEqual("Nicolas", model.UserFirstName);
Assert.AreEqual("samedi 12 mai 2012 17:26", model.CreationDateString);
Assert.AreEqual("body", model.Body);
Assert.AreEqual("1 270 Francs", model.Price);
Assert.AreEqual(17, model.AdId);
Assert.AreEqual(2, model.ImagesIds.Count);
Assert.AreEqual("e9da8b1e-aa77-401b-84e0-a1290130b7b7", model.ImagesIds[0]);
Assert.AreEqual("e9da8b1e-aa77-401b-84e0-a1290130b7b9", model.ImagesIds[1]);
Assert.AreEqual("Auto", model.Category);
Assert.AreEqual("Auto", model.CategoryUrlPart);
Assert.AreEqual("Véhicules", model.CategoryGroup);
Assert.AreEqual("Vehicules", model.CategoryGroupUrlPart);
}
public void AddUserWithPassword()
{
//Password is set to be non nullable, the save should throw an exception, and the user should not be added
User userToBeAdded = new User() {
Email = "*****@*****.**",
Password = "******"
};
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
sessionFactory.GetCurrentSession().Save(userToBeAdded);
IList<User> userToBeAddedFromDb = repo.GetAll<User>();
Assert.IsTrue(userToBeAddedFromDb.Count() == 1);
}
}
public void AdDetailsModel_ctor_WithCarAd_BrandAndFuel()
{
// Given
City c = new City()
{
Label = "Nouméa"
};
User u = new User()
{
Firstname = "Nicolas"
};
CarAd ad = new CarAd()
{
Id = 17,
Title = "title",
Price = 1270,
City = c,
CreatedBy = u,
CreationDate = new DateTime(2012, 05, 12, 17, 26, 08),
Body = "body",
Kilometers = 2000,
Year = 2013,
IsAutomatic = true,
Brand = new VehicleBrand { Label = "Honda" },
Fuel = new CarFuel { Label = "Super" }
};
// When
CarAdDetailsModel model = new CarAdDetailsModel(ad);
// Then
Assert.AreEqual("Honda", model.Brand);
Assert.AreEqual("Super", model.Fuel);
}
public void AdDetailsModel_ctor_WithCarAd_Automatique()
{
// Given
City c = new City()
{
Label = "Nouméa"
};
User u = new User()
{
Firstname = "Nicolas"
};
CarAd ad = new CarAd()
{
Id = 17,
Title = "title",
Price = 1270,
City = c,
CreatedBy = u,
CreationDate = new DateTime(2012, 05, 12, 17, 26, 08),
Body = "body",
Kilometers = 2000,
Year = 2013,
IsAutomatic = true
};
// When
CarAdDetailsModel model = new CarAdDetailsModel(ad);
// Then
Assert.AreEqual(17, model.AdId);
Assert.AreEqual(2000, model.Kilometers);
Assert.AreEqual(2013, model.Year);
Assert.AreEqual("Automatique", model.GearType);
}
public void AdvancedSearchAds_WaterSportAd_WaterSportProperties_ReturnWaterSportAd()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository adRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Bateau à moteur",
LabelUrlPart = "Bateau"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "bateau",
Body = "la desc du bateau",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
WaterSportType st = new WaterSportType()
{
Label = "pmt"
};
WaterSportAd bat = new WaterSportAd
{
Id = 1,
Title = "bateau",
Body = "la desc du bateau",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
CreatedBy = u,
Type = st
};
repo.Save(st);
repo.Save(p1);
repo.Save(c);
repo.Save(cat);
repo.Save(u);
repo.Save(bat);
repo.Save(a);
repo.Flush();
#endregion
AdSearchParameters param = new AdSearchParameters
{
WaterTypeId = 1
};
// When
IList<SearchAdCache> result = adRepo.AdvancedSearchAds<WaterSportAd>(param);
// Then
Assert.AreEqual(1, result.Count);
Assert.AreEqual(a, result[0]);
}
}
public void AdvancedSearchAds_RealEstateAds_RealEstateProperties_ReturnRealEstateAd()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository adRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Location",
LabelUrlPart = "Location"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "appart",
Body = "boite a chaussure",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
RealEstateType t1 = new RealEstateType
{
Label = "Location"
};
District d = new District
{
City = c,
Label = "Cheznous"
};
RealEstateAd loc = new RealEstateAd
{
Id = 1,
Title = "appart",
Body = "boite a chaussure",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
CreatedBy = u,
Type = t1,
District = d,
RoomsNumber = 5,
IsFurnished = true,
SurfaceArea = 45
};
repo.Save(t1);
repo.Save(d);
repo.Save(p1);
repo.Save(c);
repo.Save(cat);
repo.Save(u);
repo.Save(loc);
repo.Save(a);
MotoBrand brand = new MotoBrand
{
Label = "Suzuki"
};
SearchAdCache a2 = new SearchAdCache
{
AdId = 2,
Title = "appart2",
Body = "boite a chaussure",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
RealEstateAd loc2 = new RealEstateAd
{
Id = 2,
Title = "appart2",
Body = "boite a chaussure",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
CreatedBy = u,
Type = t1,
District = d,
RoomsNumber = 4,
IsFurnished = true,
SurfaceArea = 65
};
repo.Save(loc2);
repo.Save(a2);
repo.Flush();
#endregion
AdSearchParameters param = new AdSearchParameters
{
AndSearchStrings = new String[] { "appart" },
MinNbRooms = 2,
MaxNbRooms = 4,
DistrictId = 1,
RealEstateTypeId = 1,
IsFurnished = true,
MinSurfaceArea = 60,
MaxSurfaceArea = 65
};
// When
IList<SearchAdCache> result = adRepo.AdvancedSearchAds<RealEstateAd>(param);
// Then
Assert.AreEqual(1, result.Count);
Assert.AreEqual(a2, result[0]);
}
}
public void AdvancedSearchAds_MotorBoatEngineAd_MotorBoatEngineProperties_ReturnMotorBoatEngineAd()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository adRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Bateau à moteur",
LabelUrlPart = "Bateau"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "bateau",
Body = "la desc du bateau",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
MotorBoatEngineType mt = new MotorBoatEngineType()
{
Id = 7,
Label = "4 temps"
};
MotorBoatEngineAd bat = new MotorBoatEngineAd
{
Id = 1,
Title = "moteur",
Body = "la desc du bateau",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
CreatedBy = u,
Price = 1000,
Hp = 100,
Year = 2005,
MotorType = mt
};
repo.Save(mt);
repo.Save(p1);
repo.Save(c);
repo.Save(cat);
repo.Save(u);
repo.Save(bat);
repo.Save(a);
repo.Flush();
#endregion
AdSearchParameters param = new AdSearchParameters
{
MotorEngineTypeId = 1,
MinHp = 99,
MaxHp = 100,
MinYear = 2004,
MaxYear = 2006
};
// When
IList<SearchAdCache> result = adRepo.AdvancedSearchAds<MotorBoatEngineAd>(param);
// Then
Assert.AreEqual(1, result.Count);
Assert.AreEqual(a, result[0]);
}
}
public void AdvancedSearchAds_MotoAds_MotoProperties_ReturnMotoAd()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository adRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Auto",
LabelUrlPart = "Auto"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "aveo",
Body = "aveo sport 1.2 16s",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
CarAd car = new CarAd
{
Id = 1,
Title = "aveo",
Body = "aveo sport 1.2 16s",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
CreatedBy = u
};
repo.Save(p1);
repo.Save(c);
repo.Save(cat);
repo.Save(u);
repo.Save(car);
repo.Save(a);
Category cat2 = new Category
{
Label = "Moto",
LabelUrlPart = "Moto"
};
MotoBrand brand = new MotoBrand
{
Label = "Suzuki"
};
SearchAdCache a2 = new SearchAdCache
{
AdId = 2,
Title = "aveo",
Body = "aveo sport 1.2 16s",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat2
};
MotoAd moto = new MotoAd
{
Id = 2,
Title = "aveo",
Body = "aveo sport 1.2 16s",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat2,
Brand = brand,
EngineSize = 650,
CreatedBy = u
};
repo.Save(brand);
repo.Save(cat2);
repo.Save(moto);
repo.Save(a2);
repo.Flush();
#endregion
AdSearchParameters param = new AdSearchParameters
{
AndSearchStrings = new String[] { "aveo" },
BrandId = brand.Id,
MinEngineSize = 250,
MaxEngineSize = 800
};
// When
IList<SearchAdCache> result = adRepo.AdvancedSearchAds<MotoAd>(param);
// Then
Assert.AreEqual(1, result.Count);
Assert.AreEqual(a2, result[0]);
}
}
public void AdvancedSearchAds_Ad_MinMaxPrice_ReturnMatchingAds()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository adRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Location",
LabelUrlPart = "Location"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "chaussure",
Body = "boite a chaussure",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
Ad loc = new Ad
{
Id = 1,
Title = "chaussure",
Body = "boite a chaussure",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
CreatedBy = u,
Price = 1000
};
repo.Save(p1);
repo.Save(c);
repo.Save(cat);
repo.Save(u);
repo.Save(loc);
repo.Save(a);
SearchAdCache a2 = new SearchAdCache
{
AdId = 2,
Title = "chaussure",
Body = "boite a chaussure",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
Ad loc2 = new Ad
{
Id = 2,
Title = "chaussure",
Body = "boite a chaussure",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
CreatedBy = u,
Price = 2000
};
repo.Save(loc2);
repo.Save(a2);
repo.Flush();
#endregion
AdSearchParameters param = new AdSearchParameters
{
MinPrice = 0,
MaxPrice = 1000
};
// When
IList<SearchAdCache> result = adRepo.AdvancedSearchAds<Ad>(param);
// Then
Assert.AreEqual(1, result.Count);
Assert.AreEqual(a, result[0]);
}
}
public void AdvancedSearchAds_CarAds_CarProperties_ReturnCarAd()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository adRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Auto",
LabelUrlPart = "Auto"
};
CarFuel fuel = new CarFuel
{
Label = "Diesel"
};
VehicleBrand brand = new VehicleBrand
{
Label = "Aveo"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "aveo",
Body = "aveo sport 1.2 16s",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
CarAd car = new CarAd
{
Id = 1,
Title = "aveo",
Body = "aveo sport 1.2 16s",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
Year = 2011,
Kilometers = 10000,
IsAutomatic = true,
Fuel = fuel,
Brand = brand,
CreatedBy = u
};
repo.Save(brand);
repo.Save(fuel);
repo.Save(p1);
repo.Save(c);
repo.Save(cat);
repo.Save(u);
repo.Save(car);
repo.Save(a);
SearchAdCache a2 = new SearchAdCache
{
Title = "aveo",
Body = "aveo sport 1.2 16s",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
CarAd car2 = new CarAd
{
Id = 1,
Title = "aveo",
Body = "aveo sport 1.2 16s",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
Year = 2001,
Kilometers = 95000,
Brand = brand,
CreatedBy = u
};
repo.Save(car2);
repo.Save(a2);
repo.Flush();
#endregion
AdSearchParameters param = new AdSearchParameters
{
AndSearchStrings = new String[] { "aveo" },
MinKm = 0,
MaxKm = 11000,
MinYear = 2000,
MaxYear = 2012,
BrandId = brand.Id,
FueldId = fuel.Id,
IsAuto = true
};
// When
IList<SearchAdCache> result = adRepo.AdvancedSearchAds<CarAd>(param);
// Then
Assert.AreEqual(1, result.Count);
Assert.AreEqual(a, result[0]);
}
}
public void GetAdType_CarAdExists_ReturnType()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
AdRepository adRepo = new AdRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Auto",
LabelUrlPart = "Auto",
Type = AdTypeEnum.CarAd
};
CarAd a = new CarAd
{
Title = "honda civic type R",
Body = "the best!!",
CreatedBy = u,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
Kilometers = 25000,
Year = 1998
};
c.AddAd(a);
cat.AddAd(a);
repo.Save<Province>(p1);
repo.Save<City>(c);
repo.Save<Category>(cat);
long id = repo.Save<CarAd, long>(a);
repo.Flush();
#endregion
Assert.AreEqual(AdTypeEnum.CarAd, adRepo.GetAdType(id));
}
}
public void SearchAds_SearchByTitleAndBodyAndString_CreateWhereAndQuery()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository adRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Moto",
LabelUrlPart = "Moto"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "ship",
Body = "computer",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
repo.Save<Province>(p1);
repo.Save<City>(c);
repo.Save<Category>(cat);
repo.Save(a);
Province p2 = new Province
{
Label = "p2"
};
City c2 = new City
{
Label = "CherzmOi2",
LabelUrlPart = "city2"
};
p2.AddCity(c2);
SearchAdCache a2 = new SearchAdCache
{
AdId = 2,
Title = "ship",
Body = "content",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 17),
Category = cat
};
repo.Save<Province>(p2);
repo.Save<City>(c2);
repo.Save(a2);
repo.Flush();
#endregion
// When
IList<SearchAdCache> result = adRepo.SearchAds(new String[] { "computer", "ship" }, null, null);
// Then
Assert.AreEqual(1, result.Count);
Assert.AreEqual(a, result[0]);
}
}
public void CountByCategory_NoSearchString_Returnwholecount()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository searchRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Voilier",
LabelUrlPart = "Bateau"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "bateau 1",
Body = "la desc du bateau",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
Category cat2 = new Category
{
Label = "Bateau à moteur",
LabelUrlPart = "Bateau"
};
SearchAdCache a2 = new SearchAdCache
{
AdId = 2,
Title = "poupou",
Body = "la desc du bateau",
City = c,
CreationDate = new DateTime(2012, 06, 11, 23, 52, 18),
Category = cat2
};
repo.Save(p1);
repo.Save(c);
repo.Save(cat);
repo.Save(u);
repo.Save(a);
repo.Save(cat2);
repo.Save(a2);
repo.Flush();
#endregion
// When
IDictionary<Category, int> result = searchRepo.CountByCategory(new String[] { "bateau" }, null);
// Then
Assert.AreEqual(2, result.Count);
Assert.AreEqual(cat2, result.First().Key);
Assert.AreEqual(cat, result.Last().Key);
}
}
public void GetAdById_GetAd_ReturnAdObject()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
AdRepository adRepo = new AdRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "city",
LabelUrlPart = "city"
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Moto",
LabelUrlPart = "Moto"
};
Ad a = new Ad
{
Title = "ship",
Body = "computer",
CreatedBy = u,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
c.AddAd(a);
cat.AddAd(a);
repo.Save<Province>(p1);
repo.Save<City>(c);
repo.Save<Category>(cat);
long id = repo.Save<Ad, long>(a);
repo.Flush();
#endregion
Assert.AreEqual(a, adRepo.GetAdById<Ad>(id));
}
}
public void CountAdsByCity_2Citiesand3Ad_Return2elements()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
AdRepository adRepo = new AdRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "CherzmOi",
LabelUrlPart = "city"
};
Category cat = new Category
{
Label = "Bateau",
LabelUrlPart = "Bateau"
};
Ad a = new Ad
{
Title = "titre",
Body = "content",
CreatedBy = u,
City = c,
Category = cat
};
c.AddAd(a);
cat.AddAd(a);
repo.Save<City>(c);
repo.Save<Category>(cat);
repo.Save<Ad>(a);
Ad a2 = new Ad
{
Title = "titre",
Body = "content",
CreatedBy = u,
City = c,
Category = cat
};
c.AddAd(a2);
repo.Save<Ad>(a2);
City c2 = new City
{
Label = "CherzmOi 2",
LabelUrlPart = "city2",
};
Ad a3 = new Ad
{
Title = "titre",
Body = "content",
CreatedBy = u,
City = c2,
Category = cat
};
c2.AddAd(a3);
repo.Save<City>(c2);
repo.Save<Ad>(a3);
repo.Flush();
#endregion
// When
IDictionary<City, int> result = adRepo.CountAdsByCity();
// Then
Assert.AreEqual(2, result.Count);
Assert.AreEqual(2, result[c]);
Assert.AreEqual(1, result[c2]);
}
}
public void GetAdsByEmail_ReturnListOfAds_WithUserAndCategoryFetched()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
AdRepository adRepo = new AdRepository(sessionFactory);
Repository repo = new Repository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
#region test data
Province p1 = new Province
{
Label = "p1"
};
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
User u2 = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u2);
City c = new City
{
Label = "city",
LabelUrlPart = "city",
};
p1.AddCity(c);
Category cat = new Category
{
Label = "Informatique",
LabelUrlPart = "Informatique",
Type = AdTypeEnum.Ad
};
Category cat2 = new Category
{
Label = "Voiture",
LabelUrlPart = "Voiture",
Type = AdTypeEnum.Ad
};
Ad a = new Ad
{
Title = "video game",
Body = "the best!!",
CreatedBy = u,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat,
IsDeleted = false,
IsActivated = true
};
Ad a2 = new Ad
{
Title = "Ferrari F430",
Body = "Valab'",
CreatedBy = u,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat2,
IsDeleted = false,
IsActivated = true
};
Ad a3 = new Ad
{
Title = "Ferrari F430",
Body = "Valab'",
CreatedBy = u2,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat2,
IsDeleted = false,
IsActivated = true
};
c.AddAd(a);
c.AddAd(a2);
c.AddAd(a3);
cat.AddAd(a);
cat2.AddAd(a2);
cat2.AddAd(a3);
repo.Save<Province>(p1);
repo.Save<City>(c);
repo.Save<Category>(cat);
repo.Save<Category>(cat2);
repo.Save<Ad, long>(a);
repo.Save<Ad, long>(a2);
repo.Save<Ad, long>(a3);
repo.Flush();
#endregion
List<BaseAd> adsUser1 = adRepo.GetAdsByEmail(u.Email).ToList();
List<BaseAd> adsUser2 = adRepo.GetAdsByEmail(u2.Email).ToList();
Assert.AreEqual(2, adsUser1.Count);
Assert.AreEqual(u.Email, adsUser1[0].CreatedBy.Email);
Assert.AreEqual(1, adsUser2.Count);
Assert.AreEqual(u2.Email, adsUser2[0].CreatedBy.Email);
}
}
public void InsertInMemoryData()
{
//-------------------------------------------
// LOCATION REFERENCE TABLES
//-------------------------------------------
using (ITransaction transaction = _sessionFactory.GetCurrentSession().BeginTransaction())
{
//-------------------------------------------
// USER TABLE
//-------------------------------------------
//Create User 1
User user = new User();
user.Email = "*****@*****.**";
user.Password = "******";
user.Firstname = "Bruno";
user.Lastname = "Secret";
_sessionFactory.GetCurrentSession().Save(user);
//Create User 2
User user2 = new User();
user2.Email = "*****@*****.**";
user2.Password = "******";
user2.Firstname = "Nicolas";
user2.Lastname = "Secret";
_sessionFactory.GetCurrentSession().Save(user2);
//-------------------------------------------
// IMAGES
//-------------------------------------------
AdImage img1 = new AdImage();
img1.Id = Guid.Parse("acd04523-f2fc-47b5-a7af-50b33c49694f");
img1.IsPrimary = true;
img1.UploadedDate = new DateTime();
log.Info(_sessionFactory.GetCurrentSession().Save(img1));
AdImage img2 = new AdImage();
img2.Id = Guid.Parse("262dcc07-8c90-4af8-b99c-12e48afac89f");
img2.IsPrimary = true;
img2.UploadedDate = new DateTime();
log.Info(_sessionFactory.GetCurrentSession().Save(img2));
//-------------------------------------------
// AD TABLE
//-------------------------------------------
var normalCategories = _sessionFactory.GetCurrentSession().Query<Category>()
.Where(x => x.Type == AdTypeEnum.Ad)
.ToList();
int nbCategories = normalCategories.Count;
int nbCities = _repository.CountAll<City>();
for (int i = 1; i < 31; i++)
{
BaseAd ad = null;
ad = new Ad();
normalCategories[Faker.RandomNumber.Next(0, nbCategories - 1)].AddAd(ad);
Faker.Lorem.Words(3).ForEach(s => ad.Title += " " + s);
ad.Body = Faker.Lorem.Paragraph();
ad.IsOffer = true;
ad.CreationDate = DateTime.Now
.AddDays(Faker.RandomNumber.Next(-7, 0))
.AddHours(Faker.RandomNumber.Next(1, 23))
.AddMinutes(Faker.RandomNumber.Next(1, 59))
.AddSeconds(Faker.RandomNumber.Next(1, 59));
ad.Price = Faker.RandomNumber.Next(1, 300000);
ad.PhoneNumber = String.Format("{0}.{1}.{2}", Faker.RandomNumber.Next(20, 99), Faker.RandomNumber.Next(20, 99), Faker.RandomNumber.Next(20, 99));
if (i == 1)
ad.AddImage(img1);
if (i == 2)
ad.AddImage(img2);
ad.CreatedBy = user;
ad.IsActivated = false;
ad.ActivationToken = "activateme";
_repository.Get<City>(Faker.RandomNumber.Next(1, nbCities)).AddAd(ad);
_sessionFactory.GetCurrentSession().Save(ad);
}
_sessionFactory.GetCurrentSession().Update(img1);
_sessionFactory.GetCurrentSession().Update(img2);
//-------------------------------------------
// REFERENCE TABLES
//-------------------------------------------
transaction.Commit();
}
}
public void PerformDeleteAd_AdExists_PasswordDoesNotMatch()
{
// Given
DeleteAdModel model = new DeleteAdModel
{
AdId = 56,
Password = "******",
NbTry = 1,
SelectedDeletionReasonId = 7
};
User creator = new User()
{
Password = "******"
};
BaseAd ad = new Ad()
{
CreatedBy = creator
};
var adRepoMock = new Moq.Mock<IAdRepository>();
adRepoMock.Setup(r => r.GetAdById<BaseAd>(model.AdId)).Returns(ad);
AdDeletionServices service = new AdDeletionServices(adRepoMock.Object, null, null);
// When
DeleteAdModel result = service.DeleteAd(model);
// Then
Assert.AreEqual(model.AdId, result.AdId);
Assert.IsNull(result.Password);
Assert.AreEqual(7, result.SelectedDeletionReasonId);
Assert.AreEqual(2, result.NbTry);
Assert.IsNull(result.InfoMessage);
Assert.IsTrue(result.CanDeleteAd);
Assert.IsFalse(result.IsDeleted);
}
public void SearchAds_SearchByTitleAndCategories()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
SearchRepository adRepo = new SearchRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "CherzmOi",
LabelUrlPart = "city"
};
Category cat = new Category
{
Label = "Moto",
LabelUrlPart = "Moto"
};
SearchAdCache a = new SearchAdCache
{
AdId = 1,
Title = "titre 1",
Body = "content",
City = c,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18),
Category = cat
};
repo.Save<City>(c);
repo.Save<Category>(cat);
repo.Save(a);
City c2 = new City
{
Label = "CherzmOi2",
LabelUrlPart = "city2"
};
Category cat2 = new Category
{
Label = "Auto",
LabelUrlPart = "Auto"
};
SearchAdCache a2 = new SearchAdCache
{
AdId = 2,
Title = "title 2",
Body = "content",
City = c2,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 17),
Category = cat2
};
repo.Save<City>(c2);
repo.Save<Category>(cat2);
repo.Save(a2);
repo.Flush();
#endregion
// When
IList<SearchAdCache> result = adRepo.SearchAds(andSearchStrings: new String[] { "ti" }, categoryIds: new int[] { cat.Id, cat2.Id });
// Then
Assert.AreEqual(2, result.Count);
Assert.AreEqual(a, result[0]);
Assert.AreEqual(a2, result[1]);
}
}
public void PerformDeleteAd_AdExists_PasswordMatches_MarkAdAsDeletedAndRemoveFromSearchAdCache()
{
// Given
DeleteAdModel model = new DeleteAdModel
{
AdId = 56,
Password = "******",
NbTry = 1,
SelectedDeletionReasonId = 7
};
DeletionReason dr = new DeletionReason() { Id = 7 };
SearchAdCache adc = new SearchAdCache() { AdId = 56 };
User creator = new User()
{
Password = "******"
};
BaseAd ad = new Ad()
{
Id = 56,
CreatedBy = creator
};
var adRepoMock = new Moq.Mock<IAdRepository>();
adRepoMock.Setup(r => r.GetAdById<BaseAd>(model.AdId)).Returns(ad);
var repoMock = new Moq.Mock<IRepository>();
repoMock.Setup(x => x.Get<DeletionReason>(7)).Returns(dr);
repoMock.Setup(x => x.Get<SearchAdCache>(model.AdId)).Returns(adc);
repoMock.Setup(x => x.Save<BaseAd>(ad));
repoMock.Setup(x => x.Delete<SearchAdCache>(adc));
var helperMock = new Moq.Mock<IHelperService>();
helperMock.Setup(x => x.GetCurrentDateTime()).Returns(new DateTime(2013, 01, 26));
AdDeletionServices service = new AdDeletionServices(adRepoMock.Object, repoMock.Object, helperMock.Object);
// When
DeleteAdModel result = service.DeleteAd(model);
// Then
Assert.AreEqual(model.AdId, result.AdId);
Assert.IsNull(result.Password);
Assert.IsNull(result.SelectedDeletionReasonId);
Assert.AreEqual(0, result.NbTry);
Assert.AreEqual("Votre annonce a correctement été supprimée. Elle n'est plus disponible à la recherche.", result.InfoMessage);
Assert.IsFalse(result.CanDeleteAd);
Assert.IsTrue(result.IsDeleted);
Assert.AreEqual(new DateTime(2013, 01, 26), ad.DeletionDate);
Assert.IsTrue(ad.IsDeleted);
Assert.AreEqual(dr, ad.DeletedReason);
repoMock.Verify(x => x.Save<BaseAd>(ad), Times.Once());
repoMock.Verify(x => x.Delete<SearchAdCache>(adc), Times.Once());
}
public void SearchAdsByTitle_SearchStringIsNull_ReturnEverythingOrderedByCreationDate()
{
ISessionFactory sessionFactory = NhibernateHelper.SessionFactory;
Repository repo = new Repository(sessionFactory);
AdRepository adRepo = new AdRepository(sessionFactory);
using (ITransaction transaction = sessionFactory.GetCurrentSession().BeginTransaction())
{
// Given
#region test data
User u = new User
{
Email = "*****@*****.**",
Password = "******"
};
repo.Save<User>(u);
City c = new City
{
Label = "CherzmOi",
LabelUrlPart = "city"
};
Category cat = new Category
{
Label = "Moto",
LabelUrlPart = "Moto"
};
Ad a = new Ad
{
Title = "titre 1",
Body = "content",
CreatedBy = u,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 12)
};
c.AddAd(a);
cat.AddAd(a);
repo.Save<City>(c);
repo.Save<Category>(cat);
repo.Save<Ad>(a);
Ad a2 = new Ad
{
Title = "title 2",
Body = "content",
CreatedBy = u,
CreationDate = new DateTime(2012, 01, 16, 23, 52, 18)
};
c.AddAd(a2);
cat.AddAd(a2);
repo.Save<Ad>(a2);
repo.Flush();
#endregion
// When
IList<Ad> result = adRepo.SearchAdsByTitle(null);
// Then
Assert.AreEqual(2, result.Count);
Assert.AreEqual(a2, result[0]);
Assert.AreEqual(a, result[1]);
}
}