public static ObservableCollection <StavkaProdajeNamestaj> GetAll()
{
var spn = new ObservableCollection <StavkaProdajeNamestaj>();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM StavkaNamestaja ";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "StavkaNamestaja"); // Query se izvrsava
foreach (DataRow row in ds.Tables["StavkaNamestaja"].Rows)
{
var s = new StavkaProdajeNamestaj();
s.Id = int.Parse(row["Id"].ToString());
s.RacunId = int.Parse(row["RacunId"].ToString());
s.NamestajId = int.Parse(row["NamestajId"].ToString());
s.Kolicina = int.Parse(row["Kolicina"].ToString());
spn.Add(s);
}
return(spn);
}
}
public static void Update(StavkaProdajeNamestaj s)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "Update StavkaNamestaja set RacunId=@RacunId,NamestajId=@NamestajId,Kolicina=@Kolicina where Id=@Id";
cmd.Parameters.AddWithValue("Id", s.Id);
cmd.Parameters.AddWithValue("NamestajId", s.NamestajId);
cmd.Parameters.AddWithValue("RacunId", s.RacunId);
cmd.Parameters.AddWithValue("Kolicina", s.Kolicina);
cmd.ExecuteNonQuery();
foreach (var spn in Projekat.Instance.spn)
{
if (spn.Id == s.Id)
{
spn.RacunId = s.RacunId;
spn.NamestajId = s.NamestajId;
spn.Kolicina = s.Kolicina;
break;
}
}
}
}
public static StavkaProdajeNamestaj Create(StavkaProdajeNamestaj s)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = $"Insert into StavkaNamestaja (RacunId,NamestajId,Kolicina) Values(@RacunId,@NamestajId,@Kolicina);";//razmisli o ne unosenju obrisan pri dodavanju vec to u bazi
cmd.CommandText += "Select scope_identity();";
cmd.Parameters.AddWithValue("RacunId", s.RacunId);
cmd.Parameters.AddWithValue("NamestajId", s.NamestajId);
cmd.Parameters.AddWithValue("Kolicina", s.Kolicina);
int newId = int.Parse(cmd.ExecuteScalar().ToString()); //es izvrsava query
s.Id = newId;
}
Projekat.Instance.spn.Add(s);//obrati paznju {azurira i stanje modela}
return(s);
}
public static void Delete(StavkaProdajeNamestaj n)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "Delete StavkaNamestaja where Id=@Id";
cmd.Parameters.AddWithValue("Id", n.Id);
cmd.ExecuteNonQuery();
foreach (var spn in Projekat.Instance.spn)
{
if (spn.Id == n.Id)
{
Projekat.Instance.spn.Remove(spn);
break;
}
}
}
}
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");
}
