// I_View_EditLogReportDetails EditLogReportDetailsView;
private void View_DetailsClicked(object sender, DataLogDTO e)
{
if (e.MainType == DataLogType.DataEdit || e.MainType == DataLogType.DataInsert)
{
//if (EditLogReportDetailsView == null)
//{
var logData = AgentUICoreMediator.GetAgentUICoreMediator.logManagerService.GetDataLog(AgentUICoreMediator.GetAgentUICoreMediator.GetRequester(), e.ID);
var EditLogReportDetailsView = AgentUICoreMediator.GetAgentUICoreMediator.UIManager.GenereateViewOfEditLogReportDetails();
EditLogReportDetailsView.ColumnParameterVisibility = false;
EditLogReportDetailsView.ExitRequested += EditLogReportDetailsView_ExitRequested;
// }
EditLogReportDetailsView.ColmnSelected += EditLogReportDetailsView_ColmnSelected;
var window = AgentUICoreMediator.GetAgentUICoreMediator.UIManager.GetDialogWindow();
EditLogReportDetailsView.AddColumnEditLogs(logData.EditDataItemColumnDetails);
EditLogReportDetailsView.AddExceptionLogs(new List <EditDataItemExceptionLogDTO>()
{
logData.EditDataItemExceptionLog
});
window.ShowDialog(EditLogReportDetailsView, "جزئیات", Enum_WindowSize.Maximized);
}
else
if (e.MainType == DataLogType.ArchiveDelete || e.MainType == DataLogType.ArchiveInsert)
{
//var logData = AgentUICoreMediator.GetAgentUICoreMediator.logManagerService.GetDataLog(e.ID);
////if (EditLogReportDetailsView == null)
////{
//var archiveLogDetailsView = AgentUICoreMediator.GetAgentUICoreMediator.UIManager.GenereateViewOfArchiveLogReportDetails();
//archiveLogDetailsView.ExitRequested += EditLogReportDetailsView_ExitRequested;
//var window = AgentUICoreMediator.GetAgentUICoreMediator.UIManager.GetDialogWindow();
//archiveLogDetailsView.AddExceptionLogs(new List<ArchiveItemLogDTO>() { logData.ArchiveItemLog });
//window.ShowDialog(archiveLogDetailsView, "جزئیات", Enum_WindowSize.Maximized);
}
}
private void View_PackageClicked(object sender, DataLogDTO e)
{
if (e.PackageGuid != null)
{
var logData = AgentUICoreMediator.GetAgentUICoreMediator.logManagerService.GetDataLogsByPackageID(AgentUICoreMediator.GetAgentUICoreMediator.GetRequester(), e.PackageGuid.Value);
View.AddPackageDataLogs(logData);
View.PackageDatagridVisiblity = true;
}
}
private DataLogDTO GetBaseLog(DP_DataRepository dataItem)
{
var dataLog = new DataLogDTO();
dataLog.LocationInfo = "";
dataLog.Duration = 0;
dataLog.DatItem = dataItem;
return(dataLog);
}
//private List<DataLogDTO> GetDataLogs(InternaleEditResult internalResult, DR_Requester requester)
//{
// List<DataLogDTO> result = new List<DataLogDTO>();
// var packageGUID = Guid.NewGuid();
// if (internalResult.Result == Enum_DR_ResultType.SeccessfullyDone)
// {
// foreach (var item in internalResult.EditQueryResults)
// {
// DataLogDTO dataLog = ToDataLog(item, packageGUID, requester, false, false);
// result.Add(dataLog);
// }
// }
// else
// {
// foreach (var item in internalResult.EditQueryResults.Where(x => x.BeforeSaveActionActivitiesResult == Enum_DR_SimpleResultType.ExceptionThrown
// || x.DataUpdateResult == Enum_DR_SimpleResultType.ExceptionThrown || x.AfterSaveActionActivitiesResult == Enum_DR_SimpleResultType.ExceptionThrown))
// {
// DataLogDTO dataLog = ToDataLog(item, packageGUID, requester, internalResult.Result == Enum_DR_ResultType.ExceptionThrown, internalResult.Result == Enum_DR_ResultType.JustMajorFunctionDone);
// result.Add(dataLog);
// }
// }
// return result;
//}
private DataLogDTO GetBaseLog(QueryItem queryItem)
{
var dataLog = new DataLogDTO();
dataLog.LocationInfo = "";
dataLog.Duration = 0;
dataLog.DatItem = queryItem.DataItem;
dataLog.MainType = GetLogType(queryItem);
return(dataLog);
}
private DataLogDTO GetAfterUpdateExceptionLog(LetterDTO message, Exception Exception, DataLogType logType)
{
var dataLog = new DataLogDTO();
dataLog.LocationInfo = "";
dataLog.Duration = 0;
dataLog.MinorException = true;
dataLog.MainType = logType;
dataLog.DatItem = message.DataItem;
dataLog.LetterItemLog.AfterUpdateException = Exception.Message;
return(dataLog);
}
private List <DataLogDTO> GetUpdateDataSuccessfulLogs(List <EditQueryResultItem> editQueryResults)
{
List <DataLogDTO> result = new List <DataLogDTO>();
var packageGUID = Guid.NewGuid();
foreach (var item in editQueryResults)
{
DataLogDTO dataLog = ToUpdateSuccessfulLog(item, packageGUID);
result.Add(dataLog);
}
return(result);
}
public string AddLog(DataLogDTO messages, DR_Requester requester)
{
try
{
using (var context = new MyIdeaDataDBEntities())
{
AddLogInternal(messages, context, requester);
context.SaveChanges();
return("");
}
}
catch (Exception ex)
{
return(ex.Message);
}
}
private DataLogDTO GetUpdateLetterDataLog(LetterDTO message, string exceptionMessage, DataLogType logType)
{
var dataLog = new DataLogDTO();
dataLog.LocationInfo = "";
dataLog.Duration = 0;
dataLog.DatItem = message.DataItem;
dataLog.MainType = logType;
dataLog.RelatedItemID = message.ID;
if (!string.IsNullOrEmpty(exceptionMessage))
{
dataLog.MajorException = true;
dataLog.MajorFunctionExceptionMessage = exceptionMessage;
//dataLog.ArchiveItemLog = new ArchiveItemLogDTO();
//dataLog.ArchiveItemLog.Exception = exceptionMessage;
}
return(dataLog);
}
private DataLogDTO GetDeleteItemDataLog(Letter dbletter, string exceptionMessage)
{
var dataLog = new DataLogDTO();
dataLog.LocationInfo = "";
dataLog.Duration = 0;
dataLog.DatItem = new DP_BaseData(dbletter.MyDataItemID);
dataLog.MainType = DataLogType.LetterDelete;
dataLog.RelatedItemID = dbletter.ID;
if (!string.IsNullOrEmpty(exceptionMessage))
{
dataLog.MajorException = true;
dataLog.MajorFunctionExceptionMessage = exceptionMessage;
//dataLog.ArchiveItemLog = new ArchiveItemLogDTO();
//dataLog.ArchiveItemLog.Exception = exceptionMessage;
}
return(dataLog);
}
private DataLogDTO GetCreateItemDataLog(ArchiveItemDTO archiveItem, string exceptionMessage)
{
var dataLog = new DataLogDTO();
dataLog.LocationInfo = "";
dataLog.Duration = 0;
dataLog.DatItem = archiveItem.DatItem;
dataLog.MainType = DataLogType.ArchiveInsert;
dataLog.RelatedItemID = archiveItem.ID;
if (!string.IsNullOrEmpty(exceptionMessage))
{
dataLog.MajorException = true;
dataLog.MajorFunctionExceptionMessage = exceptionMessage;
//dataLog.ArchiveItemLog = new ArchiveItemLogDTO();
//dataLog.ArchiveItemLog.Exception = exceptionMessage;
}
return(dataLog);
}
public async Task <ApiResponse> Post([FromBody] DataLogDTO dto)
{
if (ModelState.IsValid)
{
try
{
var dataLog = _mapper.Map <DataLog>(dto);
return(new ApiResponse("Created Successfully", await _dataLogManager.AddAsync(dataLog), 201));
}
catch (Exception ex)
{
_logger.Log(LogLevel.Error, ex, "Error when trying to insert kafka.");
throw;
}
}
else
{
throw new ApiException(ModelState.AllErrors());
}
}
private void AddLogInternal(DataLogDTO message, MyIdeaDataDBEntities context, DR_Requester requester)
{
var dbLog = new DataLog();
if (message.DatItem.DataItemID == 0)
{
dbLog.MyDataItemID = bizDataItem.GetOrCreateDataItem(message.DatItem);
}
else
{
dbLog.MyDataItemID = message.DatItem.DataItemID;
}
// dbLog.DataInfo = message.DatItem.ViewInfo;
dbLog.Date = DateTime.Now;
dbLog.Time = DateTime.Now.ToString("HH:mm:ss");
dbLog.Duration = message.Duration;
dbLog.MajorFunctionException = message.MajorException;
dbLog.MinorFunctionException = message.MinorException;
dbLog.MajorFunctionExceptionMessage = message.MajorFunctionExceptionMessage;
dbLog.LocationInfo = message.LocationInfo;
dbLog.RelatedItemID = message.RelatedItemID;
dbLog.PackageGuid = message.PackageGuid;
dbLog.MainType = (short)message.MainType;
dbLog.UserID = requester.Identity;
if (message.EditDataItemExceptionLog != null)
{
dbLog.EditDataItemExceptionLog = new EditDataItemExceptionLog();
dbLog.EditDataItemExceptionLog.AfterSaveActionExceptionMessage = message.EditDataItemExceptionLog.AfterSaveActionExceptionMessage;
//dbLog.EditDataItemExceptionLog.BeforeSaveActionExceptionMessage = message.EditDataItemExceptionLog.BeforeSaveActionExceptionMessage;
//dbLog.EditDataItemExceptionLog.DataUpdateExceptionMessage = message.EditDataItemExceptionLog.DataUpdateExceptionMessage;
//dbLog.EditDataItemExceptionLog.FormulaUsageExceptionMessage = message.EditDataItemExceptionLog.ForumulaUsageExceptionMessage;
dbLog.EditDataItemExceptionLog.DataUpdateQuery = message.EditDataItemExceptionLog.DataUpdateQuery;
}
if (message.EditDataItemColumnDetails != null)
{
foreach (var messageCol in message.EditDataItemColumnDetails)
{
EditDataItemColumnDetails dbCol = new EditDataItemColumnDetails();
dbCol.ColumnID = messageCol.ColumnID;
dbCol.Info = messageCol.Info;
dbCol.NewValue = messageCol.NewValue == null ? "<Null>" : messageCol.NewValue.ToString();
dbCol.OldValue = messageCol.OldValue == null ? "<Null>" : messageCol.OldValue.ToString();
dbCol.FormulaException = messageCol.FormulaException;
dbCol.FormulaID = messageCol.FormulaID;
dbLog.EditDataItemColumnDetails.Add(dbCol);
foreach (var formulaParam in messageCol.FormulaUsageParemeters)
{
FormulaUsageParemeters paramDB = new FormulaUsageParemeters();
paramDB.ID = formulaParam.ID;
paramDB.ParameterName = formulaParam.ParameterName;
paramDB.ParameterValue = formulaParam.ParameterValue;
paramDB.RelationshipKeyColumnTail = formulaParam.RelationshipPropertyTail;
dbCol.FormulaUsageParemeters.Add(paramDB);
}
}
}
//if (message.ArchiveItemLog != null)
//{
// dbLog.ArchiveItemLog = new ArchiveItemLog();
// dbLog.ArchiveItemLog.Exception = message.ArchiveItemLog.Exception;
//}
context.DataLog.Add(dbLog);
}
private DataLogDTO ToDataLogDTO(DR_Requester requester, DataLog item, bool withDetails)
{
var message = new DataLogDTO();
message.ID = item.ID;
if (item.MyDataItemID != null && item.MyDataItemID != 0)
{
message.DatItem = bizDataItem.ToDataViewDTO(requester, item.MyDataItem, withDetails);
}
message.Date = item.Date;
message.vwPersianDate = GeneralHelper.GetShamsiDate(item.Date);
// message.DataInfo = item.DataInfo;
var entity = bizTableDrivedEntity.GetTableDrivedEntity(requester, item.MyDataItem.TableDrivedEntityID, ModelEntites.EntityColumnInfoType.WithSimpleColumns, ModelEntites.EntityRelationshipInfoType.WithoutRelationships);
if (item.MyDataItem != null)
{
//بهتر شود
message.vwEntityAlias = entity.Alias;
}
message.Duration = item.Duration ?? 0;
message.MajorException = item.MajorFunctionException;
message.MinorException = item.MinorFunctionException;
message.MajorFunctionExceptionMessage = item.MajorFunctionExceptionMessage;
message.LocationInfo = item.LocationInfo;
message.PackageGuid = item.PackageGuid;
message.Time = item.Time;
message.MainType = (DataLogType)item.MainType;
message.UserID = item.UserID;
message.vwUserInfo = bizUser.GetUserFullName(item.UserID);
if (withDetails)
{
foreach (var columnLog in item.EditDataItemColumnDetails)
{
var colMsg = new EditDataItemColumnDetailsDTO();
colMsg.ColumnID = columnLog.ColumnID;
var column = entity.Columns.FirstOrDefault(x => x.ID == colMsg.ColumnID);
if (column != null)
{
colMsg.vwColumnName = column.Name;
colMsg.vwColumnAlias = column.Alias;
}
colMsg.Info = columnLog.Info;
colMsg.NewValue = columnLog.NewValue;
colMsg.OldValue = columnLog.OldValue;
message.EditDataItemColumnDetails.Add(colMsg);
colMsg.FormulaException = columnLog.FormulaException;
colMsg.FormulaID = columnLog.FormulaID ?? 0;
foreach (var formulaParam in columnLog.FormulaUsageParemeters)
{
FormulaUsageParemetersDTO paramDTO = new FormulaUsageParemetersDTO();
paramDTO.ID = formulaParam.ID;
paramDTO.ParameterName = formulaParam.ParameterName;
paramDTO.ParameterValue = formulaParam.ParameterValue;
paramDTO.RelationshipPropertyTail = formulaParam.RelationshipKeyColumnTail;
colMsg.FormulaUsageParemeters.Add(paramDTO);
}
}
if (item.EditDataItemExceptionLog != null)
{
message.EditDataItemExceptionLog = new EditDataItemExceptionLogDTO();
message.EditDataItemExceptionLog.AfterSaveActionExceptionMessage = item.EditDataItemExceptionLog.AfterSaveActionExceptionMessage;
//message.EditDataItemExceptionLog.BeforeSaveActionExceptionMessage = item.EditDataItemExceptionLog.BeforeSaveActionExceptionMessage;
//message.EditDataItemExceptionLog.DataUpdateExceptionMessage = item.EditDataItemExceptionLog.DataUpdateExceptionMessage;
message.EditDataItemExceptionLog.DataUpdateQuery = item.EditDataItemExceptionLog.DataUpdateQuery;
//message.EditDataItemExceptionLog.ForumulaUsageExceptionMessage = item.EditDataItemExceptionLog.FormulaUsageExceptionMessage;
message.EditDataItemExceptionLog.ID = item.EditDataItemExceptionLog.ID;
}
//if (item.ArchiveItemLog != null)
//{
// message.ArchiveItemLog = new ArchiveItemLogDTO();
// message.ArchiveItemLog.ID = item.ArchiveItemLog.ID;
// message.ArchiveItemLog.Exception = item.ArchiveItemLog.Exception;
//}
}
return(message);
}
