public static StavkaUsluge Create(StavkaUsluge u)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
try
{
cmd.CommandText = "INSERT INTO StavkeUsluge (UslugaId) VALUES (@UslugaId);";
cmd.CommandText += "SELECT SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("UslugaId", u.UslugaId);
u.Id = int.Parse(cmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
MessageBox.Show("Neuspesno dodavanje", "Greska");
}
}
Projekat.Instance.StavkeUsluge.Add(u);
return(u);
}
public static ObservableCollection <StavkaUsluge> GetAll()
{
var stavka = new ObservableCollection <StavkaUsluge>();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
cmd.CommandText = "SELECT * FROM StavkeUsluge;";
da.SelectCommand = cmd;
da.Fill(ds, "StavkeUsluge");
foreach (DataRow row in ds.Tables["StavkeUsluge"].Rows)
{
var u = new StavkaUsluge();
u.Id = int.Parse(row["Id"].ToString());
u.UslugaId = int.Parse(row["UslugaId"].ToString());
u.IdProdaje = int.Parse(row["IdProdaje"].ToString());
stavka.Add(u);
}
}
return(stavka);
}
