public void GetRestaurantsAsync_NoFilter_ReturnsAll()
{
var ids = FillRestaurants();
var sut = new RestaurantDataManager(DbContext);
var result = sut.GetRestaurantsAsync(1, 100, null).Result.ToList();
Assert.AreEqual(result.Count(), 4);
}
public void DeleteRestaurantAsync_Success()
{
var ids = FillRestaurants();
var sut = new RestaurantDataManager(DbContext);
sut.DeleteRestaurantAsync(ids.First()).Wait();
var count = this.ExecuteScalar <int>(string.Format("select count(*) from Restaurant where Id={0}", ids.First()));
Assert.AreEqual(count, 0);
}
public void GetRestaurantsAsync_FilterByCity_ReturnsAll()
{
var ids = FillRestaurants();
var sut = new RestaurantDataManager(DbContext);
var filter = new DbFilter <Restaurant> {
Field = "City", Operator = OperatorEnum.Equal, Value = "ChocoCity"
};
var result = sut.GetRestaurantsAsync(1, 100, filter).Result.ToList();
Assert.AreEqual(result.Count(), 3);
}
public void GetRestaurantAsync_Success()
{
var ids = FillRestaurants();
var sut = new RestaurantDataManager(DbContext);
var result = sut.GetRestaurantAsync(ids.First()).Result;
Assert.AreEqual(result.Id, ids.First());
Assert.AreEqual(result.Name, "cool cones");
Assert.AreEqual(result.Address, "123 milky way");
Assert.AreEqual(result.City, "ChocoCity");
}
public void GetRestaurantsAsync_Paged_AreOrderedByName()
{
var ids = FillRestaurants();
var sut = new RestaurantDataManager(DbContext);
var result = sut.GetRestaurantsAsync(1, 2, null).Result.ToList();
Assert.AreEqual(result.Count(), 2);
Assert.AreEqual(result[0].Name, "burgatory");
Assert.AreEqual(result[1].Name, "candy R us");
result = sut.GetRestaurantsAsync(2, 2, null).Result.ToList();
Assert.AreEqual(result.Count(), 2);
Assert.AreEqual(result[0].Name, "cool cones");
Assert.AreEqual(result[1].Name, "cupcakes for everyone");
}
public void CreateRestaurantAsync_Success()
{
var restaurantToCreate = new Restaurant()
{
Name = "Cool Cones", Address = "123 milkshake way", City = "Chocoburgh"
};
var sut = new RestaurantDataManager(DbContext);
var result = sut.CreateRestaurantAsync(restaurantToCreate).Result;
Assert.IsTrue(result.Id > 0);
Assert.AreEqual(result.Name, "Cool Cones");
using (var reader = this.ExecuteReader("select * from Restaurant where Id=@Id", System.Data.CommandType.Text,
new System.Data.SqlClient.SqlParameter()
{
ParameterName = "Id", SqlDbType = System.Data.SqlDbType.Int, Value = result.Id
}))
{
reader.Read();
var actualName = reader.GetValue(reader.GetOrdinal("Name"));
var actualCity = reader.GetValue(reader.GetOrdinal("City"));
Assert.AreEqual(restaurantToCreate.Name, actualName);
Assert.AreEqual(restaurantToCreate.City, actualCity);
}
}
