public List <StatementModel> GetStatement(long Accountno)
{
TransactionDataAccess tranDac = new TransactionDataAccess();
DataSet ds = tranDac.Read(Accountno);
List <StatementModel> Transactionlist = new List <StatementModel>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
StatementModel uobj = new StatementModel();
uobj.TransactionId = Convert.ToInt32(ds.Tables[0].Rows[i]["transaction_id"].ToString());
uobj.DebitAccount = Convert.ToInt64(ds.Tables[0].Rows[i]["debit_account_no"].ToString());
uobj.CreditAccount = Convert.ToInt64(ds.Tables[0].Rows[i]["credit_account_no"].ToString());
uobj.DebitAccountBalance = Convert.ToInt64(ds.Tables[0].Rows[i]["debit_account_balance"].ToString());
uobj.CreditAccountBalance = Convert.ToInt64(ds.Tables[0].Rows[i]["credit_account_balance"].ToString());
uobj.Amount = Convert.ToInt32(ds.Tables[0].Rows[i]["amount"].ToString());
uobj.TransactionDate = ds.Tables[0].Rows[i]["transaction_date_time"].ToString();
Transactionlist.Add(uobj);
}
TransactionDataAccess.sqlCon.Close();
return(Transactionlist);
}
