public void Delete()
{
using (var ds = new DataService())
{
ds.ResetDatabase();
//classique
var newProduct = new T_E_Product();
newProduct.Description = "Add Product 1";
ds.Add(newProduct);
var productList = ds.GetList <T_E_Product>().ToList();
if (productList.Count != 1)
{
throw new Exception();
}
ds.Delete(newProduct);
if (ds.GetList <T_E_Product>().Count() != 0)
{
throw new Exception();
}
ds.ResetDatabase();
}
}
public void Add()
{
try
{
using (var ds = new DataService())
{
ds.ResetDatabase();
//classique
var newProduct = new T_E_Product();
newProduct.Description = "Product 1";
newProduct.Ranking = 1;
ds.Add(newProduct);
var productList = ds.GetList <T_E_Product>().ToList();
if (productList.Count != 1)
{
throw new Exception();
}
T_E_Product getProduct = productList.Single();
if (newProduct.Description != getProduct.Description)
{
throw new Exception();
}
//with error
var newProduct2 = new T_E_Product();
try
{
ds.Add(newProduct2);
throw new Exception();
}
catch { }
//classique
var newProduct3 = new T_E_Product();
newProduct3.Description = "Product 1";
ds.Add(newProduct3);
if (ds.GetList <T_E_Product>().Count() != 2)
{
throw new Exception();
}
ds.ResetDatabase();
}
}
catch (Exception)
{
throw;
}
}
public void Update()
{
using (var ds = new DataService())
{
ds.ResetDatabase();
//classique
var newProduct = new T_E_Product();
newProduct.Description = "Add Product 1";
ds.Add(newProduct);
var productList = ds.GetList <T_E_Product>().ToList();
if (productList.Count != 1)
{
throw new Exception();
}
T_E_Product getProduct = productList.Single();
if (newProduct.Description != getProduct.Description)
{
throw new Exception();
}
getProduct.Description = "Update product2";
ds.Update(getProduct);
T_E_Product getProduct2 = ds.GetSingle <T_E_Product>(x => x.ProductId == getProduct.ProductId);
if (getProduct2.Description != getProduct.Description)
{
throw new Exception();
}
//with error
try
{
getProduct2.Description = null;
ds.Update(getProduct2);
throw new Exception();
}
catch { }
//classique add
getProduct2.Description = "Update product3";
ds.Update(getProduct2);
ds.ResetDatabase();
}
}
public void GetListBatchLoading()
{
using (var ds = new DataService())
{
ds.ResetDatabase();
for (int a = 1; a <= 100; a++)
{
var newProduct1 = new T_E_Product();
newProduct1.Ranking = a;
newProduct1.Description = a + " Product";
newProduct1 = ds.Add(newProduct1);
var newPicture = new T_E_Picture();
newPicture.Name = "picture " + newProduct1.Description;
newPicture.ProductId = newProduct1.ProductId;
newPicture = ds.Add(newPicture);
}
var navPictureList = new List <System.Linq.Expressions.Expression <Func <T_E_Picture, object> > >();
navPictureList.Add(x => x.T_E_Product);
if (ds.GetList <T_E_Picture>(null, navPictureList).ToList().Where(x => x.T_E_Product != null).Count() != 100)
{
throw new Exception();
}
if (ds.GetList <T_E_Picture>().ToList().Enum().Where(x => x.T_E_Product != null).Count() != 0)
{
throw new Exception();
}
var iquery = ds.GetListBatchLoading <T_E_Picture, long>(x => x.PictureId, System.ComponentModel.ListSortDirection.Descending, navPictureList, null, 10, 10);
if (iquery.Where(x => x.T_E_Product == null).IsNotNullAndNotEmpty())
{
throw new Exception();
}
ds.ResetDatabase();
}
}
public void DeleteList()
{
using (var ds = new DataService())
{
ds.ResetDatabase();
//classique
var deleteList = new List <T_E_Product>();
var newProduct1 = new T_E_Product();
newProduct1.Description = "Product 1";
deleteList.Add(newProduct1);
var newProduct2 = new T_E_Product();
newProduct2.Description = "Product 2";
deleteList.Add(newProduct2);
var newProduct3 = new T_E_Product();
newProduct3.Description = "Product 3";
deleteList.Add(newProduct3);
ds.AddList(deleteList);
var productList = ds.GetList <T_E_Product>().ToList();
if (productList.Count != 3)
{
throw new Exception();
}
ds.DeleteList(deleteList);
productList = null;
productList = ds.GetList <T_E_Product>().ToList();
if (productList.Count != 0)
{
throw new Exception();
}
ds.ResetDatabase();
}
}
public void GetSingle()
{
using (var ds = new DataService())
{
ds.ResetDatabase();
var newProduct1 = new T_E_Product();
newProduct1.Ranking = 1;
newProduct1.Description = "Product";
newProduct1 = ds.Add(newProduct1);
var newPicture = new T_E_Picture();
newPicture.ProductId = newProduct1.ProductId;
newPicture.Name = "picture";
newPicture = ds.Add(newPicture);
var get1 = ds.GetSingle <T_E_Product>(x => x.Ranking == 1);
if (get1.Ranking != 1)
{
throw new Exception();
}
if (get1.Description != "Product")
{
throw new Exception();
}
var navPictureList = new List <System.Linq.Expressions.Expression <Func <T_E_Picture, object> > >();
navPictureList.Add(x => x.T_E_Product);
var get2 = ds.GetSingle <T_E_Picture>(x => x.Name == "picture", navPictureList);
if (get2.T_E_Product == null)
{
throw new Exception();
}
ds.ResetDatabase();
}
}
public void GetList()
{
using (var ds = new DataService())
{
ds.ResetDatabase();
for (int a = 1; a <= 100; a++)
{
var newProduct1 = new T_E_Product();
newProduct1.Ranking = a;
newProduct1.Description = a + " Product";
newProduct1 = ds.Add(newProduct1);
var newPicture = new T_E_Picture();
newPicture.Name = "picture " + newProduct1.Description;
newPicture.ProductId = newProduct1.ProductId;
newPicture = ds.Add(newPicture);
}
//GetList<T>
if (ds.GetList <T_E_Product>().Count() != 100)
{
throw new Exception();
}
if (ds.GetList <T_E_Product>(x => x.Description.Contains("Product")).Count() != 100)
{
throw new Exception();
}
var navPictureList = new List <System.Linq.Expressions.Expression <Func <T_E_Picture, object> > >();
navPictureList.Add(x => x.T_E_Product);
if (ds.GetList <T_E_Picture>(null, navPictureList).ToList().Where(x => x.T_E_Product != null).Count() != 100)
{
throw new Exception();
}
if (ds.GetList <T_E_Picture>().ToList().Enum().Where(x => x.T_E_Product != null).Count() != 0)
{
throw new Exception();
}
//GetList<T,Tkey>
var iquery = ds.GetList <T_E_Product, int>(null, null, x => x.Ranking, System.ComponentModel.ListSortDirection.Descending);
if (iquery.First().Ranking != 100)
{
throw new Exception();
}
if (iquery.Last().Ranking != 1)
{
throw new Exception();
}
iquery = ds.GetList <T_E_Product, int>(null, null, x => x.Ranking, System.ComponentModel.ListSortDirection.Descending, 10, 10);
if (iquery.Count() != 10)
{
throw new Exception();
}
if (iquery.First().Ranking != 90)
{
throw new Exception();
}
if (iquery.Last().Ranking != 81)
{
throw new Exception();
}
ds.ResetDatabase();
}
}
public void UpdateList()
{
using (var ds = new DataService())
{
ds.ResetDatabase();
//classique
var deleteList = new List <T_E_Product>();
var newProduct1 = new T_E_Product();
newProduct1.Description = "Product 1";
deleteList.Add(newProduct1);
var newProduct2 = new T_E_Product();
newProduct2.Description = "Product 2";
deleteList.Add(newProduct2);
var newProduct3 = new T_E_Product();
newProduct3.Description = "Product 3";
deleteList.Add(newProduct3);
ds.AddList(deleteList);
var productList = ds.GetList <T_E_Product>().ToList();
if (productList.Count != 3)
{
throw new Exception();
}
foreach (var item in productList)
{
item.Description = "Update 4";
}
ds.UpdateList(productList);
var getProductList = ds.GetList <T_E_Product>().ToList();
//vérification de la modification
foreach (var item in getProductList)
{
if (item.Description != "Update 4")
{
throw new Exception();
}
}
//Passe avec une erreur
getProductList.First().Description = null;
try
{
ds.UpdateList(getProductList);
throw new Exception();
}
catch { }
getProductList.First().Description = "Update5";
ds.UpdateList(getProductList);
ds.ResetDatabase();
}
}
public void AddList()
{
using (var ds = new DataService())
{
ds.ResetDatabase();
//classique
var addList = new List <T_E_Product>();
var newProduct1 = new T_E_Product();
newProduct1.Description = "Product 1";
addList.Add(newProduct1);
var newProduct2 = new T_E_Product();
newProduct2.Description = "Product 2";
addList.Add(newProduct2);
var newProduct3 = new T_E_Product();
newProduct3.Description = "Product 3";
addList.Add(newProduct3);
ds.AddList(addList);
var productList = ds.GetList <T_E_Product>().ToList();
if (productList.Count != 3)
{
throw new Exception();
}
//avec erreur
var addList2 = new List <T_E_Product>();
var newProduct4 = new T_E_Product();
newProduct4.Description = "newProduct4";
addList2.Add(newProduct4);
var newProduct5 = new T_E_Product();
newProduct5.Description = null; // provoque l'erreur
addList2.Add(newProduct5);
try
{
ds.AddList(addList2);
throw new Exception();
}
catch { }
if (productList.Count != 3)
{
throw new Exception();
}
//classique
var addList3 = new List <T_E_Product>();
var newProduct6 = new T_E_Product();
newProduct6.Description = "newProduct6";
addList3.Add(newProduct6);
var newProduct7 = new T_E_Product();
newProduct7.Description = "Product 7";
addList3.Add(newProduct7);
ds.AddList(addList3);
if (ds.GetList <T_E_Product>().Count() != 5)
{
throw new Exception();
}
ds.ResetDatabase();
}
}
