public void ObrisiKorisnika(Korisnik k) { try { string query = "DELETE FROM Korisnik WHERE username = @username;"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlParameter username = new SqlParameter(); username.Value = k.Username; username.ParameterName = "username"; cmd.Parameters.Add(username); con.Open(); if (con.State == System.Data.ConnectionState.Open) { cmd.ExecuteNonQuery(); } con.Close(); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); } }
public int brisiDojavu(Dojava d) { try { String query = "DELETE FROM Dojava WHERE id = :id;"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlParameter id = new SqlParameter(); id.Value = d.Id; id.ParameterName = "id"; cmd.Parameters.Add(id); con.Open(); int r = 0; if (con.State == System.Data.ConnectionState.Open) { r = cmd.ExecuteNonQuery(); } con.Close(); return(r); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); return(0); } }
public void UcitajKorisnike() { try { Korisnici = new List <Korisnik>(); string query = "SELECT * FROM Korisnik;"; DBConnectionString s = new DBConnectionString(); using (SqlConnection c = new SqlConnection(s.GetString())) { c.Open(); if (c.State == System.Data.ConnectionState.Open) { SqlCommand sc = c.CreateCommand(); sc.CommandText = query; SqlDataReader reader = sc.ExecuteReader(); while (reader.Read()) { Korisnik k = new Korisnik(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetInt32(6), reader.GetInt32(7)); //k.DodajSliku(reader.Get) Korisnici.Add(k); } } c.Close(); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); } }
public void ucitajDojave() { try { Dojave = new List <Dojava>(); String query = "SELECT * FROM Dojava;"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { con.Open(); if (con.State == System.Data.ConnectionState.Open) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Dojava a = new Dojava(reader.GetInt32(0), reader.GetString(1), reader.GetDateTime(2), reader.GetString(3), reader.GetInt32(4)); Dojave.Add(a); } } con.Close(); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); } }
public void ucitajAdministratore() { try { Administratori = new List <Administrator>(); String query = "SELECT * FROM Administrator;"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { con.Open(); if (con.State == System.Data.ConnectionState.Open) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Administrator a = new Administrator(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4)); Administratori.Add(a); } } con.Close(); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); } }
public int unesiDojavu(Dojava d) { try { String query = "insert into Dojava " + "values (:Id,:,:Vrsta,:Ocjene,:ProcjenaCekanja,:Lokacija, :KorisnikID)"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlParameter id = new SqlParameter(); id.Value = d.Id; id.ParameterName = "id"; SqlParameter vrsta = new SqlParameter(); vrsta.Value = d.Vrsta; vrsta.ParameterName = "vrsta"; SqlParameter ocjene = new SqlParameter(); ocjene.Value = d.Ocjene; ocjene.ParameterName = "ocjene"; SqlParameter procjenaCekanja = new SqlParameter(); procjenaCekanja.Value = d.ProcjenaCekanja; procjenaCekanja.ParameterName = "procjenaCekanja"; SqlParameter lokacija = new SqlParameter(); lokacija.Value = d.Lokacija; lokacija.ParameterName = "lokacija"; SqlParameter korisnikID = new SqlParameter(); korisnikID.Value = d.KorisnikID; korisnikID.ParameterName = "korisnikID"; cmd.Parameters.Add(id); cmd.Parameters.Add(vrsta); cmd.Parameters.Add(ocjene); cmd.Parameters.Add(procjenaCekanja); cmd.Parameters.Add(lokacija); cmd.Parameters.Add(korisnikID); int k = cmd.ExecuteNonQuery(); cmd.Dispose(); return(k); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); return(0); } }
public int UrediKorisnika(Korisnik k) { try { String query = "UPDATE Korisnik " + "SET Ime = @Ime, Prezime= @Prezime, Username= @Username, Email=@Email " + "Where ID=@ID;"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlParameter ID = new SqlParameter(); ID.Value = k.ID; ID.ParameterName = "ID"; cmd.Parameters.Add(ID); SqlParameter Ime = new SqlParameter(); Ime.Value = k.Ime; Ime.ParameterName = "Ime"; cmd.Parameters.Add(Ime); SqlParameter Prezime = new SqlParameter(); Prezime.Value = k.Prezime; Prezime.ParameterName = "Prezime"; cmd.Parameters.Add(Prezime); SqlParameter Username = new SqlParameter(); Username.Value = k.Username; Username.ParameterName = "Username"; cmd.Parameters.Add(Username); SqlParameter Email = new SqlParameter(); Email.Value = k.Email; Email.ParameterName = "Email"; cmd.Parameters.Add(Email); con.Open(); int r = cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); return(r); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); return(0); } }
public int unesiAdministratora(Administrator a) { try { String query = "insert into Administrator " + "values (@id,@Ime,@Prezime,@Username,@Password)"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlParameter id = new SqlParameter(); id.Value = a.ID; id.ParameterName = "id"; SqlParameter Ime = new SqlParameter(); Ime.Value = a.Ime; Ime.ParameterName = "Ime"; SqlParameter Prezime = new SqlParameter(); Prezime.Value = a.Prezime; Prezime.ParameterName = "Prezime"; SqlParameter Username = new SqlParameter(); Username.Value = a.Username; Username.ParameterName = "Username"; SqlParameter Password = new SqlParameter(); Password.Value = a.Password; Password.ParameterName = "Password"; cmd.Parameters.Add(id); cmd.Parameters.Add(Ime); cmd.Parameters.Add(Prezime); cmd.Parameters.Add(Username); cmd.Parameters.Add(Password); int k = cmd.ExecuteNonQuery(); cmd.Dispose(); return(k); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); return(0); } }
public int UnesiKorisnika(Korisnik k) { try { String query = "insert into Korisnik " + "values (@ID,@Ime,@Prezime,@Username,@Password,@Email, @BrojDojava, @BrojAktivnihDojava, NULL)"; DBConnectionString s = new DBConnectionString(); using (SqlConnection con = new SqlConnection(s.GetString())) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = query; SqlParameter ID = new SqlParameter(); ID.Value = k.ID; ID.ParameterName = "ID"; cmd.Parameters.Add(ID); SqlParameter Ime = new SqlParameter(); Ime.Value = k.Ime; Ime.ParameterName = "Ime"; cmd.Parameters.Add(Ime); SqlParameter Prezime = new SqlParameter(); Prezime.Value = k.Prezime; Prezime.ParameterName = "Prezime"; cmd.Parameters.Add(Prezime); SqlParameter Username = new SqlParameter(); Username.Value = k.Username; Username.ParameterName = "Username"; cmd.Parameters.Add(Username); SqlParameter Password = new SqlParameter(); Password.Value = k.Password; Password.ParameterName = "Password"; cmd.Parameters.Add(Password); SqlParameter Email = new SqlParameter(); Email.Value = k.Email; Email.ParameterName = "Email"; cmd.Parameters.Add(Email); SqlParameter BrojDojava = new SqlParameter(); BrojDojava.Value = k.BrojDojava; BrojDojava.ParameterName = "BrojDojava"; cmd.Parameters.Add(BrojDojava); SqlParameter BrojAktivnihDojava = new SqlParameter(); BrojAktivnihDojava.Value = k.BrojAktivnihDojava; BrojAktivnihDojava.ParameterName = "BrojAktivnihDojava"; cmd.Parameters.Add(BrojAktivnihDojava); /*SqlParameter k_Slika = new SqlParameter(); * k_Slika.SqlDbType = System.Data.SqlDbType.Image; * k_Slika.Value = k.Slika; * k_Slika.ParameterName = "Slika";*/ con.Open(); int r = cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); return(r); } } catch (Exception e) { Debug.WriteLine("Exception: " + e.Message); return(0); } }