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