public static void UcitajStavkeRacuna(Racun racun, int Id_Racun)
{
using (SqlConnection conn = new SqlConnection(Projekat.CONNECTION_STRING))
{
conn.Open();
DataSet ds = new DataSet();
SqlCommand command = conn.CreateCommand();
command.CommandText = $"SELECT * FROM StavkaProdajeNamestaja s WHERE s.Id_Racun=@Id_Racun ";
command.Parameters.Add(new SqlParameter("@Id_Racun", Id_Racun));
SqlDataAdapter daStavkaNamestaja = new SqlDataAdapter();
daStavkaNamestaja.SelectCommand = command;
daStavkaNamestaja.Fill(ds, "StavkaProdajeNamestaja");
Projekat.Instance.StavkaProdajeNamestaja.Clear();
foreach (DataRow row in ds.Tables["StavkaProdajeNamestaja"].Rows)
{
StavkaProdajeNamestaja s = new StavkaProdajeNamestaja();
s.Id = (int)row["Id"];
s.Id_Namestaj = (int)row["Id_Namestaj"];
s.Id_Racun = (int)row["Id_Racun"];
s.Kolicina = (int)row["Kolicina"];
s.Popust = (int)(row["Popust"]);
s.Namestaj = Namestaj.GetById(s.Id_Namestaj);
racun.listaStavkiNamestaja.Add(s);
}
}
}
public static void IzmeniNamestaj(Namestaj namestaj)
{
using (SqlConnection conn = new SqlConnection(Projekat.CONNECTION_STRING))
{
try
{
if (namestaj.Id != 0)//ako namestaj postoji u bazi
{
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandText = @"UPDATE Namestaj SET NAZIV=@Naziv, Sifra=@Sifra,Cena=@Cena,Kolicina=@Kolicina,
Obrisan=@Obrisan,IdTip=@IdTip WHERE Id=@Id";
command.Parameters.Add(new SqlParameter("@Naziv", namestaj.Naziv));
command.Parameters.Add(new SqlParameter("@Sifra", namestaj.Sifra));
command.Parameters.Add(new SqlParameter("@Cena", namestaj.Cena));
command.Parameters.Add(new SqlParameter("@Kolicina", namestaj.Kolicina));
command.Parameters.Add(new SqlParameter("@Obrisan", namestaj.Obrisan));
command.Parameters.Add(new SqlParameter("@IdTip", namestaj.IdTip));
command.Parameters.Add(new SqlParameter("@Id", namestaj.Id));
command.ExecuteNonQuery();
}
}
catch (Exception)
{
Console.WriteLine("Nije uspela sql naredba");
return;
}
}
}
public static void ObrisiNamestaj(Namestaj namestaj)
{
using (SqlConnection conn = new SqlConnection(Projekat.CONNECTION_STRING))
{
try
{
if (namestaj.Id != 0)//ako namestaj postoji u bazi
{
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandText = @"DELETE FROM Namestaj WHERE Id=@Id";
command.Parameters.Add(new SqlParameter("@Id", namestaj.Id));
command.ExecuteNonQuery();
}
}
catch (Exception)
{
Console.WriteLine("Nije uspela sql naredba");
return;
}
}
}
public static void DodajNamestaj(Namestaj namestaj)
{
using (SqlConnection conn = new SqlConnection(Projekat.CONNECTION_STRING))
{
try
{
conn.Open();
SqlCommand command = conn.CreateCommand();
command.CommandText = @"INSERT INTO Namestaj (Naziv, Sifra,Cena,Kolicina,Obrisan,IdTip)
VALUES (@Naziv, @Sifra,@Cena,@Kolicina,@Obrisan,@IdTip)";
command.Parameters.Add(new SqlParameter("@Naziv", namestaj.Naziv));
command.Parameters.Add(new SqlParameter("@Sifra", namestaj.Sifra));
command.Parameters.Add(new SqlParameter("@Cena", namestaj.Cena));
command.Parameters.Add(new SqlParameter("@Kolicina", namestaj.Kolicina));
command.Parameters.Add(new SqlParameter("@Obrisan", namestaj.Obrisan));
command.Parameters.Add(new SqlParameter("@IdTip", namestaj.IdTip));
command.ExecuteNonQuery();
}
catch (Exception)
{
Console.WriteLine("Nije uspela sql naredba");
return;
}
}
}
public StavkaProdajeNamestaja(int Id, int Id_Racun, Namestaj namestaj, int Kolicina, int Id_Namestaj, int Popust)
{
this.Id = Id;
this.Id_Racun = Id_Racun;
this.namestaj = namestaj;
this.Kolicina = Kolicina;
this.Id_Namestaj = Id_Namestaj;
this.Popust = Popust;
}
public Object Clone()
{
Namestaj kopija = new Namestaj();
kopija.Id = Id;
kopija.IdTip = IdTip;
kopija.Naziv = Naziv;
kopija.TipNamestaja = TipNamestaja;
kopija.Cena = Cena;
kopija.Obrisan = Obrisan;
kopija.Sifra = Sifra;
kopija.Kolicina = Kolicina;
return(kopija);
}
public static void UcitajNamestaj()
{
using (SqlConnection connection = new SqlConnection(Projekat.CONNECTION_STRING))
{
try
{
connection.Open();
DataSet ds = new DataSet();
SqlCommand namestajCommand = connection.CreateCommand();
namestajCommand.CommandText = @"SELECT * FROM Namestaj ";
SqlDataAdapter daNamestaj = new SqlDataAdapter();
daNamestaj.SelectCommand = namestajCommand;
daNamestaj.Fill(ds, "Namestaj");
foreach (DataRow row in ds.Tables["Namestaj"].Rows)
{
Namestaj n = new Namestaj();
n.Id = (int)row["Id"];
n.Sifra = (string)row["Sifra"];
n.Naziv = (string)row["Naziv"];
n.Cena = Convert.ToDouble(row["Cena"]);
n.Kolicina = (int)row["Kolicina"];
n.IdTip = (int)row["IdTip"];
n.TipNamestaja = TipNamestaja.GetById(n.IdTip);
n.Obrisan = (bool)row["Obrisan"];
Projekat.Instance.Namestaj.Add(n);
}
}
catch (Exception)
{
Console.WriteLine("Nije uspela sql naredba");
return;
}
}
}
public static void UcitajAktuelneAkcije()
{
using (SqlConnection connection = new SqlConnection(Projekat.CONNECTION_STRING))
{
try
{
connection.Open();
string date = Convert.ToString(DateTime.Today);
DataSet ds = new DataSet();
SqlCommand namestajCommand = connection.CreateCommand();
namestajCommand.CommandText = @"SELECT * FROM Akcija Where " + date + " BETWEEN DatumPocetka AND DatumZavrsetka ";
SqlDataAdapter daNamestaj = new SqlDataAdapter();
daNamestaj.SelectCommand = namestajCommand;
daNamestaj.Fill(ds, "Akcija");
foreach (DataRow row in ds.Tables["Akcija"].Rows)
{
Akcija n = new Akcija();
n.Id = (int)row["Id"];
n.DatumPocetka = (DateTime)row["DatumPocetka"];
n.DatumZavrsetka = (DateTime)row["DatumZavrsetka"];
n.Popust = (int)row["Popust"];
n.IdNamestaj = (int)row["IdNamestaj"];
n.Namestaj = Namestaj.GetById(n.IdNamestaj);
n.Obrisan = (bool)row["Obrisan"];
Projekat.Instance.Akcija.Add(n);
}
}
catch (Exception)
{
Console.WriteLine("Nije uspela sql naredba");
return;
}
}
}
public override string ToString()
{
return($"{Namestaj.GetById(IdNamestaj).Naziv},{Popust},{datumPocetka},{DatumZavrsetka}");
}
public Akcija(int Id, int IdNamestaj, DateTime DatumPocetka, DateTime DatumZavrsetka, Namestaj Namestaj, int Popust, bool Obrisan)
{
this.Id = Id;
this.IdNamestaj = IdNamestaj;
this.DatumPocetka = DatumPocetka;
this.DatumZavrsetka = DatumZavrsetka;
this.Namestaj = Namestaj;
this.Popust = Popust;
this.Obrisan = Obrisan;
}
