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