/// <summary> /// Get Active /// </summary> /// <param name="ctx"></param> /// <returns>active processors</returns> public static MAcctProcessor[] GetActive(Ctx ctx) { List <MAcctProcessor> list = new List <MAcctProcessor>(); String sql = "SELECT * FROM C_AcctProcessor WHERE IsActive='Y'"; IDataReader idr = null; try { idr = DataBase.DB.ExecuteReader(sql, null, null); while (idr.Read()) { list.Add(new MAcctProcessor(ctx, idr, null)); } idr.Close(); } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, "GetActive", e); } MAcctProcessor[] retValue = new MAcctProcessor[list.Count]; retValue = list.ToArray(); return(retValue); }
/// <summary> /// Parent Constructor /// </summary> /// <param name="parent"></param> /// <param name="summary"></param> public MAcctProcessorLog(MAcctProcessor parent, String summary) : this(parent.GetCtx(), 0, parent.Get_TrxName()) { SetClientOrg(parent); SetC_AcctProcessor_ID(parent.GetC_AcctProcessor_ID()); SetSummary(summary); }
/// <summary> /// Get Active /// </summary> /// <param name="ctx"></param> /// <returns>active processors</returns> public static MAcctProcessor[] GetActive(Ctx ctx) { List <MAcctProcessor> list = new List <MAcctProcessor>(); String sql = "SELECT * FROM C_AcctProcessor WHERE IsActive='Y'"; IDataReader idr = null; //Changed By Karan..... //DataSet pstmt = null; string scheduleIP = null; try { string machineIP = System.Net.Dns.GetHostEntry(Environment.MachineName).AddressList[0].ToString(); idr = DataBase.DB.ExecuteReader(sql, null, null); while (idr.Read()) { scheduleIP = Util.GetValueOfString(DB.ExecuteScalar(@"SELECT RunOnlyOnIP FROM AD_Schedule WHERE AD_Schedule_ID = (SELECT AD_Schedule_ID FROM C_AcctProcessor WHERE C_AcctProcessor_ID =" + idr["C_AcctProcessor_ID"] + " )")); //list.Add(new MAcctProcessor(ctx, idr, null)); if (string.IsNullOrEmpty(scheduleIP) || machineIP.Contains(scheduleIP)) { list.Add(new MAcctProcessor(new Ctx(), idr, null)); } } idr.Close(); } catch (Exception e) { if (idr != null) { idr.Close(); } _log.Log(Level.SEVERE, "GetActive", e); } MAcctProcessor[] retValue = new MAcctProcessor[list.Count]; retValue = list.ToArray(); return(retValue); }