CODING FOR WEB SERVICES FOR PAYMENT


CODING FOR WEB SERVICES FOR PAYMENT

using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
...
/// <summary>
/// Summary description for PaymentService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class PaymentService : System.Web.Services.WebService {
SqlConnection con;
public PaymentService () {

//Uncomment the following line if using designed components
//InitializeComponent();
}

[WebMethod]
public bool checkcard(int cno, int pno)
{
con=new SqlConnection(@"Data Source=.\SQLEXPRESS;User Instance=true;AttachDbFilename=C:\Users\radiant\Documents\Visual Studio 2010\WebSites\WebSite4\App_Data\DB.mdf;Integrated Security=SSPI");
con.Open();
string qry = "select * from cardpay where cardno=" + cno+"and pinno="+pno;
SqlDataAdapter da = new SqlDataAdapter(qry, con);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 0)
return false;
else
return true;

}

}