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