public static List <Casopis> DohvatiSve() { List <Casopis> listaCasopisa = new List <Casopis>(); BP.otvoriKonekciju(); SqliteCommand command = BP.komanda(); command.CommandText = "Select * from casopis, sadrzaj where casopis.id_sadrzaj = sadrzaj.id"; SqliteDataReader reader = command.ExecuteReader(); while (reader.Read()) { Casopis k = new Casopis(); k.Id = (int)(Int64)reader["id"]; k.Naziv = (string)reader["naziv"]; k.Tagovi = (string)reader["tagovi"]; listaCasopisa.Add(k); } reader.Dispose(); command.Dispose(); return(listaCasopisa); }
public ActionResult DeleteConfirmed(int id) { Casopis casopis = db.Casopis.Find(id); db.Casopis.Remove(casopis); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,Naziv")] Casopis casopis) { if (ModelState.IsValid) { db.Entry(casopis).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(casopis)); }
public ActionResult Create([Bind(Include = "Id,Naziv")] Casopis casopis) { if (ModelState.IsValid) { db.Casopis.Add(casopis); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(casopis)); }
public static void Spremi(Casopis k) { BP.otvoriKonekciju(); SqliteCommand command = BP.komanda(); command.CommandText = @"create table if not exist Casopis ( id integer primary key autoincrement, naziv string, tagovi string)" ; }
// GET: Casopis/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Casopis casopis = db.Casopis.Find(id); if (casopis == null) { return(HttpNotFound()); } return(View(casopis)); }