Beispiel #1
0
        public void Init()
        {
            college.Items.Clear();
            college.Items.Add("Please Select College Code");
            college.SelectedIndex = 0;
            var rdx = SqlUtils.ExecuteQueryReader("select college_code from college", false);

            while (rdx.Read())
            {
                college.Items.Add(rdx.GetString(0));
            }

            AttendeeNames.Clear();
            AttendeeNames.AddItem("Select Name of Attendee");
            AttendeeNames.selectedIndex = 0;
            var rdy = SqlUtils.ExecuteQueryReader("select attendee_id,attendee_fullname from attendee where eventid=" + UserInfo.EventId, false);

            while (rdy.Read())
            {
                //AttendeeNames.AddItem((string)rdy["attendee_fullname"]);
                NameLists.Add((string)rdy["attendee_fullname"]);
                IdLists.Add((int)rdy["attendee_id"]);
            }
            int idCounter = 0;

            foreach (var name in NameLists)
            {
                var data = IdLists[idCounter].ToString() + ':' + name;
                AttendeeNames.AddItem(data);
                Mixed.Add(data);
                idCounter += 1;
            }
        }
Beispiel #2
0
        //int UpdateId = 0; // Fix tommorrow Implement to all Universe
        // Fix Update info via on key up searchbar
        private void SearchBar_KeyUp(object sender, KeyEventArgs e)
        {
            var pattern = new Regex(SearchBar.Text.ToLower());

            AttendeeNames.Clear();
            AttendeeNames.AddItem("Select Name of Attendee");
            if (SearchBar.Text.Trim().Length > 0)
            {
                int result = 0;

                foreach (string mix in Mixed)
                {
                    if (pattern.IsMatch(mix.ToLower()))
                    {
                        AttendeeNames.AddItem(mix);
                        //NameLists.IndexOf(name);
                        //AttendeeNames.AddItem(name);
                        result += 1;
                    }
                }
                if (result <= 0)
                {
                    AttendeeNames.Clear();
                    AttendeeNames.AddItem("No Result Found");
                }

                AttendeeNames.selectedIndex = 0;
            }
            else
            {
                AttendeeNames.selectedIndex = 0;
                int z = 0;
                foreach (var mix in Mixed)
                {
                    AttendeeNames.AddItem(mix);

                    z += 1;
                }
            }
        }