public int brisiStavkuNarudzbe(StavkeNarudzbe a)
{
try
{
String query = "DELETE FROM StavkeNarudzbe WHERE id = @id;";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.idNarudzbe);
id.ParameterName = "id";
cmd.Parameters.Add(id);
con.Open();
int r = 0;
if (con.State == System.Data.ConnectionState.Open)
{
r = cmd.ExecuteNonQuery();
}
con.Close();
return(r);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
public async Task <IHttpActionResult> PutStavkeNarudzbe(int id, StavkeNarudzbe stavkeNarudzbe)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != stavkeNarudzbe.id)
{
return(BadRequest());
}
db.Entry(stavkeNarudzbe).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StavkeNarudzbeExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void ucitajStavkeNarudzbe()
{
try
{
Narudzbe = new List <StavkeNarudzbe>();
String query = "SELECT * FROM StavkeNarudzbe;";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
con.Open();
if (con.State == System.Data.ConnectionState.Open)
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
StavkeNarudzbe a = new StavkeNarudzbe(Convert.ToInt32(reader.GetString(0)), reader.GetInt32(1), reader.GetInt32(2));
Narudzbe.Add(a);
}
}
con.Close();
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
}
}
public IActionResult PostNarudzba([FromBody] NarudzbaDto narudzba)
{
var identity = HttpContext.User.Identity as ClaimsIdentity;
var userId = identity.Claims.ToList()[0].Value;
Narudzba nar = new Narudzba
{
KorisnikID = int.Parse(userId),
brojNarudzbe = narudzba.brojNarudzbe,
nacinIsporuke = narudzba.nacinIsporuke,
nacinPlacanja = narudzba.nacinPlacanje,
ukupanIznos = narudzba.ukupanIznos
};
_context.Narudzba.Add(nar);
_context.SaveChanges();
foreach (var stavka in narudzba.stavkeNarudzbe)
{
StavkeNarudzbe sn = new StavkeNarudzbe()
{
ArtikalID = stavka.ArtikalID,
Kolicina = stavka.Kolicina,
NarudzbaID = nar.NarudzbaID
};
_context.StavkeNarudzbe.Add(sn);
_context.SaveChanges();
}
return(Ok());
}
public ActionResult DeleteConfirmed(int id)
{
StavkeNarudzbe stavkeNarudzbe = db.StavkeNarudzba.Find(id);
db.StavkeNarudzba.Remove(stavkeNarudzbe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,idNarudzbe,idJela")] StavkeNarudzbe stavkeNarudzbe)
{
if (ModelState.IsValid)
{
db.Entry(stavkeNarudzbe).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stavkeNarudzbe));
}
public async Task <IHttpActionResult> GetStavkeNarudzbe(int id)
{
StavkeNarudzbe stavkeNarudzbe = await db.StavkeNarudzbe.FindAsync(id);
if (stavkeNarudzbe == null)
{
return(NotFound());
}
return(Ok(stavkeNarudzbe));
}
public ActionResult Create([Bind(Include = "id,idNarudzbe,idJela")] StavkeNarudzbe stavkeNarudzbe)
{
if (ModelState.IsValid)
{
db.StavkeNarudzba.Add(stavkeNarudzbe);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(stavkeNarudzbe));
}
public async Task <IHttpActionResult> PostStavkeNarudzbe(StavkeNarudzbe stavkeNarudzbe)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.StavkeNarudzbe.Add(stavkeNarudzbe);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = stavkeNarudzbe.id }, stavkeNarudzbe));
}
public static NarudzbeStavke_Result GetStavkeResultInstance(StavkeNarudzbe obj)
{
return(obj == null ? null : new NarudzbeStavke_Result
{
StavkeNarudzbeId = obj.StavkeNarudzbeId,
HranaId = obj.HranaId,
Kolicina = obj.Kolicina,
NarudzbaId = obj.NarudzbaId,
NazivProizvoda = obj.Hrana.Naziv,
Sifra = obj.Hrana.Sifra,
Cijena = obj.Hrana.Cijena
});
}
public async Task <IHttpActionResult> DeleteStavkeNarudzbe(int id)
{
StavkeNarudzbe stavkeNarudzbe = await db.StavkeNarudzbe.FindAsync(id);
if (stavkeNarudzbe == null)
{
return(NotFound());
}
db.StavkeNarudzbe.Remove(stavkeNarudzbe);
await db.SaveChangesAsync();
return(Ok(stavkeNarudzbe));
}
// GET: StavkeNarudzbe/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StavkeNarudzbe stavkeNarudzbe = db.StavkeNarudzba.Find(id);
if (stavkeNarudzbe == null)
{
return(HttpNotFound());
}
return(View(stavkeNarudzbe));
}
public StavkeNarudzbe GetById(int id)
{
var item = _context.NarudzbaStavke.Where(x => x.NarudzbaStavkaId == id).Include(y => y.Artikal).SingleOrDefault();
StavkeNarudzbe nova = new StavkeNarudzbe();
nova.ArtikalId = item.Artikal.ArtikalId;
nova.Cijena = item.Cijena;
nova.Kolicina = item.Kolicina;
nova.NarudzbaId = item.NarudzbaId;
nova.NarudzbaStavkaId = item.NarudzbaStavkaId;
nova.Naziv = item.Artikal.Naziv;
nova.Popust = item.Popust;
nova.Sifra = item.Artikal.Sifra;
return(nova);
}
public int unesiStavkuNarudzbe(StavkeNarudzbe a)
{
try
{
String query = "insert into StavkeNarudzbe " +
"values (@id,@idKupca,@idObjekta)";
DBConnectionString s = new DBConnectionString();
using (SqlConnection con = new SqlConnection(s.GetString()))
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = query;
SqlParameter id = new SqlParameter();
id.Value = Convert.ToString(a.idNarudzbe);
id.ParameterName = "id";
SqlParameter idKupca = new SqlParameter();
idKupca.Value = a.idNarudzbe;
idKupca.ParameterName = "idKupca";
SqlParameter idObjekta = new SqlParameter();
idObjekta.Value = a.idJela;
idObjekta.ParameterName = "idObjekta";
cmd.Parameters.Add(id);
cmd.Parameters.Add(idKupca);
cmd.Parameters.Add(idObjekta);
int k = cmd.ExecuteNonQuery();
cmd.Dispose();
return(k);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(0);
}
}
public List <StavkeNarudzbe> Get()
{
var result = _context.NarudzbaStavke.Include(y => y.Artikal).ToList();
List <StavkeNarudzbe> lista = new List <StavkeNarudzbe>();
foreach (var item in result)
{
StavkeNarudzbe nova = new StavkeNarudzbe();
nova.ArtikalId = item.Artikal.ArtikalId;
nova.Cijena = item.Cijena;
nova.Kolicina = item.Kolicina;
nova.NarudzbaId = item.NarudzbaId;
nova.NarudzbaStavkaId = item.NarudzbaStavkaId;
nova.Naziv = item.Artikal.Naziv;
nova.Popust = item.Popust;
nova.Sifra = item.Artikal.Sifra;
lista.Add(nova);
}
return(lista);
}
