public PreAuthDetails getTransactionDetilsByApprovalCodeAndTerminalID(string approvalCode, string terminalID)
{
PreAuthDetails preauth = GetAppPreAuhtPendingToPreauthByTermainlID(terminalID).Where(o => o.AuthCode == approvalCode).SingleOrDefault();
if (preauth != null)
{
return(preauth);
}
else
{
return(null);
}
}
public List <PreAuthDetails> GetAppPreAuhtPendingToPreauthByTermainlID(string terminalId)
{
List <PreAuthDetails> transactions = new List <PreAuthDetails>();
try
{
using (SqlConnection conn = new SqlConnection(connString))
{
conn.Open();
using (SqlCommand sqlcmd = new SqlCommand("select Tid, Amount, AuthCode, TransDate, TransTime, CardType, EncryptedTrack2,Amount,Pan, AccountType, Aid, SynchronizationData, SwipeIndicator, MerchantID, APIToken from IPGateTransaction where TxnName = 'Preauth' and AvailableForComp = 'Y' and completed ='true' and error = 'false' and TerminalNumber = @TerminalNumber", conn))
{
sqlcmd.Parameters.AddWithValue("@TerminalNumber", CheckForNull(terminalId));
using (SqlDataReader dr = sqlcmd.ExecuteReader())
{
while (dr.Read())
{
PreAuthDetails preTransaction = new PreAuthDetails();
preTransaction.Tid = dr["TID"].ToString();
preTransaction.OriginalPreAuthAmount = dr["Amount"].ToString();
preTransaction.AuthCode = dr["AuthCode"].ToString();
preTransaction.CardType = dr["CardType"].ToString();
preTransaction.encryptedTrack2 = dr["EncryptedTrack2"].ToString();
preTransaction.OriginalPreAuthAmount = dr["Amount"].ToString();
preTransaction.PAN = dr["Pan"].ToString();
preTransaction.AccoutnType = dr["AccountType"].ToString();
preTransaction.Aid = dr["Aid"].ToString();
preTransaction.SynchronizationData = dr["SynchronizationData"].ToString();
preTransaction.SwipeIndicator = dr["SwipeIndicator"].ToString();
preTransaction.TransactionDate = dr["TransDate"].ToString();
preTransaction.TransactionTime = dr["TransTime"].ToString();
preTransaction.APIToken = dr["APIToken"].ToString();
preTransaction.MerchantId = dr["MerchantID"].ToString();
transactions.Add(preTransaction);
}
}
}
}
return(transactions.OrderBy(o => o.Tid).ToList());
}
catch
{
return(null);
}
}
