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