private void AddFormulaParameteNode(object node, FormulaUsageParemetersDTO item)
{
var title = (string.IsNullOrEmpty(item.RelationshipPropertyTail) ? "" : item.RelationshipPropertyTail + ".") + item.ParameterName + " : " + item.ParameterValue;
var pNode = View.AddTreeNode(node, title);
//foreach (var property in item.ChildItems)
//{
// AddFormulaParameteNode(pNode, property);
//}
}
private List <FormulaUsageParemetersDTO> GetFormulaUsageParemeters(DR_Requester requester, FormulaDTO formula, DP_DataRepository dataItem)
{
List <FormulaUsageParemetersDTO> result = new List <FormulaUsageParemetersDTO>();
foreach (var item in formula.FormulaItems)
{
if (item.ItemType == FormuaItemType.Column)
{
FormulaUsageParemetersDTO formulaUsageParemeter = new FormulaUsageParemetersDTO();
formulaUsageParemeter.ParameterName = item.ItemTitle;
DataitemRelatedColumnValueHandler dataitemRelatedColumnValueHandler = new DataitemRelatedColumnValueHandler();
var value = dataitemRelatedColumnValueHandler.GetValueSomeHow(requester, dataItem, item.RelationshipTail, item.ItemID, true);
formulaUsageParemeter.ParameterValue = (value != null ? value.ToString() : "<Null>");
result.Add(formulaUsageParemeter);
}
}
return(result);
}
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);
}
