public static List <PaymentTypeData> Get(List <long> transaction_ids)
{
var payment_types = PaymentType.GetCached_Dict();
var param = new DynamicParameters();
param.Add("@transaction_ids", transaction_ids);
var query = @"
SELECT
PT.transaction_payment_type_id,
PT.transaction_id,
PT.payment_type_id,
PT.payment_type_index,
PT.added_after_save,
CPT.added_on,
CPT.added_by
FROM ClayFinancial.dbo.data_payment_type PT
INNER JOIN payment_types P ON P.payment_type_id = PT.payment_type_id
LEFT OUTER JOIN ClayFinancial.dbo.data_changes_payment_type CPT
ON CPT.transaction_payment_type_id = PT.transaction_payment_type_id
WHERE
transaction_id in @transaction_ids
ORDER BY P.name, PT.payment_type_index;
";
var data_payment_types = Constants.Get_Data <PaymentTypeData>(query, param, Constants.ConnectionString.ClayFinancial);
return(data_payment_types);
}
public static List <PaymentTypeData> Get(long transaction_id, List <ControlData> controls, List <PaymentMethodData> payment_methods)
{
var payment_types = PaymentType.GetCached_Dict();
var param = new DynamicParameters();
param.Add("@transaction_id", transaction_id);
var query = @"
SELECT
PT.transaction_payment_type_id,
PT.transaction_id,
PT.payment_type_id,
PT.payment_type_index,
PT.added_after_save,
CPT.added_on,
CPT.added_by
FROM ClayFinancial.dbo.data_payment_type PT
INNER JOIN payment_types P ON P.payment_type_id = PT.payment_type_id
LEFT OUTER JOIN ClayFinancial.dbo.data_changes_payment_type CPT
ON CPT.transaction_payment_type_id = PT.transaction_payment_type_id
WHERE
transaction_id = @transaction_id
ORDER BY P.name, PT.payment_type_index;
";
var data_payment_types = Constants.Get_Data <PaymentTypeData>(query, param, Constants.ConnectionString.ClayFinancial);
foreach (var ptd in data_payment_types)
{
if (payment_types.ContainsKey(ptd.payment_type_id))
{
ptd.payment_type = payment_types[ptd.payment_type_id];
}
else
{
new ErrorLog("Missing Payment Type Id - " + ptd.payment_type_id.ToString(), "PaymentTypeData.Get()", "", "", "");
}
ptd.control_data = (from c in controls
where c.transaction_payment_type_id.HasValue &&
c.transaction_payment_type_id.Value == ptd.transaction_payment_type_id
select c).ToList();
ptd.payment_method_data = (from p in payment_methods
where p.transaction_payment_type_id == ptd.transaction_payment_type_id
select p).ToList();
}
return(data_payment_types);
}
