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));
}
