public List <ReplacementCourse> FindByReplacementId(int id) { string query = $"SELECT * FROM SWZ.dbo.zamienniki_kursy WHERE zamiennikid={id}"; List <ReplacementCourse> replacements_courses = new List <ReplacementCourse>(); using (connection = new SqlConnection(connectionString)) { command = new SqlCommand(query, connection); try { connection.Open(); dataReader = command.ExecuteReader(); while (dataReader.Read()) { ReplacementCourse replacementCourse = new ReplacementCourse(dataReader.GetInt32(0), dataReader.GetInt32(1)); replacements_courses.Add(replacementCourse); } }catch (Exception e) { Debug.WriteLine(e.Message); throw new NoDatasourceConnectionException(); } } return(replacements_courses); }
public void SaveReplacementCourse(ReplacementCourse replacementCourse) { string query = $"INSERT INTO SWZ.dbo.propozycje_kursy " + $"(propozycjaid, zamiennikid) VALUES ({replacementCourse.replacementID},{replacementCourse.courseID});"; using (connection = new SqlConnection(connectionString)) { command = new SqlCommand(query, connection); try { connection.Open(); command.ExecuteNonQuery(); }catch (Exception e) { Debug.WriteLine(e.Message); throw new NoDatasourceConnectionException(); } } }