public HkoSifreDTO GetHkoSifreByID(string hkoSifra)
{
ISqlGenerator <HkoSifre> sqlGenerator = new SqlGenerator <HkoSifre>();
try
{
// Create repository instance
HkoSifreRepository repository = new HkoSifreRepository(SqlCon, sqlGenerator);
// Call repository method
var items = HkoSifreHandler.MapHkoSifreToDtO(repository.GetAll("HKO.s_hko_sifre"));
// Get sector if hkoSifra is for sector
var response = items.FirstOrDefault(x => x.ID == hkoSifra);
// Get sub-sector if hkoSifra is for sub-sector
if (response == null)
{
response = items.SelectMany(x => x.Podsektori).First(y => y.ID == hkoSifra);
}
return(response);
}
catch (Exception ex)
{
throw;
}
}
public IList <HkoSifreDTO> GetHkoSifre()
{
ISqlGenerator <HkoSifre> sqlGenerator = new SqlGenerator <HkoSifre>();
try
{
// Create repository instance
HkoSifreRepository repository = new HkoSifreRepository(SqlCon, sqlGenerator);
// Call repository method
var items = repository.GetAll("HKO.s_hko_sifre");
return(HkoSifreHandler.MapHkoSifreToDtO(items));
}
catch (Exception ex)
{
throw;
}
}