private void spSalgsTal(SalgsTal salgsTal, BilletType billetType) { using (SqlConnection connection = new SqlConnection(ConnectionString)) { SqlCommand command = new SqlCommand(); command.CommandText = "EXECUTE spSalgsTal @Bevægelse, @BilletType, @SalgsDato"; command.Parameters.AddWithValue("@Bevægelse", salgsTal.Solgt); command.Parameters.AddWithValue("@BilletType", billetType.ID); command.Parameters.AddWithValue("@SalgsDato", salgsTal.Dato); command.Connection = connection; command.Connection.Open(); command.ExecuteNonQuery(); connection.Close(); } }
private void spGetSalgsTal(BilletType billet) { using (SqlConnection connection = new SqlConnection(ConnectionString)) { SqlCommand command = new SqlCommand(); command.CommandText = "EXECUTE [spGetSalgsTal] @BilletID"; command.Parameters.AddWithValue("@BilletID", billet.ID); command.Connection = connection; connection.Open(); SqlDataReader Reader = command.ExecuteReader(); if (Reader.HasRows) { while (Reader.Read()) { DateTime date = (DateTime)Reader["SalgsDato"]; int sold = (int)Reader["Bevægelse"]; SalgsTal tal = new SalgsTal(date, sold); billet.SamledeSalgsTal.Add(tal); } } } }