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