public string UpdateCardData(PropAssociateRegistration objAssociateRegistration, int cardID) { WcrCryptography cardEncrypt = new WcrCryptography(); SqlCommand cmd = new SqlCommand("proc_UpdateCardInfo", objCon.Con); cmd.CommandType = CommandType.StoredProcedure; objCon.Con.Open(); try { cmd.Parameters.AddWithValue("@CardDataId", cardID); cmd.Parameters.AddWithValue("@associateID", objAssociateRegistration.AssociateID); cmd.Parameters.AddWithValue("@CardNumber", cardEncrypt.WcrEncryptCardNumber(objAssociateRegistration.CardNumber)); cmd.Parameters.AddWithValue("@CardNumberNew", cardEncrypt.WcrEncryptCardNumber(objAssociateRegistration.CardNumber)); cmd.Parameters.AddWithValue("@Cardholder_FirstName", cardEncrypt.WcrEncrypt(objAssociateRegistration.Cardholder_FirstName)); cmd.Parameters.AddWithValue("@Cardholder_LastName", cardEncrypt.WcrEncrypt(objAssociateRegistration.Cardholder_LastName)); cmd.Parameters.AddWithValue("@Cardholder_Address", cardEncrypt.WcrEncrypt(objAssociateRegistration.Cardholder_Address)); cmd.Parameters.AddWithValue("@Cardholder_Country", cardEncrypt.WcrEncrypt(objAssociateRegistration.Cardholder_Country)); cmd.Parameters.AddWithValue("@Cardholder_State", cardEncrypt.WcrEncrypt(objAssociateRegistration.Cardholder_State)); cmd.Parameters.AddWithValue("@Cardholder_City", cardEncrypt.WcrEncrypt(objAssociateRegistration.Cardholder_City)); cmd.Parameters.AddWithValue("@Cardholder_Zip", cardEncrypt.WcrEncrypt(objAssociateRegistration.Cardholder_Zip)); cmd.Parameters.AddWithValue("@CVV", cardEncrypt.WcrEncrypt(objAssociateRegistration.CVV)); cmd.Parameters.AddWithValue("@ExpMonth", cardEncrypt.WcrEncrypt(objAssociateRegistration.ExpMonth)); cmd.Parameters.AddWithValue("@ExpYear", cardEncrypt.WcrEncrypt(objAssociateRegistration.ExpYear)); cmd.Parameters.AddWithValue("@CardType", cardEncrypt.WcrEncrypt(objAssociateRegistration.CardType)); int a = Convert.ToInt16(cmd.ExecuteScalar()); objCon.Con.Close(); if (a > 0) { return(ClsCommon.InactiveValue.ToString()); } else { return(a.ToString()); } } catch (Exception showError) { throw showError; } finally { cmd.Dispose(); objCon.Con.Close(); objCon.Con.Dispose(); } }