public override List <ICardDetails> Select()
{
Source = "sp_FetchCardDetails ";
try
{
Object[] param =
{
new MySqlParameter("@paramToken", UserProfileObj.GetToken())
};
DataSet Output = Commands.ExecuteQuery(Source, CommandType.StoredProcedure, param);
List <ICardDetails> CardDetail = new List <ICardDetails>();
foreach (DataRow dr in Output.Tables[0].Rows)
{
ICardDetails CardObj = new CardDetails();
CardObj.SetCardID(Int32.Parse(dr["caID"].ToString()));
CardObj.SetName(dr["CardNameEncrypt"].ToString());
CardObj.SetCardNumber(dr["CardNumberEncrypt"].ToString());
CardObj.SetExpiryMonth(dr["ExpiryMonthEncrypt"].ToString());
CardObj.SetExpiryYear((dr["ExpiryYearEncrypt"].ToString()));
CardObj.SetCvv((dr["CvvEncrypt"].ToString()));
CardObj.SetIV(dr["Salt"].ToString());
CardObj.SetDecryptionKey(dr["DecryptionKey"].ToString());
CardDetail.Add(CardObj);
}
return(CardDetail);
}
catch (Exception ex)
{
Logger.Instance().Log(Fatal.Instance(), ex);
throw ex;
}
}