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