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