public ActionResult LogContent()
{
string conString = "Data Source=VKT-TAYLANA\\SQLEXPRESS;Initial Catalog=BlogWebSystem;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
SqlConnection connection = new SqlConnection(conString);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
string listQuery = "SELECT PostId, PostTitle, PostText, AuthorName, AuthorLname, Published, Deleted, CategoryName FROM LogPost INNER JOIN Category ON LogPost.CategoryId = Category.CategoryId INNER JOIN Author ON LogPost.AuthorId = Author.AuthorId";
SqlCommand list = new SqlCommand(listQuery, connection);
SqlDataReader reader = list.ExecuteReader();
List <Models.LogModel> LogModel = new List <Models.LogModel>();
Models.LogModel item;
while (reader.Read())
{
item = new Models.LogModel();
item.PostId = Convert.ToInt32(reader["PostId"]);
item.PostTitle = reader["PostTitle"].ToString();
item.AuthorName = reader["AuthorName"].ToString();
item.AuthorLname = reader["AuthorLname"].ToString();
item.Published = reader["Published"].ToString();
item.Deleted = reader["Deleted"].ToString();
item.CategoryName = reader["CategoryName"].ToString();
LogModel.Add(item);
}
connection.Close();
reader.Close();
return(View(LogModel));
}
public List <Models.LogModel> Get()
{
List <Models.LogModel> logList = new List <Models.LogModel>();
for (int i = 0; i < 10; i++)
{
Models.LogModel logModel = Helpers.LogProducer.ProduceLogEvent(i + 1);
string strLog = JsonConvert.SerializeObject(logModel);
logList.Add(logModel);
Helpers.QueueManager.SendMessageToQueue("queuelog1", strLog);
Helpers.QueueManager.SendMessageToQueue("queuelog2", strLog);
}
return(logList);
}
public void Add(Models.LogModel e)
{
string name = "tbl_" + MD5Encoding(e.App);
CreateTabel(name);
using (DBContext.ChangeTable <DBLog>(name))
{
DBLog log = new DBLog();
log.App = e.App;
log.Content = e.Content;
log.CreateTime = e.CreateTime;
log.Host = e.Host;
log.Type = e.Type;
log.Save(DB);
}
}
public static Models.LogModel ProduceLogEvent(int seed)
{
string [] transactions = new string[] {
"T0", "T1", "T2", "T3", "T4", "T5", "T6", "T7", "T8", "T9"
};
string eventDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Models.LogModel logModel = new Models.LogModel()
{
id = Guid.NewGuid().ToString(),
transaction_name = transactions[new Random(seed * seed).Next(0, 10)],
log_date = eventDate,
nlog_date = Convert.ToInt64(eventDate.Replace("-", "").Replace(":", "").Replace(" ", "")),
severity = new Random().Next(1, 10)
};
return(logModel);
}
protected override void Append(log4net.Core.LoggingEvent loggingEvent)
{
try
{
Models.LogModel log = new Models.LogModel();
log.App = this.AppName;
log.Host = ServerName;
log.Content = loggingEvent.RenderedMessage;
log.CreateTime = DateTime.Now;
if (loggingEvent.Level == log4net.Core.Level.Debug)
{
log.Type = Models.LogType.Debug;
}
else if (loggingEvent.Level == log4net.Core.Level.Info)
{
log.Type = Models.LogType.Info;
}
else if (loggingEvent.Level == log4net.Core.Level.Warn)
{
log.Type = Models.LogType.Warn;
}
else if (loggingEvent.Level == log4net.Core.Level.Error)
{
log.Type = Models.LogType.Error;
}
else if (loggingEvent.Level == log4net.Core.Level.Fatal)
{
log.Type = Models.LogType.Fatal;
}
else
{
log.Type = Models.LogType.Info;
}
Push(log);
}
catch (Exception e_)
{
LogLog.Error(typeof(Log4GridAppender), e_.Message);
}
}
private void OnLog(Models.LogModel e)
{
Factory.Store.Add(e);
}
protected override void Append(log4net.Core.LoggingEvent loggingEvent)
{
try
{
Models.LogModel log = new Models.LogModel();
log.App = this.AppName;
log.Host = ServerName;
log.Content = loggingEvent.RenderedMessage;
log.CreateTime = DateTime.Now;
if (loggingEvent.Level == log4net.Core.Level.Debug)
{
log.Type = Models.LogType.Debug;
}
else if (loggingEvent.Level == log4net.Core.Level.Info)
{
log.Type = Models.LogType.Info;
}
else if (loggingEvent.Level == log4net.Core.Level.Warn)
{
log.Type = Models.LogType.Warn;
}
else if (loggingEvent.Level == log4net.Core.Level.Error)
{
log.Type = Models.LogType.Error;
}
else if (loggingEvent.Level == log4net.Core.Level.Fatal)
{
log.Type = Models.LogType.Fatal;
}
else
{
log.Type = Models.LogType.Info;
}
Push(log);
}
catch (Exception e_)
{
LogLog.Error(typeof(Log4GridAppender), e_.Message);
}
}
