/// <summary>
/// Parent Constructor
/// </summary>
/// <param name="parent"></param>
/// <param name="summary"></param>
public MRequestProcessorLog(MRequestProcessor parent, String summary)
: this(parent.GetCtx(), 0, parent.Get_TrxName())
{
SetClientOrg(parent);
SetR_RequestProcessor_ID(parent.GetR_RequestProcessor_ID());
SetSummary(summary);
}
/// <summary>
/// Get Active Request Processors
/// </summary>
/// <param name="ctx">context</param>
/// <returns>array of Request </returns>
public static MRequestProcessor[] GetActive(Ctx ctx)
{
List <MRequestProcessor> list = new List <MRequestProcessor>();
String sql = "SELECT * FROM R_RequestProcessor WHERE IsActive='Y'";
IDataReader idr = null;
try
{
idr = DataBase.DB.ExecuteReader(sql, null, null);
while (idr.Read())
{
list.Add(new MRequestProcessor(ctx, idr, null));
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
idr = null;
}
_log.Log(Level.SEVERE, sql, e);
}
MRequestProcessor[] retValue = new MRequestProcessor[list.Count];
retValue = list.ToArray();
return(retValue);
}
/// <summary>
/// Get Active Request Processors
/// </summary>
/// <param name="ctx">context</param>
/// <returns>array of Request </returns>
public static MRequestProcessor[] GetActive(Ctx ctx)
{
List <MRequestProcessor> list = new List <MRequestProcessor>();
String sql = "SELECT * FROM R_RequestProcessor WHERE IsActive='Y'";
IDataReader idr = null;
//Changed By Karan.....
string scheduleIP = null;
try
{
//idr = DataBase.DB.ExecuteReader(sql, null, null);
//while (idr.Read())
//{
// list.Add(new MRequestProcessor(ctx, idr, null));
//}
//idr.Close();
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 R_RequestProcessor WHERE R_RequestProcessor_ID =" + idr["R_RequestProcessor_ID"] + " )"));
//list.Add(new MAcctProcessor(ctx, idr, null));
if (string.IsNullOrEmpty(scheduleIP) || machineIP.Contains(scheduleIP))
{
list.Add(new MRequestProcessor(new Ctx(), idr, null));
}
}
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
idr = null;
}
_log.Log(Level.SEVERE, sql, e);
}
MRequestProcessor[] retValue = new MRequestProcessor[list.Count];
retValue = list.ToArray();
return(retValue);
}
