public List <TestGroupDTO> GetByGroupIdTestId(TestGroupDTO testgroup) { using (IDbConnection connection = Connection.GetConnection()) { string sqlExpression = "Test_Group_GetByGroupIdTestId"; return(connection.Query <TestGroupDTO>(sqlExpression, testgroup, commandType: CommandType.StoredProcedure).ToList()); } }
public void DeleteByGroupIdTestId(TestGroupDTO testgroup) { using (IDbConnection connection = Connection.GetConnection()) { string sqlExpression = "Test_Group_DeleteByGroupIdTestId"; connection.Execute(sqlExpression, testgroup, commandType: CommandType.StoredProcedure); } }
public int Add(TestGroupDTO testgroup) { using (IDbConnection connection = Connection.GetConnection()) { string sqlExpression = "Test_Group_Add @GroupId, @TestId, @startDate, @endDate"; return(connection.Query <int>(sqlExpression, testgroup).FirstOrDefault()); } }
public int SetTestForGroup(TestGroupDTO testgroup) // метод - назначить тест - записать из круда { TestGroupCRUD teacher = new TestGroupCRUD(); return(teacher.Add(testgroup)); }