private void popisUslugaToolStripMenuItem_Click(object sender, EventArgs e) { FormPopisUsluga FormPopisUsluga1 = new FormPopisUsluga(); FormPopisUsluga1.Show(); }
private void btn_okRezervirajUslugu_Click(object sender, EventArgs e) { //Nađi ID usluge. string ID_usluge = ""; if (cb_usluga.SelectedIndex != -1) { try { connection = new SqlConnection(connectionstring); connection.Open(); } catch (SqlException ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); Application.ExitThread(); } SqlCommand cmd = new SqlCommand("SELECT Id_usluge,Ime_usluge FROM USLUGE", connection); try { SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); foreach (DataRow dr in dt.Rows) { if (dr["Ime_usluge"].ToString() == cb_usluga.SelectedItem.ToString()) { ID_usluge = dr["Id_usluge"].ToString(); } } } catch (SqlException ex) { MessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Unesite uslugu za koju želite rezervirati termin.", "Nije unesena usluga", MessageBoxButtons.OK, MessageBoxIcon.Error); } // Provjeri jesu li sva polja ispunjena. if (tb_gostimeusluga.Text == "" || tb_gostprezimeusluga.Text == "" || tb_gostoibusluga.Text == "") { MessageBox.Show("Sva polja moraju biti popunjena (osim tipa usluge).", "Prazna polja", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { // Izvrši INSERT. string query = "INSERT INTO REZERVACIJE_USLUGA VALUES (@id_usluge, @datum_vrijeme, @gost_ime, @gost_prezime, @gost_oib, @placeno)"; using (connection = new SqlConnection(connectionstring)) { using (SqlCommand cmd = new SqlCommand(query, connection)) { // Oblikuj datum i vrijeme. DateTime datumIVrijeme = DateTime.ParseExact(date_usluga.Text, "MM/dd/yyyy HH:mm:ss", CultureInfo.InvariantCulture); Console.WriteLine(datumIVrijeme); // Unesi parametre. connection.Open(); cmd.Parameters.AddWithValue("@id_usluge", ID_usluge); cmd.Parameters.AddWithValue("@datum_vrijeme", datumIVrijeme); cmd.Parameters.AddWithValue("@gost_ime", tb_gostimeusluga.Text); cmd.Parameters.AddWithValue("@gost_prezime", tb_gostprezimeusluga.Text); cmd.Parameters.AddWithValue("@gost_oib", tb_gostoibusluga.Text); cmd.Parameters.AddWithValue("@placeno", "false"); //cmd.ExecuteScalar(); cmd.ExecuteNonQuery(); } } FormPopisUsluga natrag = new FormPopisUsluga(); natrag.Show(); this.Close(); } }