public GradoviOpcine GetGradoviOpcineByID(int idGrad) { ISqlGenerator <GradoviOpcine> sqlGenerator = new SqlGenerator <GradoviOpcine>(); try { // Create repository instance GradoviOpcineRepository repository = new GradoviOpcineRepository(SqlCon, sqlGenerator); // Call repository method var items = repository.GetFirst("HKO.s_gradovi_opcine", new { ID = idGrad }); return(items); } catch (Exception ex) { throw; } }
public IEnumerable <GradoviOpcine> GetGradoviOpcineByZupanijaID(int idZupanija) { ISqlGenerator <GradoviOpcine> sqlGenerator = new SqlGenerator <GradoviOpcine>(); try { // Create repository instance GradoviOpcineRepository repository = new GradoviOpcineRepository(SqlCon, sqlGenerator); // Call repository method var items = repository.GetWhere("HKO.s_gradovi_opcine", new { ZUP_ID = idZupanija }); return(items); } catch (Exception ex) { throw; } }
public IEnumerable <GradoviOpcine> GetGradoviOpcine() { ISqlGenerator <GradoviOpcine> sqlGenerator = new SqlGenerator <GradoviOpcine>(); try { // Create repository instance GradoviOpcineRepository repository = new GradoviOpcineRepository(SqlCon, sqlGenerator); // Call repository method var items = repository.GetAll("HKO.s_gradovi_opcine"); return(items); } catch (Exception ex) { throw; } }