public TipoviKursaEditWindow(TipKursa t, MOD m = MOD.DODAVANJE) : this() { this.original = t; this.mod = m; this.copyObj = original.Clone() as TipKursa; this.DataContext = copyObj; }
public NivoiIzmena(TipKursa j, MOD m = MOD.DODAVANJE) : this() { this.original = j; this.copyObj = (TipKursa)original.Clone(); this.mod = m; this.DataContext = copyObj; }
private void btnIzmena_Click(object sender, RoutedEventArgs e) { TipKursa t = dgNivoi.SelectedItem as TipKursa; NivoiIzmena nizm = new NivoiIzmena(t, MOD.IZMENA); nizm.ShowDialog(); }
private void btnDodavanje_Click(object sender, RoutedEventArgs e) { TipKursa t = new TipKursa("", "", true); NivoiIzmena nizm = new NivoiIzmena(t, MOD.DODAVANJE); nizm.ShowDialog(); }
private void bIzmeni_Click(object sender, RoutedEventArgs e) { TipKursa t = dgTipoviKursa.SelectedItem as TipKursa; TipoviKursaEditWindow tew = new TipoviKursaEditWindow(t, MOD.IZMENA); tew.ShowDialog(); }
private void bDodaj_Click(object sender, RoutedEventArgs e) { TipKursa t = new TipKursa(); TipoviKursaEditWindow tew = new TipoviKursaEditWindow(t); tew.ShowDialog(); }
private void Neaktivni(object sender, FilterEventArgs e) { TipKursa j = e.Item as TipKursa; if (j != null) { e.Accepted = j.Status == false; } }
private void PretragaNaziva(object sender, FilterEventArgs e) { TipKursa j = e.Item as TipKursa; if (j != null) { e.Accepted = j.Nivo.ToLower().Contains(tbNaziv.Text.ToLower()); } }
private void SviJezici(object sender, FilterEventArgs e) { TipKursa j = e.Item as TipKursa; if (j != null) { e.Accepted = j.Status == true || j.Status == false; } }
public TipKursa GetTipKursaById(long id) { TipKursa retVal = null; foreach (TipKursa j in Tipovi) { if (j.Id == id) { retVal = j; break; } } return(retVal); }
private void btnBrisanje_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Da li ste sigurni?", "Potvrda brisanja", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { TipKursa j = dgNivoi.SelectedItem as TipKursa; j.Status = false; btnBrisanje.IsEnabled = false; btnIzmena.IsEnabled = false; NivoDAO.Brisanje(j); } }
public static TipKursa GetTipKursaByID(long id) { TipKursa retVal = null; foreach (TipKursa k in Aplikacija.Instanca.TipoviKursa) { if (k.Id == id) { retVal = k; break; } } return(retVal); }
public static void Delete(TipKursa t) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"Update TipKursa Set Obrisan = 1 Where Id=@id"; cmd.Parameters.Add(new SqlParameter("@id", t.Id)); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "Greska", MessageBoxButton.OK); } } }
public static void Create(TipKursa t) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "Insert Into TipKursa Values (@nivo, 0)"; cmd.Parameters.Add(new SqlParameter("@nivo", t.Nivo)); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "Greska", MessageBoxButton.OK); throw new Exception(); } } }
public static void Read() { using (SqlConnection conn = new SqlConnection(Aplikacija.CONN_STR)) { conn.Open(); Aplikacija.Instanca.TipoviKursa = new ObservableCollection <TipKursa>(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"Select * from TipKursa Where Obrisan = 0"; SqlDataAdapter sqlDA = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sqlDA.Fill(ds, "tipovi_kursa"); foreach (DataRow row in ds.Tables["tipovi_kursa"].Rows) { TipKursa t = new TipKursa(); t.Id = (long)row["Id"]; t.Nivo = (string)row["Nivo"]; Aplikacija.Instanca.TipoviKursa.Add(t); } } }
public static void Brisanje(TipKursa k) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = @"update tipkursa set id=@id,sts=@sts where id=@id"; cmd.Parameters.Add(new SqlParameter("@id", k.Id)); cmd.Parameters.Add(new SqlParameter("@sts", k.Status)); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "nece", MessageBoxButton.OK); } } }
private void bObrisi_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Da li ste sigurni?", "Potvrda brisanja", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { TipKursa t = dgTipoviKursa.SelectedItem as TipKursa; foreach (Kurs k in Aplikacija.Instanca.Kursevi) { if (k.Tip.Id == t.Id) { MessageBox.Show("Ne mozete obrisati tip kursa zato sto je referenciran u kursu.", "Greska"); return; } } Aplikacija.Instanca.TipoviKursa.Remove(t); TipKursaDAO.Delete(t); } if (Aplikacija.Instanca.TipoviKursa.Count == 0) { bObrisi.IsEnabled = false; bIzmeni.IsEnabled = false; } }
public static void Create(TipKursa k) { using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "insert into tipkursa values(@id,@nivo,@oznaka,@sts)"; cmd.Parameters.Add(new SqlParameter("@id", k.Id)); cmd.Parameters.Add(new SqlParameter("@nivo", k.Nivo)); cmd.Parameters.Add(new SqlParameter("@oznaka", k.Oznaka)); cmd.Parameters.Add(new SqlParameter("@sts", k.Status)); try { cmd.ExecuteNonQuery(); } catch (SqlException e) { MessageBox.Show(e.Message, "nece", MessageBoxButton.OK); } } }
public static void Read() { using (SqlConnection conn = new SqlConnection(Aplikacija.CONNECTION_STRING)) { conn.Open(); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from TIPKURSA"; SqlDataAdapter sqlDA = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); sqlDA.Fill(ds, "tipovi"); foreach (DataRow row in ds.Tables["tipovi"].Rows) { TipKursa k = new TipKursa(); k.Id = (int)row["id"]; k.Nivo = (string)row["nivo"]; k.Oznaka = (string)row["oznaka"]; k.Status = (bool)row["sts"]; Aplikacija.Instanca.Tipovi.Add(k); } } }