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 bool CreateSamplesBC()
{
lblStatus.Text = "Starting ... CreateSamplesBC";
Application.DoEvents();
TVItemService tvItemServiceR = new TVItemService(LanguageEnum.en, user);
MWQMRunService mwqmRunService = new MWQMRunService(LanguageEnum.en, user);
MWQMSiteService mwqmSiteService = new MWQMSiteService(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 tvItemModelProv = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "British Columbia", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelProv))
{
return(false);
}
List <TVItemModel> BCSubSectorLangList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelProv.TVItemID, TVTypeEnum.Subsector);
if (BCSubSectorLangList.Count == 0)
{
return(false);
}
List <BCStation> BCWQMSiteList = new List <BCStation>();
TVItemModel BCSubSector = new TVItemModel();
List <TT> tideTextInDBList = new List <TT>();
List <AM> analyseMethodInDBList = new List <AM>();
List <Mat> matrixInDBList = new List <Mat>();
List <Lab> labInDBList = new List <Lab>();
int StartBCCreateSamplesBC = int.Parse(textBoxBCCreateSamplesBC.Text);
int TotalCount = BCSubSectorLangList.Count();
int Count = 0;
foreach (TVItemModel tvItemModelSubsector in BCSubSectorLangList)
{
if (Cancel)
{
return(false);
}
Count += 1;
lblStatus.Text = (Count * 100 / TotalCount).ToString() + " ... CreateSamplesBC of " + tvItemModelSubsector.TVText;
lblStatus2.Text = Count + " of " + TotalCount;
Application.DoEvents();
textBoxBCCreateSamplesBC.Text = Count.ToString();
if (StartBCCreateSamplesBC > Count)
{
continue;
}
List <MWQMRunModel> BCRunModelList = mwqmRunService.GetMWQMRunModelListWithSubsectorTVItemIDDB(tvItemModelSubsector.TVItemID);
if (BCRunModelList.Count == 0)
{
continue;
}
List <TVItemModel> tvItemModelList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelSubsector.TVItemID, TVTypeEnum.MWQMSite);
if (tvItemModelList.Count == 0)
{
return(false);
}
MWQMSampleService mwqmSampleService = new MWQMSampleService(LanguageEnum.en, user);
List <MWQMSample> mwqmSampleList = new List <MWQMSample>();
using (CSSPDBEntities dd = new CSSPDBEntities())
{
mwqmSampleList = (from c in dd.MWQMSamples
from ts in dd.TVItems
from tr in dd.TVItems
where c.MWQMSiteTVItemID == ts.TVItemID &&
c.MWQMRunTVItemID == tr.TVItemID &&
ts.ParentID == tvItemModelSubsector.TVItemID &&
tr.ParentID == tvItemModelSubsector.TVItemID
select c).Distinct().ToList();
}
// doing land samples
List <TempData.BCLandSampleStation> bcLandSampleStation = new List <TempData.BCLandSampleStation>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
string TVText = tvItemModelSubsector.TVText.Substring(0, 4);
bcLandSampleStation = (from c in dbDT.BCLandSampleStations
where c.SS_STATION == TVText
orderby c.BCLandSampleStationID
select c).ToList <TempData.BCLandSampleStation>();
}
int countSta = 0;
int totalSta = bcLandSampleStation.Count;
foreach (TempData.BCLandSampleStation bcmss in bcLandSampleStation)
{
if (Cancel)
{
return(false);
}
countSta += 1;
lblStatus2.Text = "Doing Land Station " + bcmss.SS_STATION + " --- " + countSta + " of " + totalSta;
Application.DoEvents();
string TVText = bcmss.SS_STATION;
BCSubSector = (from c in BCSubSectorLangList where c.TVText.StartsWith(bcmss.SS_SHELLFI) select c).FirstOrDefault();
if (!CheckModelOK <TVItemModel>(BCSubSector))
{
continue;
}
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
TVItemModel tvItemModelMWQMSite = tvItemModelList.Where(c => c.TVText == TVText).FirstOrDefault();
if (tvItemModelMWQMSite == null)
{
richTextBoxStatus.AppendText("Could not find MWQMSite [" + TVText + "]");
return(false);
}
List <TempData.BCLandSample> bcLandSampleList = new List <TempData.BCLandSample>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
bcLandSampleList = (from c in dbDT.BCLandSamples
where c.SR_STATION_CODE == bcmss.SS_STATION
orderby c.SR_READING_DATE
select c).ToList <TempData.BCLandSample>();
}
int countSample = 0;
int TotalSample = bcLandSampleList.Count;
foreach (TempData.BCLandSample bcms in bcLandSampleList)
{
if (Cancel)
{
return(false);
}
countSample += 1;
lblStatus2.Text = "Doing Marine Station " + bcms.SR_STATION_CODE + " --- " + countSta + " of " + totalSta + " Sample " + countSample + " of " + TotalSample;
Application.DoEvents();
try
{
DateTime DayOfSample = (DateTime)(bcms.SR_READING_DATE);
string SampleTime = bcms.SR_READING_TIME;
if (SampleTime == null)
{
SampleTime = "0000";
}
DateTime SampleDate = new DateTime(DayOfSample.Year, DayOfSample.Month, DayOfSample.Day, (SampleTime.Length == 1 ? 0 : (SampleTime.Length == 3 ? (int.Parse(SampleTime.Substring(0, 1))) : (int.Parse(SampleTime.Substring(0, 1))))), (SampleTime.Length == 1 ? 0 : (SampleTime.Length == 3 ? (int.Parse(SampleTime.Substring(1, 2))) : (SampleTime.Substring(2, 2) == "60" ? 59 : (int.Parse(SampleTime.Substring(2, 2)))))), 0);
int FecCol = 0;
if (bcms.SR_FECAL_COLIFORM_IND == "<" && bcms.SR_FECAL_COLIFORM == 2)
{
FecCol = 1;
}
else
{
if (bcms.SR_FECAL_COLIFORM == null)
{
continue;
}
FecCol = (int)bcms.SR_FECAL_COLIFORM;
}
MWQMRunModel mwqmRunModel = (from c in BCRunModelList
where c.SubsectorTVItemID == BCSubSector.TVItemID &&
c.DateTime_Local.Year == SampleDate.Year &&
c.DateTime_Local.Month == SampleDate.Month &&
c.DateTime_Local.Day == SampleDate.Day
select c).FirstOrDefault();
if (mwqmRunModel == null)
{
richTextBoxStatus.AppendText("Could not find run for date [" + SampleDate.ToString("yyyy MMM dd") + "] for subsector [" + BCSubSector.TVText + "]\r\n");
continue;
//return false;
}
bool SampleExist = (from c in mwqmSampleList
where c.MWQMSiteTVItemID == tvItemModelMWQMSite.TVItemID &&
c.MWQMRunTVItemID == mwqmRunModel.MWQMRunTVItemID &&
c.SampleDateTime_Local == SampleDate &&
c.FecCol_MPN_100ml == FecCol &&
c.Salinity_PPT == null &&
c.WaterTemp_C == null &&
c.SampleTypesText.Contains(((int)SampleTypeEnum.Routine).ToString())
select c).Any();
if (!SampleExist)
{
MWQMSampleModel mwqmSampleModelNew = new MWQMSampleModel()
{
MWQMSiteTVItemID = tvItemModelMWQMSite.TVItemID,
MWQMRunTVItemID = mwqmRunModel.MWQMRunTVItemID,
SampleDateTime_Local = SampleDate,
Depth_m = null,
FecCol_MPN_100ml = FecCol,
Salinity_PPT = null,
MWQMSampleNote = (string.IsNullOrWhiteSpace(bcms.SR_OBS) == true ? "--" : bcms.SR_OBS.Trim()),
WaterTemp_C = null,
SampleTypesText = ((int)SampleTypeEnum.Routine).ToString() + ",",
SampleTypeList = new List <SampleTypeEnum>()
{
SampleTypeEnum.Routine
},
};
MWQMSampleModel mwqmSampleModelRet = mwqmSampleService.GetMWQMSampleModelExistDB(mwqmSampleModelNew);
if (!string.IsNullOrWhiteSpace(mwqmSampleModelRet.Error))
{
mwqmSampleModelRet = mwqmSampleService.PostAddMWQMSampleDB(mwqmSampleModelNew);
if (!CheckModelOK <MWQMSampleModel>(mwqmSampleModelRet))
{
return(false);
}
}
}
}
catch (Exception)
{
continue;
}
}
}
// doing water samples
List <TempData.BCMarineSampleStation> bcMarineSampleStation = new List <TempData.BCMarineSampleStation>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
string TVText = tvItemModelSubsector.TVText.Substring(0, 4);
bcMarineSampleStation = (from c in dbDT.BCMarineSampleStations
where c.SS_SHELLFI == TVText
orderby c.BCMarineSampleStationID
select c).ToList <TempData.BCMarineSampleStation>();
}
countSta = 0;
totalSta = bcMarineSampleStation.Count;
foreach (TempData.BCMarineSampleStation bcmss in bcMarineSampleStation)
{
if (Cancel)
{
return(false);
}
countSta += 1;
lblStatus2.Text = "Doing Marine Sample " + countSta + " of " + totalSta;
Application.DoEvents();
string TVText = bcmss.SS_STATION;
BCSubSector = (from c in BCSubSectorLangList where c.TVText.StartsWith(bcmss.SS_SHELLFI) select c).FirstOrDefault();
if (!CheckModelOK <TVItemModel>(BCSubSector))
{
return(false);
}
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
TVItemModel tvItemModelMWQMSite = tvItemModelList.Where(c => c.TVText == TVText).FirstOrDefault();
if (tvItemModelMWQMSite == null)
{
richTextBoxStatus.AppendText("Could not find MWQMSite [" + TVText + "]");
return(false);
}
List <TempData.BCMarineSample> bcMarineSampleList = new List <TempData.BCMarineSample>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
bcMarineSampleList = (from c in dbDT.BCMarineSamples
where c.SR_STATION_CODE == bcmss.SS_STATION
orderby c.SR_READING_DATE
select c).ToList <TempData.BCMarineSample>();
}
int countSample = 0;
int TotalSample = bcMarineSampleList.Count;
foreach (TempData.BCMarineSample bcms in bcMarineSampleList)
{
if (Cancel)
{
return(false);
}
countSample += 1;
lblStatus2.Text = "Doing Marine station " + bcms.SR_STATION_CODE + " ----" + countSta + " of " + totalSta + " Sample " + countSample + " of " + TotalSample;
Application.DoEvents();
try
{
DateTime DayOfSample = (DateTime)(bcms.SR_READING_DATE);
string SampleTime = bcms.SR_READING_TIME;
if (SampleTime == null)
{
SampleTime = "0000";
}
if (SampleTime == "093")
{
SampleTime = "0930";
}
if (SampleTime == "080")
{
SampleTime = "0800";
}
if (SampleTime == "073")
{
SampleTime = "0730";
}
if (SampleTime == "060")
{
SampleTime = "0600";
}
DateTime SampleDate = new DateTime(DayOfSample.Year, DayOfSample.Month, DayOfSample.Day, (SampleTime.Length == 1 ? 0 : (SampleTime.Length == 3 ? (int.Parse(SampleTime.Substring(0, 1))) : (int.Parse(SampleTime.Substring(0, 1))))), (SampleTime.Length == 1 ? 0 : (SampleTime.Length == 3 ? (int.Parse(SampleTime.Substring(1, 2))) : (SampleTime.Substring(2, 2) == "60" ? 59 : (int.Parse(SampleTime.Substring(2, 2)))))), 0);
int FecCol = 0;
if (bcms.SR_FECAL_COLIFORM_IND == "<" && bcms.SR_FECAL_COLIFORM == 2)
{
FecCol = 1;
}
else
{
FecCol = (int)bcms.SR_FECAL_COLIFORM;
}
MWQMRunModel mwqmRunModel = (from c in BCRunModelList
where c.SubsectorTVItemID == BCSubSector.TVItemID &&
c.DateTime_Local.Year == SampleDate.Year &&
c.DateTime_Local.Month == SampleDate.Month &&
c.DateTime_Local.Day == SampleDate.Day
select c).FirstOrDefault();
if (mwqmRunModel == null)
{
richTextBoxStatus.AppendText("Could not find run for date [" + SampleDate.ToString("yyyy MMM dd") + "] for subsector [" + BCSubSector.TVText + "]\r\n");
continue;
//return false;
}
bool SampleExist = (from c in mwqmSampleList
where c.MWQMSiteTVItemID == tvItemModelMWQMSite.TVItemID &&
c.MWQMRunTVItemID == mwqmRunModel.MWQMRunTVItemID &&
c.SampleDateTime_Local == SampleDate &&
c.FecCol_MPN_100ml == FecCol &&
c.Salinity_PPT == bcms.SR_SALINITY &&
c.WaterTemp_C == bcms.SR_TEMPERATURE &&
c.SampleTypesText.Contains(((int)SampleTypeEnum.Routine).ToString())
select c).Any();
if (!SampleExist)
{
MWQMSampleModel mwqmSampleModelNew = new MWQMSampleModel()
{
MWQMSiteTVItemID = tvItemModelMWQMSite.TVItemID,
MWQMRunTVItemID = mwqmRunModel.MWQMRunTVItemID,
SampleDateTime_Local = SampleDate,
Depth_m = bcms.SR_SAMPLE_DEPTH,
FecCol_MPN_100ml = FecCol,
Salinity_PPT = bcms.SR_SALINITY,
MWQMSampleNote = (string.IsNullOrWhiteSpace(bcms.SR_OBS) == true ? "--" : bcms.SR_OBS.Trim()),
WaterTemp_C = bcms.SR_TEMPERATURE,
SampleTypesText = ((int)SampleTypeEnum.Routine).ToString() + ",",
SampleTypeList = new List <SampleTypeEnum>()
{
SampleTypeEnum.Routine
},
};
MWQMSampleModel mwqmSampleModelRet = mwqmSampleService.GetMWQMSampleModelExistDB(mwqmSampleModelNew);
if (!string.IsNullOrWhiteSpace(mwqmSampleModelRet.Error))
{
mwqmSampleModelRet = mwqmSampleService.PostAddMWQMSampleDB(mwqmSampleModelNew);
if (!CheckModelOK <MWQMSampleModel>(mwqmSampleModelRet))
{
return(false);
}
}
}
}
catch (Exception)
{
continue;
}
}
}
}
return(true);
}
public bool CreateStationsBC()
{
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 tvItemModelBC = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "British Columbia", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelBC))
{
return(false);
}
List <TVItemModel> tvItemModelSubsectorBCList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelBC.TVItemID, TVTypeEnum.Subsector);
if (tvItemModelSubsectorBCList.Count == 0)
{
richTextBoxStatus.AppendText("Could not find TVItem Subsector under British Columbia\r\n");
return(false);
}
lblStatus.Text = "Starting ... LoadStationsBC";
Application.DoEvents();
int StartBCCreateStationBC = int.Parse(textBoxBCCreateStationsBC.Text);
List <BCStation> BCWQMSiteList = new List <BCStation>();
TVItemModel TVItemModelSubsectorBC = new TVItemModel();
List <TT> tideTextInDBList = new List <TT>();
List <AM> analyseMethodInDBList = new List <AM>();
List <Mat> matrixInDBList = new List <Mat>();
List <Lab> labInDBList = new List <Lab>();
int TotalCount = tvItemModelSubsectorBCList.Count();
int Count = 0;
foreach (TVItemModel tvItemModelSubsector in tvItemModelSubsectorBCList)
{
if (Cancel)
{
return(false);
}
Count += 1;
lblStatus.Text = (Count * 100 / TotalCount).ToString() + " ... CreateStationsBC for " + tvItemModelSubsector.TVText;
lblStatus2.Text = Count + " of " + TotalCount;
Application.DoEvents();
textBoxBCCreateStationsBC.Text = Count.ToString();
if (StartBCCreateStationBC > Count)
{
continue;
}
// doing Land base stations
List <TempData.BCLandSampleStation> bcLandSampleStation = new List <TempData.BCLandSampleStation>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
string TVText = tvItemModelSubsector.TVText.Substring(0, 4);
bcLandSampleStation = (from c in dbDT.BCLandSampleStations
where c.SS_SHELLFI == TVText
orderby c.BCLandSampleStationID
select c).ToList <TempData.BCLandSampleStation>();
}
int CountSta = 0;
int TotalCountSta = bcLandSampleStation.Count;
foreach (TempData.BCLandSampleStation bcmss in bcLandSampleStation)
{
if (Cancel)
{
return(false);
}
CountSta += 1;
lblStatus2.Text = "Doing Land Base ... " + CountSta + " of " + TotalCountSta;
Application.DoEvents();
string TVText = bcmss.SS_STATION;
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user);
MWQMSiteService mwqmSiteService = new MWQMSiteService(LanguageEnum.en, user);
TVItemModel tvItemModelMWQMSite = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelSubsector.TVItemID, TVText, TVTypeEnum.MWQMSite);
if (!string.IsNullOrWhiteSpace(tvItemModelMWQMSite.Error))
{
tvItemModelMWQMSite = tvItemService.PostCreateTVItem(tvItemModelSubsector.TVItemID, TVText, TVText, TVTypeEnum.MWQMSite);
if (!CheckModelOK <TVItemModel>(tvItemModelMWQMSite))
{
return(false);
}
List <Coord> coordList2 = new List <Coord>()
{
new Coord()
{
Lat = (float)(bcmss.LAT == null ? 50.0f : bcmss.LAT),
Lng = (float)(bcmss.LON == null ? -132.0f : bcmss.LON),
}
};
if (coordList2[0].Lat == 124.40966796875 && coordList2[0].Lng == -48.585498809814453)
{
coordList2[0].Lat = 48.585498809814453f;
coordList2[0].Lng = -124.40966796875f;
}
MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList2, MapInfoDrawTypeEnum.Point, TVTypeEnum.MWQMSite, tvItemModelMWQMSite.TVItemID);
if (!CheckModelOK <MapInfoModel>(mapInfoModelRet))
{
return(false);
}
MWQMSiteModel mwqmSiteModelNew = new MWQMSiteModel()
{
MWQMSiteTVItemID = tvItemModelMWQMSite.TVItemID,
MWQMSiteNumber = bcmss.SS_STATION.ToString(),
MWQMSiteTVText = TVText,
MWQMSiteDescription = "empty",
};
MWQMSiteModel mwqmSiteModelRet = mwqmSiteService.PostAddMWQMSiteDB(mwqmSiteModelNew);
if (!CheckModelOK <MWQMSiteModel>(mwqmSiteModelRet))
{
return(false);
}
}
}
// doing Marine base stations
List <TempData.BCMarineSampleStation> bcMarineSampleStation = new List <TempData.BCMarineSampleStation>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
string TVText = tvItemModelSubsector.TVText.Substring(0, 4);
bcMarineSampleStation = (from c in dbDT.BCMarineSampleStations
where c.SS_SHELLFI == TVText
orderby c.BCMarineSampleStationID
select c).ToList <TempData.BCMarineSampleStation>();
}
CountSta = 0;
TotalCountSta = bcMarineSampleStation.Count;
foreach (TempData.BCMarineSampleStation bcmss in bcMarineSampleStation)
{
if (Cancel)
{
return(false);
}
CountSta += 1;
lblStatus2.Text = "Doing Marine Base ... " + CountSta + " of " + TotalCountSta;
Application.DoEvents();
string TVText = bcmss.SS_STATION;
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user);
MWQMSiteService mwqmSiteService = new MWQMSiteService(LanguageEnum.en, user);
TVItemModel tvItemModelMWQMSite = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelSubsector.TVItemID, TVText, TVTypeEnum.MWQMSite);
if (!string.IsNullOrWhiteSpace(tvItemModelMWQMSite.Error))
{
tvItemModelMWQMSite = tvItemService.PostCreateTVItem(tvItemModelSubsector.TVItemID, TVText, TVText, TVTypeEnum.MWQMSite);
if (!CheckModelOK <TVItemModel>(tvItemModelMWQMSite))
{
return(false);
}
List <Coord> coordList2 = new List <Coord>()
{
new Coord()
{
Lat = (float)(bcmss.LAT == null ? 50.0f : bcmss.LAT),
Lng = (float)(bcmss.LON == null ? -132.0f : bcmss.LON),
}
};
MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList2, MapInfoDrawTypeEnum.Point, TVTypeEnum.MWQMSite, tvItemModelMWQMSite.TVItemID);
if (!CheckModelOK <MapInfoModel>(mapInfoModelRet))
{
return(false);
}
MWQMSiteModel mwqmSiteModelNew = new MWQMSiteModel()
{
MWQMSiteTVItemID = tvItemModelMWQMSite.TVItemID,
MWQMSiteNumber = bcmss.SS_STATION.ToString(),
MWQMSiteTVText = TVText,
MWQMSiteDescription = "empty",
};
MWQMSiteModel mwqmSiteModelRet = mwqmSiteService.PostAddMWQMSiteDB(mwqmSiteModelNew);
if (!CheckModelOK <MWQMSiteModel>(mwqmSiteModelRet))
{
return(false);
}
}
}
}
return(true);
}
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 bool CreateStationsQC()
{
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
TVItemLanguageService tvItemLanguageService = new TVItemLanguageService(LanguageEnum.en, user);
MapInfoService mapInfoService = new MapInfoService(LanguageEnum.en, user);
MWQMSiteService mwqmSiteService = new MWQMSiteService(LanguageEnum.en, user);
TVItemModel tvItemModelRoot = tvItemService.GetRootTVItemModelDB();
if (!CheckModelOK <TVItemModel>(tvItemModelRoot))
{
return(false);
}
TVItemModel tvItemModelCanada = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelRoot.TVItemID, "Canada", TVTypeEnum.Country);
if (!CheckModelOK <TVItemModel>(tvItemModelCanada))
{
return(false);
}
TVItemModel tvItemModelQC = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "Québec", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelQC))
{
return(false);
}
List <TVItemModel> tvItemModelSubsectorQCList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelQC.TVItemID, TVTypeEnum.Subsector);
if (tvItemModelSubsectorQCList.Count == 0)
{
richTextBoxStatus.AppendText("Could not find TVItem Subsector under British Columbia\r\n");
return(false);
}
lblStatus.Text = "Starting ... CreateStationsQC";
Application.DoEvents();
int StartQCCreateStationQC = int.Parse(textBoxQCCreateStationsQC.Text);
List <Obs> obsTypeList = new List <Obs>();
List <string> sectorList = new List <string>();
List <TT> tideTextInDBList = new List <TT>();
List <AM> analyseMethodInDBList = new List <AM>();
List <Mat> matrixInDBList = new List <Mat>();
List <Lab> labInDBList = new List <Lab>();
List <SampleStatus> sampleStatusInDBList = new List <SampleStatus>();
List <TempData.QCSubsectorAssociation> qcSubAssList = new List <TempData.QCSubsectorAssociation>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
qcSubAssList = (from c in dbDT.QCSubsectorAssociations
select c).ToList <TempData.QCSubsectorAssociation>();
}
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
sectorList = (from s in dbQC.geo_stations_p
where s.secteur != null
select s.secteur).Distinct().OrderBy(c => c).ToList();
}
List <TVItemModel> tvItemModelSubsectorList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelQC.TVItemID, TVTypeEnum.Subsector);
List <TVItemModel> tvItemModelSiteList = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelQC.TVItemID, TVTypeEnum.MWQMSite);
TempData.QCSubsectorAssociation qcSubsectAss = new TempData.QCSubsectorAssociation();
// doing every sector with the exception of MS__
List <PCCSM.geo_stations_p> staQCList = new List <PCCSM.geo_stations_p>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
staQCList = (from c in dbQC.geo_stations_p
where (c.x != null && c.y != null) &&
c.secteur != null
orderby c.secteur, c.station
select c).ToList <PCCSM.geo_stations_p>();
}
List <TVItemLanguage> tvItemSiteLanguageList = new List <TVItemLanguage>();
int TVItemIDSSOld = 0;
int count = 0;
int total = staQCList.Count;
foreach (PCCSM.geo_stations_p geoStat in staQCList)
{
if (Cancel)
{
return(false);
}
textBoxQCCreateStationsQC.Text = count.ToString();
if (StartQCCreateStationQC > count)
{
continue;
}
qcSubsectAss = (from c in qcSubAssList
where c.QCSectorText == geoStat.secteur
select c).FirstOrDefault <TempData.QCSubsectorAssociation>();
if (qcSubsectAss == null)
{
richTextBoxStatus.AppendText(geoStat.secteur + " does not exist\r\n");
//return false;
continue;
}
TVItemModel tvItemModelSubsector = (from c in tvItemModelSubsectorList
where c.TVText.StartsWith(qcSubsectAss.SubsectorText)
select c).FirstOrDefault();
if (TVItemIDSSOld != tvItemModelSubsector.TVItemID)
{
using (CSSPDBEntities db2 = new CSSPDBEntities())
{
tvItemSiteLanguageList = (from c in db2.TVItems
from cl in db2.TVItemLanguages
where c.TVItemID == cl.TVItemID &&
c.ParentID == tvItemModelSubsector.TVItemID &&
c.TVType == (int)TVTypeEnum.MWQMSite
select cl).ToList();
}
TVItemIDSSOld = tvItemModelSubsector.TVItemID;
}
if (tvItemModelSubsector == null)
{
richTextBoxStatus.AppendText("could not find subsector" + geoStat.secteur + "\r\n");
//return false;
continue;
}
bool IsActive = true;
if (geoStat.status != null)
{
IsActive = (geoStat.status.Substring(0, 1) == "i" ? false : true);
}
string PreText = "";
if (geoStat.secteur.Length < qcSubsectAss.SubsectorText.Length)
{
PreText = "";
}
else
{
if (geoStat.secteur.StartsWith(qcSubsectAss.SubsectorText))
{
PreText = geoStat.secteur.Substring(qcSubsectAss.SubsectorText.Length) + "_";
}
else
{
PreText = geoStat.secteur + "_";
}
}
if (PreText.StartsWith(".") || PreText.StartsWith("_"))
{
PreText = PreText.Substring(1);
}
string MWQMSiteTVText = PreText + "0000".Substring(0, 4 - geoStat.station.ToString().Length) + geoStat.station.ToString();
string subsector = tvItemModelSubsector.TVText;
if (subsector.Contains(" "))
{
subsector = subsector.Substring(0, subsector.IndexOf(" "));
}
count += 1;
lblStatus.Text = $"{subsector} --- {MWQMSiteTVText} --- { count.ToString()}/{total.ToString()}";
Application.DoEvents();
List <MapInfoModel> mapInfoModelList = mapInfoService.GetMapInfoModelWithLatAndLngInPolygonWithTVTypeDB((float)geoStat.y, (float)geoStat.x, TVTypeEnum.Subsector);
if (mapInfoModelList.Count == 0)
{
//return false;
continue;
}
TVItemModel tvItemModel = (from c in tvItemModelSiteList
where c.ParentID == tvItemModelSubsector.TVItemID &&
c.TVText.EndsWith(MWQMSiteTVText)
select c).FirstOrDefault();
//TVItemModel tvItemModel = tvItemModelMWQMSiteList.Where(c => c.TVText.EndsWith(MWQMSiteTVText)).FirstOrDefault();
if (tvItemModel == null)
{
TVItemModel tvItemModelRet = tvItemService.PostCreateTVItem(tvItemModelSubsector.TVItemID, MWQMSiteTVText, MWQMSiteTVText, TVTypeEnum.MWQMSite);
if (!CheckModelOK <TVItemModel>(tvItemModelRet))
{
//return false;
continue;
}
if (geoStat.status == null)
{
tvItemModelRet.IsActive = false;
}
else
{
tvItemModelRet.IsActive = (geoStat.status.Substring(0, 1) == "i" ? false : true);
}
TVItemModel tvItemModelRet2 = tvItemService.PostUpdateTVItemDB(tvItemModelRet);
if (!CheckModelOK <TVItemModel>(tvItemModelRet2))
{
//return false;
continue;
}
List <Coord> coordList2 = new List <Coord>()
{
new Coord()
{
Lat = (float)geoStat.y,
Lng = (float)geoStat.x,
}
};
MapInfoModel mapInfoModelRet = mapInfoService.CreateMapInfoObjectDB(coordList2, MapInfoDrawTypeEnum.Point, TVTypeEnum.MWQMSite, tvItemModelRet2.TVItemID);
if (!CheckModelOK <MapInfoModel>(mapInfoModelRet))
{
//return false;
continue;
}
// should add the QC station to WQMSite
MWQMSiteModel mwqmSiteModelNew = new MWQMSiteModel()
{
MWQMSiteTVItemID = tvItemModelRet2.TVItemID,
MWQMSiteNumber = geoStat.station.ToString(),
Ordinal = (int)geoStat.station,
MWQMSiteTVText = MWQMSiteTVText,
MWQMSiteDescription = "--"
};
MWQMSiteModel mwqmSiteModelRet = mwqmSiteService.PostAddMWQMSiteDB(mwqmSiteModelNew);
if (!CheckModelOK <MWQMSiteModel>(mwqmSiteModelRet))
{
//return false;
continue;
}
}
else
{
TVItemLanguage tvItemLanguageEN = (from c in tvItemSiteLanguageList
where c.TVItemID == tvItemModel.TVItemID &&
c.Language == (int)LanguageEnum.en
select c).FirstOrDefault();
TVItemLanguage tvItemLanguageFR = (from c in tvItemSiteLanguageList
where c.TVItemID == tvItemModel.TVItemID &&
c.Language == (int)LanguageEnum.fr
select c).FirstOrDefault();
if (tvItemLanguageEN.TVText != MWQMSiteTVText || tvItemLanguageFR.TVText != MWQMSiteTVText)
{
foreach (LanguageEnum language in new List <LanguageEnum>()
{
LanguageEnum.en, LanguageEnum.fr
})
{
TVItemLanguageModel tvItemLanguageModel = tvItemLanguageService.GetTVItemLanguageModelWithTVItemIDAndLanguageDB(tvItemModel.TVItemID, language);
if (!CheckModelOK <TVItemLanguageModel>(tvItemLanguageModel))
{
//return false;
continue;
}
if (tvItemLanguageModel.TVText != MWQMSiteTVText)
{
tvItemLanguageModel.TVText = MWQMSiteTVText;
TVItemLanguageModel tvItemLanguageModelRet = tvItemLanguageService.PostUpdateTVItemLanguageDB(tvItemLanguageModel);
if (!CheckModelOK <TVItemLanguageModel>(tvItemLanguageModelRet))
{
//return false;
continue;
}
}
}
}
}
}
return(true);
}
public bool CreateRunsQC()
{
if (Cancel)
{
return(false);
}
TVItemService tvItemServiceR = new TVItemService(LanguageEnum.en, user);
TVItemService tvItemService = new TVItemService(LanguageEnum.en, user);
MWQMRunService mwqmRunService = new MWQMRunService(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 tvItemModelProv = tvItemServiceR.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelCanada.TVItemID, "Québec", TVTypeEnum.Province);
if (!CheckModelOK <TVItemModel>(tvItemModelProv))
{
return(false);
}
List <TVItemModel> tvItemModelSubsectorList = tvItemServiceR.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelProv.TVItemID, TVTypeEnum.Subsector);
if (tvItemModelSubsectorList.Count == 0)
{
richTextBoxStatus.AppendText("Error: could not find TVItem Subsector for " + tvItemModelProv.TVText + "\r\n");
return(false);
}
lblStatus.Text = "Starting ... CreateRunsQC";
Application.DoEvents();
int StartQCCreateRunsQC = int.Parse(textBoxQCCreateRunsQC.Text);
List <Obs> obsTypeList = new List <Obs>();
List <string> sectorList = new List <string>();
List <AM> analyseMethodInDBList = new List <AM>();
List <Mat> matrixInDBList = new List <Mat>();
List <Lab> labInDBList = new List <Lab>();
List <SampleStatus> sampleStatusInDBList = new List <SampleStatus>();
List <TempData.QCSubsectorAssociation> qcSubAssList = new List <TempData.QCSubsectorAssociation>();
using (TempData.TempDataToolDBEntities dbDT = new TempData.TempDataToolDBEntities())
{
qcSubAssList = (from c in dbDT.QCSubsectorAssociations
select c).ToList <TempData.QCSubsectorAssociation>();
}
List <PCCSM.geo_stations_p> staQCListAll = new List <PCCSM.geo_stations_p>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
staQCListAll = (from c in dbQC.geo_stations_p
where (c.x != null && c.y != null) &&
c.secteur != null
select c).ToList <PCCSM.geo_stations_p>();
sectorList = (from s in dbQC.geo_stations_p
where s.secteur != null
orderby s.secteur
select s.secteur).Distinct().ToList();
}
List <TVItemModel> tvItemMWQMSiteAll = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelProv.TVItemID, TVTypeEnum.MWQMSite);
List <TVItemModel> tvItemMWQMRunAll = tvItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelProv.TVItemID, TVTypeEnum.MWQMRun);
List <PCCSM.db_mesure> dbMesureListAll = new List <PCCSM.db_mesure>();
List <PCCSM.db_tournee> dbtAll = new List <PCCSM.db_tournee>();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
dbMesureListAll = (from m in dbQC.db_mesure
select m).ToList <PCCSM.db_mesure>();
dbtAll = (from t in dbQC.db_tournee
select t).ToList();
}
int Count = 0;
int TotalCount = sectorList.Count();
foreach (string sec in sectorList)
{
if (Cancel)
{
return(false);
}
Count += 1;
lblStatus.Text = (Count * 100 / TotalCount).ToString() + " ... CreateRunsQC for " + sec;
lblStatus2.Text = Count + " of " + TotalCount;
Application.DoEvents();
textBoxQCCreateRunsQC.Text = Count.ToString();
if (StartQCCreateRunsQC > Count)
{
continue;
}
TempData.QCSubsectorAssociation qcSubsectAss = (from c in qcSubAssList
where c.QCSectorText == sec
select c).FirstOrDefault <TempData.QCSubsectorAssociation>();
if (qcSubsectAss == null)
{
continue;
}
string TVText = qcSubsectAss.SubsectorText;
TVItemModel tvItemModelSubsector = (from c in tvItemModelSubsectorList
where c.TVText.StartsWith(TVText)
select c).FirstOrDefault();
if (tvItemModelSubsector == null)
{
richTextBoxStatus.AppendText($"could not find tvItemmodelSubsector [{TVText}]\r\n");
return(false);
}
List <MWQMRunModel> mwqmRunModelAll = mwqmRunService.GetMWQMRunModelListWithSubsectorTVItemIDDB(tvItemModelSubsector.TVItemID);
List <PCCSM.geo_stations_p> staQCList = (from c in staQCListAll
where c.secteur == sec
select c).ToList <PCCSM.geo_stations_p>();
int countSta = 0;
int totalCountsta = staQCList.Count;
foreach (PCCSM.geo_stations_p geoStat in staQCList)
{
if (Cancel)
{
return(false);
}
countSta += 1;
lblStatus2.Text = countSta + " of " + totalCountsta + " ... CreateRunsQC for " + sec;
Application.DoEvents();
using (PCCSM.pccsmEntities dbQC = new PCCSM.pccsmEntities())
{
Application.DoEvents();
bool IsActive = true;
if (geoStat.status != null)
{
IsActive = (geoStat.status.Substring(0, 1) == "i" ? false : true);
}
string MWQMSiteTVText = "0000".Substring(0, 4 - geoStat.station.ToString().Length) + geoStat.station.ToString();
TVItemModel tvItemMWQMSiteExist = (from c in tvItemMWQMSiteAll
where c.ParentID == tvItemModelSubsector.TVItemID &&
c.TVText == MWQMSiteTVText &&
c.TVType == TVTypeEnum.MWQMSite
select c).FirstOrDefault();
if (tvItemMWQMSiteExist == null)
{
tvItemMWQMSiteExist = tvItemService.PostAddChildTVItemDB(tvItemModelSubsector.TVItemID, MWQMSiteTVText, TVTypeEnum.MWQMSite);
if (!CheckModelOK <TVItemModel>(tvItemMWQMSiteExist))
{
return(false);
}
}
List <PCCSM.db_mesure> dbMesureList = (from m in dbMesureListAll
where m.id_geo_station_p == geoStat.id_geo_station_p
select m).ToList <PCCSM.db_mesure>();
foreach (PCCSM.db_mesure dbm in dbMesureList)
{
Application.DoEvents();
// getting Runs
PCCSM.db_tournee dbt = (from t in dbtAll
where t.ID_Tournee == dbm.id_tournee
select t).FirstOrDefault();
DateTime?SampDateTime = null;
DateTime?SampStartDateTime = null;
DateTime?SampEndDateTime = null;
if (dbm.hre_echantillonnage != null)
{
SampDateTime = (DateTime)dbm.hre_echantillonnage.Value.AddHours(1);
if (dbt.hre_fin != null)
{
SampEndDateTime = ((DateTime)dbt.date_echantillonnage).AddHours(dbt.hre_fin.Value.Hour).AddMinutes(dbt.hre_fin.Value.Minute).AddHours(1);
}
if (dbt.hre_deb != null)
{
SampStartDateTime = ((DateTime)dbt.date_echantillonnage).AddHours(dbt.hre_deb.Value.Hour).AddMinutes(dbt.hre_deb.Value.Minute).AddHours(1);
}
}
else
{
SampDateTime = (DateTime)dbt.date_echantillonnage;
if (dbt.hre_fin != null)
{
SampEndDateTime = ((DateTime)dbt.date_echantillonnage).AddHours(dbt.hre_fin.Value.Hour).AddMinutes(dbt.hre_fin.Value.Minute).AddHours(1);
SampDateTime = SampEndDateTime;
}
if (dbt.hre_deb != null)
{
SampStartDateTime = ((DateTime)dbt.date_echantillonnage).AddHours(dbt.hre_deb.Value.Hour).AddMinutes(dbt.hre_deb.Value.Minute).AddHours(1);
SampDateTime = SampStartDateTime;
}
}
DateTime DateRun = new DateTime(((DateTime)SampDateTime).Year, ((DateTime)SampDateTime).Month, ((DateTime)SampDateTime).Day);
MWQMRunModel mwqmRunModelNew = new MWQMRunModel()
{
SubsectorTVItemID = tvItemModelSubsector.TVItemID,
DateTime_Local = DateRun,
RunSampleType = SampleTypeEnum.Routine,
RunNumber = 1,
};
MWQMRunModel wqmRunModelExist = (from c in mwqmRunModelAll
where c.DateTime_Local == DateRun &&
c.RunSampleType == SampleTypeEnum.Routine &&
c.RunNumber == 1
select c).FirstOrDefault();
if (wqmRunModelExist == null)
{
string TVTextRun = DateRun.Year.ToString()
+ " " + (DateRun.Month > 9 ? DateRun.Month.ToString() : "0" + DateRun.Month.ToString())
+ " " + (DateRun.Day > 9 ? DateRun.Day.ToString() : "0" + DateRun.Day.ToString());
TVItemModel tvItemModelRunRet = (from c in tvItemMWQMRunAll
where c.ParentID == tvItemModelSubsector.TVItemID &&
c.TVText == TVTextRun
select c).FirstOrDefault();
if (tvItemModelRunRet == null)
{
richTextBoxStatus.AppendText($"{tvItemModelSubsector.TVText} --- { TVTextRun } adding TVText\r\n");
tvItemModelRunRet = tvItemService.PostAddChildTVItemDB(tvItemModelSubsector.TVItemID, TVTextRun, TVTypeEnum.MWQMRun);
if (!CheckModelOK <TVItemModel>(tvItemModelRunRet))
{
return(false);
}
tvItemMWQMRunAll.Add(tvItemModelRunRet);
}
// add the run in the DB
mwqmRunModelNew.MWQMRunTVItemID = tvItemModelRunRet.TVItemID;
mwqmRunModelNew.AnalyzeMethod = null;
mwqmRunModelNew.SampleCrewInitials = null;
mwqmRunModelNew.DateTime_Local = DateRun;
if (SampEndDateTime == null)
{
mwqmRunModelNew.EndDateTime_Local = null;
}
else
{
mwqmRunModelNew.EndDateTime_Local = (DateTime)SampEndDateTime;
}
if (SampStartDateTime == null)
{
mwqmRunModelNew.StartDateTime_Local = null;
}
else
{
mwqmRunModelNew.StartDateTime_Local = (DateTime)SampStartDateTime;
}
if (dbt.analyse_datetime == null)
{
mwqmRunModelNew.LabAnalyzeBath1IncubationStartDateTime_Local = null;
}
else
{
mwqmRunModelNew.LabAnalyzeBath1IncubationStartDateTime_Local = dbt.analyse_datetime;
}
if (dbt.hre_recep_lab == null)
{
mwqmRunModelNew.LabReceivedDateTime_Local = null;
}
else
{
mwqmRunModelNew.LabReceivedDateTime_Local = dbt.hre_recep_lab;
}
mwqmRunModelNew.Laboratory = null;
mwqmRunModelNew.SampleMatrix = null;
if (dbt.mer_etat_fin == null)
{
mwqmRunModelNew.SeaStateAtEnd_BeaufortScale = null;
}
else
{
mwqmRunModelNew.SeaStateAtEnd_BeaufortScale = (BeaufortScaleEnum)dbt.mer_etat_fin;
}
if (dbt.mer_etat == null)
{
mwqmRunModelNew.SeaStateAtStart_BeaufortScale = null;
}
else
{
mwqmRunModelNew.SeaStateAtStart_BeaufortScale = (BeaufortScaleEnum)dbt.mer_etat;
}
mwqmRunModelNew.SampleStatus = null;
if (dbt.temp_glace_recep == null)
{
mwqmRunModelNew.TemperatureControl1_C = null;
}
else
{
mwqmRunModelNew.TemperatureControl1_C = (float)dbt.temp_glace_recep;
}
mwqmRunModelNew.SubsectorTVItemID = tvItemModelSubsector.TVItemID;
if (dbt.validation_datetime == null)
{
mwqmRunModelNew.LabRunSampleApprovalDateTime_Local = null;
}
else
{
mwqmRunModelNew.LabRunSampleApprovalDateTime_Local = dbt.validation_datetime;
}
if (dbt.validation == null)
{
mwqmRunModelNew.LabSampleApprovalContactTVItemID = null;
}
else
{
mwqmRunModelNew.LabSampleApprovalContactTVItemID = null; // 1; // this will be changed in the future to reflect the actuall UserInfoID
}
if (dbt.niveau_eau == null)
{
mwqmRunModelNew.WaterLevelAtBrook_m = null;
}
else
{
mwqmRunModelNew.WaterLevelAtBrook_m = (double)dbt.niveau_eau;
}
if (dbt.vague_hauteur_fin == null)
{
mwqmRunModelNew.WaveHightAtEnd_m = null;
}
else
{
mwqmRunModelNew.WaveHightAtEnd_m = dbt.vague_hauteur_fin;
}
if (dbt.vague_hauteur == null)
{
mwqmRunModelNew.WaveHightAtStart_m = null;
}
else
{
mwqmRunModelNew.WaveHightAtStart_m = dbt.vague_hauteur;
}
string TextEN = "--";
if (!string.IsNullOrWhiteSpace(dbt.commentaire))
{
TextEN = dbt.commentaire.Trim();
}
if (dbt.precipit == null)
{
mwqmRunModelNew.RainDay1_mm = null;
}
else
{
mwqmRunModelNew.RainDay1_mm = dbt.precipit;
}
if (dbt.precipit_3jant == null)
{
mwqmRunModelNew.RainDay3_mm = null;
}
else
{
mwqmRunModelNew.RainDay3_mm = dbt.precipit_3jant;
}
mwqmRunModelNew.Tide_Start = TideTextEnum.MidTide;
if (dbt.maree_principale != null)
{
if (dbt.maree_principale == 594)
{
mwqmRunModelNew.Tide_Start = TideTextEnum.LowTide;
}
else if (dbt.maree_principale == 593)
{
mwqmRunModelNew.Tide_Start = TideTextEnum.HighTide;
}
else
{
}
}
mwqmRunModelNew.Tide_End = mwqmRunModelNew.Tide_Start;
mwqmRunModelNew.AnalyzeMethod = null;
if (dbt.cf_methode_analytique != null)
{
switch (dbt.cf_methode_analytique.Value.ToString())
{
case "0":
{
mwqmRunModelNew.AnalyzeMethod = AnalyzeMethodEnum.ZZ_0Q;
}
break;
case "509":
{
mwqmRunModelNew.AnalyzeMethod = AnalyzeMethodEnum.ZZ_509Q;
}
break;
case "510":
{
mwqmRunModelNew.AnalyzeMethod = AnalyzeMethodEnum.ZZ_510Q;
}
break;
case "525":
{
mwqmRunModelNew.AnalyzeMethod = AnalyzeMethodEnum.ZZ_525Q;
}
break;
default:
break;
}
}
mwqmRunModelNew.SampleMatrix = SampleMatrixEnum.MPNQ;
mwqmRunModelNew.Laboratory = null;
if (dbt.laboratoire_operateur_id != null)
{
switch (dbt.laboratoire_operateur_id.ToString())
{
case "1":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_0;
}
break;
case "2":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_1;
}
break;
case "3":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_2;
}
break;
case "4":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_3;
}
break;
case "5":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_4;
}
break;
case "6":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_1Q;
}
break;
case "7":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_2Q;
}
break;
case "8":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_3Q;
}
break;
case "9":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_4Q;
}
break;
case "10":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_5Q;
}
break;
case "11":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_11BC;
}
break;
case "12":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_12BC;
}
break;
case "14":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_14BC;
}
break;
case "15":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_15BC;
}
break;
case "16":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_16BC;
}
break;
case "17":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_17BC;
}
break;
case "18":
{
mwqmRunModelNew.Laboratory = LaboratoryEnum.ZZ_18BC;
}
break;
default:
break;
}
}
// Doing Status
mwqmRunModelNew.SampleStatus = null;
if (dbt.status != null)
{
if (dbt.status == 11)
{
mwqmRunModelNew.SampleStatus = SampleStatusEnum.Active;
}
else if (dbt.status == 606)
{
mwqmRunModelNew.SampleStatus = SampleStatusEnum.Archived;
}
else
{
}
}
if (mwqmRunModelNew.StartDateTime_Local > mwqmRunModelNew.EndDateTime_Local)
{
mwqmRunModelNew.EndDateTime_Local = mwqmRunModelNew.StartDateTime_Local;
}
MWQMRunModel mwqmRunModel = (from c in mwqmRunModelAll
where c.SubsectorTVItemID == tvItemModelSubsector.TVItemID &&
c.MWQMRunTVText == TVTextRun &&
c.RunSampleType == mwqmRunModelNew.RunSampleType
select c).FirstOrDefault();
if (mwqmRunModel == null)
{
richTextBoxStatus.AppendText($"{tvItemModelSubsector.TVText} --- { TVTextRun } adding MWQMRun\r\n");
MWQMRunModel mwqmRunModelRet = mwqmRunService.PostAddMWQMRunDB(mwqmRunModelNew);
if (!CheckModelOK <MWQMRunModel>(mwqmRunModelRet))
{
return(false);
}
mwqmRunModelAll.Add(mwqmRunModelRet);
}
}
}
}
}
}
return(true);
}
