public static DodatnaUsluga Create(DodatnaUsluga du)
{
using (var con = new SqlConnection(Properties.Resources.connectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO DodatnaUsluga (Naziv, Cena, Obrisan) VALUES (@Naziv, @Cena, @Obrisan);";
cmd.CommandText += "SELECT SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("Naziv", du.Naziv);
cmd.Parameters.AddWithValue("Cena", du.Cena);
cmd.Parameters.AddWithValue("Obrisan", du.Obrisan);
du.Id = int.Parse(cmd.ExecuteScalar().ToString());
}
DodatnaUsluga.Add(du);
return(du);
}
