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();
}
}
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();
}