public ActionResult PaymentGatewayTransactionReport(DynamicReportFilter model)
{
List <PaymentGatewayTransactionReport> paymentGatewayTransactionList = _dynamicReport.PaymentGatewayTransactionList(model);
//List<DynamicReportModel> reportModel = dynamicReportCommons.MapObjects<DynamicReportModel>();
foreach (var item in paymentGatewayTransactionList)
{
item.Action = StaticData.GetActions("paymentGatewayTransaction", item.GatewayTxnId.EncryptParameter(), this);
}
IDictionary <string, string> param = new Dictionary <string, string>();
param.Add("TxnId", "Txn Id");
//param.Add("ServiceCharge", "Service Charge");
param.Add("GatewayName", "Gateway Name");
param.Add("GatewayTxnId", "Gateway Txn Id");
param.Add("AgentName", "Agent Name");
param.Add("Status", "Status");
param.Add("Amount", "Amount");
param.Add("TotalAmount", "Total Amount");
//param.Add("AgentId", "Agent Id");
//param.Add("UserId", "User Id");
//param.Add("TxnType", "Txn Type");
param.Add("CreatedDate", "Created Date");
param.Add("Action", "Action");
ProjectGrid.column = param;
//Ends
var grid = ProjectGrid.MakeGrid(paymentGatewayTransactionList, "hidebreadcrumb", "", 10, false, "", "", "", "", "", "", "datatable-total", true);
ViewData["grid"] = grid;
ViewBag.GatewayList = ApplicationUtilities.SetDDLValue(LoadDropdownList("pmtGt"), model.GatewayId, "Select Gateway");
return(View(model));
}
public ActionResult PendingTransaction(DynamicReportFilter model)
{
List <DynamicReportCommon> dynamicReportCommons = _dynamicReport.GetPendingReport(model);
List <DynamicReportModel> reportModel = dynamicReportCommons.MapObjects <DynamicReportModel>();
foreach (var item in reportModel)
{
item.Action = StaticData.GetActions("PendingTransaction", item.AgentId.EncryptParameter(), this, "", "", item.TxnId);
}
//Column Creator
IDictionary <string, string> param = new Dictionary <string, string>();
param.Add("TxnDate", "Txn Date");
param.Add("TxnId", "Txn Id");
param.Add("ProductName", "Product");
//param.Add("AgentId", "Agent Id");
param.Add("SubscriberNo", "Subscriber No.");
param.Add("Amount", "Amount");
param.Add("TxnStatus", "Txn Status");
//param.Add("UserId", "User Id");
param.Add("Remarks", "Remarks");
param.Add("Action", "Action");
ProjectGrid.column = param;
//Ends
var grid = ProjectGrid.MakeGrid(reportModel, "hidebreadcrumb", "", 10, false, "", "", "Home", "", "", "", "datatable-total", true);
ViewData["grid"] = grid;
return(View());
}
public List <MerchantTransactionCommon> MerchantTransactionReport(DynamicReportFilter model)
{
var MerchantTransactionCommons = new List <MerchantTransactionCommon>();
string sql = "sproc_topup_report @flag = 'mt'";
sql += (string.IsNullOrEmpty(model.MerchantId) ? "" : ", @agent_id =" + DAO.FilterString(model.MerchantId));
sql += (string.IsNullOrEmpty(model.FromDate) ? "" : ", @from_date =" + DAO.FilterString(model.FromDate));
sql += (string.IsNullOrEmpty(model.ToDate) ? "" : ", @to_date =" + DAO.FilterString(model.ToDate));
var dbres = DAO.ExecuteDataTable(sql);
if (dbres != null)
{
foreach (DataRow dr in dbres.Rows)
{
MerchantTransactionCommon merchantTransaction = new MerchantTransactionCommon();
merchantTransaction.TxnId = dr["txnid"].ToString();
merchantTransaction.MerchantId = dr["MerchantID"].ToString();
merchantTransaction.MerchantName = dr["MerchantName"].ToString();
merchantTransaction.MerchantCode = dr["MerchantCode"].ToString();
merchantTransaction.Amount = dr["Amount"].ToString();
merchantTransaction.CommissionAmt = dr["CommissionAmt"].ToString();
merchantTransaction.UserId = dr["UserId"].ToString();
merchantTransaction.CreatedDate = dr["createdDate"].ToString();
MerchantTransactionCommons.Add(merchantTransaction);
}
}
return(MerchantTransactionCommons);
}
public ActionResult MerchantTransactionReport(DynamicReportFilter model)
{
var merchantList = _dynamicReport.MerchantDropdown();
ViewBag.MerchantList = ApplicationUtilities.SetDDLValue(merchantList as Dictionary <string, string>, model.MerchantId, "All Merchant");
List <MerchantTransactionCommon> reportModel = _dynamicReport.MerchantTransactionReport(model);
IDictionary <string, string> param = new Dictionary <string, string>();
//param.Add("TxnId", "Txn Id");
//param.Add("MerchantId", "Merchant Id");
param.Add("MerchantName", "Merchant Name");
param.Add("MerchantCode", "Merchant Code");
param.Add("UserId", "Mobile Number");
param.Add("Amount", "Amount");
param.Add("CommissionAmt", "Commission Amount");
param.Add("CreatedDate", "Created Date");
ProjectGrid.column = param;
//Ends
var grid = ProjectGrid.MakeGrid(reportModel, "hidebreadcrumb", "", 10, false, "", "", "", "", "", "", "datatable-total", true);
ViewData["grid"] = grid;
return(View());
}
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);
}
public List <DynamicReportCommon> GetManualCommissionReport(DynamicReportFilter model)
{
var DynamicReportCommons = new List <DynamicReportCommon>();
string sql = "sproc_commission_report @flag = 'a'";
sql += ", @user_id =" + DAO.FilterString(model.UserId);
sql += ", @from_date =" + DAO.FilterString(model.FromDate);
sql += ", @to_Date =" + DAO.FilterString(model.ToDate);
var dbres = DAO.ExecuteDataTable(sql);
if (dbres != null)
{
foreach (DataRow dr in dbres.Rows)
{
DynamicReportCommon dynamicReport = new DynamicReportCommon();
dynamicReport.TxnDate = dr["Txn_Date"].ToString();
dynamicReport.TxnType = dr["Txn_Type"].ToString();
dynamicReport.Remarks = dr["Remarks"].ToString();
dynamicReport.ProductName = dr["product_label"].ToString();
dynamicReport.Amount = dr["amount"].ToString();
dynamicReport.CommissionEarned = dr["Commissionearned"].ToString();
dynamicReport.SubscriberNo = dr["user_mobile_no"].ToString();
DynamicReportCommons.Add(dynamicReport);
}
}
return(DynamicReportCommons);
}
public List <DynamicReportCommon> GetPendingReport(DynamicReportFilter model)
{
var DynamicReportCommons = new List <DynamicReportCommon>();
string sql = "sproc_topup_report @flag = 'p'";
sql += ", @from_date =" + DAO.FilterString(model.FromDate);
sql += ", @to_Date =" + DAO.FilterString(model.ToDate);
//sql += (string.IsNullOrEmpty(AgentId) ? "" : ", @agent_id =" + DAO.FilterString(AgentId));
var dbres = DAO.ExecuteDataTable(sql);
if (dbres != null)
{
foreach (DataRow dr in dbres.Rows)
{
DynamicReportCommon dynamicReport = new DynamicReportCommon();
dynamicReport.TxnId = dr["txnid"].ToString();
dynamicReport.ProductName = dr["product_label"].ToString();
dynamicReport.GrandparentId = dr["grand_parent_id"].ToString();
dynamicReport.ParentId = dr["parent_id"].ToString();
dynamicReport.AgentId = dr["agent_id"].ToString();
dynamicReport.SubscriberNo = dr["subscriber_no"].ToString();
dynamicReport.Amount = dr["amount"].ToString();
dynamicReport.TxnStatus = dr["txnstatus"].ToString();
dynamicReport.UserId = dr["user_id"].ToString();
dynamicReport.TxnDate = dr["txndate"].ToString();
dynamicReport.Remarks = dr["agent_remarks"].ToString();
DynamicReportCommons.Add(dynamicReport);
}
}
return(DynamicReportCommons);
}
public ActionResult TransactionReport(string Search = "", int Pagesize = 10)
{
DynamicReportFilter model = new DynamicReportFilter();
List <DynamicReportCommon> dynamicReportCommons = _dynamicReport.GetTransactionReport(model);
List <DynamicReportModel> reportModel = dynamicReportCommons.MapObjects <DynamicReportModel>();
foreach (var item in reportModel)
{
item.Action = StaticData.GetActions("TransactionReport", item.AgentId.EncryptParameter(), this, "", "", item.TxnId);
}
//Column Creator
IDictionary <string, string> param = new Dictionary <string, string>();
param.Add("TxnDate", "Txn Date");
param.Add("TxnId", "Txn Id");
param.Add("ProductName", "Product");
//param.Add("AgentId", "Agent Id");
param.Add("SubscriberNo", "Subscriber No.");
param.Add("Amount", "Amount");
param.Add("TxnStatus", "Txn Status");
//param.Add("UserId", "User Id");
param.Add("Remarks", "Remarks");
param.Add("Action", "Action");
ProjectGrid.column = param;
//Ends
var grid = ProjectGrid.MakeGrid(reportModel, "hidebreadcrumb", Search, Pagesize, false, "", "", "Home", "", "", "", "datatable-total", true);
ViewData["grid"] = grid;
ViewBag.EmptyMessage = "False";
ViewBag.GatewayList = ApplicationUtilities.SetDDLValue(LoadDropdownList("pmtGt"), "", "Select Gateway");
ViewBag.Status = ApplicationUtilities.SetDDLValue(LoadDropdownList("status"), "", "Select Status");
ViewBag.Product = ApplicationUtilities.SetDDLValue(LoadDropdownList("productlist"), "", "Select Product");
return(View());
}
public ActionResult ManualCommissionReport(ManualCommissionReportCommon model)
{
// Start User Id from mobile number
var list = _buss.GetSearchUserList(model.MobileNumber, "mobileno");
if (string.IsNullOrEmpty(model.MobileNumber))
{
list = null;
}
if (list != null)
{
var userinfo = list.FirstOrDefault();
if (userinfo == null)
{
ViewBag.EmptyMessage = "True";
return(View());
}
model.UserId = userinfo.UserID.ToString();
}
else
{
ViewBag.EmptyMessage = "True";
return(View());
}
//Ends
DynamicReportFilter models = new DynamicReportFilter();
models = model.MapObject <DynamicReportFilter>();
List <DynamicReportCommon> dynamicReportCommons = _dynamicReport.GetManualCommissionReport(models);
List <DynamicReportModel> reportModel = dynamicReportCommons.MapObjects <DynamicReportModel>();
Decimal Total_Commission = 0;
foreach (var item in reportModel)
{
Total_Commission = Total_Commission + Convert.ToDecimal(item.CommissionEarned);
}
ViewBag.totalcommission = (float)Total_Commission;
IDictionary <string, string> param = new Dictionary <string, string>();
param.Add("SubscriberNo", "Mobile Number");
param.Add("ProductName", "Product Name");
param.Add("TxnType", "Txn Type");
param.Add("Amount", "Amount");
param.Add("CommissionEarned", "Commission Earned");
param.Add("Remarks", "Remarks");
param.Add("TxnDate", "Txn Date");
ProjectGrid.column = param;
//Ends
var grid = ProjectGrid.MakeGrid(reportModel, "hidebreadcrumb", "", 10, false, "", "", "", "", "", "", "datatable-total", true);
ViewData["grid"] = grid;
return(View());
}
public ActionResult SettlementReport(DynamicReportFilter model)
{
// Start User Id from mobile number
var list = _buss.GetSearchUserList(model.MobileNumber, "mobileno");
if (string.IsNullOrEmpty(model.MobileNumber))
{
list = null;
}
if (list != null)
{
var userinfo = list.FirstOrDefault();
if (userinfo == null)
{
ViewBag.EmptyMessage = "True";
return(View());
}
model.UserId = userinfo.UserID.ToString();
}
else
{
ViewBag.EmptyMessage = "True";
return(View());
}
//Ends
DynamicReportFilter models = new DynamicReportFilter();
models = model.MapObject <DynamicReportFilter>();
List <DynamicReportCommon> dynamicReportCommons = _dynamicReport.GetSettlementReport(models);
List <DynamicReportModel> reportModel = dynamicReportCommons.MapObjects <DynamicReportModel>();
foreach (var item in reportModel)
{
item.Action = StaticData.GetActions("PendingTransaction", item.AgentId.EncryptParameter(), this, "", "", item.TxnId);
}
//Column Creator
IDictionary <string, string> param = new Dictionary <string, string>();
param.Add("TxnDate", "Txn Date");
param.Add("TxnType", "Txn Type");
param.Add("Remarks", "Remarks");
param.Add("Debit", "Debit");
param.Add("Credit", "Credit");
param.Add("Amount", "Amount");
ProjectGrid.column = param;
//Ends
var grid = ProjectGrid.MakeGrid(reportModel, "hidebreadcrumb", "", 10, false, "", "", "", "", "", "", "datatable-total", true);
ViewData["grid"] = grid;
return(View());
}
public ActionResult TransactionReport(DynamicReportFilter model)
{
ViewBag.EmptyMessage = "False";
//ViewBag.GatewayList = ApplicationUtilities.SetDDLValue(LoadDropdownList("pmtGt"), "", "Select Gateway");
ViewBag.Status = ApplicationUtilities.SetDDLValue(LoadDropdownList("status"), "", "Select Status");
ViewBag.Product = ApplicationUtilities.SetDDLValue(LoadDropdownList("productlist"), "", "Select Product");
// Start User Id from mobile number
var list = _buss.GetSearchUserList(model.MobileNumber, "mobileno");
if (!string.IsNullOrEmpty(model.MobileNumber))
{
var userinfo = list.FirstOrDefault();
if (userinfo == null)
{
ViewBag.EmptyMessage = "True";
return(View());
}
model.AgentId = userinfo.AgentUserId.ToString();
}
//Ends
List <DynamicReportCommon> dynamicReportCommons = _dynamicReport.GetTransactionReport(model);
List <DynamicReportModel> reportModel = dynamicReportCommons.MapObjects <DynamicReportModel>();
foreach (var item in reportModel)
{
item.Action = StaticData.GetActions("TransactionReport", item.AgentId.EncryptParameter(), this, "", "", item.TxnId);
}
//Column Creator
IDictionary <string, string> param = new Dictionary <string, string>();
param.Add("TxnDate", "Txn Date");
param.Add("TxnId", "Txn Id");
param.Add("ProductName", "Product");
//param.Add("AgentId", "Agent Id");
param.Add("SubscriberNo", "Subscriber No.");
param.Add("Amount", "Amount");
param.Add("TxnStatus", "Txn Status");
//param.Add("UserId", "User Id");
param.Add("Remarks", "Remarks");
param.Add("Action", "Action");
ProjectGrid.column = param;
//Ends
var grid = ProjectGrid.MakeGrid(reportModel, "hidebreadcrumb", "", 10, false, "", "", "Home", "", "", "", "datatable-total", true);
ViewData["grid"] = grid;
return(View());
}
public ActionResult Index()
{
DynamicReportFilter DRF = new DynamicReportFilter();
DRF.UserId = Session["UserId"].ToString();
DRF.reportlist = _Report.GetSettlementReportclient(DRF);
foreach (var item in DRF.reportlist)
{
item.TxnId = item.TxnId.EncryptParameter();
}
LoadDropDownList(DRF);
return(View(DRF));
}
public ActionResult Index()
{
DynamicReportFilter DRF = new DynamicReportFilter();
DRF.UserId = Session["UserId"].ToString();
DRF.reportlist = _Report.GetSettlementReportclient(DRF);
ViewBag.EmptyMessage = "False";
if (DRF.reportlist == null || DRF.reportlist.Count == 0)
{
ViewBag.EmptyMessage = "True";
}
foreach (var item in DRF.reportlist)
{
item.TxnId = item.TxnId.EncryptParameter();
}
LoadDropDownList(DRF);
return(View(DRF));
}
public List <DynamicReportCommon> GetSettlementReport(DynamicReportFilter model)
{
var DynamicReportCommons = new List <DynamicReportCommon>();
string sql = "sproc_admin_settlement_report @flag = 'a'";
sql += ", @user_id =" + DAO.FilterString(model.UserId);
sql += (string.IsNullOrEmpty(model.FromDate) ? "" : ", @from_Date =" + DAO.FilterString(model.FromDate));
sql += (string.IsNullOrEmpty(model.ToDate) ? "" : ", @to_Date =" + DAO.FilterString(model.ToDate));
//sql += (string.IsNullOrEmpty(DRW.ProductName) ? "" : ", @service =" + DAO.FilterString(DRW.ProductName));
//sql += (string.IsNullOrEmpty(DRW.TxnStatus) ? "" : ", @txnStatus =" + DAO.FilterString(DRW.TxnStatus));
//sql += (string.IsNullOrEmpty(DRW.TxnType) ? "" : ", @txnType =" + DAO.FilterString(DRW.TxnType));
//sql += (string.IsNullOrEmpty(DRW.CustomerName) ? "" : ", @username ="******"txn_id"].ToString();// dr["Txn_Dates"].ToString();
dynamicReport.TxnDate = dr["Txn_Date"].ToString();
dynamicReport.TxnType = dr["Txn_Type"].ToString();
//dynamicReport.TxnMode = dr["txn_mode"].ToString();
//dynamicReport.CreatedLocalDate = dr["CreatedDate"].ToString();
dynamicReport.Remarks = dr["Remarks"].ToString();
//dynamicReport.TxnTitle = dr["txn_title"].ToString();
dynamicReport.Debit = dr["DR"].ToString();
dynamicReport.Credit = dr["Cr"].ToString();
dynamicReport.Amount = dr["Balance"].ToString();
//dynamicReport.Amount = dr["Settlement_Amount"].ToString();
dynamicReport.Currency = dr["CCY"].ToString();
DynamicReportCommons.Add(dynamicReport);
}
}
return(DynamicReportCommons);
}
public List <MerchantTransactionCommon> MerchantTransactionReport(DynamicReportFilter model)
{
return(_repo.MerchantTransactionReport(model));
}
public List <PaymentGatewayTransactionReport> PaymentGatewayTransactionList(DynamicReportFilter filter)
{
return(_repo.PaymentGatewayTransactionList(filter));
}
public List <DynamicReportCommon> GetManualCommissionReport(DynamicReportFilter model)
{
return(_repo.GetManualCommissionReport(model));
}
public List <DynamicReportCommon> GetSettlementReportclient(DynamicReportFilter DRF)
{
return(_repo.GetSettlementReportclient(DRF));
}
public List <DynamicReportCommon> GetSettlementReport(DynamicReportFilter model)
{
return(_repo.GetSettlementReport(model));
}
public List <DynamicReportCommon> GetPendingReport(DynamicReportFilter model)
{
return(_repo.GetPendingReport(model));
}
public List <DynamicReportCommon> GetTransactionReport(DynamicReportFilter model)
{
return(_repo.GetTransactionReport(model));
}
public void LoadDropDownList(DynamicReportFilter dynamicReportCommon)
{
ViewBag.Services = ApplicationUtilities.SetDDLValue(LoadDropdownList("ProductName"), dynamicReportCommon.Service, "--Services--");
ViewBag.txnType = ApplicationUtilities.SetDDLValue(LoadDropdownList("TxnType"), dynamicReportCommon.TxnType, "--Transaction Type--");
ViewBag.txnStatus = ApplicationUtilities.SetDDLValue(LoadDropdownList("txnstatus"), dynamicReportCommon.TxnType, "--Transaction Status--");
}
