public List <StandingLogEntry> GetStandingLogs(Character character, DateTimeRange timeRange)
{
var records = Db.Query().CommandText("select * from standinglog where characterid=@characterID and eventtime between @earlier and @later")
.SetParameter("@characterID", character.Id)
.SetParameter("@earlier", timeRange.Start)
.SetParameter("@later", timeRange.End)
.Execute();
var logEntries = new List <StandingLogEntry>();
foreach (var record in records)
{
var logEntry = new StandingLogEntry();
logEntry.characterID = record.GetValue <int>("characterid");
logEntry.date = record.GetValue <DateTime>("eventtime");
logEntry.actual = record.GetValue <double>("actual");
logEntry.change = record.GetValue <double>("change");
logEntry.allianceEID = record.GetValue <long>("allianceeid");
logEntry.missionID = record.GetValue <int?>("missionid");
logEntries.Add(logEntry);
}
return(logEntries);
}
public void InsertStandingLog(StandingLogEntry logEntry)
{
Db.Query().CommandText("insert standinglog (characterid,actual,change,allianceeid,missionid) values (@characterID,@actual,@change,@allianceEID,@missionID)")
.SetParameter("@characterID", logEntry.characterID)
.SetParameter("@actual", logEntry.actual)
.SetParameter("@change", logEntry.change)
.SetParameter("@allianceEID", logEntry.allianceEID)
.SetParameter("@missionID", logEntry.missionID)
.ExecuteNonQuery();
}
public void WriteStandingLog(StandingLogEntry logEntry)
{
_standingRepository.InsertStandingLog(logEntry);
}
