public CoCoRaHSValueModel PostDeleteCoCoRaHSValueDB(int CoCoRaHSValueID)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
CoCoRaHSValue coCoRaHSValueToDelete = GetCoCoRaHSValueWithCoCoRaHSValueIDDB(CoCoRaHSValueID);
if (coCoRaHSValueToDelete == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToDelete, ServiceRes.CoCoRaHSValue)));
}
using (TransactionScope ts = new TransactionScope())
{
db.CoCoRaHSValues.Remove(coCoRaHSValueToDelete);
string retStr = DoDeleteChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ts.Complete();
}
return(ReturnError(""));
}
public CoCoRaHSValue GetCoCoRaHSValueWithCoCoRaHSValueIDDB(int CoCoRaHSValueID)
{
CoCoRaHSValue CoCoRaHSValue = (from c in db.CoCoRaHSValues
where c.CoCoRaHSValueID == CoCoRaHSValueID
select c).FirstOrDefault <CoCoRaHSValue>();
return(CoCoRaHSValue);
}
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));
}
