public StudyPlan GetStudyPlan(int id)
{
string query = $"SELECT * FROM SWZ.dbo.planystudiow WHERE id={id}";
connection = new SqlConnection(connectionString);
command = new SqlCommand(query, connection);
StudyPlan studyPlan = null;
connection.Open();
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
studyPlan = new StudyPlan(dataReader.GetInt32(0));
studyPlan.facultySymbol = dataReader.GetString(1);
studyPlan.fieldOfStudy = dataReader.GetString(2);
studyPlan.degreeOfStudy = dataReader.GetInt32(3);
studyPlan.language = dataReader.GetInt32(4);
studyPlan.typeOfStudies = dataReader.GetInt32(5);
}
dataReader.Close();
command.Dispose();
connection.Close();
return(studyPlan);
}
public void SaveStudyPlan(StudyPlan studyPlan)
{
throw new NotImplementedException();
}