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("");
}
