internal static SimpleTreeItem MapToSimpleTreeItem(IDataRecord dr)
{
SimpleTreeItem t = new SimpleTreeItem();
t.Value = dr["VALUE"].ToString();
t.Text = dr["TEXT"].ToString();
t.SubType = dr["SUBTYPE"].ToString();
t.Source = dr["SOURCE"].ToString();
t.Padre = dr["PADRE"].ToString();
return(t);
}
internal static SimpleTreeItem MapToSimpleTreeItemForMail(IDataRecord dr)
{
SimpleTreeItem t = new SimpleTreeItem();
t.Value = dr["ID_MAIL"].ToString();
t.Text = dr["MAIL_SUBJECT"].ToString();
t.SubType = dr["FOLDER"].ToString();
t.Source = dr["IND_MAIL"].ToString();
t.Padre = dr["FOLLOWS"].ToString();
return(t);
}
private SimpleTreeItem MapToSimpleTreeItem(DbDataReader dr)
{
SimpleTreeItem item = new SimpleTreeItem();
item.Value = dr.GetDecimal("ID_REF").ToString();
item.Padre = dr.GetDecimal("ID_PAD").ToString();
item.Text = dr.GetString("RAG_SOC");
item.SubType = dr.GetValue("IS_PADRE").ToString();
item.Source = dr.GetString("SRC");
item.Description = dr.GetString("REF_TYP");
return(item);
}
private IEnumerable <SimpleTreeItem> convertToItem(List <JObject> objects, PropertyCacheLevel referenceCacheLevel, bool preview)
{
if (!objects.Any())
{
return(Enumerable.Empty <SimpleTreeItem>());
}
var items = new List <SimpleTreeItem>();
foreach (var sourceObject in objects)
{
var elementObject = sourceObject["properties"]?.ToObject <JObject>() ?? new JObject();
elementObject["ncContentTypeAlias"] = sourceObject["contentTypeAlias"]?.ToObject <string>() ?? "menuNode";
elementObject["name"] = sourceObject["name"]?.ToObject <string>();
elementObject["key"] = sourceObject["key"]?.ToObject <string>() ?? Guid.NewGuid().ToString();
var element = ConvertToElement(elementObject, referenceCacheLevel, preview);
if (element == null)
{
continue;
}
var item = new SimpleTreeItem()
{
Item = element,
Name = sourceObject["name"]?.ToObject <string>()
};
var children = sourceObject["items"]?.ToObject <List <JObject> >();
if (children != null && children.Any())
{
item.Items = convertToItem(children, referenceCacheLevel, preview);
}
items.Add(item);
}
return(items);
}
public static void AddToVirtualGroup(SimpleTreeItem item, SimpleTreeItem VirtualGroup)
{
}
public static void addNewVirtualGroup(SimpleTreeItem item)
{
}
public Dictionary <string, SimpleTreeItem> LoadTree(Int64?startNode, SendMail.Model.IndexedCatalogs catalog, int?levels)
{
Dictionary <string, SimpleTreeItem> list = null;
StringBuilder query = new StringBuilder();
try
{
switch (catalog)
{
case IndexedCatalogs.RUBR:
query.Append("select ID_REFERRAL AS VALUE, ");
query.Append("CASE WHEN REFERRAL_TYPE in ('PA','AZ_PRI','AZ_CP','GRP') then RAGIONE_SOCIALE else UFFICIO end as TEXT, ");
query.Append("REFERRAL_TYPE AS SUBTYPE, ");
query.Append("'RUBR' AS SOURCE, ");
query.Append("ID_PADRE AS PADRE ");
query.Append("from rubr_entita ");
query.Append("where REFERRAL_TYPE in ('PA','PA_SUB','PA_UFF','AZ_PRI','AZ_CP','AZ_UFF','GRP') ");
if (levels.HasValue)
{
query.Append("and level <=:pLVL ");
}
if (startNode.HasValue)
{
query.Append("start with ID_REFERRAL = :pID ");
}
else
{
query.Append("start with ID_REFERRAL = 0 ");
}
query.Append("connect by NOCYCLE prior ID_REFERRAL = ID_PADRE ");
break;
case IndexedCatalogs.IPA:
query.Append("select ID_RUB AS VALUE, ");
query.Append("'IPA' AS SOURCE, ");
query.Append("CASE WHEN ( substr(DN,1,2)= 'c=' or substr(DN,1,2) = 'o=') then RAGIONESOCIALE ");
query.Append("else UFFICIO end AS TEXT, ");
query.Append("CASE WHEN substr(DN,1,2)= 'c=' then 'GRP' ");
query.Append("WHEN substr(DN,1,2)= 'o=' then 'PA' ");
query.Append("else 'PA_UFF' end AS SUBTYPE, ");
query.Append("ID_PADRE AS PADRE ");
query.Append("from IPA ");
if (levels.HasValue)
{
query.Append("where level <=:pLVL ");
}
if (startNode.HasValue)
{
query.Append("start with ID_RUB = :pID ");
}
else
{
query.Append("start with ID_RUB = 1 ");
}
query.Append("connect by NOCYCLE prior ID_RUB = ID_PADRE");
break;
}
using (OracleCommand oCmd = base.CurrentConnection.CreateCommand())
{
oCmd.CommandText = query.ToString();
oCmd.BindByName = true;
if (startNode.HasValue)
{
oCmd.Parameters.Add("pID", startNode.Value);
}
if (levels.HasValue)
{
oCmd.Parameters.Add("pLVL", levels.Value);
}
using (OracleDataReader r = oCmd.ExecuteReader())
if (r.HasRows)
{
list = new Dictionary <string, SimpleTreeItem>();
bool skip = false;
while (r.Read())
{
if (!skip)
{
SimpleTreeItem it = DaoOracleDbHelper.MapToSimpleTreeItem(r);
list.Add(it.ExtendedValue, it);
}
}
}
}
}
//catch (OracleException ex)
//{
// Com.Delta.Logging.Errors.ErrorLogInfo error = new Com.Delta.Logging.Errors.ErrorLogInfo();
// error.freeTextDetails = "Errore nel caricamento dell'albero Data Layer E033 Dettagli Errore: " + ex.Message;
// error.logCode = "ERR_033";
// error.passiveparentcodeobjectID = string.Empty;
// error.passiveobjectGroupID = string.Empty;
// error.passiveobjectID = string.Empty;
// error.passiveapplicationID = string.Empty;
// log.Error(error);
// throw new ManagedException(ex.Message, "E033", "Delta.CdR.INAData.OracleImpl", "LoadTree", "Caricamento dell'albero ", string.Empty, "Eccezione non Gestita", ex);
//}
catch (Exception ex)
{
//TASK: Allineamento log - Ciro
if (!ex.GetType().Equals(typeof(ManagedException)))
{
ManagedException mEx = new ManagedException("Errore nel caricamento dal database dell'albero Data Layer E035 Dettagli Errore: " + ex.Message,
"ERR_035", string.Empty, string.Empty, ex.InnerException);
ErrorLogInfo err = new ErrorLogInfo(mEx);
log.Error(err);
throw mEx;
}
else
{
throw ex;
}
//Com.Delta.Logging.Errors.ErrorLogInfo error = new Com.Delta.Logging.Errors.ErrorLogInfo();
//error.freeTextDetails = "Errore nel caricamento dal database dell'albero Data Layer E034 Dettagli Errore: " + ex.Message;
//error.logCode = "ERR_034";
//error.passiveparentcodeobjectID = string.Empty;
//error.passiveobjectGroupID = string.Empty;
//error.passiveobjectID = string.Empty;
//error.passiveapplicationID = string.Empty;
//log.Error(error);
//throw new ManagedException(ex.Message, "E034", "Delta.CdR.INAData.OracleImpl", "LoadTree", "Caricamento dal database dell'albero Data Layer", string.Empty, "Eccezione non Gestita", ex);
}
return(list);
}
public Dictionary <string, SimpleTreeItem> LoadTree(Int64?startNode, SendMail.Model.IndexedCatalogs catalog, int?levels)
{
Dictionary <string, SimpleTreeItem> list = null;
StringBuilder query = new StringBuilder();
switch (catalog)
{
case IndexedCatalogs.RUBR:
query.Append(" with tree(value, text, subtype, source, padre, level) as ( ");
query.Append(" select ID_REFERRAL AS VALUE, CASE ");
query.Append(" WHEN REFERRAL_TYPE in ('PA', 'AZ_PRI', 'AZ_CP', 'GRP') then RAGIONE_SOCIALE else UFFICIO end as TEXT, ");
query.Append(" REFERRAL_TYPE AS SUBTYPE, 'RUBR' AS SOURCE, ID_PADRE AS PADRE, 1 as level from ");
query.Append(" [FAXPEC].[FAXPEC].[rubr_entita] where REFERRAL_TYPE in ");
query.Append(" ('PA', 'PA_SUB', 'PA_UFF', 'AZ_PRI', 'AZ_CP', 'AZ_UFF', 'GRP') ");
query.Append(" union all ");
query.Append(" select ");
query.Append(" child.ID_REFERRAL AS VALUE, CASE ");
query.Append(" WHEN REFERRAL_TYPE in ('PA','AZ_PRI','AZ_CP','GRP') then child.RAGIONE_SOCIALE else child.UFFICIO end as TEXT, ");
query.Append(" child.REFERRAL_TYPE AS SUBTYPE, 'RUBR' AS SOURCE, child.ID_PADRE AS PADRE, parent.level + 1 from ");
query.Append(" [FAXPEC].[FAXPEC].[rubr_entita] as child join tree parent on parent.value = child.ID_PADRE where REFERRAL_TYPE in ");
query.Append(" ('PA','PA_SUB','PA_UFF','AZ_PRI','AZ_CP','AZ_UFF','GRP')) ");
query.Append(" select * from tree ");
if (levels.HasValue || startNode.HasValue)
{
query.Append(" where ");
}
if (levels.HasValue)
{
query.Append(" level <=" + levels);
query.Append(" and ");
}
if (startNode.HasValue)
{
query.Append(" tree.value >= :pID ");
}
else
{
query.Append(" tree.value >= 0 ");
}
query.Append(" order by tree.level asc");
break;
case IndexedCatalogs.IPA:
query.Append("select ID_RUB AS VALUE, ");
query.Append("'IPA' AS SOURCE, ");
query.Append("CASE WHEN ( substr(DN,1,2)= 'c=' or substr(DN,1,2) = 'o=') then RAGIONESOCIALE ");
query.Append("else UFFICIO end AS TEXT, ");
query.Append("CASE WHEN substr(DN,1,2)= 'c=' then 'GRP' ");
query.Append("WHEN substr(DN,1,2)= 'o=' then 'PA' ");
query.Append("else 'PA_UFF' end AS SUBTYPE, ");
query.Append("ID_PADRE AS PADRE ");
query.Append("from [FAXPEC].[FAXPEC].[IPA] ");
if (levels.HasValue)
{
query.Append("where level <=" + levels.Value);
}
if (startNode.HasValue)
{
query.Append("start with ID_RUB = " + startNode.Value);
}
else
{
query.Append("start with ID_RUB = 1 ");
}
query.Append("connect by NOCYCLE prior ID_RUB = ID_PADRE");
break;
}
using (var dbcontext = new FAXPECContext())
{
using (var oCmd = dbcontext.Database.Connection.CreateCommand())
{
try
{
oCmd.Connection.Open();
oCmd.CommandText = query.ToString();
using (var r = oCmd.ExecuteReader())
{
if (r.HasRows)
{
list = new Dictionary <string, SimpleTreeItem>();
bool skip = false;
while (r.Read())
{
if (!skip)
{
SimpleTreeItem it = DaoSQLServerDBHelper.MapToSimpleTreeItem(r);
list.Add(it.ExtendedValue, it);
}
}
}
}
oCmd.Connection.Close();
}
catch (Exception ex)
{
if (!ex.GetType().Equals(typeof(ManagedException)))
{
ManagedException mEx = new ManagedException("Errore nel caricamento dal database dell'albero Data Layer E035 Dettagli Errore: " + ex.Message,
"ERR_035", string.Empty, string.Empty, ex.InnerException);
ErrorLogInfo err = new ErrorLogInfo(mEx);
log.Error(err);
throw mEx;
}
else
{
throw ex;
}
}
}
}
return(list);
}
