public static ObservableCollection <TipNamestaja> GetAllTipNamestaja() { var listaTipovaNamestaja = new ObservableCollection <TipNamestaja>(); using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RS18-2012"].ConnectionString)) { SqlCommand scmd = conn.CreateCommand(); SqlDataAdapter sda = new SqlDataAdapter(); DataSet ds = new DataSet(); scmd.CommandText = "SELECT * FROM TipNamestaja WHERE Obrisan=0;"; sda.SelectCommand = scmd; //izvrsavanje upita sda.Fill(ds, "TipNamestaja"); foreach (DataRow row in ds.Tables["TipNamestaja"].Rows) { var tn = new TipNamestaja(); tn.Id = int.Parse(row["Id"].ToString()); tn.Naziv = row["Naziv"].ToString(); tn.Obrisan = bool.Parse(row["Obrisan"].ToString()); listaTipovaNamestaja.Add(tn); } } return(listaTipovaNamestaja); }
public static void Update(TipNamestaja utn) { using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RS18-2012"].ConnectionString)) { conn.Open(); SqlCommand scmd = conn.CreateCommand(); scmd.CommandText = "UPDATE TipNamestaja SET Naziv=@Naziv, Obrisan=@Obrisan WHERE Id=@TId;"; scmd.CommandText += "SELECT SCOPE_IDENTITY();"; scmd.Parameters.AddWithValue("TId", utn.Id); scmd.Parameters.AddWithValue("Naziv", utn.Naziv); scmd.Parameters.AddWithValue("Obrisan", utn.Obrisan); scmd.ExecuteNonQuery(); } foreach (var tip in Projekat.Instance.TipNamestaja) { if (utn.Id == tip.Id) { tip.Naziv = utn.Naziv; tip.Obrisan = utn.Obrisan; } } }
public static TipNamestaja Create(TipNamestaja ctn) { using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["RS18-2012"].ConnectionString)) { conn.Open(); SqlCommand scmd = conn.CreateCommand(); scmd.CommandText = "INSERT INTO TipNamestaja (Naziv, Obrisan) VALUES(@Naziv, @Obrisan);"; scmd.CommandText += "SELECT SCOPE_IDENTITY();"; scmd.Parameters.AddWithValue("Naziv", ctn.Naziv); scmd.Parameters.AddWithValue("Obrisan", ctn.Obrisan); //izvrsavanje upita ctn.Id = int.Parse(scmd.ExecuteScalar().ToString()); } Projekat.Instance.TipNamestaja.Add(ctn); return(ctn); }
public static void Delete(TipNamestaja dtn) { dtn.Obrisan = true; Update(dtn); }