public void LabSheetDetail_Controller_Put_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
LabSheetDetailController labSheetDetailController = new LabSheetDetailController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(labSheetDetailController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetDetailController.DatabaseType);
LabSheetDetail labSheetDetailLast = new LabSheetDetail();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
LabSheetDetailService labSheetDetailService = new LabSheetDetailService(query, db, ContactID);
labSheetDetailLast = (from c in db.LabSheetDetails select c).FirstOrDefault();
}
// ok with LabSheetDetail info
IHttpActionResult jsonRet = labSheetDetailController.GetLabSheetDetailWithID(labSheetDetailLast.LabSheetDetailID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <LabSheetDetail> Ret = jsonRet as OkNegotiatedContentResult <LabSheetDetail>;
LabSheetDetail labSheetDetailRet = Ret.Content;
Assert.AreEqual(labSheetDetailLast.LabSheetDetailID, labSheetDetailRet.LabSheetDetailID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Put to return success
IHttpActionResult jsonRet2 = labSheetDetailController.Put(labSheetDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <LabSheetDetail> labSheetDetailRet2 = jsonRet2 as OkNegotiatedContentResult <LabSheetDetail>;
Assert.IsNotNull(labSheetDetailRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest2);
// Put to return CSSPError because LabSheetDetailID of 0 does not exist
labSheetDetailRet.LabSheetDetailID = 0;
IHttpActionResult jsonRet3 = labSheetDetailController.Put(labSheetDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
OkNegotiatedContentResult <LabSheetDetail> labSheetDetailRet3 = jsonRet3 as OkNegotiatedContentResult <LabSheetDetail>;
Assert.IsNull(labSheetDetailRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest3);
}
}
}
public IHttpActionResult GetLabSheetDetailWithID([FromUri] int LabSheetDetailID, [FromUri] string lang = "en", [FromUri] string extra = "")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
LabSheetDetailService labSheetDetailService = new LabSheetDetailService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
labSheetDetailService.Query = labSheetDetailService.FillQuery(typeof(LabSheetDetail), lang, 0, 1, "", "", extra);
if (labSheetDetailService.Query.Extra == "A")
{
LabSheetDetailExtraA labSheetDetailExtraA = new LabSheetDetailExtraA();
labSheetDetailExtraA = labSheetDetailService.GetLabSheetDetailExtraAWithLabSheetDetailID(LabSheetDetailID);
if (labSheetDetailExtraA == null)
{
return(NotFound());
}
return(Ok(labSheetDetailExtraA));
}
else if (labSheetDetailService.Query.Extra == "B")
{
LabSheetDetailExtraB labSheetDetailExtraB = new LabSheetDetailExtraB();
labSheetDetailExtraB = labSheetDetailService.GetLabSheetDetailExtraBWithLabSheetDetailID(LabSheetDetailID);
if (labSheetDetailExtraB == null)
{
return(NotFound());
}
return(Ok(labSheetDetailExtraB));
}
else
{
LabSheetDetail labSheetDetail = new LabSheetDetail();
labSheetDetail = labSheetDetailService.GetLabSheetDetailWithLabSheetDetailID(LabSheetDetailID);
if (labSheetDetail == null)
{
return(NotFound());
}
return(Ok(labSheetDetail));
}
}
}
private bool TryToSave(LabSheetDetail labSheetDetail)
{
try
{
db.SaveChanges();
}
catch (DbUpdateException ex)
{
labSheetDetail.ValidationResults = new List <ValidationResult>()
{
new ValidationResult(ex.Message + (ex.InnerException != null ? " Inner: " + ex.InnerException.Message : ""))
}.AsEnumerable();
return(false);
}
return(true);
}
public bool Update(LabSheetDetail labSheetDetail)
{
labSheetDetail.ValidationResults = Validate(new ValidationContext(labSheetDetail), ActionDBTypeEnum.Update);
if (labSheetDetail.ValidationResults.Count() > 0)
{
return(false);
}
db.LabSheetDetails.Update(labSheetDetail);
if (!TryToSave(labSheetDetail))
{
return(false);
}
return(true);
}
public void LabSheetDetail_Controller_GetLabSheetDetailWithID_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
LabSheetDetailController labSheetDetailController = new LabSheetDetailController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(labSheetDetailController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetDetailController.DatabaseType);
LabSheetDetail labSheetDetailFirst = new LabSheetDetail();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
LabSheetDetailService labSheetDetailService = new LabSheetDetailService(new Query(), db, ContactID);
labSheetDetailFirst = (from c in db.LabSheetDetails select c).FirstOrDefault();
}
// ok with LabSheetDetail info
IHttpActionResult jsonRet = labSheetDetailController.GetLabSheetDetailWithID(labSheetDetailFirst.LabSheetDetailID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <LabSheetDetail> Ret = jsonRet as OkNegotiatedContentResult <LabSheetDetail>;
LabSheetDetail labSheetDetailRet = Ret.Content;
Assert.AreEqual(labSheetDetailFirst.LabSheetDetailID, labSheetDetailRet.LabSheetDetailID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Not Found
IHttpActionResult jsonRet2 = labSheetDetailController.GetLabSheetDetailWithID(0);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <LabSheetDetail> labSheetDetailRet2 = jsonRet2 as OkNegotiatedContentResult <LabSheetDetail>;
Assert.IsNull(labSheetDetailRet2);
NotFoundResult notFoundRequest = jsonRet2 as NotFoundResult;
Assert.IsNotNull(notFoundRequest);
}
}
}
public IHttpActionResult Delete([FromBody] LabSheetDetail labSheetDetail, [FromUri] string lang = "en")
{
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
LabSheetDetailService labSheetDetailService = new LabSheetDetailService(new Query()
{
Language = (lang == "fr" ? LanguageEnum.fr : LanguageEnum.en)
}, db, ContactID);
if (!labSheetDetailService.Delete(labSheetDetail))
{
return(BadRequest(String.Join("|||", labSheetDetail.ValidationResults)));
}
else
{
labSheetDetail.ValidationResults = null;
return(Ok(labSheetDetail));
}
}
}
/// <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 LabSheetDetail_Controller_GetLabSheetDetailList_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
LabSheetDetailController labSheetDetailController = new LabSheetDetailController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(labSheetDetailController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetDetailController.DatabaseType);
LabSheetDetail labSheetDetailFirst = new LabSheetDetail();
int count = -1;
Query query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
LabSheetDetailService labSheetDetailService = new LabSheetDetailService(query, db, ContactID);
labSheetDetailFirst = (from c in db.LabSheetDetails select c).FirstOrDefault();
count = (from c in db.LabSheetDetails select c).Count();
count = (query.Take > count ? count : query.Take);
}
// ok with LabSheetDetail info
IHttpActionResult jsonRet = labSheetDetailController.GetLabSheetDetailList();
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <List <LabSheetDetail> > ret = jsonRet as OkNegotiatedContentResult <List <LabSheetDetail> >;
Assert.AreEqual(labSheetDetailFirst.LabSheetDetailID, ret.Content[0].LabSheetDetailID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count);
List <LabSheetDetail> labSheetDetailList = new List <LabSheetDetail>();
count = -1;
query = new Query();
using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB))
{
LabSheetDetailService labSheetDetailService = new LabSheetDetailService(query, db, ContactID);
labSheetDetailList = (from c in db.LabSheetDetails select c).OrderBy(c => c.LabSheetDetailID).Skip(0).Take(2).ToList();
count = (from c in db.LabSheetDetails select c).Count();
}
if (count > 0)
{
query.Skip = 0;
query.Take = 5;
count = (query.Take > count ? query.Take : count);
// ok with LabSheetDetail info
jsonRet = labSheetDetailController.GetLabSheetDetailList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet);
ret = jsonRet as OkNegotiatedContentResult <List <LabSheetDetail> >;
Assert.AreEqual(labSheetDetailList[0].LabSheetDetailID, ret.Content[0].LabSheetDetailID);
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 LabSheetDetail info
IHttpActionResult jsonRet2 = labSheetDetailController.GetLabSheetDetailList(query.Language.ToString(), query.Skip, query.Take);
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <List <LabSheetDetail> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <LabSheetDetail> >;
Assert.AreEqual(labSheetDetailList[1].LabSheetDetailID, ret2.Content[0].LabSheetDetailID);
Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count);
}
}
}
}
}
public void LabSheetDetail_Controller_Post_Test()
{
foreach (LanguageEnum LanguageRequest in AllowableLanguages)
{
foreach (int ContactID in new List <int>()
{
AdminContactID
}) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID })
{
LabSheetDetailController labSheetDetailController = new LabSheetDetailController(DatabaseTypeEnum.SqlServerTestDB);
Assert.IsNotNull(labSheetDetailController);
Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, labSheetDetailController.DatabaseType);
LabSheetDetail labSheetDetailLast = new LabSheetDetail();
using (CSSPDBContext db = new CSSPDBContext(DatabaseType))
{
Query query = new Query();
query.Language = LanguageRequest;
query.Asc = "";
query.Desc = "";
LabSheetDetailService labSheetDetailService = new LabSheetDetailService(query, db, ContactID);
labSheetDetailLast = (from c in db.LabSheetDetails select c).FirstOrDefault();
}
// ok with LabSheetDetail info
IHttpActionResult jsonRet = labSheetDetailController.GetLabSheetDetailWithID(labSheetDetailLast.LabSheetDetailID);
Assert.IsNotNull(jsonRet);
OkNegotiatedContentResult <LabSheetDetail> Ret = jsonRet as OkNegotiatedContentResult <LabSheetDetail>;
LabSheetDetail labSheetDetailRet = Ret.Content;
Assert.AreEqual(labSheetDetailLast.LabSheetDetailID, labSheetDetailRet.LabSheetDetailID);
BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult;
Assert.IsNull(badRequest);
// Post to return CSSPError because LabSheetDetailID exist
IHttpActionResult jsonRet2 = labSheetDetailController.Post(labSheetDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet2);
OkNegotiatedContentResult <LabSheetDetail> labSheetDetailRet2 = jsonRet2 as OkNegotiatedContentResult <LabSheetDetail>;
Assert.IsNull(labSheetDetailRet2);
BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult;
Assert.IsNotNull(badRequest2);
// Post to return newly added LabSheetDetail
labSheetDetailRet.LabSheetDetailID = 0;
labSheetDetailController.Request = new System.Net.Http.HttpRequestMessage();
labSheetDetailController.Request.RequestUri = new System.Uri("http://localhost:5000/api/labSheetDetail");
IHttpActionResult jsonRet3 = labSheetDetailController.Post(labSheetDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet3);
CreatedNegotiatedContentResult <LabSheetDetail> labSheetDetailRet3 = jsonRet3 as CreatedNegotiatedContentResult <LabSheetDetail>;
Assert.IsNotNull(labSheetDetailRet3);
BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest3);
IHttpActionResult jsonRet4 = labSheetDetailController.Delete(labSheetDetailRet, LanguageRequest.ToString());
Assert.IsNotNull(jsonRet4);
OkNegotiatedContentResult <LabSheetDetail> labSheetDetailRet4 = jsonRet4 as OkNegotiatedContentResult <LabSheetDetail>;
Assert.IsNotNull(labSheetDetailRet4);
BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult;
Assert.IsNull(badRequest4);
}
}
}
private IEnumerable <ValidationResult> Validate(ValidationContext validationContext, ActionDBTypeEnum actionDBType)
{
string retStr = "";
Enums enums = new Enums(LanguageRequest);
LabSheetDetail labSheetDetail = validationContext.ObjectInstance as LabSheetDetail;
labSheetDetail.HasErrors = false;
if (actionDBType == ActionDBTypeEnum.Update || actionDBType == ActionDBTypeEnum.Delete)
{
if (labSheetDetail.LabSheetDetailID == 0)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LabSheetDetailID"), new[] { "LabSheetDetailID" }));
}
if (!(from c in db.LabSheetDetails select c).Where(c => c.LabSheetDetailID == labSheetDetail.LabSheetDetailID).Any())
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "LabSheetDetail", "LabSheetDetailID", labSheetDetail.LabSheetDetailID.ToString()), new[] { "LabSheetDetailID" }));
}
}
LabSheet LabSheetLabSheetID = (from c in db.LabSheets where c.LabSheetID == labSheetDetail.LabSheetID select c).FirstOrDefault();
if (LabSheetLabSheetID == null)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "LabSheet", "LabSheetID", labSheetDetail.LabSheetID.ToString()), new[] { "LabSheetID" }));
}
SamplingPlan SamplingPlanSamplingPlanID = (from c in db.SamplingPlans where c.SamplingPlanID == labSheetDetail.SamplingPlanID select c).FirstOrDefault();
if (SamplingPlanSamplingPlanID == null)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "SamplingPlan", "SamplingPlanID", labSheetDetail.SamplingPlanID.ToString()), new[] { "SamplingPlanID" }));
}
TVItem TVItemSubsectorTVItemID = (from c in db.TVItems where c.TVItemID == labSheetDetail.SubsectorTVItemID select c).FirstOrDefault();
if (TVItemSubsectorTVItemID == null)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "SubsectorTVItemID", labSheetDetail.SubsectorTVItemID.ToString()), new[] { "SubsectorTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Subsector,
};
if (!AllowableTVTypes.Contains(TVItemSubsectorTVItemID.TVType))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsNotOfType_, "SubsectorTVItemID", "Subsector"), new[] { "SubsectorTVItemID" }));
}
}
if (labSheetDetail.Version < 1 || labSheetDetail.Version > 5)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "Version", "1", "5"), new[] { "Version" }));
}
if (labSheetDetail.RunDate.Year == 1)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "RunDate"), new[] { "RunDate" }));
}
else
{
if (labSheetDetail.RunDate.Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "RunDate", "1980"), new[] { "RunDate" }));
}
}
if (string.IsNullOrWhiteSpace(labSheetDetail.Tides))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "Tides"), new[] { "Tides" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Tides) && (labSheetDetail.Tides.Length < 1 || labSheetDetail.Tides.Length > 7))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Tides", "1", "7"), new[] { "Tides" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.SampleCrewInitials) && labSheetDetail.SampleCrewInitials.Length > 20)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "SampleCrewInitials", "20"), new[] { "SampleCrewInitials" }));
}
if (labSheetDetail.WaterBathCount != null)
{
if (labSheetDetail.WaterBathCount < 1 || labSheetDetail.WaterBathCount > 3)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "WaterBathCount", "1", "3"), new[] { "WaterBathCount" }));
}
}
if (labSheetDetail.IncubationBath1StartTime != null && ((DateTime)labSheetDetail.IncubationBath1StartTime).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "IncubationBath1StartTime", "1980"), new[] { "IncubationBath1StartTime" }));
}
if (labSheetDetail.IncubationBath2StartTime != null && ((DateTime)labSheetDetail.IncubationBath2StartTime).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "IncubationBath2StartTime", "1980"), new[] { "IncubationBath2StartTime" }));
}
if (labSheetDetail.IncubationBath3StartTime != null && ((DateTime)labSheetDetail.IncubationBath3StartTime).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "IncubationBath3StartTime", "1980"), new[] { "IncubationBath3StartTime" }));
}
if (labSheetDetail.IncubationBath1EndTime != null && ((DateTime)labSheetDetail.IncubationBath1EndTime).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "IncubationBath1EndTime", "1980"), new[] { "IncubationBath1EndTime" }));
}
if (labSheetDetail.IncubationBath2EndTime != null && ((DateTime)labSheetDetail.IncubationBath2EndTime).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "IncubationBath2EndTime", "1980"), new[] { "IncubationBath2EndTime" }));
}
if (labSheetDetail.IncubationBath3EndTime != null && ((DateTime)labSheetDetail.IncubationBath3EndTime).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "IncubationBath3EndTime", "1980"), new[] { "IncubationBath3EndTime" }));
}
if (labSheetDetail.IncubationBath1TimeCalculated_minutes != null)
{
if (labSheetDetail.IncubationBath1TimeCalculated_minutes < 0 || labSheetDetail.IncubationBath1TimeCalculated_minutes > 10000)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "IncubationBath1TimeCalculated_minutes", "0", "10000"), new[] { "IncubationBath1TimeCalculated_minutes" }));
}
}
if (labSheetDetail.IncubationBath2TimeCalculated_minutes != null)
{
if (labSheetDetail.IncubationBath2TimeCalculated_minutes < 0 || labSheetDetail.IncubationBath2TimeCalculated_minutes > 10000)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "IncubationBath2TimeCalculated_minutes", "0", "10000"), new[] { "IncubationBath2TimeCalculated_minutes" }));
}
}
if (labSheetDetail.IncubationBath3TimeCalculated_minutes != null)
{
if (labSheetDetail.IncubationBath3TimeCalculated_minutes < 0 || labSheetDetail.IncubationBath3TimeCalculated_minutes > 10000)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "IncubationBath3TimeCalculated_minutes", "0", "10000"), new[] { "IncubationBath3TimeCalculated_minutes" }));
}
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.WaterBath1) && labSheetDetail.WaterBath1.Length > 10)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "WaterBath1", "10"), new[] { "WaterBath1" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.WaterBath2) && labSheetDetail.WaterBath2.Length > 10)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "WaterBath2", "10"), new[] { "WaterBath2" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.WaterBath3) && labSheetDetail.WaterBath3.Length > 10)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "WaterBath3", "10"), new[] { "WaterBath3" }));
}
if (labSheetDetail.TCField1 != null)
{
if (labSheetDetail.TCField1 < -10 || labSheetDetail.TCField1 > 40)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TCField1", "-10", "40"), new[] { "TCField1" }));
}
}
if (labSheetDetail.TCLab1 != null)
{
if (labSheetDetail.TCLab1 < -10 || labSheetDetail.TCLab1 > 40)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TCLab1", "-10", "40"), new[] { "TCLab1" }));
}
}
if (labSheetDetail.TCField2 != null)
{
if (labSheetDetail.TCField2 < -10 || labSheetDetail.TCField2 > 40)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TCField2", "-10", "40"), new[] { "TCField2" }));
}
}
if (labSheetDetail.TCLab2 != null)
{
if (labSheetDetail.TCLab2 < -10 || labSheetDetail.TCLab2 > 40)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TCLab2", "-10", "40"), new[] { "TCLab2" }));
}
}
if (labSheetDetail.TCFirst != null)
{
if (labSheetDetail.TCFirst < -10 || labSheetDetail.TCFirst > 40)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TCFirst", "-10", "40"), new[] { "TCFirst" }));
}
}
if (labSheetDetail.TCAverage != null)
{
if (labSheetDetail.TCAverage < -10 || labSheetDetail.TCAverage > 40)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "TCAverage", "-10", "40"), new[] { "TCAverage" }));
}
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.ControlLot) && labSheetDetail.ControlLot.Length > 100)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "ControlLot", "100"), new[] { "ControlLot" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Positive35) && (labSheetDetail.Positive35.Length < 1 || labSheetDetail.Positive35.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Positive35", "1", "1"), new[] { "Positive35" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.NonTarget35) && (labSheetDetail.NonTarget35.Length < 1 || labSheetDetail.NonTarget35.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "NonTarget35", "1", "1"), new[] { "NonTarget35" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Negative35) && (labSheetDetail.Negative35.Length < 1 || labSheetDetail.Negative35.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Negative35", "1", "1"), new[] { "Negative35" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath1Positive44_5) && (labSheetDetail.Bath1Positive44_5.Length < 1 || labSheetDetail.Bath1Positive44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath1Positive44_5", "1", "1"), new[] { "Bath1Positive44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath2Positive44_5) && (labSheetDetail.Bath2Positive44_5.Length < 1 || labSheetDetail.Bath2Positive44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath2Positive44_5", "1", "1"), new[] { "Bath2Positive44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath3Positive44_5) && (labSheetDetail.Bath3Positive44_5.Length < 1 || labSheetDetail.Bath3Positive44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath3Positive44_5", "1", "1"), new[] { "Bath3Positive44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath1NonTarget44_5) && (labSheetDetail.Bath1NonTarget44_5.Length < 1 || labSheetDetail.Bath1NonTarget44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath1NonTarget44_5", "1", "1"), new[] { "Bath1NonTarget44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath2NonTarget44_5) && (labSheetDetail.Bath2NonTarget44_5.Length < 1 || labSheetDetail.Bath2NonTarget44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath2NonTarget44_5", "1", "1"), new[] { "Bath2NonTarget44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath3NonTarget44_5) && (labSheetDetail.Bath3NonTarget44_5.Length < 1 || labSheetDetail.Bath3NonTarget44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath3NonTarget44_5", "1", "1"), new[] { "Bath3NonTarget44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath1Negative44_5) && (labSheetDetail.Bath1Negative44_5.Length < 1 || labSheetDetail.Bath1Negative44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath1Negative44_5", "1", "1"), new[] { "Bath1Negative44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath2Negative44_5) && (labSheetDetail.Bath2Negative44_5.Length < 1 || labSheetDetail.Bath2Negative44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath2Negative44_5", "1", "1"), new[] { "Bath2Negative44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath3Negative44_5) && (labSheetDetail.Bath3Negative44_5.Length < 1 || labSheetDetail.Bath3Negative44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath3Negative44_5", "1", "1"), new[] { "Bath3Negative44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Blank35) && (labSheetDetail.Blank35.Length < 1 || labSheetDetail.Blank35.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Blank35", "1", "1"), new[] { "Blank35" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath1Blank44_5) && (labSheetDetail.Bath1Blank44_5.Length < 1 || labSheetDetail.Bath1Blank44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath1Blank44_5", "1", "1"), new[] { "Bath1Blank44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath2Blank44_5) && (labSheetDetail.Bath2Blank44_5.Length < 1 || labSheetDetail.Bath2Blank44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath2Blank44_5", "1", "1"), new[] { "Bath2Blank44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Bath3Blank44_5) && (labSheetDetail.Bath3Blank44_5.Length < 1 || labSheetDetail.Bath3Blank44_5.Length > 1))
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._LengthShouldBeBetween_And_, "Bath3Blank44_5", "1", "1"), new[] { "Bath3Blank44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Lot35) && labSheetDetail.Lot35.Length > 20)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "Lot35", "20"), new[] { "Lot35" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Lot44_5) && labSheetDetail.Lot44_5.Length > 20)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "Lot44_5", "20"), new[] { "Lot44_5" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.Weather) && labSheetDetail.Weather.Length > 250)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "Weather", "250"), new[] { "Weather" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.RunComment) && labSheetDetail.RunComment.Length > 250)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "RunComment", "250"), new[] { "RunComment" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.RunWeatherComment) && labSheetDetail.RunWeatherComment.Length > 250)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "RunWeatherComment", "250"), new[] { "RunWeatherComment" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.SampleBottleLotNumber) && labSheetDetail.SampleBottleLotNumber.Length > 20)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "SampleBottleLotNumber", "20"), new[] { "SampleBottleLotNumber" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.SalinitiesReadBy) && labSheetDetail.SalinitiesReadBy.Length > 20)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "SalinitiesReadBy", "20"), new[] { "SalinitiesReadBy" }));
}
if (labSheetDetail.SalinitiesReadDate != null && ((DateTime)labSheetDetail.SalinitiesReadDate).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "SalinitiesReadDate", "1980"), new[] { "SalinitiesReadDate" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.ResultsReadBy) && labSheetDetail.ResultsReadBy.Length > 20)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "ResultsReadBy", "20"), new[] { "ResultsReadBy" }));
}
if (labSheetDetail.ResultsReadDate != null && ((DateTime)labSheetDetail.ResultsReadDate).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "ResultsReadDate", "1980"), new[] { "ResultsReadDate" }));
}
if (!string.IsNullOrWhiteSpace(labSheetDetail.ResultsRecordedBy) && labSheetDetail.ResultsRecordedBy.Length > 20)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._MaxLengthIs_, "ResultsRecordedBy", "20"), new[] { "ResultsRecordedBy" }));
}
if (labSheetDetail.ResultsRecordedDate != null && ((DateTime)labSheetDetail.ResultsRecordedDate).Year < 1980)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._YearShouldBeBiggerThan_, "ResultsRecordedDate", "1980"), new[] { "ResultsRecordedDate" }));
}
if (labSheetDetail.DailyDuplicateRLog != null)
{
if (labSheetDetail.DailyDuplicateRLog < 0 || labSheetDetail.DailyDuplicateRLog > 100)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "DailyDuplicateRLog", "0", "100"), new[] { "DailyDuplicateRLog" }));
}
}
if (labSheetDetail.DailyDuplicatePrecisionCriteria != null)
{
if (labSheetDetail.DailyDuplicatePrecisionCriteria < 0 || labSheetDetail.DailyDuplicatePrecisionCriteria > 100)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "DailyDuplicatePrecisionCriteria", "0", "100"), new[] { "DailyDuplicatePrecisionCriteria" }));
}
}
if (labSheetDetail.IntertechDuplicateRLog != null)
{
if (labSheetDetail.IntertechDuplicateRLog < 0 || labSheetDetail.IntertechDuplicateRLog > 100)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "IntertechDuplicateRLog", "0", "100"), new[] { "IntertechDuplicateRLog" }));
}
}
if (labSheetDetail.IntertechDuplicatePrecisionCriteria != null)
{
if (labSheetDetail.IntertechDuplicatePrecisionCriteria < 0 || labSheetDetail.IntertechDuplicatePrecisionCriteria > 100)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._ValueShouldBeBetween_And_, "IntertechDuplicatePrecisionCriteria", "0", "100"), new[] { "IntertechDuplicatePrecisionCriteria" }));
}
}
if (labSheetDetail.LastUpdateDate_UTC.Year == 1)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes._IsRequired, "LastUpdateDate_UTC"), new[] { "LastUpdateDate_UTC" }));
}
else
{
if (labSheetDetail.LastUpdateDate_UTC.Year < 1980)
{
labSheetDetail.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 == labSheetDetail.LastUpdateContactTVItemID select c).FirstOrDefault();
if (TVItemLastUpdateContactTVItemID == null)
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult(string.Format(CSSPServicesRes.CouldNotFind_With_Equal_, "TVItem", "LastUpdateContactTVItemID", labSheetDetail.LastUpdateContactTVItemID.ToString()), new[] { "LastUpdateContactTVItemID" }));
}
else
{
List <TVTypeEnum> AllowableTVTypes = new List <TVTypeEnum>()
{
TVTypeEnum.Contact,
};
if (!AllowableTVTypes.Contains(TVItemLastUpdateContactTVItemID.TVType))
{
labSheetDetail.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
{
labSheetDetail.HasErrors = true;
yield return(new ValidationResult("AAA", new[] { "AAA" }));
}
}
public string UploadLabSheetDetailInDB(LabSheetAndA1Sheet labSheetAndA1Sheet)
{
string retStr = "";
// Filling LabSheetDetailModel
LabSheetDetail labSheetDetailNew = new LabSheetDetail();
labSheetDetailNew.LabSheetID = labSheetAndA1Sheet.LabSheet.LabSheetID;
labSheetDetailNew.SamplingPlanID = labSheetAndA1Sheet.LabSheet.SamplingPlanID;
labSheetDetailNew.SubsectorTVItemID = labSheetAndA1Sheet.LabSheet.SubsectorTVItemID;
labSheetDetailNew.Version = labSheetAndA1Sheet.LabSheetA1Sheet.Version;
//labSheetDetailNew.IncludeLaboratoryQAQC = labSheetAndA1Sheet.LabSheetA1Sheet.IncludeLaboratoryQAQC;
// RunDate
DateTime RunDate = new DateTime();
int RunYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear));
int RunMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth));
int RunDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay));
if (RunYear != 1900)
{
RunDate = new DateTime(RunYear, RunMonth, RunDay);
}
labSheetDetailNew.RunDate = RunDate;
labSheetDetailNew.Tides = labSheetAndA1Sheet.LabSheetA1Sheet.Tides;
labSheetDetailNew.SampleCrewInitials = labSheetAndA1Sheet.LabSheetA1Sheet.SampleCrewInitials;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncludeLaboratoryQAQC)
{
// IncubationBath1StartDate
DateTime IncubationBath1StartDate = new DateTime();
int IncubationBath1StartYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear));
int IncubationBath1StartMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth));
int IncubationBath1StartDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay));
int IncubationBath1StartHour = 0;
int IncubationBath1StartMinute = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1StartTime.Length == 5)
{
IncubationBath1StartHour = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1StartTime.Substring(0, 2));
IncubationBath1StartMinute = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1StartTime.Substring(3, 2));
}
if (IncubationBath1StartYear != 1900)
{
IncubationBath1StartDate = new DateTime(IncubationBath1StartYear, IncubationBath1StartMonth, IncubationBath1StartDay, IncubationBath1StartHour, IncubationBath1StartMinute, 0);
}
labSheetDetailNew.IncubationBath1StartTime = IncubationBath1StartDate;
// IncubationBath1EndDate
DateTime IncubationBath1EndDate = new DateTime();
int IncubationBath1EndYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear));
int IncubationBath1EndMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth));
int IncubationBath1EndDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay));
int IncubationBath1EndHour = 0;
int IncubationBath1EndMinute = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1EndTime.Length == 5)
{
IncubationBath1EndHour = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1EndTime.Substring(0, 2));
IncubationBath1EndMinute = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1EndTime.Substring(3, 2));
}
if (IncubationBath1EndYear != 1900)
{
IncubationBath1EndDate = new DateTime(IncubationBath1EndYear, IncubationBath1EndMonth, IncubationBath1EndDay, IncubationBath1EndHour, IncubationBath1EndMinute, 0).AddDays(1);
}
labSheetDetailNew.IncubationBath1EndTime = IncubationBath1EndDate;
// IncubationBath1TimeCalculated_minutes
int IncubationBath1TimeCalculated_minutes = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1TimeCalculated.Length == 5)
{
IncubationBath1TimeCalculated_minutes = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1TimeCalculated.Substring(0, 2)) * 60;
IncubationBath1TimeCalculated_minutes += int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath1TimeCalculated.Substring(3, 2));
}
labSheetDetailNew.IncubationBath1TimeCalculated_minutes = IncubationBath1TimeCalculated_minutes;
labSheetDetailNew.WaterBath1 = labSheetAndA1Sheet.LabSheetA1Sheet.WaterBath1;
labSheetDetailNew.WaterBathCount = labSheetAndA1Sheet.LabSheetA1Sheet.WaterBathCount;
if (labSheetDetailNew.WaterBathCount > 1)
{
// IncubationBath2StartDate
DateTime IncubationBath2StartDate = new DateTime();
int IncubationBath2StartYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear));
int IncubationBath2StartMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth));
int IncubationBath2StartDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay));
int IncubationBath2StartHour = 0;
int IncubationBath2StartMinute = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2StartTime.Length == 5)
{
IncubationBath2StartHour = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2StartTime.Substring(0, 2));
IncubationBath2StartMinute = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2StartTime.Substring(3, 2));
}
if (IncubationBath2StartYear != 1900)
{
IncubationBath2StartDate = new DateTime(IncubationBath2StartYear, IncubationBath2StartMonth, IncubationBath2StartDay, IncubationBath2StartHour, IncubationBath2StartMinute, 0);
}
labSheetDetailNew.IncubationBath2StartTime = IncubationBath2StartDate;
// IncubationBath2EndDate
DateTime IncubationBath2EndDate = new DateTime();
int IncubationBath2EndYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear));
int IncubationBath2EndMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth));
int IncubationBath2EndDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay));
int IncubationBath2EndHour = 0;
int IncubationBath2EndMinute = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2EndTime.Length == 5)
{
IncubationBath2EndHour = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2EndTime.Substring(0, 2));
IncubationBath2EndMinute = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2EndTime.Substring(3, 2));
}
if (IncubationBath2EndYear != 1900)
{
IncubationBath2EndDate = new DateTime(IncubationBath2EndYear, IncubationBath2EndMonth, IncubationBath2EndDay, IncubationBath2EndHour, IncubationBath2EndMinute, 0).AddDays(1);
}
labSheetDetailNew.IncubationBath2EndTime = IncubationBath2EndDate;
// IncubationBath2TimeCalculated_minutes
int IncubationBath2TimeCalculated_minutes = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2TimeCalculated.Length == 5)
{
IncubationBath2TimeCalculated_minutes = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2TimeCalculated.Substring(0, 2)) * 60;
IncubationBath2TimeCalculated_minutes += int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath2TimeCalculated.Substring(3, 2));
}
labSheetDetailNew.IncubationBath2TimeCalculated_minutes = IncubationBath2TimeCalculated_minutes;
labSheetDetailNew.WaterBath2 = labSheetAndA1Sheet.LabSheetA1Sheet.WaterBath2;
labSheetDetailNew.Bath2Positive44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath2Positive44_5;
labSheetDetailNew.Bath2NonTarget44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath2NonTarget44_5;
labSheetDetailNew.Bath2Negative44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath2Negative44_5;
labSheetDetailNew.Bath2Blank44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath2Blank44_5;
}
if (labSheetDetailNew.WaterBathCount > 2)
{
// IncubationBath3StartDate
DateTime IncubationBath3StartDate = new DateTime();
int IncubationBath3StartYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear));
int IncubationBath3StartMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth));
int IncubationBath3StartDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay));
int IncubationBath3StartHour = 0;
int IncubationBath3StartMinute = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3StartTime.Length == 5)
{
IncubationBath3StartHour = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3StartTime.Substring(0, 2));
IncubationBath3StartMinute = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3StartTime.Substring(3, 2));
}
if (IncubationBath3StartYear != 1900)
{
IncubationBath3StartDate = new DateTime(IncubationBath3StartYear, IncubationBath3StartMonth, IncubationBath3StartDay, IncubationBath3StartHour, IncubationBath3StartMinute, 0);
}
labSheetDetailNew.IncubationBath3StartTime = IncubationBath3StartDate;
// IncubationBath3EndDate
DateTime IncubationBath3EndDate = new DateTime();
int IncubationBath3EndYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunYear));
int IncubationBath3EndMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunMonth));
int IncubationBath3EndDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.RunDay));
int IncubationBath3EndHour = 0;
int IncubationBath3EndMinute = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3EndTime.Length == 5)
{
IncubationBath3EndHour = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3EndTime.Substring(0, 2));
IncubationBath3EndMinute = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3EndTime.Substring(3, 2));
}
if (IncubationBath3EndYear != 1900)
{
IncubationBath3EndDate = new DateTime(IncubationBath3EndYear, IncubationBath3EndMonth, IncubationBath3EndDay, IncubationBath3EndHour, IncubationBath3EndMinute, 0).AddDays(1);
}
labSheetDetailNew.IncubationBath3EndTime = IncubationBath3EndDate;
// IncubationBath3TimeCalculated_minutes
int IncubationBath3TimeCalculated_minutes = 0;
if (labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3TimeCalculated.Length == 5)
{
IncubationBath3TimeCalculated_minutes = int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3TimeCalculated.Substring(0, 2)) * 60;
IncubationBath3TimeCalculated_minutes += int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IncubationBath3TimeCalculated.Substring(3, 2));
}
labSheetDetailNew.IncubationBath3TimeCalculated_minutes = IncubationBath3TimeCalculated_minutes;
labSheetDetailNew.WaterBath3 = labSheetAndA1Sheet.LabSheetA1Sheet.WaterBath3;
labSheetDetailNew.Bath3Positive44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath3Positive44_5;
labSheetDetailNew.Bath3NonTarget44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath3NonTarget44_5;
labSheetDetailNew.Bath3Negative44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath3Negative44_5;
labSheetDetailNew.Bath3Blank44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath3Blank44_5;
}
labSheetDetailNew.TCField1 = null;
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.TCField1))
{
float temp = 0.0f;
if (float.TryParse(labSheetAndA1Sheet.LabSheetA1Sheet.TCField1, out temp))
{
labSheetDetailNew.TCField1 = temp;
}
}
labSheetDetailNew.TCLab1 = null;
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.TCLab1))
{
float temp = 0.0f;
if (float.TryParse(labSheetAndA1Sheet.LabSheetA1Sheet.TCLab1, out temp))
{
labSheetDetailNew.TCLab1 = temp;
}
}
labSheetDetailNew.TCField2 = null;
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.TCField2))
{
float temp = 0.0f;
if (float.TryParse(labSheetAndA1Sheet.LabSheetA1Sheet.TCField2, out temp))
{
labSheetDetailNew.TCField2 = temp;
}
}
labSheetDetailNew.TCLab2 = null;
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.TCLab2))
{
float temp = 0.0f;
if (float.TryParse(labSheetAndA1Sheet.LabSheetA1Sheet.TCLab2, out temp))
{
labSheetDetailNew.TCLab2 = temp;
}
}
labSheetDetailNew.TCFirst = null;
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.TCFirst) && !labSheetAndA1Sheet.LabSheetA1Sheet.TCFirst.Contains("-"))
{
float temp = 0.0f;
if (float.TryParse(labSheetAndA1Sheet.LabSheetA1Sheet.TCFirst, out temp))
{
labSheetDetailNew.TCFirst = temp;
}
}
labSheetDetailNew.TCAverage = null;
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.TCAverage) && !labSheetAndA1Sheet.LabSheetA1Sheet.TCAverage.Contains("-"))
{
float temp = 0.0f;
if (float.TryParse(labSheetAndA1Sheet.LabSheetA1Sheet.TCAverage, out temp))
{
labSheetDetailNew.TCAverage = temp;
}
}
labSheetDetailNew.ControlLot = labSheetAndA1Sheet.LabSheetA1Sheet.ControlLot;
labSheetDetailNew.Positive35 = labSheetAndA1Sheet.LabSheetA1Sheet.Positive35;
labSheetDetailNew.NonTarget35 = labSheetAndA1Sheet.LabSheetA1Sheet.NonTarget35;
labSheetDetailNew.Negative35 = labSheetAndA1Sheet.LabSheetA1Sheet.Negative35;
labSheetDetailNew.Bath1Positive44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath1Positive44_5;
labSheetDetailNew.Bath1NonTarget44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath1NonTarget44_5;
labSheetDetailNew.Bath1Negative44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath1Negative44_5;
labSheetDetailNew.Blank35 = labSheetAndA1Sheet.LabSheetA1Sheet.Blank35;
labSheetDetailNew.Bath1Blank44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Bath1Blank44_5;
labSheetDetailNew.Lot35 = labSheetAndA1Sheet.LabSheetA1Sheet.Lot35;
labSheetDetailNew.Lot44_5 = labSheetAndA1Sheet.LabSheetA1Sheet.Lot44_5;
labSheetDetailNew.RunComment = labSheetAndA1Sheet.LabSheetA1Sheet.RunComment;
labSheetDetailNew.RunWeatherComment = labSheetAndA1Sheet.LabSheetA1Sheet.RunWeatherComment;
labSheetDetailNew.SampleBottleLotNumber = labSheetAndA1Sheet.LabSheetA1Sheet.SampleBottleLotNumber;
labSheetDetailNew.SalinitiesReadBy = labSheetAndA1Sheet.LabSheetA1Sheet.SalinitiesReadBy;
// SalinitiesReadDate
DateTime SalinitiesReadDate = new DateTime();
int SalinitiesReadYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.SalinitiesReadYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.SalinitiesReadYear));
int SalinitiesReadMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.SalinitiesReadMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.SalinitiesReadMonth));
int SalinitiesReadDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.SalinitiesReadDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.SalinitiesReadDay));
if (SalinitiesReadYear != 1900)
{
SalinitiesReadDate = new DateTime(SalinitiesReadYear, SalinitiesReadMonth, SalinitiesReadDay);
}
labSheetDetailNew.SalinitiesReadDate = SalinitiesReadDate;
labSheetDetailNew.ResultsReadBy = labSheetAndA1Sheet.LabSheetA1Sheet.ResultsReadBy;
// ResultsReadDate
DateTime ResultsReadDate = new DateTime();
int ResultsReadYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsReadYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsReadYear));
int ResultsReadMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsReadMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsReadMonth));
int ResultsReadDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsReadDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsReadDay));
if (ResultsReadYear != 1900)
{
ResultsReadDate = new DateTime(ResultsReadYear, ResultsReadMonth, ResultsReadDay);
}
labSheetDetailNew.ResultsReadDate = ResultsReadDate;
labSheetDetailNew.ResultsRecordedBy = labSheetAndA1Sheet.LabSheetA1Sheet.ResultsRecordedBy;
// ResultsRecordedDate
DateTime ResultsRecordedDate = new DateTime();
int ResultsRecordedYear = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsRecordedYear) ? 1900 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsRecordedYear));
int ResultsRecordedMonth = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsRecordedMonth) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsRecordedMonth));
int ResultsRecordedDay = (string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsRecordedDay) ? 1 : int.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.ResultsRecordedDay));
if (ResultsRecordedYear != 1900)
{
ResultsRecordedDate = new DateTime(ResultsRecordedYear, ResultsRecordedMonth, ResultsRecordedDay);
}
labSheetDetailNew.ResultsRecordedDate = ResultsRecordedDate;
labSheetDetailNew.DailyDuplicateRLog = 0.0f;
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicateRLog) && !labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicateRLog.StartsWith("N"))
{
try
{
labSheetDetailNew.DailyDuplicateRLog = float.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicateRLog);
}
catch (Exception)
{
// nothing
}
}
labSheetDetailNew.DailyDuplicatePrecisionCriteria = null;
labSheetDetailNew.DailyDuplicateRLog = null;
labSheetDetailNew.DailyDuplicateAcceptable = null;
labSheetDetailNew.IntertechDuplicatePrecisionCriteria = null;
labSheetDetailNew.IntertechDuplicateRLog = null;
labSheetDetailNew.IntertechDuplicateAcceptable = null;
labSheetDetailNew.IntertechReadAcceptable = null;
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicatePrecisionCriteria))
{
labSheetDetailNew.DailyDuplicatePrecisionCriteria = float.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicatePrecisionCriteria);
}
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicateRLog))
{
if (!labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicateRLog.StartsWith("N"))
{
labSheetDetailNew.DailyDuplicateRLog = float.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicateRLog);
}
}
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicateAcceptableOrUnacceptable))
{
labSheetDetailNew.DailyDuplicateAcceptable = (labSheetAndA1Sheet.LabSheetA1Sheet.DailyDuplicateAcceptableOrUnacceptable != "Acceptable" ? false : true);
}
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.IntertechDuplicatePrecisionCriteria))
{
labSheetDetailNew.IntertechDuplicatePrecisionCriteria = float.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IntertechDuplicatePrecisionCriteria);
}
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.IntertechDuplicateRLog))
{
if (!labSheetAndA1Sheet.LabSheetA1Sheet.IntertechDuplicateRLog.StartsWith("N"))
{
labSheetDetailNew.IntertechDuplicateRLog = float.Parse(labSheetAndA1Sheet.LabSheetA1Sheet.IntertechDuplicateRLog);
}
}
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.IntertechDuplicateAcceptableOrUnacceptable))
{
labSheetDetailNew.IntertechDuplicateAcceptable = (labSheetAndA1Sheet.LabSheetA1Sheet.IntertechDuplicateAcceptableOrUnacceptable != "Acceptable" ? false : true);
}
if (!string.IsNullOrWhiteSpace(labSheetAndA1Sheet.LabSheetA1Sheet.IntertechReadAcceptableOrUnacceptable))
{
labSheetDetailNew.IntertechReadAcceptable = (labSheetAndA1Sheet.LabSheetA1Sheet.IntertechReadAcceptableOrUnacceptable != "Acceptable" ? false : true);
}
}
LabSheetDetailService labSheetDetailService = new LabSheetDetailService(LanguageEnum.en, _User);
LabSheetDetail labSheetDetailExist = labSheetDetailService.GetLabSheetDetailExistDB(labSheetDetailNew);
if (!string.IsNullOrWhiteSpace(labSheetDetailExist.Error))
{
labSheetDetailExist = labSheetDetailService.PostAddLabSheetDetailDB(labSheetDetailNew);
if (!string.IsNullOrWhiteSpace(labSheetDetailExist.Error))
{
richTextBoxStatus.AppendText("Lab sheet detail could not be loaded to the local DB. Error [" + labSheetDetailExist.Error + "]\r\n");
return(labSheetDetailExist.Error);
}
}
else
{
labSheetDetailNew.LabSheetDetailID = labSheetDetailExist.LabSheetDetailID;
labSheetDetailExist = labSheetDetailService.PostUpdateLabSheetDetailDB(labSheetDetailNew);
if (!string.IsNullOrWhiteSpace(labSheetDetailExist.Error))
{
richTextBoxStatus.AppendText("Lab sheet detail could not be loaded to the local DB. Error [" + labSheetDetailExist.Error + "]\r\n");
return(labSheetDetailExist.Error);
}
}
retStr = UploadLabSheetTubeMPNDetailInDB(labSheetDetailExist.LabSheetDetailID, labSheetAndA1Sheet.LabSheetA1Sheet.LabSheetA1MeasurementList);
if (!string.IsNullOrWhiteSpace(retStr))
{
richTextBoxStatus.AppendText("Lab sheet tube and MPN detail could not be loaded to the local DB. Error [" + retStr + "]\r\n");
return(retStr);
}
return(retStr);
}
