//public override string CoCoRaHSDoAddChanges()
//{
// return base.CoCoRaHSDoAddChanges();
//}
//public override string CoCoRaHSDoDeleteChanges()
//{
// return base.CoCoRaHSDoDeleteChanges();
//}
//public override string CoCoRaHSDoUpdateChanges()
//{
// return base.CoCoRaHSDoUpdateChanges();
//}
// Check
public string CoCoRaHSSiteModelOK(CoCoRaHSSiteModel coCoRaHSSiteModel)
{
string retStr = FieldCheckNotNullAndMinMaxLengthString(coCoRaHSSiteModel.StationNumber, ServiceRes.StationNumber, 2, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(coCoRaHSSiteModel.StationName, ServiceRes.StationName, 2, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(coCoRaHSSiteModel.Latitude, ServiceRes.Latitude, -90.0D, 90.0D);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(coCoRaHSSiteModel.Longitude, ServiceRes.Longitude, -180.0D, 180.0D);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(coCoRaHSSiteModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public CoCoRaHSSiteModel GetCoCoRaHSSiteModelExistDB(CoCoRaHSSiteModel coCoRaHSSiteModel)
{
CoCoRaHSSiteModel coCoRaHSSiteModelRet = (from c in db.CoCoRaHSSites
where c.StationNumber == coCoRaHSSiteModel.StationNumber &&
c.StationName == coCoRaHSSiteModel.StationName
select new CoCoRaHSSiteModel
{
Error = "",
CoCoRaHSSiteID = c.CoCoRaHSSiteID,
DBCommand = (DBCommandEnum)c.DBCommand,
StationNumber = c.StationNumber,
StationName = c.StationName,
Latitude = c.Latitude,
Longitude = c.Longitude,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <CoCoRaHSSiteModel>();
if (coCoRaHSSiteModelRet == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.CoCoRaHSSite,
ServiceRes.StationNumber + "," +
ServiceRes.StationName,
coCoRaHSSiteModel.StationNumber + "," +
coCoRaHSSiteModel.StationName)));
}
return(coCoRaHSSiteModelRet);
}
// 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));
}
// Helper
public string CreateTVText(CoCoRaHSSiteModel coCoRaHSSiteModel)
{
string retStr = "CoCoRaHS " + coCoRaHSSiteModel.StationName + " (" + coCoRaHSSiteModel.StationNumber + ")";
return(retStr);
}
