internal List <Transactions> FetchTransactions(FetchTransactionsModel f, bool x)
{
if (!x)
{
sql = "select top(10) transactionid,senderaccno,receiveraccno,amount,convert(varchar(12),date,120)as date,convert(varchar(12),time,108) as time from transactions where senderaccno=" + f.accountno + " or receiveraccno=" + f.accountno + " order by date desc,time desc";
}
else
{
sql = "select transactionid,senderaccno,receiveraccno,amount,convert(varchar(12),date,120)as date,convert(varchar(12),time,108) as time from transactions where (senderaccno=" + f.accountno + " or receiveraccno=" + f.accountno + ") and (convert(varchar(12),date,120)>='" + f.fromdate + "' or convert(varchar(12),date,120)<='" + f.todate + "') order by date desc,time desc";
}
var customertransaction = new List <Transactions>();
using (conn = new SqlConnection(connectionString))
{
cmd = new SqlCommand(sql, conn);
conn.Open();
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
var c = new Transactions();
c.transactionId = int.Parse(rdr["transactionId"].ToString());
c.senderAccNo = int.Parse(rdr["senderAccNo"].ToString());
c.recieverAccNo = int.Parse(rdr["receiverAccNo"].ToString());
c.amount = float.Parse(rdr["amount"].ToString());
c.date = rdr["date"].ToString();
c.time = rdr["time"].ToString();
customertransaction.Add(c);
}
conn.Close();
return(customertransaction);
}
}
public ActionResult TransactionHistory(string selectedaccount, string selected, string from, string to)
{
if (Session["LoggedInCustomerId"] == null)
{
return(Redirect("/HomePage/Index"));
}
else
{
var c = new CustomerDetails();
var ch = new CustomerHelper();
var f = new FetchTransactionsModel();
f.accountno = selectedaccount;
ViewData["AccNo"] = selectedaccount;
f.fromdate = from;
f.todate = to;
c.cid = HttpContext.Session["LoggedInCustomerId"].ToString();
var model = new List <Accounts>();
model = ch.FetchCustomerAccount(c);
foreach (var item in model)
{
if (item.accountNum == int.Parse(selectedaccount))
{
ViewData["Bal"] = item.balance;
}
}
if (selected == "last10")
{
ViewBag.Transactions = ch.FetchTransactions(f, false);
return(View("ViewTransactions", model));
}
else
{
ViewBag.Transactions = ch.FetchTransactions(f, true);
return(View("ViewTransactions", model));
}
}
}
