public static void Update(Namestaj n)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "Update Namestaj set Naziv=@Naziv,Obrisan=@Obrisan,Cena=@Cena,Kolicina=@Kolicina,AkcijaId=@Akcija,TipNamestajaId=@TipNamestaja where Id=@Id";
cmd.Parameters.AddWithValue("Id", n.Id);
cmd.Parameters.AddWithValue("Naziv", n.Naziv);
cmd.Parameters.AddWithValue("Obrisan", n.Obrisan);
cmd.Parameters.AddWithValue("Cena", n.Cena);
cmd.Parameters.AddWithValue("Kolicina", n.Kolicina);
cmd.Parameters.AddWithValue("Akcija", n.ak);
cmd.Parameters.AddWithValue("TipNamestaja", n.TipN);
cmd.ExecuteNonQuery();
foreach (var Namestaj in Projekat.Instance.namestaj)
{
if (Namestaj.Id == n.Id)
{
Namestaj.Naziv = n.Naziv;
Namestaj.Obrisan = n.Obrisan;
Namestaj.Cena = n.Cena;
Namestaj.Kolicina = n.Kolicina;
Namestaj.ak = n.ak;
Namestaj.TipN = n.TipN;
break;
}
}
}
}
//bilo gde ako koristis bazu koristi try catch
#region Database
public static ObservableCollection <Namestaj> GetAll()
{
var Namestaj = new ObservableCollection <Namestaj>();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
return(Namestaj);
}
}
private Projekat()
{
TN = TipNamestaja.GetAll();
//Console.WriteLine("1");
namestaj = Namestaj.GetAll();
// Console.WriteLine("2");
korisnik = Korisnik.GetAll();
// Console.WriteLine("3");
DU = DodatnaUsluga.GetAll();
// Console.WriteLine("4");
pn = Racun.GetAll();
// Console.WriteLine("5");
akcija = AkcijskaProdaja.GetAll();
// Console.WriteLine("6");
spn = StavkaProdajeNamestaj.GetAll();
// Console.WriteLine("7");
spdu = StavkaProdajeDU.GetAll();
// Console.WriteLine("8");
}
public static Namestaj Create(Namestaj n)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = $"Insert into Namestaj (Naziv,Obrisan,Cena,Kolicina,AkcijaId,TipNamestajaId) Values(@Naziv,@Obrisan,@Cena,@Kolicina,@Akcija,@TipNamestaja);";//razmisli o ne unosenju obrisan pri dodavanju vec to u bazi
cmd.CommandText += "Select scope_identity();";
cmd.Parameters.AddWithValue("Naziv", n.Naziv);
cmd.Parameters.AddWithValue("Obrisan", n.Obrisan);
cmd.Parameters.AddWithValue("Cena", n.Cena);
cmd.Parameters.AddWithValue("Kolicina", n.Kolicina);
try
{
cmd.Parameters.AddWithValue("Akcija", n.ak);
}
catch { }
cmd.Parameters.AddWithValue("TipNamestaja", n.TipN);
int newId = int.Parse(cmd.ExecuteScalar().ToString()); //es izvrsava query
n.Id = newId;
}
Projekat.Instance.namestaj.Add(n);//obrati paznju {azurira i stanje modela}
return(n);
}
public static ObservableCollection <Namestaj> Search(Prikaz p, String s)
{
var Namestaj = new ObservableCollection <Namestaj>();
switch (p)
{
case Prikaz.Naziv:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and Naziv like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Cena:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and Cena like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Kolicina:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and Kolicina like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.TipNamestaja:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and (Select Naziv from TipNamestaja where TipNamestajaId = Id ) like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Akcija:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 and (Select Popust from Akcija where AkcijaId = Id ) like '%'+@s+'%'";
cmd.Parameters.AddWithValue("s", s);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
}
return(Namestaj);
}
public static ObservableCollection <Namestaj> Sort(Prikaz p, NacinSortiranja nn)
{
var Namestaj = new ObservableCollection <Namestaj>();
switch (p)
{
case Prikaz.Naziv:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Naziv ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Naziv desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
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 Namestaj WHERE Obrisan=0 Order by Cena ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Cena desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Kolicina:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Kolicina ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by Kolicina desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.TipNamestaja:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by TipNamestajaId ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by TipNamestajaId desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
case Prikaz.Akcija:
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
if (nn == NacinSortiranja.asc)
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by AkcijaId ";
}
else
{
cmd.CommandText = "SELECT * FROM Namestaj WHERE Obrisan=0 Order by AkcijaId desc";
}
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Namestaj"); // Query se izvrsava
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
var tn = new Namestaj();
tn.Id = int.Parse(row["Id"].ToString());
tn.Naziv = row["Naziv"].ToString();
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
tn.Cena = double.Parse(row["Cena"].ToString());
tn.Kolicina = int.Parse(row["Kolicina"].ToString());
try
{
tn.ak = int.Parse(row["AkcijaId"].ToString());
}
catch { }
tn.TipN = int.Parse(row["TipNamestajaId"].ToString());
Namestaj.Add(tn);
}
}
break;
}
return(Namestaj);
}
public static void Delete(Namestaj n)
{
n.Obrisan = true;
Update(n);
}