private TVItemStat GetFilledRandomTVItemStat(string OmitPropName)
{
TVItemStat tvItemStat = new TVItemStat();
if (OmitPropName != "TVItemID")
{
tvItemStat.TVItemID = 1;
}
if (OmitPropName != "TVType")
{
tvItemStat.TVType = (TVTypeEnum)GetRandomEnumType(typeof(TVTypeEnum));
}
if (OmitPropName != "ChildCount")
{
tvItemStat.ChildCount = GetRandomInt(0, 10000000);
}
if (OmitPropName != "LastUpdateDate_UTC")
{
tvItemStat.LastUpdateDate_UTC = new DateTime(2005, 3, 6);
}
if (OmitPropName != "LastUpdateContactTVItemID")
{
tvItemStat.LastUpdateContactTVItemID = 2;
}
return(tvItemStat);
}
public void TVItemStat_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemStatController tvItemStatController = new TVItemStatController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemStatController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemStatController.DatabaseType);
TVItemStat tvItemStatLast = new TVItemStat();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
TVItemStatService tvItemStatService = new TVItemStatService(query, db, ContactID);
tvItemStatLast = (from c in db.TVItemStats select c).FirstOrDefault();
}
// ok with TVItemStat info
IHttpActionResult jsonRet = tvItemStatController.GetTVItemStatWithID(tvItemStatLast.TVItemStatID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <TVItemStat> Ret = jsonRet as OkNegotiatedContentResult <TVItemStat>;
TVItemStat tvItemStatRet = Ret.Content;
Assert.AreEqual(tvItemStatLast.TVItemStatID, tvItemStatRet.TVItemStatID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = tvItemStatController.Put(tvItemStatRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <TVItemStat> tvItemStatRet2 = jsonRet2 as OkNegotiatedContentResult <TVItemStat>;
Assert.IsNotNull(tvItemStatRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because TVItemStatID of 0 does not exist
tvItemStatRet.TVItemStatID = 0;
IHttpActionResult jsonRet3 = tvItemStatController.Put(tvItemStatRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <TVItemStat> tvItemStatRet3 = jsonRet3 as OkNegotiatedContentResult <TVItemStat>;
Assert.IsNull(tvItemStatRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
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 GetTVItemStatWithID([FromUri] int TVItemStatID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
TVItemStatService tvItemStatService = new TVItemStatService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
tvItemStatService.Query = tvItemStatService.FillQuery(typeof(TVItemStat), lang, 0, 1, "", "", extra);
if (tvItemStatService.Query.Extra == "A")
{
TVItemStatExtraA tvItemStatExtraA = new TVItemStatExtraA();
tvItemStatExtraA = tvItemStatService.GetTVItemStatExtraAWithTVItemStatID(TVItemStatID);
if (tvItemStatExtraA == null)
{
return(NotFound());
}
return(Ok(tvItemStatExtraA));
}
else if (tvItemStatService.Query.Extra == "B")
{
TVItemStatExtraB tvItemStatExtraB = new TVItemStatExtraB();
tvItemStatExtraB = tvItemStatService.GetTVItemStatExtraBWithTVItemStatID(TVItemStatID);
if (tvItemStatExtraB == null)
{
return(NotFound());
}
return(Ok(tvItemStatExtraB));
}
else
{
TVItemStat tvItemStat = new TVItemStat();
tvItemStat = tvItemStatService.GetTVItemStatWithTVItemStatID(TVItemStatID);
if (tvItemStat == null)
{
return(NotFound());
}
return(Ok(tvItemStat));
}
}
}
private bool TryToSave(TVItemStat tvItemStat)
{
try
{
db.SaveChanges();
}
catch (DbUpdateException ex)
{
tvItemStat.ValidationResults = new List <ValidationResult>()
{
new ValidationResult(ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""))
}.AsEnumerable();
return(false);
}
return(true);
}
public bool Update(TVItemStat tvItemStat)
{
tvItemStat.ValidationResults = Validate(new ValidationContext(tvItemStat), ActionDBTypeEnum.Update);
if (tvItemStat.ValidationResults.Count() > 0)
{
return(false);
}
db.TVItemStats.Update(tvItemStat);
if (!TryToSave(tvItemStat))
{
return(false);
}
return(true);
}
public void TVItemStat_Controller_GetTVItemStatWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemStatController tvItemStatController = new TVItemStatController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemStatController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemStatController.DatabaseType);
TVItemStat tvItemStatFirst = new TVItemStat();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
TVItemStatService tvItemStatService = new TVItemStatService(new Query(), db, ContactID);
tvItemStatFirst = (from c in db.TVItemStats select c).FirstOrDefault();
}
// ok with TVItemStat info
IHttpActionResult jsonRet = tvItemStatController.GetTVItemStatWithID(tvItemStatFirst.TVItemStatID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <TVItemStat> Ret = jsonRet as OkNegotiatedContentResult <TVItemStat>;
TVItemStat tvItemStatRet = Ret.Content;
Assert.AreEqual(tvItemStatFirst.TVItemStatID, tvItemStatRet.TVItemStatID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = tvItemStatController.GetTVItemStatWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <TVItemStat> tvItemStatRet2 = jsonRet2 as OkNegotiatedContentResult <TVItemStat>;
Assert.IsNull(tvItemStatRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public IHttpActionResult Delete([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.Delete(tvItemStat))
{
return(BadRequest(String.Join("|||", tvItemStat.ValidationResults)));
}
else
{
tvItemStat.ValidationResults = null;
return(Ok(tvItemStat));
}
}
}
public void GetTVItemStatList_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);
TVItemStat tvItemStat = (from c in dbTestDB.TVItemStats select c).FirstOrDefault();
Assert.IsNotNull(tvItemStat);
List <TVItemStat> tvItemStatDirectQueryList = new List <TVItemStat>();
tvItemStatDirectQueryList = (from c in dbTestDB.TVItemStats select c).Take(200).ToList();
foreach (string extra in new List <string>()
{
null, "A", "B", "C", "D", "E"
})
{
tvItemStatService.Query.Extra = extra;
if (string.IsNullOrWhiteSpace(extra))
{
List <TVItemStat> tvItemStatList = new List <TVItemStat>();
tvItemStatList = tvItemStatService.GetTVItemStatList().ToList();
CheckTVItemStatFields(tvItemStatList);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public TVItemStatTest()
{
tVItemStat = new TVItemStat();
tVItemStatExtraA = new TVItemStatExtraA();
tVItemStatExtraB = new TVItemStatExtraB();
}
private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
TVItemStat tvItemStat = validationContext.ObjectInstance as TVItemStat;
tvItemStat.HasErrors = false;
if (actionDBType == ActionDBTypeEnum.Update || actionDBType == ActionDBTypeEnum.Delete)
{
if (tvItemStat.TVItemStatID == 0)
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "TVItemStatID"), new[] { "TVItemStatID" }));
}
if (!(from c in db.TVItemStats select c).Where(c => c.TVItemStatID == tvItemStat.TVItemStatID).Any())
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItemStat", "TVItemStatID", tvItemStat.TVItemStatID.ToString()), new[] { "TVItemStatID" }));
}
}
TVItem TVItemTVItemID = (from c in db.TVItems where c.TVItemID == tvItemStat.TVItemID select c).FirstOrDefault();
if (TVItemTVItemID == null)
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "TVItemID", tvItemStat.TVItemID.ToString()), new[] { "TVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Root,
TVTypeEnum.Address,
TVTypeEnum.Area,
TVTypeEnum.ClimateSite,
TVTypeEnum.Contact,
TVTypeEnum.Country,
TVTypeEnum.Email,
TVTypeEnum.File,
TVTypeEnum.HydrometricSite,
TVTypeEnum.Infrastructure,
TVTypeEnum.MikeScenario,
TVTypeEnum.MikeSource,
TVTypeEnum.Municipality,
TVTypeEnum.MWQMSite,
TVTypeEnum.PolSourceSite,
TVTypeEnum.Province,
TVTypeEnum.Sector,
TVTypeEnum.Subsector,
TVTypeEnum.Tel,
TVTypeEnum.TideSite,
TVTypeEnum.WasteWaterTreatmentPlant,
TVTypeEnum.LiftStation,
TVTypeEnum.Spill,
TVTypeEnum.BoxModel,
TVTypeEnum.VisualPlumesScenario,
TVTypeEnum.OtherInfrastructure,
TVTypeEnum.MWQMRun,
TVTypeEnum.MeshNode,
TVTypeEnum.WebTideNode,
TVTypeEnum.SamplingPlan,
TVTypeEnum.SeeOtherMunicipality,
TVTypeEnum.LineOverflow,
TVTypeEnum.MapInfo,
TVTypeEnum.MapInfoPoint,
};
if (!AllowableTVTypes.Contains(TVItemTVItemID.TVType))
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(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"), new[] { "TVItemID" }));
}
}
retStr = enums.EnumTypeOK(typeof(TVTypeEnum), (int?)tvItemStat.TVType);
if (!string.IsNullOrWhiteSpace(retStr))
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "TVType"), new[] { "TVType" }));
}
if (tvItemStat.ChildCount < 0 || tvItemStat.ChildCount > 10000000)
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "ChildCount", "0", "10000000"), new[] { "ChildCount" }));
}
if (tvItemStat.LastUpdateDate_UTC.Year == 1)
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), new[] { "LastUpdateDate_UTC" }));
}
else
{
if (tvItemStat.LastUpdateDate_UTC.Year < 1980)
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), new[] { "LastUpdateDate_UTC" }));
}
}
TVItem TVItemLastUpdateContactTVItemID = (from c in db.TVItems where c.TVItemID == tvItemStat.LastUpdateContactTVItemID select c).FirstOrDefault();
if (TVItemLastUpdateContactTVItemID == null)
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", tvItemStat.LastUpdateContactTVItemID.ToString()), new[] { "LastUpdateContactTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Contact,
};
if (!AllowableTVTypes.Contains(TVItemLastUpdateContactTVItemID.TVType))
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), new[] { "LastUpdateContactTVItemID" }));
}
}
retStr = ""; // added to stop compiling CSSPError
if (retStr != "") // will never be true
{
tvItemStat.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
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
}
}
}
public void TVItemStat_Controller_GetTVItemStatList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemStatController tvItemStatController = new TVItemStatController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemStatController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemStatController.DatabaseType);
TVItemStat tvItemStatFirst = new TVItemStat();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemStatService tvItemStatService = new TVItemStatService(query, db, ContactID);
tvItemStatFirst = (from c in db.TVItemStats select c).FirstOrDefault();
count = (from c in db.TVItemStats select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with TVItemStat info
IHttpActionResult jsonRet = tvItemStatController.GetTVItemStatList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <TVItemStat> > ret = jsonRet as OkNegotiatedContentResult <List <TVItemStat> >;
Assert.AreEqual(tvItemStatFirst.TVItemStatID, ret.Content[0].TVItemStatID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <TVItemStat> tvItemStatList = new List <TVItemStat>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemStatService tvItemStatService = new TVItemStatService(query, db, ContactID);
tvItemStatList = (from c in db.TVItemStats select c).OrderBy(c => c.TVItemStatID).Skip(0).Take(2).ToList();
count = (from c in db.TVItemStats select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with TVItemStat info
jsonRet = tvItemStatController.GetTVItemStatList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <TVItemStat> >;
Assert.AreEqual(tvItemStatList[0].TVItemStatID, ret.Content[0].TVItemStatID);
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 TVItemStat info
IHttpActionResult jsonRet2 = tvItemStatController.GetTVItemStatList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <TVItemStat> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <TVItemStat> >;
Assert.AreEqual(tvItemStatList[1].TVItemStatID, ret2.Content[0].TVItemStatID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void TVItemStat_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemStatController tvItemStatController = new TVItemStatController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemStatController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemStatController.DatabaseType);
TVItemStat tvItemStatLast = new TVItemStat();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
TVItemStatService tvItemStatService = new TVItemStatService(query, db, ContactID);
tvItemStatLast = (from c in db.TVItemStats select c).FirstOrDefault();
}
// ok with TVItemStat info
IHttpActionResult jsonRet = tvItemStatController.GetTVItemStatWithID(tvItemStatLast.TVItemStatID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <TVItemStat> Ret = jsonRet as OkNegotiatedContentResult <TVItemStat>;
TVItemStat tvItemStatRet = Ret.Content;
Assert.AreEqual(tvItemStatLast.TVItemStatID, tvItemStatRet.TVItemStatID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because TVItemStatID exist
IHttpActionResult jsonRet2 = tvItemStatController.Post(tvItemStatRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <TVItemStat> tvItemStatRet2 = jsonRet2 as OkNegotiatedContentResult <TVItemStat>;
Assert.IsNull(tvItemStatRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added TVItemStat
tvItemStatRet.TVItemStatID = 0;
tvItemStatController.Request = new System.Net.Http.HttpRequestMessage();
tvItemStatController.Request.RequestUri = new System.Uri("http://localhost:5000/api/tvItemStat");
IHttpActionResult jsonRet3 = tvItemStatController.Post(tvItemStatRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <TVItemStat> tvItemStatRet3 = jsonRet3 as CreatedNegotiatedContentResult <TVItemStat>;
Assert.IsNotNull(tvItemStatRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = tvItemStatController.Delete(tvItemStatRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <TVItemStat> tvItemStatRet4 = jsonRet4 as OkNegotiatedContentResult <TVItemStat>;
Assert.IsNotNull(tvItemStatRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
