public MWQMSampleService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_MWQMSampleLanguageService = new MWQMSampleLanguageService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_MWQMRunService = new MWQMRunService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
_MWQMSubsectorService = new MWQMSubsectorService(LanguageRequest, User);
_MWQMRunService = new MWQMRunService(LanguageRequest, User);
_UseOfSiteService = new UseOfSiteService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
}
public void MWQMRun_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMRunController mwqmRunController = new MWQMRunController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmRunController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmRunController.DatabaseType);
MWQMRun mwqmRunLast = new MWQMRun();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
MWQMRunService mwqmRunService = new MWQMRunService(query, db, ContactID);
mwqmRunLast = (from c in db.MWQMRuns select c).FirstOrDefault();
}
// ok with MWQMRun info
IHttpActionResult jsonRet = mwqmRunController.GetMWQMRunWithID(mwqmRunLast.MWQMRunID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMRun> Ret = jsonRet as OkNegotiatedContentResult <MWQMRun>;
MWQMRun mwqmRunRet = Ret.Content;
Assert.AreEqual(mwqmRunLast.MWQMRunID, mwqmRunRet.MWQMRunID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = mwqmRunController.Put(mwqmRunRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMRun> mwqmRunRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMRun>;
Assert.IsNotNull(mwqmRunRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because MWQMRunID of 0 does not exist
mwqmRunRet.MWQMRunID = 0;
IHttpActionResult jsonRet3 = mwqmRunController.Put(mwqmRunRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <MWQMRun> mwqmRunRet3 = jsonRet3 as OkNegotiatedContentResult <MWQMRun>;
Assert.IsNull(mwqmRunRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public IHttpActionResult GetMWQMRunList([FromUri] string lang = "en", [FromUri] int skip = 0, [FromUri] int take = 200,
[FromUri] string asc = "", [FromUri] string desc = "", [FromUri] string where = "", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMRunService mwqmRunService = new MWQMRunService(new Query()
{
Lang = lang
}, db, ContactID);
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
base.Initialize(requestContext);
_AppTaskService = new AppTaskService(LanguageRequest, User);
_MWQMSiteService = new MWQMSiteService(LanguageRequest, User);
_MWQMRunService = new MWQMRunService(LanguageRequest, User);
_MWQMSampleService = new MWQMSampleService(LanguageRequest, User);
_MapInfoPointService = new MapInfoPointService(LanguageRequest, User);
_MWQMSubsectorService = new MWQMSubsectorService(LanguageRequest, User);
_MWQMAnalysisReportParameterService = new MWQMAnalysisReportParameterService(LanguageRequest, User);
}
public LabSheetTubeMPNDetailService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_MWQMRunService = new MWQMRunService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_MWQMSiteService = new MWQMSiteService(LanguageRequest, User);
_MWQMSampleService = new MWQMSampleService(LanguageRequest, User);
_TVFileService = new TVFileService(LanguageRequest, User);
_AppTaskService = new AppTaskService(LanguageRequest, User);
_ContactService = new ContactService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
}
public MikeScenarioResultService(LanguageEnum LanguageRequest, IPrincipal User)
: base(LanguageRequest, User)
{
_AppTaskService = new AppTaskService(LanguageRequest, User);
_TVFileService = new TVFileService(LanguageRequest, User);
_MapInfoService = new MapInfoService(LanguageRequest, User);
_MikeSourceService = new MikeSourceService(LanguageRequest, User);
_MikeBoundaryConditionService = new MikeBoundaryConditionService(LanguageRequest, User);
_TideSiteService = new TideSiteService(LanguageRequest, User);
_TVItemService = new TVItemService(LanguageRequest, User);
_LogService = new LogService(LanguageRequest, User);
_MWQMRunService = new MWQMRunService(LanguageRequest, User);
}
public IHttpActionResult GetMWQMRunWithID([FromUri] int MWQMRunID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMRunService mwqmRunService = new MWQMRunService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
mwqmRunService.Query = mwqmRunService.FillQuery(typeof(MWQMRun), lang, 0, 1, "", "", extra);
if (mwqmRunService.Query.Extra == "A")
{
MWQMRunExtraA mwqmRunExtraA = new MWQMRunExtraA();
mwqmRunExtraA = mwqmRunService.GetMWQMRunExtraAWithMWQMRunID(MWQMRunID);
if (mwqmRunExtraA == null)
{
return(NotFound());
}
return(Ok(mwqmRunExtraA));
}
else if (mwqmRunService.Query.Extra == "B")
{
MWQMRunExtraB mwqmRunExtraB = new MWQMRunExtraB();
mwqmRunExtraB = mwqmRunService.GetMWQMRunExtraBWithMWQMRunID(MWQMRunID);
if (mwqmRunExtraB == null)
{
return(NotFound());
}
return(Ok(mwqmRunExtraB));
}
else
{
MWQMRun mwqmRun = new MWQMRun();
mwqmRun = mwqmRunService.GetMWQMRunWithMWQMRunID(MWQMRunID);
if (mwqmRun == null)
{
return(NotFound());
}
return(Ok(mwqmRun));
}
}
}
public void SetupTest(ContactModel contactModelToDo, CultureInfo culture)
{
Thread.CurrentThread.CurrentCulture = culture;
Thread.CurrentThread.CurrentUICulture = culture;
contactModel = contactModelToDo;
user = new GenericPrincipal(new GenericIdentity(contactModel.LoginEmail, "Forms"), null);
mwqmRunService = new MWQMRunService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
mwqmRunLanguageService = new MWQMRunLanguageService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
testDBService = new TestDBService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user, TableName, Plurial);
randomService = new RandomService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), user);
mwqmRunLanguageModelNew = new MWQMRunLanguageModel();
mwqmRunLanguage = new MWQMRunLanguage();
mwqmRunServiceTest = new MWQMRunServiceTest();
mwqmRunServiceTest.SetupTest(contactModelToDo, culture);
}
public void MWQMRun_Controller_GetMWQMRunWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMRunController mwqmRunController = new MWQMRunController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmRunController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmRunController.DatabaseType);
MWQMRun mwqmRunFirst = new MWQMRun();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMRunService mwqmRunService = new MWQMRunService(new Query(), db, ContactID);
mwqmRunFirst = (from c in db.MWQMRuns select c).FirstOrDefault();
}
// ok with MWQMRun info
IHttpActionResult jsonRet = mwqmRunController.GetMWQMRunWithID(mwqmRunFirst.MWQMRunID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMRun> Ret = jsonRet as OkNegotiatedContentResult <MWQMRun>;
MWQMRun mwqmRunRet = Ret.Content;
Assert.AreEqual(mwqmRunFirst.MWQMRunID, mwqmRunRet.MWQMRunID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = mwqmRunController.GetMWQMRunWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMRun> mwqmRunRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMRun>;
Assert.IsNull(mwqmRunRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public PartialViewResult _LabSheetsHistory(int SamplingPlanID)
{
ViewBag.SamplingPlanController = _SamplingPlanController;
ViewBag.AdminContactModelList = null;
ViewBag.IsSamplingPlanner = false;
ViewBag.LabSheetModelList = null;
ViewBag.SamplingPlanID = SamplingPlanID;
ViewBag.LabSheetModelList = null;
ViewBag.LabSheetSiteMonitoredCountsList = null;
List <LabSheetModel> labSheetModelList = new List <LabSheetModel>();
SamplingPlanService SamplingPlanService = new SamplingPlanService(_TVItemService.LanguageRequest, _TVItemService.User);
LabSheetService labSheetService = new LabSheetService(_TVItemService.LanguageRequest, _TVItemService.User);
MWQMRunService mwqmRunService = new MWQMRunService(_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;
}
labSheetModelList = labSheetService.GetLabSheetModelListWithSamplingPlanIDDB(SamplingPlanID);
ViewBag.LabSheetModelList = labSheetModelList;
List <LabSheetSiteMonitoredCounts> labSheetSiteMonitoredCountsList = labSheetService.GetLabSheetIDListAndCountSamplesWithSamplingPlanIDDB(SamplingPlanID);
ViewBag.LabSheetSiteMonitoredCountsList = labSheetSiteMonitoredCountsList;
}
return(PartialView());
}
public IHttpActionResult Delete([FromBody] MWQMRun mwqmRun, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMRunService mwqmRunService = new MWQMRunService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!mwqmRunService.Delete(mwqmRun))
{
return(BadRequest(String.Join("|||", mwqmRun.ValidationResults)));
}
else
{
mwqmRun.ValidationResults = null;
return(Ok(mwqmRun));
}
}
}
public IHttpActionResult GetMWQMRunList([FromUri] string lang = "en", [FromUri] int skip = 0, [FromUri] int take = 200,
[FromUri] string asc = "", [FromUri] string desc = "", [FromUri] string where = "", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMRunService mwqmRunService = new MWQMRunService(new Query()
{
Lang = lang
}, db, ContactID);
if (extra == "A") // QueryString contains [extra=A]
{
mwqmRunService.Query = mwqmRunService.FillQuery(typeof(MWQMRunExtraA), lang, skip, take, asc, desc, where, extra);
if (mwqmRunService.Query.HasErrors)
{
return(Ok(new List <MWQMRunExtraA>()
{
new MWQMRunExtraA()
{
HasErrors = mwqmRunService.Query.HasErrors,
ValidationResults = mwqmRunService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(mwqmRunService.GetMWQMRunExtraAList().ToList()));
}
}
else if (extra == "B") // QueryString contains [extra=B]
{
mwqmRunService.Query = mwqmRunService.FillQuery(typeof(MWQMRunExtraB), lang, skip, take, asc, desc, where, extra);
if (mwqmRunService.Query.HasErrors)
{
return(Ok(new List <MWQMRunExtraB>()
{
new MWQMRunExtraB()
{
HasErrors = mwqmRunService.Query.HasErrors,
ValidationResults = mwqmRunService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(mwqmRunService.GetMWQMRunExtraBList().ToList()));
}
}
else // QueryString has no parameter [extra] or extra is empty
{
mwqmRunService.Query = mwqmRunService.FillQuery(typeof(MWQMRun), lang, skip, take, asc, desc, where, extra);
if (mwqmRunService.Query.HasErrors)
{
return(Ok(new List <MWQMRun>()
{
new MWQMRun()
{
HasErrors = mwqmRunService.Query.HasErrors,
ValidationResults = mwqmRunService.Query.ValidationResults,
},
}.ToList()));
}
else
{
return(Ok(mwqmRunService.GetMWQMRunList().ToList()));
}
}
}
}
public void MWQMRun_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMRunController mwqmRunController = new MWQMRunController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmRunController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmRunController.DatabaseType);
MWQMRun mwqmRunLast = new MWQMRun();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
MWQMRunService mwqmRunService = new MWQMRunService(query, db, ContactID);
mwqmRunLast = (from c in db.MWQMRuns select c).FirstOrDefault();
}
// ok with MWQMRun info
IHttpActionResult jsonRet = mwqmRunController.GetMWQMRunWithID(mwqmRunLast.MWQMRunID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMRun> Ret = jsonRet as OkNegotiatedContentResult <MWQMRun>;
MWQMRun mwqmRunRet = Ret.Content;
Assert.AreEqual(mwqmRunLast.MWQMRunID, mwqmRunRet.MWQMRunID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because MWQMRunID exist
IHttpActionResult jsonRet2 = mwqmRunController.Post(mwqmRunRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMRun> mwqmRunRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMRun>;
Assert.IsNull(mwqmRunRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added MWQMRun
mwqmRunRet.MWQMRunID = 0;
mwqmRunController.Request = new System.Net.Http.HttpRequestMessage();
mwqmRunController.Request.RequestUri = new System.Uri("http://localhost:5000/api/mwqmRun");
IHttpActionResult jsonRet3 = mwqmRunController.Post(mwqmRunRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <MWQMRun> mwqmRunRet3 = jsonRet3 as CreatedNegotiatedContentResult <MWQMRun>;
Assert.IsNotNull(mwqmRunRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = mwqmRunController.Delete(mwqmRunRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <MWQMRun> mwqmRunRet4 = jsonRet4 as OkNegotiatedContentResult <MWQMRun>;
Assert.IsNotNull(mwqmRunRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
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());
}
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 void MWQMRun_Controller_GetMWQMRunList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMRunController mwqmRunController = new MWQMRunController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmRunController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmRunController.DatabaseType);
MWQMRun mwqmRunFirst = new MWQMRun();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
MWQMRunService mwqmRunService = new MWQMRunService(query, db, ContactID);
mwqmRunFirst = (from c in db.MWQMRuns select c).FirstOrDefault();
count = (from c in db.MWQMRuns select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with MWQMRun info
IHttpActionResult jsonRet = mwqmRunController.GetMWQMRunList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <MWQMRun> > ret = jsonRet as OkNegotiatedContentResult <List <MWQMRun> >;
Assert.AreEqual(mwqmRunFirst.MWQMRunID, ret.Content[0].MWQMRunID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <MWQMRun> mwqmRunList = new List <MWQMRun>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
MWQMRunService mwqmRunService = new MWQMRunService(query, db, ContactID);
mwqmRunList = (from c in db.MWQMRuns select c).OrderBy(c => c.MWQMRunID).Skip(0).Take(2).ToList();
count = (from c in db.MWQMRuns select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with MWQMRun info
jsonRet = mwqmRunController.GetMWQMRunList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <MWQMRun> >;
Assert.AreEqual(mwqmRunList[0].MWQMRunID, ret.Content[0].MWQMRunID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
if (count > 1)
{
query.Skip = 1;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with MWQMRun info
IHttpActionResult jsonRet2 = mwqmRunController.GetMWQMRunList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <MWQMRun> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <MWQMRun> >;
Assert.AreEqual(mwqmRunList[1].MWQMRunID, ret2.Content[0].MWQMRunID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
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);
}
