private void button1_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { int id = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); MySqlConnection konekcij = ConnectionPool.checkOutConnection(); MySqlCommand cm = konekcij.CreateCommand(); cm.CommandText = "update ski_obuca set Nedostupan=1 where IdObuce=" + id + ";"; cm.ExecuteNonQuery(); MessageBox.Show("Uspješno ste obrisali stavku!"); } }
public void provjera() { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand c = konekcija.CreateCommand(); c.CommandText = "select * from iznajmljivanjaSvihKorisnikaKojaNisuVracena;"; MySqlDataReader read = c.ExecuteReader(); var dataTable = new DataTable(); dataTable.Load(read); dataGridView1.DataSource = dataTable; dataGridView1.Columns[0].Visible = false; }
private void button2_Click(object sender, EventArgs e) { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmd = konekcija.CreateCommand(); cmd.CommandText = "insert into servisiranje (DatumServisiranja,IdOpreme,JMBGZaposleni,Opis) values(current_date()," + id + "," + idservisera + ",'" + textBox1.Text.ToString() + "');"; if (cmd.ExecuteNonQuery().ToString().Equals("1")) { MessageBox.Show("Uspješno ste dodali servis !"); } konekcija.Close(); //forma.Show(); this.Dispose(); }
public void provjera() { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmddd = konekcija.CreateCommand(); cmddd.CommandText = "call listaSvihRezervacijaKorisnikBuducnost('" + jmbgkorisnik + "');"; MySqlDataReader readdd = cmddd.ExecuteReader(); var dataTable = new DataTable(); dataTable.Load(readdd); dataGridView1.DataSource = dataTable; dataGridView1.Columns[0].Visible = false; konekcija.Close(); }
private void button1_Click(object sender, EventArgs e) { MySqlConnection connection = ConnectionPool.checkOutConnection(); MySqlCommand command = connection.CreateCommand(); int id_proizvodjaca = Int32.Parse(comboBox1.SelectedValue.ToString()); int id_tipa = Int32.Parse(comboBox2.SelectedValue.ToString()); command.CommandText = "insert into ski_obuca (Naziv, Boja, Cijena,Broj,IdProizvodjaca,IdTipa,Nedostupan) " + "values" + "('" + textBox1.Text + "', '" + textBox2.Text + "', '" + textBox3.Text + "', '" + textBox4.Text + "', " + id_proizvodjaca + "," + id_tipa + ",0);"; command.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Uspjesno ste dodali novu obuću!"); this.Dispose(); }
private void button7_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmdd = konekcija.CreateCommand(); cmdd.CommandText = "update iznajmljivanje set DatumVracanja=current_date() where IdIznajmljivanja=" + int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()) + ";"; cmdd.ExecuteNonQuery(); MessageBox.Show("Uspješno ste izvršili upit! "); } else { MessageBox.Show("Niste izabrali nijednu rezervaciju! "); } }
private void ServiserForma_Load(object sender, EventArgs e) { radioButton1.Checked = true; radioButton4.Checked = true; MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmd = konekcija.CreateCommand(); cmd.CommandText = "SELECT Ime from OSOBA where jmbg=" + jmbgserviser; MySqlDataReader read = cmd.ExecuteReader(); while (read.Read()) { label6.Text = read["Ime"].ToString(); } konekcija.Close(); provjera(); }
private void button8_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmd = konekcija.CreateCommand(); DateTime aa = DateTime.Today; cmd.CommandText = "update rezervacija set Otkazano=1 where IdRezervacije=" + int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()) + ";"; cmd.ExecuteNonQuery(); MessageBox.Show("Uspjesno ste otkazali rezervaciju!"); } else { MessageBox.Show("Niste izabrali nijednu rezervaciju !"); } }
public void provjera() { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmd = konekcija.CreateCommand(); if (radioButton5.Checked) { if (radioButton1.Checked) { cmd.CommandText = "SELECT * FROM dostupneSkijeRezervacijaDanas"; } else if (radioButton2.Checked) { cmd.CommandText = "SELECT * FROM skijeNaServisuDanas"; } else { cmd.CommandText = "SELECT * FROM iznajmljeneSkijeDanas"; } } else { if (radioButton1.Checked) { cmd.CommandText = "SELECT * FROM dostupniSnowboardiRezervacijaDanas"; } else if (radioButton2.Checked) { cmd.CommandText = "SELECT * FROM snowboardnaservisuDanas"; } else { cmd.CommandText = "SELECT * FROM iznajmljeniSnowboardDanas"; } } MySqlDataAdapter myAdapter = new MySqlDataAdapter(cmd); // Adapter DataSet ds = new DataSet(); myAdapter.Fill(ds); // DataSet <- Adapter dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].Visible = false; }
public void provjera() { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmdd = konekcija.CreateCommand(); if (radioButton4.Checked) //obuca { cmdd.CommandText = "call listaRezervisaneObuceId(" + id + "); "; } else { cmdd.CommandText = "call listaRezervisaneOpremeId(" + id + "); "; } MySqlDataReader readd = cmdd.ExecuteReader(); var dataTable = new DataTable(); dataTable.Load(readd); dataGridView1.DataSource = dataTable; dataGridView1.Columns[0].Visible = false; }
public void provjera() { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand c = konekcija.CreateCommand(); if (radioButton1.Checked) //REZERVACIJE { c.CommandText = "select * from rezervacijeBuduceSvihKorisnika;"; } else //IZNAJMLJIVANJA { c.CommandText = "select * from iznajmljivanjaDanasSvihKorisnika;"; } MySqlDataReader read = c.ExecuteReader(); var dataTable = new DataTable(); dataTable.Load(read); dataGridView1.DataSource = dataTable; dataGridView1.Columns[0].Visible = false; }
private void DodajObucu_Load(object sender, EventArgs e) { MySqlConnection connection = ConnectionPool.checkOutConnection(); MySqlCommand command = connection.CreateCommand(); command.CommandText = "select IdProizvodjaca,Naziv from Proizvodjac;"; MySqlDataReader reader = command.ExecuteReader(); Dictionary <int, String> proizvodjaci = new Dictionary <int, string>(); proizvodjaci.Add(0, "Izaberi proizvođaca"); while (reader.Read()) { proizvodjaci.Add(Int32.Parse(reader["IdProizvodjaca"].ToString()), reader["Naziv"].ToString()); } comboBox1.DataSource = new BindingSource(proizvodjaci, null); comboBox1.DisplayMember = "Value"; comboBox1.ValueMember = "Key"; comboBox1.SelectedIndex = 0; reader.Close(); MySqlCommand commandd = connection.CreateCommand(); commandd.CommandText = "select IdTipa,Naziv from Tip;"; MySqlDataReader readerr = commandd.ExecuteReader(); Dictionary <int, String> tipovi = new Dictionary <int, string>(); tipovi.Add(0, "Izaberi tip"); while (readerr.Read()) { tipovi.Add(Int32.Parse(readerr["IdTipa"].ToString()), readerr["Naziv"].ToString()); } comboBox2.DataSource = new BindingSource(tipovi, null); comboBox2.DisplayMember = "Value"; comboBox2.ValueMember = "Key"; comboBox2.SelectedIndex = 0; connection.Close(); }
private void button1_Click(object sender, EventArgs e) { int ukupanBroj = rezObuca.Count + rezOprema.Count; if (ukupanBroj != 0) { DateTime aa = DateTime.Now; String dat = datumPocetkaDateTimePicker.Value.Date.ToString("yyyy-MM-dd"); long idPK = 0; if (!(izna) && dat.Equals(aa.Date.ToString("yyyy-MM-dd")) && int.Parse(aa.Hour.ToString()) > 11) { MessageBox.Show("U ovom terminu nije moguće rezervisati stavku!"); } else { MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmd = konekcija.CreateCommand(); if (izna) { cmd.CommandText = "insert into iznajmljivanje (JMBGZaposleni,JMBG,IznajmljenoOdDatuma,CijenaIznajmljivanja) values('" + jmbgradnik + "','" + jmbgkorisnik + "','" + aa.Date.ToString("yyyy.MM.dd") + "',0);"; } else { cmd.CommandText = "insert into rezervacija (JMBGZaposleni,JMBG,RezervisanoZaDan,DatumRezervacije,Otkazano) values('" + jmbgradnik + "','" + jmbgkorisnik + "','" + dat + "','" + aa.Date.ToString("yyyy.MM.dd") + "',0);"; } cmd.ExecuteNonQuery(); idPK = cmd.LastInsertedId; for (int i = 0; i < rezObuca.Count; i++) { MySqlCommand cmdd = konekcija.CreateCommand(); if (izna) { cmdd.CommandText = "insert into i_obuca (IdIznajmljivanja,IdObuce) values(" + idPK + "," + rezObuca.ElementAt(i) + ");"; } else { cmdd.CommandText = "insert into r_obuca (IdRezervacije,IdObuce) values(" + idPK + "," + rezObuca.ElementAt(i) + ");"; } cmdd.ExecuteNonQuery(); } for (int j = 0; j < rezOprema.Count; j++) { MySqlCommand cmdd = konekcija.CreateCommand(); if (izna) { cmdd.CommandText = "insert into i_oprema (IdIznajmljivanja,IdOpreme) values(" + idPK + "," + rezOprema.ElementAt(j) + ");"; } else { cmdd.CommandText = "insert into r_oprema (IdRezervacije,IdOpreme) values(" + idPK + "," + rezOprema.ElementAt(j) + ");"; } cmdd.ExecuteNonQuery(); } MessageBox.Show("Uspješno !"); rezOprema.Clear(); rezObuca.Clear(); label4.Text = rezObuca.Count + rezOprema.Count + ""; provjera(); } } else { MessageBox.Show("Niste izabrali nijednu stavku!"); } }
private void button7_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count > 0) { if (radioButton1.Checked) { string jmbgz = ""; MySqlConnection konekcija = ConnectionPool.checkOutConnection(); MySqlCommand cmd = konekcija.CreateCommand(); cmd.CommandText = "call provjeraCijaJeRezervacija(" + int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()) + ");"; MySqlDataReader read = cmd.ExecuteReader(); string dat = ""; DateTime aa = DateTime.Today; while (read.Read()) { dat = read["RezervisanoZaDan"].ToString(); jmbgz = read["JMBG"].ToString(); } read.Close(); if (jmbgz.Equals(jmbgkorisnik) && dat.Substring(0, 9).Equals(aa.Date.ToString("M/d/yyyy"))) { long idPK = 0; MySqlCommand cmdd = konekcija.CreateCommand(); cmdd.CommandText = "update rezervacija set Otkazano=1 where IdRezervacije=" + int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()) + ";"; cmdd.ExecuteNonQuery(); MySqlCommand c = konekcija.CreateCommand(); c.CommandText = "insert into iznajmljivanje (JMBGZaposleni,JMBG,IznajmljenoOdDatuma,CijenaIznajmljivanja) values('" + jmbgradnik + "','" + jmbgkorisnik + "','" + aa.Date.ToString("yyyy-MM-dd") + "',999);"; c.ExecuteNonQuery(); idPK = c.LastInsertedId; MySqlCommand cmddd = konekcija.CreateCommand(); cmddd.CommandText = "call svaRezervisanaObucaId(" + int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()) + ");"; MySqlDataReader readd = cmddd.ExecuteReader(); int idOb; double cije; while (readd.Read()) { idOb = int.Parse(readd["IdObuce"].ToString()); cije = double.Parse(readd["Cijena"].ToString()); MySqlConnection konekcijaa = ConnectionPool.checkOutConnection(); MySqlCommand cm = konekcijaa.CreateCommand(); cm.CommandText = "insert into i_obuca values(" + idPK + "," + idOb + "," + cije + ");"; cm.ExecuteNonQuery(); } readd.Close(); MySqlCommand cmde = konekcija.CreateCommand(); cmde.CommandText = "call svaRezervisanaOpremaId(" + int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()) + ");"; MySqlDataReader readder = cmde.ExecuteReader(); while (readder.Read()) { idOb = int.Parse(readder["IdOpreme"].ToString()); cije = double.Parse(readder["Cijena"].ToString()); MySqlConnection konekcij = ConnectionPool.checkOutConnection(); MySqlCommand cm = konekcij.CreateCommand(); cm.CommandText = "insert into i_oprema values(" + idPK + "," + idOb + "," + cije + ");"; cm.ExecuteNonQuery(); } readder.Close(); MessageBox.Show("Vasa rezervacija je prosla !"); //provjera(); } else { MessageBox.Show("Nije moguce preuzeti rezervaciju"); } } else { MessageBox.Show("Niste izabrali nijednu rezervaciju !"); } } else { MessageBox.Show("Niste izabrali nijednu rezervaciju !"); } }