public static ObservableCollection <Korisnik> PretragaKorisnika(string unos, TipPretrage tipPretrage)
{
var korisnici = new ObservableCollection <Korisnik>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
switch (tipPretrage)
{
case TipPretrage.IME:
cmd.CommandText = "SELECT * FROM Korisnik WHERE Ime LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.PREZIME:
cmd.CommandText = "SELECT * FROM Korisnik WHERE Prezime LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.EMAIL:
cmd.CommandText = "SELECT * FROM Korisnik WHERE Email LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.USERNAME:
cmd.CommandText = "SELECT * FROM Korisnik WHERE Username LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.TIPKORISNIKA:
cmd.CommandText = "SELECT * FROM Korisnik WHERE TipKorisnika LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.USTANOVAID:
cmd.CommandText = "SELECT * FROM Korisnik WHERE UstanovaId LIKE @unos AND Obrisano = 0;";
break;
}
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Korisnik");
foreach (DataRow row in ds.Tables["Korisnik"].Rows)
{
var k = new Korisnik();
k.Id = int.Parse(row["Id"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.Email = row["Email"].ToString();
k.Username = row["Username"].ToString();
k.Password = row["Password"].ToString();
k.TipKorisnika = (ETipKorisnika)Enum.Parse(typeof(ETipKorisnika), (row["TipKorisnika"].ToString()));
k.UstanovaId = int.Parse(row["UstanovaId"].ToString());
k.Obrisano = bool.Parse(row["Obrisano"].ToString());
korisnici.Add(k);
}
}
return(korisnici);
}
public static ObservableCollection <Termin> PretragaTermina(string unos, TipPretrage tipPretrage)
{
var termini = new ObservableCollection <Termin>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
switch (tipPretrage)
{
case TipPretrage.TIPNASTAVE:
cmd.CommandText = "SELECT * FROM Termin WHERE TipNastave LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.VREMEZAUZECAOD:
cmd.CommandText = "SELECT * FROM Termin WHERE VremeZauzecaOd LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.VREMEZAUZECADO:
cmd.CommandText = "SELECT * FROM Termin WHERE VremeZauzecaDo LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.DAN:
cmd.CommandText = "SELECT * FROM Termin WHERE Dan LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.KORISNIKID:
cmd.CommandText = "SELECT * FROM Termin WHERE KorisnikId LIKE @unos AND Obrisano = 0;";
break;
}
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Termin");
foreach (DataRow row in ds.Tables["Termin"].Rows)
{
var t = new Termin();
t.Id = int.Parse(row["Id"].ToString());
t.TipNastave = (ETipNastave)Enum.Parse(typeof(ETipNastave), (row["TipNastave"].ToString()));
t.VremeZauzecaOd = DateTime.Parse(row["VremeZauzecaOd"].ToString());
t.VremeZauzecaDo = DateTime.Parse(row["VremeZauzecaDo"].ToString());
t.Dan = row["Dan"].ToString();
t.KorisnikId = int.Parse(row["KorisnikId"].ToString());
t.Obrisano = bool.Parse(row["Obrisano"].ToString());
termini.Add(t);
}
}
return(termini);
}
public static ObservableCollection <Ucionica> PretragaUcionice(string unos, TipPretrage tipPretrage)
{
var ucionice = new ObservableCollection <Ucionica>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
switch (tipPretrage)
{
case TipPretrage.BROJUCIONICE:
cmd.CommandText = "SELECT * FROM Ucionica WHERE BrojUcionice LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.BROJMESTA:
cmd.CommandText = "SELECT * FROM Ucionica WHERE BrojMesta LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.TIPUCIONICE:
cmd.CommandText = "SELECT * FROM Ucionica WHERE TipUcionice LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.USTANOVAID:
cmd.CommandText = "SELECT * FROM Ucionica WHERE UstanovaId LIKE @unos AND Obrisano = 0;";
break;
}
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Ucionica");
foreach (DataRow row in ds.Tables["Ucionica"].Rows)
{
var u = new Ucionica();
u.Id = int.Parse(row["Id"].ToString());
u.BrojUcionice = int.Parse(row["BrojUcionice"].ToString());
u.BrojMesta = int.Parse(row["BrojMesta"].ToString());
u.TipUcionice = (ETipUcionice)Enum.Parse(typeof(ETipUcionice), (row["TipUcionice"].ToString()));
u.Obrisano = bool.Parse(row["Obrisano"].ToString());
u.UstanovaId = int.Parse(row["UstanovaId"].ToString());
ucionice.Add(u);
}
}
return(ucionice);
}
public static ObservableCollection <Namestaj> PretragaNamestaja(string unos, TipPretrage tipPretrage)
{
var namestaj = new ObservableCollection <Namestaj>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
switch (tipPretrage)
{
case TipPretrage.NAZIV:
cmd.CommandText = "SELECT * FROM Namestaj n INNER JOIN TipNamestaja tn ON n.TipNamestajaId = tn.Id WHERE n.Naziv LIKE @unos AND n.Obrisan = 0;";
break;
case TipPretrage.SIFRA:
cmd.CommandText = "SELECT * FROM Namestaj n INNER JOIN TipNamestaja tn ON n.TipNamestajaId = tn.Id WHERE n.Sifra LIKE @unos AND n.Obrisan = 0;";
break;
case TipPretrage.TIPNAMESTAJA:
cmd.CommandText = "SELECT * FROM Namestaj n INNER JOIN TipNamestaja tn ON n.TipNamestajaId = tn.Id WHERE tn.Naziv LIKE @unos AND n.Obrisan = 0;";
break;
}
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Namestaj");
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var n = new Namestaj();
n.Id = int.Parse(row["Id"].ToString());
n.TipNamestajaId = int.Parse(row["TipNamestajaId"].ToString());
n.AkcijaId = int.Parse(row["AkcijskaProdajaId"].ToString());
n.Naziv = row["Naziv"].ToString();
n.Sifra = row["Sifra"].ToString();
n.JedinicnaCena = double.Parse(row["Cena"].ToString());
n.KolicinaUMagacinu = int.Parse(row["Kolicina"].ToString());
n.CenaNaAkciji = double.Parse(row["CenaNaAkciji"].ToString());
n.Obrisan = bool.Parse(row["Obrisan"].ToString());
namestaj.Add(n);
}
}
return(namestaj);
}
public static ObservableCollection <Ustanova> PretragaUstanove(string unos, TipPretrage tipPretrage)
{
var ustanove = new ObservableCollection <Ustanova>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
switch (tipPretrage)
{
case TipPretrage.SIFRAUSTANOVE:
cmd.CommandText = "SELECT * FROM Ustanova WHERE SifraUstanove LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.NAZIV:
cmd.CommandText = "SELECT * FROM Ustanova WHERE Naziv LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.LOKACIJA:
cmd.CommandText = "SELECT * FROM Ustanova WHERE Lokacija LIKE @unos AND Obrisano = 0;";
break;
}
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Ustanova");
foreach (DataRow row in ds.Tables["Ustanova"].Rows)
{
var u = new Ustanova();
u.Id = int.Parse(row["Id"].ToString());
u.SifraUstanove = row["SifraUstanove"].ToString();
u.Naziv = row["Naziv"].ToString();
u.Lokacija = row["Lokacija"].ToString();
u.Obrisano = bool.Parse(row["Obrisano"].ToString());
ustanove.Add(u);
}
}
return(ustanove);
}
public static ObservableCollection <Akcija> FindSort(String parametarZaPretragu, TipPretrage tipPretrage, DateTime?dateTime, int sort)
{
try
{
var listaPretraga = new ObservableCollection <Akcija>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
switch (tipPretrage)
{
case TipPretrage.DatumPocetka:
cmd.CommandText = @"SELECT * " +
"FROM Akcija " +
"WHERE Obrisan = 0 and DatumPocetka >= @dateTime ";
cmd.CommandText += SortBy(sort);
cmd.Parameters.Add(new SqlParameter("@dateTime", dateTime));
break;
case TipPretrage.DatumZavrsetka:
cmd.CommandText = @"SELECT * " +
"FROM Akcija " +
"WHERE Obrisan = 0 and DatumZavrsetka <= @dateTime ";
cmd.CommandText += SortBy(sort);
cmd.Parameters.Add(new SqlParameter("@dateTime", dateTime));
break;
case TipPretrage.Naziv:
cmd.CommandText = @"SELECT * " +
"FROM Akcija " +
"WHERE Obrisan = 0 and Naziv like @ParametarNaziv ";
cmd.CommandText += SortBy(sort);
cmd.Parameters.Add(new SqlParameter("@ParametarNaziv", "%" + parametarZaPretragu + "%"));
break;
case TipPretrage.Namestaji:
cmd.CommandText = @"SELECT * " +
"FROM Akcija a inner join NaAkciji na on a.IdA = na.AkcijaId inner join Namestaj n on n.IdN = na.NamestajId " +
"WHERE a.Obrisan = 0 and na.Obrisan = 0 and n.Naziv like @ParametarNaziv ";
cmd.CommandText += SortBy(sort);
cmd.Parameters.Add(new SqlParameter("@ParametarNaziv", "%" + parametarZaPretragu + "%"));
break;
}
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
DataSet dsA = new DataSet(); // izvrsavanje upita
sqlDA.Fill(dsA, "Akcija");
foreach (DataRow row in dsA.Tables["Akcija"].Rows)
{
Akcija akcija = new Akcija();
akcija.Id = int.Parse(row["IdA"].ToString());
akcija.Naziv = row["Naziv"].ToString();
akcija.DatumPocetka = DateTime.Parse(row["DatumPocetka"].ToString());
akcija.DatumZavrsetka = DateTime.Parse(row["DatumZavrsetka"].ToString());
akcija.Obrisan = Boolean.Parse(row["Obrisan"].ToString());
listaPretraga.Add(akcija);
}
}
return(listaPretraga);
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom ucitavanje iz baze, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
return(null);
}
}
public static ObservableCollection <ProdajaNamestaja> PretragaProdaje(string unos, TipPretrage tipPretrage, DateTime?poDatumu)
{
var prodaja = new ObservableCollection <ProdajaNamestaja>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
switch (tipPretrage)
{
case TipPretrage.BROJRACUNA:
cmd.CommandText = "SELECT * FROM ProdajaNamestaja WHERE BrojRacuna LIKE @unos;";
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
break;
case TipPretrage.KUPAC:
cmd.CommandText = "SELECT * FROM ProdajaNamestaja WHERE Kupac LIKE @unos;";
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
break;
case TipPretrage.DATUM:
cmd.CommandText = "SELECT * FROM ProdajaNamestaja WHERE DatumProdaje = @poDatumu;";
cmd.Parameters.AddWithValue("poDatumu", poDatumu);
break;
}
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "ProdajaNamestaja");
foreach (DataRow row in ds.Tables["ProdajaNamestaja"].Rows)
{
var pn = new ProdajaNamestaja();
pn.Id = int.Parse(row["Id"].ToString());
pn.DatumProdaje = DateTime.Parse(row["DatumProdaje"].ToString());
pn.Kupac = row["Kupac"].ToString();
pn.BrojRacuna = row["BrojRacuna"].ToString();
prodaja.Add(pn);
}
}
return(prodaja);
}
public static ObservableCollection <Korisnik> FindSort(String parametarZaPretragu, TipPretrage tipPretrage, int sort)
{
try
{
var listaPretraga = new ObservableCollection <Korisnik>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
switch (tipPretrage)
{
case TipPretrage.Ime:
cmd.CommandText = @"SELECT * " +
"FROM Korisnik " +
"WHERE Obrisan = 0 and Ime like @Parametar ";
cmd.CommandText += SortBy(sort);
break;
case TipPretrage.Prezime:
cmd.CommandText = @"SELECT * " +
"FROM Korisnik " +
"WHERE Obrisan = 0 and Prezime like @Parametar ";
cmd.CommandText += SortBy(sort);
break;
case TipPretrage.KorisnickoIme:
cmd.CommandText = @"SELECT * " +
"FROM Korisnik " +
"WHERE Obrisan = 0 and KorisnickoIme like @Parametar ";
cmd.CommandText += SortBy(sort);
break;
}
cmd.Parameters.Add(new SqlParameter("@Parametar", "%" + parametarZaPretragu + "%"));
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
DataSet ds = new DataSet();
sqlDA.Fill(ds, "korisnik");
foreach (DataRow row in ds.Tables["korisnik"].Rows)
{
Korisnik k = new Korisnik();
k.Id = int.Parse(row["IdK"].ToString());
k.Ime = row["Ime"].ToString();
k.Prezime = row["Prezime"].ToString();
k.KorisnickoIme = row["KorisnickoIme"].ToString();
k.Lozinka = row["Lozinka"].ToString();
k.TipKorisnika = Enums.GetValue(row["TipKorisnika"].ToString());
k.Id = int.Parse(row["IdK"].ToString());
k.Obrisan = Boolean.Parse(row["Obrisan"].ToString());
listaPretraga.Add(k);
}
}
return(listaPretraga);
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom ucitavanje iz baze, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
return(null);
}
}
public static ObservableCollection <Namestaj> FindSort(String parametarZaPretragu, TipPretrage tipPretrage, int sort)
{
try
{
var listaPretraga = new ObservableCollection <Namestaj>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
switch (tipPretrage)
{
case TipPretrage.Naziv:
cmd.CommandText = @"SELECT * " +
"FROM Namestaj n inner join TipNamestaj tn on n.TipNamestajaId = tn.IdTN " +
"WHERE n.Naziv like @Parametar and n.Obrisan =0 ";
cmd.CommandText += SortBy(sort);
break;
case TipPretrage.Sifra:
cmd.CommandText = @"SELECT * " +
"FROM Namestaj n inner join TipNamestaj tn on n.TipNamestajaId = tn.IdTN " +
"WHERE n.Sifra like @Parametar and n.Obrisan =0 ";
cmd.CommandText += SortBy(sort);
break;
case TipPretrage.TipNamestaja:
cmd.CommandText = @"SELECT * " +
"FROM Namestaj n inner join TipNamestaj tn on n.TipNamestajaId = tn.IdTN " +
"WHERE tn.Naziv like @Parametar and n.Obrisan = 0 ";
cmd.CommandText += SortBy(sort);
break;
}
cmd.Parameters.Add(new SqlParameter("@Parametar", "%" + parametarZaPretragu + "%"));
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
DataSet ds = new DataSet(); // izvrsavanje upita
sqlDA.Fill(ds, "Namestaj");
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
Namestaj n = new Namestaj();
n.Id = int.Parse(row["IdN"].ToString());
n.Naziv = row["Naziv"].ToString();
n.Sifra = row["Sifra"].ToString();
n.JedinicnaCena = Double.Parse(row["Cena"].ToString());
n.KolicinaUMagacinu = int.Parse(row["Kolicina"].ToString());
n.TipNamestajaId = int.Parse(row["TipNamestajaId"].ToString());
n.Obrisan = Boolean.Parse(row["Obrisan"].ToString());
listaPretraga.Add(n);
}
}
return(listaPretraga);
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom ucitavanja iz baze, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
return(null);
}
}
public static ObservableCollection <AkcijskaProdaja> PretragaAkcije(string unos, TipPretrage tipPretrage, DateTime?poDatumu)
{
var akcija = new ObservableCollection <AkcijskaProdaja>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
switch (tipPretrage)
{
case TipPretrage.NAZIV:
cmd.CommandText = "SELECT * FROM AkcijskaProdaja WHERE Naziv LIKE @unos AND Obrisan = 0;";
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
break;
case TipPretrage.DATUMP:
cmd.CommandText = "SELECT * FROM AkcijskaProdaja WHERE Obrisan = 0 AND DatumPocetka = @poDatumu;";
cmd.Parameters.AddWithValue("poDatumu", poDatumu);
break;
case TipPretrage.DATUMZ:
cmd.CommandText = "SELECT * FROM AkcijskaProdaja WHERE DatumZavrsetka = @poDatumu AND Obrisan = 0;";
cmd.Parameters.AddWithValue("poDatumu", poDatumu);
break;
case TipPretrage.NAMESTAJ:
cmd.CommandText = "SELECT * FROM AkcijskaProdaja ap INNER JOIN NaAkciji na ON ap.Id = na.AkcijskaProdajaId INNER JOIN Namestaj n ON n.Id = na.NamestajId WHERE n.Naziv LIKE @unos;";
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
break;
}
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "AkcijskaProdaja");
foreach (DataRow row in ds.Tables["AkcijskaProdaja"].Rows)
{
var ap = new AkcijskaProdaja();
ap.Id = int.Parse(row["Id"].ToString());
ap.DatumPocetka = DateTime.Parse(row["DatumPocetka"].ToString());
ap.DatumZavrsetka = DateTime.Parse(row["DatumZavrsetka"].ToString());
ap.Popust = int.Parse(row["Popust"].ToString());
ap.Naziv = row["Naziv"].ToString();
ap.Obrisan = bool.Parse(row["Obrisan"].ToString());
akcija.Add(ap);
}
}
return(akcija);
}
public static ObservableCollection <Prodaja> FindSort(String parametarZaPretragu, TipPretrage tipPretrage, DateTime?date, int sort)
{
try
{
var listaPretraga = new ObservableCollection <Prodaja>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
switch (tipPretrage)
{
case TipPretrage.Kupac:
cmd.CommandText = @"SELECT * " +
"FROM Prodaja p " +
"WHERE p.Kupac like @Parametar and p.Obrisan = 0 ";
cmd.CommandText += SortBy(sort);
break;
case TipPretrage.Prodavac:
cmd.CommandText = @"SELECT * " +
"FROM Prodaja p inner join Korisnik k on p.ProdavacId = k.IdK " +
"WHERE k.KorisnickoIme like @Parametar and p.Obrisan = 0 ";
cmd.CommandText += SortBy(sort);
break;
case TipPretrage.BrRacuna:
cmd.CommandText = @"SELECT * " +
"FROM Prodaja p " +
"WHERE p.BrRacuna like @Parametar and p.Obrisan = 0 ";
cmd.CommandText += SortBy(sort);
break;
case TipPretrage.ProdatiNamestaj:
cmd.CommandText = @"SELECT * " +
"FROM Prodaja p INNER JOIN ProdajaNamestaj pn ON p.IdP = pn.ProdajaId INNER JOIN Namestaj n ON pn.NamestajId = n.IdN " +
"WHERE n.Naziv like @Parametar and p.Obrisan = 0 and pn.Obrisan = 0 and n.Obrisan = 0 ";
cmd.CommandText += SortBy(sort);
break;
case TipPretrage.DatumProdaje:
cmd.CommandText = @"SELECT * " +
"FROM Prodaja p " +
"WHERE p.DatumProdaje like @DatumProdaje and p.Obrisan = 0 ";
cmd.CommandText += SortBy(sort);
break;
}
cmd.Parameters.Add(new SqlParameter("@DatumProdaje", date));
cmd.Parameters.Add(new SqlParameter("@Parametar", "%" + parametarZaPretragu + "%"));
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
DataSet dsA = new DataSet(); // izvrsavanje upita
sqlDA.Fill(dsA, "Prodaja");
foreach (DataRow row in dsA.Tables["Prodaja"].Rows)
{
Prodaja prodaja = new Prodaja();
prodaja.Id = int.Parse(row["IdP"].ToString());
prodaja.DatumProdaje = DateTime.Parse(row["DatumProdaje"].ToString());
prodaja.BrRacuna = row["BrojRacuna"].ToString();
prodaja.Kupac = row["Kupac"].ToString();
prodaja.ProdavacId = int.Parse(row["ProdavacId"].ToString());
prodaja.UkupanIznos = double.Parse(row["UkupanIznos"].ToString());
prodaja.Obrisan = Boolean.Parse(row["Obrisan"].ToString());
listaPretraga.Add(prodaja);
}
}
return(listaPretraga);
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom ucitavanja iz baze, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
return(null);
}
}
