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; } }