public TVItemModel PictureFileUploadDB(HttpRequestBase Request)
{
string AdminEmail = Request.QueryString["e"];
int TVItemID = int.Parse(Request.QueryString["t"]);
IPrincipal user = new GenericPrincipal(new GenericIdentity(AdminEmail, "Forms"), null);
ContactService contactService = new ContactService(LanguageRequest, user);
ContactModel contactModel = contactService.GetContactModelWithLoginEmailDB(AdminEmail);
if (!string.IsNullOrWhiteSpace(contactModel.Error))
{
return(new TVItemModel()
{
Error = "ERROR: " + string.Format(ServiceRes.NoUserWithEmail_, AdminEmail)
});
}
TVItemService tvItemService = new TVItemService(LanguageRequest, user);
TVFileService tvFileService = new TVFileService(LanguageRequest, user);
List <string> AllowableExt = tvFileService.GetAllowableExt();
TVFileModel tvFileModelRet = new TVFileModel();
using (TransactionScope ts = new TransactionScope())
{
string FileName = "";
if (Request.Files.Count != 1)
{
return new TVItemModel()
{
Error = "ERROR: " + ServiceRes.CanOnlyLoadOneFileAtATime
}
}
;
HttpPostedFileBase hpf = null;
foreach (string file in Request.Files)
{
hpf = Request.Files[file];
}
if (hpf == null)
{
return new TVItemModel()
{
Error = "ERROR: " + ServiceRes.PleaseSelectAFileToUpload
}
}
;
FileName = hpf.FileName;
FileInfo fi = new FileInfo(FileName);
if (!AllowableExt.Contains(fi.Extension.ToLower()))
{
string AllowableExtText = "";
foreach (string s in AllowableExt)
{
AllowableExtText += s + " ";
}
return(new TVItemModel()
{
Error = "ERROR: " + string.Format(ServiceRes.PleaseSelectAFileOfType_, AllowableExtText)
});
}
string ServerFileName = "";
if (FileName.Contains(@"\"))
{
ServerFileName = FileName.Substring(FileName.LastIndexOf(@"\") + 1);
}
else
{
ServerFileName = FileName;
}
TVItemModel tvItemModelPSS = tvItemService.GetTVItemModelWithTVItemIDDB(TVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelPSS.Error))
{
return(new TVItemModel()
{
Error = "ERROR: " + tvItemModelPSS.Error
});
}
TVItemModel tvItemModelExist = tvItemService.GetChildTVItemModelWithParentIDAndTVTextAndTVTypeDB(tvItemModelPSS.TVItemID, ServerFileName, TVTypeEnum.File);
if (string.IsNullOrEmpty(tvItemModelExist.Error))
{
return(new TVItemModel()
{
Error = "ERROR: " + string.Format(ServiceRes._AlreadyExists, ServerFileName)
});
}
TVItemModel tvItemModelTVFileRet = tvItemService.PostAddChildTVItemDB(tvItemModelPSS.TVItemID, ServerFileName, TVTypeEnum.File);
if (!string.IsNullOrEmpty(tvItemModelTVFileRet.Error))
{
return(new TVItemModel()
{
Error = "ERROR: " + tvItemModelTVFileRet.Error
});
}
string ServerFilePath = tvFileService.GetServerFilePath(tvItemModelPSS.TVItemID);
int FileLength = hpf.ContentLength;
DirectoryInfo di = new DirectoryInfo(ServerFilePath);
if (!di.Exists)
{
di.Create();
}
fi = new FileInfo(ServerFilePath + ServerFileName);
if (fi.Exists)
{
return(new TVItemModel()
{
Error = "ERROR: " + string.Format(ServiceRes.File_AlreadyExist, ServerFileName)
});
}
hpf.SaveAs(fi.FullName);
FileTypeEnum fileType = tvFileService.GetFileType(fi.Extension.ToUpper());
TVFileModel tvFileModelNew = new TVFileModel()
{
TVFileTVItemID = tvItemModelTVFileRet.TVItemID,
FilePurpose = FilePurposeEnum.Picture,
FileDescription = "Temp description",
FileType = fileType,
FileSize_kb = Math.Max(hpf.ContentLength / 1024, 1),
FileInfo = "Uploaded file",
FileCreatedDate_UTC = DateTime.Now,
FromWater = false,
ClientFilePath = FileName,
ServerFileName = ServerFileName,
ServerFilePath = ServerFilePath,
Language = LanguageEnum.en,
Year = DateTime.Now.Year,
};
tvFileModelRet = tvFileService.PostAddTVFileDB(tvFileModelNew);
if (!string.IsNullOrWhiteSpace(tvFileModelRet.Error))
{
DeleteFileFromServer(fi);
{
return(new TVItemModel()
{
Error = "ERROR: " + tvFileModelRet.Error
});
}
}
ts.Complete();
}
return(new TVItemModel()
{
Error = tvFileModelRet.TVFileTVItemID.ToString()
});
}
private bool GenerateKMZ()
{
string NotUsed = "";
//StringBuilder sbKMZ = new StringBuilder();
//DateTime CD = DateTime.Now;
//string Language = "_" + _TaskRunnerBaseService._BWObj.appTaskModel.Language;
//string DateText = "_" + CD.Year.ToString() +
// "_" + (CD.Month > 9 ? CD.Month.ToString() : "0" + CD.Month.ToString()) +
// "_" + (CD.Day > 9 ? CD.Day.ToString() : "0" + CD.Day.ToString()) +
// "_" + (CD.Hour > 9 ? CD.Hour.ToString() : "0" + CD.Hour.ToString()) +
// "_" + (CD.Minute > 9 ? CD.Minute.ToString() : "0" + CD.Minute.ToString());
switch (reportTypeModel.TVType)
{
case TVTypeEnum.MikeScenario:
break;
case TVTypeEnum.Subsector:
break;
default:
break;
}
//if (!RenameStartOfFileNameKMZ(fi))
//{
// return false;
//}
fi = new FileInfo(fi.FullName.Replace(".html", ".kml"));
if (fi.Exists)
{
try
{
fi.Delete();
fi = new FileInfo(fi.FullName);
}
catch (Exception ex)
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotDeleteFile_Error_, fi.FullName, ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""));
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("CouldNotDeleteFile_Error_", fi.FullName, ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""));
return(false);
}
}
switch (reportTypeModel.TVType)
{
case TVTypeEnum.Root:
{
if (!GenerateKMZRoot())
{
return(false);
}
}
break;
case TVTypeEnum.Area:
case TVTypeEnum.Country:
case TVTypeEnum.Infrastructure:
case TVTypeEnum.MikeScenario:
{
if (!GenerateKMZMikeScenario())
{
return(false);
}
}
break;
case TVTypeEnum.MikeSource:
case TVTypeEnum.Municipality:
case TVTypeEnum.MWQMSite:
case TVTypeEnum.PolSourceSite:
case TVTypeEnum.Province:
case TVTypeEnum.Sector:
case TVTypeEnum.Subsector:
{
if (!GenerateKMZSubsector())
{
return(false);
}
}
break;
case TVTypeEnum.BoxModel:
case TVTypeEnum.VisualPlumesScenario:
if (!GenerateKMZNotImplemented())
{
return(false);
}
break;
default:
break;
}
DirectoryInfo di = new DirectoryInfo(fi.DirectoryName);
if (!di.Exists)
{
try
{
di.Create();
}
catch (Exception ex)
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotCreateDirectory__, di.FullName, ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""));
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("CouldNotCreateDirectory__", di.FullName, ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""));
return(false);
}
}
StreamWriter sw = fi.CreateText();
sw.Write(sb.ToString());
sw.Flush();
sw.Close();
fi = new FileInfo(fi.FullName);
if (!fi.Exists)
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFindFile_, fi.FullName);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("CouldNotFindFile_", fi.FullName);
return(false);
}
//ProcessStartInfo pZip = new ProcessStartInfo();
//pZip.Arguments = "a -tzip \"" + fi.FullName.Replace(".kml", ".kmz") + "\" \"" + fi.FullName + "\"";
//pZip.RedirectStandardInput = true;
//pZip.UseShellExecute = false;
//pZip.CreateNoWindow = true;
//pZip.WindowStyle = ProcessWindowStyle.Hidden;
//Process processZip = new Process();
//processZip.StartInfo = pZip;
//try
//{
// pZip.FileName = @"C:\Program Files\7-Zip\7z.exe";
// processZip.Start();
//}
//catch (Exception ex)
//{
// NotUsed = string.Format(TaskRunnerServiceRes.CompressKMLDidNotWorkWith7zError_, ex.Message);
// _TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("CompressKMLDidNotWorkWith7zError_", ex.Message);
// return false;
//}
//while (!processZip.HasExited)
//{
// // waiting for the processZip to finish then continue
//}
//fi = new FileInfo(fi.FullName);
//if (fi.Exists)
//{
// try
// {
// //fi.Delete();
// }
// catch (Exception ex)
// {
// NotUsed = string.Format(TaskRunnerServiceRes.CouldNotDeleteFile_Error_, fi.FullName, ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""));
// _TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("CouldNotDeleteFile_Error_", fi.FullName, ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""));
// return false;
// }
//}
//fi = new FileInfo(fi.FullName.Replace(".kml", ".kmz"));
//if (!fi.Exists)
//{
// NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFindFile_, fi.FullName);
// _TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat1List("CouldNotFindFile_", fi.FullName);
// return false;
//}
TVFileService tvFileService = new TVFileService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemModel tvItemModel = tvItemService.PostAddChildTVItemDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID, fi.Name.Replace(fi.Extension, ""), TVTypeEnum.File);
if (!string.IsNullOrWhiteSpace(tvItemModel.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotAdd_Error_, TaskRunnerServiceRes.TVItem, _TaskRunnerBaseService._BWObj.appTaskModel.TVItemID.ToString());
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("CouldNotAdd_Error_", TaskRunnerServiceRes.TVItem, _TaskRunnerBaseService._BWObj.appTaskModel.TVItemID.ToString());
return(false);
}
TVFileModel tvFileModelNew = new TVFileModel();
tvFileModelNew.TVFileTVItemID = tvItemModel.TVItemID;
tvFileModelNew.TemplateTVType = 0;
tvFileModelNew.ReportTypeID = reportTypeModel.ReportTypeID;
tvFileModelNew.Parameters = Parameters;
tvFileModelNew.ServerFileName = fi.Name;
tvFileModelNew.FilePurpose = FilePurposeEnum.ReportGenerated;
tvFileModelNew.Language = _TaskRunnerBaseService._BWObj.appTaskModel.Language;
tvFileModelNew.Year = DateTime.Now.Year;
tvFileModelNew.FileDescription = reportTypeModel.Description;
tvFileModelNew.FileType = tvFileService.GetFileType(fi.Extension);
tvFileModelNew.FileSize_kb = (((int)fi.Length / 1024) == 0 ? 1 : (int)fi.Length / 1024);
tvFileModelNew.FileInfo = TaskRunnerServiceRes.FileName + "[" + fi.Name + "]\r\n" + TaskRunnerServiceRes.FileType + "[" + fi.Extension + "]\r\n";
tvFileModelNew.FileCreatedDate_UTC = fi.LastWriteTimeUtc;
tvFileModelNew.ServerFilePath = (fi.DirectoryName + @"\").Replace(@"C:\", @"E:\");
tvFileModelNew.LastUpdateDate_UTC = DateTime.UtcNow;
tvFileModelNew.LastUpdateContactTVItemID = _TaskRunnerBaseService._BWObj.appTaskModel.LastUpdateContactTVItemID;
TVFileModel tvFileModelRet = tvFileService.PostAddTVFileDB(tvFileModelNew);
if (!string.IsNullOrWhiteSpace(tvFileModelRet.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotAdd_Error_, TaskRunnerServiceRes.TVFile, tvFileModelRet.Error);
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat2List("CouldNotAdd_Error_", TaskRunnerServiceRes.TVFile, tvFileModelRet.Error);
return(false);
}
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);
}