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