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