public LabSheetTubeMPNDetailModel GetLabSheetTubeMPNDetailModelWithLabSheetTubeMPNDetailIDDB(int LabSheetTubeMPNDetailID) { LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModel = (from c in db.LabSheetTubeMPNDetails where c.LabSheetTubeMPNDetailID == LabSheetTubeMPNDetailID orderby c.Ordinal select new LabSheetTubeMPNDetailModel { Error = "", LabSheetTubeMPNDetailID = c.LabSheetTubeMPNDetailID, DBCommand = (DBCommandEnum)c.DBCommand, LabSheetDetailID = c.LabSheetDetailID, Ordinal = c.Ordinal, MWQMSiteTVItemID = c.MWQMSiteTVItemID, SampleDateTime = c.SampleDateTime, MPN = c.MPN, Tube10 = c.Tube10, Tube1_0 = c.Tube1_0, Tube0_1 = c.Tube0_1, Salinity = (float)c.Salinity, Temperature = (float)c.Temperature, ProcessedBy = c.ProcessedBy, SampleType = (SampleTypeEnum)c.SampleType, SiteComment = c.SiteComment, LastUpdateDate_UTC = c.LastUpdateDate_UTC, LastUpdateContactTVItemID = c.LastUpdateContactTVItemID, }).FirstOrDefault <LabSheetTubeMPNDetailModel>(); if (labSheetTubeMPNDetailModel == null) { return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.LabSheetTubeMPNDetail, ServiceRes.LabSheetTubeMPNDetailID, LabSheetTubeMPNDetailID))); } return(labSheetTubeMPNDetailModel); }
// Post public LabSheetTubeMPNDetailModel PostAddLabSheetTubeMPNDetailDB(LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModel) { string retStr = LabSheetTubeMPNDetailModelOK(labSheetTubeMPNDetailModel); if (!string.IsNullOrEmpty(retStr)) { return(ReturnError(retStr)); } ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModelExist = GetLabSheetTubeMPNDetailModelExistDB(labSheetTubeMPNDetailModel); if (string.IsNullOrWhiteSpace(labSheetTubeMPNDetailModelExist.Error)) { return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.LabSheetTubeMPNDetail))); } LabSheetTubeMPNDetail labSheetTubeMPNDetailNew = new LabSheetTubeMPNDetail(); retStr = FillLabSheetTubeMPNDetail(labSheetTubeMPNDetailNew, labSheetTubeMPNDetailModel, contactOK); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } using (TransactionScope ts = new TransactionScope()) { db.LabSheetTubeMPNDetails.Add(labSheetTubeMPNDetailNew); retStr = DoAddChanges(); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } LogModel logModel = _LogService.PostAddLogForObj("LabSheetTubeMPNDetails", labSheetTubeMPNDetailNew.LabSheetTubeMPNDetailID, LogCommandEnum.Add, labSheetTubeMPNDetailNew); if (!string.IsNullOrWhiteSpace(logModel.Error)) { return(ReturnError(logModel.Error)); } ts.Complete(); } return(GetLabSheetTubeMPNDetailModelWithLabSheetTubeMPNDetailIDDB(labSheetTubeMPNDetailNew.LabSheetTubeMPNDetailID)); }
public LabSheetTubeMPNDetailModel PostUpdateLabSheetTubeMPNDetailDB(LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModel) { string retStr = LabSheetTubeMPNDetailModelOK(labSheetTubeMPNDetailModel); if (!string.IsNullOrEmpty(retStr)) { return(ReturnError(retStr)); } ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } LabSheetTubeMPNDetail labSheetTubeMPNDetailToUpdate = GetLabSheetTubeMPNDetailWithLabSheetTubeMPNDetailIDDB(labSheetTubeMPNDetailModel.LabSheetTubeMPNDetailID); if (labSheetTubeMPNDetailToUpdate == null) { return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.LabSheetTubeMPNDetail))); } retStr = FillLabSheetTubeMPNDetail(labSheetTubeMPNDetailToUpdate, labSheetTubeMPNDetailModel, contactOK); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } using (TransactionScope ts = new TransactionScope()) { retStr = DoUpdateChanges(); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } LogModel logModel = _LogService.PostAddLogForObj("LabSheetTubeMPNDetails", labSheetTubeMPNDetailToUpdate.LabSheetTubeMPNDetailID, LogCommandEnum.Change, labSheetTubeMPNDetailToUpdate); if (!string.IsNullOrWhiteSpace(logModel.Error)) { return(ReturnError(logModel.Error)); } ts.Complete(); } return(GetLabSheetTubeMPNDetailModelWithLabSheetTubeMPNDetailIDDB(labSheetTubeMPNDetailToUpdate.LabSheetTubeMPNDetailID)); }
// Check public string LabSheetTubeMPNDetailModelOK(LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModel) { string retStr = FieldCheckNotZeroInt(labSheetTubeMPNDetailModel.LabSheetDetailID, ServiceRes.LabSheetDetailID); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndWithinRangeInt(labSheetTubeMPNDetailModel.Ordinal, ServiceRes.Ordinal, 0, 10000); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotZeroInt(labSheetTubeMPNDetailModel.MWQMSiteTVItemID, ServiceRes.MWQMSiteTVItemID); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } if (labSheetTubeMPNDetailModel.SampleDateTime != null) { retStr = FieldCheckNotNullDateTime(labSheetTubeMPNDetailModel.SampleDateTime, ServiceRes.SampleDateTime); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } } if (labSheetTubeMPNDetailModel.MPN != -999) { retStr = FieldCheckIfNotNullWithinRangeDouble(labSheetTubeMPNDetailModel.MPN, ServiceRes.MPN, 1, 100000000); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } } retStr = FieldCheckIfNotNullWithinRangeInt(labSheetTubeMPNDetailModel.Tube10, ServiceRes.Tube10, 0, 5); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckIfNotNullWithinRangeInt(labSheetTubeMPNDetailModel.Tube1_0, ServiceRes.Tube1_0, 0, 5); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckIfNotNullWithinRangeInt(labSheetTubeMPNDetailModel.Tube0_1, ServiceRes.Tube0_1, 0, 5); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckIfNotNullWithinRangeDouble(labSheetTubeMPNDetailModel.Salinity, ServiceRes.Salinity, 0, 40); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckIfNotNullWithinRangeDouble(labSheetTubeMPNDetailModel.Temperature, ServiceRes.Temperature, -12, 40); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckIfNotNullMaxLengthString(labSheetTubeMPNDetailModel.ProcessedBy, ServiceRes.ProcessedBy, 10); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = _BaseEnumService.SampleTypeOK(labSheetTubeMPNDetailModel.SampleType); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckIfNotNullMaxLengthString(labSheetTubeMPNDetailModel.SiteComment, ServiceRes.SiteComment, 250); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = _BaseEnumService.DBCommandOK(labSheetTubeMPNDetailModel.DBCommand); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } return(""); }
// Fill public string FillLabSheetTubeMPNDetail(LabSheetTubeMPNDetail labSheetTubeMPNDetail, LabSheetTubeMPNDetailModel labSheetTubeMPNDetailModel, ContactOK contactOK) { labSheetTubeMPNDetail.DBCommand = (int)labSheetTubeMPNDetailModel.DBCommand; labSheetTubeMPNDetail.LabSheetTubeMPNDetailID = labSheetTubeMPNDetailModel.LabSheetTubeMPNDetailID; labSheetTubeMPNDetail.LabSheetDetailID = labSheetTubeMPNDetailModel.LabSheetDetailID; labSheetTubeMPNDetail.Ordinal = labSheetTubeMPNDetailModel.Ordinal; labSheetTubeMPNDetail.MWQMSiteTVItemID = labSheetTubeMPNDetailModel.MWQMSiteTVItemID; labSheetTubeMPNDetail.SampleDateTime = labSheetTubeMPNDetailModel.SampleDateTime; labSheetTubeMPNDetail.MPN = labSheetTubeMPNDetailModel.MPN; labSheetTubeMPNDetail.Tube10 = labSheetTubeMPNDetailModel.Tube10; labSheetTubeMPNDetail.Tube1_0 = labSheetTubeMPNDetailModel.Tube1_0; labSheetTubeMPNDetail.Tube0_1 = labSheetTubeMPNDetailModel.Tube0_1; labSheetTubeMPNDetail.Salinity = labSheetTubeMPNDetailModel.Salinity; labSheetTubeMPNDetail.Temperature = labSheetTubeMPNDetailModel.Temperature; labSheetTubeMPNDetail.ProcessedBy = labSheetTubeMPNDetailModel.ProcessedBy; labSheetTubeMPNDetail.SampleType = (int)labSheetTubeMPNDetailModel.SampleType; labSheetTubeMPNDetail.SiteComment = labSheetTubeMPNDetailModel.SiteComment; labSheetTubeMPNDetail.LastUpdateDate_UTC = DateTime.UtcNow; if (contactOK == null) { labSheetTubeMPNDetail.LastUpdateContactTVItemID = 2; } else { labSheetTubeMPNDetail.LastUpdateContactTVItemID = contactOK.ContactTVItemID; } return(""); }