public static ObservableCollection <ProdataUsluga> GetAllId(int Id)
{
var pUsluga = new ObservableCollection <ProdataUsluga>();
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 ProdataUsluga WHERE Obrisan=0 and ProdajaNamestajaId=@ProdajaNamestajaId";
cmd.CommandText += " Select SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("ProdajaNamestajaId", Id);
da.SelectCommand = cmd;
da.Fill(ds, "ProdataUsluga"); //izvrsavanje upita
foreach (DataRow row in ds.Tables["ProdataUsluga"].Rows)
{
var pu = new ProdataUsluga();
pu.Id = int.Parse(row["Id"].ToString());
pu.ProdajaNamestajaId = int.Parse(row["ProdajaNamestajaId"].ToString());
pu.DodatnaUslugaId = int.Parse(row["DodatnaUslugaId"].ToString());
pu.Obrisan = bool.Parse(row["Obrisan"].ToString());
pUsluga.Add(pu);
}
}
return(pUsluga);
}
public static ProdataUsluga Create(ProdataUsluga pu)
{
try
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO ProdataUsluga (ProdajaNamestajaId,DodatnaUslugaId,Obrisan) VALUES (@ProdajaNamestajaId,@DodatnaUslugaId,@Obrisan);";
cmd.CommandText += "SELECT SCOPE_IDENTITY()";
cmd.Parameters.AddWithValue("ProdajaNamestajaId", pu.ProdajaNamestajaId);
cmd.Parameters.AddWithValue("DodatnaUslugaId", pu.DodatnaUslugaId);
cmd.Parameters.AddWithValue("Obrisan", pu.Obrisan);
pu.Id = int.Parse(cmd.ExecuteScalar().ToString()); //executeScalar izvrsava upit
}
Projekat.Instance.ProdateUsluge.Add(pu);
return(pu);
}
catch (Exception)
{
MessageBox.Show("Upis u bazu nije uspeo.\n Molim da pokusate ponovo!", "Greska", MessageBoxButton.OK, MessageBoxImage.Warning);
return(null);
}
}
public static void Update(ProdataUsluga pu)
{
try
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["POP"].ConnectionString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE ProdataUsluga SET ProdajaNamestajaId=@ProdajaNamestajaId,DodatnaUslugaId = @DodatnaUslugaId,Obrisan=@Obrisan WHERE Id = @Id";
cmd.CommandText += " SELECT SCOPE_IDENTITY();";
cmd.Parameters.AddWithValue("Id", pu.Id);
cmd.Parameters.AddWithValue("ProdajaNamestajaId", pu.ProdajaNamestajaId);
cmd.Parameters.AddWithValue("DodatnaUslugaId", pu.DodatnaUslugaId);
cmd.Parameters.AddWithValue("Obrisan", pu.Obrisan);
cmd.ExecuteNonQuery();
}
foreach (var prodataU in Projekat.Instance.ProdateUsluge)
{
if (prodataU.Id == pu.Id)
{
pu.ProdajaNamestajaId = prodataU.ProdajaNamestajaId;
pu.DodatnaUslugaId = prodataU.DodatnaUslugaId;
pu.Obrisan = prodataU.Obrisan;
}
}
}
catch (Exception)
{
MessageBox.Show("Upis u bazu nije uspeo.\n Molim da pokusate ponovo!", "Greska", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
public static void Delete(ProdataUsluga pu)
{
pu.Obrisan = true;
ProdataUsluga.Update(pu);
}