internal List <RubricaEntitaType> GetEntitaByPartitaIVA(string partitaIVA)
{
List <RubricaEntitaType> l = new List <RubricaEntitaType>();
try
{
using (OracleCommand oCmd = base.CurrentConnection.CreateCommand())
{
string cmdT = "SELECT VALUE(V0)"
+ " FROM V_RUBR_ENTITA_OBJ V0"
+ " WHERE P_IVA = '{0}' AND REFERRAL_TYPE IN ('AZ_PS', 'PG', 'AZ_PRI')"
+ " OR ID_REFERRAL IN ("
+ "SELECT REF_ORG"
+ " FROM V_RUBR_ENTITA_OBJ"
+ " WHERE P_IVA = '{0}' AND REFERRAL_TYPE IN ('AZ_PS', 'PG', 'AZ_PRI')"
+ " AND REF_ORG IS NOT NULL)";
oCmd.CommandText = String.Format(cmdT, partitaIVA);
using (OracleDataReader r = oCmd.ExecuteReader())
{
while (r.Read())
{
RubricaEntitaType ret = (RubricaEntitaType)(r.GetOracleValue(0));
ret.SetContatti(base.CurrentConnection);
l.Add(ret);
}
}
}
}
catch
{
throw;
}
return(l);
}
internal RubricaEntitaType GetEntitaByIdReferral(Int64 idReferral)
{
RubricaEntitaType ret = null;
try
{
using (OracleCommand oCmd = base.CurrentConnection.CreateCommand())
{
oCmd.CommandText =
String.Format("SELECT VALUE(V0) FROM V_RUBR_ENTITA_OBJ V0 WHERE ID_REFERRAL = {0}", idReferral);
using (OracleDataReader r = oCmd.ExecuteReader())
{
while (r.Read())
{
ret = (RubricaEntitaType)(r.GetOracleValue(0));
ret.SetContatti(base.CurrentConnection);
}
}
}
}
catch
{
throw;
}
return(ret);
}
internal IList <RubricaEntitaType> GetContattiOrgByName(string nomeEntita)
{
List <RubricaEntitaType> listEntities = null;
using (OracleCommand oCmd = base.CurrentConnection.CreateCommand())
{
oCmd.CommandText = "SELECT VALUE(v0)"
+ " FROM v_rubr_entita_obj v0"
+ " WHERE :p_id_org IN (upper(v0.ragione_sociale), upper(v0.ufficio))";
oCmd.Parameters.Add("p_id_org", nomeEntita.ToUpper());
try
{
using (OracleDataReader r = oCmd.ExecuteReader())
{
if (r.HasRows)
{
listEntities = new List <RubricaEntitaType>();
while (r.Read())
{
RubricaEntitaType ent = (RubricaEntitaType)(r.GetOracleValue(0));
if (!ent.RUBR_CONTATTI_REFS.IsNull)
{
ent.Contatti = new List <RubricaContatti>();
foreach (string o in ent.RUBR_CONTATTI_REFS.ListContattiRef)
{
OracleRef or = new OracleRef(base.CurrentConnection, o);
RubricaContattiType rc = (RubricaContattiType)or.GetCustomObject(OracleUdtFetchOption.Server);
rc.SetEntita(ent);
ent.Contatti.Add(rc);
}
}
listEntities.Add(ent);
}
}
}
}
catch
{
listEntities = null;
}
}
return(listEntities);
}
internal IList <RubricaEntitaType> GetContattiByIdOrg(Int64 idOrg)
{
List <RubricaEntitaType> listEntities = null;
using (OracleCommand oCmd = base.CurrentConnection.CreateCommand())
{
oCmd.CommandText = "SELECT VALUE(v0)"
+ " FROM v_rubr_entita_obj v0"
+ " WHERE :p_id_org IN (v0.id_referral, v0.ref_org)";
oCmd.Parameters.Add("p_id_org", idOrg);
try
{
using (OracleDataReader r = oCmd.ExecuteReader())
{
if (r.HasRows)
{
listEntities = new List <RubricaEntitaType>();
while (r.Read())
{
RubricaEntitaType ent = (RubricaEntitaType)(r.GetOracleValue(0));
//if (!ent.oRUBR_CONTATTI_REFS.IsNull)
//{
// ent.Contatti = new List<RubricaContatti>();
// foreach (OracleRef or in ent.oRUBR_CONTATTI_REFS.ListContatti)
// {
// RubricaContattiType rc = (RubricaContattiType)or.GetCustomObject(OracleUdtFetchOption.Server);
// rc.SetEntita(ent);
// ent.Contatti.Add(rc);
// }
//}
listEntities.Add(ent);
}
}
}
}
catch
{
listEntities = null;
}
}
return(listEntities);
}
