public void MWQMSampleLanguageService_PostAddMWQMSampleLanguageDB_GetMWQMSampleLanguageModelWithMWQMSampleIDAndLanguageDB_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
using (ShimsContext.Create())
{
SetupShim();
LanguageEnum LangToAdd = LanguageEnum.es;
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
//string ErrorText = "ErrorText";
shimMWQMSampleLanguageService.GetMWQMSampleLanguageModelWithMWQMSampleIDAndLanguageDBInt32LanguageEnum = (a, b) =>
{
return(new MWQMSampleLanguageModel());
};
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = mwqmSampleLanguageService.PostAddMWQMSampleLanguageDB(mwqmSampleLanguageModelNew);
Assert.AreEqual(string.Format(ServiceRes._AlreadyExists, ServiceRes.MWQMSampleLanguage), mwqmSampleLanguageModelRet.Error);
}
}
}
}
public void MWQMSampleLanguageService_PostAddMWQMSampleLanguageDB_Add_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
using (ShimsContext.Create())
{
SetupShim();
LanguageEnum LangToAdd = LanguageEnum.es;
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
//string ErrorText = "ErrorText";
shimMWQMSampleLanguageService.FillMWQMSampleLanguageMWQMSampleLanguageMWQMSampleLanguageModelContactOK = (a, b, c) =>
{
return("");
};
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = mwqmSampleLanguageService.PostAddMWQMSampleLanguageDB(mwqmSampleLanguageModelNew);
Assert.IsTrue(mwqmSampleLanguageModelRet.Error.StartsWith(string.Format(ServiceRes.CouldNotAddError_, "").Substring(0, 10)));
}
}
}
}
public void MWQMSampleLanguageService_PostAddMWQMSampleLanguageDB_DoAddChanges_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
using (ShimsContext.Create())
{
SetupShim();
LanguageEnum LangToAdd = LanguageEnum.es;
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
string ErrorText = "ErrorText";
shimMWQMSampleLanguageService.DoAddChanges = () =>
{
return(ErrorText);
};
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = mwqmSampleLanguageService.PostAddMWQMSampleLanguageDB(mwqmSampleLanguageModelNew);
Assert.AreEqual(ErrorText, mwqmSampleLanguageModelRet.Error);
}
}
}
}
public void MWQMSampleLanguageService_PostDeleteMWQMSampleLanguageDB_IsContactOK_Error_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = AddMWQMSampleLanguageModel(LangToAdd, mwqmSampleModelRet);
MWQMSampleLanguageModel mwqmSampleLanguageModelRet2 = UpdateMWQMSampleLanguageModel(mwqmSampleLanguageModelRet);
using (ShimsContext.Create())
{
SetupShim();
string ErrorText = "ErrorText";
shimMWQMSampleLanguageService.IsContactOK = () =>
{
return(new ContactOK()
{
Error = ErrorText
});
};
MWQMSampleLanguageModel mwqmSampleLanguageModelRet3 = mwqmSampleLanguageService.PostDeleteMWQMSampleLanguageDB(mwqmSampleLanguageModelRet2.MWQMSampleID, LangToAdd);
Assert.AreEqual(ErrorText, mwqmSampleLanguageModelRet3.Error);
}
}
}
}
// Fill
public string FillMWQMSample(MWQMSample mwqmSample, MWQMSampleModel mwqmSampleModel, ContactOK contactOK)
{
mwqmSample.DBCommand = (int)mwqmSampleModel.DBCommand;
mwqmSample.MWQMSiteTVItemID = mwqmSampleModel.MWQMSiteTVItemID;
mwqmSample.MWQMRunTVItemID = mwqmSampleModel.MWQMRunTVItemID;
mwqmSample.Depth_m = mwqmSampleModel.Depth_m;
mwqmSample.FecCol_MPN_100ml = mwqmSampleModel.FecCol_MPN_100ml;
mwqmSample.PH = mwqmSampleModel.PH;
mwqmSample.Salinity_PPT = mwqmSampleModel.Salinity_PPT;
mwqmSample.SampleDateTime_Local = mwqmSampleModel.SampleDateTime_Local;
mwqmSample.TimeText = mwqmSampleModel.TimeText;
mwqmSample.WaterTemp_C = mwqmSampleModel.WaterTemp_C;
mwqmSample.SampleTypesText = mwqmSampleModel.SampleTypesText;
mwqmSample.Tube_10 = mwqmSampleModel.Tube_10;
mwqmSample.Tube_1_0 = mwqmSampleModel.Tube_1_0;
mwqmSample.Tube_0_1 = mwqmSampleModel.Tube_0_1;
mwqmSample.ProcessedBy = mwqmSampleModel.ProcessedBy;
mwqmSample.UseForOpenData = mwqmSampleModel.UseForOpenData;
mwqmSample.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
mwqmSample.LastUpdateContactTVItemID = 2;
}
else
{
mwqmSample.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
public void MWQMSampleLanguageService_FillMWQMSampleLanguage_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
LanguageEnum LangToAdd = LanguageEnum.es;
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
ContactOK contactOK = mwqmSampleLanguageService.IsContactOK();
string retStr = mwqmSampleLanguageService.FillMWQMSampleLanguage(mwqmSampleLanguage, mwqmSampleLanguageModelNew, contactOK);
Assert.AreEqual("", retStr);
Assert.AreEqual(contactOK.ContactTVItemID, mwqmSampleLanguage.LastUpdateContactTVItemID);
contactOK = null;
retStr = mwqmSampleLanguageService.FillMWQMSampleLanguage(mwqmSampleLanguage, mwqmSampleLanguageModelNew, contactOK);
Assert.AreEqual("", retStr);
Assert.AreEqual(contactModelListGood[0].ContactTVItemID, mwqmSampleLanguage.LastUpdateContactTVItemID);
}
}
}
private void FillMWQMSampleLanguageModelNew(LanguageEnum Language, MWQMSampleModel mwqmSampleModel, MWQMSampleLanguageModel mwqmSampleLanguageModel)
{
mwqmSampleLanguageModel.MWQMSampleID = mwqmSampleModel.MWQMSampleID;
mwqmSampleLanguageModel.MWQMSampleNote = randomService.RandomString("MWQMSampleName", 30);
mwqmSampleLanguageModel.Language = Language;
mwqmSampleLanguageModel.TranslationStatus = TranslationStatusEnum.Translated;
Assert.IsTrue(mwqmSampleLanguageModel.MWQMSampleID != 0);
Assert.IsTrue(mwqmSampleLanguageModel.MWQMSampleNote.Length == 30);
Assert.IsTrue(mwqmSampleLanguageModel.Language == Language);
Assert.IsTrue(mwqmSampleLanguageModel.TranslationStatus == TranslationStatusEnum.Translated);
}
public MWQMSampleModel GetMWQMSampleModelWithMWQMSampleIDDB(int MWQMSampleID)
{
MWQMSampleModel mwqmSampleModel = (from c in db.MWQMSamples
let siteName = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.MWQMSiteTVItemID select cl.TVText).FirstOrDefault <string>()
let mwqmRunTVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.MWQMRunTVItemID select cl.TVText).FirstOrDefault <string>()
let mwqmSampleNote = (from cl in db.MWQMSampleLanguages where cl.Language == (int)LanguageRequest && cl.MWQMSampleID == c.MWQMSampleID select cl.MWQMSampleNote).FirstOrDefault <string>()
where c.MWQMSampleID == MWQMSampleID
select new MWQMSampleModel
{
Error = "",
MWQMSampleID = c.MWQMSampleID,
DBCommand = (DBCommandEnum)c.DBCommand,
MWQMSampleNote = mwqmSampleNote,
MWQMSiteTVItemID = c.MWQMSiteTVItemID,
MWQMSiteTVText = siteName,
MWQMRunTVItemID = c.MWQMRunTVItemID,
MWQMRunTVText = mwqmRunTVText,
Depth_m = c.Depth_m,
FecCol_MPN_100ml = c.FecCol_MPN_100ml,
PH = c.PH,
Salinity_PPT = c.Salinity_PPT,
SampleDateTime_Local = c.SampleDateTime_Local,
TimeText = c.TimeText,
WaterTemp_C = c.WaterTemp_C,
SampleTypesText = c.SampleTypesText,
Tube_10 = c.Tube_10,
Tube_1_0 = c.Tube_1_0,
Tube_0_1 = c.Tube_0_1,
ProcessedBy = c.ProcessedBy,
UseForOpenData = c.UseForOpenData,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <MWQMSampleModel>();
if (mwqmSampleModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.MWQMSample, ServiceRes.MWQMSampleID, MWQMSampleID)));
}
mwqmSampleModel.SampleTypeList = mwqmSampleModel.SampleTypesText.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(c => ((SampleTypeEnum)(int.Parse(c)))).ToList <SampleTypeEnum>();
return(mwqmSampleModel);
}
public void MWQMSampleLanguageService_GetMWQMSampleModelCountDB_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMSampleLanguageModel mwqmSampleModelLanguageRet = AddMWQMSampleLanguageModel(LangToAdd, mwqmSampleModelRet);
int mwqmSampleCount = mwqmSampleLanguageService.GetMWQMSampleLanguageModelCountDB();
Assert.AreEqual(testDBService.Count + 3, mwqmSampleCount);
}
}
}
public void MWQMSampleLanguageService_PostAddMWQMSampleLanguageDB_Good_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = AddMWQMSampleLanguageModel(LangToAdd, mwqmSampleModelRet);
MWQMSampleLanguageModel mwqmSampleLanguageModelRet2 = UpdateMWQMSampleLanguageModel(mwqmSampleLanguageModelRet);
MWQMSampleLanguageModel mwqmSampleLanguageModelRet3 = mwqmSampleLanguageService.PostDeleteMWQMSampleLanguageDB(mwqmSampleLanguageModelRet2.MWQMSampleID, LangToAdd);
Assert.AreEqual("", mwqmSampleLanguageModelRet3.Error);
}
}
}
public void MWQMSampleLanguageService_GetMWQMSampleLanguageWithMWQMSampleIDAndLanguageDB_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
LanguageEnum LangToAdd = LanguageEnum.es;
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = AddMWQMSampleLanguageModel(LangToAdd, mwqmSampleModelRet);
MWQMSampleLanguage mwqmSampleLanguageRet2 = mwqmSampleLanguageService.GetMWQMSampleLanguageWithMWQMSampleIDAndLanguageDB(mwqmSampleLanguageModelRet.MWQMSampleID, LangToAdd);
Assert.AreEqual(mwqmSampleLanguageModelRet.MWQMSampleID, mwqmSampleLanguageRet2.MWQMSampleID);
Assert.AreEqual(mwqmSampleLanguageModelRet.Language, (LanguageEnum)mwqmSampleLanguageRet2.Language);
Assert.AreEqual(LangToAdd, (LanguageEnum)mwqmSampleLanguageRet2.Language);
}
}
}
public void MWQMSampleLanguageService_PostAddMWQMSampleLanguageDB_UserEmailNotValidated_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
LanguageEnum LangToAdd = LanguageEnum.es;
ContactModel contactModelBad = contactModelListGood[2];
IPrincipal userBad = new GenericPrincipal(new GenericIdentity(contactModelBad.LoginEmail, "Forms"), null);
mwqmSampleLanguageService = new MWQMSampleLanguageService((culture.TwoLetterISOLanguageName == "fr" ? LanguageEnum.fr : LanguageEnum.en), userBad);
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = AddMWQMSampleLanguageModel(LangToAdd, mwqmSampleModelRet);
// Assert 1
Assert.AreEqual(ServiceRes.EmailRequiresValidation, mwqmSampleLanguageModelRet.Error);
}
}
}
private MWQMSampleLanguageModel AddMWQMSampleLanguageModel(LanguageEnum LangToAdd, MWQMSampleModel mwqmSampleModel)
{
MWQMSampleLanguageModel mwqmSampleLanguageModelNew = new MWQMSampleLanguageModel();
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModel, mwqmSampleLanguageModelNew);
MWQMSampleLanguageModel mwqmSampleLanguagModelRet = mwqmSampleLanguageService.PostAddMWQMSampleLanguageDB(mwqmSampleLanguageModelNew);
if (!string.IsNullOrWhiteSpace(mwqmSampleLanguagModelRet.Error))
{
return(mwqmSampleLanguagModelRet);
}
Assert.IsNotNull(mwqmSampleLanguagModelRet);
CompareMWQMSampleLanguageModels(mwqmSampleLanguageModelNew, mwqmSampleLanguagModelRet);
return(mwqmSampleLanguagModelRet);
}
// 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);
}
// Check
public string MWQMSampleModelOK(MWQMSampleModel mwqmSampleModel)
{
string retStr = FieldCheckNotZeroInt(mwqmSampleModel.MWQMSiteTVItemID, ServiceRes.MWQMSiteTVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotZeroInt(mwqmSampleModel.MWQMRunTVItemID, ServiceRes.MWQMRunTVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullDateTime(mwqmSampleModel.SampleDateTime_Local, ServiceRes.SampleDateTime_Local);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(mwqmSampleModel.Depth_m, ServiceRes.Depth_m, 0, 10000);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndWithinRangeInt(mwqmSampleModel.FecCol_MPN_100ml, ServiceRes.FecCol_MPN_100ml, 0, 100000000);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(mwqmSampleModel.Salinity_PPT, ServiceRes.Salinity_PPT, 0, 40);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(mwqmSampleModel.WaterTemp_C, ServiceRes.WaterTemp_C, -12, 40);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(mwqmSampleModel.PH, ServiceRes.PH, 0, 14);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotEmptyAndMaxLengthString(mwqmSampleModel.SampleTypesText, ServiceRes.SampleTypesText, 50);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
List <SampleTypeEnum> SampleTypeList = mwqmSampleModel.SampleTypesText.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries).Select(c => ((SampleTypeEnum)(int.Parse(c)))).ToList <SampleTypeEnum>();
foreach (SampleTypeEnum sampleType in SampleTypeList)
{
retStr = _BaseEnumService.SampleTypeOK(sampleType);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
}
retStr = FieldCheckIfNotNullMaxLengthString(mwqmSampleModel.MWQMSampleNote, ServiceRes.MWQMSampleNote, 10000);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(mwqmSampleModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public MWQMSampleModel PostAddMWQMSampleDB(MWQMSampleModel mwqmSampleModel)
{
string retStr = MWQMSampleModelOK(mwqmSampleModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
MWQMSampleModel mwqmSampleModelExist = GetMWQMSampleModelExistDB(mwqmSampleModel);
if (string.IsNullOrWhiteSpace(mwqmSampleModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.MWQMSample)));
}
MWQMSample mwqmSampleNew = new MWQMSample();
retStr = FillMWQMSample(mwqmSampleNew, mwqmSampleModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.MWQMSamples.Add(mwqmSampleNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("MWQMSamples", mwqmSampleNew.MWQMSampleID, LogCommandEnum.Add, mwqmSampleNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
MWQMSampleLanguageModel mwqmSampleLanguageModel = new MWQMSampleLanguageModel()
{
DBCommand = DBCommandEnum.Original,
MWQMSampleID = mwqmSampleNew.MWQMSampleID,
Language = Lang,
MWQMSampleNote = mwqmSampleModel.MWQMSampleNote,
TranslationStatus = (Lang == LanguageRequest ? TranslationStatusEnum.Translated : TranslationStatusEnum.NotTranslated),
};
if (mwqmSampleLanguageModel.MWQMSampleNote == null)
{
mwqmSampleLanguageModel.MWQMSampleNote = ServiceRes.Empty;
}
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = _MWQMSampleLanguageService.PostAddMWQMSampleLanguageDB(mwqmSampleLanguageModel);
if (!string.IsNullOrEmpty(mwqmSampleLanguageModelRet.Error))
{
return(ReturnError(mwqmSampleLanguageModelRet.Error));
}
}
ts.Complete();
}
return(GetMWQMSampleModelWithMWQMSampleIDDB(mwqmSampleNew.MWQMSampleID));
}
public MWQMSampleModel PostUpdateMWQMSampleDB(MWQMSampleModel mwqmSampleModel)
{
string retStr = MWQMSampleModelOK(mwqmSampleModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
MWQMSample mwqmSampleToUpdate = GetMWQMSampleWithMWQMSampleIDDB(mwqmSampleModel.MWQMSampleID);
if (mwqmSampleToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.MWQMSample)));
}
retStr = FillMWQMSample(mwqmSampleToUpdate, mwqmSampleModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("MWQMSamples", mwqmSampleToUpdate.MWQMSampleID, LogCommandEnum.Change, mwqmSampleToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
foreach (LanguageEnum Lang in LanguageListAllowable)
{
if (Lang == LanguageRequest)
{
MWQMSampleLanguageModel mwqmSampleLanguageModel = new MWQMSampleLanguageModel()
{
DBCommand = DBCommandEnum.Original,
MWQMSampleID = mwqmSampleModel.MWQMSampleID,
Language = Lang,
MWQMSampleNote = mwqmSampleModel.MWQMSampleNote ?? "",
TranslationStatus = TranslationStatusEnum.Translated,
};
if (!string.IsNullOrWhiteSpace(mwqmSampleModel.MWQMSampleNote))
{
mwqmSampleModel.MWQMSampleNote = ServiceRes.Empty;
}
MWQMSampleLanguageModel mwqmSampleLanguageModelRet = _MWQMSampleLanguageService.PostUpdateMWQMSampleLanguageDB(mwqmSampleLanguageModel);
if (!string.IsNullOrEmpty(mwqmSampleLanguageModelRet.Error))
{
return(ReturnError(mwqmSampleLanguageModelRet.Error));
}
}
}
ts.Complete();
}
return(GetMWQMSampleModelWithMWQMSampleIDDB(mwqmSampleToUpdate.MWQMSampleID));
}
public JsonResult MWQMRunSampleAddOrModifyJSON(FormCollection fc)
{
MWQMSampleModel mwqmSampleModel = _MWQMSampleService.MWQMSampleAddOrModifyDB(fc);
return(Json(mwqmSampleModel.Error, JsonRequestBehavior.AllowGet));
}
public void MWQMSampleLanguageService_MWQMSampleLanguageModelOK_Test()
{
foreach (CultureInfo culture in setupData.cultureListGood)
{
SetupTest(contactModelListGood[0], culture);
LanguageEnum LangToAdd = LanguageEnum.es;
using (TransactionScope ts = new TransactionScope())
{
MWQMSampleModel mwqmSampleModelRet = mwqmSampleServiceTest.AddMWQMSampleModel();
#region Good
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
string retStr = mwqmSampleLanguageService.MWQMSampleLanguageModelOK(mwqmSampleLanguageModelNew);
Assert.AreEqual("", retStr);
#endregion Good
#region MWQMSampleID
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
mwqmSampleLanguageModelNew.MWQMSampleID = 0;
retStr = mwqmSampleLanguageService.MWQMSampleLanguageModelOK(mwqmSampleLanguageModelNew);
Assert.AreEqual(string.Format(ServiceRes._IsRequired, ServiceRes.MWQMSampleID), retStr);
#endregion MWQMSampleID
#region Language
int Max = 2;
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
mwqmSampleLanguageModelNew.Language = (LanguageEnum)10000;
retStr = mwqmSampleLanguageService.MWQMSampleLanguageModelOK(mwqmSampleLanguageModelNew);
Assert.AreEqual(string.Format(ServiceRes._IsRequired, ServiceRes.Language), retStr);
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
mwqmSampleLanguageModelNew.Language = LanguageEnum.en;
#endregion Language
#region MWQMSampleNote
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
Max = 10000;
mwqmSampleLanguageModelNew.MWQMSampleNote = randomService.RandomString("", 0);
retStr = mwqmSampleLanguageService.MWQMSampleLanguageModelOK(mwqmSampleLanguageModelNew);
Assert.AreEqual("", retStr);
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
mwqmSampleLanguageModelNew.MWQMSampleNote = randomService.RandomString("", Max + 1);
retStr = mwqmSampleLanguageService.MWQMSampleLanguageModelOK(mwqmSampleLanguageModelNew);
Assert.AreEqual(string.Format(ServiceRes._MaxLengthIs_, ServiceRes.MWQMSampleNote, Max), retStr);
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
mwqmSampleLanguageModelNew.MWQMSampleNote = randomService.RandomString("", Max - 1);
retStr = mwqmSampleLanguageService.MWQMSampleLanguageModelOK(mwqmSampleLanguageModelNew);
Assert.AreEqual("", retStr);
FillMWQMSampleLanguageModelNew(LangToAdd, mwqmSampleModelRet, mwqmSampleLanguageModelNew);
mwqmSampleLanguageModelNew.MWQMSampleNote = randomService.RandomString("", Max);
retStr = mwqmSampleLanguageService.MWQMSampleLanguageModelOK(mwqmSampleLanguageModelNew);
Assert.AreEqual("", retStr);
#endregion MWQMSampleNote
}
}
}
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 JsonResult MWQMRunSampleDeleteJSON(int MWQMSampleID)
{
MWQMSampleModel mwqmSampleModel = _MWQMSampleService.PostDeleteMWQMSampleDB(MWQMSampleID);
return(Json(mwqmSampleModel.Error, JsonRequestBehavior.AllowGet));
}
