public static ObservableCollection <ProdajaNamestaja> GetAll()
{
var namestaj = new ObservableCollection <ProdajaNamestaja>();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SELECT * FROM Racun";
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(ds, "Racun"); // izvrsava se query nad bazom
foreach (DataRow row in ds.Tables["Racun"].Rows)
{
var tn = new ProdajaNamestaja();
tn.Id = int.Parse(row["Id"].ToString());
tn.DatumProdaje = DateTime.Parse(row["DatumProdaje"].ToString());
tn.BrojRacuna = row["BrojRacuna"].ToString();
tn.Kupac = row["Kupac"].ToString();
tn.UkupnaCena = double.Parse(row["UkupnaCena"].ToString());
tn.Obrisan = bool.Parse(row["Obrisan"].ToString());
namestaj.Add(tn);
}
}
return(namestaj);
}
public static ProdajaNamestaja Create(ProdajaNamestaja tn)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
DataSet ds = new DataSet();
cmd.CommandText = "INSERT INTO Racun (Id, DatumProdaje, BrojRacuna, Kupac, UkupnaCena, Obrisan) VALUES (@Id, @DatumProdaje, @BrojRacuna, @Kupac, @UkupnaCena, @Obrisan);";
cmd.CommandText += "SELECT SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("Id", tn.Id);
cmd.Parameters.AddWithValue("DatumProdaje", tn.DatumProdaje);
cmd.Parameters.AddWithValue("BrojRacuna", tn.BrojRacuna);
cmd.Parameters.AddWithValue("Kupac", tn.Kupac);
cmd.Parameters.AddWithValue("UkupnaCena", tn.UkupnaCena);
cmd.Parameters.AddWithValue("Obrisan", tn.Obrisan);
int newId = int.Parse(cmd.ExecuteScalar().ToString()); // ExecuteScalar izvrsava query
tn.Id = newId;
}
Projekat.Instace.prodajanamestaja.Add(tn);
return(tn);
}
