public IEnumerable<JednaKategoriaModel> Get() { var model = new ListaKategoriiModel(); var categoriesDataTable = WroBL.DAL.DatabaseUtils.EleentsToDataTable("select c.id,c.name,c.img_link from categories c left join cat2event c2e on c.id=c2e.categories left join \"EVENT\" e on e.id = c2e.\"EVENT\" where e.id is not null").AsEnumerable(); model.ListaKategorii = (from item in categoriesDataTable select new JednaKategoriaModel { Id = item.Field<int>("id"), Nazwa = item.Field<string>("name"), LinkDoObrazka = item.Field<string>("img_link") }).ToList(); return model.ListaKategorii; }
public ActionResult Kategorie() { var model = new ListaKategoriiModel(); var categoriesDataTable = WroBL.DAL.DatabaseUtils.EleentsToDataTable("select id,name,img_link from categories").AsEnumerable(); model.ListaKategorii = (from item in categoriesDataTable select new Models.JednaKategoriaModel { Id = item.Field<int>("id"), Nazwa = item.Field<string>("name"), LinkDoObrazka = item.Field<string>("img_link") }).ToList(); return View(model); }