public void PolSourceSiteEffect_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectController polSourceSiteEffectController = new PolSourceSiteEffectController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectController.DatabaseType);
PolSourceSiteEffect polSourceSiteEffectLast = new PolSourceSiteEffect();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(query, db, ContactID);
polSourceSiteEffectLast = (from c in db.PolSourceSiteEffects select c).FirstOrDefault();
}
// ok with PolSourceSiteEffect info
IHttpActionResult jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectWithID(polSourceSiteEffectLast.PolSourceSiteEffectID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffect> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffect>;
PolSourceSiteEffect polSourceSiteEffectRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectLast.PolSourceSiteEffectID, polSourceSiteEffectRet.PolSourceSiteEffectID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = polSourceSiteEffectController.Put(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNotNull(polSourceSiteEffectRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because PolSourceSiteEffectID of 0 does not exist
polSourceSiteEffectRet.PolSourceSiteEffectID = 0;
IHttpActionResult jsonRet3 = polSourceSiteEffectController.Put(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet3 = jsonRet3 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNull(polSourceSiteEffectRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public IHttpActionResult GetPolSourceSiteEffectList([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))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query()
{
Lang = lang
}, db, ContactID);
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 PolSourceSiteEffect_CRUD_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(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]
}
PolSourceSiteEffect polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
// -------------------------------
// -------------------------------
// CRUD testing
// -------------------------------
// -------------------------------
count = polSourceSiteEffectService.GetPolSourceSiteEffectList().Count();
Assert.AreEqual(count, (from c in dbTestDB.PolSourceSiteEffects select c).Count());
polSourceSiteEffectService.Add(polSourceSiteEffect);
if (polSourceSiteEffect.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(true, polSourceSiteEffectService.GetPolSourceSiteEffectList().Where(c => c == polSourceSiteEffect).Any());
polSourceSiteEffectService.Update(polSourceSiteEffect);
if (polSourceSiteEffect.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count + 1, polSourceSiteEffectService.GetPolSourceSiteEffectList().Count());
polSourceSiteEffectService.Delete(polSourceSiteEffect);
if (polSourceSiteEffect.HasErrors)
{
Assert.AreEqual("", polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count, polSourceSiteEffectService.GetPolSourceSiteEffectList().Count());
}
}
}
public void PolSourceSiteEffect_Controller_GetPolSourceSiteEffectWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectController polSourceSiteEffectController = new PolSourceSiteEffectController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectController.DatabaseType);
PolSourceSiteEffect polSourceSiteEffectFirst = new PolSourceSiteEffect();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query(), db, ContactID);
polSourceSiteEffectFirst = (from c in db.PolSourceSiteEffects select c).FirstOrDefault();
}
// ok with PolSourceSiteEffect info
IHttpActionResult jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectWithID(polSourceSiteEffectFirst.PolSourceSiteEffectID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffect> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffect>;
PolSourceSiteEffect polSourceSiteEffectRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectFirst.PolSourceSiteEffectID, polSourceSiteEffectRet.PolSourceSiteEffectID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = polSourceSiteEffectController.GetPolSourceSiteEffectWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNull(polSourceSiteEffectRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public void GetPolSourceSiteEffectList_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
PolSourceSiteEffect polSourceSiteEffect = (from c in dbTestDB.PolSourceSiteEffects select c).FirstOrDefault();
Assert.IsNotNull(polSourceSiteEffect);
List <PolSourceSiteEffect> polSourceSiteEffectDirectQueryList = new List <PolSourceSiteEffect>();
polSourceSiteEffectDirectQueryList = (from c in dbTestDB.PolSourceSiteEffects select c).Take(200).ToList();
foreach (string extra in new List <string>()
{
null, "A", "B", "C", "D", "E"
})
{
polSourceSiteEffectService.Query.Extra = extra;
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceSiteEffect> polSourceSiteEffectList = new List <PolSourceSiteEffect>();
polSourceSiteEffectList = polSourceSiteEffectService.GetPolSourceSiteEffectList().ToList();
CheckPolSourceSiteEffectFields(polSourceSiteEffectList);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public void GetPolSourceSiteEffectList_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"
})
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
polSourceSiteEffectService.Query = polSourceSiteEffectService.FillQuery(typeof(PolSourceSiteEffect), culture.TwoLetterISOLanguageName, 0, 10000, "", "", "PolSourceSiteEffectID,GT,2|PolSourceSiteEffectID,LT,5", extra);
List <PolSourceSiteEffect> polSourceSiteEffectDirectQueryList = new List <PolSourceSiteEffect>();
polSourceSiteEffectDirectQueryList = (from c in dbTestDB.PolSourceSiteEffects select c).Where(c => c.PolSourceSiteEffectID > 2 && c.PolSourceSiteEffectID < 5).ToList();
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceSiteEffect> polSourceSiteEffectList = new List <PolSourceSiteEffect>();
polSourceSiteEffectList = polSourceSiteEffectService.GetPolSourceSiteEffectList().ToList();
CheckPolSourceSiteEffectFields(polSourceSiteEffectList);
Assert.AreEqual(polSourceSiteEffectDirectQueryList[0].PolSourceSiteEffectID, polSourceSiteEffectList[0].PolSourceSiteEffectID);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public void GetPolSourceSiteEffectList_Skip_Take_2Desc_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"
})
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
polSourceSiteEffectService.Query = polSourceSiteEffectService.FillQuery(typeof(PolSourceSiteEffect), culture.TwoLetterISOLanguageName, 1, 1, "", "PolSourceSiteEffectID,PolSourceSiteOrInfrastructureTVItemID", "", extra);
List <PolSourceSiteEffect> polSourceSiteEffectDirectQueryList = new List <PolSourceSiteEffect>();
polSourceSiteEffectDirectQueryList = (from c in dbTestDB.PolSourceSiteEffects select c).OrderByDescending(c => c.PolSourceSiteEffectID).ThenByDescending(c => c.PolSourceSiteOrInfrastructureTVItemID).Skip(1).Take(1).ToList();
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceSiteEffect> polSourceSiteEffectList = new List <PolSourceSiteEffect>();
polSourceSiteEffectList = polSourceSiteEffectService.GetPolSourceSiteEffectList().ToList();
CheckPolSourceSiteEffectFields(polSourceSiteEffectList);
Assert.AreEqual(polSourceSiteEffectDirectQueryList[0].PolSourceSiteEffectID, polSourceSiteEffectList[0].PolSourceSiteEffectID);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public void PolSourceSiteEffect_Properties_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(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 = polSourceSiteEffectService.GetPolSourceSiteEffectList().Count();
PolSourceSiteEffect polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
// -------------------------------
// -------------------------------
// Properties testing
// -------------------------------
// -------------------------------
// -----------------------------------
// [Key]
// Is NOT Nullable
// polSourceSiteEffect.PolSourceSiteEffectID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteEffectID = 0;
polSourceSiteEffectService.Update(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "PolSourceSiteEffectID"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteEffectID = 10000000;
polSourceSiteEffectService.Update(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "PolSourceSiteEffect", "PolSourceSiteEffectID", polSourceSiteEffect.PolSourceSiteEffectID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Infrastructure,PolSourceSite)]
// polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID = 0;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "PolSourceSiteOrInfrastructureTVItemID", polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteOrInfrastructureTVItemID = 1;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "PolSourceSiteOrInfrastructureTVItemID", "Infrastructure,PolSourceSite"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = MWQMSite)]
// polSourceSiteEffect.MWQMSiteTVItemID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.MWQMSiteTVItemID = 0;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "MWQMSiteTVItemID", polSourceSiteEffect.MWQMSiteTVItemID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.MWQMSiteTVItemID = 1;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "MWQMSiteTVItemID", "MWQMSite"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is Nullable
// [StringLength(250))]
// polSourceSiteEffect.PolSourceSiteEffectTermIDs (String)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.PolSourceSiteEffectTermIDs = GetRandomString("", 251);
Assert.AreEqual(false, polSourceSiteEffectService.Add(polSourceSiteEffect));
Assert.AreEqual(string.Format(CSSPServicesRes._MaxLengthIs_, "PolSourceSiteEffectTermIDs", "250"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, polSourceSiteEffectService.GetPolSourceSiteEffectList().Count());
// -----------------------------------
// Is Nullable
// polSourceSiteEffect.Comments (String)
// -----------------------------------
// -----------------------------------
// Is Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = File)]
// polSourceSiteEffect.AnalysisDocumentTVItemID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.AnalysisDocumentTVItemID = 0;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "AnalysisDocumentTVItemID", polSourceSiteEffect.AnalysisDocumentTVItemID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.AnalysisDocumentTVItemID = 1;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "AnalysisDocumentTVItemID", "File"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPAfter(Year = 1980)]
// polSourceSiteEffect.LastUpdateDate_UTC (DateTime)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.LastUpdateDate_UTC = new DateTime();
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.LastUpdateDate_UTC = new DateTime(1979, 1, 1);
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Contact)]
// polSourceSiteEffect.LastUpdateContactTVItemID (Int32)
// -----------------------------------
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.LastUpdateContactTVItemID = 0;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", polSourceSiteEffect.LastUpdateContactTVItemID.ToString()), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceSiteEffect = null;
polSourceSiteEffect = GetFilledRandomPolSourceSiteEffect("");
polSourceSiteEffect.LastUpdateContactTVItemID = 1;
polSourceSiteEffectService.Add(polSourceSiteEffect);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), polSourceSiteEffect.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// polSourceSiteEffect.HasErrors (Boolean)
// -----------------------------------
// No testing requied
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// polSourceSiteEffect.ValidationResults (IEnumerable`1)
// -----------------------------------
// No testing requied
}
}
}
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 PolSourceSiteEffect_Controller_GetPolSourceSiteEffectList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectController polSourceSiteEffectController = new PolSourceSiteEffectController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectController.DatabaseType);
PolSourceSiteEffect polSourceSiteEffectFirst = new PolSourceSiteEffect();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(query, db, ContactID);
polSourceSiteEffectFirst = (from c in db.PolSourceSiteEffects select c).FirstOrDefault();
count = (from c in db.PolSourceSiteEffects select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with PolSourceSiteEffect info
IHttpActionResult jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <PolSourceSiteEffect> > ret = jsonRet as OkNegotiatedContentResult <List <PolSourceSiteEffect> >;
Assert.AreEqual(polSourceSiteEffectFirst.PolSourceSiteEffectID, ret.Content[0].PolSourceSiteEffectID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <PolSourceSiteEffect> polSourceSiteEffectList = new List <PolSourceSiteEffect>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(query, db, ContactID);
polSourceSiteEffectList = (from c in db.PolSourceSiteEffects select c).OrderBy(c => c.PolSourceSiteEffectID).Skip(0).Take(2).ToList();
count = (from c in db.PolSourceSiteEffects select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with PolSourceSiteEffect info
jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <PolSourceSiteEffect> >;
Assert.AreEqual(polSourceSiteEffectList[0].PolSourceSiteEffectID, ret.Content[0].PolSourceSiteEffectID);
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 PolSourceSiteEffect info
IHttpActionResult jsonRet2 = polSourceSiteEffectController.GetPolSourceSiteEffectList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <PolSourceSiteEffect> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <PolSourceSiteEffect> >;
Assert.AreEqual(polSourceSiteEffectList[1].PolSourceSiteEffectID, ret2.Content[0].PolSourceSiteEffectID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void PolSourceSiteEffect_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceSiteEffectController polSourceSiteEffectController = new PolSourceSiteEffectController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceSiteEffectController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceSiteEffectController.DatabaseType);
PolSourceSiteEffect polSourceSiteEffectLast = new PolSourceSiteEffect();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
PolSourceSiteEffectService polSourceSiteEffectService = new PolSourceSiteEffectService(query, db, ContactID);
polSourceSiteEffectLast = (from c in db.PolSourceSiteEffects select c).FirstOrDefault();
}
// ok with PolSourceSiteEffect info
IHttpActionResult jsonRet = polSourceSiteEffectController.GetPolSourceSiteEffectWithID(polSourceSiteEffectLast.PolSourceSiteEffectID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceSiteEffect> Ret = jsonRet as OkNegotiatedContentResult <PolSourceSiteEffect>;
PolSourceSiteEffect polSourceSiteEffectRet = Ret.Content;
Assert.AreEqual(polSourceSiteEffectLast.PolSourceSiteEffectID, polSourceSiteEffectRet.PolSourceSiteEffectID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because PolSourceSiteEffectID exist
IHttpActionResult jsonRet2 = polSourceSiteEffectController.Post(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNull(polSourceSiteEffectRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added PolSourceSiteEffect
polSourceSiteEffectRet.PolSourceSiteEffectID = 0;
polSourceSiteEffectController.Request = new System.Net.Http.HttpRequestMessage();
polSourceSiteEffectController.Request.RequestUri = new System.Uri("http://localhost:5000/api/polSourceSiteEffect");
IHttpActionResult jsonRet3 = polSourceSiteEffectController.Post(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet3 = jsonRet3 as CreatedNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNotNull(polSourceSiteEffectRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = polSourceSiteEffectController.Delete(polSourceSiteEffectRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <PolSourceSiteEffect> polSourceSiteEffectRet4 = jsonRet4 as OkNegotiatedContentResult <PolSourceSiteEffect>;
Assert.IsNotNull(polSourceSiteEffectRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
