public ActionResult Inquiry()
{
string getVal = Request["_val"];
string getTrxType = Request["_trxType"];
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
if (getVal.Length == 16)
{
param.Parameter.Add("cardNo", getVal);
}
else
{
param.Parameter.Add("custNo", getVal);
}
if ("outstanding".Equals(getTrxType))
{
CreditCardOutstandingTransaction model = CCTransaction.OutstandingTransactions(param);
model.getTotalNominal();
model.Sampling();
var outstandingData = new { CustomerNo = model.CustomerNo, Total = model.TotalAmount, grid = model.TransactionData };
return(Json(outstandingData, JsonRequestBehavior.AllowGet));
}
if ("current".Equals(getTrxType))
{
CreditCardCurrentTransaction model = CCTransaction.CurrentTransactions(param);
model.getTotalAmount();
model.Sampling();
var currentData = new { CustomerNo = model.CustomerNo, Total = model.TotalAmount, grid = model.TransactionData };
return(Json(currentData, JsonRequestBehavior.AllowGet));
}
if ("history".Equals(getTrxType))
{
CreditCardRetrieveMultipleStatementDate st = CreditCardService.RetrieveCreditCardStatementDates(param);
string julianformat = string.Empty;
param.Parameter.Add("statementDate", st.Statements.Count > 0 ? st.Statements.First().StatementDateInJulianFormat : "");
CreditCardHistoricalTransaction model = CCTransaction.HistoryTransactions(param);
model.CompletingInformation(st);
var historicalData = new { Information = model.Information, StatementDates = st.Statements, grid = model.TransactionData };
return(Json(historicalData, JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public ActionResult TransactionsByStatement()
{
string getNo = Request["_no"];
string getStatementDate = Request["_statementDate"];
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
if (getNo.Length == 16)
{
param.Parameter.Add("cardNo", getNo);
}
else
{
param.Parameter.Add("custNo", getNo);
}
param.Parameter.Add("statementDate", getStatementDate);
CreditCardHistoricalTransaction model = CCTransaction.HistoryTransactions(param);
double newBalance = 0;
double newBill = 0;
foreach (CreditCardInformation entry in model.CreditCards)
{
IEnumerable <CreditCardTransaction> creditCardTransactions =
from transaction in model.Transactions
where transaction.CreditCardNo == entry.CreditCardNo
select transaction;
double?negativeAmount = (from creditCardTransaction in creditCardTransactions
where CCTransaction.HistoricalTransactionCodesForNegativeAmount.Contains(creditCardTransaction.TransactionCode)
select creditCardTransaction.Amount).Sum();
double?positiveAmount = (from creditCardTransaction in creditCardTransactions
where !CCTransaction.HistoricalTransactionCodesForNegativeAmount.Contains(creditCardTransaction.TransactionCode)
select creditCardTransaction.Amount).Sum();
double?previousBalance = (from creditCardTransaction in creditCardTransactions
select creditCardTransaction.PreviousBalance).Sum();
double?subTotal = positiveAmount - negativeAmount + previousBalance;
if (subTotal.HasValue)
{
newBalance += subTotal.Value;
newBill = newBalance - ((double)model.Information.OldBalance) + ((double)model.Information.Credit);
}
entry.PrevBalance = previousBalance;
entry.SubTotal = subTotal;
}
model.Information.NewBalance = newBalance;
model.Information.NewBill = newBill;
model.Sampling();
var historicalData = new { Information = model.Information, grid = model.TransactionData };
return(Json(historicalData, JsonRequestBehavior.AllowGet));
}