public TVItemLinkModel PostDeleteTVItemLinkWithFromTVItemIDAndFromTVTypeAndToTVTypeDB(int FromTVItemID, TVTypeEnum FromTVType, TVTypeEnum ToTVType)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
TVItemLink tvItemLinkToDelete = GetTVItemLinkWithFromTVItemIDAndFromTVTypeAndToTVTypeDB(FromTVItemID, FromTVType, ToTVType);
if (tvItemLinkToDelete == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToDelete, ServiceRes.TVItemLink)));
}
using (TransactionScope ts = new TransactionScope())
{
db.TVItemLinks.Remove(tvItemLinkToDelete);
string retStr = DoDeleteChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("TVItemLinks", tvItemLinkToDelete.TVItemLinkID, LogCommandEnum.Delete, tvItemLinkToDelete);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(ReturnError(""));
}
// Fill
public string FillTVItemLink(TVItemLink tvItemLinkNew, TVItemLinkModel tvItemLinkModel, ContactOK contactOK)
{
tvItemLinkNew.DBCommand = (int)tvItemLinkModel.DBCommand;
tvItemLinkNew.FromTVItemID = tvItemLinkModel.FromTVItemID;
tvItemLinkNew.ToTVItemID = tvItemLinkModel.ToTVItemID;
tvItemLinkNew.FromTVType = (int)tvItemLinkModel.FromTVType;
tvItemLinkNew.ToTVType = (int)tvItemLinkModel.ToTVType;
tvItemLinkNew.Ordinal = tvItemLinkModel.Ordinal;
tvItemLinkNew.StartDateTime_Local = tvItemLinkModel.StartDateTime_Local;
tvItemLinkNew.EndDateTime_Local = tvItemLinkModel.EndDateTime_Local;
tvItemLinkNew.ParentTVItemLinkID = tvItemLinkModel.ParentTVItemLinkID;
tvItemLinkNew.TVLevel = tvItemLinkModel.TVLevel;
tvItemLinkNew.TVPath = tvItemLinkModel.TVPath;
tvItemLinkNew.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
tvItemLinkNew.LastUpdateContactTVItemID = 2;
}
else
{
tvItemLinkNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
public TVItemLink GetTVItemLinkWithTVItemLinkIDDB(int TVItemLinkID)
{
TVItemLink tvItemLink = (from c in db.TVItemLinks
where c.TVItemLinkID == TVItemLinkID
select c).FirstOrDefault <TVItemLink>();
return(tvItemLink);
}
public TVItemLinkModel PostUpdateTVItemLinkDB(TVItemLinkModel tvItemLinkModel)
{
string retStr = TVItemLinkModelOK(tvItemLinkModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
TVItemLink tvItemLinkToUpdate = GetTVItemLinkWithTVItemLinkIDDB(tvItemLinkModel.TVItemLinkID);
if (tvItemLinkToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.TVItemLink)));
}
List <TVItemLinkModel> tvItemLinkModelList = GetTVItemLinkModelListWithFromTVItemIDDB(tvItemLinkModel.FromTVItemID);
foreach (TVItemLinkModel tvItemLinkModelInDB in tvItemLinkModelList)
{
if (tvItemLinkModelInDB.ToTVItemID == tvItemLinkModel.ToTVItemID && tvItemLinkModelInDB.TVItemLinkID != tvItemLinkModel.TVItemLinkID)
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.TVItemLink)));
}
}
retStr = FillTVItemLink(tvItemLinkToUpdate, tvItemLinkModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("TVItemLinks", tvItemLinkToUpdate.TVItemLinkID, LogCommandEnum.Change, tvItemLinkToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetTVItemLinkModelWithTVItemLinkIDDB(tvItemLinkToUpdate.TVItemLinkID));
}
public TVItemLink GetTVItemLinkWithFromTVItemIDAndToTVItemIDDB(int FromTVItemID, int ToTVItemID)
{
TVItemLink tvItemLink = (from c in db.TVItemLinks
where c.FromTVItemID == FromTVItemID &&
c.ToTVItemID == ToTVItemID
select c).FirstOrDefault <TVItemLink>();
return(tvItemLink);
}
public void TVItemLink_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemLinkController tvItemLinkController = new TVItemLinkController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemLinkController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemLinkController.DatabaseType);
TVItemLink tvItemLinkLast = new TVItemLink();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
TVItemLinkService tvItemLinkService = new TVItemLinkService(query, db, ContactID);
tvItemLinkLast = (from c in db.TVItemLinks select c).FirstOrDefault();
}
// ok with TVItemLink info
IHttpActionResult jsonRet = tvItemLinkController.GetTVItemLinkWithID(tvItemLinkLast.TVItemLinkID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <TVItemLink> Ret = jsonRet as OkNegotiatedContentResult <TVItemLink>;
TVItemLink tvItemLinkRet = Ret.Content;
Assert.AreEqual(tvItemLinkLast.TVItemLinkID, tvItemLinkRet.TVItemLinkID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = tvItemLinkController.Put(tvItemLinkRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <TVItemLink> tvItemLinkRet2 = jsonRet2 as OkNegotiatedContentResult <TVItemLink>;
Assert.IsNotNull(tvItemLinkRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because TVItemLinkID of 0 does not exist
tvItemLinkRet.TVItemLinkID = 0;
IHttpActionResult jsonRet3 = tvItemLinkController.Put(tvItemLinkRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <TVItemLink> tvItemLinkRet3 = jsonRet3 as OkNegotiatedContentResult <TVItemLink>;
Assert.IsNull(tvItemLinkRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public TVItemLink GetTVItemLinkWithFromTVItemIDAndFromTVTypeAndToTVTypeDB(int FromTVItemID, TVTypeEnum FromTVType, TVTypeEnum ToTVType)
{
TVItemLink tvItemLink = (from c in db.TVItemLinks
where c.FromTVItemID == FromTVItemID &&
c.FromTVType == (int)FromTVType &&
c.ToTVType == (int)ToTVType
select c).FirstOrDefault <TVItemLink>();
return(tvItemLink);
}
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());
}
}
}
private TVItemLink GetFilledRandomTVItemLink(string OmitPropName)
{
TVItemLink tvItemLink = new TVItemLink();
if (OmitPropName != "FromTVItemID")
{
tvItemLink.FromTVItemID = 1;
}
if (OmitPropName != "ToTVItemID")
{
tvItemLink.ToTVItemID = 1;
}
if (OmitPropName != "FromTVType")
{
tvItemLink.FromTVType = (TVTypeEnum)GetRandomEnumType(typeof(TVTypeEnum));
}
if (OmitPropName != "ToTVType")
{
tvItemLink.ToTVType = (TVTypeEnum)GetRandomEnumType(typeof(TVTypeEnum));
}
if (OmitPropName != "StartDateTime_Local")
{
tvItemLink.StartDateTime_Local = new DateTime(2005, 3, 6);
}
if (OmitPropName != "EndDateTime_Local")
{
tvItemLink.EndDateTime_Local = new DateTime(2005, 3, 7);
}
if (OmitPropName != "Ordinal")
{
tvItemLink.Ordinal = GetRandomInt(0, 100);
}
if (OmitPropName != "TVLevel")
{
tvItemLink.TVLevel = GetRandomInt(0, 100);
}
if (OmitPropName != "TVPath")
{
tvItemLink.TVPath = GetRandomString("", 5);
}
// Need to implement [TVItemLink ParentTVItemLinkID TVItemLink TVItemLinkID]
if (OmitPropName != "LastUpdateDate_UTC")
{
tvItemLink.LastUpdateDate_UTC = new DateTime(2005, 3, 6);
}
if (OmitPropName != "LastUpdateContactTVItemID")
{
tvItemLink.LastUpdateContactTVItemID = 2;
}
return(tvItemLink);
}
// Post
public TVItemLinkModel PostAddTVItemLinkDB(TVItemLinkModel tvItemLinkModel)
{
string retStr = TVItemLinkModelOK(tvItemLinkModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
TVItemLinkModel tvItemLinkModelRet = GetTVItemLinkModelWithFromTVItemIDAndToTVItemIDDB(tvItemLinkModel.FromTVItemID, tvItemLinkModel.ToTVItemID);
if (string.IsNullOrWhiteSpace(tvItemLinkModelRet.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.TVItemLink)));
}
TVItemLink tvItemLinkNew = new TVItemLink();
retStr = FillTVItemLink(tvItemLinkNew, tvItemLinkModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.TVItemLinks.Add(tvItemLinkNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("TVItemLinks", tvItemLinkNew.TVItemLinkID, LogCommandEnum.Add, tvItemLinkNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetTVItemLinkModelWithTVItemLinkIDDB(tvItemLinkNew.TVItemLinkID));
}
public IHttpActionResult GetTVItemLinkWithID([FromUri] int TVItemLinkID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
tvItemLinkService.Query = tvItemLinkService.FillQuery(typeof(TVItemLink), lang, 0, 1, "", "", extra);
if (tvItemLinkService.Query.Extra == "A")
{
TVItemLinkExtraA tvItemLinkExtraA = new TVItemLinkExtraA();
tvItemLinkExtraA = tvItemLinkService.GetTVItemLinkExtraAWithTVItemLinkID(TVItemLinkID);
if (tvItemLinkExtraA == null)
{
return(NotFound());
}
return(Ok(tvItemLinkExtraA));
}
else if (tvItemLinkService.Query.Extra == "B")
{
TVItemLinkExtraB tvItemLinkExtraB = new TVItemLinkExtraB();
tvItemLinkExtraB = tvItemLinkService.GetTVItemLinkExtraBWithTVItemLinkID(TVItemLinkID);
if (tvItemLinkExtraB == null)
{
return(NotFound());
}
return(Ok(tvItemLinkExtraB));
}
else
{
TVItemLink tvItemLink = new TVItemLink();
tvItemLink = tvItemLinkService.GetTVItemLinkWithTVItemLinkID(TVItemLinkID);
if (tvItemLink == null)
{
return(NotFound());
}
return(Ok(tvItemLink));
}
}
}
public bool Update(TVItemLink tvItemLink)
{
tvItemLink.ValidationResults = Validate(new ValidationContext(tvItemLink), ActionDBTypeEnum.Update);
if (tvItemLink.ValidationResults.Count() > 0)
{
return(false);
}
db.TVItemLinks.Update(tvItemLink);
if (!TryToSave(tvItemLink))
{
return(false);
}
return(true);
}
private bool TryToSave(TVItemLink tvItemLink)
{
try
{
db.SaveChanges();
}
catch (DbUpdateException ex)
{
tvItemLink.ValidationResults = new List <ValidationResult>()
{
new ValidationResult(ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""))
}.AsEnumerable();
return(false);
}
return(true);
}
public void TVItemLink_Controller_GetTVItemLinkWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemLinkController tvItemLinkController = new TVItemLinkController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemLinkController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemLinkController.DatabaseType);
TVItemLink tvItemLinkFirst = new TVItemLink();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(new Query(), db, ContactID);
tvItemLinkFirst = (from c in db.TVItemLinks select c).FirstOrDefault();
}
// ok with TVItemLink info
IHttpActionResult jsonRet = tvItemLinkController.GetTVItemLinkWithID(tvItemLinkFirst.TVItemLinkID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <TVItemLink> Ret = jsonRet as OkNegotiatedContentResult <TVItemLink>;
TVItemLink tvItemLinkRet = Ret.Content;
Assert.AreEqual(tvItemLinkFirst.TVItemLinkID, tvItemLinkRet.TVItemLinkID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = tvItemLinkController.GetTVItemLinkWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <TVItemLink> tvItemLinkRet2 = jsonRet2 as OkNegotiatedContentResult <TVItemLink>;
Assert.IsNull(tvItemLinkRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public IHttpActionResult Delete([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.Delete(tvItemLink))
{
return(BadRequest(String.Join("|||", tvItemLink.ValidationResults)));
}
else
{
tvItemLink.ValidationResults = null;
return(Ok(tvItemLink));
}
}
}
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 TVItemLink_Controller_GetTVItemLinkList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemLinkController tvItemLinkController = new TVItemLinkController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemLinkController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemLinkController.DatabaseType);
TVItemLink tvItemLinkFirst = new TVItemLink();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(query, db, ContactID);
tvItemLinkFirst = (from c in db.TVItemLinks select c).FirstOrDefault();
count = (from c in db.TVItemLinks select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with TVItemLink info
IHttpActionResult jsonRet = tvItemLinkController.GetTVItemLinkList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <TVItemLink> > ret = jsonRet as OkNegotiatedContentResult <List <TVItemLink> >;
Assert.AreEqual(tvItemLinkFirst.TVItemLinkID, ret.Content[0].TVItemLinkID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <TVItemLink> tvItemLinkList = new List <TVItemLink>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
TVItemLinkService tvItemLinkService = new TVItemLinkService(query, db, ContactID);
tvItemLinkList = (from c in db.TVItemLinks select c).OrderBy(c => c.TVItemLinkID).Skip(0).Take(2).ToList();
count = (from c in db.TVItemLinks select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with TVItemLink info
jsonRet = tvItemLinkController.GetTVItemLinkList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <TVItemLink> >;
Assert.AreEqual(tvItemLinkList[0].TVItemLinkID, ret.Content[0].TVItemLinkID);
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 TVItemLink info
IHttpActionResult jsonRet2 = tvItemLinkController.GetTVItemLinkList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <TVItemLink> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <TVItemLink> >;
Assert.AreEqual(tvItemLinkList[1].TVItemLinkID, ret2.Content[0].TVItemLinkID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public TVItemLinkTest()
{
tVItemLink = new TVItemLink();
tVItemLinkExtraA = new TVItemLinkExtraA();
tVItemLinkExtraB = new TVItemLinkExtraB();
}
private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
TVItemLink tvItemLink = validationContext.ObjectInstance as TVItemLink;
tvItemLink.HasErrors = false;
if (actionDBType == ActionDBTypeEnum.Update || actionDBType == ActionDBTypeEnum.Delete)
{
if (tvItemLink.TVItemLinkID == 0)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "TVItemLinkID"), new[] { "TVItemLinkID" }));
}
if (!(from c in db.TVItemLinks select c).Where(c => c.TVItemLinkID == tvItemLink.TVItemLinkID).Any())
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItemLink", "TVItemLinkID", tvItemLink.TVItemLinkID.ToString()), new[] { "TVItemLinkID" }));
}
}
TVItem TVItemFromTVItemID = (from c in db.TVItems where c.TVItemID == tvItemLink.FromTVItemID select c).FirstOrDefault();
if (TVItemFromTVItemID == null)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "FromTVItemID", tvItemLink.FromTVItemID.ToString()), new[] { "FromTVItemID" }));
}
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(TVItemFromTVItemID.TVType))
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(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"), new[] { "FromTVItemID" }));
}
}
TVItem TVItemToTVItemID = (from c in db.TVItems where c.TVItemID == tvItemLink.ToTVItemID select c).FirstOrDefault();
if (TVItemToTVItemID == null)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "ToTVItemID", tvItemLink.ToTVItemID.ToString()), new[] { "ToTVItemID" }));
}
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(TVItemToTVItemID.TVType))
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(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"), new[] { "ToTVItemID" }));
}
}
retStr = enums.EnumTypeOK(typeof(TVTypeEnum), (int?)tvItemLink.FromTVType);
if (!string.IsNullOrWhiteSpace(retStr))
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "FromTVType"), new[] { "FromTVType" }));
}
retStr = enums.EnumTypeOK(typeof(TVTypeEnum), (int?)tvItemLink.ToTVType);
if (!string.IsNullOrWhiteSpace(retStr))
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "ToTVType"), new[] { "ToTVType" }));
}
if (tvItemLink.StartDateTime_Local != null && ((DateTime)tvItemLink.StartDateTime_Local).Year < 1980)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "StartDateTime_Local", "1980"), new[] { "StartDateTime_Local" }));
}
if (tvItemLink.EndDateTime_Local != null && ((DateTime)tvItemLink.EndDateTime_Local).Year < 1980)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "EndDateTime_Local", "1980"), new[] { "EndDateTime_Local" }));
}
if (tvItemLink.StartDateTime_Local > tvItemLink.EndDateTime_Local)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._DateIsBiggerThan_, "EndDateTime_Local", "TVItemLinkStartDateTime_Local"), new[] { "EndDateTime_Local" }));
}
if (tvItemLink.Ordinal < 0 || tvItemLink.Ordinal > 100)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Ordinal", "0", "100"), new[] { "Ordinal" }));
}
if (tvItemLink.TVLevel < 0 || tvItemLink.TVLevel > 100)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TVLevel", "0", "100"), new[] { "TVLevel" }));
}
if (string.IsNullOrWhiteSpace(tvItemLink.TVPath))
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "TVPath"), new[] { "TVPath" }));
}
if (!string.IsNullOrWhiteSpace(tvItemLink.TVPath) && tvItemLink.TVPath.Length > 250)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "TVPath", "250"), new[] { "TVPath" }));
}
if (tvItemLink.ParentTVItemLinkID != null)
{
TVItemLink TVItemLinkParentTVItemLinkID = (from c in db.TVItemLinks where c.TVItemLinkID == tvItemLink.ParentTVItemLinkID select c).FirstOrDefault();
if (TVItemLinkParentTVItemLinkID == null)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItemLink", "ParentTVItemLinkID", (tvItemLink.ParentTVItemLinkID == null ? "" : tvItemLink.ParentTVItemLinkID.ToString())), new[] { "ParentTVItemLinkID" }));
}
}
if (tvItemLink.LastUpdateDate_UTC.Year == 1)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), new[] { "LastUpdateDate_UTC" }));
}
else
{
if (tvItemLink.LastUpdateDate_UTC.Year < 1980)
{
tvItemLink.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 == tvItemLink.LastUpdateContactTVItemID select c).FirstOrDefault();
if (TVItemLastUpdateContactTVItemID == null)
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", tvItemLink.LastUpdateContactTVItemID.ToString()), new[] { "LastUpdateContactTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Contact,
};
if (!AllowableTVTypes.Contains(TVItemLastUpdateContactTVItemID.TVType))
{
tvItemLink.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
{
tvItemLink.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
public void TVItemLink_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
TVItemLinkController tvItemLinkController = new TVItemLinkController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(tvItemLinkController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, tvItemLinkController.DatabaseType);
TVItemLink tvItemLinkLast = new TVItemLink();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
TVItemLinkService tvItemLinkService = new TVItemLinkService(query, db, ContactID);
tvItemLinkLast = (from c in db.TVItemLinks select c).FirstOrDefault();
}
// ok with TVItemLink info
IHttpActionResult jsonRet = tvItemLinkController.GetTVItemLinkWithID(tvItemLinkLast.TVItemLinkID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <TVItemLink> Ret = jsonRet as OkNegotiatedContentResult <TVItemLink>;
TVItemLink tvItemLinkRet = Ret.Content;
Assert.AreEqual(tvItemLinkLast.TVItemLinkID, tvItemLinkRet.TVItemLinkID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because TVItemLinkID exist
IHttpActionResult jsonRet2 = tvItemLinkController.Post(tvItemLinkRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <TVItemLink> tvItemLinkRet2 = jsonRet2 as OkNegotiatedContentResult <TVItemLink>;
Assert.IsNull(tvItemLinkRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added TVItemLink
tvItemLinkRet.TVItemLinkID = 0;
tvItemLinkController.Request = new System.Net.Http.HttpRequestMessage();
tvItemLinkController.Request.RequestUri = new System.Uri("http://localhost:5000/api/tvItemLink");
IHttpActionResult jsonRet3 = tvItemLinkController.Post(tvItemLinkRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <TVItemLink> tvItemLinkRet3 = jsonRet3 as CreatedNegotiatedContentResult <TVItemLink>;
Assert.IsNotNull(tvItemLinkRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = tvItemLinkController.Delete(tvItemLinkRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <TVItemLink> tvItemLinkRet4 = jsonRet4 as OkNegotiatedContentResult <TVItemLink>;
Assert.IsNotNull(tvItemLinkRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
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
}
}
}
