protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
_InfrastructureService = new InfrastructureService(LanguageRequest, User);
_TVItemLinkService = new TVItemLinkService(LanguageRequest, User);
_MapInfoPointService = new MapInfoPointService(LanguageRequest, User);
_AddressService = new AddressService(LanguageRequest, User);
}
private void SetupTest(ContactModel contactModelToDo, CultureInfo culture, string actionStr)
{
LanguageEnum languageEnum = (culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en);
if (contactModelToDo == null)
{
user = null;
}
else
{
user = new GenericPrincipal(new GenericIdentity(contactModelToDo.LoginEmail, "Forms"), null);
}
routeData = new RouteData();
routeData.Values.Add("culture", culture);
routeData.Values.Add("controller", "Infrastructure");
routeData.Values.Add("action", actionStr);
stubHttpContext = new StubHttpContextBase();
stubHttpRequestBase = new StubHttpRequestBase();
stubHttpContext.RequestGet = () => stubHttpRequestBase;
requestContext = new RequestContext(stubHttpContext, routeData);
controller = new InfrastructureController();
controller.Url = new UrlHelper(requestContext);
controller.ControllerContext = new ControllerContext(stubHttpContext, routeData, controller);
stubHttpContext.UserGet = () => user;
randomService = new RandomService(languageEnum, user);
tvItemService = new TVItemService(languageEnum, user);
infrastructureService = new InfrastructureService(languageEnum, user);
tvItemLinkService = new TVItemLinkService(languageEnum, user);
mapInfoPointService = new MapInfoPointService(languageEnum, user);
controller.SetRequestContext(requestContext);
Assert.IsNotNull(controller);
Assert.AreEqual(2, controller.CultureListAllowable.Count);
Assert.AreEqual("en-CA", controller.CultureListAllowable[0]);
Assert.AreEqual("fr-CA", controller.CultureListAllowable[1]);
Assert.IsNotNull(controller._ContactService);
Assert.IsNotNull(controller._RequestContext);
Assert.IsNotNull(controller._InfrastructureService);
Assert.IsNotNull(controller._TVItemService);
Assert.IsNotNull(controller.urlModel);
Assert.IsNotNull(culture.Name, controller._RequestContext.RouteData.Values["culture"].ToString());
Assert.IsNotNull("Infrastructure", controller._RequestContext.RouteData.Values["controller"].ToString());
Assert.IsNotNull(actionStr, controller._RequestContext.RouteData.Values["action"].ToString());
Assert.AreEqual((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), controller.LanguageRequest);
Assert.AreEqual((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), controller.ViewBag.Language);
Assert.AreEqual(culture.Name, controller.CultureRequest);
Assert.AreEqual(culture.Name, controller.ViewBag.Culture);
if (contactModelToDo != null)
{
Assert.AreEqual(contactModelToDo.IsAdmin, controller.IsAdmin);
Assert.AreEqual(contactModelToDo.IsAdmin, controller.ViewBag.IsAdmin);
}
Assert.AreEqual(true, controller.Debug);
Assert.AreEqual(true, controller.ViewBag.Debug);
}
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);
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 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 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 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 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()));
}
}
}
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
_EmailService = new EmailService(LanguageRequest, User);
_TVItemLinkService = new TVItemLinkService(LanguageRequest, User);
}
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
}
}
}
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 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);
}
}
}
