public Nkz7 GetNkz7ByID(string nkz7ID) { ISqlGenerator <Nkz7> sqlGenerator = new SqlGenerator <Nkz7>(); try { // Create repository instance Nkz7Repository repository = new Nkz7Repository(SqlCon, sqlGenerator); // Call repository method var items = repository.GetFirst("HKO.s_nkz7", new { NKZ7_ID = nkz7ID }); return(items); } catch (Exception ex) { throw; } }
public IEnumerable <Nkz7> GetNkz7() { ISqlGenerator <Nkz7> sqlGenerator = new SqlGenerator <Nkz7>(); try { // Create repository instance Nkz7Repository repository = new Nkz7Repository(SqlCon, sqlGenerator); // Call repository method var items = repository.GetAll("HKO.s_nkz7"); return(items); } catch (Exception ex) { throw; } }