private void barListLoadAccount_ListItemClick(object sender, ListItemClickEventArgs e) { var type = (e.Item as BarListItem).Strings[(int)e.Index]; lbGroupAccount.Text = "Current group accounts: " + type; CurrentGroupAccount = groupAccountsService.GetGroupByName(type); var ls = accountService.GetAccountByGroupID(CurrentGroupAccount.ID); LoadAccounts(ls); }
public GroupAccountsModel GetGroupByName(string name) { sql_con.Open(); sql_cmd = new SQLiteCommand($"SELECT * FROM GroupAccounts where NameGroup ='{name}'", sql_con); SQLiteDataReader sqliteDataReader = sql_cmd.ExecuteReader(); GroupAccountsModel Groups = new GroupAccountsModel(); while (sqliteDataReader.Read()) { Groups.ID = Conversions.ToInteger(sqliteDataReader["ID"]); Groups.NameGroup = Conversions.ToString(sqliteDataReader["NameGroup"]); } sql_con.Close(); return(Groups); }