public void TVItemLink_CRUD_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
int count = 0;
if (count == 1)
{
// just so we don't get a warning during compile [The variable 'count' is assigned but its value is never used]
}
TVItemLink tvItemLink = GetFilledRandomTVItemLink("");
// -------------------------------
// -------------------------------
// CRUD testing
// -------------------------------
// -------------------------------
count = tvItemLinkService.GetTVItemLinkList().Count();
Assert.AreEqual(count, (from c in dbTestDB.TVItemLinks select c).Count());
tvItemLinkService.Add(tvItemLink);
if (tvItemLink.HasErrors)
{
Assert.AreEqual("", tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(true, tvItemLinkService.GetTVItemLinkList().Where(c => c == tvItemLink).Any());
tvItemLinkService.Update(tvItemLink);
if (tvItemLink.HasErrors)
{
Assert.AreEqual("", tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count + 1, tvItemLinkService.GetTVItemLinkList().Count());
tvItemLinkService.Delete(tvItemLink);
if (tvItemLink.HasErrors)
{
Assert.AreEqual("", tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count, tvItemLinkService.GetTVItemLinkList().Count());
}
}
}
public void GetTVItemLinkList_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
TVItemLink tvItemLink = (from c in dbTestDB.TVItemLinks select c).FirstOrDefault();
Assert.IsNotNull(tvItemLink);
List <TVItemLink> tvItemLinkDirectQueryList = new List <TVItemLink>();
tvItemLinkDirectQueryList = (from c in dbTestDB.TVItemLinks select c).Take(200).ToList();
foreach (string extra in new List <string>()
{
null, "A", "B", "C", "D", "E"
})
{
tvItemLinkService.Query.Extra = extra;
if (string.IsNullOrWhiteSpace(extra))
{
List <TVItemLink> tvItemLinkList = new List <TVItemLink>();
tvItemLinkList = tvItemLinkService.GetTVItemLinkList().ToList();
CheckTVItemLinkFields(tvItemLinkList);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public void GetTVItemLinkList_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"
})
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
tvItemLinkService.Query = tvItemLinkService.FillQuery(typeof(TVItemLink), culture.TwoLetterISOLanguageName, 0, 10000, "", "", "TVItemLinkID,GT,2|TVItemLinkID,LT,5", extra);
List <TVItemLink> tvItemLinkDirectQueryList = new List <TVItemLink>();
tvItemLinkDirectQueryList = (from c in dbTestDB.TVItemLinks select c).Where(c => c.TVItemLinkID > 2 && c.TVItemLinkID < 5).ToList();
if (string.IsNullOrWhiteSpace(extra))
{
List <TVItemLink> tvItemLinkList = new List <TVItemLink>();
tvItemLinkList = tvItemLinkService.GetTVItemLinkList().ToList();
CheckTVItemLinkFields(tvItemLinkList);
Assert.AreEqual(tvItemLinkDirectQueryList[0].TVItemLinkID, tvItemLinkList[0].TVItemLinkID);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public IHttpActionResult GetTVItemLinkList([FromUri] string lang = "en", [FromUri] int skip = 0, [FromUri] int take = 200,
[FromUri] string asc = "", [FromUri] string desc = "", [FromUri] string where = "", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(new Query()
{
Lang = lang
}, db, ContactID);
if (extra == "A") // QueryString contains [extra=A]
{
tvItemLinkService.Query = tvItemLinkService.FillQuery(typeof(TVItemLinkExtraA), lang, skip, take, asc, desc, where, extra);
if (tvItemLinkService.Query.HasErrors)
{
return(Ok(new List <TVItemLinkExtraA>()
{
new TVItemLinkExtraA()
{
HasErrors = tvItemLinkService.Query.HasErrors,
ValidationResults = tvItemLinkService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(tvItemLinkService.GetTVItemLinkExtraAList().ToList()));
}
}
else if (extra == "B") // QueryString contains [extra=B]
{
tvItemLinkService.Query = tvItemLinkService.FillQuery(typeof(TVItemLinkExtraB), lang, skip, take, asc, desc, where, extra);
if (tvItemLinkService.Query.HasErrors)
{
return(Ok(new List <TVItemLinkExtraB>()
{
new TVItemLinkExtraB()
{
HasErrors = tvItemLinkService.Query.HasErrors,
ValidationResults = tvItemLinkService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(tvItemLinkService.GetTVItemLinkExtraBList().ToList()));
}
}
else // QueryString has no parameter [extra] or extra is empty
{
tvItemLinkService.Query = tvItemLinkService.FillQuery(typeof(TVItemLink), lang, skip, take, asc, desc, where, extra);
if (tvItemLinkService.Query.HasErrors)
{
return(Ok(new List <TVItemLink>()
{
new TVItemLink()
{
HasErrors = tvItemLinkService.Query.HasErrors,
ValidationResults = tvItemLinkService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(tvItemLinkService.GetTVItemLinkList().ToList()));
}
}
}
}
public void TVItemLink_Properties_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
int count = 0;
if (count == 1)
{
// just so we don't get a warning during compile [The variable 'count' is assigned but its value is never used]
}
count = tvItemLinkService.GetTVItemLinkList().Count();
TVItemLink tvItemLink = GetFilledRandomTVItemLink("");
// -------------------------------
// -------------------------------
// Properties testing
// -------------------------------
// -------------------------------
// -----------------------------------
// [Key]
// Is NOT Nullable
// tvItemLink.TVItemLinkID (Int32)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.TVItemLinkID = 0;
tvItemLinkService.Update(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "TVItemLinkID"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.TVItemLinkID = 10000000;
tvItemLinkService.Update(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItemLink", "TVItemLinkID", tvItemLink.TVItemLinkID.ToString()), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Root,Address,Area,ClimateSite,Contact,Country,Email,File,HydrometricSite,Infrastructure,MikeScenario,MikeSource,Municipality,MWQMSite,PolSourceSite,Province,Sector,Subsector,Tel,TideSite,WasteWaterTreatmentPlant,LiftStation,Spill,BoxModel,VisualPlumesScenario,OtherInfrastructure,MWQMRun,MeshNode,WebTideNode,SamplingPlan,SeeOtherMunicipality,LineOverflow,MapInfo,MapInfoPoint)]
// tvItemLink.FromTVItemID (Int32)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.FromTVItemID = 0;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "FromTVItemID", tvItemLink.FromTVItemID.ToString()), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.FromTVItemID = 13;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "FromTVItemID", "Root,Address,Area,ClimateSite,Contact,Country,Email,File,HydrometricSite,Infrastructure,MikeScenario,MikeSource,Municipality,MWQMSite,PolSourceSite,Province,Sector,Subsector,Tel,TideSite,WasteWaterTreatmentPlant,LiftStation,Spill,BoxModel,VisualPlumesScenario,OtherInfrastructure,MWQMRun,MeshNode,WebTideNode,SamplingPlan,SeeOtherMunicipality,LineOverflow,MapInfo,MapInfoPoint"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Root,Address,Area,ClimateSite,Contact,Country,Email,File,HydrometricSite,Infrastructure,MikeScenario,MikeSource,Municipality,MWQMSite,PolSourceSite,Province,Sector,Subsector,Tel,TideSite,WasteWaterTreatmentPlant,LiftStation,Spill,BoxModel,VisualPlumesScenario,OtherInfrastructure,MWQMRun,MeshNode,WebTideNode,SamplingPlan,SeeOtherMunicipality,LineOverflow,MapInfo,MapInfoPoint)]
// tvItemLink.ToTVItemID (Int32)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.ToTVItemID = 0;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "ToTVItemID", tvItemLink.ToTVItemID.ToString()), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.ToTVItemID = 13;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "ToTVItemID", "Root,Address,Area,ClimateSite,Contact,Country,Email,File,HydrometricSite,Infrastructure,MikeScenario,MikeSource,Municipality,MWQMSite,PolSourceSite,Province,Sector,Subsector,Tel,TideSite,WasteWaterTreatmentPlant,LiftStation,Spill,BoxModel,VisualPlumesScenario,OtherInfrastructure,MWQMRun,MeshNode,WebTideNode,SamplingPlan,SeeOtherMunicipality,LineOverflow,MapInfo,MapInfoPoint"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPEnumType]
// tvItemLink.FromTVType (TVTypeEnum)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.FromTVType = (TVTypeEnum)1000000;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "FromTVType"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPEnumType]
// tvItemLink.ToTVType (TVTypeEnum)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.ToTVType = (TVTypeEnum)1000000;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "ToTVType"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is Nullable
// [CSSPAfter(Year = 1980)]
// tvItemLink.StartDateTime_Local (DateTime)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.StartDateTime_Local = new DateTime(1979, 1, 1);
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "StartDateTime_Local", "1980"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is Nullable
// [CSSPAfter(Year = 1980)]
// [CSSPBigger(OtherField = StartDateTime_Local)]
// tvItemLink.EndDateTime_Local (DateTime)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.EndDateTime_Local = new DateTime(1979, 1, 1);
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "EndDateTime_Local", "1980"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [Range(0, 100)]
// tvItemLink.Ordinal (Int32)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.Ordinal = -1;
Assert.AreEqual(false, tvItemLinkService.Add(tvItemLink));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Ordinal", "0", "100"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, tvItemLinkService.GetTVItemLinkList().Count());
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.Ordinal = 101;
Assert.AreEqual(false, tvItemLinkService.Add(tvItemLink));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Ordinal", "0", "100"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, tvItemLinkService.GetTVItemLinkList().Count());
// -----------------------------------
// Is NOT Nullable
// [Range(0, 100)]
// tvItemLink.TVLevel (Int32)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.TVLevel = -1;
Assert.AreEqual(false, tvItemLinkService.Add(tvItemLink));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TVLevel", "0", "100"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, tvItemLinkService.GetTVItemLinkList().Count());
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.TVLevel = 101;
Assert.AreEqual(false, tvItemLinkService.Add(tvItemLink));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TVLevel", "0", "100"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, tvItemLinkService.GetTVItemLinkList().Count());
// -----------------------------------
// Is NOT Nullable
// [StringLength(250))]
// tvItemLink.TVPath (String)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("TVPath");
Assert.AreEqual(false, tvItemLinkService.Add(tvItemLink));
Assert.AreEqual(1, tvItemLink.ValidationResults.Count());
Assert.IsTrue(tvItemLink.ValidationResults.Where(c => c.ErrorMessage == string.Format(CSSPServicesRes._IsRequired, "TVPath")).Any());
Assert.AreEqual(null, tvItemLink.TVPath);
Assert.AreEqual(count, tvItemLinkService.GetTVItemLinkList().Count());
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.TVPath = GetRandomString("", 251);
Assert.AreEqual(false, tvItemLinkService.Add(tvItemLink));
Assert.AreEqual(string.Format(CSSPServicesRes._MaxLengthIs_, "TVPath", "250"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, tvItemLinkService.GetTVItemLinkList().Count());
// -----------------------------------
// Is Nullable
// [CSSPExist(ExistTypeName = "TVItemLink", ExistPlurial = "s", ExistFieldID = "TVItemLinkID", AllowableTVtypeList = )]
// tvItemLink.ParentTVItemLinkID (Int32)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.ParentTVItemLinkID = 0;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItemLink", "ParentTVItemLinkID", tvItemLink.ParentTVItemLinkID.ToString()), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPAfter(Year = 1980)]
// tvItemLink.LastUpdateDate_UTC (DateTime)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.LastUpdateDate_UTC = new DateTime();
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.LastUpdateDate_UTC = new DateTime(1979, 1, 1);
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Contact)]
// tvItemLink.LastUpdateContactTVItemID (Int32)
// -----------------------------------
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.LastUpdateContactTVItemID = 0;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", tvItemLink.LastUpdateContactTVItemID.ToString()), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemLink = null;
tvItemLink = GetFilledRandomTVItemLink("");
tvItemLink.LastUpdateContactTVItemID = 1;
tvItemLinkService.Add(tvItemLink);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), tvItemLink.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// tvItemLink.HasErrors (Boolean)
// -----------------------------------
// No testing requied
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// tvItemLink.ValidationResults (IEnumerable`1)
// -----------------------------------
// No testing requied
}
}
}
