public static void Update(UslugaProdaje tn)
{
try
{
//azuriranje baze
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "UPDATE UslugaProdaje SET IdProdaje = @IdProdaje, IdUsluge = @IdUsluge WHERE Id=@Id;";
cmd.CommandText += "SELECT SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("Id", tn.Id);
cmd.Parameters.AddWithValue("IdProdaje", tn.IdProdaje);
cmd.Parameters.AddWithValue("IdUsluge", tn.IdUsluge);
cmd.ExecuteNonQuery();
}
//azuriranje modela
foreach (var tip in Projekat.Instance.UslugeProdaje)
{
if (tn.Id == tip.Id)
{
tip.IdProdaje = tn.IdProdaje;
tip.IdUsluge = tn.IdUsluge;
}
}
}
catch (Exception)
{
}
}
public static ObservableCollection <UslugaProdaje> GetAll()
{
var uslugeZaProdaju = new ObservableCollection <UslugaProdaje>();
try
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
SqlCommand cmd = con.CreateCommand();
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
cmd.CommandText = "SELECT * FROM UslugaProdaje;";
da.SelectCommand = cmd;
da.Fill(ds, "UslugaProdaje");
foreach (DataRow row in ds.Tables["UslugaProdaje"].Rows)
{
var tn = new UslugaProdaje();
tn.Id = Convert.ToInt32(row["Id"]);
tn.IdProdaje = Convert.ToInt32(row["IdProdaje"]);
tn.IdUsluge = Convert.ToInt32(row["IdUsluge"]);
uslugeZaProdaju.Add(tn);
}
}
return(uslugeZaProdaju);
}
catch (Exception)
{
MessageBoxResult obavestenje = MessageBox.Show("Doslo je do greske.", "Obavestenje", MessageBoxButton.OK);
return(null);
}
}
public static UslugaProdaje Create(UslugaProdaje tn)
{
try
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO UslugaProdaje (IdProdaje, IdUsluge) VALUES (@IdProdaje, @IdUsluge);";
cmd.CommandText += "SELECT SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("IdUsluge", tn.IdUsluge);
cmd.Parameters.AddWithValue("IdProdaje", tn.IdProdaje);
tn.Id = int.Parse(cmd.ExecuteScalar().ToString());
}
Projekat.Instance.UslugeProdaje.Add(tn);
return(tn);
}
catch (Exception)
{
MessageBoxResult obavestenje = MessageBox.Show("Doslo je do greske.", "Obavestenje", MessageBoxButton.OK);
return(null);
}
}
private Projekat()
{
Namestaji = Namestaj.GetAll();
TipoviNamestaja = TipNamestaja.GetAll();
Korisnici = Korisnik.GetAll();
DodatneUsluge = DodatnaUsluga.GetAll();
ProdajeNamestaja = ProdajaNamestaja.GetAll();
StavkeProdaje = StavkaProdaje.GetAll();
UslugeProdaje = UslugaProdaje.GetAll();
Akcije = Akcija.GetAll();
NaAkcijama = NaAkciji.GetAll();
Saloni = Salon.GetAll();
}
public static void Delete(UslugaProdaje p)
{
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "DELETE FROM UslugaProdaje WHERE Id=@Id;";
cmd.CommandText += "SELECT SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("Id", p.Id);
cmd.ExecuteNonQuery();
}
}