public void WriteMainEventLog(DateTime dtEvent, EventCode e1, EventSubCode e2, string Text, string Value, string LoginUserId) { if (ConnectionString == null) { ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["SelfiConnectionString"]; } SqlConnection connection = new SqlConnection(ConnectionString); try { string queryString = "INSERT Selfi.dbo.MainEventLog ([CreateDate],[Program],[LoginUser],[eventType],[eventSubType],[Text],[Value]) VALUES (@CreateDate,@Program,@LoginUser,@eventType,@eventSubType,@Text,@Value)"; SqlCommand command = new SqlCommand(queryString, connection); command.Connection.Open(); command.Parameters.AddWithValue("@CreateDate", dtEvent); AddParams(command.Parameters, "@LoginUser", LoginUserId, 50); AddParams(command.Parameters, "@Program", ApplicationName, 50); command.Parameters.AddWithValue("@eventType", e1); command.Parameters.AddWithValue("@eventSubType", e2); AddParams(command.Parameters, "@Text", Text, 4000); AddParams(command.Parameters, "@Value", Value, 100); command.ExecuteNonQuery(); } catch (Exception Ex) { // Co proboha udelat pokud selze log } finally { connection.Close(); } }
public void WriteMainEventLog(EventCode e1, EventSubCode e2, string Text) { WriteMainEventLog(DateTime.Now, e1, e2, Text, ""); }
public CMainEventLog(EventCode eventCode, EventSubCode eventSubCode, string Text, string Value, string sUserId) : this() { WriteMainEventLog(eventCode, eventSubCode, Text, Value, sUserId); }
public CMainEventLog(EventCode eventCode, EventSubCode eventSubCode, string Text) : this() { WriteMainEventLog(eventCode, eventSubCode, Text); }
public void WriteMainEventLog(EventCode e1, EventSubCode e2, string Text, string Value, string LoginUserId) { WriteMainEventLog(DateTime.Now, e1, e2, Text, Value, LoginUserId); }