public string ActionExecuteChangeLog(ChangesHeader _ChangesHeader, List <ChangeItem> _ChangeItemCollection)
{
string _Result = string.Empty;
MappingChanges _MappingChanges = null;
string _XML = string.Empty;
List <DbParameter> _ParameterList = new List <DbParameter>();
string _ConnectionString = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04_HistoricoModificacoes"].ConnectionString;
string _ProviderName = ConfigurationManager.ConnectionStrings["BrErpSindicatoV04_HistoricoModificacoes"].ProviderName;
string _TSQL = "[dbo].[Log_ModificaLogModificacoes]";
_MappingChanges = ServiceHelper.CreateInstance.GetMappingChanges(_ChangesHeader, _ChangeItemCollection);
_XML = SerializationData.CreateInstance.GetSerializableData(_MappingChanges, "MappingExecuteChangeLog");
_ParameterList.Add(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).CreateParameter("@XMLChangeLog", System.Data.DbType.Xml, _XML));
try
{
_Result = Convert.ToString(DatabasePersistence.CreateInstance(_ConnectionString, _ProviderName).ExecuteCommand(_TSQL, CommandType.StoredProcedure, _ParameterList, ExecuteType.ExecuteScalar));
}
catch (Exception ex)
{
ExceptionHandling.CreateInstance.AddExceptionAndSaveTextFile(ex);
}
return(_Result);
}
public MappingChanges GetMappingChanges(ChangesHeader _ChangeHeader, List <ChangeItem> _ChangeItems)
{
MappingChanges _MappingChanges = null;
List <ChangesHeader> _ChangeHeadersHelper = new List <ChangesHeader>();
List <ChangeItem> _ChangeItemsHelper = new List <ChangeItem>();
_ChangeHeadersHelper.Add(new ChangesHeader()
{
Id = _ChangeHeader.Id,
CodigoRegistro = _ChangeHeader.CodigoRegistro,
NomeProcesso = _ChangeHeader.NomeProcesso,
TipoModificacao = _ChangeHeader.TipoModificacao,
Usuario = _ChangeHeader.Usuario,
DataHora = _ChangeHeader.DataHora,
StatusExecucao = _ChangeHeader.StatusExecucao
});
foreach (ChangeItem _ChangeItem in _ChangeItems)
{
_ChangeItemsHelper.Add(new ChangeItem()
{
IdChangeHeader = _ChangeItem.IdChangeHeader,
IdItem = _ChangeItem.IdItem,
NomeTabela = _ChangeItem.NomeTabela,
NomeCampo = _ChangeItem.NomeCampo,
ValorAntigo = _ChangeItem.ValorAntigo,
ValorNovo = _ChangeItem.ValorNovo
});
}
if (_MappingChanges == null)
{
_MappingChanges = new MappingChanges();
}
_MappingChanges.ChangeHeaders = _ChangeHeadersHelper;
_MappingChanges.ChangeItems = _ChangeItemsHelper;
return(_MappingChanges);
}
