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