public JsonResult GetArtikalById(int ArtikalID) { tblArtikal model = db.tblArtikals.Where(x => x.ArtikalID == ArtikalID).SingleOrDefault(); string value = string.Empty; value = JsonConvert.SerializeObject(model, Formatting.Indented, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); return(Json(value, JsonRequestBehavior.AllowGet)); }
public JsonResult DeleteArtikalRecord(int ArtikalID) { bool result = false; tblArtikal Art = db.tblArtikals.SingleOrDefault(x => x.IsDeleted == false && x.ArtikalID == ArtikalID); if (Art != null) { Art.IsDeleted = true; db.SaveChanges(); result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult SaveDataInDatabase(ArtikalViewModel model) { var result = false; try { if (model.ArtikalID > 0) { tblArtikal art = db.tblArtikals.SingleOrDefault(x => x.IsDeleted == false && x.ArtikalID == model.ArtikalID); art.ArtikalID = model.ArtikalID; art.ArtikalNaziv = model.ArtikalNaziv; art.Opis = model.Opis; art.Kategorija = model.Kategorija; art.Proizvodjac = model.Proizvodjac; art.Dobavljac = model.Dobavljac; art.Cena = model.Cena; db.SaveChanges(); result = true; } else { tblArtikal art = new tblArtikal(); art.ArtikalID = model.ArtikalID; art.ArtikalNaziv = model.ArtikalNaziv; art.Opis = model.Opis; art.Kategorija = model.Kategorija; art.Proizvodjac = model.Proizvodjac; art.Cena = model.Cena; art.Dobavljac = model.Dobavljac; art.IsDeleted = false; db.tblArtikals.Add(art); db.SaveChanges(); result = true; } } catch (Exception ex) { throw ex; } return(Json(result, JsonRequestBehavior.AllowGet)); }