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 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}");
}