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