public void InsertTravelPartner(Travelpartner travelpartner, bool volwassene, MainCustomer mainCustomer)
{
string QUERY = $"Boeking_InsertTravelPartner";
SqlCommand CMD = new SqlCommand(QUERY, Conn);
//To prevent SQL-injection
CMD.Parameters.AddWithValue("@Naam", travelpartner.Firstname + " " + travelpartner.Lastname);
CMD.Parameters.AddWithValue("@Aanhef", travelpartner.Preamble);
CMD.Parameters.AddWithValue("@Geboortedatum", travelpartner.DateOfBirth);
CMD.Parameters.AddWithValue("@Volwassenen", volwassene);
CMD.Parameters.AddWithValue("@Hoofdboeker_ID", mainCustomer.ID);
CMD.CommandType = CommandType.StoredProcedure;
try
{
if (OpenConnection())
{
CMD.ExecuteNonQuery();
}
}
catch (SqlException exception)
{
throw new Exception(exception.ToString());
}
finally
{
CloseConnection();
}
}
public void PlaatsBoeking()
{
Boeking boeking = new Boeking(99, true, 100M, 2, 2, true, true);
MainCustomer mainCustomer = new MainCustomer("testadress", "testresidence", "testtelephonenumber", "testmail", Preamble.dhr, DateTime.Now, "testname", "testname");
List <Travelpartner> travelpartners = new List <Travelpartner>();
Travelpartner travelpartner = new Travelpartner(true, Preamble.dhr, DateTime.Now, "testpartnername", "testpartnerlastname");
travelpartners.Add(travelpartner);
mainCustomer.Boeking = boeking;
BoekingRepository boekingRepository = new BoekingRepository(BoekingFactory.Get(1));
boekingRepository.Insert(mainCustomer, travelpartners);
//assert GetBoeking() in repositoryPattern moet nog geimplementeerd worden.
}
public bool Insert(Travelpartner Travelpartner)
{
return(iTravelpartnerContext.Insert(Travelpartner));
}
public bool Insert(Travelpartner Travelpartner)
{
throw new NotImplementedException();
}
