private void SendPaymentNotifications(DataContext context, int batchId, string fromEmail)
{
var q = (from req in context.tblRequisitions.Include(a => a.Supplier)
where req.RequisitionBatchId == batchId &&
req.NotifySupplierByEmail == true
select new
{
NotifyEmailAddress = req.NotifyEmailAddress,
Payreference = req.payreference,
ContactPerson = req.SupplierId == null ? "" : req.Supplier.ContactPerson,
Amount = req.amount
});
foreach (var itm in q.Distinct().ToList())
{
if (!String.IsNullOrWhiteSpace(itm.NotifyEmailAddress))
{
EmailProvider.RequisitionBatchSendPaymentNotifications(fromEmail, itm.NotifyEmailAddress, itm.ContactPerson, itm.Amount, itm.Payreference);
}
}
}