Esempio n. 1
0
        public List <TestSubject> Get(int testid)
        {
            List <SqlParameter> pars = new List <SqlParameter>();

            pars.Add(new SqlParameter("testID", testid));
            var dt = EnterpriseDAO.Get("GetTestSubjects", System.Data.CommandType.StoredProcedure, pars);

            return(DataHelper.DataTableToObjects <TestSubject>(dt, ToObject));
        }
Esempio n. 2
0
        public TestConfiguration Get(int id)
        {
            List <SqlParameter> pars = new List <SqlParameter>();

            pars.Add(new SqlParameter("id", id));
            var dt = EnterpriseDAO.Get("GetTestConfigurations", System.Data.CommandType.StoredProcedure, pars);

            return(DataHelper.DataTableToObjects <TestConfiguration>(dt, ToObject).FirstOrDefault());
        }
Esempio n. 3
0
        public List <Entities.IDNamePair> Get(string tableName)
        {
            var dt = EnterpriseDAO.Get("select * from " + tableName, System.Data.CommandType.Text, null);

            return(DataHelper.DataTableToObjects <IDNamePair>(dt, ToObject));
        }
Esempio n. 4
0
        public List <TestConfiguration> Get()
        {
            var dt = EnterpriseDAO.Get("GetTestConfigurations", System.Data.CommandType.StoredProcedure, null);

            return(DataHelper.DataTableToObjects <TestConfiguration>(dt, ToObject));
        }
Esempio n. 5
0
        public List <Subject> Get()
        {
            var dt = EnterpriseDAO.Get("GetSubjects", System.Data.CommandType.StoredProcedure, null);

            return(DataHelper.DataTableToObjects <Subject>(dt, ToObject));
        }