public bool Insert(MainCustomer mainCustomer, List <Travelpartner> travelPartners)
{
try
{
mainCustomer = InsertMainCustomer(mainCustomer);
foreach (Travelpartner travelpartner in travelPartners)
{
if (travelpartner == travelPartners[0])
{
InsertTravelPartner(travelpartner, true, mainCustomer);
}
else
{
InsertTravelPartner(travelpartner, false, mainCustomer);
}
}
mainCustomer.Boeking.Transport = InsertTransport(mainCustomer.Boeking.Transport);
InsertBoeking(mainCustomer);
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public BoekingViewModel()
{
travelpartners = new List <Travelpartner>();
maincustomer = new MainCustomer();
mvr = Preamble.mvr;
dhr = Preamble.dhr;
}
public MainCustomer InsertMainCustomer(MainCustomer mainCustomer)
{
string QUERY = $"Boeking_InsertHoofdboeker";
SqlCommand CMD = new SqlCommand(QUERY, Conn);
//To prevent SQL-injection
CMD.Parameters.AddWithValue("@Naam", mainCustomer.Firstname + " " + mainCustomer.Lastname);
CMD.Parameters.AddWithValue("@Aanhef", mainCustomer.Preamble);
CMD.Parameters.AddWithValue("@Geboortedatum", mainCustomer.DateOfBirth);
CMD.Parameters.AddWithValue("@Email", mainCustomer.Email);
CMD.Parameters.AddWithValue("@Adres", mainCustomer.Adress);
CMD.Parameters.AddWithValue("@Stad", mainCustomer.Residence);
CMD.CommandType = CommandType.StoredProcedure;
try
{
if (OpenConnection())
{
mainCustomer.ID = Convert.ToInt32(CMD.ExecuteScalar());
}
}
catch (SqlException exception)
{
throw new Exception(exception.ToString());
}
finally
{
CloseConnection();
}
return(mainCustomer);
}
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 MainCustomer InsertBoeking(MainCustomer mainCustomer)
{
string QUERY = $"Boeking_InsertBoeking";
SqlCommand CMD = new SqlCommand(QUERY, Conn);
//To prevent SQL-injection
CMD.Parameters.AddWithValue("@Korting", mainCustomer.Boeking.Discount);
CMD.Parameters.AddWithValue("@AantalKamers", mainCustomer.Boeking.Rooms);
CMD.Parameters.AddWithValue("@TotaalPrijs", mainCustomer.Boeking.Totalprice);
CMD.Parameters.AddWithValue("@AnnuleringsVerzekering", mainCustomer.Boeking.CancellationInsurance);
CMD.Parameters.AddWithValue("@ReisVerzekering", mainCustomer.Boeking.TravelInsurance);
//NOG TOEVOEGEN
CMD.Parameters.AddWithValue("@Accommodatie_ID", mainCustomer.Boeking.Accommodatie.ID);
CMD.Parameters.AddWithValue("@Vervoer_ID", mainCustomer.Boeking.Transport.ID);
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();
}
return(mainCustomer);
}
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 bool Insert(MainCustomer maincustomer)
{
throw new NotImplementedException();
}
public bool Insert(MainCustomer mainCustomer, List <Travelpartner> travelPartners)
{
return(iboekingContext.Insert(mainCustomer, travelPartners));
}
bool Insert(MainCustomer maincustomer)
{
return(iMainCustomerContext.Insert(maincustomer));
}
