/*
* updated by Shahbaz Akhtar on 27-12-2016 for view and grid */
public DirectPayment GetDirectPaymentRecord(int recordID, string UserID)
{
string proc = string.Empty;
try
{
DirectPayment dp = new DirectPayment();
SqlParameter[] Parameters = { new SqlParameter("@SNo", Convert.ToInt32(recordID)),
new SqlParameter("@UserID", Convert.ToInt32(UserID)) };
if (System.Web.HttpContext.Current.Request.QueryString.ToString().Split('=')[4] == "O")
{
proc = "GetRecordDirectPayment_Office";
}
else
{
proc = "GetRecordDirectPayment";
}
SqlDataReader dr = SqlHelper.ExecuteReader(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, proc, Parameters);
if (dr.Read())
// SqlDataReader dr = SqlHelper.ExecuteReader(ReadConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordDirectPayment", Parameters);
// if (dr.Read())
{
dp.SNo = Convert.ToString(dr["SNo"]);
dp.AccountSNo = Convert.ToInt32(dr["SNo"]);
dp.RefNo = dr["RefNo"].ToString();
dp.Office = dr["Office"].ToString().ToUpper();
dp.Agent = dr["Agent"].ToString().ToUpper();
dp.Amount = Convert.ToString(dr["Amount"]);
dp.Credit = Convert.ToString(dr["Credit"]);
dp.UpdateTypeText = dr["UpdateType"].ToString();
dp.Transaction = dr["Transaction"].ToString();
dp.CreatedUser = dr["CreatedUser"].ToString();
dp.UpdatedUser = dr["UpdatedUser"].ToString();
dp.AccountSNo = Convert.ToInt32(dr["AccountSNo"]);
dp.CitySNo = Convert.ToInt32(dr["CitySNo"]);
dp.AirlineSNo = Convert.ToInt32(dr["AirlineSno"]);
dp.OfficeSNo = Convert.ToInt32(dr["officeSno"]);
dp.CurrencySNo = Convert.ToInt32(dr["CurrencySNo"]);
dp.AirlineSNo = Convert.ToInt32(dr["Airlinesno"]);
dp.Text_AirlineSNo = dr["Airline"].ToString();
dp.Text_Agent = dr["Agent"].ToString();
dp.Text_City = dr["City"].ToString();
dp.Text_CurrencySNo = dr["Currency"].ToString();
dp.Text_Office = dr["Office"].ToString();
dp.PaymentBy = dr["Office"].ToString() == "0" || dr["Office"].ToString() == "" ? 1 : 0;
dp.TransactionType = dr["TransactionType"].ToString();
dp.CreditLimit = dr["CreditLimit"].ToString();
dp.ExistingCreditLimit = Convert.ToString(dr["ExistingCreditLimit"]);
dp.PaymentDate = Convert.ToString(dr["PaymentDate"]);
dp.PaymentDateCal = string.IsNullOrEmpty(dr["PaymentDate"].ToString()) == true ? (DateTime?)null : Convert.ToDateTime(dr["PaymentDate"].ToString());
dp.Remarks = Convert.ToString(dr["Remarks"]);
dp.TotalNtaAmount = Convert.ToString(dr["TotalNtaAmount"]);
dp.TransectionModeSNo = Convert.ToInt32(dr["TransectionModeSNo"]);
dp.Text_TransectionModeSNo = Convert.ToString(dr["Text_TransectionModeSNo"]);
dp.Text_UpdateType = Convert.ToString(dr["Text_UpdateType"]);
dp.BankAccountNo = Convert.ToString(dr["BankAccountNo"]);
dp.BankName = Convert.ToString(dr["BankName"]);
dp.BranchName = Convert.ToString(dr["BranchName"]);
dp.ChequeAccountName = Convert.ToString(dr["ChequeAccountName"]);
dp.ChequeDate = string.IsNullOrEmpty(dr["ChequeDate"].ToString()) == true ? (DateTime?)null : Convert.ToDateTime(dr["ChequeDate"].ToString());
dp.ValidFrom = string.IsNullOrEmpty(dr["ValidFrom"].ToString()) == true ? (DateTime?)null : Convert.ToDateTime(dr["ValidFrom"].ToString());
dp.ValidTo = string.IsNullOrEmpty(dr["ValidTo"].ToString()) == true ? (DateTime?)null : Convert.ToDateTime(dr["ValidTo"].ToString());
dp.ReferenceNo = Convert.ToString(dr["ReferenceNo"]);
dp.Text_AWBSNo = dr["AwbNumber"].ToString();
dp.ChequeNo = Convert.ToString(dr["ChequeNo"]);
dp.Description = Convert.ToString(dr["Description"]).ToUpper();
}
dr.Close();
return(dp);
}
catch (Exception ex)// (Exception ex)
{
throw ex;
}
}
static void Main(string[] args)
{
//Create voguepay merchant instance
Merchant merchantinfo = new Merchant();
merchantinfo.MerchantID = "6359-0000000";
merchantinfo.Username = "******";
merchantinfo.Email = "*****@*****.**";
merchantinfo.CommandAPIToken = "ZnHzcbxKVbvF5d3J5JvZqZe587Rna";
merchantinfo.PublicKeyFile = @"C:\Users\Rock\public.txt"; //URL path to saved public key
//Create voguepay instance (Parameters "live" or "demo", default is demo)
Voguepay voguepay = new Voguepay("live");
voguepay.Init(merchantinfo);
//Create customer instance
Customerinfo customer = new Customerinfo();
customer.Name = "Sam Great";
customer.Phone = "20339922";
customer.Email = "*****@*****.**";
customer.City = "Allen";
customer.Country = "NGA";
customer.State = "Ikeja";
customer.ZipCode = "23401";
customer.Address = "3 Drive view estate";
DirectPayment directpayment = new DirectPayment();
directpayment.version = 2;
directpayment.Amount = 100.22;
directpayment.Currency = "USD";
directpayment.Reference = "MY_UNIQUE_REF";
directpayment.Memo = "Sample payment";
directpayment.RedirectURL = "https://sample.com/redirect";
directpayment.ReferralURL = "https://sample.com/referral";
directpayment.ResponseURL = "https://sample.com/notify/";
directpayment.StoreID = "5a33c3933ca"; //optional
directpayment.CardName = "Steve";
directpayment.CardPan = "5389830123937029";
directpayment.CardExpiryMonth = 5;
directpayment.CardExpiryYear = 21;
directpayment.CardCVV = 170;
directpayment.ServerPublicIP = "192.333.44.33";
directpayment.ServerWebsiteURL = "www.google.com";
directpayment.CustomerReferringIP = "10.22.333.33";
directpayment.CustomerReferringWebsite = "www.shades.com";
directpayment.DescriptorCompanyName = "Sparks";
directpayment.DescriptorCountryAddress = "Sparks Street";
directpayment.DescriptorCityAddress = "Califonia";
directpayment.DescriptorCountryAddress = "USA"; //country or 3 letter ISO
// directpayment.CardToken = "5a344439203";
// directpayment.CardTokenize =true;
string jsonResult = voguepay.Pay(directpayment, customer);
Console.WriteLine(jsonResult);
Console.ReadKey();
}
