public void WriteFieldChanged(long refMessage)
{
var openConnection = false;
try
{
if (_cmdLogFields.Connection.State != ConnectionState.Open)
{
openConnection = true;
_cmdLogFields.Connection.Open();
}
var data = new DS.LogFieldChangedDataTable();
var table = new DataTable(data.TableName);
using (var stream = new MemoryStream())
{
data.WriteXmlSchema(stream);
stream.Flush();
stream.Position = 0;
table.ReadXmlSchema(stream);
}
foreach (var row in ChangedFieldList)
{
data.AddLogFieldChangedRow(refMessage, row.RowEntity, row.FieldName, (string)GetValue(row.OldValue), (string)GetValue(row.NewValue));
}
foreach (var row in data)
{
table.Rows.Add(row.ItemArray);
}
using (var command = _cmdLogFields.Connection.CreateCommand())
{
var parameter = command.CreateParameter();
parameter.ParameterName = "@data";
parameter.Value = table;
command.Parameters.Add(parameter);
command.CommandText = "LOG_P_BulkInsertLogFieldChanged";
command.CommandType = CommandType.StoredProcedure;
command.ExecuteNonQuery();
}
ChangedFieldList.Clear();
}
finally
{
if (openConnection)
{
_cmdLogFields.Connection.Close();
}
}
}
public void FieldChanged(string rowEntity, string fieldName, object oldValue, object newValue)
{
if (oldValue is Binary || newValue is Binary)
{
return;
}
var logChangedFieldEntry = new LogChangedFieldEntry(
null, rowEntity, fieldName, oldValue, newValue);
ChangedFieldList.Add(logChangedFieldEntry);
}
public void FieldChanged(string tableName, string tableNameKz, string rowEntity, string fieldName, string fieldNameKz, bool isDetailsViewVisible, object oldValue, object newValue)
{
if (oldValue is Binary || newValue is Binary)
{
return;
}
var logChangedFieldEntry = new LogChangedFieldEntry(
tableName, tableNameKz, rowEntity, fieldName, fieldNameKz, isDetailsViewVisible, oldValue, newValue);
ChangedFieldList.Add(logChangedFieldEntry);
}
public long?WriteLog(ILogMessageEntry logMessageEntry)
{
long?refMessage = null;
if (EnabledLogTable.EnabledLog(logMessageEntry.MessageCodeAsLong, Transaction))
{
refMessage = WriteToDataBase(logMessageEntry);
}
ChangedFieldList.Clear();
return(refMessage);
}
public long?WriteLog(LogMessageType messageCode, Func <ILogMessageEntry> log)
{
long?refMessage = null;
if (EnabledLogTable.EnabledLog((long)messageCode, Transaction))
{
var logMessageEntry = log();
if (logMessageEntry.MessageCodeAsLong == 0)
{
logMessageEntry.MessageCodeAsLong = (long)messageCode;
}
refMessage = WriteToDataBase(logMessageEntry);
}
ChangedFieldList.Clear();
return(refMessage);
}
public void ClearChangedFieldList()
{
ChangedFieldList.Clear();
}