public PartialViewResult _SamplingPlanEmailAddOrModify(int SamplingPlanID)
{
ViewBag.SamplingPlanID = SamplingPlanID;
ViewBag.SamplingPlanModel = null;
ViewBag.SamplingPlanEmailModelList = null;
SamplingPlanModel SamplingPlanModel = _SamplingPlanService.GetSamplingPlanModelWithSamplingPlanIDDB(SamplingPlanID);
ViewBag.SamplingPlanModel = SamplingPlanModel;
List <SamplingPlanEmailModel> samplingPlanEmailModelList = _SamplingPlanEmailService.GetSamplingPlanEmailModelListWithSamplingPlanIDDB(SamplingPlanID);
ViewBag.SamplingPlanEmailModelList = samplingPlanEmailModelList;
return(PartialView());
}
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 PartialViewResult _SamplingPlanAddOrModify(int ProvinceTVItemID, int SamplingPlanID)
{
ViewBag.SamplingPlanController = _SamplingPlanController;
ViewBag.ProvinceTVItemID = ProvinceTVItemID;
ViewBag.SamplingPlanID = SamplingPlanID;
ViewBag.SamplingPlanModel = null;
ViewBag.SamplingPlanSubsectorModelList = null;
ViewBag.AdminContactModelList = null;
ViewBag.ContactModel = null;
ViewBag.TVItemModelSubsectorList = null;
ViewBag.SampleTypeEnumTextOrderedList = null;
ViewBag.SamplingPlanTypeEnumTextOrderedList = null;
ViewBag.LabSheetTypeEnumTextOrderedList = null;
ViewBag.SampleTypeEnumTextOrderedFirst = null;
ViewBag.IsSamplingPlanner = null;
List <SampleTypeEnumTextOrdered> sampleTypeEnumTextOrderedList = _BaseEnumService.GetSampleTypeEnumTextOrderedList();
ViewBag.SampleTypeEnumTextOrderedList = sampleTypeEnumTextOrderedList;
SampleTypeEnumTextOrdered sampleTypeEnumTextOrderedFirst = sampleTypeEnumTextOrderedList.Where(c => c.SampleType == SampleTypeEnum.Routine).FirstOrDefault();
ViewBag.SampleTypeEnumTextOrderedFirst = sampleTypeEnumTextOrderedFirst;
List <SamplingPlanTypeEnumTextOrdered> samplingPlanTypeEnumTextOrderedList = _BaseEnumService.GetSamplingPlanTypeEnumTextOrderedList();
ViewBag.SamplingPlanTypeEnumTextOrderedList = samplingPlanTypeEnumTextOrderedList;
List <LabSheetTypeEnumTextOrdered> labSheetTypeEnumTextOrderedList = _BaseEnumService.GetLabSheetTypeEnumTextOrderedList();
ViewBag.LabSheetTypeEnumTextOrderedList = labSheetTypeEnumTextOrderedList;
ContactModel contactModel = _ContactService.GetContactLoggedInDB();
ViewBag.ContactModel = contactModel;
bool IsSamplingPlanner = false;
if (contactModel.SamplingPlanner_ProvincesTVItemID.Contains(ProvinceTVItemID.ToString()))
{
IsSamplingPlanner = true;
}
else
{
List <ContactModel> adminContactModelList = _ContactService.GetAdminContactModelListDB();
ViewBag.AdminContactModelList = adminContactModelList;
}
ViewBag.IsSamplingPlanner = IsSamplingPlanner;
if (IsSamplingPlanner)
{
ViewBag.ContactModel = contactModel;
if (contactModel.SamplingPlanner_ProvincesTVItemID.Contains(ProvinceTVItemID.ToString()))
{
List <SamplingPlanSubsectorModel> SamplingPlanSubsectorModelList = _SamplingPlanSubsectorService.GetSamplingPlanSubsectorModelListWithSamplingPlanIDDB(SamplingPlanID);
ViewBag.SamplingPlanSubsectorModelList = SamplingPlanSubsectorModelList;
List <TVItemModel> tvItemModelSubsectorList = _TVItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(ProvinceTVItemID, TVTypeEnum.Subsector);
ViewBag.TVItemModelSubsectorList = tvItemModelSubsectorList;
}
if (SamplingPlanID != 0)
{
SamplingPlanModel SamplingPlanModel = _SamplingPlanService.GetSamplingPlanModelWithSamplingPlanIDDB(SamplingPlanID);
ViewBag.SamplingPlanModel = SamplingPlanModel;
}
}
return(PartialView());
}
public JsonResult SamplingPlanDeleteFileJSON(int SamplingPlanID)
{
SamplingPlanModel SamplingPlanModel = _SamplingPlanService.SamplingPlanDeleteFileDB(SamplingPlanID);
return(Json(SamplingPlanModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult SamplingPlanSubsectorSaveJSON(FormCollection fc)
{
SamplingPlanModel SamplingPlanModel = _SamplingPlanService.SamplingPlanSubsectorSaveDB(fc);
return(Json(SamplingPlanModel.Error, JsonRequestBehavior.AllowGet));
}
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 Generate(FileInfo fi, int SamplingPlanID)
{
string NotUsed = "";
if (_TaskRunnerBaseService._BWObj.appTaskModel.Language == LanguageEnum.fr)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("fr-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("fr-CA");
}
else
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-CA");
Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-CA");
}
TVFileService tvFileService = new TVFileService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
string ServerFilePath = tvFileService.GetServerFilePath(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
DirectoryInfo di = new DirectoryInfo(ServerFilePath);
if (!di.Exists)
{
di.Create();
}
if (fi.Exists)
{
fi.Delete();
}
SamplingPlanModel SamplingPlanModel = _SamplingPlanService.GetSamplingPlanModelWithSamplingPlanIDDB(SamplingPlanID);
if (!string.IsNullOrWhiteSpace(SamplingPlanModel.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFind_With_Equal_, TaskRunnerServiceRes.SamplingPlan, TaskRunnerServiceRes.SamplingPlanID, SamplingPlanID.ToString());
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat3List("CouldNotFind_With_Equal_", TaskRunnerServiceRes.SamplingPlan, TaskRunnerServiceRes.SamplingPlanID, SamplingPlanID.ToString());
return;
}
TVItemService tvItemService = new TVItemService(_TaskRunnerBaseService._BWObj.appTaskModel.Language, _TaskRunnerBaseService._User);
TVItemModel tvItemModelProvince = tvItemService.GetTVItemModelWithTVItemIDDB(_TaskRunnerBaseService._BWObj.appTaskModel.TVItemID);
StringBuilder sb = new StringBuilder();
sb.AppendLine("Version\t1\t");
sb.AppendLine("Sampling Plan Type\t" + SamplingPlanModel.SamplingPlanType.ToString() + "\t");
sb.AppendLine("Sample Type\t" + SamplingPlanModel.SampleType.ToString() + "\t");
sb.AppendLine("Lab Sheet Type\t" + SamplingPlanModel.LabSheetType.ToString() + "\t");
List <SamplingPlanSubsectorModel> SamplingPlanSubsectorModelList = _SamplingPlanSubsectorService.GetSamplingPlanSubsectorModelListWithSamplingPlanIDDB(SamplingPlanID);
foreach (SamplingPlanSubsectorModel SamplingPlanSubsectorModel in SamplingPlanSubsectorModelList)
{
MWQMSubsectorModel mwqmSubsectorModel = _MWQMSubsectorService.GetMWQMSubsectorModelWithMWQMSubsectorTVItemIDDB(SamplingPlanSubsectorModel.SubsectorTVItemID);
if (!string.IsNullOrWhiteSpace(mwqmSubsectorModel.Error))
{
NotUsed = string.Format(TaskRunnerServiceRes.CouldNotFind_With_Equal_, TaskRunnerServiceRes.MWQMSubsector, TaskRunnerServiceRes.SubsectorTVItemID, SamplingPlanSubsectorModel.SubsectorTVItemID.ToString());
_TaskRunnerBaseService._BWObj.TextLanguageList = _TaskRunnerBaseService.GetTextLanguageFormat3List("CouldNotFind_With_Equal_", TaskRunnerServiceRes.MWQMSubsector, TaskRunnerServiceRes.SubsectorTVItemID, SamplingPlanSubsectorModel.SubsectorTVItemID.ToString());
}
List <SamplingPlanSubsectorSiteModel> SamplingPlanSubsectorSiteModelList = _SamplingPlanSubsectorSiteService.GetSamplingPlanSubsectorSiteModelListWithSamplingPlanSubsectorIDDB(SamplingPlanSubsectorModel.SamplingPlanSubsectorID);
if (SamplingPlanSubsectorSiteModelList.Count > 0)
{
sb.AppendLine("Subsector\t" + SamplingPlanSubsectorModel.SubsectorTVText + "\t" + SamplingPlanSubsectorModel.SubsectorTVItemID + "\t" + mwqmSubsectorModel.TideLocationSIDText);
sb.Append("MWQM Sites\t");
foreach (SamplingPlanSubsectorSiteModel SamplingPlanSubsectorSiteModel in SamplingPlanSubsectorSiteModelList)
{
sb.Append(SamplingPlanSubsectorSiteModel.MWQMSiteText + ",");
}
sb.Append("\t");
foreach (SamplingPlanSubsectorSiteModel SamplingPlanSubsectorSiteModel in SamplingPlanSubsectorSiteModelList)
{
sb.Append(SamplingPlanSubsectorSiteModel.MWQMSiteTVItemID + ",");
}
sb.AppendLine("");
}
if (SamplingPlanSubsectorSiteModelList.Where(c => c.IsDuplicate == true).Count() > 0)
{
sb.Append("Daily Duplicate\t");
foreach (SamplingPlanSubsectorSiteModel SamplingPlanSubsectorSiteModel in SamplingPlanSubsectorSiteModelList.Where(c => c.IsDuplicate == true))
{
sb.Append(SamplingPlanSubsectorSiteModel.MWQMSiteText + ",");
}
sb.Append("\t");
foreach (SamplingPlanSubsectorSiteModel SamplingPlanSubsectorSiteModel in SamplingPlanSubsectorSiteModelList.Where(c => c.IsDuplicate == true))
{
sb.Append(SamplingPlanSubsectorSiteModel.MWQMSiteTVItemID + ",");
}
sb.AppendLine("");
}
}
sb.AppendLine("App\t" + CreateCode(SamplingPlanModel.AccessCode) + "\t" + CreateCode(SamplingPlanModel.Year.ToString()));
sb.AppendLine("Precision Criteria\t" + CreateCode(SamplingPlanModel.DailyDuplicatePrecisionCriteria.ToString()) + "\t" + CreateCode(SamplingPlanModel.IntertechDuplicatePrecisionCriteria.ToString()));
sb.AppendLine("Include Laboratory QA/QC\t" + SamplingPlanModel.IncludeLaboratoryQAQC.ToString() + "\t" + CreateCode(SamplingPlanModel.ApprovalCode));
sb.AppendLine("Backup Directory\t" + SamplingPlanModel.BackupDirectory);
StreamWriter sw = fi.CreateText();
sw.Write(sb.ToString());
sw.Close();
}
