//zapisujemo narudžbu i stavke narudžbe u bazu
static public void ZapisiNarudzbu(Narudzba nar)
{
Narudzba narudzba = nar;
DBCon baza = new DBCon();
SqlCommand command = new SqlCommand("INSERT INTO Narudzba (ID_Narudzbe,ID_Poslovnice,ID_Djelatnika) OUTPUT INSERTED.ID_Narudzbe VALUES (((SELECT TOP 1 ID_Narudzbe FROM Narudzba order by 1 desc)+1),@ID_Poslovnice, @ID_Djelatnika)");
command.Parameters.AddWithValue("@ID_Poslovnice", narudzba.poslovnicaId);
command.Parameters.AddWithValue("@ID_Djelatnika", narudzba.djelatnikId);
int nar_id = (int)baza.DohvatiVrijednost(command);
SqlCommand naredba = new SqlCommand("INSERT INTO StavkeNarudzbe (ID_Lijek, ID_Narudzbe, kolicina) VALUES ");
for (int i = 0; i < nar.Stavke.Count; i++)
{
StavkaNarudzbe sn = nar.Stavke[i];
naredba.CommandText += "(";
naredba.CommandText += "@ID_Lijek" + i + ",";
naredba.CommandText += "@ID_Narudzbe" + i + ",";
naredba.CommandText += "@kolicina" + i + ")";
naredba.Parameters.AddWithValue("@ID_Lijek" + i, sn.IdLijeka);
naredba.Parameters.AddWithValue("@ID_Narudzbe" + i, nar_id);
naredba.Parameters.AddWithValue("@kolicina" + i, sn.Kolicina);
if (i != nar.Stavke.Count - 1)
{
naredba.CommandText += ",";
}
}
baza.IzvrsiUpit(naredba);
}
