public LabSheetTubeMPNDetailModel PostDeleteLabSheetTubeMPNDetailDB(int LabSheetTubeMPNDetailID)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
LabSheetTubeMPNDetail labSheetTubeMPNDetailToDelete = GetLabSheetTubeMPNDetailWithLabSheetTubeMPNDetailIDDB(LabSheetTubeMPNDetailID);
if (labSheetTubeMPNDetailToDelete == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToDelete, ServiceRes.LabSheetTubeMPNDetail)));
}
using (TransactionScope ts = new TransactionScope())
{
db.LabSheetTubeMPNDetails.Remove(labSheetTubeMPNDetailToDelete);
string retStr = DoDeleteChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("LabSheetTubeMPNDetails", labSheetTubeMPNDetailToDelete.LabSheetTubeMPNDetailID, LogCommandEnum.Delete, labSheetTubeMPNDetailToDelete);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(ReturnError(""));
}
// Fill
public string FillLabSheetTubeMPNDetail(LabSheetTubeMPNDetail labSheetTubeMPNDetail, LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModel, ContactOK contactOK)
{
labSheetTubeMPNDetail.DBCommand = (int)labSheetTubeMPNDetailModel.DBCommand;
labSheetTubeMPNDetail.LabSheetTubeMPNDetailID = labSheetTubeMPNDetailModel.LabSheetTubeMPNDetailID;
labSheetTubeMPNDetail.LabSheetDetailID = labSheetTubeMPNDetailModel.LabSheetDetailID;
labSheetTubeMPNDetail.Ordinal = labSheetTubeMPNDetailModel.Ordinal;
labSheetTubeMPNDetail.MWQMSiteTVItemID = labSheetTubeMPNDetailModel.MWQMSiteTVItemID;
labSheetTubeMPNDetail.SampleDateTime = labSheetTubeMPNDetailModel.SampleDateTime;
labSheetTubeMPNDetail.MPN = labSheetTubeMPNDetailModel.MPN;
labSheetTubeMPNDetail.Tube10 = labSheetTubeMPNDetailModel.Tube10;
labSheetTubeMPNDetail.Tube1_0 = labSheetTubeMPNDetailModel.Tube1_0;
labSheetTubeMPNDetail.Tube0_1 = labSheetTubeMPNDetailModel.Tube0_1;
labSheetTubeMPNDetail.Salinity = labSheetTubeMPNDetailModel.Salinity;
labSheetTubeMPNDetail.Temperature = labSheetTubeMPNDetailModel.Temperature;
labSheetTubeMPNDetail.ProcessedBy = labSheetTubeMPNDetailModel.ProcessedBy;
labSheetTubeMPNDetail.SampleType = (int)labSheetTubeMPNDetailModel.SampleType;
labSheetTubeMPNDetail.SiteComment = labSheetTubeMPNDetailModel.SiteComment;
labSheetTubeMPNDetail.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
labSheetTubeMPNDetail.LastUpdateContactTVItemID = 2;
}
else
{
labSheetTubeMPNDetail.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
public void LabSheetTubeMPNDetail_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
LabSheetTubeMPNDetailController labSheetTubeMPNDetailController = new LabSheetTubeMPNDetailController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(labSheetTubeMPNDetailController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetTubeMPNDetailController.DatabaseType);
LabSheetTubeMPNDetail labSheetTubeMPNDetailLast = new LabSheetTubeMPNDetail();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
LabSheetTubeMPNDetailService labSheetTubeMPNDetailService = new LabSheetTubeMPNDetailService(query, db, ContactID);
labSheetTubeMPNDetailLast = (from c in db.LabSheetTubeMPNDetails select c).FirstOrDefault();
}
// ok with LabSheetTubeMPNDetail info
IHttpActionResult jsonRet = labSheetTubeMPNDetailController.GetLabSheetTubeMPNDetailWithID(labSheetTubeMPNDetailLast.LabSheetTubeMPNDetailID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <LabSheetTubeMPNDetail> Ret = jsonRet as OkNegotiatedContentResult <LabSheetTubeMPNDetail>;
LabSheetTubeMPNDetail labSheetTubeMPNDetailRet = Ret.Content;
Assert.AreEqual(labSheetTubeMPNDetailLast.LabSheetTubeMPNDetailID, labSheetTubeMPNDetailRet.LabSheetTubeMPNDetailID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = labSheetTubeMPNDetailController.Put(labSheetTubeMPNDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <LabSheetTubeMPNDetail> labSheetTubeMPNDetailRet2 = jsonRet2 as OkNegotiatedContentResult <LabSheetTubeMPNDetail>;
Assert.IsNotNull(labSheetTubeMPNDetailRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because LabSheetTubeMPNDetailID of 0 does not exist
labSheetTubeMPNDetailRet.LabSheetTubeMPNDetailID = 0;
IHttpActionResult jsonRet3 = labSheetTubeMPNDetailController.Put(labSheetTubeMPNDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <LabSheetTubeMPNDetail> labSheetTubeMPNDetailRet3 = jsonRet3 as OkNegotiatedContentResult <LabSheetTubeMPNDetail>;
Assert.IsNull(labSheetTubeMPNDetailRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public LabSheetTubeMPNDetail GetLabSheetTubeMPNDetailWithLabSheetTubeMPNDetailIDDB(int LabSheetTubeMPNDetailID)
{
LabSheetTubeMPNDetail labSheetTubeMPNDetail = (from c in db.LabSheetTubeMPNDetails
where c.LabSheetTubeMPNDetailID == LabSheetTubeMPNDetailID
orderby c.Ordinal
select c).FirstOrDefault <LabSheetTubeMPNDetail>();
return(labSheetTubeMPNDetail);
}
// Post
public LabSheetTubeMPNDetailModel PostAddLabSheetTubeMPNDetailDB(LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModel)
{
string retStr = LabSheetTubeMPNDetailModelOK(labSheetTubeMPNDetailModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModelExist = GetLabSheetTubeMPNDetailModelExistDB(labSheetTubeMPNDetailModel);
if (string.IsNullOrWhiteSpace(labSheetTubeMPNDetailModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.LabSheetTubeMPNDetail)));
}
LabSheetTubeMPNDetail labSheetTubeMPNDetailNew = new LabSheetTubeMPNDetail();
retStr = FillLabSheetTubeMPNDetail(labSheetTubeMPNDetailNew, labSheetTubeMPNDetailModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.LabSheetTubeMPNDetails.Add(labSheetTubeMPNDetailNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("LabSheetTubeMPNDetails", labSheetTubeMPNDetailNew.LabSheetTubeMPNDetailID, LogCommandEnum.Add, labSheetTubeMPNDetailNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetLabSheetTubeMPNDetailModelWithLabSheetTubeMPNDetailIDDB(labSheetTubeMPNDetailNew.LabSheetTubeMPNDetailID));
}
public IHttpActionResult GetLabSheetTubeMPNDetailWithID([FromUri] int LabSheetTubeMPNDetailID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
LabSheetTubeMPNDetailService labSheetTubeMPNDetailService = new LabSheetTubeMPNDetailService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
labSheetTubeMPNDetailService.Query = labSheetTubeMPNDetailService.FillQuery(typeof(LabSheetTubeMPNDetail), lang, 0, 1, "", "", extra);
if (labSheetTubeMPNDetailService.Query.Extra == "A")
{
LabSheetTubeMPNDetailExtraA labSheetTubeMPNDetailExtraA = new LabSheetTubeMPNDetailExtraA();
labSheetTubeMPNDetailExtraA = labSheetTubeMPNDetailService.GetLabSheetTubeMPNDetailExtraAWithLabSheetTubeMPNDetailID(LabSheetTubeMPNDetailID);
if (labSheetTubeMPNDetailExtraA == null)
{
return(NotFound());
}
return(Ok(labSheetTubeMPNDetailExtraA));
}
else if (labSheetTubeMPNDetailService.Query.Extra == "B")
{
LabSheetTubeMPNDetailExtraB labSheetTubeMPNDetailExtraB = new LabSheetTubeMPNDetailExtraB();
labSheetTubeMPNDetailExtraB = labSheetTubeMPNDetailService.GetLabSheetTubeMPNDetailExtraBWithLabSheetTubeMPNDetailID(LabSheetTubeMPNDetailID);
if (labSheetTubeMPNDetailExtraB == null)
{
return(NotFound());
}
return(Ok(labSheetTubeMPNDetailExtraB));
}
else
{
LabSheetTubeMPNDetail labSheetTubeMPNDetail = new LabSheetTubeMPNDetail();
labSheetTubeMPNDetail = labSheetTubeMPNDetailService.GetLabSheetTubeMPNDetailWithLabSheetTubeMPNDetailID(LabSheetTubeMPNDetailID);
if (labSheetTubeMPNDetail == null)
{
return(NotFound());
}
return(Ok(labSheetTubeMPNDetail));
}
}
}
public string UploadLabSheetTubeMPNDetailInDB(int LabSheetDetailID, List <LabSheetA1Measurement> labSheetA1MeasurementList)
{
string retStr = "";
LabSheetTubeMPNDetailService labSheetTubeMPNDetailService = new LabSheetTubeMPNDetailService(LanguageEnum.en, _User);
int Ordinal = 0;
foreach (LabSheetA1Measurement labSheetA1Measurement in labSheetA1MeasurementList)
{
LabSheetTubeMPNDetail labSheetTubeMPNDetailNew = new LabSheetTubeMPNDetail();
labSheetTubeMPNDetailNew.LabSheetDetailID = LabSheetDetailID;
labSheetTubeMPNDetailNew.Ordinal = Ordinal;
labSheetTubeMPNDetailNew.MWQMSiteTVItemID = labSheetA1Measurement.TVItemID;
labSheetTubeMPNDetailNew.SampleDateTime = labSheetA1Measurement.Time;
labSheetTubeMPNDetailNew.MPN = labSheetA1Measurement.MPN;
labSheetTubeMPNDetailNew.Tube10 = labSheetA1Measurement.Tube10;
labSheetTubeMPNDetailNew.Tube1_0 = labSheetA1Measurement.Tube1_0;
labSheetTubeMPNDetailNew.Tube0_1 = labSheetA1Measurement.Tube0_1;
labSheetTubeMPNDetailNew.Salinity = labSheetA1Measurement.Salinity;
labSheetTubeMPNDetailNew.Temperature = labSheetA1Measurement.Temperature;
labSheetTubeMPNDetailNew.ProcessedBy = labSheetA1Measurement.ProcessedBy;
labSheetTubeMPNDetailNew.SampleType = (SampleTypeEnum)labSheetA1Measurement.SampleType;
labSheetTubeMPNDetailNew.SiteComment = labSheetA1Measurement.SiteComment;
LabSheetTubeMPNDetail labSheetTubeMPNDetailExist = labSheetTubeMPNDetailService.GetLabSheetTubeMPNDetailExistDB(labSheetTubeMPNDetailNew);
if (!string.IsNullOrWhiteSpace(labSheetTubeMPNDetailExist.Error))
{
labSheetTubeMPNDetailExist = labSheetTubeMPNDetailService.PostAddLabSheetTubeMPNDetailDB(labSheetTubeMPNDetailNew);
if (!string.IsNullOrWhiteSpace(labSheetTubeMPNDetailExist.Error))
{
return(labSheetTubeMPNDetailExist.Error);
}
}
else
{
labSheetTubeMPNDetailNew.LabSheetTubeMPNDetailID = labSheetTubeMPNDetailExist.LabSheetTubeMPNDetailID;
labSheetTubeMPNDetailExist = labSheetTubeMPNDetailService.PostUpdateLabSheetTubeMPNDetailDB(labSheetTubeMPNDetailNew);
if (!string.IsNullOrWhiteSpace(labSheetTubeMPNDetailExist.Error))
{
return(labSheetTubeMPNDetailExist.Error);
}
}
Ordinal += 1;
}
return(retStr);
}
/// <summary>
/// Tries to execute the CSSPDB transaction (add/delete/update) on an [LabSheetTubeMPNDetail](CSSPModels.LabSheetTubeMPNDetail.html) item
/// </summary>
/// <param name="labSheetTubeMPNDetail">Is the LabSheetTubeMPNDetail item the client want to add to CSSPDB. What's important here is the LabSheetTubeMPNDetailID</param>
/// <returns>true if LabSheetTubeMPNDetail item was updated to CSSPDB, false if an error happened during the DB requested transtaction</returns>
private bool TryToSave(LabSheetTubeMPNDetail labSheetTubeMPNDetail)
{
try
{
db.SaveChanges();
}
catch (DbUpdateException ex)
{
labSheetTubeMPNDetail.ValidationResults = new List <ValidationResult>()
{
new ValidationResult(ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""))
}.AsEnumerable();
return(false);
}
return(true);
}
/// <summary>
/// Updates an [LabSheetTubeMPNDetail](CSSPModels.LabSheetTubeMPNDetail.html) item in CSSPDB
/// </summary>
/// <param name="labSheetTubeMPNDetail">Is the LabSheetTubeMPNDetail item the client want to add to CSSPDB. What's important here is the LabSheetTubeMPNDetailID</param>
/// <returns>true if LabSheetTubeMPNDetail item was updated to CSSPDB, false if an error happened during the DB requested transtaction</returns>
public bool Update(LabSheetTubeMPNDetail labSheetTubeMPNDetail)
{
labSheetTubeMPNDetail.ValidationResults = Validate(new ValidationContext(labSheetTubeMPNDetail), ActionDBTypeEnum.Update);
if (labSheetTubeMPNDetail.ValidationResults.Count() > 0)
{
return(false);
}
db.LabSheetTubeMPNDetails.Update(labSheetTubeMPNDetail);
if (!TryToSave(labSheetTubeMPNDetail))
{
return(false);
}
return(true);
}
public void LabSheetTubeMPNDetail_Controller_GetLabSheetTubeMPNDetailWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
LabSheetTubeMPNDetailController labSheetTubeMPNDetailController = new LabSheetTubeMPNDetailController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(labSheetTubeMPNDetailController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetTubeMPNDetailController.DatabaseType);
LabSheetTubeMPNDetail labSheetTubeMPNDetailFirst = new LabSheetTubeMPNDetail();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
LabSheetTubeMPNDetailService labSheetTubeMPNDetailService = new LabSheetTubeMPNDetailService(new Query(), db, ContactID);
labSheetTubeMPNDetailFirst = (from c in db.LabSheetTubeMPNDetails select c).FirstOrDefault();
}
// ok with LabSheetTubeMPNDetail info
IHttpActionResult jsonRet = labSheetTubeMPNDetailController.GetLabSheetTubeMPNDetailWithID(labSheetTubeMPNDetailFirst.LabSheetTubeMPNDetailID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <LabSheetTubeMPNDetail> Ret = jsonRet as OkNegotiatedContentResult <LabSheetTubeMPNDetail>;
LabSheetTubeMPNDetail labSheetTubeMPNDetailRet = Ret.Content;
Assert.AreEqual(labSheetTubeMPNDetailFirst.LabSheetTubeMPNDetailID, labSheetTubeMPNDetailRet.LabSheetTubeMPNDetailID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = labSheetTubeMPNDetailController.GetLabSheetTubeMPNDetailWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <LabSheetTubeMPNDetail> labSheetTubeMPNDetailRet2 = jsonRet2 as OkNegotiatedContentResult <LabSheetTubeMPNDetail>;
Assert.IsNull(labSheetTubeMPNDetailRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public IHttpActionResult Delete([FromBody] LabSheetTubeMPNDetail labSheetTubeMPNDetail, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
LabSheetTubeMPNDetailService labSheetTubeMPNDetailService = new LabSheetTubeMPNDetailService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!labSheetTubeMPNDetailService.Delete(labSheetTubeMPNDetail))
{
return(BadRequest(String.Join("|||", labSheetTubeMPNDetail.ValidationResults)));
}
else
{
labSheetTubeMPNDetail.ValidationResults = null;
return(Ok(labSheetTubeMPNDetail));
}
}
}
/// <summary>
/// Validate function for all LabSheetTubeMPNDetailService commands
/// </summary>
/// <param name="validationContext">System.ComponentModel.DataAnnotations.ValidationContext (Describes the context in which a validation check is performed.)</param>
/// <param name="actionDBType">[ActionDBTypeEnum] (CSSPEnums.ActionDBTypeEnum.html) action type to validate</param>
/// <returns>IEnumerable of ValidationResult (Where ValidationResult is a container for the results of a validation request.)</returns>
private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
LabSheetTubeMPNDetail labSheetTubeMPNDetail = validationContext.ObjectInstance as LabSheetTubeMPNDetail;
labSheetTubeMPNDetail.HasErrors = false;
if (actionDBType == ActionDBTypeEnum.Update || actionDBType == ActionDBTypeEnum.Delete)
{
if (labSheetTubeMPNDetail.LabSheetTubeMPNDetailID == 0)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LabSheetTubeMPNDetailID"), new[] { "LabSheetTubeMPNDetailID" }));
}
if (!(from c in db.LabSheetTubeMPNDetails select c).Where(c => c.LabSheetTubeMPNDetailID == labSheetTubeMPNDetail.LabSheetTubeMPNDetailID).Any())
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "LabSheetTubeMPNDetail", "LabSheetTubeMPNDetailID", labSheetTubeMPNDetail.LabSheetTubeMPNDetailID.ToString()), new[] { "LabSheetTubeMPNDetailID" }));
}
}
LabSheetDetail LabSheetDetailLabSheetDetailID = (from c in db.LabSheetDetails where c.LabSheetDetailID == labSheetTubeMPNDetail.LabSheetDetailID select c).FirstOrDefault();
if (LabSheetDetailLabSheetDetailID == null)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "LabSheetDetail", "LabSheetDetailID", labSheetTubeMPNDetail.LabSheetDetailID.ToString()), new[] { "LabSheetDetailID" }));
}
if (labSheetTubeMPNDetail.Ordinal < 0 || labSheetTubeMPNDetail.Ordinal > 1000)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Ordinal", "0", "1000"), new[] { "Ordinal" }));
}
TVItem TVItemMWQMSiteTVItemID = (from c in db.TVItems where c.TVItemID == labSheetTubeMPNDetail.MWQMSiteTVItemID select c).FirstOrDefault();
if (TVItemMWQMSiteTVItemID == null)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "MWQMSiteTVItemID", labSheetTubeMPNDetail.MWQMSiteTVItemID.ToString()), new[] { "MWQMSiteTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.MWQMSite,
};
if (!AllowableTVTypes.Contains(TVItemMWQMSiteTVItemID.TVType))
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "MWQMSiteTVItemID", "MWQMSite"), new[] { "MWQMSiteTVItemID" }));
}
}
if (labSheetTubeMPNDetail.SampleDateTime != null && ((DateTime)labSheetTubeMPNDetail.SampleDateTime).Year < 1980)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "SampleDateTime", "1980"), new[] { "SampleDateTime" }));
}
if (labSheetTubeMPNDetail.MPN != null)
{
if (labSheetTubeMPNDetail.MPN < 1 || labSheetTubeMPNDetail.MPN > 10000000)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "MPN", "1", "10000000"), new[] { "MPN" }));
}
}
if (labSheetTubeMPNDetail.Tube10 != null)
{
if (labSheetTubeMPNDetail.Tube10 < 0 || labSheetTubeMPNDetail.Tube10 > 5)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Tube10", "0", "5"), new[] { "Tube10" }));
}
}
if (labSheetTubeMPNDetail.Tube1_0 != null)
{
if (labSheetTubeMPNDetail.Tube1_0 < 0 || labSheetTubeMPNDetail.Tube1_0 > 5)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Tube1_0", "0", "5"), new[] { "Tube1_0" }));
}
}
if (labSheetTubeMPNDetail.Tube0_1 != null)
{
if (labSheetTubeMPNDetail.Tube0_1 < 0 || labSheetTubeMPNDetail.Tube0_1 > 5)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Tube0_1", "0", "5"), new[] { "Tube0_1" }));
}
}
if (labSheetTubeMPNDetail.Salinity != null)
{
if (labSheetTubeMPNDetail.Salinity < 0 || labSheetTubeMPNDetail.Salinity > 40)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Salinity", "0", "40"), new[] { "Salinity" }));
}
}
if (labSheetTubeMPNDetail.Temperature != null)
{
if (labSheetTubeMPNDetail.Temperature < -10 || labSheetTubeMPNDetail.Temperature > 40)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Temperature", "-10", "40"), new[] { "Temperature" }));
}
}
if (!string.IsNullOrWhiteSpace(labSheetTubeMPNDetail.ProcessedBy) && labSheetTubeMPNDetail.ProcessedBy.Length > 10)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "ProcessedBy", "10"), new[] { "ProcessedBy" }));
}
retStr = enums.EnumTypeOK(typeof(SampleTypeEnum), (int?)labSheetTubeMPNDetail.SampleType);
if (!string.IsNullOrWhiteSpace(retStr))
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "SampleType"), new[] { "SampleType" }));
}
if (!string.IsNullOrWhiteSpace(labSheetTubeMPNDetail.SiteComment) && labSheetTubeMPNDetail.SiteComment.Length > 250)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "SiteComment", "250"), new[] { "SiteComment" }));
}
if (labSheetTubeMPNDetail.LastUpdateDate_UTC.Year == 1)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), new[] { "LastUpdateDate_UTC" }));
}
else
{
if (labSheetTubeMPNDetail.LastUpdateDate_UTC.Year < 1980)
{
labSheetTubeMPNDetail.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 == labSheetTubeMPNDetail.LastUpdateContactTVItemID select c).FirstOrDefault();
if (TVItemLastUpdateContactTVItemID == null)
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", labSheetTubeMPNDetail.LastUpdateContactTVItemID.ToString()), new[] { "LastUpdateContactTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Contact,
};
if (!AllowableTVTypes.Contains(TVItemLastUpdateContactTVItemID.TVType))
{
labSheetTubeMPNDetail.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
{
labSheetTubeMPNDetail.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
public void LabSheetTubeMPNDetail_Controller_GetLabSheetTubeMPNDetailList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
LabSheetTubeMPNDetailController labSheetTubeMPNDetailController = new LabSheetTubeMPNDetailController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(labSheetTubeMPNDetailController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetTubeMPNDetailController.DatabaseType);
LabSheetTubeMPNDetail labSheetTubeMPNDetailFirst = new LabSheetTubeMPNDetail();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
LabSheetTubeMPNDetailService labSheetTubeMPNDetailService = new LabSheetTubeMPNDetailService(query, db, ContactID);
labSheetTubeMPNDetailFirst = (from c in db.LabSheetTubeMPNDetails select c).FirstOrDefault();
count = (from c in db.LabSheetTubeMPNDetails select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with LabSheetTubeMPNDetail info
IHttpActionResult jsonRet = labSheetTubeMPNDetailController.GetLabSheetTubeMPNDetailList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <LabSheetTubeMPNDetail> > ret = jsonRet as OkNegotiatedContentResult <List <LabSheetTubeMPNDetail> >;
Assert.AreEqual(labSheetTubeMPNDetailFirst.LabSheetTubeMPNDetailID, ret.Content[0].LabSheetTubeMPNDetailID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <LabSheetTubeMPNDetail> labSheetTubeMPNDetailList = new List <LabSheetTubeMPNDetail>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
LabSheetTubeMPNDetailService labSheetTubeMPNDetailService = new LabSheetTubeMPNDetailService(query, db, ContactID);
labSheetTubeMPNDetailList = (from c in db.LabSheetTubeMPNDetails select c).OrderBy(c => c.LabSheetTubeMPNDetailID).Skip(0).Take(2).ToList();
count = (from c in db.LabSheetTubeMPNDetails select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with LabSheetTubeMPNDetail info
jsonRet = labSheetTubeMPNDetailController.GetLabSheetTubeMPNDetailList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <LabSheetTubeMPNDetail> >;
Assert.AreEqual(labSheetTubeMPNDetailList[0].LabSheetTubeMPNDetailID, ret.Content[0].LabSheetTubeMPNDetailID);
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 LabSheetTubeMPNDetail info
IHttpActionResult jsonRet2 = labSheetTubeMPNDetailController.GetLabSheetTubeMPNDetailList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <LabSheetTubeMPNDetail> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <LabSheetTubeMPNDetail> >;
Assert.AreEqual(labSheetTubeMPNDetailList[1].LabSheetTubeMPNDetailID, ret2.Content[0].LabSheetTubeMPNDetailID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void LabSheetTubeMPNDetail_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
LabSheetTubeMPNDetailController labSheetTubeMPNDetailController = new LabSheetTubeMPNDetailController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(labSheetTubeMPNDetailController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetTubeMPNDetailController.DatabaseType);
LabSheetTubeMPNDetail labSheetTubeMPNDetailLast = new LabSheetTubeMPNDetail();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
LabSheetTubeMPNDetailService labSheetTubeMPNDetailService = new LabSheetTubeMPNDetailService(query, db, ContactID);
labSheetTubeMPNDetailLast = (from c in db.LabSheetTubeMPNDetails select c).FirstOrDefault();
}
// ok with LabSheetTubeMPNDetail info
IHttpActionResult jsonRet = labSheetTubeMPNDetailController.GetLabSheetTubeMPNDetailWithID(labSheetTubeMPNDetailLast.LabSheetTubeMPNDetailID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <LabSheetTubeMPNDetail> Ret = jsonRet as OkNegotiatedContentResult <LabSheetTubeMPNDetail>;
LabSheetTubeMPNDetail labSheetTubeMPNDetailRet = Ret.Content;
Assert.AreEqual(labSheetTubeMPNDetailLast.LabSheetTubeMPNDetailID, labSheetTubeMPNDetailRet.LabSheetTubeMPNDetailID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because LabSheetTubeMPNDetailID exist
IHttpActionResult jsonRet2 = labSheetTubeMPNDetailController.Post(labSheetTubeMPNDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <LabSheetTubeMPNDetail> labSheetTubeMPNDetailRet2 = jsonRet2 as OkNegotiatedContentResult <LabSheetTubeMPNDetail>;
Assert.IsNull(labSheetTubeMPNDetailRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added LabSheetTubeMPNDetail
labSheetTubeMPNDetailRet.LabSheetTubeMPNDetailID = 0;
labSheetTubeMPNDetailController.Request = new System.Net.Http.HttpRequestMessage();
labSheetTubeMPNDetailController.Request.RequestUri = new System.Uri("http://localhost:5000/api/labSheetTubeMPNDetail");
IHttpActionResult jsonRet3 = labSheetTubeMPNDetailController.Post(labSheetTubeMPNDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <LabSheetTubeMPNDetail> labSheetTubeMPNDetailRet3 = jsonRet3 as CreatedNegotiatedContentResult <LabSheetTubeMPNDetail>;
Assert.IsNotNull(labSheetTubeMPNDetailRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = labSheetTubeMPNDetailController.Delete(labSheetTubeMPNDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <LabSheetTubeMPNDetail> labSheetTubeMPNDetailRet4 = jsonRet4 as OkNegotiatedContentResult <LabSheetTubeMPNDetail>;
Assert.IsNotNull(labSheetTubeMPNDetailRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
public LabSheetTubeMPNDetailTest()
{
labSheetTubeMPNDetail = new LabSheetTubeMPNDetail();
labSheetTubeMPNDetailExtraA = new LabSheetTubeMPNDetailExtraA();
labSheetTubeMPNDetailExtraB = new LabSheetTubeMPNDetailExtraB();
}
