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