public static void Create(ProdajaDodatnaUsluga prodajaDodatnaUsluga)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"INSERT INTO ProdajaDodatnaUsluga (ProdajaId, DodatnaUslugaId, Cena, Obrisan) " +
"VALUES (@ProdajaId, @DodatnaUslugaId, @Cena, @Obrisan);";
cmd.CommandText += "SELECT SCOPE_IDENTITY();";
cmd.Parameters.Add(new SqlParameter("@ProdajaId", prodajaDodatnaUsluga.ProdajaId));
cmd.Parameters.Add(new SqlParameter("@DodatnaUslugaId", prodajaDodatnaUsluga.DodatnaUslugaId));
cmd.Parameters.Add(new SqlParameter("@Cena", prodajaDodatnaUsluga.Cena));
cmd.Parameters.Add(new SqlParameter("@Obrisan", prodajaDodatnaUsluga.Obrisan));
prodajaDodatnaUsluga.Id = int.Parse(cmd.ExecuteScalar().ToString());
}
Projekat.Instance.ProdajaDodatneUsluge.Add(prodajaDodatnaUsluga);
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom snimanja u bazu, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public static void Load()
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT * " +
"FROM ProdajaDodatnaUsluga " +
"WHERE Obrisan = 0; ";
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
DataSet dsA = new DataSet(); // izvrsavanje upita
sqlDA.Fill(dsA, "ProdajaDodatnaUsluga");
foreach (DataRow row in dsA.Tables["ProdajaDodatnaUsluga"].Rows)
{
ProdajaDodatnaUsluga prodajaDodatnaUsluga = new ProdajaDodatnaUsluga();
prodajaDodatnaUsluga.Id = int.Parse(row["IdPDU"].ToString());
prodajaDodatnaUsluga.DodatnaUslugaId = int.Parse(row["DodatnaUslugaId"].ToString());
prodajaDodatnaUsluga.ProdajaId = int.Parse(row["ProdajaId"].ToString());
prodajaDodatnaUsluga.Obrisan = Boolean.Parse(row["Obrisan"].ToString());
prodajaDodatnaUsluga.Cena = double.Parse(row["Cena"].ToString());
Projekat.Instance.ProdajaDodatneUsluge.Add(prodajaDodatnaUsluga);
}
foreach (var prodaja in Projekat.Instance.Prodaja)
{
if (prodaja.ListaDodatnihUslugaId == null)
{
prodaja.ListaDodatnihUslugaId = new ObservableCollection <int?>();
}
foreach (var dodatnaUsluga in Projekat.Instance.ProdajaDodatneUsluge)
{
if (prodaja.Id == dodatnaUsluga.ProdajaId)
{
prodaja.ListaDodatnihUslugaId.Add(dodatnaUsluga.Id);
}
}
}
}
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom ucitavanje iz baze, Molimo vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public static void Delete(ProdajaDodatnaUsluga prodajaDodatnaUsluga, TipBrisanja tipBrisanja, int prodajaId)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
switch (tipBrisanja)
{
case TipBrisanja.ProdajaId:
cmd.CommandText = @"UPDATE ProdajaDodatnaUsluga SET Obrisan = 1 WHERE ProdajaId=@ProdajaId";
cmd.Parameters.Add(new SqlParameter("@Obrisan", prodajaDodatnaUsluga.Obrisan));
cmd.Parameters.Add(new SqlParameter("@ProdajaId", prodajaId));
var i = cmd.ExecuteNonQuery();
break;
case TipBrisanja.ProdajaDodatnaUsluga:
cmd.CommandText = @"UPDATE ProdajaDodatnaUsluga SET Obrisan = 1 " +
"WHERE IdPDU=@IdPDU";
cmd.Parameters.Add(new SqlParameter("@IdPDU", prodajaDodatnaUsluga.Id));;
var ii = cmd.ExecuteNonQuery();
break;
}
foreach (var pdu in Projekat.Instance.ProdajaDodatneUsluge)
{
if (pdu.Id == prodajaDodatnaUsluga.Id)
{
pdu.Obrisan = true;
}
}
}
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom snimanja u bazu, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
public static ObservableCollection <ProdajaDodatnaUsluga> LoadByProdajaId(int prodajaId)
{
try
{
var lista = new ObservableCollection <ProdajaDodatnaUsluga>();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT * " +
"FROM ProdajaDodatnaUsluga " +
"WHERE Obrisan = 0 and ProdajaId=@ProdajaId;";
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = cmd;
cmd.Parameters.Add(new SqlParameter("@ProdajaId", prodajaId));
DataSet dsA = new DataSet(); // izvrsavanje upita
sqlDA.Fill(dsA, "ProdajaDodatnaUsluga");
foreach (DataRow row in dsA.Tables["ProdajaDodatnaUsluga"].Rows)
{
ProdajaDodatnaUsluga prodajaDodatnaUsluga = new ProdajaDodatnaUsluga();
prodajaDodatnaUsluga.Id = int.Parse(row["IdPDU"].ToString());
prodajaDodatnaUsluga.DodatnaUslugaId = int.Parse(row["DodatnaUslugaId"].ToString());
prodajaDodatnaUsluga.ProdajaId = int.Parse(row["ProdajaId"].ToString());
prodajaDodatnaUsluga.Obrisan = Boolean.Parse(row["Obrisan"].ToString());
prodajaDodatnaUsluga.Cena = double.Parse(row["Cena"].ToString());
lista.Add(prodajaDodatnaUsluga);
}
}
return(lista);
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom citanja iz baze, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
return(null);
}
}
public static void Update(ProdajaDodatnaUsluga prodajaDodatnaUsluga)
{
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = @"UPDATE ProdajaDodatnaUsluga SET ProdajaId=@ProdajaId , DodatnaUslugaId=@DodatnaUslugaId, Cena=@Cena, Obrisan=@Obrisan " +
"WHERE IdPDU=@IdPDU;";
cmd.Parameters.Add(new SqlParameter("@ProdajaId", prodajaDodatnaUsluga.ProdajaId));
cmd.Parameters.Add(new SqlParameter("@DodatnaUslugaId", prodajaDodatnaUsluga.DodatnaUslugaId));
cmd.Parameters.Add(new SqlParameter("@Cena", prodajaDodatnaUsluga.Cena));
cmd.Parameters.Add(new SqlParameter("@Obrisan", prodajaDodatnaUsluga.Obrisan));
cmd.Parameters.Add(new SqlParameter("@IdPDU", prodajaDodatnaUsluga.Id));
var uu = cmd.ExecuteNonQuery();
foreach (var pdu in Projekat.Instance.ProdajaDodatneUsluge)
{
if (prodajaDodatnaUsluga.Id == pdu.Id)
{
pdu.DodatnaUslugaId = prodajaDodatnaUsluga.DodatnaUslugaId;
pdu.Cena = prodajaDodatnaUsluga.Cena;
pdu.Obrisan = prodajaDodatnaUsluga.Obrisan;
}
}
}
}
catch (Exception)
{
MessageBox.Show("Doslo je do greske prilikom snimanja u bazu, Molimo Vas pokusajte ponovo", "Upozorenje", MessageBoxButton.OK, MessageBoxImage.Information);
}
}