public System.Collections.Generic.List <DataLogger.DataLog> GetEntries( ) { MDG.DataLogger.DataLogEntities1 _Entity = new DataLogEntities1(); try { return(_Entity.DataLogs.Where(x => x.ReadingDate.Day == DateTime.Now.Day).OrderByDescending(log => log.ReadingDate).ToList()); } catch (Exception ex) { throw ex; } finally { _Entity.Dispose(); } }
public int ClearEntries( ) { MDG.DataLogger.DataLogEntities1 _Entity = new DataLogEntities1( ); try { int count = 0; foreach (var dataLog in _Entity.DataLogs) { _Entity.DeleteObject(dataLog); count++; } _Entity.SaveChanges(); return(count); } catch (Exception ex) { throw ex; } finally { _Entity.Dispose( ); } }
private System.Collections.Generic.List <DataLogger.ModifiedDraftReading> GetFormatedEntries( ) { MDG.DataLogger.DataLogEntities1 _Entity = new DataLogEntities1( ); try { var query = _Entity.DataLogs.Where(x => x.ReadingDate.Day == DateTime.Now.Day).OrderByDescending( log => log.ReadingDate).OrderByDescending(logEntry => logEntry.ReadingDate); var formattedQuery = from rawLogEntry in query.AsEnumerable() select new ModifiedDraftReading() { ReadingDate = string.Format( "{0} : {1} : {2}", rawLogEntry. ReadingDate .Hour, rawLogEntry. ReadingDate .Minute, rawLogEntry. ReadingDate .Second), DayNumber = rawLogEntry. DayNumber, SternAngle = rawLogEntry. SternAngle.ToString ("N2"), SternWaterSideDaft = rawLogEntry. SternWaterSideDraft.ToFeetAndInches(), SternDockSideDraft = rawLogEntry.SternDockSideDraft.ToFeetAndInches(), BowAngle = rawLogEntry. BowAngle.ToString( "N2"), BowWaterSideDraft = rawLogEntry.BowWaterSideDraft.ToFeetAndInches(), BowDockSideDraft = rawLogEntry.BowDockSideDraft.ToFeetAndInches(), AverageDraft = ((rawLogEntry.SternWaterSideDraft + rawLogEntry.SternDockSideDraft + rawLogEntry.BowWaterSideDraft + rawLogEntry.BowDockSideDraft) / 4).ToFeetAndInches(), LightDraft = rawLogEntry. LightDraft, HeavyDraft = rawLogEntry. HeavyDraft, Depth1 = (float)rawLogEntry.Depth1, Depth2 = (float)rawLogEntry.Depth2 }; return(formattedQuery.ToList()); } catch (Exception ex) { throw ex; } finally { _Entity.Dispose( ); } }
private void ProcessReadings(double[] registers) { WaterSideFreeboardForward = ScaleDepth(registers[3], _node2DepthCountsLow, _node2DepthCountsHigh, _node2DepthActualLow, _node2DepthActualHigh) - _freeboardOffset; //Yellow Box WaterSideFreeboardAft = ScaleDepth(registers[0], _node1DepthCountsLow, _node1DepthCountsHigh, _node1DepthActualLow, _node1DepthActualHigh) - _freeboardOffset; //Black box RollAngleNode1 = (ScaleAngle(registers[1], _node1RollCountsLow, _node1RollCountsHigh, _node1RollActualLow, _node1RollActualHigh) - (TareAngleStern)); RollAngleNode1 = RollAngleNode1 * -1; RollAngleNode2 = (ScaleAngle(registers[4], _node2RollCountsLow, _node2RollCountsHigh, _node2RollActualLow, _node2RollActualHigh) - (TareAngleBow)); RollAngleNode2 = RollAngleNode2 * -1; DockSideFreeboardAft = WaterSideFreeboardAft + CalculateStroke(WaterSideFreeboardAft, RollAngleNode1, BargeWidth * 12); DockSideFreeboardForward = WaterSideFreeboardForward + CalculateStroke(WaterSideFreeboardForward, RollAngleNode2, BargeWidth * 12); double avgDraft = (BargeDepth * 12) - CalculateAverageFreeboard(); HeavyDraftTonnage = TonsPerInch * (avgDraft); Payload = Math.Round((HeavyDraftTonnage - LightDraftTonnage), 0); if (_logReadings) { MDG.DataLogger.DataLogEntities1 logger = null; try { logger = new DataLogEntities1(); DataLog newLogEntry = new DataLog() { ReadingDate = DateTime.Now, SternAngle = RollAngleNode1, SternWaterSideDraft = (BargeDepth * 12) - WaterSideFreeboardAft, SternDockSideDraft = (BargeDepth * 12) - DockSideFreeboardAft, BowAngle = RollAngleNode2, BowDockSideDraft = (BargeDepth * 12) - DockSideFreeboardForward, BowWaterSideDraft = (BargeDepth * 12) - WaterSideFreeboardForward, LightDraft = LightDraft, HeavyDraft = HeavyDraft, DayNumber = logCount++, Depth1 = registers[3], Depth2 = registers[0] }; logger.AddToDataLogs(newLogEntry); logger.SaveChanges(); } catch (Exception ex) { throw ex; } finally { if (logger != null) { logger.Dispose(); } } } }