public static TicketType VerwerkRij(IDataRecord rij) { TicketType type = new TicketType(); type.ID = Convert.ToInt32(rij["ID"].ToString()); type.AvailableTickets = Convert.ToInt32( rij["AvailableTickets"].ToString()); type.Name = rij["Name"].ToString(); type.Price = Convert.ToInt32(rij["Price"].ToString()); type.Datum = Convert.ToDateTime(rij["Datum"]); type.kortedatum = Convert.ToDateTime(rij["Datum"]).ToShortDateString(); return type; }
public static void DeleteType(TicketType type) { try { DbParameter paramName = Database.AddParameter("@Name",type.Name ); Database.ModifyData("DELETE FROM TicketType WHERE Name = @Name", paramName); } catch (Exception e) { throw e; } }
public static void AddType(TicketType newticket) { string datum = newticket.Datum.ToShortDateString(); try { DbParameter paramName = Database.AddParameter("@Name",newticket.Name ); DbParameter paramPrijs = Database.AddParameter("@Price",newticket.Price ); DbParameter paramTicket = Database.AddParameter("@AvailableTickets",newticket.AvailableTickets ); DbParameter paramDatum = Database.AddParameter("@datum", datum); Database.ModifyData("INSERT INTO TicketType (Name,Price,AvailableTickets,Datum) values (@Name,@Price,@AvailableTickets,@datum)", paramName, paramPrijs, paramTicket,paramDatum); } catch (Exception e) { Console.WriteLine(e.Message); } }
public static TicketType GetTicketTypeByID(int p) { TicketType nieuw = new TicketType(); string sql = "SELECT * FROM TicketType WHERE ID like @ID"; DbParameter paramID = Database.AddParameter("@ID", p); DbDataReader reader = Database.GetData(sql, paramID); while (reader.Read()) { nieuw = VerwerkRij(reader); } return nieuw; }
public static void EditTicket(TicketType tick) { try { //band gedeelte string sql = "UPDATE TicketType SET Name=@name, Price=@price, AvailableTickets=@available, Datum=@datum WHERE ID=@ID;"; DbParameter par1 = Database.AddParameter("@name", tick.Name); DbParameter par2 = Database.AddParameter("@price", tick.Price); DbParameter par3 = Database.AddParameter("@datum", tick.Datum); DbParameter par4 = Database.AddParameter("@available", tick.AvailableTickets); DbParameter parID = Database.AddParameter("@ID", Convert.ToInt16(tick.ID)); Database.ModifyData(sql, par1, par2, par3, par4, parID); } catch (Exception ex) { Console.WriteLine(ex.Message); throw ex; } }
//Tickettype methods public void AddTickettype() { TicketType newType = new TicketType(); Tickettypes.Add(newType); SelectedTicketType = newType; }