public void MWQMRunLanguageService_PostAddMWQMRunLanguageDB_Add_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
using (ShimsContext.Create())
{
SetupShim();
LanguageEnum LangToAdd = LanguageEnum.es;
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
//string ErrorText = "ErrorText";
shimMWQMRunLanguageService.FillMWQMRunLanguageMWQMRunLanguageMWQMRunLanguageModelContactOK = (a, b, c) =>
{
return("");
};
MWQMRunLanguageModel mwqmRunLanguageModelRet = mwqmRunLanguageService.PostAddMWQMRunLanguageDB(mwqmRunLanguageModelNew);
Assert.IsTrue(mwqmRunLanguageModelRet.Error.StartsWith(string.Format(ServiceRes.CouldNotAddError_, "").Substring(0, 10)));
}
}
}
}
public void MWQMRunLanguageService_PostAddMWQMRunLanguageDB_GetMWQMRunLanguageModelWithMWQMRunIDAndLanguageDB_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
using (ShimsContext.Create())
{
SetupShim();
LanguageEnum LangToAdd = LanguageEnum.es;
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
//string ErrorText = "ErrorText";
shimMWQMRunLanguageService.GetMWQMRunLanguageModelWithMWQMRunIDAndLanguageDBInt32LanguageEnum = (a, b) =>
{
return(new MWQMRunLanguageModel()
{
Error = ""
});
};
MWQMRunLanguageModel mwqmRunLanguageModelRet = mwqmRunLanguageService.PostAddMWQMRunLanguageDB(mwqmRunLanguageModelNew);
Assert.AreEqual(string.Format(ServiceRes._AlreadyExists, ServiceRes.MWQMRunLanguage), mwqmRunLanguageModelRet.Error);
}
}
}
}
public void MWQMRunLanguageService_FillMWQMRunLanguage_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
ContactOK contactOK = mwqmRunLanguageService.IsContactOK();
string retStr = mwqmRunLanguageService.FillMWQMRunLanguage(mwqmRunLanguage, mwqmRunLanguageModelNew, contactOK);
Assert.AreEqual("", retStr);
Assert.AreEqual(contactOK.ContactTVItemID, mwqmRunLanguage.LastUpdateContactTVItemID);
contactOK = null;
retStr = mwqmRunLanguageService.FillMWQMRunLanguage(mwqmRunLanguage, mwqmRunLanguageModelNew, contactOK);
Assert.AreEqual("", retStr);
Assert.AreEqual(2, mwqmRunLanguage.LastUpdateContactTVItemID);
}
}
}
public void MWQMRunLanguageService_PostUpdateMWQMRunLanguageDB_GetMWQMRunLanguageWithMWQMRunIDAndLanguageDB_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMRunLanguageModel mwqmRunLanguageModelRet = AddMWQMRunLanguageModel(LangToAdd, mwqmRunModelRet);
using (ShimsContext.Create())
{
SetupShim();
FillMWQMRunLanguageModelUpdate(mwqmRunLanguageModelRet);
//string ErrorText = "ErrorText";
shimMWQMRunLanguageService.GetMWQMRunLanguageWithMWQMRunIDAndLanguageDBInt32LanguageEnum = (a, b) =>
{
return(null);
};
MWQMRunLanguageModel mwqmRunLanguageModelRet2 = mwqmRunLanguageService.PostUpdateMWQMRunLanguageDB(mwqmRunLanguageModelRet);
Assert.AreEqual(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.MWQMRunLanguage), mwqmRunLanguageModelRet2.Error);
}
}
}
}
public void MWQMRunLanguageService_PostDeleteMWQMRunLanguageDB_IsContactOK_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMRunLanguageModel mwqmRunLanguageModelRet = AddMWQMRunLanguageModel(LangToAdd, mwqmRunModelRet);
MWQMRunLanguageModel mwqmRunLanguageModelRet2 = UpdateMWQMRunLanguageModel(mwqmRunLanguageModelRet);
using (ShimsContext.Create())
{
SetupShim();
string ErrorText = "ErrorText";
shimMWQMRunLanguageService.IsContactOK = () =>
{
return(new ContactOK()
{
Error = ErrorText
});
};
MWQMRunLanguageModel mwqmRunLanguageModelRet3 = mwqmRunLanguageService.PostDeleteMWQMRunLanguageDB(mwqmRunLanguageModelRet2.MWQMRunID, LangToAdd);
Assert.AreEqual(ErrorText, mwqmRunLanguageModelRet3.Error);
}
}
}
}
public PartialViewResult _mwqmRun(string Q)
{
SetArgs(Q);
ViewBag.URLModel = urlModel;
ViewBag.MWQMController = _MWQMController;
ViewBag.SamplingContactTVText = null;
ViewBag.ValidatorContactTVText = null;
MWQMRunModel mwqmRunModel = _MWQMRunService.GetMWQMRunModelWithMWQMRunTVItemIDDB(urlModel.TVItemIDList[0]);
ViewBag.MWQMRunModel = mwqmRunModel;
if (mwqmRunModel.LabSampleApprovalContactTVItemID > 0)
{
TVItemModel tvItemModel = _TVItemService.GetTVItemModelWithTVItemIDDB((int)mwqmRunModel.LabSampleApprovalContactTVItemID);
ViewBag.ValidatorContactTVText = tvItemModel.TVText;
}
List <MWQMSampleModel> mwqmSampleModelList = _MWQMSampleService.GetMWQMSampleModelListWithMWQMRunTVItemIDDB(urlModel.TVItemIDList[0]);
ViewBag.MWQMSampleModelList = mwqmSampleModelList;
ViewBag.IsShowMoreInfo = (GetURLVarShowEnumStr(URLVarShowEnum.ShowMoreInfo) == "0" ? false : true);
ViewBag.IsShowMap = (GetURLVarShowEnumStr(URLVarShowEnum.ShowMap) == "0" ? false : true);
return(PartialView());
}
public void MWQMRunLanguageService_PostUpdateMWQMRunLanguageDB_DoUpdateChanges_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMRunLanguageModel mwqmRunLanguageModelRet = AddMWQMRunLanguageModel(LangToAdd, mwqmRunModelRet);
using (ShimsContext.Create())
{
SetupShim();
FillMWQMRunLanguageModelUpdate(mwqmRunLanguageModelRet);
string ErrorText = "ErrorText";
shimMWQMRunLanguageService.DoUpdateChanges = () =>
{
return(ErrorText);
};
MWQMRunLanguageModel mwqmRunLanguageModelRet2 = mwqmRunLanguageService.PostUpdateMWQMRunLanguageDB(mwqmRunLanguageModelRet);
Assert.AreEqual(ErrorText, mwqmRunLanguageModelRet2.Error);
}
}
}
}
public void MWQMRunLanguageService_PostAddMWQMRunLanguageDB_MWQMRunModelOK_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
using (ShimsContext.Create())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
string ErrorText = "ErrorText";
ShimMWQMRunLanguageService shimMWQMRunLanguageService = new ShimMWQMRunLanguageService(mwqmRunLanguageService);
shimMWQMRunLanguageService.MWQMRunLanguageModelOKMWQMRunLanguageModel = (a) =>
{
return(ErrorText);
};
MWQMRunLanguageModel mwqmRunLanguageModelRet = mwqmRunLanguageService.PostAddMWQMRunLanguageDB(mwqmRunLanguageModelNew);
Assert.AreEqual(ErrorText, mwqmRunLanguageModelRet.Error);
}
}
}
}
private void FillMWQMRunLanguageModelNew(LanguageEnum Language, MWQMRunModel mwqmRunModel, MWQMRunLanguageModel mwqmRunLanguageModel)
{
mwqmRunLanguageModel.MWQMRunID = mwqmRunModel.MWQMRunID;
mwqmRunLanguageModel.MWQMRunComment = randomService.RandomString("MWQMRunName", 30);
mwqmRunLanguageModel.Language = Language;
mwqmRunLanguageModel.TranslationStatus = TranslationStatusEnum.Translated;
Assert.IsTrue(mwqmRunLanguageModel.MWQMRunID != 0);
Assert.IsTrue(mwqmRunLanguageModel.MWQMRunComment.Length == 30);
Assert.IsTrue(mwqmRunLanguageModel.Language == Language);
Assert.IsTrue(mwqmRunLanguageModel.TranslationStatus == TranslationStatusEnum.Translated);
}
public PartialViewResult _selectedRunPrecipitation(int SubsectorTVItemID, int MWQMRunTVItemID)
{
ViewBag.ClimateSitesAndRainsList = null;
ViewBag.MWQMRunModel = null;
ViewBag.SubsectorTVItemID = SubsectorTVItemID;
ViewBag.MWQMRunTVItemID = MWQMRunTVItemID;
ViewBag.UseOfSiteModelList = null;
ViewBag.ATL_PYR = "";
ViewBag.MWQMSubsectorClimateSites = null;
TVAuthEnum tvAuth = _TVItemService.GetTVAuthWithTVItemIDAndLoggedInUser(urlModel.TVItemIDList[0], null, null, null);
ViewBag.TVAuth = tvAuth;
ViewBag.IsShowMap = (GetURLVarShowEnumStr(URLVarShowEnum.ShowMap) == "0" ? false : true);
MWQMRunModel mwqmRunModel = _MWQMSubsectorService._MWQMRunService.GetMWQMRunModelWithMWQMRunTVItemIDDB(MWQMRunTVItemID);
ViewBag.MWQMRunModel = mwqmRunModel;
List <ClimateSitesAndRains> climateSiteAndRainsList = _MWQMSubsectorService.GetMWQMSubsectorClimateSitesAndValuesForAParicularRunsDB(SubsectorTVItemID, MWQMRunTVItemID);
ViewBag.ClimateSitesAndRainsList = climateSiteAndRainsList;
List <UseOfSiteModel> useOfSiteModelList = _UseOfSiteService.GetUseOfSiteModelListWithTVTypeAndSubsectorTVItemIDDB(TVTypeEnum.ClimateSite, SubsectorTVItemID);
ViewBag.UseOfSiteModelList = useOfSiteModelList;
if (useOfSiteModelList.Count > 0)
{
List <MapInfoPointModel> mapInfoPointModelList = _MapInfoService._MapInfoPointService.GetMapInfoPointModelListWithTVItemIDAndTVTypeAndMapInfoDrawTypeDB(useOfSiteModelList[0].SiteTVItemID, TVTypeEnum.ClimateSite, MapInfoDrawTypeEnum.Point);
if (mapInfoPointModelList.Count > 0)
{
if (mapInfoPointModelList[0].Lng < -100)
{
ViewBag.ATL_PYR = "PYR";
}
else
{
ViewBag.ATL_PYR = "ATL";
}
}
}
MWQMSubsectorClimateSites mwqmSubsectorClimateSites = _MWQMSubsectorService.GetMWQMSubsectorClimateSitesDB(SubsectorTVItemID, 1);
ViewBag.MWQMSubsectorClimateSites = mwqmSubsectorClimateSites;
return(PartialView());
}
public JsonResult GetMWQMRunTVItemIDWithMWQMSiteTVItemIDAndRunDateJSON(int MWQMSiteTVItemID, int Year, int Month, int Day)
{
DateTime RunDate = new DateTime(Year, Month, Day);
int MWQMRunTVItemID = 0;
TVItemModel tvItemModelMWQMSite = _TVItemService.GetTVItemModelWithTVItemIDDB(MWQMSiteTVItemID);
if (string.IsNullOrWhiteSpace(tvItemModelMWQMSite.Error))
{
MWQMRunModel mwqmRunModel = _MWQMRunService.GetMWQMRunModelWithSubsectorTVItemIDAndRunDateDB(tvItemModelMWQMSite.ParentID, RunDate).FirstOrDefault();
if (string.IsNullOrWhiteSpace(tvItemModelMWQMSite.Error))
{
MWQMRunTVItemID = mwqmRunModel.MWQMRunTVItemID;
}
}
return(Json(MWQMRunTVItemID, JsonRequestBehavior.AllowGet));
}
private MWQMRunLanguageModel AddMWQMRunLanguageModel(LanguageEnum LangToAdd, MWQMRunModel mwqmRunModel)
{
MWQMRunLanguageModel mwqmRunLanguageModelNew = new MWQMRunLanguageModel();
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModel, mwqmRunLanguageModelNew);
MWQMRunLanguageModel mwqmRunLanguagModelRet = mwqmRunLanguageService.PostAddMWQMRunLanguageDB(mwqmRunLanguageModelNew);
if (!string.IsNullOrWhiteSpace(mwqmRunLanguagModelRet.Error))
{
return(mwqmRunLanguagModelRet);
}
Assert.IsNotNull(mwqmRunLanguagModelRet);
CompareMWQMRunLanguageModels(mwqmRunLanguageModelNew, mwqmRunLanguagModelRet);
return(mwqmRunLanguagModelRet);
}
public JsonResult MWQMRunDeleteJSON(int MWQMRunTVItemID)
{
int count = _MWQMSampleService.GetMWQMSampleModelListWithMWQMRunTVItemIDDB(MWQMRunTVItemID).Count();
string retStr = "";
if (count > 0)
{
retStr = ControllerRes.AllMWQMSamplesNeedsToBeDeletedBeforeDeletingTheRun;
}
else
{
MWQMRunModel mwqmRunModel = _MWQMRunService.PostDeleteMWQMRunTVItemIDDB(MWQMRunTVItemID);
retStr = mwqmRunModel.Error;
}
return(Json(retStr, JsonRequestBehavior.AllowGet));
}
public void MWQMRunLanguageService_GetMWQMRunModelCountDB_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMRunLanguageModel mwqmRunModelLanguageRet = AddMWQMRunLanguageModel(LangToAdd, mwqmRunModelRet);
int mwqmRunCount = mwqmRunLanguageService.GetMWQMRunLanguageModelCountDB();
Assert.AreEqual(testDBService.Count + 3, mwqmRunCount);
}
}
}
public void MWQMRunLanguageService_PostAddMWQMRunLanguageDB_Good_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMRunLanguageModel mwqmRunLanguageModelRet = AddMWQMRunLanguageModel(LangToAdd, mwqmRunModelRet);
MWQMRunLanguageModel mwqmRunLanguageModelRet2 = UpdateMWQMRunLanguageModel(mwqmRunLanguageModelRet);
MWQMRunLanguageModel mwqmRunLanguageModelRet3 = mwqmRunLanguageService.PostDeleteMWQMRunLanguageDB(mwqmRunLanguageModelRet2.MWQMRunID, LangToAdd);
Assert.AreEqual("", mwqmRunLanguageModelRet3.Error);
}
}
}
public void MWQMRunLanguageService_GetMWQMRunLanguageWithMWQMRunIDAndLanguageDB_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMRunLanguageModel mwqmRunLanguageModelRet = AddMWQMRunLanguageModel(LangToAdd, mwqmRunModelRet);
MWQMRunLanguage mwqmRunLanguageRet2 = mwqmRunLanguageService.GetMWQMRunLanguageWithMWQMRunIDAndLanguageDB(mwqmRunLanguageModelRet.MWQMRunID, LangToAdd);
Assert.AreEqual(mwqmRunLanguageModelRet.MWQMRunID, mwqmRunLanguageRet2.MWQMRunID);
Assert.AreEqual(mwqmRunLanguageModelRet.Language, (LanguageEnum)mwqmRunLanguageRet2.Language);
Assert.AreEqual(LangToAdd, (LanguageEnum)mwqmRunLanguageRet2.Language);
}
}
}
public PartialViewResult _mwqmRunAddOrModify(int MWQMRunTVItemID, int SubsectorTVItemID)
{
ViewBag.MWQMController = _MWQMController;
ViewBag.SubsectorTVItemID = SubsectorTVItemID;
ViewBag.SamplingContactTVText = null;
ViewBag.ValidatorContactTVText = null;
ViewBag.TVItemModelContactLabValidatorOptionList = null;
MWQMRunModel mwqmRunModel = _MWQMRunService.GetMWQMRunModelWithMWQMRunTVItemIDDB(MWQMRunTVItemID);
ViewBag.MWQMRunModel = mwqmRunModel;
TVItemModel tvItemModelMWQMrun = _TVItemService.GetTVItemModelWithTVItemIDDB(MWQMRunTVItemID);
if (mwqmRunModel.LabSampleApprovalContactTVItemID > 0)
{
TVItemModel tvItemModel = _TVItemService.GetTVItemModelWithTVItemIDDB((int)mwqmRunModel.LabSampleApprovalContactTVItemID);
ViewBag.ValidatorContactTVText = tvItemModel.TVText;
}
List <MWQMSampleModel> mwqmSampleModelList = _MWQMSampleService.GetMWQMSampleModelListWithMWQMRunTVItemIDDB(MWQMRunTVItemID);
ViewBag.MWQMSampleModelList = mwqmSampleModelList;
TVItemModel tvItemModelRoot = _TVItemService.GetRootTVItemModelDB();
if (string.IsNullOrWhiteSpace(tvItemModelRoot.Error))
{
List <TVItemModel> tvItemModelContactLabValidatorOptionList = _TVItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelRoot.TVItemID, TVTypeEnum.Contact);
ViewBag.TVItemModelContactLabValidatorOptionList = tvItemModelContactLabValidatorOptionList;
}
List <TVItemModel> tvItemModelMWQMSiteList = _TVItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(tvItemModelMWQMrun.ParentID, TVTypeEnum.MWQMSite);
ViewBag.TVItemModelMWQMSiteList = tvItemModelMWQMSiteList;
return(PartialView());
}
public void MWQMRunLanguageService_PostAddMWQMRunLanguageDB_UserEmailNotValidated_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
LanguageEnum LangToAdd = LanguageEnum.es;
ContactModel contactModelBad = contactModelListGood[2];
IPrincipal userBad = new GenericPrincipal(new GenericIdentity(contactModelBad.LoginEmail, "Forms"), null);
mwqmRunLanguageService = new MWQMRunLanguageService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), userBad);
MWQMRunLanguageModel mwqmRunLanguageModelRet = AddMWQMRunLanguageModel(LangToAdd, mwqmRunModelRet);
// Assert 1
Assert.AreEqual(ServiceRes.EmailRequiresValidation, mwqmRunLanguageModelRet.Error);
}
}
}
public JsonResult MWQMRunAddOrModifyJSON(FormCollection fc)
{
MWQMRunModel mwqmRunModel = _MWQMRunService.MWQMRunAddOrModifyDB(fc);
return(Json(mwqmRunModel, JsonRequestBehavior.AllowGet));
}
public PartialViewResult _LabSheetsHistoryDetail(int SamplingPlanID, int LabSheetID)
{
ViewBag.SamplingPlanController = _SamplingPlanController;
ViewBag.AdminContactModelList = null;
ViewBag.IsSamplingPlanner = false;
ViewBag.LabSheetModelAndA1Sheet = null;
ViewBag.AnalyzeMethod = AnalyzeMethodEnum.Error;
ViewBag.SampleMatrix = SampleMatrixEnum.Error;
ViewBag.Laboratory = LaboratoryEnum.Error;
ViewBag.MWQMSiteModelList = new List <MWQMSiteModel>();
SamplingPlanService SamplingPlanService = new SamplingPlanService(_TVItemService.LanguageRequest, _TVItemService.User);
LabSheetService labSheetService = new LabSheetService(_TVItemService.LanguageRequest, _TVItemService.User);
MWQMRunService mwqmRunService = new MWQMRunService(_TVItemService.LanguageRequest, _TVItemService.User);
MWQMSiteService mwqmSiteService = new MWQMSiteService(_TVItemService.LanguageRequest, _TVItemService.User);
ContactModel contactModel = _ContactService.GetContactLoggedInDB();
SamplingPlanModel SamplingPlanModel = SamplingPlanService.GetSamplingPlanModelWithSamplingPlanIDDB(SamplingPlanID);
if (string.IsNullOrWhiteSpace(SamplingPlanModel.Error))
{
ViewBag.IsSamplingPlanner = false;
if (contactModel.SamplingPlanner_ProvincesTVItemID.Contains(SamplingPlanModel.ProvinceTVItemID.ToString()))
{
ViewBag.IsSamplingPlanner = true;
}
else
{
List <ContactModel> adminContactModelList = _ContactService.GetAdminContactModelListDB();
ViewBag.AdminContactModelList = adminContactModelList;
}
LabSheetModel labSheetModel = labSheetService.GetLabSheetModelWithLabSheetIDDB(LabSheetID);
LabSheetModelAndA1Sheet labSheetModelAndA1Sheet = new LabSheetModelAndA1Sheet();
labSheetModelAndA1Sheet.LabSheetModel = labSheetModel;
labSheetModelAndA1Sheet.LabSheetA1Sheet = labSheetService.ParseLabSheetA1WithLabSheetID(labSheetModel.LabSheetID);
ViewBag.LabSheetModelAndA1Sheet = labSheetModelAndA1Sheet;
if (labSheetModel.MWQMRunTVItemID != null)
{
MWQMRunModel mwqmRunModel = mwqmRunService.GetMWQMRunModelWithMWQMRunTVItemIDDB((int)labSheetModel.MWQMRunTVItemID);
if (string.IsNullOrWhiteSpace(mwqmRunModel.Error))
{
if (mwqmRunModel.AnalyzeMethod != null)
{
ViewBag.AnalyzeMethod = (AnalyzeMethodEnum)mwqmRunModel.AnalyzeMethod;
}
if (mwqmRunModel.SampleMatrix != null)
{
ViewBag.SampleMatrix = (SampleMatrixEnum)mwqmRunModel.SampleMatrix;
}
if (mwqmRunModel.Laboratory != null)
{
ViewBag.Laboratory = (LaboratoryEnum)mwqmRunModel.Laboratory;
}
}
}
List <MWQMSiteModel> mwqmSiteModelList = mwqmSiteService.GetMWQMSiteModelListWithSubsectorTVItemIDDB(labSheetModelAndA1Sheet.LabSheetA1Sheet.SubsectorTVItemID);
ViewBag.MWQMSiteModelList = mwqmSiteModelList;
}
return(PartialView());
}
public PartialViewResult _LabSheetsTranferred(int SamplingPlanID)
{
ViewBag.SamplingPlanController = _SamplingPlanController;
ViewBag.AdminContactModelList = null;
ViewBag.IsSamplingPlanner = false;
ViewBag.LabSheetModelAndA1SheetList = null;
ViewBag.LastAnalyzeMethod = AnalyzeMethodEnum.Error;
ViewBag.LastSampleMatrix = SampleMatrixEnum.Error;
ViewBag.LastLaboratory = LaboratoryEnum.Error;
ViewBag.MWQMSampleModelList = new List <MWQMSampleModel>();
ViewBag.SubsectorMWQMSiteModelList = new List <SubsectorMWQMSiteModel>();
ViewBag.SamplingPlanModel = null;
ViewBag.LabSheetSiteMonitoredCountsList = null;
List <LabSheetModelAndA1Sheet> labSheetModelAndA1SheetList = new List <LabSheetModelAndA1Sheet>();
SamplingPlanService SamplingPlanService = new SamplingPlanService(_TVItemService.LanguageRequest, _TVItemService.User);
LabSheetService labSheetService = new LabSheetService(_TVItemService.LanguageRequest, _TVItemService.User);
MWQMRunService mwqmRunService = new MWQMRunService(_TVItemService.LanguageRequest, _TVItemService.User);
MWQMSampleService mwqmSampleService = new MWQMSampleService(_TVItemService.LanguageRequest, _TVItemService.User);
MWQMSiteService mwqmSiteService = new MWQMSiteService(_TVItemService.LanguageRequest, _TVItemService.User);
ContactModel contactModel = _ContactService.GetContactLoggedInDB();
SamplingPlanModel SamplingPlanModel = SamplingPlanService.GetSamplingPlanModelWithSamplingPlanIDDB(SamplingPlanID);
if (string.IsNullOrWhiteSpace(SamplingPlanModel.Error))
{
ViewBag.SamplingPlanModel = SamplingPlanModel;
ViewBag.IsSamplingPlanner = false;
if (contactModel.SamplingPlanner_ProvincesTVItemID.Contains(SamplingPlanModel.ProvinceTVItemID.ToString()))
{
ViewBag.IsSamplingPlanner = true;
}
else
{
List <ContactModel> adminContactModelList = _ContactService.GetAdminContactModelListDB();
ViewBag.AdminContactModelList = adminContactModelList;
}
List <LabSheetModel> labSheetModelList = labSheetService.GetLabSheetModelListWithSamplingPlanIDAndLabSheetStatusDB(SamplingPlanID, LabSheetStatusEnum.Transferred);
foreach (LabSheetModel labSheetModel in labSheetModelList)
{
LabSheetModelAndA1Sheet labSheetModelAndA1Sheet = new LabSheetModelAndA1Sheet();
labSheetModelAndA1Sheet.LabSheetModel = labSheetModel;
labSheetModelAndA1Sheet.LabSheetA1Sheet = labSheetService.ParseLabSheetA1WithLabSheetID(labSheetModel.LabSheetID);
labSheetModelAndA1SheetList.Add(labSheetModelAndA1Sheet);
}
ViewBag.LabSheetModelAndA1SheetList = labSheetModelAndA1SheetList;
if (labSheetModelAndA1SheetList.Count > 0)
{
MWQMRunModel mwqmRunModelLast = mwqmRunService.GetMWQMRunModelLastWithSubsectorTVItemIDDB(labSheetModelAndA1SheetList[0].LabSheetModel.SubsectorTVItemID);
if (string.IsNullOrWhiteSpace(mwqmRunModelLast.Error))
{
if (mwqmRunModelLast.AnalyzeMethod != null)
{
ViewBag.LastAnalyzeMethod = (AnalyzeMethodEnum)mwqmRunModelLast.AnalyzeMethod;
}
if (mwqmRunModelLast.SampleMatrix != null)
{
ViewBag.LastSampleMatrix = (SampleMatrixEnum)mwqmRunModelLast.SampleMatrix;
}
if (mwqmRunModelLast.Laboratory != null)
{
ViewBag.LastLaboratory = (LaboratoryEnum)mwqmRunModelLast.Laboratory;
}
}
}
List <MWQMSampleModel> mwqmSampleModelList = new List <MWQMSampleModel>();
foreach (LabSheetModelAndA1Sheet labSheetModelAndA1Sheet in labSheetModelAndA1SheetList)
{
int Year = 0;
int Month = 0;
int Day = 0;
if (int.TryParse(labSheetModelAndA1Sheet.LabSheetA1Sheet.RunYear, out Year))
{
if (int.TryParse(labSheetModelAndA1Sheet.LabSheetA1Sheet.RunMonth, out Month))
{
if (int.TryParse(labSheetModelAndA1Sheet.LabSheetA1Sheet.RunDay, out Day))
{
MWQMRunModel mwqmRunModelNew = new MWQMRunModel()
{
SubsectorTVItemID = labSheetModelAndA1Sheet.LabSheetA1Sheet.SubsectorTVItemID,
DateTime_Local = new DateTime(Year, Month, Day),
RunSampleType = labSheetModelAndA1Sheet.LabSheetA1Sheet.SampleType,
RunNumber = labSheetModelList[0].RunNumber,
};
MWQMRunModel mwqmRunModel = mwqmRunService.GetMWQMRunModelExistDB(mwqmRunModelNew);
if (string.IsNullOrWhiteSpace(mwqmRunModel.Error))
{
List <MWQMSampleModel> mwqmSampleModelList2 = mwqmSampleService.GetMWQMSampleModelListWithMWQMRunTVItemIDDB(mwqmRunModel.MWQMRunTVItemID);
foreach (MWQMSampleModel mwqmSampleModel in mwqmSampleModelList2)
{
mwqmSampleModelList.Add(mwqmSampleModel);
}
}
}
}
}
}
ViewBag.MWQMSampleModelList = mwqmSampleModelList;
if (labSheetModelAndA1SheetList.Count > 0)
{
List <SubsectorMWQMSiteModel> subsectorMWQMSiteModelList = new List <SubsectorMWQMSiteModel>();
foreach (LabSheetModelAndA1Sheet labSheetModelAndA1Sheet in labSheetModelAndA1SheetList)
{
List <MWQMSiteModel> mwqmSiteModelList = mwqmSiteService.GetMWQMSiteModelListWithSubsectorTVItemIDDB(labSheetModelAndA1Sheet.LabSheetA1Sheet.SubsectorTVItemID);
subsectorMWQMSiteModelList.Add(new SubsectorMWQMSiteModel()
{
Subsector = labSheetModelAndA1Sheet.LabSheetA1Sheet.SubsectorName, MWQMSiteModelList = mwqmSiteModelList
});
}
ViewBag.SubsectorMWQMSiteModelList = subsectorMWQMSiteModelList;
}
List <LabSheetSiteMonitoredCounts> labSheetSiteMonitoredCountsList = labSheetService.GetLabSheetIDListAndCountSamplesWithSamplingPlanIDDB(SamplingPlanID);
ViewBag.LabSheetSiteMonitoredCountsList = labSheetSiteMonitoredCountsList;
}
return(PartialView());
}
// Post
public MWQMSampleModel MWQMSampleAddOrModifyDB(FormCollection fc)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
int MWQMSampleID = 0;
int MWQMRunTVItemID = 0;
int MWQMSiteTVItemID = 0;
string SampleTime = "";
int Hour = 0;
int Minute = 0;
int FecCol_MPN_100ml = -1;
float? Salinity_PPT = 0.0f;
float? WaterTemp_C = 0.0f;
float? Depth_m = 0.0f;
float? PH = 0.0f;
string ProcessedBy = "";
bool UseForOpenData = false;
List <SampleTypeEnum> SampleTypeList = new List <SampleTypeEnum>()
{
SampleTypeEnum.Error
};
string MWQMSampleNote = "";
// MWQMSampleID
if (string.IsNullOrWhiteSpace(fc["MWQMSampleID"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMSampleID)));
}
int.TryParse(fc["MWQMSampleID"], out MWQMSampleID);
if (MWQMSampleID == 0)
{
// could be 0 if adding new
}
MWQMSampleModel mwqmSampleModelToChange = new MWQMSampleModel();
if (MWQMSampleID > 0)
{
mwqmSampleModelToChange = GetMWQMSampleModelWithMWQMSampleIDDB(MWQMSampleID);
if (!string.IsNullOrWhiteSpace(mwqmSampleModelToChange.Error))
{
return(ReturnError(mwqmSampleModelToChange.Error));
}
}
mwqmSampleModelToChange.DBCommand = DBCommandEnum.Original;
// MWQMRunTVItemID
if (string.IsNullOrWhiteSpace(fc["MWQMRunTVItemID"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMRunTVItemID)));
}
int.TryParse(fc["MWQMRunTVItemID"], out MWQMRunTVItemID);
if (MWQMRunTVItemID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMRunTVItemID)));
}
MWQMRunModel mwqmRunModel = _MWQMRunService.GetMWQMRunModelWithMWQMRunTVItemIDDB(MWQMRunTVItemID);
if (!string.IsNullOrWhiteSpace(mwqmRunModel.Error))
{
return(ReturnError(mwqmRunModel.Error));
}
mwqmSampleModelToChange.MWQMRunTVItemID = MWQMRunTVItemID;
// MWQMSiteTVItemID
if (string.IsNullOrWhiteSpace(fc["MWQMSiteTVItemID"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMSiteTVItemID)));
}
int.TryParse(fc["MWQMSiteTVItemID"], out MWQMSiteTVItemID);
if (MWQMSiteTVItemID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMSiteTVItemID)));
}
TVItemModel tvItemModelMWQMSite = _TVItemService.GetTVItemModelWithTVItemIDDB(MWQMSiteTVItemID);
if (!string.IsNullOrWhiteSpace(tvItemModelMWQMSite.Error))
{
return(ReturnError(tvItemModelMWQMSite.Error));
}
if (MWQMSampleID > 0) // modify
{
if (mwqmSampleModelToChange.MWQMSiteTVItemID != MWQMSiteTVItemID)
{
return(ReturnError(string.Format(ServiceRes._NotEqual, mwqmSampleModelToChange.MWQMSiteTVItemID + ", " + MWQMSiteTVItemID)));
}
}
mwqmSampleModelToChange.MWQMSiteTVItemID = MWQMSiteTVItemID;
// SampleTime
SampleTime = fc["SampleTime"];
if (string.IsNullOrWhiteSpace(SampleTime))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.SampleTime)));
}
else
{
if (SampleTime.Length != 5)
{
return(ReturnError(string.Format(ServiceRes.Time_NotWellFormed, SampleTime)));
}
if (SampleTime.Substring(2, 1) != ":")
{
return(ReturnError(string.Format(ServiceRes.Time_NotWellFormed, SampleTime)));
}
try
{
Hour = int.Parse(SampleTime.Substring(0, 2));
Minute = int.Parse(SampleTime.Substring(3, 2));
}
catch (Exception)
{
return(ReturnError(string.Format(ServiceRes.Time_NotWellFormed, SampleTime)));
}
if (Hour < 0 || Hour > 23)
{
return(ReturnError(string.Format(ServiceRes.Time_NotWellFormed, SampleTime)));
}
if (Minute < 0 || Minute > 59)
{
return(ReturnError(string.Format(ServiceRes.Time_NotWellFormed, SampleTime)));
}
DateTime SampleDate = new DateTime(mwqmRunModel.DateTime_Local.Year, mwqmRunModel.DateTime_Local.Month, mwqmRunModel.DateTime_Local.Day, Hour, Minute, 0);
mwqmSampleModelToChange.SampleDateTime_Local = SampleDate;
}
// FecCol_MPN_100ml
if (string.IsNullOrWhiteSpace(fc["FecCol_MPN_100ml"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.FecCol_MPN_100ml)));
}
int.TryParse(fc["FecCol_MPN_100ml"], out FecCol_MPN_100ml);
if (FecCol_MPN_100ml < 0)
{
return(ReturnError(string.Format(ServiceRes._OnlyAllowsPositiveValues, ServiceRes.FecCol_MPN_100ml)));
}
mwqmSampleModelToChange.FecCol_MPN_100ml = FecCol_MPN_100ml;
// WaterTemp_C
if (string.IsNullOrWhiteSpace(fc["WaterTemp_C"]))
{
WaterTemp_C = null;
}
else
{
WaterTemp_C = float.Parse(fc["WaterTemp_C"]);
if (WaterTemp_C < -15.0f || WaterTemp_C > 40.0f)
{
return(ReturnError(string.Format(ServiceRes._RangeIsBetween_And_, ServiceRes.WaterTemp_C, -15, 40)));
}
}
mwqmSampleModelToChange.WaterTemp_C = WaterTemp_C;
// Salinity_PPT
if (string.IsNullOrWhiteSpace(fc["Salinity_PPT"]))
{
Salinity_PPT = null;
}
else
{
Salinity_PPT = float.Parse(fc["Salinity_PPT"]);
if (Salinity_PPT < 0 || Salinity_PPT > 40)
{
return(ReturnError(string.Format(ServiceRes._RangeIsBetween_And_, ServiceRes.Salinity_PPT, 0, 40)));
}
}
mwqmSampleModelToChange.Salinity_PPT = Salinity_PPT;
// Depth_m
if (string.IsNullOrWhiteSpace(fc["Depth_m"]))
{
Depth_m = null;
}
else
{
Depth_m = float.Parse(fc["Depth_m"]);
if (Depth_m < 0 || Depth_m > 10000)
{
return(ReturnError(string.Format(ServiceRes._RangeIsBetween_And_, ServiceRes.Depth_m, 0, 10000)));
}
}
mwqmSampleModelToChange.Depth_m = Depth_m;
// PH
if (string.IsNullOrWhiteSpace(fc["PH"]))
{
PH = null;
}
else
{
PH = float.Parse(fc["PH"]);
if (PH < 0)
{
return(ReturnError(string.Format(ServiceRes._RangeIsBetween_And_, ServiceRes.PH, 0, 14)));
}
}
mwqmSampleModelToChange.PH = PH;
// ProcessBy
ProcessedBy = fc["ProcessedBy"];
if (ProcessedBy == null)
{
mwqmSampleModelToChange.ProcessedBy = null;
}
else
{
if (ProcessedBy.Length > 10)
{
return(ReturnError(string.Format(ServiceRes._MaxLengthIs_, ServiceRes.ProcessedBy, 10)));
}
mwqmSampleModelToChange.ProcessedBy = ProcessedBy.ToUpper();
}
if (!string.IsNullOrWhiteSpace(fc["UseForOpenData"]))
{
if (bool.Parse(fc["UseForOpenData"]))
{
UseForOpenData = true;
}
}
mwqmSampleModelToChange.UseForOpenData = UseForOpenData;
// SampleTypesText
if (string.IsNullOrWhiteSpace(fc["SampleTypes[]"]))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.SampleTypes)));
}
SampleTypeList = fc["SampleTypes[]"].Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(c => ((SampleTypeEnum)(int.Parse(c)))).ToList <SampleTypeEnum>();
mwqmSampleModelToChange.SampleTypesText = "";
foreach (SampleTypeEnum sampleType in SampleTypeList)
{
string retStr = _BaseEnumService.SampleTypeOK(sampleType);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
mwqmSampleModelToChange.SampleTypesText += ((int)sampleType).ToString() + ",";
}
// MWQMSampleNote
MWQMSampleNote = fc["MWQMSampleNote"];
if (string.IsNullOrWhiteSpace(MWQMSampleNote))
{
mwqmSampleModelToChange.MWQMSampleNote = null;
}
else
{
if (MWQMSampleNote.Length > 250)
{
return(ReturnError(string.Format(ServiceRes._MaxLengthIs_, ServiceRes.Comment, 250)));
}
mwqmSampleModelToChange.MWQMSampleNote = MWQMSampleNote;
}
MWQMSampleModel mwqmSampleModelRet = new MWQMSampleModel();
if (MWQMSampleID > 0)
{
mwqmSampleModelRet = PostUpdateMWQMSampleDB(mwqmSampleModelToChange);
if (!string.IsNullOrWhiteSpace(mwqmSampleModelRet.Error))
{
return(ReturnError(mwqmSampleModelRet.Error));
}
}
else
{
mwqmSampleModelRet = PostAddMWQMSampleDB(mwqmSampleModelToChange);
if (!string.IsNullOrWhiteSpace(mwqmSampleModelRet.Error))
{
return(ReturnError(mwqmSampleModelRet.Error));
}
}
return(mwqmSampleModelRet);
}
public void MWQMRunLanguageService_MWQMRunLanguageModelOK_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
LanguageEnum LangToAdd = LanguageEnum.es;
using (TransactionScope ts = new TransactionScope())
{
MWQMRunModel mwqmRunModelRet = mwqmRunServiceTest.AddMWQMRunModel();
#region Good
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
string retStr = mwqmRunLanguageService.MWQMRunLanguageModelOK(mwqmRunLanguageModelNew);
Assert.AreEqual("", retStr);
#endregion Good
#region MWQMRunID
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
mwqmRunLanguageModelNew.MWQMRunID = 0;
retStr = mwqmRunLanguageService.MWQMRunLanguageModelOK(mwqmRunLanguageModelNew);
Assert.AreEqual(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMRunID), retStr);
#endregion MWQMRunID
#region Language
int Max = 2;
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
mwqmRunLanguageModelNew.Language = (LanguageEnum)10000;
retStr = mwqmRunLanguageService.MWQMRunLanguageModelOK(mwqmRunLanguageModelNew);
Assert.AreEqual(string.Format(ServiceRes._IsRequired, ServiceRes.Language), retStr);
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
mwqmRunLanguageModelNew.Language = LanguageEnum.en;
retStr = mwqmRunLanguageService.MWQMRunLanguageModelOK(mwqmRunLanguageModelNew);
Assert.AreEqual("", retStr);
#endregion Language
#region MWQMRunComment
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
Max = 10000;
mwqmRunLanguageModelNew.MWQMRunComment = randomService.RandomString("", 0);
retStr = mwqmRunLanguageService.MWQMRunLanguageModelOK(mwqmRunLanguageModelNew);
Assert.AreEqual("", retStr);
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
mwqmRunLanguageModelNew.MWQMRunComment = randomService.RandomString("", Max + 1);
retStr = mwqmRunLanguageService.MWQMRunLanguageModelOK(mwqmRunLanguageModelNew);
Assert.AreEqual(string.Format(ServiceRes._MaxLengthIs_, ServiceRes.MWQMRunComment, Max), retStr);
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
mwqmRunLanguageModelNew.MWQMRunComment = randomService.RandomString("", Max - 1);
retStr = mwqmRunLanguageService.MWQMRunLanguageModelOK(mwqmRunLanguageModelNew);
Assert.AreEqual("", retStr);
FillMWQMRunLanguageModelNew(LangToAdd, mwqmRunModelRet, mwqmRunLanguageModelNew);
mwqmRunLanguageModelNew.MWQMRunComment = randomService.RandomString("", Max);
retStr = mwqmRunLanguageService.MWQMRunLanguageModelOK(mwqmRunLanguageModelNew);
Assert.AreEqual("", retStr);
#endregion MWQMRunComment
}
}
}
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 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);
}
