コード例 #1
0
ファイル: adaugareRecenzie.cs プロジェクト: StefanLazea/paw
        private void buttonAdaugaRecenzie_Click(object sender, EventArgs e)
        {
            OleDbConnection conn    = new OleDbConnection(connString);
            OleDbCommand    comanda = new OleDbCommand();

            comanda.Connection = conn;

            try
            {
                conn.Open();
                comanda.CommandText = "Select MAX(id) FROM recenzii";
                int id = Convert.ToInt32(comanda.ExecuteScalar());

                int    nota      = Convert.ToInt32(cbNota.SelectedItem.ToString());
                string descriere = tbDescriere.Text;

                Recenzie rec = new Recenzie(id, nota, descriere, idFilm);
                rec.save(connString);

                MessageBox.Show("Succes");

                afisareFilme form = new afisareFilme();
                this.Hide();
                form.ShowDialog();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            finally
            {
                conn.Close();
            }
        }
コード例 #2
0
ファイル: adaugareRecenzie.cs プロジェクト: StefanLazea/paw
        private void adaugareRecenzie_Load(object sender, EventArgs e)
        {
            Filme film = Filme.getOneById(connString, idFilm);

            tbDenumire.Text = film.Denumire;
            string denumireCategorie = Categorie.findCategoryNameById(connString, film.IdCategorie);

            tbCategorie.Text   = denumireCategorie;
            tbNotaMedie.Text   = Recenzie.getAverageOfNotesForAMovie(connString, idFilm).ToString();
            tbDataLansare.Text = film.Datalansare.ToString();
        }