public IList <GetAccountDetails> ViewUsers() { SqlConnection con = new SqlConnection(); DataTable dt = new DataTable(); IList <GetAccountDetails> accountDetailList = new List <GetAccountDetails>(); try { int rowCount = 0; con.ConnectionString = ConfigurationManager.ConnectionStrings["Bankingsysconn"].ConnectionString; con.Open(); string getRowNo = Query.getCount; SqlCommand cmd = new SqlCommand(getRowNo, con); SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { rowCount = Convert.ToInt32(dr.GetValue(0)); } dr.Close(); string getDetails = Query.selectViewUsers; SqlCommand cmd1 = new SqlCommand(getDetails, con); SqlDataReader dr1 = cmd1.ExecuteReader(); dt.Columns.AddRange(new DataColumn[8] { new DataColumn("Account number", typeof(string)), new DataColumn("Customer name", typeof(string)), new DataColumn("Age", typeof(string)), new DataColumn("Address", typeof(string)), new DataColumn("Email", typeof(string)), new DataColumn("City", typeof(string)), new DataColumn("Gender", typeof(string)), new DataColumn("Account balance", typeof(string)) }); while (dr1.Read()) { GetAccountDetails detail = new GetAccountDetails(); detail.AccountNo = Convert.ToString(dr1["account_no"]); detail.CustomerName = Convert.ToString(dr1["customer_name"]); detail.Age = Convert.ToString(dr1["age"]); detail.Address = Convert.ToString(dr1["address"]); detail.EmailId = Convert.ToString(dr1["email_id"]); detail.City = Convert.ToString(dr1["city"]); detail.Gender = Convert.ToString(dr1["gender"]); detail.AccountBalance = Convert.ToString(dr1["account_balance"]); accountDetailList.Add(detail); } dr1.Close(); } finally { con.Close(); } return(accountDetailList); }
public void Default(GetAccountDetailsOutput output) { GetAccountDetails.Add(output); }
public void Handle(Application.Boundaries.GetAccountDetails.Output output) { GetAccountDetails.Add(output); }
public void Default(Application.Boundaries.GetAccountDetails.GetAccountDetailsOutput output) { GetAccountDetails.Add(output); }
public void Standard(Application.Boundaries.GetAccountDetails.GetAccountDetailsOutput output) { GetAccountDetails.Add(output); }
public async Task <ActionResult> Details(GetAccountDetails query) { var accountDetails = await _queryProcessor.ProcessAsync(query); return(View(accountDetails)); }
public void Standard(GetAccountDetailsOutput output) { GetAccountDetails.Add(output); }