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 GetLabSheetDetailList([FromUri] string lang = "en", [FromUri] int skip = 0, [FromUri] int take = 200, [FromUri] string asc = "", [FromUri] string desc = "", [FromUri] string where = "", [FromUri] string extra = "") { using (CSSPDBContext db = new CSSPDBContext(DatabaseType)) { LabSheetDetailService labSheetDetailService = new LabSheetDetailService(new Query() { Lang = lang }, db, ContactID);
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)); } } }
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)); } } }
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); } } }
public IHttpActionResult GetLabSheetDetailList([FromUri] string lang = "en", [FromUri] int skip = 0, [FromUri] int take = 200, [FromUri] string asc = "", [FromUri] string desc = "", [FromUri] string where = "", [FromUri] string extra = "") { using (CSSPDBContext db = new CSSPDBContext(DatabaseType)) { LabSheetDetailService labSheetDetailService = new LabSheetDetailService(new Query() { Lang = lang }, db, ContactID); if (extra == "A") // QueryString contains [extra=A] { labSheetDetailService.Query = labSheetDetailService.FillQuery(typeof(LabSheetDetailExtraA), lang, skip, take, asc, desc, where, extra); if (labSheetDetailService.Query.HasErrors) { return(Ok(new List <LabSheetDetailExtraA>() { new LabSheetDetailExtraA() { HasErrors = labSheetDetailService.Query.HasErrors, ValidationResults = labSheetDetailService.Query.ValidationResults, }, }.ToList())); } else { return(Ok(labSheetDetailService.GetLabSheetDetailExtraAList().ToList())); } } else if (extra == "B") // QueryString contains [extra=B] { labSheetDetailService.Query = labSheetDetailService.FillQuery(typeof(LabSheetDetailExtraB), lang, skip, take, asc, desc, where, extra); if (labSheetDetailService.Query.HasErrors) { return(Ok(new List <LabSheetDetailExtraB>() { new LabSheetDetailExtraB() { HasErrors = labSheetDetailService.Query.HasErrors, ValidationResults = labSheetDetailService.Query.ValidationResults, }, }.ToList())); } else { return(Ok(labSheetDetailService.GetLabSheetDetailExtraBList().ToList())); } } else // QueryString has no parameter [extra] or extra is empty { labSheetDetailService.Query = labSheetDetailService.FillQuery(typeof(LabSheetDetail), lang, skip, take, asc, desc, where, extra); if (labSheetDetailService.Query.HasErrors) { return(Ok(new List <LabSheetDetail>() { new LabSheetDetail() { HasErrors = labSheetDetailService.Query.HasErrors, ValidationResults = labSheetDetailService.Query.ValidationResults, }, }.ToList())); } else { return(Ok(labSheetDetailService.GetLabSheetDetailList().ToList())); } } } }
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); }