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