public static string Authorizepin(Card_details cd_details) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CS"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("sp_payment", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter out_pin = new SqlParameter(); out_pin.ParameterName = "@paystatus"; out_pin.SqlDbType = SqlDbType.Int; out_pin.Direction = ParameterDirection.Output; out_pin.Size = 50; cmd.Parameters.Add(out_pin); cmd.Parameters.Add(new SqlParameter("@Bank_Id ", cd_details.Bank_id)); cmd.Parameters.Add(new SqlParameter("@CreditCardNo", cd_details.card_no)); cmd.Parameters.Add(new SqlParameter("@Cardtype", cd_details.card_type)); cmd.Parameters.Add(new SqlParameter("@NameOnCard", cd_details.name_on_card)); cmd.Parameters.Add(new SqlParameter("@ExpiryDate", cd_details.exp_date.ToString())); cmd.Parameters.Add(new SqlParameter("@CVV", cd_details.cvc_no)); cmd.Parameters.Add(new SqlParameter("@AccountNumber", cd_details.account_no)); cmd.Parameters.Add(new SqlParameter("@Pin", cd_details.pin)); string autopin; try { int result = cmd.ExecuteNonQuery(); } catch (Exception) { autopin = "Error"; } if (int.Parse(cmd.Parameters["@paystatus"].Value.ToString()) == 1) { autopin = "Payment Successful"; } else { autopin = "Payment Error "; } con.Close(); return(autopin); }
public static string AuthrizeCard(string bankid, int ccn, string ctype, string name, DateTime date, int cvc, int ano, int pin) { Card_details Cd = new Card_details(); Cd.Bank_id = bankid; Cd.card_no = ccn; Cd.card_type = ctype; Cd.name_on_card = name; Cd.exp_date = date; Cd.cvc_no = cvc; Cd.account_no = ano; Cd.pin = pin; string pay = HRSData.Authorizepin(Cd); return(pay); }