public PaymentGatewayTransactionReport PaymentGatewayTransactionDetail(string TxnId) { var dynamicReport = new PaymentGatewayTransactionReport(); string sql = "sproc_pmt_gatewayTxn_report @flag = 's'"; sql += ", @pmtGatewayTxnId =" + DAO.FilterString(TxnId); var dr = DAO.ExecuteDataRow(sql); if (dr != null) { dynamicReport.TxnId = dr["TxnId"].ToString(); dynamicReport.Amount = dr["Amount"].ToString(); dynamicReport.ServiceCharge = dr["ServiceCharge"].ToString(); dynamicReport.TotalAmount = dr["TotalAmount"].ToString(); dynamicReport.Status = dr["status"].ToString(); dynamicReport.GatewayName = dr["GatewayName"].ToString(); dynamicReport.GatewayTxnId = dr["GatewayTxnId"].ToString(); dynamicReport.AgentId = dr["AgentId"].ToString(); dynamicReport.UserId = dr["UserId"].ToString(); dynamicReport.TxnType = dr["TxnType"].ToString(); dynamicReport.AgentName = dr["AgentName"].ToString(); dynamicReport.CreatedDate = dr["createdDate"].ToString(); } return(dynamicReport); }
public ActionResult PaymentGatewayTransactionDetail(string txnid) { string TxnId = txnid.DecryptParameter(); PaymentGatewayTransactionReport model = _dynamicReport.PaymentGatewayTransactionDetail(TxnId); return(View(model)); }
public List <PaymentGatewayTransactionReport> PaymentGatewayTransactionList(DynamicReportFilter filter) { var model = new List <PaymentGatewayTransactionReport>(); string sql = "sproc_pmt_gatewayTxn_report @flag = 's'"; sql += ", @fromdate =" + DAO.FilterString(filter.FromDate); sql += ", @todate =" + DAO.FilterString(filter.ToDate); sql += ", @userMobileNo =" + DAO.FilterString(filter.MobileNumber); sql += ", @pmtGatewayId =" + DAO.FilterString(filter.GatewayId); sql += ", @pmtGatewayTxnId =" + DAO.FilterString(filter.PgTxnId); sql += ", @pmtTxnId =" + DAO.FilterString(filter.TxnId); var dbres = DAO.ExecuteDataTable(sql); if (dbres != null) { foreach (DataRow dr in dbres.Rows) { PaymentGatewayTransactionReport dynamicReport = new PaymentGatewayTransactionReport(); dynamicReport.TxnId = dr["TxnId"].ToString(); dynamicReport.Amount = dr["Amount"].ToString(); dynamicReport.ServiceCharge = dr["ServiceCharge"].ToString(); dynamicReport.TotalAmount = dr["TotalAmount"].ToString(); dynamicReport.Status = dr["status"].ToString(); dynamicReport.GatewayName = dr["GatewayName"].ToString(); dynamicReport.GatewayTxnId = dr["GatewayTxnId"].ToString(); dynamicReport.AgentId = dr["AgentId"].ToString(); dynamicReport.UserId = dr["UserId"].ToString(); dynamicReport.TxnType = dr["TxnType"].ToString(); dynamicReport.AgentName = dr["AgentName"].ToString(); dynamicReport.CreatedDate = dr["createdDate"].ToString(); model.Add(dynamicReport); } } return(model); }