public PolSourceSiteEffectService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_PolSourceSiteEffectTermService = new PolSourceSiteEffectTermService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public IHttpActionResult GetPolSourceSiteEffectTermList([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))
{
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(new Query()
{
Lang = lang
}, db, ContactID);
public void PolSourceSiteEffectTerm_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectTermController polSourceSiteEffectTermController = new PolSourceSiteEffectTermController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectTermController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectTermController.DatabaseType);
PolSourceSiteEffectTerm polSourceSiteEffectTermLast = new PolSourceSiteEffectTerm();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(query, db, ContactID);
polSourceSiteEffectTermLast = (from c in db.PolSourceSiteEffectTerms select c).FirstOrDefault();
}
// ok with PolSourceSiteEffectTerm info
IHttpActionResult jsonRet = polSourceSiteEffectTermController.GetPolSourceSiteEffectTermWithID(polSourceSiteEffectTermLast.PolSourceSiteEffectTermID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffectTerm> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffectTerm>;
PolSourceSiteEffectTerm polSourceSiteEffectTermRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectTermLast.PolSourceSiteEffectTermID, polSourceSiteEffectTermRet.PolSourceSiteEffectTermID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = polSourceSiteEffectTermController.Put(polSourceSiteEffectTermRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffectTerm> polSourceSiteEffectTermRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffectTerm>;
Assert.IsNotNull(polSourceSiteEffectTermRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because PolSourceSiteEffectTermID of 0 does not exist
polSourceSiteEffectTermRet.PolSourceSiteEffectTermID = 0;
IHttpActionResult jsonRet3 = polSourceSiteEffectTermController.Put(polSourceSiteEffectTermRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <PolSourceSiteEffectTerm> polSourceSiteEffectTermRet3 = jsonRet3 as OkNegotiatedContentResult <PolSourceSiteEffectTerm>;
Assert.IsNull(polSourceSiteEffectTermRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
_PolSourceSiteEffectService = new PolSourceSiteEffectService(LanguageRequest, User);
_PolSourceSiteEffectTermService = new PolSourceSiteEffectTermService(LanguageRequest, User);
_PolSourceSiteService = new PolSourceSiteService(LanguageRequest, User);
_MWQMSiteService = new MWQMSiteService(LanguageRequest, User);
_UseOfSiteService = new UseOfSiteService(LanguageRequest, User);
_PolSourceSiteEffectService = new PolSourceSiteEffectService(LanguageRequest, User);
_BaseEnumService = new BaseEnumService(LanguageRequest);
}
public void PolSourceSiteEffectTerm_CRUD_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(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]
}
PolSourceSiteEffectTerm polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
// -------------------------------
// -------------------------------
// CRUD testing
// -------------------------------
// -------------------------------
count = polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Count();
Assert.AreEqual(count, (from c in dbTestDB.PolSourceSiteEffectTerms select c).Count());
polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm);
if (polSourceSiteEffectTerm.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(true, polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Where(c => c == polSourceSiteEffectTerm).Any());
polSourceSiteEffectTermService.Update(polSourceSiteEffectTerm);
if (polSourceSiteEffectTerm.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count + 1, polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Count());
polSourceSiteEffectTermService.Delete(polSourceSiteEffectTerm);
if (polSourceSiteEffectTerm.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count, polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Count());
}
}
}
public void PolSourceSiteEffectTerm_Controller_GetPolSourceSiteEffectTermWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectTermController polSourceSiteEffectTermController = new PolSourceSiteEffectTermController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectTermController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectTermController.DatabaseType);
PolSourceSiteEffectTerm polSourceSiteEffectTermFirst = new PolSourceSiteEffectTerm();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(new Query(), db, ContactID);
polSourceSiteEffectTermFirst = (from c in db.PolSourceSiteEffectTerms select c).FirstOrDefault();
}
// ok with PolSourceSiteEffectTerm info
IHttpActionResult jsonRet = polSourceSiteEffectTermController.GetPolSourceSiteEffectTermWithID(polSourceSiteEffectTermFirst.PolSourceSiteEffectTermID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffectTerm> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffectTerm>;
PolSourceSiteEffectTerm polSourceSiteEffectTermRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectTermFirst.PolSourceSiteEffectTermID, polSourceSiteEffectTermRet.PolSourceSiteEffectTermID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = polSourceSiteEffectTermController.GetPolSourceSiteEffectTermWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffectTerm> polSourceSiteEffectTermRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffectTerm>;
Assert.IsNull(polSourceSiteEffectTermRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public void GetPolSourceSiteEffectTermList_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
PolSourceSiteEffectTerm polSourceSiteEffectTerm = (from c in dbTestDB.PolSourceSiteEffectTerms select c).FirstOrDefault();
Assert.IsNotNull(polSourceSiteEffectTerm);
List <PolSourceSiteEffectTerm> polSourceSiteEffectTermDirectQueryList = new List <PolSourceSiteEffectTerm>();
polSourceSiteEffectTermDirectQueryList = (from c in dbTestDB.PolSourceSiteEffectTerms select c).Take(200).ToList();
foreach (string extra in new List <string>()
{
null, "A", "B", "C", "D", "E"
})
{
polSourceSiteEffectTermService.Query.Extra = extra;
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceSiteEffectTerm> polSourceSiteEffectTermList = new List <PolSourceSiteEffectTerm>();
polSourceSiteEffectTermList = polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().ToList();
CheckPolSourceSiteEffectTermFields(polSourceSiteEffectTermList);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public void GetPolSourceSiteEffectTermList_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"
})
{
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
polSourceSiteEffectTermService.Query = polSourceSiteEffectTermService.FillQuery(typeof(PolSourceSiteEffectTerm), culture.TwoLetterISOLanguageName, 0, 10000, "", "", "PolSourceSiteEffectTermID,GT,2|PolSourceSiteEffectTermID,LT,5", extra);
List <PolSourceSiteEffectTerm> polSourceSiteEffectTermDirectQueryList = new List <PolSourceSiteEffectTerm>();
polSourceSiteEffectTermDirectQueryList = (from c in dbTestDB.PolSourceSiteEffectTerms select c).Where(c => c.PolSourceSiteEffectTermID > 2 && c.PolSourceSiteEffectTermID < 5).ToList();
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceSiteEffectTerm> polSourceSiteEffectTermList = new List <PolSourceSiteEffectTerm>();
polSourceSiteEffectTermList = polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().ToList();
CheckPolSourceSiteEffectTermFields(polSourceSiteEffectTermList);
Assert.AreEqual(polSourceSiteEffectTermDirectQueryList[0].PolSourceSiteEffectTermID, polSourceSiteEffectTermList[0].PolSourceSiteEffectTermID);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public void GenerateLinksBetweenMWQMSitesAndPolSourceSitesForCSSPWebToolsVisualization()
{
string NotUsed = "";
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
AppTaskService appTaskService = new AppTaskService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVFileService tvFileService = new TVFileService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
ProvinceToolsService provinceToolsService = new ProvinceToolsService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
MapInfoService mapInfoService = new MapInfoService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
AppTaskModel appTaskModel = appTaskService.GetAppTaskModelWithAppTaskIDDB(_TaskRunnerBaseService._BWObj.appTaskModel.AppTaskID);
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
if (_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID == 0)
{
NotUsed = string.Format(TaskRunnerServiceRes._Required, TaskRunnerServiceRes.TVItemID);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("_Required", TaskRunnerServiceRes.TVItemID);
return;
}
if (_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID2 == 0)
{
NotUsed = string.Format(TaskRunnerServiceRes._Required, TaskRunnerServiceRes.TVItemID2);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("_Required", TaskRunnerServiceRes.TVItemID2);
return;
}
TVItemModel tvItemModelProvince = tvItemService.GetTVItemModelWithTVItemIDDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelProvince.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFind_With_Equal_, TaskRunnerServiceRes.TVItem, TaskRunnerServiceRes.TVItemID, _TaskRunnerBaseService._BWObj.appTaskModel.TVItemID.ToString());
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat3List("CouldNotFind_With_Equal_", TaskRunnerServiceRes.TVItem, TaskRunnerServiceRes.TVItemID, _TaskRunnerBaseService._BWObj.appTaskModel.TVItemID.ToString());
return;
}
if (tvItemModelProvince.TVType != TVTypeEnum.Province)
{
NotUsed = string.Format(TaskRunnerServiceRes.TVTypeShouldBe_, TVTypeEnum.Province.ToString());
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("TVTypeShouldBe_", TVTypeEnum.Province.ToString());
return;
}
string Parameters = _TaskRunnerBaseService._BWObj.appTaskModel.Parameters;
string[] ParamValueList = Parameters.Split("|||".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
int ProvinceTVItemID = 0;
foreach (string s in ParamValueList)
{
string[] ParamValue = s.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (ParamValue.Length != 2)
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotParse_Properly, TaskRunnerServiceRes.Parameters);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("CouldNotParse_Properly", TaskRunnerServiceRes.Parameters);
return;
}
if (ParamValue[0] == "ProvinceTVItemID")
{
ProvinceTVItemID = int.Parse(ParamValue[1]);
}
else
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFind_, ParamValue[0]);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("CouldNotFind_", ParamValue[0].ToString());
return;
}
}
if (tvItemModelProvince.TVItemID != ProvinceTVItemID)
{
NotUsed = string.Format(TaskRunnerServiceRes._NotEqualTo_, "tvItemModelProvince.TVItemID[" + tvItemModelProvince.TVItemID.ToString() + "]", "ProvinceTVItemID[" + ProvinceTVItemID.ToString() + "]");
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("_NotEqualTo_", "tvItemModelProvince.TVItemID[" + tvItemModelProvince.TVItemID.ToString() + "]", "ProvinceTVItemID[" + ProvinceTVItemID.ToString() + "]");
return;
}
string ServerPath = tvFileService.GetServerFilePath(ProvinceTVItemID);
string Init = provinceToolsService.GetInit(ProvinceTVItemID);
#region Reading the MWQMSitesAndPolSourceSites_XX.KML
List <TVItemIDAndLatLng> TVItemIDAndLatLngList = new List <TVItemIDAndLatLng>();
string FileName = $"MWQMSitesAndPolSourceSites_{Init}.kml";
FileInfo fi = new FileInfo(ServerPath + FileName);
if (!fi.Exists)
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFindFile_, fi.FullName);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("CouldNotFindFile_", fi.FullName);
return;
}
XmlDocument doc = new XmlDocument();
doc.Load(fi.FullName);
foreach (XmlNode node in doc.ChildNodes)
{
GetTVItemIDAndLatLng(TVItemIDAndLatLngList, node);
}
#endregion Reading the MWQMSitesAndPolSourceSites_XX.KML
#region Reading the GroupingInputs__XX.KML
string FileName2 = $"GroupingInputs_{Init}.kml";
FileInfo fi2 = new FileInfo(ServerPath + FileName2);
if (!fi2.Exists)
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFindFile_, fi2.FullName);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("CouldNotFindFile_", fi2.FullName);
return;
}
XmlDocument doc2 = new XmlDocument();
doc2.Load(fi2.FullName);
string CurrentSubsector = "";
string CurrentGroupingMWQMSitesAndPolSourceSites = "";
List <PolyObj> polyObjList = new List <PolyObj>();
XmlNode StartNode2 = doc2.ChildNodes[1].ChildNodes[0];
foreach (XmlNode n in StartNode2.ChildNodes)
{
if (n.Name == "Folder")
{
CurrentSubsector = "";
foreach (XmlNode n22 in n)
{
if (n22.Name == "name")
{
CurrentSubsector = n22.InnerText;
}
if (n22.Name == "Placemark")
{
CurrentGroupingMWQMSitesAndPolSourceSites = "";
foreach (XmlNode n2 in n22)
{
if (n2.Name == "name")
{
CurrentGroupingMWQMSitesAndPolSourceSites = n2.InnerText;
}
if (n2.Name == "Polygon")
{
foreach (XmlNode n222 in n2.ChildNodes)
{
if (n222.Name == "outerBoundaryIs")
{
foreach (XmlNode n2222 in n222.ChildNodes)
{
if (n2222.Name == "LinearRing")
{
PolyObj polyObj = new PolyObj();
polyObj.Subsector = CurrentSubsector;
polyObj.Classification = CurrentGroupingMWQMSitesAndPolSourceSites.ToUpper().Trim();
foreach (XmlNode n3 in n2222.ChildNodes)
{
if (n3.Name == "coordinates")
{
string coordText = n3.InnerText.Trim();
List <string> pointListText = coordText.Split(" ".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList();
int ordinal = 0;
foreach (string pointText in pointListText)
{
string pointTxt = pointText.Trim();
if (!string.IsNullOrWhiteSpace(pointTxt))
{
List <string> valListText = pointTxt.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).ToList();
if (valListText.Count != 3)
{
NotUsed = "valListText.Count != 3";
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageList("valListText.Count != 3");
return;
}
float Lng = float.Parse(valListText[0]);
float Lat = float.Parse(valListText[1]);
Coord coord = new Coord()
{
Lat = Lat, Lng = Lng, Ordinal = ordinal
};
polyObj.coordList.Add(coord);
ordinal += 1;
}
}
}
}
if (polyObj.coordList.Count > 0)
{
polyObj.MinLat = polyObj.coordList.Min(c => c.Lat);
polyObj.MaxLat = polyObj.coordList.Max(c => c.Lat);
polyObj.MinLng = polyObj.coordList.Min(c => c.Lng);
polyObj.MaxLng = polyObj.coordList.Max(c => c.Lng);
}
polyObjList.Add(polyObj);
}
}
}
}
}
}
}
}
}
}
#endregion Reading the GroupingInputs__XX.KML
#region Saving PolSourceSiteEffect in CSSPDB
TVItemModel tvItemModelProv = tvItemService.GetTVItemModelWithTVItemIDDB(ProvinceTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelProv.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFind_With_Equal_, TaskRunnerServiceRes.TVItem, TaskRunnerServiceRes.TVItemID, ProvinceTVItemID.ToString());
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat3List("CouldNotFind_With_Equal_", TaskRunnerServiceRes.TVItem, TaskRunnerServiceRes.TVItemID, ProvinceTVItemID.ToString());
return;
}
// getting all active MWQMSites and PolSourceSites under the province
List <TVItem> tvItemMWQMSiteList = new List <TVItem>();
List <TVItem> tvItemPSSList = new List <TVItem>();
List <TVItem> tvItemInfraList = new List <TVItem>();
using (CSSPDBEntities db2 = new CSSPDBEntities())
{
tvItemMWQMSiteList = (from c in db2.TVItems
where c.TVPath.StartsWith(tvItemModelProv.TVPath + "p") &&
c.TVType == (int)TVTypeEnum.MWQMSite &&
c.IsActive == true
select c).ToList();
tvItemPSSList = (from c in db2.TVItems
where c.TVPath.StartsWith(tvItemModelProv.TVPath + "p") &&
c.TVType == (int)TVTypeEnum.PolSourceSite &&
c.IsActive == true
select c).ToList();
tvItemInfraList = (from c in db2.TVItems
where c.TVPath.StartsWith(tvItemModelProv.TVPath + "p") &&
c.TVType == (int)TVTypeEnum.Infrastructure &&
c.IsActive == true
select c).ToList();
}
List <TVItemModel> tvitemModelSSList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelProv.TVItemID, TVTypeEnum.Subsector);
List <PolSourceSiteEffect> existingPolSourceSiteEffectSubsectorList = new List <PolSourceSiteEffect>();
List <PolSourceSiteEffect> newPolSourceSiteEffectSubsectorList = new List <PolSourceSiteEffect>();
int CountSS = 0;
int TotalCount = tvitemModelSSList.Count;
string Status = appTaskModel.StatusText;
foreach (TVItemModel tvItemModelSS in tvitemModelSSList)
{
CountSS += 1;
if (CountSS % 1 == 0)
{
_TaskRunnerBaseService.SendPercentToDB(_TaskRunnerBaseService._BWObj.appTaskModel.AppTaskID, (int)(100.0f * ((float)CountSS / (float)TotalCount)));
}
Application.DoEvents();
string TVTextSS = "";
if (tvItemModelSS.TVText.Contains(" "))
{
TVTextSS = tvItemModelSS.TVText.Substring(0, tvItemModelSS.TVText.IndexOf(" "));
}
else
{
TVTextSS = tvItemModelSS.TVText;
}
foreach (PolyObj polyObj in polyObjList.Where(c => c.Subsector == TVTextSS))
{
List <MapInfo> mapInfoMWQMSiteList2 = new List <MapInfo>();
List <MapInfo> mapInfoPSSList2 = new List <MapInfo>();
List <MapInfo> mapInfoInfraList2 = new List <MapInfo>();
using (CSSPDBEntities db2 = new CSSPDBEntities())
{
var mapInfoMWQMSiteList = (from c in db2.MapInfos
let lat = (from d in db2.MapInfoPoints where c.MapInfoID == d.MapInfoID select d).FirstOrDefault().Lat
let lng = (from d in db2.MapInfoPoints where c.MapInfoID == d.MapInfoID select d).FirstOrDefault().Lng
where c.TVType == (int)TVTypeEnum.MWQMSite &&
c.MapInfoDrawType == (int)MapInfoDrawTypeEnum.Point &&
lat >= polyObj.MinLat &&
lat <= polyObj.MaxLat &&
lng >= polyObj.MinLng &&
lng <= polyObj.MaxLng
select new { c, lat, lng }).ToList();
var mapInfoPSSList = (from c in db2.MapInfos
let lat = (from d in db2.MapInfoPoints where c.MapInfoID == d.MapInfoID select d).FirstOrDefault().Lat
let lng = (from d in db2.MapInfoPoints where c.MapInfoID == d.MapInfoID select d).FirstOrDefault().Lng
where c.TVType == (int)TVTypeEnum.PolSourceSite &&
c.MapInfoDrawType == (int)MapInfoDrawTypeEnum.Point &&
lat >= polyObj.MinLat &&
lat <= polyObj.MaxLat &&
lng >= polyObj.MinLng &&
lng <= polyObj.MaxLng
select new { c, lat, lng }).ToList();
var mapInfoInfraList = (from c in db2.MapInfos
let lat = (from d in db2.MapInfoPoints where c.MapInfoID == d.MapInfoID select d).FirstOrDefault().Lat
let lng = (from d in db2.MapInfoPoints where c.MapInfoID == d.MapInfoID select d).FirstOrDefault().Lng
where (c.TVType == (int)TVTypeEnum.WasteWaterTreatmentPlant ||
c.TVType == (int)TVTypeEnum.LiftStation ||
c.TVType == (int)TVTypeEnum.LineOverflow) &&
c.MapInfoDrawType == (int)MapInfoDrawTypeEnum.Point &&
lat >= polyObj.MinLat &&
lat <= polyObj.MaxLat &&
lng >= polyObj.MinLng &&
lng <= polyObj.MaxLng
select new { c, lat, lng }).ToList();
foreach (var mapInfo in mapInfoMWQMSiteList)
{
if (mapInfoService.CoordInPolygon(polyObj.coordList, new Coord()
{
Lat = (float)mapInfo.lat, Lng = (float)mapInfo.lng, Ordinal = 0
}))
{
mapInfoMWQMSiteList2.Add(mapInfo.c);
}
}
foreach (var mapInfo in mapInfoPSSList)
{
if (mapInfoService.CoordInPolygon(polyObj.coordList, new Coord()
{
Lat = (float)mapInfo.lat, Lng = (float)mapInfo.lng, Ordinal = 0
}))
{
mapInfoPSSList2.Add(mapInfo.c);
}
}
foreach (var mapInfo in mapInfoInfraList)
{
if (mapInfoService.CoordInPolygon(polyObj.coordList, new Coord()
{
Lat = (float)mapInfo.lat, Lng = (float)mapInfo.lng, Ordinal = 0
}))
{
mapInfoInfraList2.Add(mapInfo.c);
}
}
}
List <int> PSSTVItemIDList = (from c in mapInfoPSSList2
select c.TVItemID).Distinct().ToList();
List <int> MWQMTVItemIDList = (from c in mapInfoMWQMSiteList2
select c.TVItemID).Distinct().ToList();
List <int> InfraTVItemIDList = (from c in mapInfoInfraList2
select c.TVItemID).Distinct().ToList();
using (CSSPDBEntities db2 = new CSSPDBEntities())
{
List <int> TVItemIDMWQMSiteWithinSubsector = tvItemMWQMSiteList.Where(c => c.TVPath.Contains(tvItemModelSS.TVPath + "p")).Select(c => c.TVItemID).ToList();
existingPolSourceSiteEffectSubsectorList = (from c in db2.PolSourceSiteEffects
from m in TVItemIDMWQMSiteWithinSubsector
where c.MWQMSiteTVItemID == m
select c).ToList();
}
foreach (TVItem tvItemMWQMSite in tvItemMWQMSiteList.Where(c => c.TVPath.Contains(tvItemModelSS.TVPath + "p")))
{
if (MWQMTVItemIDList.Contains(tvItemMWQMSite.TVItemID))
{
List <PolSourceSiteEffect> MWQMSiteExistingPolSourceSiteEffectList = (from c in existingPolSourceSiteEffectSubsectorList
where c.MWQMSiteTVItemID == tvItemMWQMSite.TVItemID
select c).ToList();
// doing pollution source site
foreach (int PSSTVItemID in PSSTVItemIDList)
{
newPolSourceSiteEffectSubsectorList.Add(new PolSourceSiteEffect()
{
PolSourceSiteOrInfrastructureTVItemID = PSSTVItemID, MWQMSiteTVItemID = tvItemMWQMSite.TVItemID,
});
if (!(MWQMSiteExistingPolSourceSiteEffectList.Where(c => c.PolSourceSiteOrInfrastructureTVItemID == PSSTVItemID).Any()))
{
PolSourceSiteEffectModel polSourceSiteEffectModelNew = new PolSourceSiteEffectModel()
{
PolSourceSiteOrInfrastructureTVItemID = PSSTVItemID,
MWQMSiteTVItemID = tvItemMWQMSite.TVItemID,
};
PolSourceSiteEffectModel polSourceSiteEffectModelAlreadyExist = polSourceSiteEffectService.GetPolSourceSiteEffectModelWithPolSourceSiteOrInfrastructureTVItemIDAndMWQMSiteTVItemIDDB(PSSTVItemID, tvItemMWQMSite.TVItemID);
if (!string.IsNullOrWhiteSpace(polSourceSiteEffectModelAlreadyExist.Error))
{
PolSourceSiteEffectModel polSourceSiteEffectModelRet = polSourceSiteEffectService.PostAddPolSourceSiteEffectDB(polSourceSiteEffectModelNew);
if (!string.IsNullOrWhiteSpace(polSourceSiteEffectModelRet.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotAdd_Error_, TaskRunnerServiceRes.PolSourceSiteEffect, polSourceSiteEffectModelRet.Error);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("CouldNotAdd_Error_", TaskRunnerServiceRes.PolSourceSiteEffect, polSourceSiteEffectModelRet.Error);
return;
}
}
}
}
// doing infrastructure
foreach (int InfraTVItemID in InfraTVItemIDList)
{
newPolSourceSiteEffectSubsectorList.Add(new PolSourceSiteEffect()
{
PolSourceSiteOrInfrastructureTVItemID = InfraTVItemID, MWQMSiteTVItemID = tvItemMWQMSite.TVItemID,
});
if (!(MWQMSiteExistingPolSourceSiteEffectList.Where(c => c.PolSourceSiteOrInfrastructureTVItemID == InfraTVItemID).Any()))
{
PolSourceSiteEffectModel polSourceSiteEffectModelNew = new PolSourceSiteEffectModel()
{
PolSourceSiteOrInfrastructureTVItemID = InfraTVItemID,
MWQMSiteTVItemID = tvItemMWQMSite.TVItemID,
};
PolSourceSiteEffectModel polSourceSiteEffectModelAlreadyExist = polSourceSiteEffectService.GetPolSourceSiteEffectModelWithPolSourceSiteOrInfrastructureTVItemIDAndMWQMSiteTVItemIDDB(InfraTVItemID, tvItemMWQMSite.TVItemID);
if (!string.IsNullOrWhiteSpace(polSourceSiteEffectModelAlreadyExist.Error))
{
PolSourceSiteEffectModel polSourceSiteEffectModelRet = polSourceSiteEffectService.PostAddPolSourceSiteEffectDB(polSourceSiteEffectModelNew);
if (!string.IsNullOrWhiteSpace(polSourceSiteEffectModelRet.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotAdd_Error_, TaskRunnerServiceRes.PolSourceSiteEffect, polSourceSiteEffectModelRet.Error);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("CouldNotAdd_Error_", TaskRunnerServiceRes.PolSourceSiteEffect, polSourceSiteEffectModelRet.Error);
return;
}
}
}
}
}
}
}
}
foreach (PolSourceSiteEffect polSourceSiteEffect in existingPolSourceSiteEffectSubsectorList)
{
if (!newPolSourceSiteEffectSubsectorList.Where(c => c.PolSourceSiteOrInfrastructureTVItemID == polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID &&
c.MWQMSiteTVItemID == polSourceSiteEffect.MWQMSiteTVItemID).Any())
{
PolSourceSiteEffectModel polSourceSiteEffectModelAlreadyExist = polSourceSiteEffectService.GetPolSourceSiteEffectModelWithPolSourceSiteOrInfrastructureTVItemIDAndMWQMSiteTVItemIDDB(polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID, polSourceSiteEffect.MWQMSiteTVItemID);
if (string.IsNullOrWhiteSpace(polSourceSiteEffectModelAlreadyExist.Error))
{
PolSourceSiteEffectModel polSourceSiteEffectModelRet = polSourceSiteEffectService.PostDeletePolSourceSiteEffectDB(polSourceSiteEffectModelAlreadyExist.PolSourceSiteEffectID);
if (!string.IsNullOrWhiteSpace(polSourceSiteEffectModelRet.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotDelete_Error_, TaskRunnerServiceRes.PolSourceSiteEffect, polSourceSiteEffectModelRet.Error);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("CouldNotDelete_Error_", TaskRunnerServiceRes.PolSourceSiteEffect, polSourceSiteEffectModelRet.Error);
return;
}
}
}
}
#endregion Saving PolSourceSiteEffect in CSSPDB
appTaskModel.PercentCompleted = 100;
appTaskService.PostUpdateAppTask(appTaskModel);
}
public void PolSourceSiteEffectTerm_Controller_GetPolSourceSiteEffectTermList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectTermController polSourceSiteEffectTermController = new PolSourceSiteEffectTermController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectTermController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectTermController.DatabaseType);
PolSourceSiteEffectTerm polSourceSiteEffectTermFirst = new PolSourceSiteEffectTerm();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(query, db, ContactID);
polSourceSiteEffectTermFirst = (from c in db.PolSourceSiteEffectTerms select c).FirstOrDefault();
count = (from c in db.PolSourceSiteEffectTerms select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with PolSourceSiteEffectTerm info
IHttpActionResult jsonRet = polSourceSiteEffectTermController.GetPolSourceSiteEffectTermList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <PolSourceSiteEffectTerm> > ret = jsonRet as OkNegotiatedContentResult <List <PolSourceSiteEffectTerm> >;
Assert.AreEqual(polSourceSiteEffectTermFirst.PolSourceSiteEffectTermID, ret.Content[0].PolSourceSiteEffectTermID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <PolSourceSiteEffectTerm> polSourceSiteEffectTermList = new List <PolSourceSiteEffectTerm>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(query, db, ContactID);
polSourceSiteEffectTermList = (from c in db.PolSourceSiteEffectTerms select c).OrderBy(c => c.PolSourceSiteEffectTermID).Skip(0).Take(2).ToList();
count = (from c in db.PolSourceSiteEffectTerms select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with PolSourceSiteEffectTerm info
jsonRet = polSourceSiteEffectTermController.GetPolSourceSiteEffectTermList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <PolSourceSiteEffectTerm> >;
Assert.AreEqual(polSourceSiteEffectTermList[0].PolSourceSiteEffectTermID, ret.Content[0].PolSourceSiteEffectTermID);
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 PolSourceSiteEffectTerm info
IHttpActionResult jsonRet2 = polSourceSiteEffectTermController.GetPolSourceSiteEffectTermList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <PolSourceSiteEffectTerm> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <PolSourceSiteEffectTerm> >;
Assert.AreEqual(polSourceSiteEffectTermList[1].PolSourceSiteEffectTermID, ret2.Content[0].PolSourceSiteEffectTermID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void PolSourceSiteEffectTerm_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectTermController polSourceSiteEffectTermController = new PolSourceSiteEffectTermController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectTermController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectTermController.DatabaseType);
PolSourceSiteEffectTerm polSourceSiteEffectTermLast = new PolSourceSiteEffectTerm();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(query, db, ContactID);
polSourceSiteEffectTermLast = (from c in db.PolSourceSiteEffectTerms select c).FirstOrDefault();
}
// ok with PolSourceSiteEffectTerm info
IHttpActionResult jsonRet = polSourceSiteEffectTermController.GetPolSourceSiteEffectTermWithID(polSourceSiteEffectTermLast.PolSourceSiteEffectTermID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffectTerm> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffectTerm>;
PolSourceSiteEffectTerm polSourceSiteEffectTermRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectTermLast.PolSourceSiteEffectTermID, polSourceSiteEffectTermRet.PolSourceSiteEffectTermID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because PolSourceSiteEffectTermID exist
IHttpActionResult jsonRet2 = polSourceSiteEffectTermController.Post(polSourceSiteEffectTermRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffectTerm> polSourceSiteEffectTermRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffectTerm>;
Assert.IsNull(polSourceSiteEffectTermRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added PolSourceSiteEffectTerm
polSourceSiteEffectTermRet.PolSourceSiteEffectTermID = 0;
polSourceSiteEffectTermController.Request = new System.Net.Http.HttpRequestMessage();
polSourceSiteEffectTermController.Request.RequestUri = new System.Uri("http://localhost:5000/api/polSourceSiteEffectTerm");
IHttpActionResult jsonRet3 = polSourceSiteEffectTermController.Post(polSourceSiteEffectTermRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <PolSourceSiteEffectTerm> polSourceSiteEffectTermRet3 = jsonRet3 as CreatedNegotiatedContentResult <PolSourceSiteEffectTerm>;
Assert.IsNotNull(polSourceSiteEffectTermRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = polSourceSiteEffectTermController.Delete(polSourceSiteEffectTermRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <PolSourceSiteEffectTerm> polSourceSiteEffectTermRet4 = jsonRet4 as OkNegotiatedContentResult <PolSourceSiteEffectTerm>;
Assert.IsNotNull(polSourceSiteEffectTermRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
public void PolSourceSiteEffectTerm_Properties_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectTermService polSourceSiteEffectTermService = new PolSourceSiteEffectTermService(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 = polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Count();
PolSourceSiteEffectTerm polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
// -------------------------------
// -------------------------------
// Properties testing
// -------------------------------
// -------------------------------
// -----------------------------------
// [Key]
// Is NOT Nullable
// polSourceSiteEffectTerm.PolSourceSiteEffectTermID (Int32)
// -----------------------------------
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.PolSourceSiteEffectTermID = 0;
polSourceSiteEffectTermService.Update(polSourceSiteEffectTerm);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "PolSourceSiteEffectTermID"), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.PolSourceSiteEffectTermID = 10000000;
polSourceSiteEffectTermService.Update(polSourceSiteEffectTerm);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "PolSourceSiteEffectTerm", "PolSourceSiteEffectTermID", polSourceSiteEffectTerm.PolSourceSiteEffectTermID.ToString()), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// polSourceSiteEffectTerm.IsGroup (Boolean)
// -----------------------------------
// -----------------------------------
// Is Nullable
// [CSSPExist(ExistTypeName = "PolSourceSiteEffectTerm", ExistPlurial = "s", ExistFieldID = "PolSourceSiteEffectTermID", AllowableTVtypeList = )]
// polSourceSiteEffectTerm.UnderGroupID (Int32)
// -----------------------------------
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.UnderGroupID = 0;
polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "PolSourceSiteEffectTerm", "UnderGroupID", polSourceSiteEffectTerm.UnderGroupID.ToString()), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [StringLength(100))]
// polSourceSiteEffectTerm.EffectTermEN (String)
// -----------------------------------
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("EffectTermEN");
Assert.AreEqual(false, polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm));
Assert.AreEqual(1, polSourceSiteEffectTerm.ValidationResults.Count());
Assert.IsTrue(polSourceSiteEffectTerm.ValidationResults.Where(c => c.ErrorMessage == string.Format(CSSPServicesRes._IsRequired, "EffectTermEN")).Any());
Assert.AreEqual(null, polSourceSiteEffectTerm.EffectTermEN);
Assert.AreEqual(count, polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Count());
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.EffectTermEN = GetRandomString("", 101);
Assert.AreEqual(false, polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm));
Assert.AreEqual(string.Format(CSSPServicesRes._MaxLengthIs_, "EffectTermEN", "100"), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Count());
// -----------------------------------
// Is NOT Nullable
// [StringLength(100))]
// polSourceSiteEffectTerm.EffectTermFR (String)
// -----------------------------------
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("EffectTermFR");
Assert.AreEqual(false, polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm));
Assert.AreEqual(1, polSourceSiteEffectTerm.ValidationResults.Count());
Assert.IsTrue(polSourceSiteEffectTerm.ValidationResults.Where(c => c.ErrorMessage == string.Format(CSSPServicesRes._IsRequired, "EffectTermFR")).Any());
Assert.AreEqual(null, polSourceSiteEffectTerm.EffectTermFR);
Assert.AreEqual(count, polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Count());
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.EffectTermFR = GetRandomString("", 101);
Assert.AreEqual(false, polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm));
Assert.AreEqual(string.Format(CSSPServicesRes._MaxLengthIs_, "EffectTermFR", "100"), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, polSourceSiteEffectTermService.GetPolSourceSiteEffectTermList().Count());
// -----------------------------------
// Is NOT Nullable
// [CSSPAfter(Year = 1980)]
// polSourceSiteEffectTerm.LastUpdateDate_UTC (DateTime)
// -----------------------------------
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.LastUpdateDate_UTC = new DateTime();
polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.LastUpdateDate_UTC = new DateTime(1979, 1, 1);
polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Contact)]
// polSourceSiteEffectTerm.LastUpdateContactTVItemID (Int32)
// -----------------------------------
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.LastUpdateContactTVItemID = 0;
polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", polSourceSiteEffectTerm.LastUpdateContactTVItemID.ToString()), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffectTerm = null;
polSourceSiteEffectTerm = GetFilledRandomPolSourceSiteEffectTerm("");
polSourceSiteEffectTerm.LastUpdateContactTVItemID = 1;
polSourceSiteEffectTermService.Add(polSourceSiteEffectTerm);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), polSourceSiteEffectTerm.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// polSourceSiteEffectTerm.HasErrors (Boolean)
// -----------------------------------
// No testing requied
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// polSourceSiteEffectTerm.ValidationResults (IEnumerable`1)
// -----------------------------------
// No testing requied
}
}
}
