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