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