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 IHttpActionResult Post([FromBody] TVItemLink tvItemLink, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!tvItemLinkService.Add(tvItemLink))
{
return(BadRequest(String.Join("|||", tvItemLink.ValidationResults)));
}
else
{
tvItemLink.ValidationResults = null;
return(Created <TVItemLink>(new Uri(Request.RequestUri, tvItemLink.TVItemLinkID.ToString()), tvItemLink));
}
}
}
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
}
}
}
