Exemple #1
0
        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);
        }