public static ObservableCollection <Racun> Search(Prikaz p, String s) { var racun = new ObservableCollection <Racun>(); switch (p) { case Prikaz.DatumProdaje: using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM Racun WHERE Dp like '%'+@s+'%'"; cmd.Parameters.AddWithValue("s", s); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, "Racun"); // Query se izvrsava foreach (DataRow row in ds.Tables["Racun"].Rows) { var r = new Racun(); r.Id = int.Parse(row["Id"].ToString()); r.datumProdaje = DateTime.Parse(row["Dp"].ToString()); r.Kupac = row["Kupac"].ToString(); r.UkupnaCena = double.Parse(row["UkupnaCena"].ToString()); racun.Add(r); } } break; case Prikaz.Kupac: using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM Racun WHERE Kupac like '%'+@s+'%'"; cmd.Parameters.AddWithValue("s", s); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, "Racun"); // Query se izvrsava foreach (DataRow row in ds.Tables["Racun"].Rows) { var r = new Racun(); r.Id = int.Parse(row["Id"].ToString()); r.datumProdaje = DateTime.Parse(row["Dp"].ToString()); r.Kupac = row["Kupac"].ToString(); r.UkupnaCena = double.Parse(row["UkupnaCena"].ToString()); racun.Add(r); } } break; case Prikaz.Cena: using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM Racun WHERE UkupnaCena like '%'+@s+'%'"; cmd.Parameters.AddWithValue("s", s); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, "Racun"); // Query se izvrsava foreach (DataRow row in ds.Tables["Racun"].Rows) { var r = new Racun(); r.Id = int.Parse(row["Id"].ToString()); r.datumProdaje = DateTime.Parse(row["Dp"].ToString()); r.Kupac = row["Kupac"].ToString(); r.UkupnaCena = double.Parse(row["UkupnaCena"].ToString()); racun.Add(r); } } break; } return(racun); }
public static ObservableCollection <Racun> Sort(Prikaz p, NacinSortiranja nn) { var racun = new ObservableCollection <Racun>(); switch (p) { case Prikaz.DatumProdaje: using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); if (nn == NacinSortiranja.asc) { cmd.CommandText = "SELECT * FROM Racun Order by Dp"; } else { cmd.CommandText = "SELECT * FROM Racun Order by Dp desc"; } DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, "Racun"); // Query se izvrsava foreach (DataRow row in ds.Tables["Racun"].Rows) { var r = new Racun(); r.Id = int.Parse(row["Id"].ToString()); r.datumProdaje = DateTime.Parse(row["Dp"].ToString()); r.Kupac = row["Kupac"].ToString(); r.UkupnaCena = double.Parse(row["UkupnaCena"].ToString()); racun.Add(r); } } break; case Prikaz.Kupac: using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); if (nn == NacinSortiranja.asc) { cmd.CommandText = "SELECT * FROM Racun Order by Kupac"; } else { cmd.CommandText = "SELECT * FROM Racun Order by Kupac desc"; } DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, "Racun"); // Query se izvrsava foreach (DataRow row in ds.Tables["Racun"].Rows) { var r = new Racun(); r.Id = int.Parse(row["Id"].ToString()); r.datumProdaje = DateTime.Parse(row["Dp"].ToString()); r.Kupac = row["Kupac"].ToString(); r.UkupnaCena = double.Parse(row["UkupnaCena"].ToString()); racun.Add(r); } } break; case Prikaz.Cena: using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString)) { SqlCommand cmd = con.CreateCommand(); if (nn == NacinSortiranja.asc) { cmd.CommandText = "SELECT * FROM Racun Order by UkupnaCena"; } else { cmd.CommandText = "SELECT * FROM Racun Order by UkupnaCena desc"; } DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds, "Racun"); // Query se izvrsava foreach (DataRow row in ds.Tables["Racun"].Rows) { var r = new Racun(); r.Id = int.Parse(row["Id"].ToString()); r.datumProdaje = DateTime.Parse(row["Dp"].ToString()); r.Kupac = row["Kupac"].ToString(); r.UkupnaCena = double.Parse(row["UkupnaCena"].ToString()); racun.Add(r); } } break; } return(racun); }