protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserId"] != null)
{
string query = "select R.FullName,R.UserId,R.ContactNumber,R.Email,P.PaymentId,P.Amount,P.CreditCardNo,P.NameOnCard,P.OrderId,O.OrderNumber," +
" Case When P.PaymentTypeId = 1 then 'Credit Card' else 'Debit Card' end PaymentType, P.PaymentNumber ,O.OrderDate," +
" CASE when P.Status = 1 Then 'Success' else 'Failed' end Status, convert(varchar(20), P.PaymentDate, 106) PaymentDate" +
" from tbl_PaymentDetails P Join tbl_Login R ON R.UserId = P.UserId Join tbl_Order O ON O.OrderId=P.OrderId";
DataSet ds = new DataSet();
ds = obj.PaymentReport(query);
gvPaymentReport.DataSource = ds.Tables[0];
gvPaymentReport.DataBind();
}
else
{
Response.Redirect("Login.aspx");
}
}
