public bool AddNewHistoricalData(int id, double value)
{
HistoricalData newHistoricalData = new HistoricalData();
newHistoricalData.IdId = id;
newHistoricalData.Value = value;
newHistoricalData.Date = DateTime.Now;
Entities.HistoricalDatas.AddObject(newHistoricalData);
if (Entities.SaveChanges() > 0)
{
return(true);
}
return(false);
}
public HistoricalDataForLastRecord GetLastRecord(int id)
{
var lastRecordQuery = from data in Entities.HistoricalDatas
where data.IdId.Equals(id)
orderby data.Date descending
select data;
HistoricalData lastRecordTemp = lastRecordQuery.FirstOrDefault();
if (lastRecordTemp != null)
{
HistoricalDataForLastRecord lastRecord = new HistoricalDataForLastRecord(lastRecordTemp.HistocalDataId, lastRecordTemp.Value, lastRecordTemp.Date);
return(lastRecord);
}
return(null);
}
