public MikeBoundaryConditionModel GetMikeBoundaryConditionModelWithMikeBoundaryConditionTVItemIDDB(int MikeBoundaryConditionTVItemID) { MikeBoundaryConditionModel mikeBoundaryConditionModel = (from c in db.MikeBoundaryConditions let bcName = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.MikeBoundaryConditionTVItemID select cl.TVText).FirstOrDefault <string>() where c.MikeBoundaryConditionTVItemID == MikeBoundaryConditionTVItemID select new MikeBoundaryConditionModel { Error = "", MikeBoundaryConditionID = c.MikeBoundaryConditionID, DBCommand = (DBCommandEnum)c.DBCommand, MikeBoundaryConditionTVItemID = c.MikeBoundaryConditionTVItemID, MikeBoundaryConditionTVText = bcName, MikeBoundaryConditionCode = c.MikeBoundaryConditionCode, MikeBoundaryConditionFormat = c.MikeBoundaryConditionFormat, MikeBoundaryConditionLength_m = c.MikeBoundaryConditionLength_m, MikeBoundaryConditionName = c.MikeBoundaryConditionName, MikeBoundaryConditionLevelOrVelocity = (MikeBoundaryConditionLevelOrVelocityEnum)c.MikeBoundaryConditionLevelOrVelocity, NumberOfWebTideNodes = c.NumberOfWebTideNodes, WebTideDataSet = (WebTideDataSetEnum)c.WebTideDataSet, WebTideDataFromStartToEndDate = c.WebTideDataFromStartToEndDate, TVType = (TVTypeEnum)c.TVType, LastUpdateDate_UTC = c.LastUpdateDate_UTC, LastUpdateContactTVItemID = c.LastUpdateContactTVItemID }).FirstOrDefault <MikeBoundaryConditionModel>(); if (mikeBoundaryConditionModel == null) { return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.MikeBoundaryCondition, ServiceRes.MikeBoundaryConditionTVItemID, MikeBoundaryConditionTVItemID))); } return(mikeBoundaryConditionModel); }
public bool GetIsItSameObject(MikeBoundaryConditionModel mikeBoundaryConditionModel, TVItemModel tvItemModelMikeBoundaryConditionExit) { bool IsSame = false; if (mikeBoundaryConditionModel.MikeBoundaryConditionTVItemID == tvItemModelMikeBoundaryConditionExit.TVItemID) { IsSame = true; } return(IsSame); }
// Post public MikeBoundaryConditionModel PostAddMikeBoundaryConditionDB(MikeBoundaryConditionModel mikeBoundaryConditionModel) { string retStr = MikeBoundaryConditionModelOK(mikeBoundaryConditionModel); if (!string.IsNullOrEmpty(retStr)) { return(ReturnError(retStr)); } ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } TVItemModel tvItemModelExist = _TVItemService.GetTVItemModelWithTVItemIDDB(mikeBoundaryConditionModel.MikeBoundaryConditionTVItemID); if (!string.IsNullOrWhiteSpace(tvItemModelExist.Error)) { return(ReturnError(tvItemModelExist.Error)); } MikeBoundaryCondition mikeBoundaryConditionNew = new MikeBoundaryCondition(); retStr = FillMikeBoundaryCondition(mikeBoundaryConditionNew, mikeBoundaryConditionModel, contactOK); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } using (TransactionScope ts = new TransactionScope()) { db.MikeBoundaryConditions.Add(mikeBoundaryConditionNew); retStr = DoAddChanges(); if (!string.IsNullOrWhiteSpace(retStr)) { return(ReturnError(retStr)); } LogModel logModel = _LogService.PostAddLogForObj("MikeBoundaryConditions", mikeBoundaryConditionNew.MikeBoundaryConditionID, LogCommandEnum.Add, mikeBoundaryConditionNew); if (!string.IsNullOrWhiteSpace(logModel.Error)) { return(ReturnError(logModel.Error)); } ts.Complete(); } return(GetMikeBoundaryConditionModelWithMikeBoundaryConditionIDDB(mikeBoundaryConditionNew.MikeBoundaryConditionID)); }
public MikeBoundaryConditionModel PostUpdateMikeBoundaryConditionDB(MikeBoundaryConditionModel mikeBoundaryConditionModel) { string retStr = MikeBoundaryConditionModelOK(mikeBoundaryConditionModel); if (!string.IsNullOrEmpty(retStr)) { return(ReturnError(retStr)); } ContactOK contactOK = IsContactOK(); if (!string.IsNullOrEmpty(contactOK.Error)) { return(ReturnError(contactOK.Error)); } MikeBoundaryCondition mikeBoundaryConditionToUpdate = GetMikeBoundaryConditionWithMikeBoundaryConditionIDDB(mikeBoundaryConditionModel.MikeBoundaryConditionID); if (mikeBoundaryConditionToUpdate == null) { return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.MikeBoundaryCondition))); } retStr = FillMikeBoundaryCondition(mikeBoundaryConditionToUpdate, mikeBoundaryConditionModel, 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("MikeBoundaryConditions", mikeBoundaryConditionToUpdate.MikeBoundaryConditionID, LogCommandEnum.Change, mikeBoundaryConditionToUpdate); if (!string.IsNullOrWhiteSpace(logModel.Error)) { return(ReturnError(logModel.Error)); } ts.Complete(); } return(GetMikeBoundaryConditionModelWithMikeBoundaryConditionIDDB(mikeBoundaryConditionToUpdate.MikeBoundaryConditionID)); }
public string ResetWebTideDB(int MikeScenarioTVItemID) { ContactOK contactOK = IsContactOK(); if (!string.IsNullOrWhiteSpace(contactOK.Error)) { return(contactOK.Error); } if (MikeScenarioTVItemID == 0) { return(string.Format(ServiceRes._IsRequired, ServiceRes.MikeScenarioTVItemID)); } using (TransactionScope ts = new TransactionScope()) { List <MikeBoundaryConditionModel> mikeBoundaryConditionModelListMeshToDelete = _MikeBoundaryConditionService.GetMikeBoundaryConditionModelListWithMikeScenarioTVItemIDAndTVTypeDB(MikeScenarioTVItemID, TVTypeEnum.MikeBoundaryConditionMesh); foreach (MikeBoundaryConditionModel mikeBoundaryConditionModel in mikeBoundaryConditionModelListMeshToDelete) { MikeBoundaryConditionModel mikeBoundaryConditionModelRet = _MikeBoundaryConditionService.PostDeleteMikeBoundaryConditionDB(mikeBoundaryConditionModel.MikeBoundaryConditionID); if (!string.IsNullOrWhiteSpace(mikeBoundaryConditionModelRet.Error)) { return(mikeBoundaryConditionModelRet.Error); } } List <MikeBoundaryConditionModel> mikeBoundaryConditionModelListWebTideToDelete = _MikeBoundaryConditionService.GetMikeBoundaryConditionModelListWithMikeScenarioTVItemIDAndTVTypeDB(MikeScenarioTVItemID, TVTypeEnum.MikeBoundaryConditionWebTide); foreach (MikeBoundaryConditionModel mikeBoundaryConditionModel in mikeBoundaryConditionModelListWebTideToDelete) { MikeBoundaryConditionModel mikeBoundaryConditionModelRet = _MikeBoundaryConditionService.PostDeleteMikeBoundaryConditionDB(mikeBoundaryConditionModel.MikeBoundaryConditionID); if (!string.IsNullOrWhiteSpace(mikeBoundaryConditionModelRet.Error)) { return(mikeBoundaryConditionModelRet.Error); } } ts.Complete(); } return(""); }
// Check public string MikeBoundaryConditionModelOK(MikeBoundaryConditionModel mikeBoundaryConditionModel) { string retStr = FieldCheckNotZeroInt(mikeBoundaryConditionModel.MikeBoundaryConditionTVItemID, ServiceRes.MikeBoundaryConditionTVItemID); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndMinMaxLengthString(mikeBoundaryConditionModel.MikeBoundaryConditionTVText, ServiceRes.MikeBoundaryConditionTVText, 1, 200); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndMinMaxLengthString(mikeBoundaryConditionModel.MikeBoundaryConditionCode, ServiceRes.MikeBoundaryConditionCode, 3, 100); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndMinMaxLengthString(mikeBoundaryConditionModel.MikeBoundaryConditionName, ServiceRes.MikeBoundaryConditionName, 1, 100); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndWithinRangeDouble(mikeBoundaryConditionModel.MikeBoundaryConditionLength_m, ServiceRes.MikeBoundaryConditionLength_m, 0, 500000); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndMinMaxLengthString(mikeBoundaryConditionModel.MikeBoundaryConditionFormat, ServiceRes.MikeBoundaryConditionFormat, 3, 100); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = _BaseEnumService.MikeBoundaryConditionLevelOrVelocityOK(mikeBoundaryConditionModel.MikeBoundaryConditionLevelOrVelocity); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = _BaseEnumService.WebTideDataSetOK(mikeBoundaryConditionModel.WebTideDataSet); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } retStr = FieldCheckNotNullAndWithinRangeInt(mikeBoundaryConditionModel.NumberOfWebTideNodes, ServiceRes.NumberOfWebTideNodes, 0, 10000); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } if (!(mikeBoundaryConditionModel.TVType == TVTypeEnum.MikeBoundaryConditionWebTide || mikeBoundaryConditionModel.TVType == TVTypeEnum.MikeBoundaryConditionMesh)) { return(string.Format(ServiceRes.TVTypeForBoundaryConditionShouldBeOneOf_Or_, ServiceRes.MikeBoundaryConditionWebTide, ServiceRes.MikeBoundaryConditionMesh)); } retStr = _BaseEnumService.DBCommandOK(mikeBoundaryConditionModel.DBCommand); if (!string.IsNullOrWhiteSpace(retStr)) { return(retStr); } return(""); }
// Helper public string CreateTVText(MikeBoundaryConditionModel mikeBoundaryConditionModel) { return(mikeBoundaryConditionModel.MikeBoundaryConditionTVText); }
// Fill public string FillMikeBoundaryCondition(MikeBoundaryCondition mikeBoundaryCondition, MikeBoundaryConditionModel mikeBoundaryConditionModel, ContactOK contactOK) { mikeBoundaryCondition.DBCommand = (int)mikeBoundaryConditionModel.DBCommand; mikeBoundaryCondition.MikeBoundaryConditionTVItemID = mikeBoundaryConditionModel.MikeBoundaryConditionTVItemID; mikeBoundaryCondition.MikeBoundaryConditionCode = mikeBoundaryConditionModel.MikeBoundaryConditionCode; mikeBoundaryCondition.MikeBoundaryConditionFormat = mikeBoundaryConditionModel.MikeBoundaryConditionFormat; mikeBoundaryCondition.MikeBoundaryConditionLength_m = mikeBoundaryConditionModel.MikeBoundaryConditionLength_m; mikeBoundaryCondition.MikeBoundaryConditionName = mikeBoundaryConditionModel.MikeBoundaryConditionName; mikeBoundaryCondition.MikeBoundaryConditionLevelOrVelocity = (int)mikeBoundaryConditionModel.MikeBoundaryConditionLevelOrVelocity; mikeBoundaryCondition.NumberOfWebTideNodes = mikeBoundaryConditionModel.NumberOfWebTideNodes; mikeBoundaryCondition.WebTideDataFromStartToEndDate = mikeBoundaryConditionModel.WebTideDataFromStartToEndDate; mikeBoundaryCondition.TVType = (int)mikeBoundaryConditionModel.TVType; mikeBoundaryCondition.WebTideDataSet = (int)mikeBoundaryConditionModel.WebTideDataSet; mikeBoundaryCondition.LastUpdateDate_UTC = DateTime.UtcNow; if (contactOK == null) { mikeBoundaryCondition.LastUpdateContactTVItemID = 2; } else { mikeBoundaryCondition.LastUpdateContactTVItemID = contactOK.ContactTVItemID; } return(""); }