public static void DodajTipKorisnika(TipKorisnika nk)
{
using (SqlConnection conn = new SqlConnection(Podaci.CONNECTION_STRING))
{
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandText = @"INSERT INTO TIPKORISNIKA (NAZIV, OBRISAN) VALUES(@NAZIV, @OBRISAN)";
command.Parameters.Add(new SqlParameter("@Naziv", nk.Naziv));
command.Parameters.Add(new SqlParameter("@Obrisan", nk.Obrisan));
}
}
public static void ObrisiTipKorisnika(TipKorisnika kn)
{
using (SqlConnection conn = new SqlConnection(Podaci.CONNECTION_STRING))
{
if (kn.tkId != 0) //ako postoji u bazi
{
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandText = @"DELETE FROM TIPKORISNIKA WHERE TKID=@tkId";
command.Parameters.Add(new SqlParameter("@tkId", kn.tkId));
command.ExecuteNonQuery();
}
}
}
public static void IzmeniTipKorisnika(TipKorisnika kn)
{
using (SqlConnection conn = new SqlConnection(Podaci.CONNECTION_STRING))
{
if (kn.tkId != 0)//ako postoji u bazi
{
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandText = @"UPDATE TIPKORISNIKA SET Naziv=@Naziv, Obrisan=@Obrisan WHERE TKID=@tkId";
command.Parameters.Add(new SqlParameter("@tkId", kn.tkId));
command.Parameters.Add(new SqlParameter("@Naziv", kn.Naziv));
command.Parameters.Add(new SqlParameter("@Obrisan", kn.Obrisan));
command.ExecuteNonQuery();
}
}
}
public static void UcitajTipKorisnika()
{
using (SqlConnection konekcija = new SqlConnection(Podaci.CONNECTION_STRING))
{
konekcija.Open();
DataSet ds = new DataSet();
SqlCommand tipkorkomand = konekcija.CreateCommand();
tipkorkomand.CommandText = @"SELECT * FROM TIPKORISNIKA";
SqlDataAdapter datipk = new SqlDataAdapter();
datipk.SelectCommand = tipkorkomand;
datipk.Fill(ds, "TipKorisnika");
foreach (DataRow row in ds.Tables["TipKorisnika"].Rows)
{
TipKorisnika tipk = new TipKorisnika();
tipk.tkId = (int)row["TkId"];
tipk.Naziv = (string)row["Naziv"];
tipk.Obrisan = (bool)row["Obrisan"];
Podaci.Instance.TipoviKorisnika.Add(tipk);
}
}
}
