public CoCoRaHSSiteModel PostDeleteCoCoRaHSSiteDB(int CoCoRaHSSiteID)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
CoCoRaHSSite coCoRaHSSiteToDelete = GetCoCoRaHSSiteWithCoCoRaHSSiteIDDB(CoCoRaHSSiteID);
if (coCoRaHSSiteToDelete == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToDelete, ServiceRes.CoCoRaHSSite)));
}
using (TransactionScope ts = new TransactionScope())
{
db.CoCoRaHSSites.Remove(coCoRaHSSiteToDelete);
string retStr = DoDeleteChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ts.Complete();
}
return(ReturnError(""));
}
public CoCoRaHSSite GetCoCoRaHSSiteWithCoCoRaHSSiteIDDB(int CoCoRaHSSiteID)
{
CoCoRaHSSite CoCoRaHSSite = (from c in db.CoCoRaHSSites
where c.CoCoRaHSSiteID == CoCoRaHSSiteID
select c).FirstOrDefault <CoCoRaHSSite>();
return(CoCoRaHSSite);
}
// Fill
public string FillCoCoRaHSSite(CoCoRaHSSite coCoRaHSSiteNew, CoCoRaHSSiteModel coCoRaHSSiteModel, ContactOK contactOK)
{
coCoRaHSSiteNew.DBCommand = (int)coCoRaHSSiteModel.DBCommand;
coCoRaHSSiteNew.StationNumber = coCoRaHSSiteModel.StationNumber;
coCoRaHSSiteNew.StationName = coCoRaHSSiteModel.StationName;
coCoRaHSSiteNew.Latitude = coCoRaHSSiteModel.Latitude;
coCoRaHSSiteNew.Longitude = coCoRaHSSiteModel.Longitude;
coCoRaHSSiteNew.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
coCoRaHSSiteNew.LastUpdateContactTVItemID = 2;
}
else
{
coCoRaHSSiteNew.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
public CoCoRaHSSiteModel PostUpdateCoCoRaHSSiteDB(CoCoRaHSSiteModel coCoRaHSSiteModel)
{
string retStr = CoCoRaHSSiteModelOK(coCoRaHSSiteModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
CoCoRaHSSite coCoRaHSSiteToUpdate = GetCoCoRaHSSiteWithCoCoRaHSSiteIDDB(coCoRaHSSiteModel.CoCoRaHSSiteID);
if (coCoRaHSSiteToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.CoCoRaHSSite)));
}
retStr = FillCoCoRaHSSite(coCoRaHSSiteToUpdate, coCoRaHSSiteModel, 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(GetCoCoRaHSSiteModelWithCoCoRaHSSiteIDDB(coCoRaHSSiteToUpdate.CoCoRaHSSiteID));
}
// Post
public CoCoRaHSSiteModel PostAddCoCoRaHSSiteDB(CoCoRaHSSiteModel coCoRaHSSiteModel)
{
string retStr = CoCoRaHSSiteModelOK(coCoRaHSSiteModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
CoCoRaHSSite coCoRaHSSiteNew = new CoCoRaHSSite();
retStr = FillCoCoRaHSSite(coCoRaHSSiteNew, coCoRaHSSiteModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.CoCoRaHSSites.Add(coCoRaHSSiteNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ts.Complete();
}
return(GetCoCoRaHSSiteModelWithCoCoRaHSSiteIDDB(coCoRaHSSiteNew.CoCoRaHSSiteID));
}
