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); }