order confirmation e-mail not working. check list

  Send order confirmation e-mail : always send order conf.

1. Check db > PaymentTransactionInfos table > ConfirmationEmailSent set to true :

2. If true : hosting issue

If false sana issue . Check db have any multiple data for same order  

 protected virtual bool ShouldSendConfirmationEmail(IPaymentTransactionInfo transaction)
{
var checkoutProcess = transaction.CheckoutProcessName;
if (checkoutProcess == CheckoutProcesses.EditOrder || checkoutProcess == CheckoutProcesses.EditQuote)
return true;

if (transaction.ConfirmationEmailSent)
return false;

var transactions = CommerceFrameworkBase.PaymentData.GetPaymentTransactionsInfo(transaction.OrderId, transaction.WebsiteId);

return !transactions.Any(t => t.ConfirmationEmailSent);
}