public static Namestaj Create(Namestaj cn)
{
using (SqlConnection connection = new SqlConnection(Podaci.CONNECTION_STRING))
{
connection.Open();
SqlCommand cnamestajcommand = connection.CreateCommand();
cnamestajcommand.CommandText = "INSERT INTO NAMESTAJ(Naziv, Sifra, Kolicina, Obrisan) VALUES(@Naziv, @Sifra, @Kolicina, @Obrisan)";
cnamestajcommand.CommandText += "SELECT SCOPE_IDENTITY();";
cnamestajcommand.Parameters.AddWithValue("Naziv", cn.Naziv);
cnamestajcommand.Parameters.AddWithValue("Sifra", cn.Sifra);
cnamestajcommand.Parameters.AddWithValue("Kolicina", cn.Kolicina);
cnamestajcommand.Parameters.AddWithValue("Obrisan", cn.Obrisan);
}
Projekat.Instance.Namestaj.Add(cn);
return(cn);
}
public static ObservableCollection <Namestaj> UcitajNamestaj()
{
var lista = new ObservableCollection <Namestaj>();
using (SqlConnection connection = new SqlConnection(Podaci.CONNECTION_STRING))
{
connection.Open();
DataSet ds = new DataSet();
SqlCommand namestajcommand = connection.CreateCommand();
namestajcommand.CommandText = @"SELECT * FROM NAMESTAJ";
SqlDataAdapter daNamestaj = new SqlDataAdapter();
daNamestaj.SelectCommand = namestajcommand;
daNamestaj.Fill(ds, "NAMESTAJ");
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
Namestaj nam = new Namestaj();
nam.Id = (int)row["id"];
nam.Naziv = (string)row["naziv"];
nam.Sifra = (string)row["sifra"];
nam.Kolicina = (int)row["kolicina"];
// int Id = (int)row["Id"];
/*foreach (TipNamestaja tn in Podaci.Instance.TipoviNamestaja)
* {
* if (tn.Id == Id)
* nam.tipn = tn;
* }
* foreach (TipNamestaja tn in Podaci.Instance.TipoviNamestaja)
* {
* if (tn.Id == Id)
* nam.tipn = tn;
* }
*/
nam.Obrisan = (bool)row["obrisan"];
lista.Add(nam);
}
}
return(lista);
}
