예제 #1
0
파일: home.cs 프로젝트: StefanLazea/paw
        private void buttonFilme_Click(object sender, EventArgs e)
        {
            afisareFilme form = new afisareFilme();

            this.Hide();
            form.ShowDialog();
        }
예제 #2
0
        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();
            }
        }
예제 #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            OleDbConnection conn    = new OleDbConnection(connString);
            OleDbCommand    comanda = new OleDbCommand();

            comanda.Connection = conn;

            if (tbDenumire.Text == "")
            {
                errorProvider1.SetError(tbDenumire, "Introduceti denumire");
            }
            else if (tbDurata.Text == "")
            {
                errorProvider1.Clear();
                errorProvider1.SetError(tbDurata, "Introduceti durata (min)");
            }
            else if (tbPret.Text == "")
            {
                errorProvider1.Clear();
                errorProvider1.SetError(tbPret, "Introduceti pretul");
            }
            else
            {
                errorProvider1.Clear();
                try
                {
                    conn.Open();
                    comanda.CommandText = "Select MAX(id) FROM filme";
                    int id = Convert.ToInt32(comanda.ExecuteScalar());

                    string   denumire    = tbDenumire.Text;
                    int      idCategorie = Categorie.getCategoryIdByName(connString, cbCategorie.SelectedItem.ToString());
                    DateTime data        = Convert.ToDateTime(dateTimePicker.Text);
                    double   durata      = Convert.ToDouble(tbDurata.Text);
                    float    pret        = (float)Convert.ToDouble(tbPret.Text);


                    Filme film = new Filme(id, denumire, idCategorie, data, durata, pret, imgPath);
                    film.save(connString);

                    MessageBox.Show("Succes");

                    this.Hide();
                    afisareFilme form = new afisareFilme();
                    form.ShowDialog();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                finally
                {
                    conn.Close();
                }
            }
        }
예제 #4
0
        private void buttonComanda_Click(object sender, EventArgs e)
        {
            OleDbConnection conn    = new OleDbConnection(connString);
            OleDbCommand    comanda = new OleDbCommand();

            comanda.Connection = conn;
            Regex regex = new Regex("^[a-zA-Z]+$");

            //bool hasOnlyAlpha = regex.IsMatch(myTextBox.Text);  && regex.IsMatch(tbNume.Text
            if (tbNume.Text == "")
            {
                errorProvider1.SetError(tbNume, "Introduceti numele");
            }
            else if (tbPrenume.Text == "")
            {
                errorProvider1.Clear();
                errorProvider1.SetError(tbPrenume, "Introduceti prenumele)");
            }
            else if (tbTelefon.Text == "")
            {
                errorProvider1.Clear();
                errorProvider1.SetError(tbTelefon, "Introduceti telefonul ");
            }
            else
            {
                errorProvider1.Clear();
                try
                {
                    int idMaxClient  = getMaxIdFromDbTable("clienti");
                    int idMaxComanda = getMaxIdFromDbTable("inchirieri");


                    string   nume     = tbNume.Text;
                    string   prenume  = tbPrenume.Text;
                    string   adresa   = tbAdresa.Text;
                    string   telefon  = tbTelefon.Text;
                    string   sex      = cbSex.SelectedItem.ToString();
                    int      varsta   = Convert.ToInt32(tbVarsta.Text);
                    string   username = tbUsername.Text;
                    string   password = tbPassword.Text;
                    int      idFilm   = Filme.findMovieIdByName(connString, cbFilm.SelectedItem.ToString());
                    DateTime data     = Convert.ToDateTime(dateTimePicker.Text);

                    client = new Clienti(idMaxClient, nume, prenume, adresa, telefon, sex, varsta, username, password);
                    client.save(connString);

                    Inchirieri inchiriere = new Inchirieri(idMaxComanda, data, idFilm, idMaxClient);
                    inchiriere.save(connString);

                    MessageBox.Show("Succes");
                    this.Hide();
                    afisareFilme form = new afisareFilme();
                    form.ShowDialog();
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                finally
                {
                    conn.Close();
                }
            }
        }