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);
}
}
}
