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); }