Example #1
0
        private void buttonSave_Click(object sender, EventArgs e)
        {
            Nominant nominant = new Nominant
            {
                name        = textBoxName.Text,
                nominations = int.Parse(textBoxNominations.Text),
                oscars      = int.Parse(textBoxOscars.Text)
            };

            ControlDb.Add(nominant);
            Thread.Sleep(500);
            this.Close();
        }
Example #2
0
        public static void getAllSeries(int from, int to, string channels)
        {
            string        commandGetAllSeries = string.Format("SELECT * FROM Series WHERE(completed_seasons BETWEEN {0} AND {1}) AND(TV_Channel IN({2}))", from, to, channels);
            SqlCommand    selectSeries        = new SqlCommand(commandGetAllSeries, GetConnection());
            SqlDataReader sqlReader           = selectSeries.ExecuteReader();

            if (sqlReader.HasRows)
            {
                while (sqlReader.Read())
                {
                    Nominant newNominant = new Nominant
                    {
                    };
                }
            }
        }
Example #3
0
        public static BindingList <Nominant> SelectAll()
        {
            BindingList <Nominant> getNominants = new BindingList <Nominant>();
            string        commandSelectAll      = "Select * from nominats";
            SqlCommand    selectInfo            = new SqlCommand(commandSelectAll, GetConnection());
            SqlDataReader sqlReader             = selectInfo.ExecuteReader();

            if (sqlReader.HasRows)
            {
                while (sqlReader.Read())
                {
                    Nominant newNominant = new Nominant
                    {
                        name        = sqlReader.GetValue(0).ToString(),
                        nominations = (int)sqlReader.GetValue(1),
                        oscars      = (int)sqlReader.GetValue(2)
                    };
                    getNominants.Add(newNominant);
                }
            }
            return(getNominants);
        }