public void TVItemStat_CRUD_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemStatService tvItemStatService = new TVItemStatService(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]
}
TVItemStat tvItemStat = GetFilledRandomTVItemStat("");
// -------------------------------
// -------------------------------
// CRUD testing
// -------------------------------
// -------------------------------
count = tvItemStatService.GetTVItemStatList().Count();
Assert.AreEqual(count, (from c in dbTestDB.TVItemStats select c).Count());
tvItemStatService.Add(tvItemStat);
if (tvItemStat.HasErrors)
{
Assert.AreEqual("", tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(true, tvItemStatService.GetTVItemStatList().Where(c => c == tvItemStat).Any());
tvItemStatService.Update(tvItemStat);
if (tvItemStat.HasErrors)
{
Assert.AreEqual("", tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count + 1, tvItemStatService.GetTVItemStatList().Count());
tvItemStatService.Delete(tvItemStat);
if (tvItemStat.HasErrors)
{
Assert.AreEqual("", tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count, tvItemStatService.GetTVItemStatList().Count());
}
}
}
public IHttpActionResult Post([FromBody] TVItemStat tvItemStat, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
TVItemStatService tvItemStatService = new TVItemStatService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!tvItemStatService.Add(tvItemStat))
{
return(BadRequest(String.Join("|||", tvItemStat.ValidationResults)));
}
else
{
tvItemStat.ValidationResults = null;
return(Created <TVItemStat>(new Uri(Request.RequestUri, tvItemStat.TVItemStatID.ToString()), tvItemStat));
}
}
}
public void TVItemStat_Properties_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemStatService tvItemStatService = new TVItemStatService(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 = tvItemStatService.GetTVItemStatList().Count();
TVItemStat tvItemStat = GetFilledRandomTVItemStat("");
// -------------------------------
// -------------------------------
// Properties testing
// -------------------------------
// -------------------------------
// -----------------------------------
// [Key]
// Is NOT Nullable
// tvItemStat.TVItemStatID (Int32)
// -----------------------------------
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.TVItemStatID = 0;
tvItemStatService.Update(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "TVItemStatID"), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.TVItemStatID = 10000000;
tvItemStatService.Update(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItemStat", "TVItemStatID", tvItemStat.TVItemStatID.ToString()), tvItemStat.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)]
// tvItemStat.TVItemID (Int32)
// -----------------------------------
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.TVItemID = 0;
tvItemStatService.Add(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "TVItemID", tvItemStat.TVItemID.ToString()), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.TVItemID = 13;
tvItemStatService.Add(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "TVItemID", "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"), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPEnumType]
// tvItemStat.TVType (TVTypeEnum)
// -----------------------------------
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.TVType = (TVTypeEnum)1000000;
tvItemStatService.Add(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "TVType"), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [Range(0, 10000000)]
// tvItemStat.ChildCount (Int32)
// -----------------------------------
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.ChildCount = -1;
Assert.AreEqual(false, tvItemStatService.Add(tvItemStat));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "ChildCount", "0", "10000000"), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, tvItemStatService.GetTVItemStatList().Count());
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.ChildCount = 10000001;
Assert.AreEqual(false, tvItemStatService.Add(tvItemStat));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "ChildCount", "0", "10000000"), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, tvItemStatService.GetTVItemStatList().Count());
// -----------------------------------
// Is NOT Nullable
// [CSSPAfter(Year = 1980)]
// tvItemStat.LastUpdateDate_UTC (DateTime)
// -----------------------------------
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.LastUpdateDate_UTC = new DateTime();
tvItemStatService.Add(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.LastUpdateDate_UTC = new DateTime(1979, 1, 1);
tvItemStatService.Add(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Contact)]
// tvItemStat.LastUpdateContactTVItemID (Int32)
// -----------------------------------
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.LastUpdateContactTVItemID = 0;
tvItemStatService.Add(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", tvItemStat.LastUpdateContactTVItemID.ToString()), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
tvItemStat = null;
tvItemStat = GetFilledRandomTVItemStat("");
tvItemStat.LastUpdateContactTVItemID = 1;
tvItemStatService.Add(tvItemStat);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), tvItemStat.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// tvItemStat.HasErrors (Boolean)
// -----------------------------------
// No testing requied
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// tvItemStat.ValidationResults (IEnumerable`1)
// -----------------------------------
// No testing requied
}
}
}