/// <summary> /// Insert message to the database. Do not fire errors. /// </summary> /// <param name="message"></param> /// <param name="source"></param> /// <param name="stacktrase"></param> /// <param name="onServer"></param> public static void InsertMessageAsync(string message, int clientID, eSources source, eMessageTypes type, string stackTrase, DateTime dateGenerated) { // Do not refire errors SQLWorker.Default.Add(CreateInsertMessage(message, clientID, source, type, stackTrase, dateGenerated), //No Errors! PTFUtils.EmptyThreadExceptionEventHandler()); }
/// <summary> /// Select config value /// </summary> /// <param name="dict"></param> /// <param name="source"></param> /// <returns></returns> public static IList <DbConfigInfo> SelectConfig(IDictionary dict, eSources source) { const string sql = "SELECT Key, Value FROM CONFIG WHERE SourceID = @SourceID;"; IList <DbConfigInfo> list = MSSQL.ExecuteReader <DbConfigInfo>(ConnectionString, sql, new SqlParameter("@SourceID", Convert.ToInt32(source))); return(list); }
/// <summary> /// Creates command for inserting message to the client database /// </summary> /// <param name="message"></param> /// <param name="source"></param> /// <param name="stacktrase"></param> /// <param name="onServer"></param> /// <returns></returns> private static SqlCommand CreateInsertMessage(string message, eSources source, eMessageTypes type, string stackTrase) { const string sql = "INSERT INTO MESSAGES(Message, Source, Type, StackTrace, DateInserted) VALUES " + "(@Message, @Source, @Type, @StackTrace, @DateInserted);"; return(MSSQL.CreateCommand(ConnectionString, sql, new SqlParameter("@Message", message.Top(1024)), new SqlParameter("@Source", Convert.ToInt32(source)), new SqlParameter("@Type", Convert.ToInt32(type)), new SqlParameter("@StackTrace", stackTrase.Top(2028)), new SqlParameter("@DateInserted", DateTime.Now))); }
/// <summary> /// Creates a command for inserting message /// </summary> /// <param name="message"></param> /// <param name="source"></param> /// <param name="stacktrase"></param> /// <param name="onServer"></param> /// <returns></returns> private static SqlCommand CreateInsertMessage(string message, int clientID, eSources source, eMessageTypes type, string stackTrace, DateTime dateGenerated) { const string sql = "spInsertMessage"; return(MSSQL.CreateCommand(ConnectionString, sql, CommandType.StoredProcedure, new SqlParameter("@ClientID", clientID), new SqlParameter("@Message", message), new SqlParameter("@Type", Convert.ToInt32(type)), new SqlParameter("@SourceID", Convert.ToInt32(source)), new SqlParameter("@StackTrace", stackTrace), new SqlParameter("@DateGenerated", dateGenerated))); }
/// <summary> /// Insert message to the database. Do not fire errors. /// </summary> /// <param name="message"></param> /// <param name="source"></param> /// <param name="stacktrase"></param> /// <param name="onServer"></param> public static void InsertMessage(string message, int clientID, eSources source, eMessageTypes type, string stackTrase, DateTime dateGenerated) { // Do not refire errors SQL.ExecuteNonQuery(CreateInsertMessage(message, clientID, source, type, stackTrase, dateGenerated)); }
/// <summary> /// Inserts message to the client database asynchronously /// </summary> /// <param name="message"></param> /// <param name="source"></param> /// <param name="type"></param> /// <param name="stacktrase"></param> public static void InsertMessageAsync(string message, eSources source, eMessageTypes type, string stacktrase) { // Do not refire errors SQLWorker.Default.Add(CreateInsertMessage(message, source, type, stacktrase)); }
/// <summary> /// Inserts message to the client database /// </summary> /// <param name="message"></param> /// <param name="source"></param> /// <param name="type"></param> /// <param name="stacktrase"></param> public static void InsertMessage(string message, eSources source, eMessageTypes type, string stacktrase) { SQL.ExecuteNonQuery(CreateInsertMessage(message, source, type, stacktrase)); }