//Een bestaand ticket bewerken
public static int EditTicketHolder(Ticket holder)
{
try
{
String sSQL = "Update Ticket Set TicketHolder=@TicketHolder,TicketHolderEmail=@TicketHolderEmail,Amount=@Amount WHERE ID=@ID";
DbParameter par1 = Database.AddParameter("@Ticketholder", holder.TicketHolder);
if (par1.Value == null) par1.Value = DBNull.Value;
DbParameter par2 = Database.AddParameter("@TicketHolderEmail", holder.TicketHolderEmail);
if (par2.Value == null) par2.Value = DBNull.Value;
DbParameter par4 = Database.AddParameter("@Amount", holder.Amount);
if (par4.Value == null) par4.Value = DBNull.Value;
DbParameter par5 = Database.AddParameter("@ID", holder.Id);
if (par5.Value == null) par5.Value = DBNull.Value;
DbParameter[] pars = new DbParameter[] { par1, par2, par4, par5 };
int affected = Database.ModifyData(sSQL, pars);
return affected;
}
catch (Exception ex) { Console.WriteLine(ex.Message); return 0; }
}
//De laatste nieuwe toegevoegde ophalen
public static Ticket GetLastTicketHolder()
{
try
{
Ticket LastTicket = new Ticket();
ObservableCollection<TicketType> l = TicketType.GetTicketTypes();
DbDataReader reader = Database.GetData("SELECT * FROM Ticket WHERE Id = (SELECT max(Id) FROM Ticket)");
while (reader.Read())
{
int idTicketType = int.Parse(reader["TicketType"].ToString());
TicketType type = GetTicketTypeByID(l, idTicketType);
Ticket holder = Create(reader, type);
return holder;
}
return null;
}
catch (Exception ex) { Console.WriteLine(ex.Message); return null; }
}
//Een nieuw ticket toevoegen in database
public static int AddTicketHolder(Ticket holder)
{
try
{
String sSQL = "INSERT INTO Ticket(TicketHolder, TicketHolderEmail, TicketType, Amount) VALUES(@TicketHolder, @TicketHolderEmail, @TicketType, @Amount)";
DbParameter par1 = Database.AddParameter("@TicketHolder", holder.TicketHolder);
if (par1.Value == null) par1.Value = DBNull.Value;
DbParameter par2 = Database.AddParameter("@TicketHolderEmail", holder.TicketHolderEmail);
if (par2.Value == null) par2.Value = DBNull.Value;
DbParameter par3 = Database.AddParameter("@TicketType", holder.TicketType.Id);
if (par3.Value == null) par3.Value = DBNull.Value;
DbParameter par4 = Database.AddParameter("@Amount", holder.Amount);
if (par4.Value == null) par4.Value = DBNull.Value;
DbParameter[] pars = new DbParameter[] { par1, par2, par3, par4 };
int affected = Database.ModifyData(sSQL, pars);
return affected;
}
catch (Exception ex) { Console.WriteLine(ex.Message); return 0; }
}
