public async Task <ActionResult <Magacin> > PostMagacin(Magacin magacin)
{
_context.Magacin.Add(magacin);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMagacin", new { id = magacin.MagacinId }, magacin));
}
public async Task <IActionResult> PutMagacin(int id, Magacin magacin)
{
if (id != magacin.MagacinId)
{
return(BadRequest());
}
_context.Entry(magacin).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MagacinExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public MainWindow()
{
InitializeComponent();
Magacin db = new Magacin();
kDal = new KategorijaDal(db);
}
public void ObrisiNamestaj(Namestaj namestaj)
{
if (namestaj != null)
{
Magacin.Remove(namestaj);
namestaj.Aktivan = "Neaktivan";
Magacin.Add(namestaj);
}
database.UpdateNamestaj(namestaj);
}
public void PutMagacin(Magacin ar)
{
try
{
var dataSet = new DataSet();
var connection = new SqlConnection(Program.sqlString);
connection.Open();
var update = new SqlCommand($"UPDATE MAGACIN SET idArtikla ={ar.IdStavke}, kolicina = {ar.Kolicina}, cena = {ar.Cena}, vremeIDatum = {ar.VremeIDatum} WHERE id = {ar.IdArtikla};", connection);
update.ExecuteNonQuery();
}
catch (Exception e)
{
throw new FaultException <Error>(new Error(e.Message));
}
}
public void PostMagacin(Magacin ar)
{
try
{
var dataSet = new DataSet();
var connection = new SqlConnection(Program.sqlString);
connection.Open();
var insert = new SqlCommand($"INSERT INTO MAGACIN(id,idArtikla,kolicina,cena,vremeIDatum) VALUES ({ar.IdArtikla},{ar.IdStavke},{ar.Kolicina},{ar.Cena},{ar.VremeIDatum});", connection);
var a = new SqlDataAdapter(insert);
insert.ExecuteNonQuery();
}
catch (Exception e)
{
throw new FaultException <Error>(new Error(e.Message));
}
}
// POST: odata/Magacin
public async Task <IHttpActionResult> Post(Magacin magacin)
{
if (!LoginController.CheckAuthorizationForRequest(Request))
{
return(Unauthorized());
}
if (!ModelState.IsValid || !magacin.ValidateOcl())
{
return(BadRequest(ModelState));
}
db.Magacin.Add(magacin);
await db.SaveChangesAsync();
return(Created(magacin));
}
public StorageItemControl(string slika, Magacin magacin)
{
// this.imgBloodType.Source = ImageSource(slika);
InitializeComponent();
imgBloodType.Source = new ImageSourceConverter().ConvertFromString(@slika) as ImageSource;
lblBlood.Content = magacin.BrojDozaKrvi;
lblPlasma.Content = magacin.BrojDozaPlazme;
lblPlatelets.Content = magacin.BrojDozaTrombocita;
lblRedCells.Content = magacin.BrojDozaEritrocita;
if (magacin.BrojDozaKrvi == 0)
{
lblBlood.Background = new SolidColorBrush(Color.FromRgb(180, 0, 0));
}
else
{
lblBlood.Background = new SolidColorBrush(Color.FromRgb(0, 116, 21));
}
if (magacin.BrojDozaEritrocita == 0)
{
lblRedCells.Background = new SolidColorBrush(Color.FromRgb(180, 0, 0));
}
else
{
lblRedCells.Background = new SolidColorBrush(Color.FromRgb(0, 116, 21));
}
if (magacin.BrojDozaPlazme == 0)
{
lblPlasma.Background = new SolidColorBrush(Color.FromRgb(180, 0, 0));
}
else
{
lblPlasma.Background = new SolidColorBrush(Color.FromRgb(0, 116, 21));
}
if (magacin.BrojDozaTrombocita == 0)
{
lblPlatelets.Background = new SolidColorBrush(Color.FromRgb(180, 0, 0));
}
else
{
lblPlatelets.Background = new SolidColorBrush(Color.FromRgb(0, 116, 21));
}
}
private void SmanjiKolicinu(string sifra)
{
Namestaj n = null;
foreach (var namestaj in Magacin)
{
if (namestaj.Sifra == sifra)
{
namestaj.KolicinaUMagacinu -= Kolicina;
n = namestaj;
}
}
if (n != null)
{
Magacin.Remove(n);
Magacin.Add(n);
}
}
// DELETE: odata/Magacin(5)
public async Task <IHttpActionResult> Delete([FromODataUri] int key)
{
if (!LoginController.CheckAuthorizationForRequest(Request))
{
return(Unauthorized());
}
Magacin magacin = await db.Magacin.FindAsync(key);
if (magacin == null)
{
return(NotFound());
}
db.Magacin.Remove(magacin);
await db.SaveChangesAsync();
return(StatusCode(HttpStatusCode.NoContent));
}
public async Task <IActionResult> IzmeniMagacin([FromBody] Magacin magacin)
{
if (Context.Magacini.Any(p => p.Ime == magacin.Ime && p.Kapacitet == magacin.Kapacitet && p.N == magacin.N))
{
return(StatusCode(406));
}
if (magacin.Ime == null || magacin.Kapacitet == 0)
{
return(StatusCode(406));
}
else
{
Context.Update <Magacin>(magacin);
await Context.SaveChangesAsync();
return(Ok());
}
}
// PUT: odata/Magacin(5)
public async Task <IHttpActionResult> Put([FromODataUri] int key, Delta <Magacin> patch)
{
if (!LoginController.CheckAuthorizationForRequest(Request))
{
return(Unauthorized());
}
Validate(patch.GetEntity());
if (!ModelState.IsValid || !patch.GetEntity().ValidateOcl())
{
return(BadRequest(ModelState));
}
Magacin magacin = await db.Magacin.FindAsync(key);
if (magacin == null)
{
return(NotFound());
}
patch.Put(magacin);
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MagacinExists(key))
{
return(NotFound());
}
else
{
throw;
}
}
return(Updated(magacin));
}
public async Task DodajMagacin([FromBody] Magacin magacin)
{
Context.Magacini.Add(magacin);
await Context.SaveChangesAsync();
}
public KategorijaDal(Magacin _db)
{
db = _db;
}
public static void Init(Interface i)
{
int input = 0;
while (input != 4)
{
Console.Write("1)Artikli\n2)FiskalniRacun\n3)Magacin\n4)Izlaz\n");
input = Convert.ToInt32(Console.ReadLine());
if (input == 1)
{
int input2 = 0;
while (input2 != 5)
{
Console.Write("1)Ispis Artikla\n2)Dodaj Artikal\n3)Izmeni Artikal\n4)Obrisi Artikal\n5)Izlaz\n");
input2 = Convert.ToInt32(Console.ReadLine());
if (input2 == 1)
{
int id;
id = Convert.ToInt32(Console.ReadLine());
Artikli a = i.GetArtikli(id);
Console.WriteLine(a);
}
if (input2 == 2)
{
int id;
string naz, jed;
id = Convert.ToInt32(Console.ReadLine());
naz = Convert.ToString(Console.ReadLine());
jed = Convert.ToString(Console.ReadLine());
Artikli a = new Artikli(id, naz, jed);
i.PostArtikli(a);
}
if (input2 == 3)
{
int id;
string naz, jed;
id = Convert.ToInt32(Console.ReadLine());
naz = Convert.ToString(Console.ReadLine());
jed = Convert.ToString(Console.ReadLine());
Artikli a = new Artikli(id, naz, jed);
i.PutArtikli(a);
}
if (input2 == 4)
{
int id;
id = Convert.ToInt32(Console.ReadLine());
i.DeleteArtikli(id);
}
}
}
if (input == 2)
{
int input2 = 0;
while (input2 != 5)
{
Console.Write("1)Ispis Fiskalnog Racuna\n2)Dodaj Fiskalni Racun\n3)Izmeni Fiskalni Racun\n4)Obrisi Fiskalni Racun\n5)Izlaz\n");
input2 = Convert.ToInt32(Console.ReadLine());
if (input2 == 1)
{
int id;
id = Convert.ToInt32(Console.ReadLine());
FiskalniRacun a = i.GetFiskalniRacun(id);
Console.WriteLine(a);
}
if (input2 == 2)
{
int id, idStavke, kolicina;
DateTime vreme;
id = Convert.ToInt32(Console.ReadLine());
idStavke = Convert.ToInt32(Console.ReadLine());
vreme = Convert.ToDateTime(Console.ReadLine());
kolicina = Convert.ToInt32(Console.ReadLine());
FiskalniRacun a = new FiskalniRacun(id, idStavke, vreme, kolicina);
i.PostFiskalniRacun(a);
}
if (input2 == 3)
{
int id, idStavke, kolicina;
DateTime vreme;
id = Convert.ToInt32(Console.ReadLine());
idStavke = Convert.ToInt32(Console.ReadLine());
vreme = Convert.ToDateTime(Console.ReadLine());
kolicina = Convert.ToInt32(Console.ReadLine());
FiskalniRacun a = new FiskalniRacun(id, idStavke, vreme, kolicina);
i.PutFiskalniRacun(a);
}
if (input2 == 4)
{
int id;
id = Convert.ToInt32(Console.ReadLine());
i.DeleteFiskalniRacun(id);
}
}
}
if (input == 3)
{
int input2 = 0;
while (input2 != 4)
{
Console.Write("1)Ispis Magacina\n2)Dodaj Magacin\n3)Izmeni Magacin\n4)Obrisi Magacin\n5)Izlaz\n");
input2 = Convert.ToInt32(Console.ReadLine());
if (input2 == 1)
{
int id;
id = Convert.ToInt32(Console.ReadLine());
Magacin a = i.GetMagacin(id);
Console.WriteLine(a);
}
if (input2 == 2)
{
int id, idArtikla, kolicina, cena;
DateTime vreme;
id = Convert.ToInt32(Console.ReadLine());
idArtikla = Convert.ToInt32(Console.ReadLine());
kolicina = Convert.ToInt32(Console.ReadLine());
cena = Convert.ToInt32(Console.ReadLine());
vreme = Convert.ToDateTime(Console.ReadLine());
Magacin a = new Magacin(id, idArtikla, kolicina, cena, vreme);
i.PostMagacin(a);
}
if (input2 == 3)
{
int id, idArtikla, kolicina, cena;
DateTime vreme;
id = Convert.ToInt32(Console.ReadLine());
idArtikla = Convert.ToInt32(Console.ReadLine());
kolicina = Convert.ToInt32(Console.ReadLine());
cena = Convert.ToInt32(Console.ReadLine());
vreme = Convert.ToDateTime(Console.ReadLine());
Magacin a = new Magacin(id, idArtikla, kolicina, cena, vreme);
i.PutMagacin(a);
}
if (input2 == 4)
{
int id;
id = Convert.ToInt32(Console.ReadLine());
i.DeleteMagacin(id);
}
}
}
}
}
public string DeleteRobu(Magacin roba)
{
return(new MagacinRepository().DeleteRobu(roba));
}
public string InsertRobu(Magacin roba)
{
roba.Id_robe = FreeID();
return(new MagacinRepository().InsertRobu(roba));
}
public string UpdateMagacin(Magacin roba)
{
return(new MagacinRepository().UpdateMagacin(roba));
}
