private static Ticket VerwerkRij(IDataRecord rij)
{
Ticket nieuw = new Ticket();
nieuw.ID = Int32.Parse(rij["ID"].ToString());
nieuw.Ticketholder = rij["TicketHolder"].ToString();
nieuw.TicketholderEmail = rij["TicketHolderEmail"].ToString();
nieuw.Amount = Int32.Parse( rij["Amount"].ToString());
nieuw.tickettype = TicketType.GetTicketTypeByID(Convert.ToInt32(rij["TicketType"].ToString()));
return nieuw;
}
public static void DeleteType(Ticket SelectedTicket)
{
try
{
DbParameter paramName = Database.AddParameter("@Name", SelectedTicket.Ticketholder);
Database.ModifyData("DELETE FROM TicketType WHERE Name = @Name", paramName);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static void AddType(Ticket SelectedTicket)
{
try
{
DbParameter paramHolder = Database.AddParameter("@Holder", SelectedTicket.Ticketholder);
DbParameter paramEmail = Database.AddParameter("@Email", SelectedTicket.TicketholderEmail);
DbParameter paramAmount = Database.AddParameter("@Amount", SelectedTicket.Amount);
DbParameter paramTicketType = Database.AddParameter("@Type", SelectedTicket.tickettype.ID);
Database.ModifyData("INSERT INTO Ticket (TicketHolder,TicketHolderEmail,TicketType,Amount) values (@Holder,@Email,@Type,@Amount)", paramHolder,paramEmail,paramTicketType,paramAmount);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
