public override void Delete(int subjectId)
{
if (GroupValidation.IsValidGroupId(subjectId))
{
DataAccessProvider.ExecuteNonQuery($"DELETE Subjects WHERE SubjectID = {subjectId}");
}
}
public override void Delete(int groupId)
{
if (GroupValidation.IsValidGroupId(groupId))
{
DataAccessProvider.ExecuteNonQuery($"DELETE Groups WHERE GroupID = {groupId}");
}
}
public override void Create(Group group)
{
if (GroupValidation.IsValidGroup(group))
{
DataAccessProvider.ExecuteNonQuery($"INSERT INTO Groups (GroupName, UniversityID) " +
$"values (\'{group.GroupName}\'," +
$"{group.UniversityId})");
}
}
public override void Update(Group group)
{
if (GroupValidation.IsValidGroup(group) && GroupValidation.IsValidGroupId(group.GroupId))
{
DataAccessProvider.ExecuteNonQuery($"UPDATE Groups SET " +
$"GroupName = \'{group.GroupName}\', " +
$"UniversityID = {group.UniversityId} " +
$"WHERE GroupID = {group.GroupId}");
}
}
private static void ValidateGroupCount(int count)
{
if (!GroupValidation.IsGroupCountWithinRange(count))
{
throw new ArgumentException(
string.Format(
TournamentResources.GroupCountOutOfRange,
GroupConstants.MIN_GROUPS_COUNT,
GroupConstants.MAX_GROUPS_COUNT));
}
}
