public void Address_Controller_GetAddressList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
AddressController addressController = new AddressController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(addressController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, addressController.DatabaseType);
Address addressFirst = new Address();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
AddressService addressService = new AddressService(query, db, ContactID);
addressFirst = (from c in db.Addresses select c).FirstOrDefault();
count = (from c in db.Addresses select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with Address info
IHttpActionResult jsonRet = addressController.GetAddressList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <Address> > ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressFirst.AddressID, ret.Content[0].AddressID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <Address> addressList = new List <Address>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
AddressService addressService = new AddressService(query, db, ContactID);
addressList = (from c in db.Addresses select c).OrderBy(c => c.AddressID).Skip(0).Take(2).ToList();
count = (from c in db.Addresses select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with Address info
jsonRet = addressController.GetAddressList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList[0].AddressID, ret.Content[0].AddressID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
if (count > 1)
{
query.Skip = 1;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with Address info
IHttpActionResult jsonRet2 = addressController.GetAddressList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <Address> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList[1].AddressID, ret2.Content[0].AddressID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void Address_Controller_GetAddressList()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
})
{
List <Address> addressList = null;
AddressController addressController = new AddressController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(addressController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, addressController.DatabaseType);
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
AddressService addressService = new AddressService(new Query(), db, ContactID);
addressList = (from c in db.Addresses select c).ToList();
count = addressList.Count;
}
// GetAddressList()
IHttpActionResult jsonRet = addressController.GetAddressList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <Address> > ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList[0].AddressID, ret.Content[0].AddressID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
// GetAddressList(lang)
string lang = query.Language.ToString();
jsonRet = addressController.GetAddressList(lang);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList[0].AddressID, ret.Content[0].AddressID);
Assert.AreEqual(addressList.Count, ret.Content.Count);
// GetAddressList(lang, skip)
int skip = 1;
jsonRet = addressController.GetAddressList(lang, skip);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList[1].AddressID, ret.Content[0].AddressID);
Assert.AreEqual(addressList.Count - 1, ret.Content.Count);
// GetAddressList(lang, skip, take)
int take = 1;
jsonRet = addressController.GetAddressList(lang, skip, take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList[1].AddressID, ret.Content[0].AddressID);
Assert.AreEqual(take, ret.Content.Count);
// GetAddressList(lang, skip, take, order)
string order = "LastUpdateDate_UTC";
jsonRet = addressController.GetAddressList(lang, skip, take, order);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList.OrderBy(c => c.LastUpdateDate_UTC).Skip(1).Take(1).FirstOrDefault().AddressID, ret.Content[0].AddressID);
Assert.AreEqual(take, ret.Content.Count);
// GetAddressList(lang, skip, take, order, where)
string where = "AddressID,EQ,3";
jsonRet = addressController.GetAddressList(lang: lang, where : where);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList.Where(c => c.AddressID == 3).FirstOrDefault().AddressID, ret.Content[0].AddressID);
Assert.AreEqual(1, ret.Content.Count);
// GetAddressList(lang, skip, take, order, where)
where = "AddressID,GT,2|AddressID,LT,5";
jsonRet = addressController.GetAddressList(lang: lang, where : where);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <Address> >;
Assert.AreEqual(addressList.Where(c => c.AddressID > 2 && c.AddressID < 5).FirstOrDefault().AddressID, ret.Content[0].AddressID);
Assert.AreEqual(2, ret.Content.Count);
}
}
}
