public DataTable GetRecoveryDataForReport(string CardNo, string AccountNo, string BranchCode, DateTime StartDate, DateTime EndDate) { string startDate = Convert.ToString(StartDate); string endDate = Convert.ToString(EndDate); var builder = new StringBuilder(); try { builder.Append("exec sp_Reports_Recovery "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CardNo + "'"); var query = builder.ToString(); return string.IsNullOrEmpty(query) ? new DataTable() : DatabaseGateway.GetDataUsingStoredProcedureQuery(query); } catch (Exception ex) { throw ex; } }
public DataTable GetDataForDailyTransaction(string CardNo, string AccountNo, string BranchCode, DateTime? TransDate) { var TransactionDate = TransDate.Value.Date.ToString("d"); var builder = new StringBuilder(); try { builder.Append("exec sp_Daily_Transactions"); builder.Append(" '" + CardNo + "','" + AccountNo + "',"); builder.Append("'" + BranchCode + "','" + TransactionDate + "'"); var query = builder.ToString(); return string.IsNullOrEmpty(query) ? new DataTable() : DatabaseGateway.GetDataUsingStoredProcedureQuery(query); } catch (Exception ex) { throw ex; } }
public DataTable GetFileImports(string accountNo, string cardNo, string branchCode, int?CardTypeId, DateTime?productionDate, DateTime?ImportDate) { try { int CT = CardTypeId ?? -1; string ProdDate = Convert.ToString(productionDate); string ImpDate = Convert.ToString(ImportDate); var builder = new StringBuilder(); builder.Append("exec sp_Reports_CardImport "); builder.Append("'" + accountNo + "','" + cardNo + "','" + branchCode + "'," + CT.ToString() + ","); builder.Append("'" + ProdDate + "','" + ImpDate + "'"); return(DatabaseGateway.GetDataUsingStoredProcedureQuery(builder.ToString())); } catch (Exception ex) { throw ex; } }
public DataTable GetDataForCurrentRecovery(string CardNo, string AccountNo, string BranchCode, DateTime StartDate, DateTime EndDate, string RequestType, string CIF) { string startDate = StartDate.Date.ToString("d"); string endDate = EndDate.Date.ToString("d"); var builder = new StringBuilder(); try { builder.Append("exec sp_Current_Recovery_Status"); builder.Append("'" + CardNo + "','" + AccountNo + "',"); builder.Append("'" + CIF + "','" + BranchCode + "',"); builder.Append("'" + startDate + "','" + endDate + "','" + RequestType + "'"); var query = builder.ToString(); return string.IsNullOrEmpty(query) ? new DataTable() : DatabaseGateway.GetDataUsingStoredProcedureQuery(query); } catch (Exception ex) { throw ex; } }
public DataTable GetRequestDataForReport(string CardNo, string AccountNo, string BranchCode, int? CardTypeId, string CIF, long? RequestNo, int? Waive, string RequestType,string ReportType, DateTime StartDate, DateTime EndDate, string AuthorizeStatus) { try { string startDate = Convert.ToString(StartDate); string endDate = Convert.ToString(EndDate); var builder = new StringBuilder(); if (RequestType == "N" && ReportType == "false") { builder.Append("exec sp_Reports_CardIssuance "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + Waive + "," + CardTypeId + ","); builder.Append("'" + RequestType + "','" + AuthorizeStatus + "'"); } else if (RequestType == "N" && ReportType == "true") { builder.Append("exec sp_Reports_CardIssuance_log "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + Waive + "," + CardTypeId + ","); builder.Append("'" + RequestType + "','" + AuthorizeStatus + "'"); } else if (RequestType == "R" && ReportType == "false") { builder.Append("exec sp_Reports_CardReplacement "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + Waive + "," + CardTypeId + ","); builder.Append("'" + RequestType + "','" + AuthorizeStatus + "'"); } else if (RequestType == "R" && ReportType == "true") { builder.Append("exec sp_Reports_CardReplacement_log "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + Waive + "," + CardTypeId + ","); builder.Append("'" + RequestType + "','" + AuthorizeStatus + "'"); } else if (RequestType == "A" && ReportType =="false") { builder.Append("exec sp_Reports_CardAmendment "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "','" + AuthorizeStatus + "'"); } else if (RequestType == "A" && ReportType == "true") { builder.Append("exec sp_Reports_CardAmendment_log "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "','" + AuthorizeStatus + "'"); } else if (RequestType == "U") { builder.Append("exec sp_Reports_CardUpgrade "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + Waive + "," + CardTypeId + ","); builder.Append("'" + RequestType + "','" + AuthorizeStatus + "'"); } else if (RequestType == "H" && ReportType == "false") { builder.Append("exec sp_Reports_CardHotMark "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + CardTypeId + ",'" + AuthorizeStatus + "'"); } else if (RequestType == "H" && ReportType == "false") { builder.Append("exec sp_Reports_CardHotMark "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + CardTypeId + ",'" + AuthorizeStatus + "'"); } //else if (RequestType == "H" && ReportType == "true") //{ // builder.Append("exec sp_Reports_CardHotMark_log"); // builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); // builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); // builder.Append("'" + RequestNo + "'," + Waive + "," + CardTypeId + ","); // builder.Append("'" + RequestType + "','" + AuthorizeStatus + "'"); //} else if (RequestType == "L" && ReportType == "false") { builder.Append("exec sp_Reports_CardLinking "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "','" + AuthorizeStatus + "'"); } else if (RequestType == "L" && ReportType == "true") { builder.Append("exec sp_Reports_CardLinking_log"); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + Waive + "," + CardTypeId + ","); builder.Append("'" + RequestType + "','" + AuthorizeStatus + "'"); } else if (RequestType == "D" && ReportType == "false") { builder.Append("exec sp_Reports_CardDeLinking "); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "','" + AuthorizeStatus + "'"); } else if (RequestType == "D" && ReportType == "true") { builder.Append("exec sp_Reports_CardDeLinking_log"); builder.Append("'" + BranchCode + "','" + startDate + "','" + endDate + "',"); builder.Append("'" + AccountNo + "','" + CIF + "','" + CardNo + "',"); builder.Append("'" + RequestNo + "'," + Waive + "," + CardTypeId + ","); builder.Append("'" + RequestType + "','" + AuthorizeStatus + "'"); } var query = builder.ToString(); return string.IsNullOrEmpty(query) ? new DataTable() : DatabaseGateway.GetDataUsingStoredProcedureQuery(query); } catch (Exception ex) { throw ex; } }