//프로잭트만들기
private void projectMaking_Click(object sender, EventArgs e)
{
string pj = btPj.Text;
treeView1.Nodes.Add(pj);
btPj.Text = "";
project = new Project(pj);
}
static void Main()
{
using (var game = new Project())
game.Run();
}
public static ObservableCollection<Ticket> GetTicketsZoek(string EntryName, string Name, Project.TicketType ticketType)
{
string ticket="";
if (ticketType == null)
{
ticket = "";
}
else
{
ticket = ticketType.Name;
}
ObservableCollection<Ticket> tickets = new ObservableCollection<Ticket>();
DbDataReader reader = Database.GetData("SELECT tbl_ticket.ID as TicketId,tbl_ticketType.ID as TypeId ,Ticketholder,TicketholderEmail, EntryName, Amount, OrderDate,TicketName,Price,Available FROM tbl_ticketType,tbl_ticket WHERE tbl_ticketType.ID=tbl_ticket.TicketType AND EntryName LIKE @entryname AND TicketHolder LIKE @name AND Tbl_ticketType.TicketName LIKE @tickettype",
Database.AddParameter("@entryname","%"+EntryName+"%"),
Database.AddParameter("@name", "%" + Name + "%"),
Database.AddParameter("@tickettype", "%" + ticket + "%")
);
foreach (IDataRecord db in reader)
{
tickets.Add(Create(db));
}
return tickets;
}
