public CoCoRaHSValueModel GetCoCoRaHSValueModelExistDB(CoCoRaHSValueModel coCoRaHSValueModel)
{
CoCoRaHSValueModel coCoRaHSValueModelRet = (from c in db.CoCoRaHSValues
where c.CoCoRaHSSiteID == coCoRaHSValueModel.CoCoRaHSSiteID &&
c.ObservationDateAndTime == coCoRaHSValueModel.ObservationDateAndTime
select new CoCoRaHSValueModel
{
Error = "",
CoCoRaHSValueID = c.CoCoRaHSValueID,
DBCommand = (DBCommandEnum)c.DBCommand,
CoCoRaHSSiteID = c.CoCoRaHSSiteID,
ObservationDateAndTime = c.ObservationDateAndTime,
TotalPrecipAmt = c.TotalPrecipAmt,
NewSnowDepth = c.NewSnowDepth,
NewSnowSWE = c.NewSnowSWE,
TotalSnowDepth = c.TotalSnowDepth,
TotalSnowSWE = c.TotalSnowSWE,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <CoCoRaHSValueModel>();
if (coCoRaHSValueModelRet == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.CoCoRaHSValue,
ServiceRes.CoCoRaHSSiteID + "," +
ServiceRes.ObservationDateAndTime,
coCoRaHSValueModel.CoCoRaHSSiteID + "," +
coCoRaHSValueModel.ObservationDateAndTime.ToString())));
}
return(coCoRaHSValueModelRet);
}
//public override string CoCoRaHSDoAddChanges()
//{
// return base.CoCoRaHSDoAddChanges();
//}
//public override string CoCoRaHSDoDeleteChanges()
//{
// return base.CoCoRaHSDoDeleteChanges();
//}
//public override string CoCoRaHSDoUpdateChanges()
//{
// return base.CoCoRaHSDoUpdateChanges();
//}
// Check
public string CoCoRaHSValueModelOK(CoCoRaHSValueModel coCoRaHSValueModel)
{
string retStr = FieldCheckNotZeroInt(coCoRaHSValueModel.CoCoRaHSSiteID, ServiceRes.CoCoRaHSSiteID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullDateTime(coCoRaHSValueModel.ObservationDateAndTime, ServiceRes.ObservationDateAndTime);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(coCoRaHSValueModel.TotalPrecipAmt, ServiceRes.TotalPrecipAmt, 0.0D, 100000.0D);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(coCoRaHSValueModel.NewSnowDepth, ServiceRes.NewSnowDepth, 0.0D, 100000.0D);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(coCoRaHSValueModel.NewSnowSWE, ServiceRes.NewSnowSWE, 0.0D, 100000.0D);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(coCoRaHSValueModel.TotalSnowDepth, ServiceRes.TotalSnowDepth, 0.0D, 100000.0D);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(coCoRaHSValueModel.TotalSnowSWE, ServiceRes.TotalSnowSWE, 0.0D, 100000.0D);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(coCoRaHSValueModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public CoCoRaHSValueModel PostUpdateCoCoRaHSValueDB(CoCoRaHSValueModel coCoRaHSValueModel)
{
string retStr = CoCoRaHSValueModelOK(coCoRaHSValueModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
CoCoRaHSValue coCoRaHSValueToUpdate = GetCoCoRaHSValueWithCoCoRaHSValueIDDB(coCoRaHSValueModel.CoCoRaHSValueID);
if (coCoRaHSValueToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.CoCoRaHSValue)));
}
retStr = FillCoCoRaHSValue(coCoRaHSValueToUpdate, coCoRaHSValueModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ts.Complete();
}
return(GetCoCoRaHSValueModelWithCoCoRaHSValueIDDB(coCoRaHSValueToUpdate.CoCoRaHSValueID));
}
// Fill
public string FillCoCoRaHSValue(CoCoRaHSValue coCoRaHSValueNew, CoCoRaHSValueModel coCoRaHSValueModel, ContactOK contactOK)
{
coCoRaHSValueNew.DBCommand = (int)coCoRaHSValueModel.DBCommand;
coCoRaHSValueNew.CoCoRaHSSiteID = coCoRaHSValueModel.CoCoRaHSSiteID;
coCoRaHSValueNew.ObservationDateAndTime = coCoRaHSValueModel.ObservationDateAndTime;
coCoRaHSValueNew.TotalPrecipAmt = coCoRaHSValueModel.TotalPrecipAmt;
coCoRaHSValueNew.NewSnowDepth = coCoRaHSValueModel.NewSnowDepth;
coCoRaHSValueNew.NewSnowSWE = coCoRaHSValueModel.NewSnowSWE;
coCoRaHSValueNew.TotalSnowDepth = coCoRaHSValueModel.TotalSnowDepth;
coCoRaHSValueNew.TotalSnowSWE = coCoRaHSValueModel.TotalSnowSWE;
coCoRaHSValueNew.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
coCoRaHSValueNew.LastUpdateContactTVItemID = 2;
}
else
{
coCoRaHSValueNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
// Post
public CoCoRaHSValueModel PostAddCoCoRaHSValueDB(CoCoRaHSValueModel coCoRaHSValueModel)
{
string retStr = CoCoRaHSValueModelOK(coCoRaHSValueModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
CoCoRaHSValue coCoRaHSValueNew = new CoCoRaHSValue();
retStr = FillCoCoRaHSValue(coCoRaHSValueNew, coCoRaHSValueModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.CoCoRaHSValues.Add(coCoRaHSValueNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ts.Complete();
}
return(GetCoCoRaHSValueModelWithCoCoRaHSValueIDDB(coCoRaHSValueNew.CoCoRaHSValueID));
}
