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);
}
}
}
}
