public static Ucionica Create(Ucionica u)
{
try
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO Ucionica (BrojUcionice,BrojMesta,TipUcionice,Obrisano) VALUES (@BrojUcionice,@BrojMesta,@TipUcionice,@Obrisano);";
cmd.CommandText += "SELECT SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("@BrojUcionice", u.BrojUcionice);
cmd.Parameters.AddWithValue("@BrojMesta", u.BrojMesta);
cmd.Parameters.AddWithValue("@TipUcionice", u.TipUcionice.ToString());
cmd.Parameters.AddWithValue("@Obrisano", u.Obrisano);
cmd.Parameters.AddWithValue("@UstanovaId", u.UstanovaId);
u.Id = int.Parse(cmd.ExecuteScalar().ToString());
//cmd.ExecuteNonQuery();
}
Data.Instance.Ucionice.Add(u);
return(u);
}
catch (Exception)
{
MessageBox.Show("Upis u bazu nije uspeo.\n Pokusajte ponovo.", "Greska", MessageBoxButton.OK, MessageBoxImage.Warning);
return(null);
}
}
public static ObservableCollection <Ucionica> GetAll()
{
var ucionice = new ObservableCollection <Ucionica>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
cmd.CommandText = "SELECT * FROM Ucionica WHERE Obrisano = 0;";
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Ucionica"); // Izvrsavanje upita
foreach (DataRow row in ds.Tables["Ucionica"].Rows)
{
var u = new Ucionica();
u.Id = int.Parse(row["Id"].ToString());
u.BrojUcionice = int.Parse(row["BrojUcionice"].ToString());
u.BrojMesta = int.Parse(row["BrojMesta"].ToString());
u.TipUcionice = (ETipUcionice)Enum.Parse(typeof(ETipUcionice), (row["TipUcionice"].ToString()));
u.Obrisano = bool.Parse(row["Obrisano"].ToString());
u.UstanovaId = int.Parse(row["UstanovaId"].ToString());
ucionice.Add(u);
}
}
return(ucionice);
}
public static ObservableCollection <Ucionica> PretragaUcionice(string unos, TipPretrage tipPretrage)
{
var ucionice = new ObservableCollection <Ucionica>();
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = conn.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
switch (tipPretrage)
{
case TipPretrage.BROJUCIONICE:
cmd.CommandText = "SELECT * FROM Ucionica WHERE BrojUcionice LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.BROJMESTA:
cmd.CommandText = "SELECT * FROM Ucionica WHERE BrojMesta LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.TIPUCIONICE:
cmd.CommandText = "SELECT * FROM Ucionica WHERE TipUcionice LIKE @unos AND Obrisano = 0;";
break;
case TipPretrage.USTANOVAID:
cmd.CommandText = "SELECT * FROM Ucionica WHERE UstanovaId LIKE @unos AND Obrisano = 0;";
break;
}
cmd.Parameters.AddWithValue("unos", "%" + unos.Trim() + "%");
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Ucionica");
foreach (DataRow row in ds.Tables["Ucionica"].Rows)
{
var u = new Ucionica();
u.Id = int.Parse(row["Id"].ToString());
u.BrojUcionice = int.Parse(row["BrojUcionice"].ToString());
u.BrojMesta = int.Parse(row["BrojMesta"].ToString());
u.TipUcionice = (ETipUcionice)Enum.Parse(typeof(ETipUcionice), (row["TipUcionice"].ToString()));
u.Obrisano = bool.Parse(row["Obrisano"].ToString());
u.UstanovaId = int.Parse(row["UstanovaId"].ToString());
ucionice.Add(u);
}
}
return(ucionice);
}
public static void Update(Ucionica u)
{
try
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE Ucionica SET BrojUcionice = @BrojUcionice,BrojMesta = @BrojMesta, TipUcionice = @TipUcionice, Obrisano= @Obrisano WHERE Id = @Id";
cmd.Parameters.AddWithValue("@Id", u.Id);
cmd.Parameters.AddWithValue("@BrojUcionice", u.BrojUcionice);
cmd.Parameters.AddWithValue("@BrojMesta", u.BrojMesta);
cmd.Parameters.AddWithValue("@TipUcionice", u.TipUcionice.ToString());
cmd.Parameters.AddWithValue("@Obrisano", u.Obrisano);
cmd.Parameters.AddWithValue("@UstanovaId", u.UstanovaId);
cmd.ExecuteNonQuery();
}
//azuriranje modela
foreach (var ucionica in Data.Instance.Ucionice)
{
if (u.Id == ucionica.Id)
{
ucionica.BrojUcionice = u.BrojUcionice;
ucionica.BrojMesta = u.BrojMesta;
ucionica.TipUcionice = u.TipUcionice;
ucionica.Obrisano = u.Obrisano;
ucionica.UstanovaId = u.UstanovaId;
}
}
}
catch (Exception)
{
MessageBox.Show("Upis u bazu nije uspeo.\n Molim da pokusate ponovo!", "Greska", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public static void Delete(Ucionica u)
{
u.Obrisano = true;
Update(u);
}