public async Task <ActionResult> DownloadSettEnquiry(SettlementEnquiryObj obj)
{
try
{
string logopath = !string.IsNullOrEmpty(ConfigurationManager.AppSettings["LogoPath"]) ? Convert.ToString(ConfigurationManager.AppSettings["LogoPath"]) : string.Empty;
//Call to get Excel byte array.
string fileName = string.Format("Settlement Enquiry Report {0}.xlsx", DateTime.Now.ToString("dd-MM-yyyy"));
DateTime start_date;
DateTime end_date;
var companyname = repoComp.AllEager().FirstOrDefault().COMPANY_NAME;
var stSuc = DateTime.TryParse(GetDate(obj.fromDate), out start_date);
var adSuc = DateTime.TryParse(GetDate(obj.toDate), out end_date);
var data = await _repo2.GetSettlementEnquiryAsync(obj);
var dt = SmartObj.ToDataTable(data);
var excelBytes = ExcelHelper.ExportDatasetWithLogo2(10, dt, logopath, companyname, "Settlement Enquiry");
//var excelBytes = DumpExcelSettEnquiry(dt, fileName);
//Set file name.
return(excelBytes != null?File(excelBytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName) : null);
}
catch
{
return(null);
}
}
public async Task <List <SM_SETTLEMENTDETAIL> > GetSettlementEnquiryAsync(SettlementEnquiryObj obj = null)
{
var p = new DynamicParameters();
p.Add("P_FROMDATE", obj.fromDate, DbType.DateTime, null);
p.Add("P_TODATE", obj.toDate, DbType.DateTime, null);
p.Add("@P_SETTDATE", obj.settDate, DbType.DateTime, null);
p.Add("PAYREF", string.IsNullOrEmpty(obj.payRef) ? null : obj.payRef, DbType.String, null);
p.Add("REFNO", string.IsNullOrEmpty(obj.tranRef) ? null : obj.tranRef, DbType.String, null);
p.Add("TRANSID", obj.tranID ?? null, DbType.Decimal, null);
p.Add("MERCHANTDEPOSITBANK", string.IsNullOrEmpty(obj.crBank) ? null : obj.crBank, DbType.String, null);
p.Add("DEBITBANK", string.IsNullOrEmpty(obj.drBank) ? null : obj.drBank, DbType.String, null);
p.Add("MERCHANTID", string.IsNullOrEmpty(obj.merchantID) ? null : obj.merchantID, DbType.String, null);
p.Add("MERCHANTNAME", string.IsNullOrEmpty(obj.merchantName) ? null : obj.merchantName, DbType.String, null);
p.Add("CARDSCHEME", string.IsNullOrEmpty(obj.cardScheme) ? null : obj.cardScheme, DbType.String, null);
p.Add("TRANAMOUNT", obj.tranAmt ?? null, DbType.Decimal, null);
p.Add("ACQUIRERFIID", string.IsNullOrEmpty(obj.acquirer) ? null : obj.acquirer, DbType.String, null);
p.Add("ISSUERFIID", string.IsNullOrEmpty(obj.issuer) ? null : obj.issuer, DbType.String, null);
p.Add("SETTLEMENTACCOUNT", string.IsNullOrEmpty(obj.settAcct) ? null : obj.settAcct, DbType.String, null);
p.Add("CHANNELID", string.IsNullOrEmpty(obj.channel) ? null : obj.channel, DbType.Int32, null);
p.Add("MASKPAN", string.IsNullOrEmpty(obj.maskpan) ? null : obj.maskpan, DbType.String, null);
p.Add("TERMINALID", string.IsNullOrEmpty(obj.termID) ? null : obj.termID, DbType.String, null);
p.Add("LOCATION", string.IsNullOrEmpty(obj.mlocation) ? null : obj.mlocation, DbType.String, null);
p.Add("INVOICENO", string.IsNullOrEmpty(obj.invoiceNo) ? null : obj.invoiceNo, DbType.String, null);
//p.Add("@P_PAGENUMBER", pagenumber, DbType.Int32, null);
//p.Add("@P_PAGESIZE", pagesize, DbType.Int32, null);
var rec = await FetchAsync(async c =>
{
var gh = await c.QueryAsync <SM_SETTLEMENTDETAIL>("PROC_SETTLEMENTENQUIRY", p, commandType: CommandType.StoredProcedure);
return(gh);
});
return(rec.ToList());
}
public List <SM_SETTLEMENTDETAIL> GetSettlementEnquiryObj(SettlementEnquiryObj obj)
{
// OutPutObj ret = new OutPutObj();
var p = new DynamicParameters();
p.Add("P_FROMDATE", obj.fromDate, DbType.DateTime);
p.Add("P_TODATE", obj.toDate, DbType.DateTime);
p.Add("@P_SETTDATE", obj.settDate, DbType.DateTime);
p.Add("PAYREF", obj.payRef, DbType.String);
p.Add("REFNO", obj.tranRef, DbType.String);
p.Add("TRANSID", obj.tranID, DbType.Decimal);
p.Add("MERCHANTDEPOSITBANK", obj.crBank, DbType.String);
p.Add("DEBITBANK", obj.drBank, DbType.String);
p.Add("MERCHANTID", obj.merchantID, DbType.String);
p.Add("MERCHANTNAME", obj.merchantName, DbType.String);
p.Add("CARDSCHEME", obj.cardScheme, DbType.String);
p.Add("TRANAMOUNT", obj.tranAmt, DbType.Decimal);
p.Add("ACQUIRERFIID", obj.acquirer, DbType.String);
p.Add("ISSUERFIID", obj.issuer, DbType.String);
p.Add("SETTLEMENTACCOUNT", obj.settAcct, DbType.String);
p.Add("CHANNELID", obj.channel, DbType.Int32);
p.Add("MASKPAN", obj.maskpan, DbType.String);
p.Add("TERMINALID", obj.termID, DbType.String);
p.Add("LOCATION", obj.mlocation, DbType.String);
p.Add("INVOICENO", obj.invoiceNo, DbType.String);
using (var con = new RepoBase().OpenConnection(null))
{
var ret = con.Query <SM_SETTLEMENTDETAIL>("PROC_SETTLEMENTENQUIRY", p, commandType: CommandType.StoredProcedure).ToList();
return(ret);
}
}
public async Task <ActionResult> GetSettlementEnquiry(int draw, int start, int length, SettlementEnquiryObj obj)
{
DataTableData dataTableData = new DataTableData();
try
{
start++;
// DateTime start_date;
// DateTime end_date;
//var stSuc = DateTime.TryParse(GetDate(obj.fromDate), out start_date);
//var adSuc = DateTime.TryParse(GetDate(obj.toDate), out end_date);
//if (!stSuc || !adSuc)
//{
// dataTableData.draw = draw;
// dataTableData.recordsTotal = 0; // TOTAL_ROWS;
// // int recordsFiltered = 0;
// dataTableData.data = new List<SettlementEnquiryObj>(); //FilterData(ref recordsFiltered, start, length, search, sortColumn, sortDirection);
// dataTableData.recordsFiltered = 0;
//}
//else
//{
dataTableData.draw = draw;
var data = await _repo2.GetSettlementEnquiryAsync(obj);
//dataTableData.recordsTotal = cnt; // TOTAL_ROWS;
//int recordsFiltered = 0;
dataTableData.data = data; //FilterData(ref recordsFiltered, start, length, search, sortColumn, sortDirection);
dataTableData.recordsFiltered = data.Count; // recordsFiltered;
// }
}
catch (Exception ex)
{
dataTableData.draw = draw;
dataTableData.recordsTotal = 0; // TOTAL_ROWS;
// int recordsFiltered = 0;
dataTableData.data = new List <SM_SETTLEMENTDETAIL>(); //FilterData(ref recordsFiltered, start, length, search, sortColumn, sortDirection);
dataTableData.recordsFiltered = 0;
}
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
