public void Delete(int id) { List <SqlParameter> pars = new List <SqlParameter>(); pars.Add(new SqlParameter("id", id)); EnterpriseDAO.Delete("DeleteTestConfiguration", System.Data.CommandType.StoredProcedure, pars); }
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()); }
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)); }
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)); }
public void Update(TestConfiguration item) { EnterpriseDAO.Update("UpdateTestConfiguration", System.Data.CommandType.StoredProcedure, DataHelper.GetParamsForTestConfiguration(item)); }
public List <TestConfiguration> Get() { var dt = EnterpriseDAO.Get("GetTestConfigurations", System.Data.CommandType.StoredProcedure, null); return(DataHelper.DataTableToObjects <TestConfiguration>(dt, ToObject)); }
public void Update(Topic item) { EnterpriseDAO.Update("UpdateTopic", System.Data.CommandType.StoredProcedure, DataHelper.GetParamsForTopic(item)); }
public void Add(TestSubject item) { EnterpriseDAO.Update("AddTestSubject", System.Data.CommandType.StoredProcedure, DataHelper.GetParamsForTestSubject(item)); }
public List <Subject> Get() { var dt = EnterpriseDAO.Get("GetSubjects", System.Data.CommandType.StoredProcedure, null); return(DataHelper.DataTableToObjects <Subject>(dt, ToObject)); }