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