public static void Log(string message, ImportLogMessageType type)
{
SQLDataAccess.ExecuteNonQuery("INSERT INTO [Catalog].[ImportLog] (message, mtype) VALUES (@message, @mtype)",
CommandType.Text,
new SqlParameter("@mtype", (int)type),
new SqlParameter("@message", message));
}
public static void Log(string message, ImportLogMessageType type)
{
SQLDataAccess.ExecuteNonQuery("INSERT INTO [Catalog].[ImportLog] (message, mtype) VALUES (@message, @mtype)",
CommandType.Text,
new SqlParameter("@mtype", (int)type),
new SqlParameter("@message", message));
}
protected void Log(string message, ImportLogMessageType type)
{
sqlDataSourceLog.InsertParameters["mtype"].DefaultValue = type.ToString("d");
sqlDataSourceLog.InsertParameters["message"].DefaultValue = message;
sqlDataSourceLog.Insert();
if (type == ImportLogMessageType.ProductAdded)
{
Done++;
Added++;
}
if (type == ImportLogMessageType.ProductUpdated)
{
Updated++;
Done++;
}
if (type == ImportLogMessageType.InvalidData)
{
Errors++;
MsgErr(message);
}
}
private static void Log(string message, ImportLogMessageType type)
{
try
{
using (var db = new SQLDataAccess())
{
db.cmd.CommandText = "INSERT INTO [Catalog].[ImportLog] (message, mtype) VALUES (@message, @mtype)";
db.cmd.CommandType = CommandType.Text;
db.cmd.Parameters.Clear();
db.cmd.Parameters.AddWithValue("@mtype", Convert.ToInt32(type));
db.cmd.Parameters.AddWithValue("@message", message);
db.cnOpen();
db.cmd.ExecuteNonQuery();
db.cnClose();
}
}
catch (Exception ex)
{
Debug.LogError(ex);
}
}
