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