// GET: Knjige/Create
public ActionResult Create()
{
KnjigaZanrViewModel knjigaZanrViewModel = new KnjigaZanrViewModel
{
autori = db.Autoris.OrderBy(a => a.ime).ToList(),
zanrovi = db.Zanrs.OrderBy(z => z.vrsta).ToList()
};
return(View("~/Views/Back-end/Knjige/Create.cshtml", knjigaZanrViewModel));
}
// GET: Knjiga/Create
public ActionResult Create()
{
KnjigaZanrViewModel knjigaZanrViewModel = new KnjigaZanrViewModel();
string query = "SELECT * FROM zanr";
DataTable dt = new DataTable();
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = query;
SqlDataAdapter dataAdapter = new SqlDataAdapter();
dataAdapter.SelectCommand = cmd;
dataAdapter.Fill(ds, "zanr");
dt = ds.Tables["zanr"];
conn.Close();
}
}
List <Zanr> sviZanrovi = new List <Zanr>();
foreach (DataRow dataRow in dt.Rows)
{
int zanrId = int.Parse(dataRow["Id"].ToString());
string zanrNaziv = dataRow["Naziv"].ToString();
sviZanrovi.Add(new Zanr(zanrId, zanrNaziv));
}
knjigaZanrViewModel.SviZanrovi = sviZanrovi;
return(View(knjigaZanrViewModel));
}
