public bool checkGradeThemeData(GradeTheme newGradetheme,
List <GradeTheme> oldGradeThemes)
{
if (newGradetheme.Contains(oldGradeThemes) | newGradetheme.GthName == null)
{
return(false);
}
else
{
return(true);
}
}
public bool chechIfGthExistsByName(GradeTheme newGradeTheme,
List <GradeTheme> gradeThemes)
{
foreach (GradeTheme gradeTheme in gradeThemes)
{
if (gradeTheme.GthName == newGradeTheme.GthName)
{
return(true);
}
}
return(false);
}
public bool checkIfGradeThemeReferenceExists(GradeTheme newGradeTheme,
List <GradeTheme> gradeThemes)
{
foreach (GradeTheme gradeTheme in gradeThemes)
{
if (gradeTheme.GthRetake_GthId == newGradeTheme.GthRetake_GthId &
gradeTheme.GthRetake_GthId != null & newGradeTheme.GthRetake_GthId != null)
{
return(true);
}
}
return(false);
}
public bool createNewGradeTheme(GradeTheme gradeTheme)
{
if (!(correction.checkGradeThemeData(gradeTheme, getAllGradeThemes())))
{
Console.WriteLine("Grade's theme is incorrect or exists in database."); return(false);
}
string sqlCreateNewGradeTheme;
if (gradeTheme.GthRetake_GthId == null)
{
sqlCreateNewGradeTheme = $"INSERT INTO GradeThemes " +
$"(GthName, Gth_SubId, Gth_TeaId, Gth_ClaId, Gth_DepCSTid) " +
$"VALUES ('{gradeTheme.GthName}',{gradeTheme.GthDepClaSubTea._SubId},{gradeTheme.GthDepClaSubTea._TeaId}, " +
$"{gradeTheme.GthDepClaSubTea._ClaId}, {gradeTheme.GthDepClaSubTea.DepCSTid})";
}
else
{
sqlCreateNewGradeTheme = $"INSERT INTO GradeThemes " +
$"(GthName, Gth_SubId, Gth_TeaId, Gth_ClaId, GthRetake_GthId, Gth_DepCSTid) " +
$"VALUES ('{gradeTheme.GthName}',{gradeTheme.GthDepClaSubTea._SubId},{gradeTheme.GthDepClaSubTea._TeaId}, " +
$"{gradeTheme.GthDepClaSubTea._ClaId}, {gradeTheme.GthRetake_GthId}, {gradeTheme.GthDepClaSubTea.DepCSTid})";
}
SqlCommand comCreateNewGradeTheme = new SqlCommand(sqlCreateNewGradeTheme, connection);
try
{
connection.Open();
comCreateNewGradeTheme.ExecuteNonQuery();
}
catch (SqlException)
{
Console.WriteLine("DATABASE createnewgradetheme ERROR");
}
finally
{
connection.Close();
}
return(true);
}