public void GetPolSourceSiteEffectList_2Where_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
foreach (string extra in new List <string>()
{
null, "A", "B", "C", "D", "E"
})
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
polSourceSiteEffectService.Query = polSourceSiteEffectService.FillQuery(typeof(PolSourceSiteEffect), culture.TwoLetterISOLanguageName, 0, 10000, "", "", "PolSourceSiteEffectID,GT,2|PolSourceSiteEffectID,LT,5", extra);
List <PolSourceSiteEffect> polSourceSiteEffectDirectQueryList = new List <PolSourceSiteEffect>();
polSourceSiteEffectDirectQueryList = (from c in dbTestDB.PolSourceSiteEffects select c).Where(c => c.PolSourceSiteEffectID > 2 && c.PolSourceSiteEffectID < 5).ToList();
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceSiteEffect> polSourceSiteEffectList = new List <PolSourceSiteEffect>();
polSourceSiteEffectList = polSourceSiteEffectService.GetPolSourceSiteEffectList().ToList();
CheckPolSourceSiteEffectFields(polSourceSiteEffectList);
Assert.AreEqual(polSourceSiteEffectDirectQueryList[0].PolSourceSiteEffectID, polSourceSiteEffectList[0].PolSourceSiteEffectID);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public void GetPolSourceSiteEffectList_Skip_Take_2Desc_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
foreach (string extra in new List <string>()
{
null, "A", "B", "C", "D", "E"
})
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
polSourceSiteEffectService.Query = polSourceSiteEffectService.FillQuery(typeof(PolSourceSiteEffect), culture.TwoLetterISOLanguageName, 1, 1, "", "PolSourceSiteEffectID,PolSourceSiteOrInfrastructureTVItemID", "", extra);
List <PolSourceSiteEffect> polSourceSiteEffectDirectQueryList = new List <PolSourceSiteEffect>();
polSourceSiteEffectDirectQueryList = (from c in dbTestDB.PolSourceSiteEffects select c).OrderByDescending(c => c.PolSourceSiteEffectID).ThenByDescending(c => c.PolSourceSiteOrInfrastructureTVItemID).Skip(1).Take(1).ToList();
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceSiteEffect> polSourceSiteEffectList = new List <PolSourceSiteEffect>();
polSourceSiteEffectList = polSourceSiteEffectService.GetPolSourceSiteEffectList().ToList();
CheckPolSourceSiteEffectFields(polSourceSiteEffectList);
Assert.AreEqual(polSourceSiteEffectDirectQueryList[0].PolSourceSiteEffectID, polSourceSiteEffectList[0].PolSourceSiteEffectID);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}