// 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 MWQMSampleModel PostDeleteMWQMSampleDB(int MWQMSampleID)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
MWQMSample mwqmSampleToDelete = GetMWQMSampleWithMWQMSampleIDDB(MWQMSampleID);
if (mwqmSampleToDelete == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToDelete, ServiceRes.MWQMSample)));
}
using (TransactionScope ts = new TransactionScope())
{
db.MWQMSamples.Remove(mwqmSampleToDelete);
string retStr = DoDeleteChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("MWQMSamples", mwqmSampleToDelete.MWQMSampleID, LogCommandEnum.Delete, mwqmSampleToDelete);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(ReturnError(""));
}
public TVItemModel MarkSamplesWithMWQMSampleIDForOpenDataDB(int MWQMSampleID, bool UseForOpenData)
{
using (CSSPDBEntities dd = new CSSPDBEntities())
{
MWQMSample mwqmSample = (from s in dd.MWQMSamples
where s.MWQMSampleID == MWQMSampleID
select s).FirstOrDefault();
if (mwqmSample == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.MWQMSample, ServiceRes.MWQMSampleID, MWQMSampleID.ToString())));
}
mwqmSample.UseForOpenData = UseForOpenData;
try
{
dd.SaveChanges();
}
catch (Exception ex)
{
return(ReturnError(string.Format(ServiceRes.CouldNotUpdateError_, ex.Message + " InnerException: " + (ex.InnerException != null ? ex.InnerException.Message : ""))));
}
}
return(ReturnError(""));
}
public MWQMSample GetMWQMSampleWithMWQMSampleIDDB(int MWQMSampleID)
{
MWQMSample mwqmSample = (from c in db.MWQMSamples
where c.MWQMSampleID == MWQMSampleID
select c).FirstOrDefault <MWQMSample>();
return(mwqmSample);
}
public void MWQMSample_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMSampleController mwqmSampleController = new MWQMSampleController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmSampleController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmSampleController.DatabaseType);
MWQMSample mwqmSampleLast = new MWQMSample();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
MWQMSampleService mwqmSampleService = new MWQMSampleService(query, db, ContactID);
mwqmSampleLast = (from c in db.MWQMSamples select c).FirstOrDefault();
}
// ok with MWQMSample info
IHttpActionResult jsonRet = mwqmSampleController.GetMWQMSampleWithID(mwqmSampleLast.MWQMSampleID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMSample> Ret = jsonRet as OkNegotiatedContentResult <MWQMSample>;
MWQMSample mwqmSampleRet = Ret.Content;
Assert.AreEqual(mwqmSampleLast.MWQMSampleID, mwqmSampleRet.MWQMSampleID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = mwqmSampleController.Put(mwqmSampleRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMSample> mwqmSampleRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMSample>;
Assert.IsNotNull(mwqmSampleRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because MWQMSampleID of 0 does not exist
mwqmSampleRet.MWQMSampleID = 0;
IHttpActionResult jsonRet3 = mwqmSampleController.Put(mwqmSampleRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <MWQMSample> mwqmSampleRet3 = jsonRet3 as OkNegotiatedContentResult <MWQMSample>;
Assert.IsNull(mwqmSampleRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public IHttpActionResult GetMWQMSampleWithID([FromUri] int MWQMSampleID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMSampleService mwqmSampleService = new MWQMSampleService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
mwqmSampleService.Query = mwqmSampleService.FillQuery(typeof(MWQMSample), lang, 0, 1, "", "", extra);
if (mwqmSampleService.Query.Extra == "A")
{
MWQMSampleExtraA mwqmSampleExtraA = new MWQMSampleExtraA();
mwqmSampleExtraA = mwqmSampleService.GetMWQMSampleExtraAWithMWQMSampleID(MWQMSampleID);
if (mwqmSampleExtraA == null)
{
return(NotFound());
}
return(Ok(mwqmSampleExtraA));
}
else if (mwqmSampleService.Query.Extra == "B")
{
MWQMSampleExtraB mwqmSampleExtraB = new MWQMSampleExtraB();
mwqmSampleExtraB = mwqmSampleService.GetMWQMSampleExtraBWithMWQMSampleID(MWQMSampleID);
if (mwqmSampleExtraB == null)
{
return(NotFound());
}
return(Ok(mwqmSampleExtraB));
}
else
{
MWQMSample mwqmSample = new MWQMSample();
mwqmSample = mwqmSampleService.GetMWQMSampleWithMWQMSampleID(MWQMSampleID);
if (mwqmSample == null)
{
return(NotFound());
}
return(Ok(mwqmSample));
}
}
}
public bool Update(MWQMSample mwqmSample)
{
mwqmSample.ValidationResults = Validate(new ValidationContext(mwqmSample), ActionDBTypeEnum.Update);
if (mwqmSample.ValidationResults.Count() > 0)
{
return(false);
}
db.MWQMSamples.Update(mwqmSample);
if (!TryToSave(mwqmSample))
{
return(false);
}
return(true);
}
private bool TryToSave(MWQMSample mwqmSample)
{
try
{
db.SaveChanges();
}
catch (DbUpdateException ex)
{
mwqmSample.ValidationResults = new List <ValidationResult>()
{
new ValidationResult(ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""))
}.AsEnumerable();
return(false);
}
return(true);
}
public void MWQMSample_Controller_GetMWQMSampleWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMSampleController mwqmSampleController = new MWQMSampleController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmSampleController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmSampleController.DatabaseType);
MWQMSample mwqmSampleFirst = new MWQMSample();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMSampleService mwqmSampleService = new MWQMSampleService(new Query(), db, ContactID);
mwqmSampleFirst = (from c in db.MWQMSamples select c).FirstOrDefault();
}
// ok with MWQMSample info
IHttpActionResult jsonRet = mwqmSampleController.GetMWQMSampleWithID(mwqmSampleFirst.MWQMSampleID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMSample> Ret = jsonRet as OkNegotiatedContentResult <MWQMSample>;
MWQMSample mwqmSampleRet = Ret.Content;
Assert.AreEqual(mwqmSampleFirst.MWQMSampleID, mwqmSampleRet.MWQMSampleID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = mwqmSampleController.GetMWQMSampleWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMSample> mwqmSampleRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMSample>;
Assert.IsNull(mwqmSampleRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public IHttpActionResult Delete([FromBody] MWQMSample mwqmSample, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
MWQMSampleService mwqmSampleService = new MWQMSampleService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!mwqmSampleService.Delete(mwqmSample))
{
return(BadRequest(String.Join("|||", mwqmSample.ValidationResults)));
}
else
{
mwqmSample.ValidationResults = null;
return(Ok(mwqmSample));
}
}
}
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 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 void MWQMSample_Controller_GetMWQMSampleList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMSampleController mwqmSampleController = new MWQMSampleController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmSampleController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmSampleController.DatabaseType);
MWQMSample mwqmSampleFirst = new MWQMSample();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
MWQMSampleService mwqmSampleService = new MWQMSampleService(query, db, ContactID);
mwqmSampleFirst = (from c in db.MWQMSamples select c).FirstOrDefault();
count = (from c in db.MWQMSamples select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with MWQMSample info
IHttpActionResult jsonRet = mwqmSampleController.GetMWQMSampleList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <MWQMSample> > ret = jsonRet as OkNegotiatedContentResult <List <MWQMSample> >;
Assert.AreEqual(mwqmSampleFirst.MWQMSampleID, ret.Content[0].MWQMSampleID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <MWQMSample> mwqmSampleList = new List <MWQMSample>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
MWQMSampleService mwqmSampleService = new MWQMSampleService(query, db, ContactID);
mwqmSampleList = (from c in db.MWQMSamples select c).OrderBy(c => c.MWQMSampleID).Skip(0).Take(2).ToList();
count = (from c in db.MWQMSamples select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with MWQMSample info
jsonRet = mwqmSampleController.GetMWQMSampleList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <MWQMSample> >;
Assert.AreEqual(mwqmSampleList[0].MWQMSampleID, ret.Content[0].MWQMSampleID);
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 MWQMSample info
IHttpActionResult jsonRet2 = mwqmSampleController.GetMWQMSampleList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <MWQMSample> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <MWQMSample> >;
Assert.AreEqual(mwqmSampleList[1].MWQMSampleID, ret2.Content[0].MWQMSampleID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void MWQMSample_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
MWQMSampleController mwqmSampleController = new MWQMSampleController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(mwqmSampleController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, mwqmSampleController.DatabaseType);
MWQMSample mwqmSampleLast = new MWQMSample();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
MWQMSampleService mwqmSampleService = new MWQMSampleService(query, db, ContactID);
mwqmSampleLast = (from c in db.MWQMSamples select c).FirstOrDefault();
}
// ok with MWQMSample info
IHttpActionResult jsonRet = mwqmSampleController.GetMWQMSampleWithID(mwqmSampleLast.MWQMSampleID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <MWQMSample> Ret = jsonRet as OkNegotiatedContentResult <MWQMSample>;
MWQMSample mwqmSampleRet = Ret.Content;
Assert.AreEqual(mwqmSampleLast.MWQMSampleID, mwqmSampleRet.MWQMSampleID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because MWQMSampleID exist
IHttpActionResult jsonRet2 = mwqmSampleController.Post(mwqmSampleRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <MWQMSample> mwqmSampleRet2 = jsonRet2 as OkNegotiatedContentResult <MWQMSample>;
Assert.IsNull(mwqmSampleRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added MWQMSample
mwqmSampleRet.MWQMSampleID = 0;
mwqmSampleController.Request = new System.Net.Http.HttpRequestMessage();
mwqmSampleController.Request.RequestUri = new System.Uri("http://localhost:5000/api/mwqmSample");
IHttpActionResult jsonRet3 = mwqmSampleController.Post(mwqmSampleRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <MWQMSample> mwqmSampleRet3 = jsonRet3 as CreatedNegotiatedContentResult <MWQMSample>;
Assert.IsNotNull(mwqmSampleRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = mwqmSampleController.Delete(mwqmSampleRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <MWQMSample> mwqmSampleRet4 = jsonRet4 as OkNegotiatedContentResult <MWQMSample>;
Assert.IsNotNull(mwqmSampleRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
public MWQMSampleTest()
{
mWQMSample = new MWQMSample();
mWQMSampleExtraA = new MWQMSampleExtraA();
mWQMSampleExtraB = new MWQMSampleExtraB();
}
private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
MWQMSample mwqmSample = validationContext.ObjectInstance as MWQMSample;
mwqmSample.HasErrors = false;
if (actionDBType == ActionDBTypeEnum.Update || actionDBType == ActionDBTypeEnum.Delete)
{
if (mwqmSample.MWQMSampleID == 0)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "MWQMSampleID"), new[] { "MWQMSampleID" }));
}
if (!(from c in db.MWQMSamples select c).Where(c => c.MWQMSampleID == mwqmSample.MWQMSampleID).Any())
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "MWQMSample", "MWQMSampleID", mwqmSample.MWQMSampleID.ToString()), new[] { "MWQMSampleID" }));
}
}
TVItem TVItemMWQMSiteTVItemID = (from c in db.TVItems where c.TVItemID == mwqmSample.MWQMSiteTVItemID select c).FirstOrDefault();
if (TVItemMWQMSiteTVItemID == null)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "MWQMSiteTVItemID", mwqmSample.MWQMSiteTVItemID.ToString()), new[] { "MWQMSiteTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.MWQMSite,
};
if (!AllowableTVTypes.Contains(TVItemMWQMSiteTVItemID.TVType))
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "MWQMSiteTVItemID", "MWQMSite"), new[] { "MWQMSiteTVItemID" }));
}
}
TVItem TVItemMWQMRunTVItemID = (from c in db.TVItems where c.TVItemID == mwqmSample.MWQMRunTVItemID select c).FirstOrDefault();
if (TVItemMWQMRunTVItemID == null)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "MWQMRunTVItemID", mwqmSample.MWQMRunTVItemID.ToString()), new[] { "MWQMRunTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.MWQMRun,
};
if (!AllowableTVTypes.Contains(TVItemMWQMRunTVItemID.TVType))
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "MWQMRunTVItemID", "MWQMRun"), new[] { "MWQMRunTVItemID" }));
}
}
if (mwqmSample.SampleDateTime_Local.Year == 1)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "SampleDateTime_Local"), new[] { "SampleDateTime_Local" }));
}
else
{
if (mwqmSample.SampleDateTime_Local.Year < 1980)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "SampleDateTime_Local", "1980"), new[] { "SampleDateTime_Local" }));
}
}
if (!string.IsNullOrWhiteSpace(mwqmSample.TimeText) && mwqmSample.TimeText.Length > 6)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "TimeText", "6"), new[] { "TimeText" }));
}
if (mwqmSample.Depth_m != null)
{
if (mwqmSample.Depth_m < 0 || mwqmSample.Depth_m > 1000)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Depth_m", "0", "1000"), new[] { "Depth_m" }));
}
}
if (mwqmSample.FecCol_MPN_100ml < 0 || mwqmSample.FecCol_MPN_100ml > 10000000)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "FecCol_MPN_100ml", "0", "10000000"), new[] { "FecCol_MPN_100ml" }));
}
if (mwqmSample.Salinity_PPT != null)
{
if (mwqmSample.Salinity_PPT < 0 || mwqmSample.Salinity_PPT > 40)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Salinity_PPT", "0", "40"), new[] { "Salinity_PPT" }));
}
}
if (mwqmSample.WaterTemp_C != null)
{
if (mwqmSample.WaterTemp_C < -10 || mwqmSample.WaterTemp_C > 40)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "WaterTemp_C", "-10", "40"), new[] { "WaterTemp_C" }));
}
}
if (mwqmSample.PH != null)
{
if (mwqmSample.PH < 0 || mwqmSample.PH > 14)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "PH", "0", "14"), new[] { "PH" }));
}
}
if (string.IsNullOrWhiteSpace(mwqmSample.SampleTypesText))
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "SampleTypesText"), new[] { "SampleTypesText" }));
}
if (!string.IsNullOrWhiteSpace(mwqmSample.SampleTypesText) && mwqmSample.SampleTypesText.Length > 50)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "SampleTypesText", "50"), new[] { "SampleTypesText" }));
}
if (mwqmSample.SampleType_old != null)
{
retStr = enums.EnumTypeOK(typeof(SampleTypeEnum), (int?)mwqmSample.SampleType_old);
if (mwqmSample.SampleType_old == null || !string.IsNullOrWhiteSpace(retStr))
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "SampleType_old"), new[] { "SampleType_old" }));
}
}
if (mwqmSample.Tube_10 != null)
{
if (mwqmSample.Tube_10 < 0 || mwqmSample.Tube_10 > 5)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Tube_10", "0", "5"), new[] { "Tube_10" }));
}
}
if (mwqmSample.Tube_1_0 != null)
{
if (mwqmSample.Tube_1_0 < 0 || mwqmSample.Tube_1_0 > 5)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Tube_1_0", "0", "5"), new[] { "Tube_1_0" }));
}
}
if (mwqmSample.Tube_0_1 != null)
{
if (mwqmSample.Tube_0_1 < 0 || mwqmSample.Tube_0_1 > 5)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Tube_0_1", "0", "5"), new[] { "Tube_0_1" }));
}
}
if (!string.IsNullOrWhiteSpace(mwqmSample.ProcessedBy) && mwqmSample.ProcessedBy.Length > 10)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "ProcessedBy", "10"), new[] { "ProcessedBy" }));
}
if (mwqmSample.LastUpdateDate_UTC.Year == 1)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), new[] { "LastUpdateDate_UTC" }));
}
else
{
if (mwqmSample.LastUpdateDate_UTC.Year < 1980)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), new[] { "LastUpdateDate_UTC" }));
}
}
TVItem TVItemLastUpdateContactTVItemID = (from c in db.TVItems where c.TVItemID == mwqmSample.LastUpdateContactTVItemID select c).FirstOrDefault();
if (TVItemLastUpdateContactTVItemID == null)
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", mwqmSample.LastUpdateContactTVItemID.ToString()), new[] { "LastUpdateContactTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Contact,
};
if (!AllowableTVTypes.Contains(TVItemLastUpdateContactTVItemID.TVType))
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), new[] { "LastUpdateContactTVItemID" }));
}
}
retStr = ""; // added to stop compiling CSSPError
if (retStr != "") // will never be true
{
mwqmSample.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
MWQMSampleLanguage mwqmSampleLanguage = validationContext.ObjectInstance as MWQMSampleLanguage;
mwqmSampleLanguage.HasErrors = false;
if (actionDBType == ActionDBTypeEnum.Update || actionDBType == ActionDBTypeEnum.Delete)
{
if (mwqmSampleLanguage.MWQMSampleLanguageID == 0)
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "MWQMSampleLanguageID"), new[] { "MWQMSampleLanguageID" }));
}
if (!(from c in db.MWQMSampleLanguages select c).Where(c => c.MWQMSampleLanguageID == mwqmSampleLanguage.MWQMSampleLanguageID).Any())
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "MWQMSampleLanguage", "MWQMSampleLanguageID", mwqmSampleLanguage.MWQMSampleLanguageID.ToString()), new[] { "MWQMSampleLanguageID" }));
}
}
MWQMSample MWQMSampleMWQMSampleID = (from c in db.MWQMSamples where c.MWQMSampleID == mwqmSampleLanguage.MWQMSampleID select c).FirstOrDefault();
if (MWQMSampleMWQMSampleID == null)
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "MWQMSample", "MWQMSampleID", mwqmSampleLanguage.MWQMSampleID.ToString()), new[] { "MWQMSampleID" }));
}
retStr = enums.EnumTypeOK(typeof(LanguageEnum), (int?)mwqmSampleLanguage.Language);
if (!string.IsNullOrWhiteSpace(retStr))
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "Language"), new[] { "Language" }));
}
if (string.IsNullOrWhiteSpace(mwqmSampleLanguage.MWQMSampleNote))
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "MWQMSampleNote"), new[] { "MWQMSampleNote" }));
}
//MWQMSampleNote has no StringLength Attribute
retStr = enums.EnumTypeOK(typeof(TranslationStatusEnum), (int?)mwqmSampleLanguage.TranslationStatus);
if (!string.IsNullOrWhiteSpace(retStr))
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "TranslationStatus"), new[] { "TranslationStatus" }));
}
if (mwqmSampleLanguage.LastUpdateDate_UTC.Year == 1)
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), new[] { "LastUpdateDate_UTC" }));
}
else
{
if (mwqmSampleLanguage.LastUpdateDate_UTC.Year < 1980)
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "LastUpdateDate_UTC", "1980"), new[] { "LastUpdateDate_UTC" }));
}
}
TVItem TVItemLastUpdateContactTVItemID = (from c in db.TVItems where c.TVItemID == mwqmSampleLanguage.LastUpdateContactTVItemID select c).FirstOrDefault();
if (TVItemLastUpdateContactTVItemID == null)
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", mwqmSampleLanguage.LastUpdateContactTVItemID.ToString()), new[] { "LastUpdateContactTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Contact,
};
if (!AllowableTVTypes.Contains(TVItemLastUpdateContactTVItemID.TVType))
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "LastUpdateContactTVItemID", "Contact"), new[] { "LastUpdateContactTVItemID" }));
}
}
retStr = ""; // added to stop compiling CSSPError
if (retStr != "") // will never be true
{
mwqmSampleLanguage.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
