/// <summary>
/// Generates a Query string that should pull all the ledger items for a specific Guarantor.
///
/// If Guarantor = 0 then it will pull for all Guarantors which is a lot of data.
/// So check for this condition.
///
/// <b>Note</b>: IsPulledFlag is currently depreciated 01-12-2008
/// </summary>
/// <param name="IsPulledFlag">indicates whether you want to pull items with the IsPulled status or not</param>
/// <returns></returns>
public static string PullAll_FromOD(long Guarantor,bool IsPulledFlag)
{
string rVal = "";
L1_NegativeAdjustments L1 = new L1_NegativeAdjustments();
L2_PositiveAdjustments L2 = new L2_PositiveAdjustments();
L3_ClaimWriteOffAdjustments L3 = new L3_ClaimWriteOffAdjustments();
// L4_PaymentsFromPaySplit L4 = new L4_PaymentsFromPaySplit();
// replaced with L4b_
L4b_PaymentsFromPayment L4b = new L4b_PaymentsFromPayment();
L5_PaymentsFromInsurance L5 = new L5_PaymentsFromInsurance();
L6_Charges L6 = new L6_Charges();
PP_ODSQLPullStrings_LedgerItem [] LArray = { L1, L2, L3, L4b, L5, L6 };
for (int i = 0; i < LArray.Length; i++)
{
rVal += LArray[i].ODPullString(Guarantor, IsPulledFlag);
if (i != LArray.Length - 1)
rVal += "\n UNION ALL\n";
}
return rVal;
}
/// <summary>
/// Generates a Query string that should pull all the ledger items for a specific Guarantor.
///
/// If Guarantor = 0 then it will pull for all Guarantors which is a lot of data.
/// So check for this condition.
///
/// <b>Note</b>: IsPulledFlag is currently depreciated 01-12-2008
/// </summary>
/// <param name="IsPulledFlag">indicates whether you want to pull items with the IsPulled status or not</param>
/// <returns></returns>
public static string PullAll_FromOD(long Guarantor, bool IsPulledFlag)
{
string rVal = "";
L1_NegativeAdjustments L1 = new L1_NegativeAdjustments();
L2_PositiveAdjustments L2 = new L2_PositiveAdjustments();
L3_ClaimWriteOffAdjustments L3 = new L3_ClaimWriteOffAdjustments();
// L4_PaymentsFromPaySplit L4 = new L4_PaymentsFromPaySplit();
// replaced with L4b_
L4b_PaymentsFromPayment L4b = new L4b_PaymentsFromPayment();
L5_PaymentsFromInsurance L5 = new L5_PaymentsFromInsurance();
L6_Charges L6 = new L6_Charges();
PP_ODSQLPullStrings_LedgerItem [] LArray = { L1, L2, L3, L4b, L5, L6 };
for (int i = 0; i < LArray.Length; i++)
{
rVal += LArray[i].ODPullString(Guarantor, IsPulledFlag);
if (i != LArray.Length - 1)
{
rVal += "\n UNION ALL\n";
}
}
return(rVal);
}