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