} // getClientAcctSchema // by amit 23-12-2015 public static MAcctSchema[] GetClientAcctSchemas(Ctx ctx, int AD_Client_ID, Trx trxName) { // Check Cache int key = AD_Client_ID; if (_schema.ContainsKey(key)) { return((MAcctSchema[])_schema[key]); } // Create New List <MAcctSchema> list = new List <MAcctSchema>(); MClientInfo info = MClientInfo.Get(ctx, AD_Client_ID, trxName); MAcctSchema ass = MAcctSchema.Get(ctx, info.GetC_AcctSchema1_ID(), trxName); if (ass.Get_ID() != 0 && trxName == null) { list.Add(ass); } // Other String sql = "SELECT C_AcctSchema_ID FROM C_AcctSchema acs " + "WHERE IsActive='Y'"; if (AD_Client_ID != 0) { sql += " AND AD_Client_ID=" + AD_Client_ID; } sql += " ORDER BY C_AcctSchema_ID"; IDataReader dr = null; try { dr = DataBase.DB.ExecuteReader(sql, null, trxName); while (dr.Read()) { int id = Utility.Util.GetValueOfInt(dr[0].ToString()); if (id != info.GetC_AcctSchema1_ID()) // already in list { ass = MAcctSchema.Get(ctx, id, trxName); if (ass.Get_ID() != 0 && trxName == null) { list.Add(ass); } } } dr.Close(); dr = null; } catch (System.Data.Common.DbException e) { if (dr != null) { dr.Close(); } _log.Log(Level.SEVERE, sql, e); } finally { if (dr != null) { dr.Close(); dr = null; } } // Save MAcctSchema[] retValue = new MAcctSchema[list.Count]; retValue = list.ToArray(); if (trxName == null) { _schema.Add(key, retValue); } return(retValue); } // getClientAcctSchema