public PolSourceObservationService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_PolSourceObservationIssueService = new PolSourceObservationIssueService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public void PolSourceObservationIssue_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceObservationIssueController polSourceObservationIssueController = new PolSourceObservationIssueController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceObservationIssueController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceObservationIssueController.DatabaseType);
PolSourceObservationIssue polSourceObservationIssueLast = new PolSourceObservationIssue();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(query, db, ContactID);
polSourceObservationIssueLast = (from c in db.PolSourceObservationIssues select c).FirstOrDefault();
}
// ok with PolSourceObservationIssue info
IHttpActionResult jsonRet = polSourceObservationIssueController.GetPolSourceObservationIssueWithID(polSourceObservationIssueLast.PolSourceObservationIssueID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceObservationIssue> Ret = jsonRet as OkNegotiatedContentResult <PolSourceObservationIssue>;
PolSourceObservationIssue polSourceObservationIssueRet = Ret.Content;
Assert.AreEqual(polSourceObservationIssueLast.PolSourceObservationIssueID, polSourceObservationIssueRet.PolSourceObservationIssueID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = polSourceObservationIssueController.Put(polSourceObservationIssueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceObservationIssue> polSourceObservationIssueRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceObservationIssue>;
Assert.IsNotNull(polSourceObservationIssueRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because PolSourceObservationIssueID of 0 does not exist
polSourceObservationIssueRet.PolSourceObservationIssueID = 0;
IHttpActionResult jsonRet3 = polSourceObservationIssueController.Put(polSourceObservationIssueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <PolSourceObservationIssue> polSourceObservationIssueRet3 = jsonRet3 as OkNegotiatedContentResult <PolSourceObservationIssue>;
Assert.IsNull(polSourceObservationIssueRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public IHttpActionResult GetPolSourceObservationIssueList([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))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(new Query()
{
Lang = lang
}, db, ContactID);
public ProvinceToolsService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_TVItemService = new TVItemService(LanguageRequest, User);
_AppTaskService = new AppTaskService(LanguageRequest, User);
_TVFileService = new TVFileService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_PolSourceSiteService = new PolSourceSiteService(LanguageRequest, User);
_PolSourceObservationService = new PolSourceObservationService(LanguageRequest, User);
_PolSourceObservationIssueService = new PolSourceObservationIssueService(LanguageRequest, User);
}
public void PolSourceObservationIssue_CRUD_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(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]
}
PolSourceObservationIssue polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
// -------------------------------
// -------------------------------
// CRUD testing
// -------------------------------
// -------------------------------
count = polSourceObservationIssueService.GetPolSourceObservationIssueList().Count();
Assert.AreEqual(count, (from c in dbTestDB.PolSourceObservationIssues select c).Count());
polSourceObservationIssueService.Add(polSourceObservationIssue);
if (polSourceObservationIssue.HasErrors)
{
Assert.AreEqual("", polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(true, polSourceObservationIssueService.GetPolSourceObservationIssueList().Where(c => c == polSourceObservationIssue).Any());
polSourceObservationIssueService.Update(polSourceObservationIssue);
if (polSourceObservationIssue.HasErrors)
{
Assert.AreEqual("", polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count + 1, polSourceObservationIssueService.GetPolSourceObservationIssueList().Count());
polSourceObservationIssueService.Delete(polSourceObservationIssue);
if (polSourceObservationIssue.HasErrors)
{
Assert.AreEqual("", polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
}
Assert.AreEqual(count, polSourceObservationIssueService.GetPolSourceObservationIssueList().Count());
}
}
}
public IHttpActionResult GetPolSourceObservationIssueWithID([FromUri] int PolSourceObservationIssueID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
polSourceObservationIssueService.Query = polSourceObservationIssueService.FillQuery(typeof(PolSourceObservationIssue), lang, 0, 1, "", "", extra);
if (polSourceObservationIssueService.Query.Extra == "A")
{
PolSourceObservationIssueExtraA polSourceObservationIssueExtraA = new PolSourceObservationIssueExtraA();
polSourceObservationIssueExtraA = polSourceObservationIssueService.GetPolSourceObservationIssueExtraAWithPolSourceObservationIssueID(PolSourceObservationIssueID);
if (polSourceObservationIssueExtraA == null)
{
return(NotFound());
}
return(Ok(polSourceObservationIssueExtraA));
}
else if (polSourceObservationIssueService.Query.Extra == "B")
{
PolSourceObservationIssueExtraB polSourceObservationIssueExtraB = new PolSourceObservationIssueExtraB();
polSourceObservationIssueExtraB = polSourceObservationIssueService.GetPolSourceObservationIssueExtraBWithPolSourceObservationIssueID(PolSourceObservationIssueID);
if (polSourceObservationIssueExtraB == null)
{
return(NotFound());
}
return(Ok(polSourceObservationIssueExtraB));
}
else
{
PolSourceObservationIssue polSourceObservationIssue = new PolSourceObservationIssue();
polSourceObservationIssue = polSourceObservationIssueService.GetPolSourceObservationIssueWithPolSourceObservationIssueID(PolSourceObservationIssueID);
if (polSourceObservationIssue == null)
{
return(NotFound());
}
return(Ok(polSourceObservationIssue));
}
}
}
public void PolSourceObservationIssue_Controller_GetPolSourceObservationIssueWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceObservationIssueController polSourceObservationIssueController = new PolSourceObservationIssueController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceObservationIssueController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceObservationIssueController.DatabaseType);
PolSourceObservationIssue polSourceObservationIssueFirst = new PolSourceObservationIssue();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(new Query(), db, ContactID);
polSourceObservationIssueFirst = (from c in db.PolSourceObservationIssues select c).FirstOrDefault();
}
// ok with PolSourceObservationIssue info
IHttpActionResult jsonRet = polSourceObservationIssueController.GetPolSourceObservationIssueWithID(polSourceObservationIssueFirst.PolSourceObservationIssueID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceObservationIssue> Ret = jsonRet as OkNegotiatedContentResult <PolSourceObservationIssue>;
PolSourceObservationIssue polSourceObservationIssueRet = Ret.Content;
Assert.AreEqual(polSourceObservationIssueFirst.PolSourceObservationIssueID, polSourceObservationIssueRet.PolSourceObservationIssueID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = polSourceObservationIssueController.GetPolSourceObservationIssueWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceObservationIssue> polSourceObservationIssueRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceObservationIssue>;
Assert.IsNull(polSourceObservationIssueRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public IHttpActionResult Delete([FromBody] PolSourceObservationIssue polSourceObservationIssue, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!polSourceObservationIssueService.Delete(polSourceObservationIssue))
{
return(BadRequest(String.Join("|||", polSourceObservationIssue.ValidationResults)));
}
else
{
polSourceObservationIssue.ValidationResults = null;
return(Ok(polSourceObservationIssue));
}
}
}
public void GetPolSourceObservationIssueList_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
PolSourceObservationIssue polSourceObservationIssue = (from c in dbTestDB.PolSourceObservationIssues select c).FirstOrDefault();
Assert.IsNotNull(polSourceObservationIssue);
List <PolSourceObservationIssue> polSourceObservationIssueDirectQueryList = new List <PolSourceObservationIssue>();
polSourceObservationIssueDirectQueryList = (from c in dbTestDB.PolSourceObservationIssues select c).Take(200).ToList();
foreach (string extra in new List <string>()
{
null, "A", "B", "C", "D", "E"
})
{
polSourceObservationIssueService.Query.Extra = extra;
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceObservationIssue> polSourceObservationIssueList = new List <PolSourceObservationIssue>();
polSourceObservationIssueList = polSourceObservationIssueService.GetPolSourceObservationIssueList().ToList();
CheckPolSourceObservationIssueFields(polSourceObservationIssueList);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public void GetPolSourceObservationIssueList_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"
})
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(new Query()
{
Lang = culture.TwoLetterISOLanguageName
}, dbTestDB, ContactID);
polSourceObservationIssueService.Query = polSourceObservationIssueService.FillQuery(typeof(PolSourceObservationIssue), culture.TwoLetterISOLanguageName, 0, 10000, "", "", "PolSourceObservationIssueID,GT,2|PolSourceObservationIssueID,LT,5", extra);
List <PolSourceObservationIssue> polSourceObservationIssueDirectQueryList = new List <PolSourceObservationIssue>();
polSourceObservationIssueDirectQueryList = (from c in dbTestDB.PolSourceObservationIssues select c).Where(c => c.PolSourceObservationIssueID > 2 && c.PolSourceObservationIssueID < 5).ToList();
if (string.IsNullOrWhiteSpace(extra))
{
List <PolSourceObservationIssue> polSourceObservationIssueList = new List <PolSourceObservationIssue>();
polSourceObservationIssueList = polSourceObservationIssueService.GetPolSourceObservationIssueList().ToList();
CheckPolSourceObservationIssueFields(polSourceObservationIssueList);
Assert.AreEqual(polSourceObservationIssueDirectQueryList[0].PolSourceObservationIssueID, polSourceObservationIssueList[0].PolSourceObservationIssueID);
}
else
{
//Assert.AreEqual(true, false);
}
}
}
}
}
public bool CreateQCPolSourceNullAll()
{
lblStatus.Text = "Starting ... CreateSanitaryQC - CreateQCPolSourceNullAll";
Application.DoEvents();
if (Cancel)
{
return(false);
}
TVItemService tvItemServiceR = new TVItemService(LanguageEnum.en, user);
TVItemModel tvItemModelRoot = tvItemServiceR.GetRootTVItemModelDB();
if (!CheckModelOK <TVItemModel>(tvItemModelRoot))
{
return(false);
}
TVItemModel tvItemModelCanada = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, "Canada", TVTypeEnum.Country);
if (!CheckModelOK <TVItemModel>(tvItemModelCanada))
{
return(false);
}
TVItemModel tvItemModelQC = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "Québec", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelQC))
{
return(false);
}
List <TVItemModel> TVItemModelSubsectorList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelQC.TVItemID, TVTypeEnum.Subsector);
if (TVItemModelSubsectorList.Count == 0)
{
richTextBoxStatus.AppendText("Error: could not find TVItem Subsector for " + tvItemModelQC.TVText + "\r\n");
return(false);
}
List <MapInfo> mapInfoList = (from c in TVItemModelSubsectorList
from m in tvItemServiceR.db.MapInfos
where c.TVItemID == m.TVItemID &&
m.MapInfoDrawType == (int)MapInfoDrawTypeEnum.Polygon
select m).ToList();
List <TVItemSubsectorAndCoordCentroid> TVItemSubsectorAndCoordCentroidList = (from c in mapInfoList
let lat = (c.LatMax - c.LatMin) / 2 + c.LatMin
let lng = (c.LngMax - c.LngMin) / 2 + c.LngMin
select new TVItemSubsectorAndCoordCentroid
{
TVItemID = c.TVItemID,
Lat = (float)lat,
Lng = (float)lng,
}).ToList();
List <string> sectorList = new List <string>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
sectorList = (from s in dbQC.geo_pollution_p
select s.secteur).Distinct().ToList();
}
List <string> sectorOrderedList = (from c in sectorList
orderby c
select c).ToList();
Application.DoEvents();
List <PCCSM.geo_pollution_p> polQCList = new List <PCCSM.geo_pollution_p>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
polQCList = (from c in dbQC.geo_pollution_p
where c.secteur == null &&
c.id_geo_pollution_p != 0 &&
(c.x != null && c.y != null)
select c).ToList <PCCSM.geo_pollution_p>();
}
int TotalCount = polQCList.Count();
int Count = 0;
foreach (PCCSM.geo_pollution_p pqc in polQCList)
{
Count += 1;
lblStatus.Text = (Count * 100 / TotalCount).ToString() + "... CreateSanitaryQC for sector " + pqc.secteur;
Application.DoEvents();
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
PolSourceSiteService polSourceSiteService = new PolSourceSiteService(LanguageEnum.en, user);
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user);
PolSourceObservationService polSourceObservationService = new PolSourceObservationService(LanguageEnum.en, user);
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(LanguageEnum.en, user);
PolSourceSiteModel polSourceSiteModelNew = new PolSourceSiteModel();
string Code = tvItemService.CleanText(pqc.code.ToUpper());
List <PolSourceObsInfoEnum> polSourceObsInfoList = GetPolSourceType(Code.Trim(), "", "QC");
string ObservationInfo = (int)polSourceObsInfoList[0] + "," + (int)polSourceObsInfoList[1] + ",";
polSourceSiteModelNew.IsPointSource = true;
//if (pqc.status == "actif")
//{
// polSourceSiteModelNew.IsActive = true;
//}
//else
//{
// polSourceSiteModelNew.IsActive = false;
//}
polSourceSiteModelNew.InactiveReason = PolSourceInactiveReasonEnum.Error;
polSourceSiteModelNew.Oldsiteid = pqc.id_geo_pollution_p;
// Pollution Source Type
string PolSourceSiteTVText = tvItemService.CleanText(Code + " ".Substring(0, 6 - pqc.id_geo_pollution_p.ToString().Length) + pqc.id_geo_pollution_p.ToString());
List <MapInfoModel> mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)pqc.y, (float)pqc.x, TVTypeEnum.Subsector);
int TempTVItemID = 0;
if (mapInfoModelListSubsector.Count == 0)
{
float SmallestDistance = 100000000f;
foreach (TVItemSubsectorAndCoordCentroid tvItemSubsectorAndCoordCentroid in TVItemSubsectorAndCoordCentroidList)
{
float TempDistance = (float)mapInfoService.CalculateDistance((double)pqc.y, (double)pqc.x, (double)tvItemSubsectorAndCoordCentroid.Lat, (double)tvItemSubsectorAndCoordCentroid.Lng, mapInfoService.R);
if (SmallestDistance > TempDistance)
{
TempTVItemID = tvItemSubsectorAndCoordCentroid.TVItemID;
SmallestDistance = TempDistance;
}
}
}
else
{
TempTVItemID = mapInfoModelListSubsector[0].TVItemID;
}
if (TempTVItemID == 0)
{
richTextBoxStatus.AppendText("TempTVItemID equal 0");
return(false);
}
TVItemModel tvItemModelPolSourceSite = tvItemService.GetChildTVItemModelWithTVItemIDAndTVTextStartWithAndTVTypeDB(TempTVItemID, PolSourceSiteTVText, TVTypeEnum.PolSourceSite);
if (!CheckModelOK <TVItemModel>(tvItemModelPolSourceSite))
{
tvItemModelPolSourceSite = tvItemService.PostCreateTVItem(TempTVItemID, PolSourceSiteTVText, PolSourceSiteTVText, TVTypeEnum.PolSourceSite);
if (!CheckModelOK <TVItemModel>(tvItemModelPolSourceSite))
{
return(false);
}
}
;
List <Coord> coordList = new List <Coord>()
{
new Coord()
{
Lat = (float)pqc.y,
Lng = (float)pqc.x,
}
};
MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList, MapInfoDrawTypeEnum.Point, TVTypeEnum.PolSourceSite, tvItemModelPolSourceSite.TVItemID);
if (!CheckModelOK <MapInfoModel>(mapInfoModelRet))
{
return(false);
}
polSourceSiteModelNew.PolSourceSiteTVItemID = tvItemModelPolSourceSite.TVItemID;
polSourceSiteModelNew.PolSourceSiteTVText = PolSourceSiteTVText;
PolSourceSiteModel polSourceSiteModelRet = polSourceSiteService.GetPolSourceSiteModelWithPolSourceSiteTVItemIDDB(tvItemModelPolSourceSite.TVItemID);
if (!string.IsNullOrWhiteSpace(polSourceSiteModelRet.Error))
{
polSourceSiteModelRet = polSourceSiteService.PostAddPolSourceSiteDB(polSourceSiteModelNew);
if (!CheckModelOK <PolSourceSiteModel>(polSourceSiteModelRet))
{
return(false);
}
}
string TVTextObservation = tvItemService.CleanText(string.IsNullOrEmpty(pqc.description) ? "" : pqc.description);;
PolSourceObservationModel polSourceObservationModelNew = new PolSourceObservationModel();
if (pqc.date_observation == null)
{
polSourceObservationModelNew.ObservationDate_Local = new DateTime(1970, 1, 1);
}
else
{
polSourceObservationModelNew.ObservationDate_Local = (DateTime)(pqc.date_observation.Value).AddHours(1);
}
string Observateur = "";
if (pqc.observateur != null)
{
if (pqc.observateur.Length > 98)
{
Observateur = pqc.observateur.Substring(0, 60);
}
else
{
Observateur = pqc.observateur;
}
}
string TVText = "Inspector " + Observateur;
TVText = (TVText.Length > 50 ? TVText.Substring(0, 50) : TVText);
TVItemModel tvItemModelContact = tvItemService.GetChildTVItemModelWithTVItemIDAndTVTextStartWithAndTVTypeDB(tvItemModelRoot.TVItemID, TVText, TVTypeEnum.Contact);
if (!string.IsNullOrWhiteSpace(tvItemModelContact.Error))
{
tvItemModelContact = tvItemService.PostCreateTVItem(tvItemModelRoot.TVItemID, TVText, TVText, TVTypeEnum.Contact);
if (!CheckModelOK <TVItemModel>(tvItemModelContact))
{
return(false);
}
}
polSourceObservationModelNew.ContactTVItemID = tvItemModelContact.TVItemID;
polSourceObservationModelNew.Observation_ToBeDeleted = TVTextObservation;
polSourceObservationModelNew.PolSourceSiteID = polSourceSiteModelRet.PolSourceSiteID;
PolSourceObservationModel polSourceObservationModelRet = polSourceObservationService.GetPolSourceObservationModelExistDB(polSourceObservationModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelRet.Error))
{
PolSourceObservationModel polSourceObservationModel = polSourceObservationService.PostAddPolSourceObservationDB(polSourceObservationModelNew);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModel))
{
return(false);
}
}
PolSourceObservationIssueModel polSourceObservationIssueModelNew = new PolSourceObservationIssueModel()
{
PolSourceObservationID = polSourceObservationModelNew.PolSourceObservationID,
ObservationInfo = ObservationInfo,
PolSourceObsInfoList = polSourceObsInfoList,
Ordinal = 0,
};
PolSourceObservationIssueModel polSourceObservationIssueModelRet = polSourceObservationIssueService.GetPolSourceObservationIssueModelExistDB(polSourceObservationIssueModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationIssueModelRet.Error))
{
polSourceObservationIssueModelRet = polSourceObservationIssueService.PostAddPolSourceObservationIssueDB(polSourceObservationIssueModelNew);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet))
{
return(false);
}
}
// do historic PolSourceObservation
List <PCCSM.db_histo_operation> histoPolSourceList = new List <PCCSM.db_histo_operation>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
histoPolSourceList = (from c in dbQC.geo_pollution_p
from h in dbQC.db_histo_operation
where c.id_geo_pollution_p == h.id_geo_pollution_p &&
c.id_geo_pollution_p == pqc.id_geo_pollution_p
select h).ToList();
}
foreach (PCCSM.db_histo_operation hist in histoPolSourceList)
{
Application.DoEvents();
PolSourceObservationModel polSourceObservationModelNew2 = new PolSourceObservationModel();
if (hist.date_operation == null)
{
polSourceObservationModelNew2.ObservationDate_Local = new DateTime(1970, 1, 1);
}
else
{
polSourceObservationModelNew2.ObservationDate_Local = (DateTime)hist.date_operation;
}
if (hist.auteur != null)
{
if (hist.auteur.Length > 98)
{
Observateur = hist.auteur.Substring(0, 60);
}
else
{
Observateur = hist.auteur;
}
}
TVText = "Inspector " + Observateur;
TVText = (TVText.Length > 50 ? TVText.Substring(0, 50) : TVText);
TVItemModel tvItemModelContact2 = tvItemService.GetChildTVItemModelWithTVItemIDAndTVTextStartWithAndTVTypeDB(tvItemModelRoot.TVItemID, TVText, TVTypeEnum.Contact);
if (!string.IsNullOrWhiteSpace(tvItemModelContact.Error))
{
tvItemModelContact = tvItemService.PostCreateTVItem(tvItemModelRoot.TVItemID, TVText, TVText, TVTypeEnum.Contact);
if (!CheckModelOK <TVItemModel>(tvItemModelContact))
{
return(false);
}
}
polSourceObservationModelNew2.ContactTVItemID = tvItemModelContact2.TVItemID;
polSourceObservationModelNew2.Observation_ToBeDeleted = TVTextObservation;
polSourceObservationModelNew2.PolSourceSiteID = polSourceSiteModelRet.PolSourceSiteID;
PolSourceObservationModel polSourceObservationModelRet2 = polSourceObservationService.GetPolSourceObservationModelExistDB(polSourceObservationModelNew2);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelRet2.Error))
{
polSourceObservationModelRet2 = polSourceObservationService.PostAddPolSourceObservationDB(polSourceObservationModelNew2);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet2))
{
return(false);
}
}
PolSourceObservationIssueModel polSourceObservationIssueModelNew2 = new PolSourceObservationIssueModel()
{
PolSourceObservationID = polSourceObservationModelNew2.PolSourceObservationID,
ObservationInfo = ObservationInfo,
PolSourceObsInfoList = polSourceObsInfoList,
Ordinal = 0,
};
PolSourceObservationIssueModel polSourceObservationIssueModelRet2 = polSourceObservationIssueService.GetPolSourceObservationIssueModelExistDB(polSourceObservationIssueModelNew2);
if (!string.IsNullOrWhiteSpace(polSourceObservationIssueModelRet2.Error))
{
polSourceObservationIssueModelRet2 = polSourceObservationIssueService.PostAddPolSourceObservationIssueDB(polSourceObservationIssueModelNew2);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet2))
{
return(false);
}
}
}
}
return(true);
}
public bool CreateQCPolSourceAll()
{
if (Cancel)
{
return(false);
}
lblStatus.Text = "Starting ... CreateSanitaryQC - CreateQCPolSourceAll";
Application.DoEvents();
TVItemService tvItemServiceR = new TVItemService(LanguageEnum.en, user);
TVItemModel tvItemModelRoot = tvItemServiceR.GetRootTVItemModelDB();
if (!CheckModelOK <TVItemModel>(tvItemModelRoot))
{
return(false);
}
TVItemModel tvItemModelCanada = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, "Canada", TVTypeEnum.Country);
if (!CheckModelOK <TVItemModel>(tvItemModelCanada))
{
return(false);
}
TVItemModel tvItemModelQC = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "Québec", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelQC))
{
return(false);
}
List <TVItemModel> TVItemModelSubsectorList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelQC.TVItemID, TVTypeEnum.Subsector);
if (TVItemModelSubsectorList.Count == 0)
{
richTextBoxStatus.AppendText("Error: could not find TVItem Subsector for " + tvItemModelQC.TVText + "\r\n");
return(false);
}
List <string> NoSecList = new List <string>()
{
"M", "G-00"
};
List <TempData.QCSecteurMPol> qcSecteurMPol = new List <TempData.QCSecteurMPol>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
qcSecteurMPol = (from c in dbDT.QCSecteurMPols
select c).ToList <TempData.QCSecteurMPol>();
}
List <Obs> obsTypeList = new List <Obs>();
List <string> sectorList = new List <string>();
List <TempData.QCSubsectorAssociation> qcsubsectorAssociationList = new List <TempData.QCSubsectorAssociation>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
qcsubsectorAssociationList = (from c in dbDT.QCSubsectorAssociations
select c).ToList <TempData.QCSubsectorAssociation>();
}
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
sectorList = (from s in dbQC.geo_pollution_p
select s.secteur).Distinct().ToList();
}
List <string> sectorOrderedList = (from c in sectorList
orderby c
select c).ToList();
int StartQCCreateSanitarysQC = int.Parse(textBoxQCCreateSanitaryQC.Text);
int TotalCount = sectorOrderedList.Count();
int Count = 0;
foreach (string sec in sectorOrderedList)
{
Count += 1;
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
PolSourceSiteService polSourceSiteService = new PolSourceSiteService(LanguageEnum.en, user);
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user);
PolSourceObservationService polSourceObservationService = new PolSourceObservationService(LanguageEnum.en, user);
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(LanguageEnum.en, user);
lblStatus.Text = (Count * 100 / TotalCount).ToString() + " ... CreateSanitaryQC for sector " + sec;
lblStatus2.Text = Count + " of " + TotalCount;
Application.DoEvents();
textBoxQCCreateSanitaryQC.Text = Count.ToString();
if (StartQCCreateSanitarysQC > Count)
{
continue;
}
if (sec != null)
{
Application.DoEvents();
TVItemModel tvItemModelSubsector = new TVItemModel();
if (sec.StartsWith("M") || sec.StartsWith("G-00"))
{
}
else
{
TempData.QCSubsectorAssociation qcsubAss = (from c in qcsubsectorAssociationList
where c.QCSectorText == sec
select c).FirstOrDefault <TempData.QCSubsectorAssociation>();
tvItemModelSubsector = tvItemService.GetChildTVItemModelWithTVItemIDAndTVTextStartWithAndTVTypeDB(tvItemModelQC.TVItemID, qcsubAss.SubsectorText, TVTypeEnum.Subsector);
if (!CheckModelOK <TVItemModel>(tvItemModelSubsector))
{
return(false);
}
}
List <PCCSM.geo_pollution_p> polQCList = new List <PCCSM.geo_pollution_p>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
polQCList = (from c in dbQC.geo_pollution_p
where c.secteur == sec &&
c.id_geo_pollution_p != 0 &&
(c.x != null && c.y != null)
//&& c.ex.exlure_importation == false
select c).ToList <PCCSM.geo_pollution_p>();
}
int countPol = 0;
int totalCountPol = polQCList.Count;
foreach (PCCSM.geo_pollution_p pqc in polQCList)
{
if (Cancel)
{
return(false);
}
countPol += 1;
lblStatus2.Text = "Doing " + countPol + " of " + totalCountPol;
Application.DoEvents();
PolSourceSiteModel polSourceSiteModelNew = new PolSourceSiteModel();
string Code = tvItemService.CleanText(pqc.code.ToUpper());
List <PolSourceObsInfoEnum> polSourceObsInfoList = GetPolSourceType(Code.Trim(), "--", "QC");
string ObservationInfo = (int)polSourceObsInfoList[0] + "," + (int)polSourceObsInfoList[1] + ",";
polSourceSiteModelNew.IsPointSource = true;
//if (pqc.status == "actif")
//{
// polSourceSiteModelNew.IsActive = true;
//}
//else
//{
// polSourceSiteModelNew.IsActive = false;
//}
polSourceSiteModelNew.Oldsiteid = pqc.id_geo_pollution_p;
string SectText = (from c in qcSecteurMPol
where c.geo_pollution_id == pqc.id_geo_pollution_p
select c.Subsector).FirstOrDefault <string>();
if (string.IsNullOrWhiteSpace(SectText))
{
List <MapInfoModel> mapInfoModelList = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)pqc.y, (float)pqc.x, TVTypeEnum.Subsector);
foreach (MapInfoModel mapInfoModel in mapInfoModelList)
{
List <MapInfoPointModel> mapInfoPointModelList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithMapInfoIDDB(mapInfoModel.MapInfoID);
List <Coord> coordList2 = new List <Coord>();
foreach (MapInfoPointModel mapInfoPointModel in mapInfoPointModelList)
{
coordList2.Add(new Coord()
{
Lat = (float)mapInfoPointModel.Lat, Lng = (float)mapInfoPointModel.Lng, Ordinal = mapInfoPointModel.Ordinal
});
}
if (mapInfoService.CoordInPolygon(coordList2, new Coord()
{
Lat = (float)pqc.y, Lng = (float)pqc.x, Ordinal = 0
}))
{
TVItemModel tvItemModelSS = tvItemService.GetTVItemModelWithTVItemIDDB(mapInfoModel.TVItemID);
SectText = tvItemModelSS.TVText.Substring(0, tvItemModelSS.TVText.IndexOf(" ")).Trim();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
TempData.QCSecteurMPol qcSecteurMPolExist = (from c in dbDT.QCSecteurMPols
where c.Subsector == SectText &&
c.geo_pollution_id == pqc.id_geo_pollution_p
select c).FirstOrDefault();
if (qcSecteurMPolExist == null)
{
TempData.QCSecteurMPol qcsmpol = new TempData.QCSecteurMPol()
{
geo_pollution_id = pqc.id_geo_pollution_p,
Subsector = SectText,
};
dbDT.QCSecteurMPols.Add(qcsmpol);
try
{
dbDT.SaveChanges();
}
catch (Exception ex)
{
richTextBoxStatus.AppendText("Error saving new TempData.QCSecteurMPol [" + ex.Message + "]");
return(false);
}
}
}
break;
}
}
if (string.IsNullOrWhiteSpace(SectText))
{
int MapInfoID = 0;
float MinDist = 10000000f;
foreach (TVItemModel tvItemModel in TVItemModelSubsectorList)
{
List <MapInfoPointModel> mapInfoPointModelList = mapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(tvItemModel.TVItemID, TVTypeEnum.Subsector, MapInfoDrawTypeEnum.Point);
float tempDist = (float)mapInfoService.CalculateDistance(mapInfoPointModelList[0].Lat, mapInfoPointModelList[0].Lng, (double)pqc.y, (double)pqc.x, mapInfoService.R);
if (tempDist < MinDist)
{
MapInfoID = mapInfoPointModelList[0].MapInfoID;
MinDist = tempDist;
}
}
MapInfoModel mapInfoModel = mapInfoService.GetMapInfoModelWithMapInfoIDDB(MapInfoID);
if (!string.IsNullOrWhiteSpace(mapInfoModel.Error))
{
richTextBoxStatus.AppendText("Error [" + mapInfoModel.Error + "]");
return(false);
}
TVItemModel tvItemModelSS = tvItemService.GetTVItemModelWithTVItemIDDB(mapInfoModel.TVItemID);
SectText = tvItemModelSS.TVText.Substring(0, tvItemModelSS.TVText.IndexOf(" ")).Trim();
}
}
if (string.IsNullOrWhiteSpace(SectText))
{
richTextBoxStatus.AppendText(pqc.y + " " + pqc.x + " " + pqc.id_geo_pollution_p + "\r\n");
continue;
}
tvItemModelSubsector = tvItemService.GetChildTVItemModelWithTVItemIDAndTVTextStartWithAndTVTypeDB(tvItemModelQC.TVItemID, SectText, TVTypeEnum.Subsector);
if (!CheckModelOK <TVItemModel>(tvItemModelSubsector))
{
return(false);
}
// doing EN TVText
string PolSourceSiteTVTextEN = _BaseEnumService.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[0]);
if (polSourceObsInfoList.Count > 1)
{
if (polSourceObsInfoList[1] != PolSourceObsInfoEnum.Error)
{
PolSourceSiteTVTextEN += " - " + _BaseEnumService.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[1]);
}
}
PolSourceSiteTVTextEN = tvItemService.CleanText(PolSourceSiteTVTextEN + " - " + " ".Substring(0, 6 - pqc.id_geo_pollution_p.ToString().Length) + pqc.id_geo_pollution_p.ToString());
Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("fr-CA");
// Doing FR TVText
PolSourceObservationService polSourceObservationService2 = new PolSourceObservationService(LanguageEnum.fr, user);
string PolSourceSiteTVTextFR = _BaseEnumService.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[0]);
if (polSourceObsInfoList.Count > 1)
{
if (polSourceObsInfoList[1] != PolSourceObsInfoEnum.Error)
{
PolSourceSiteTVTextFR += " - " + _BaseEnumService.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[1]);
}
}
PolSourceSiteTVTextFR = tvItemService.CleanText(PolSourceSiteTVTextFR + " - " + " ".Substring(0, 6 - pqc.id_geo_pollution_p.ToString().Length) + pqc.id_geo_pollution_p.ToString());
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-CA");
TVItemModel tvItemModelPolSourceSite = tvItemService.PostCreateTVItem(tvItemModelSubsector.TVItemID, PolSourceSiteTVTextEN, PolSourceSiteTVTextFR, TVTypeEnum.PolSourceSite);
if (!CheckModelOK <TVItemModel>(tvItemModelPolSourceSite))
{
return(false);
}
List <Coord> coordList = new List <Coord>()
{
new Coord()
{
Lat = (float)pqc.y,
Lng = (float)pqc.x,
}
};
MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList, MapInfoDrawTypeEnum.Point, TVTypeEnum.PolSourceSite, tvItemModelPolSourceSite.TVItemID);
if (!CheckModelOK <MapInfoModel>(mapInfoModelRet))
{
return(false);
}
polSourceSiteModelNew.PolSourceSiteTVItemID = tvItemModelPolSourceSite.TVItemID;
polSourceSiteModelNew.PolSourceSiteTVText = PolSourceSiteTVTextEN;
PolSourceSiteModel polSourceSiteModelRet = polSourceSiteService.GetPolSourceSiteModelWithPolSourceSiteTVItemIDDB(tvItemModelPolSourceSite.TVItemID);
if (!string.IsNullOrWhiteSpace(polSourceSiteModelRet.Error))
{
polSourceSiteModelRet = polSourceSiteService.PostAddPolSourceSiteDB(polSourceSiteModelNew);
if (!CheckModelOK <PolSourceSiteModel>(polSourceSiteModelRet))
{
return(false);
}
}
string TextObs = tvItemService.CleanText(string.IsNullOrEmpty(pqc.description) ? "" : pqc.description);
PolSourceObservationModel polSourceObservationModelNew = new PolSourceObservationModel();
if (pqc.date_observation == null)
{
polSourceObservationModelNew.ObservationDate_Local = new DateTime(2050, 1, 1);
}
else
{
polSourceObservationModelNew.ObservationDate_Local = (DateTime)(pqc.date_observation.Value).AddHours(1);
}
string observateur = "unknown";
if (pqc.observateur != null)
{
if (pqc.observateur.Length > 98)
{
observateur = pqc.observateur.Substring(0, 60);
}
else
{
observateur = pqc.observateur;
}
}
string observation = "(empty)";
if (pqc.description != null)
{
observation = Code.ToString().ToUpper() + " - " + pqc.description;
}
string TVTextInspectorEN = "Inspector " + observateur + " - (QC)";
string TVTextInspectorFR = "Inspecteur " + observateur + " - (QC)";
TVItemModel tvItemModelContact = tvItemService.GetChildTVItemModelWithTVItemIDAndTVTextStartWithAndTVTypeDB(tvItemModelRoot.TVItemID, TVTextInspectorEN, TVTypeEnum.Contact);
if (!string.IsNullOrWhiteSpace(tvItemModelContact.Error))
{
tvItemModelContact = tvItemService.PostCreateTVItem(tvItemModelRoot.TVItemID, TVTextInspectorEN, TVTextInspectorFR, TVTypeEnum.Contact);
if (!CheckModelOK <TVItemModel>(tvItemModelContact))
{
return(false);
}
}
polSourceObservationModelNew.ContactTVItemID = tvItemModelContact.TVItemID;
polSourceObservationModelNew.PolSourceSiteID = polSourceSiteModelRet.PolSourceSiteID;
polSourceObservationModelNew.Observation_ToBeDeleted = observation;
PolSourceObservationModel polSourceObservationModelRet = polSourceObservationService.GetPolSourceObservationModelExistDB(polSourceObservationModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelRet.Error))
{
polSourceObservationModelRet = polSourceObservationService.PostAddPolSourceObservationDB(polSourceObservationModelNew);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet))
{
return(false);
}
}
PolSourceObservationIssueModel polSourceObservationIssueModelNew = new PolSourceObservationIssueModel()
{
PolSourceObservationID = polSourceObservationModelNew.PolSourceObservationID,
ObservationInfo = ObservationInfo,
PolSourceObsInfoList = polSourceObsInfoList,
Ordinal = 0,
};
PolSourceObservationIssueModel polSourceObservationIssueModelRet = polSourceObservationIssueService.GetPolSourceObservationIssueModelExistDB(polSourceObservationIssueModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationIssueModelRet.Error))
{
polSourceObservationIssueModelRet = polSourceObservationIssueService.PostAddPolSourceObservationIssueDB(polSourceObservationIssueModelNew);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet))
{
return(false);
}
}
// do historic PolSourceObservation
List <PCCSM.db_histo_operation> histoPolSourceList = new List <PCCSM.db_histo_operation>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
histoPolSourceList = (from c in dbQC.geo_pollution_p
from h in dbQC.db_histo_operation
where c.id_geo_pollution_p == h.id_geo_pollution_p &&
c.id_geo_pollution_p == pqc.id_geo_pollution_p
select h).ToList();
}
foreach (PCCSM.db_histo_operation hist in histoPolSourceList)
{
Application.DoEvents();
PolSourceObservationModel polSourceObservationModelNew2 = new PolSourceObservationModel();
if (hist.date_operation == null)
{
polSourceObservationModelNew2.ObservationDate_Local = new DateTime(1900, 1, 1);
}
else
{
polSourceObservationModelNew2.ObservationDate_Local = (DateTime)hist.date_operation;
}
observateur = "unknown";
if (hist.auteur != null)
{
if (hist.auteur.Length > 98)
{
observateur = hist.auteur.Substring(0, 60);
}
else
{
observateur = hist.auteur;
}
}
observation = "(vide)";
if (hist.description != null)
{
observation = hist.description;
}
TVTextInspectorEN = "Inspector " + observateur + " - (QC)";
TVTextInspectorFR = "Inspecteur " + observateur + " - (QC)";
tvItemModelContact = tvItemService.GetChildTVItemModelWithTVItemIDAndTVTextStartWithAndTVTypeDB(tvItemModelRoot.TVItemID, TVTextInspectorEN, TVTypeEnum.Contact);
if (!string.IsNullOrWhiteSpace(tvItemModelContact.Error))
{
tvItemModelContact = tvItemService.PostCreateTVItem(tvItemModelRoot.TVItemID, TVTextInspectorEN, TVTextInspectorFR, TVTypeEnum.Contact);
if (!CheckModelOK <TVItemModel>(tvItemModelContact))
{
return(false);
}
}
polSourceObservationModelNew2.ContactTVItemID = tvItemModelContact.TVItemID;
polSourceObservationModelNew2.PolSourceSiteID = polSourceSiteModelRet.PolSourceSiteID;
polSourceObservationModelNew2.Observation_ToBeDeleted = observation;
PolSourceObservationModel polSourceObservationModelRet2 = polSourceObservationService.GetPolSourceObservationModelExistDB(polSourceObservationModelNew2);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelRet2.Error))
{
polSourceObservationModelRet2 = polSourceObservationService.PostAddPolSourceObservationDB(polSourceObservationModelNew2);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet2))
{
return(false);
}
}
PolSourceObservationIssueModel polSourceObservationIssueModelNew2 = new PolSourceObservationIssueModel()
{
PolSourceObservationID = polSourceObservationModelNew2.PolSourceObservationID,
ObservationInfo = ObservationInfo,
PolSourceObsInfoList = polSourceObsInfoList,
Ordinal = 0,
};
PolSourceObservationIssueModel polSourceObservationIssueModelRet2 = polSourceObservationIssueService.GetPolSourceObservationIssueModelExistDB(polSourceObservationIssueModelNew2);
if (!string.IsNullOrWhiteSpace(polSourceObservationIssueModelRet2.Error))
{
polSourceObservationIssueModelRet2 = polSourceObservationIssueService.PostAddPolSourceObservationIssueDB(polSourceObservationIssueModelNew2);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet2))
{
return(false);
}
}
}
}
}
}
return(true);
}
public IHttpActionResult GetPolSourceObservationIssueList([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))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(new Query()
{
Lang = lang
}, db, ContactID);
if (extra == "A") // QueryString contains [extra=A]
{
polSourceObservationIssueService.Query = polSourceObservationIssueService.FillQuery(typeof(PolSourceObservationIssueExtraA), lang, skip, take, asc, desc, where, extra);
if (polSourceObservationIssueService.Query.HasErrors)
{
return(Ok(new List <PolSourceObservationIssueExtraA>()
{
new PolSourceObservationIssueExtraA()
{
HasErrors = polSourceObservationIssueService.Query.HasErrors,
ValidationResults = polSourceObservationIssueService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(polSourceObservationIssueService.GetPolSourceObservationIssueExtraAList().ToList()));
}
}
else if (extra == "B") // QueryString contains [extra=B]
{
polSourceObservationIssueService.Query = polSourceObservationIssueService.FillQuery(typeof(PolSourceObservationIssueExtraB), lang, skip, take, asc, desc, where, extra);
if (polSourceObservationIssueService.Query.HasErrors)
{
return(Ok(new List <PolSourceObservationIssueExtraB>()
{
new PolSourceObservationIssueExtraB()
{
HasErrors = polSourceObservationIssueService.Query.HasErrors,
ValidationResults = polSourceObservationIssueService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(polSourceObservationIssueService.GetPolSourceObservationIssueExtraBList().ToList()));
}
}
else // QueryString has no parameter [extra] or extra is empty
{
polSourceObservationIssueService.Query = polSourceObservationIssueService.FillQuery(typeof(PolSourceObservationIssue), lang, skip, take, asc, desc, where, extra);
if (polSourceObservationIssueService.Query.HasErrors)
{
return(Ok(new List <PolSourceObservationIssue>()
{
new PolSourceObservationIssue()
{
HasErrors = polSourceObservationIssueService.Query.HasErrors,
ValidationResults = polSourceObservationIssueService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(polSourceObservationIssueService.GetPolSourceObservationIssueList().ToList()));
}
}
}
}
public void PolSourceObservationIssue_Controller_GetPolSourceObservationIssueList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceObservationIssueController polSourceObservationIssueController = new PolSourceObservationIssueController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceObservationIssueController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceObservationIssueController.DatabaseType);
PolSourceObservationIssue polSourceObservationIssueFirst = new PolSourceObservationIssue();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(query, db, ContactID);
polSourceObservationIssueFirst = (from c in db.PolSourceObservationIssues select c).FirstOrDefault();
count = (from c in db.PolSourceObservationIssues select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with PolSourceObservationIssue info
IHttpActionResult jsonRet = polSourceObservationIssueController.GetPolSourceObservationIssueList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <PolSourceObservationIssue> > ret = jsonRet as OkNegotiatedContentResult <List <PolSourceObservationIssue> >;
Assert.AreEqual(polSourceObservationIssueFirst.PolSourceObservationIssueID, ret.Content[0].PolSourceObservationIssueID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <PolSourceObservationIssue> polSourceObservationIssueList = new List <PolSourceObservationIssue>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(query, db, ContactID);
polSourceObservationIssueList = (from c in db.PolSourceObservationIssues select c).OrderBy(c => c.PolSourceObservationIssueID).Skip(0).Take(2).ToList();
count = (from c in db.PolSourceObservationIssues select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with PolSourceObservationIssue info
jsonRet = polSourceObservationIssueController.GetPolSourceObservationIssueList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <PolSourceObservationIssue> >;
Assert.AreEqual(polSourceObservationIssueList[0].PolSourceObservationIssueID, ret.Content[0].PolSourceObservationIssueID);
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 PolSourceObservationIssue info
IHttpActionResult jsonRet2 = polSourceObservationIssueController.GetPolSourceObservationIssueList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <PolSourceObservationIssue> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <PolSourceObservationIssue> >;
Assert.AreEqual(polSourceObservationIssueList[1].PolSourceObservationIssueID, ret2.Content[0].PolSourceObservationIssueID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void PolSourceObservationIssue_Properties_Test()
{
foreach (CultureInfo culture in AllowableCulture)
{
ChangeCulture(culture);
using (CSSPDBContext dbTestDB = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(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 = polSourceObservationIssueService.GetPolSourceObservationIssueList().Count();
PolSourceObservationIssue polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
// -------------------------------
// -------------------------------
// Properties testing
// -------------------------------
// -------------------------------
// -----------------------------------
// [Key]
// Is NOT Nullable
// polSourceObservationIssue.PolSourceObservationIssueID (Int32)
// -----------------------------------
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.PolSourceObservationIssueID = 0;
polSourceObservationIssueService.Update(polSourceObservationIssue);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "PolSourceObservationIssueID"), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.PolSourceObservationIssueID = 10000000;
polSourceObservationIssueService.Update(polSourceObservationIssue);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "PolSourceObservationIssue", "PolSourceObservationIssueID", polSourceObservationIssue.PolSourceObservationIssueID.ToString()), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "PolSourceObservation", ExistPlurial = "s", ExistFieldID = "PolSourceObservationID", AllowableTVtypeList = )]
// polSourceObservationIssue.PolSourceObservationID (Int32)
// -----------------------------------
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.PolSourceObservationID = 0;
polSourceObservationIssueService.Add(polSourceObservationIssue);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "PolSourceObservation", "PolSourceObservationID", polSourceObservationIssue.PolSourceObservationID.ToString()), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [StringLength(250))]
// polSourceObservationIssue.ObservationInfo (String)
// -----------------------------------
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("ObservationInfo");
Assert.AreEqual(false, polSourceObservationIssueService.Add(polSourceObservationIssue));
Assert.AreEqual(1, polSourceObservationIssue.ValidationResults.Count());
Assert.IsTrue(polSourceObservationIssue.ValidationResults.Where(c => c.ErrorMessage == string.Format(CSSPServicesRes._IsRequired, "ObservationInfo")).Any());
Assert.AreEqual(null, polSourceObservationIssue.ObservationInfo);
Assert.AreEqual(count, polSourceObservationIssueService.GetPolSourceObservationIssueList().Count());
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.ObservationInfo = GetRandomString("", 251);
Assert.AreEqual(false, polSourceObservationIssueService.Add(polSourceObservationIssue));
Assert.AreEqual(string.Format(CSSPServicesRes._MaxLengthIs_, "ObservationInfo", "250"), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, polSourceObservationIssueService.GetPolSourceObservationIssueList().Count());
// -----------------------------------
// Is NOT Nullable
// [Range(0, 1000)]
// polSourceObservationIssue.Ordinal (Int32)
// -----------------------------------
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.Ordinal = -1;
Assert.AreEqual(false, polSourceObservationIssueService.Add(polSourceObservationIssue));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Ordinal", "0", "1000"), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, polSourceObservationIssueService.GetPolSourceObservationIssueList().Count());
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.Ordinal = 1001;
Assert.AreEqual(false, polSourceObservationIssueService.Add(polSourceObservationIssue));
Assert.AreEqual(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Ordinal", "0", "1000"), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
Assert.AreEqual(count, polSourceObservationIssueService.GetPolSourceObservationIssueList().Count());
// -----------------------------------
// Is Nullable
// polSourceObservationIssue.ExtraComment (String)
// -----------------------------------
// -----------------------------------
// Is NOT Nullable
// [CSSPAfter(Year = 1980)]
// polSourceObservationIssue.LastUpdateDate_UTC (DateTime)
// -----------------------------------
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.LastUpdateDate_UTC = new DateTime();
polSourceObservationIssueService.Add(polSourceObservationIssue);
Assert.AreEqual(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.LastUpdateDate_UTC = new DateTime(1979, 1, 1);
polSourceObservationIssueService.Add(polSourceObservationIssue);
Assert.AreEqual(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [CSSPExist(ExistTypeName = "TVItem", ExistPlurial = "s", ExistFieldID = "TVItemID", AllowableTVtypeList = Contact)]
// polSourceObservationIssue.LastUpdateContactTVItemID (Int32)
// -----------------------------------
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.LastUpdateContactTVItemID = 0;
polSourceObservationIssueService.Add(polSourceObservationIssue);
Assert.AreEqual(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", polSourceObservationIssue.LastUpdateContactTVItemID.ToString()), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
polSourceObservationIssue = null;
polSourceObservationIssue = GetFilledRandomPolSourceObservationIssue("");
polSourceObservationIssue.LastUpdateContactTVItemID = 1;
polSourceObservationIssueService.Add(polSourceObservationIssue);
Assert.AreEqual(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), polSourceObservationIssue.ValidationResults.FirstOrDefault().ErrorMessage);
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// polSourceObservationIssue.HasErrors (Boolean)
// -----------------------------------
// No testing requied
// -----------------------------------
// Is NOT Nullable
// [NotMapped]
// polSourceObservationIssue.ValidationResults (IEnumerable`1)
// -----------------------------------
// No testing requied
}
}
}
public bool CreateSanitaryBC()
{
lblStatus.Text = "Starting ... CreateSanitaryBC";
Application.DoEvents();
if (Cancel)
{
return(false);
}
TVItemService tvItemServiceR = new TVItemService(LanguageEnum.en, user);
BaseEnumService _BaseEnumSerice = new BaseEnumService(LanguageEnum.en);
TVItemModel tvItemModelRoot = tvItemServiceR.GetRootTVItemModelDB();
if (!CheckModelOK <TVItemModel>(tvItemModelRoot))
{
return(false);
}
TVItemModel tvItemModelCanada = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, "Canada", TVTypeEnum.Country);
if (!CheckModelOK <TVItemModel>(tvItemModelCanada))
{
return(false);
}
TVItemModel tvItemModelBC = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "British Columbia", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelBC))
{
return(false);
}
List <TVItemModel> TVItemModelSubsectorList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelBC.TVItemID, TVTypeEnum.Subsector);
if (TVItemModelSubsectorList.Count == 0)
{
richTextBoxStatus.AppendText("Error: could not find TVItem Subsector for " + tvItemModelBC.TVText + "\r\n");
return(false);
}
List <TempData.BCPolSource> bcPolSourceList = new List <TempData.BCPolSource>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
bcPolSourceList = (from c in dbDT.BCPolSources
orderby c.BCPolSourceID
select c).ToList <TempData.BCPolSource>();
}
int StartBCCreateSanitarysBC = int.Parse(textBoxBCCreateSanitaryBC.Text);
int TotalCount = bcPolSourceList.Count();
int Count = 0;
foreach (TempData.BCPolSource bcps in bcPolSourceList)
{
if (Cancel)
{
return(false);
}
Count += 1;
lblStatus.Text = Count + " of " + TotalCount + " ... LoadSanitary BC";
Application.DoEvents();
textBoxBCCreateSanitaryBC.Text = Count.ToString();
if (StartBCCreateSanitarysBC > Count)
{
continue;
}
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
PolSourceObservationService polSourceObservationService = new PolSourceObservationService(LanguageEnum.en, user);
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(LanguageEnum.en, user);
PolSourceSiteService polSourceSiteService = new PolSourceSiteService(LanguageEnum.en, user);
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user);
PolSourceSiteModel polSourceSiteModelNew = new PolSourceSiteModel();
polSourceSiteModelNew.Oldsiteid = int.Parse(bcps.Key_.Substring(2));
string LCODE = tvItemService.CleanText(bcps.LCode);
string ICODE = tvItemService.CleanText(bcps.ICode);
if (LCODE.Trim() == "")
{
LCODE = "--";
}
if (ICODE.Trim() == "")
{
ICODE = "--";
}
List <PolSourceObsInfoEnum> polSourceObsInfoList = GetPolSourceType(LCODE.Trim(), ICODE.Trim(), "BC");
string ObservationInfo = ((int)polSourceObsInfoList[0]).ToString() + "," + ((int)polSourceObsInfoList[1]).ToString() + ",";
List <MapInfoModel> mapInfoModelListSubsector = new List <MapInfoModel>();
if (bcps.Y_calc == 48.984828948974609f && bcps.X_calc == -123.02297973632812f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB(49.01f, (float)bcps.X_calc, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 49.3099250793457f && bcps.X_calc == -121.77302551269531f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-122.2, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 48.3582878112793f && bcps.X_calc == -123.73906707763672f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-123.72, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 51.266487121582031f && bcps.X_calc == -128.20162963867187f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-128, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 55.91217041015625f && bcps.X_calc == -130.01992797851562f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-129, TVTypeEnum.Subsector);
}
else if (bcps.Y_calc == 55.912052154541016f && bcps.X_calc == -130.01669311523437f)
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)-129, TVTypeEnum.Subsector);
}
else
{
mapInfoModelListSubsector = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)bcps.Y_calc, (float)bcps.X_calc, TVTypeEnum.Subsector);
}
if (mapInfoModelListSubsector.Count == 0)
{
richTextBoxStatus.AppendText("GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB did not find anything\r\n");
return(false);
}
// doing EN TVText
string PolSourceSiteTVTextEN = _BaseEnumSerice.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[0]);
if (polSourceObsInfoList.Count > 1)
{
if (polSourceObsInfoList[1] != PolSourceObsInfoEnum.Error)
{
PolSourceSiteTVTextEN += " - " + _BaseEnumSerice.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[1]);
}
}
int Site = (int)bcps.OBJECTID;
PolSourceSiteTVTextEN = tvItemService.CleanText(PolSourceSiteTVTextEN + " - " + " ".Substring(0, 6 - Site.ToString().Length) + Site.ToString());
Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("fr-CA");
// Doing FR TVText
PolSourceObservationService polSourceObservationService2 = new PolSourceObservationService(LanguageEnum.fr, user);
string PolSourceSiteTVTextFR = _BaseEnumSerice.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[0]);
if (polSourceObsInfoList.Count > 1)
{
if (polSourceObsInfoList[1] != PolSourceObsInfoEnum.Error)
{
PolSourceSiteTVTextFR += " - " + _BaseEnumSerice.GetEnumText_PolSourceObsInfoEnum(polSourceObsInfoList[1]);
}
}
PolSourceSiteTVTextFR = tvItemService.CleanText(PolSourceSiteTVTextFR + " - " + " ".Substring(0, 6 - Site.ToString().Length) + Site.ToString());
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-CA");
TVItemModel tvItemModelPolSourceSite = tvItemService.PostCreateTVItem(mapInfoModelListSubsector[0].TVItemID, PolSourceSiteTVTextEN, PolSourceSiteTVTextFR, TVTypeEnum.PolSourceSite);
if (!CheckModelOK <TVItemModel>(tvItemModelPolSourceSite))
{
return(false);
}
List <Coord> coordList = new List <Coord>()
{
new Coord()
{
Lat = (float)bcps.Y_calc,
Lng = (float)bcps.X_calc,
}
};
MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList, MapInfoDrawTypeEnum.Point, TVTypeEnum.PolSourceSite, tvItemModelPolSourceSite.TVItemID);
if (!CheckModelOK <MapInfoModel>(mapInfoModelRet))
{
return(false);
}
polSourceSiteModelNew.PolSourceSiteTVItemID = tvItemModelPolSourceSite.TVItemID;
polSourceSiteModelNew.PolSourceSiteTVText = PolSourceSiteTVTextEN;
polSourceSiteModelNew.Site = Site;
polSourceSiteModelNew.Oldsiteid = Site;
PolSourceSiteModel polSourceSiteModelRet = polSourceSiteService.GetPolSourceSiteModelWithPolSourceSiteTVItemIDDB(tvItemModelPolSourceSite.TVItemID);
if (!string.IsNullOrWhiteSpace(polSourceSiteModelRet.Error))
{
polSourceSiteModelRet = polSourceSiteService.PostAddPolSourceSiteDB(polSourceSiteModelNew);
if (!CheckModelOK <PolSourceSiteModel>(polSourceSiteModelRet))
{
return(false);
}
}
PolSourceObservationModel polSourceObservationModelNew = new PolSourceObservationModel();
if (bcps.yyyymmdd == null)
{
polSourceObservationModelNew.ObservationDate_Local = new DateTime(2050, 1, 1);
}
else
{
polSourceObservationModelNew.ObservationDate_Local = (DateTime)bcps.yyyymmdd;
}
string Inspector = "unknown";
if (!string.IsNullOrWhiteSpace(bcps.Verified))
{
Inspector = bcps.Verified + " - (BC)";
}
string TVTextInspectorEN = "Inspector " + Inspector;
string TVTextInspectorFR = "Inspecteur " + Inspector;
TVItemModel tvItemModelContactRet = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, TVTextInspectorEN, TVTypeEnum.Contact);
if (!string.IsNullOrWhiteSpace(tvItemModelContactRet.Error))
{
tvItemModelContactRet = tvItemService.PostCreateTVItem(tvItemModelRoot.TVItemID, TVTextInspectorEN, TVTextInspectorFR, TVTypeEnum.Contact);
if (!CheckModelOK <TVItemModel>(tvItemModelContactRet))
{
return(false);
}
}
polSourceObservationModelNew.ContactTVItemID = tvItemModelContactRet.TVItemID;
string Observation = "(empty)";
if (!string.IsNullOrWhiteSpace(bcps.Remarks))
{
Observation = LCODE.Trim().ToUpper() + " - " + ICODE.Trim().ToUpper() + " - " + bcps.Remarks;
}
polSourceObservationModelNew.Observation_ToBeDeleted = Observation;
polSourceObservationModelNew.PolSourceSiteID = polSourceSiteModelRet.PolSourceSiteID;
PolSourceObservationModel polSourceObservationModelRet = polSourceObservationService.GetPolSourceObservationModelExistDB(polSourceObservationModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationModelRet.Error))
{
polSourceObservationModelRet = polSourceObservationService.PostAddPolSourceObservationDB(polSourceObservationModelNew);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet))
{
return(false);
}
}
PolSourceObservationIssueModel polSourceObservationIssueModelNew = new PolSourceObservationIssueModel()
{
PolSourceObservationID = polSourceObservationModelNew.PolSourceObservationID,
ObservationInfo = ObservationInfo,
PolSourceObsInfoList = polSourceObsInfoList,
Ordinal = 0,
};
PolSourceObservationIssueModel polSourceObservationIssueModelRet = polSourceObservationIssueService.GetPolSourceObservationIssueModelExistDB(polSourceObservationIssueModelNew);
if (!string.IsNullOrWhiteSpace(polSourceObservationIssueModelRet.Error))
{
polSourceObservationIssueModelRet = polSourceObservationIssueService.PostAddPolSourceObservationIssueDB(polSourceObservationIssueModelNew);
if (!CheckModelOK <PolSourceObservationModel>(polSourceObservationModelRet))
{
return(false);
}
}
}
return(true);
}
public void PolSourceObservationIssue_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
PolSourceObservationIssueController polSourceObservationIssueController = new PolSourceObservationIssueController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(polSourceObservationIssueController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, polSourceObservationIssueController.DatabaseType);
PolSourceObservationIssue polSourceObservationIssueLast = new PolSourceObservationIssue();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
PolSourceObservationIssueService polSourceObservationIssueService = new PolSourceObservationIssueService(query, db, ContactID);
polSourceObservationIssueLast = (from c in db.PolSourceObservationIssues select c).FirstOrDefault();
}
// ok with PolSourceObservationIssue info
IHttpActionResult jsonRet = polSourceObservationIssueController.GetPolSourceObservationIssueWithID(polSourceObservationIssueLast.PolSourceObservationIssueID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <PolSourceObservationIssue> Ret = jsonRet as OkNegotiatedContentResult <PolSourceObservationIssue>;
PolSourceObservationIssue polSourceObservationIssueRet = Ret.Content;
Assert.AreEqual(polSourceObservationIssueLast.PolSourceObservationIssueID, polSourceObservationIssueRet.PolSourceObservationIssueID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because PolSourceObservationIssueID exist
IHttpActionResult jsonRet2 = polSourceObservationIssueController.Post(polSourceObservationIssueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <PolSourceObservationIssue> polSourceObservationIssueRet2 = jsonRet2 as OkNegotiatedContentResult <PolSourceObservationIssue>;
Assert.IsNull(polSourceObservationIssueRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added PolSourceObservationIssue
polSourceObservationIssueRet.PolSourceObservationIssueID = 0;
polSourceObservationIssueController.Request = new System.Net.Http.HttpRequestMessage();
polSourceObservationIssueController.Request.RequestUri = new System.Uri("http://localhost:5000/api/polSourceObservationIssue");
IHttpActionResult jsonRet3 = polSourceObservationIssueController.Post(polSourceObservationIssueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <PolSourceObservationIssue> polSourceObservationIssueRet3 = jsonRet3 as CreatedNegotiatedContentResult <PolSourceObservationIssue>;
Assert.IsNotNull(polSourceObservationIssueRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = polSourceObservationIssueController.Delete(polSourceObservationIssueRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <PolSourceObservationIssue> polSourceObservationIssueRet4 = jsonRet4 as OkNegotiatedContentResult <PolSourceObservationIssue>;
Assert.IsNotNull(polSourceObservationIssueRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
