public static List <Dividend_Payment> GetPayments_FX(int fxInput_id)
{
List <Dividend_Payment> list = new List <Dividend_Payment>();
DB_select db_sel = new DB_select(Dividend_Payment.Get_cmdTP());
SQL_relation rela = new SQL_relation("FX_InputID", RelationalOperator.Equals, fxInput_id);
db_sel.SetCondition(rela);
DB_reader reader = new DB_reader(db_sel, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Dividend_Payment dp = new Dividend_Payment();
dp.Init_from_reader(reader);
list.Add(dp);
}
reader.Close();
return(list);
}
/// <summary>
/// Get a list of Dividend_Payment
/// </summary>
/// <param name="option">0 for unlocked and 1 for locked, other values for all records</param>
public static List <Dividend_Payment> GetAll_payment_list(int option)
{
List <Dividend_Payment> list = new List <Dividend_Payment>();
DB_select db_sel = new DB_select(Dividend_Payment.Get_cmdTP());
if (option == 0 || option == 1)
{
SQL_relation rela = new SQL_relation("Paid_And_Locked", RelationalOperator.Equals, option);
db_sel.SetCondition(rela);
}
DB_reader reader = new DB_reader(db_sel, Utility.Get_DRWIN_hDB());
while (reader.Read())
{
Dividend_Payment dp = new Dividend_Payment();
dp.Init_from_reader(reader);
list.Add(dp);
}
reader.Close();
return(list);
}
