public async Task <ActionResult> Privacy() { IList <Models.EventLog> logs = new List <Models.EventLog>(); using (SqlConnection connection = new SqlConnection(this.sqlConnectionString)) { await connection.OpenAsync().ConfigureAwait(false); using var sqlcommand = connection.CreateCommand(); sqlcommand.CommandText = "GetLeaderboard"; sqlcommand.CommandType = System.Data.CommandType.StoredProcedure; using (var reader = await sqlcommand.ExecuteReaderAsync().ConfigureAwait(false)) { while (reader.HasRows) { while (await reader.ReadAsync().ConfigureAwait(false)) { var log = new Models.EventLog(); log.UserId = reader.GetString(0); log.Qno = reader.GetInt32(1); logs.Add(log); } await reader.NextResultAsync().ConfigureAwait(false); } } } return(View(logs)); }
/// <summary> /// Insert Log /// </summary> /// <param name="log"></param> /// <returns></returns> public bool InsertLog(Models.EventLog log) { string command = $@"INSERT INTO [dbo].[CoreEventLogs] ([EventId], [Logger],[LogLevel],[Message],[CreatedDate]) VALUES (@EventId, @Logger, @LogLevel, @Message, @CreatedDate)"; List <SqlParameter> paramList = new List <SqlParameter>(); paramList.Add(new SqlParameter("EventId", log.EventId)); paramList.Add(new SqlParameter("Logger", log.Logger)); paramList.Add(new SqlParameter("LogLevel", log.LogLevel)); paramList.Add(new SqlParameter("Message", log.Message)); paramList.Add(new SqlParameter("CreatedDate", log.CreatedDate)); return(ExecuteNonQuery(command, paramList)); }
public FilterEventLog(Models.EventLog eventLog) { Fill(eventLog); }