public bool Insert(DALYear year)
{
using (var connection = new SQLiteConnection(connectionString))
{
SQLiteCommand command = new SQLiteCommand(null, connection);
int res = -1;
try
{
connection.Open();
command.CommandText = $"INSERT INTO {YearTableName} ({DALYear.yearNumberColumn} ,{DALYear.yearCreditColumn},{DALYear.yearAverageColumn},{DALYear.yearDegreeColumn},{DALYear.yearStudentIdColumn}) " +
$"VALUES (@numVal,@creditVal,@averageVal@yearVal,@degreeVal,@studentIdVal);";
SQLiteParameter nameParam = new SQLiteParameter(@"numVal", year.Number);
SQLiteParameter creditParam = new SQLiteParameter(@"creditVal", year.Credit);
SQLiteParameter averageParam = new SQLiteParameter(@"averageVal", year.Average);
SQLiteParameter degreeParam = new SQLiteParameter(@"degreeVal", year.Degree);
SQLiteParameter studentIdParam = new SQLiteParameter(@"studentIdVal", year.StudentId);
command.Parameters.Add(nameParam);
command.Parameters.Add(creditParam);
command.Parameters.Add(averageParam);
command.Parameters.Add(degreeParam);
command.Parameters.Add(studentIdParam);
command.Prepare();
res = command.ExecuteNonQuery();
}
catch (Exception e)
{
if (e.Message != null)
{
}
}
finally
{
command.Dispose();
connection.Close();
}
return(res > 0);
}
}
protected override DALObj ConvertReaderToObject(SQLiteDataReader reader)
{
DALYear ret = new DALYear(reader.GetInt32(0), reader.GetInt32(1), reader.GetDouble(2), reader.GetString(4), reader.GetInt32(5));
return(ret);
}
