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 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);
}
}
public static void ReserveerTicket(Ticket ticket)
{
Ticket.AddType(ticket);
}
private void AddTicket()
{
FestivalLib.Model.Ticket nieuw = new FestivalLib.Model.Ticket();
Tickets.Add(nieuw);
SelectedTicket = nieuw;
}
public static void DeleteType(Ticket SelectedTicket)
{
try
{
DbParameter paramName = Database.AddParameter("@Name", SelectedTicket.ID);
Database.ModifyData("DELETE FROM Ticket WHERE ID = @Name", paramName);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
public static void EditTicket(Ticket tick)
{
try
{
//band gedeelte
string sql = "UPDATE Ticket SET TicketHolder=@name, TicketHolderEmail=@email, TicketType=@type, Amount=@amount WHERE ID=@ID;";
DbParameter par1 = Database.AddParameter("@name", tick.Ticketholder);
DbParameter par2 = Database.AddParameter("@email", tick.TicketholderEmail);
DbParameter par3 = Database.AddParameter("@type", tick.tickettype.ID);
DbParameter par4 = Database.AddParameter("@amount", tick.Amount);
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;
}
}
public static Ticket GetTicketByID(int id)
{
Ticket gevondenTicket = new Ticket();
foreach (Ticket ticket in Soorten)
{
if (ticket.ID == id)
{
gevondenTicket = ticket;
}
}
return gevondenTicket;
}
public static void PrintWord(Ticket ticket, Festival festival, string sPad)
{
string sFileNaam = ticket.ID + "_" + ticket.Ticketholder + ".docx";
string sFullPad = sPad + "\\" + sFileNaam;
try
{
File.Copy("C:\\Users\\jerry_000\\Dropbox\\2NMCT4\\S1\\Business applications\\Project\\FestivalApp\\word\\template.docx", sFullPad, true);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
WordprocessingDocument newDoc = WordprocessingDocument.Open(sFullPad, true);
IDictionary<string, BookmarkStart> bookmarks = new Dictionary<string, BookmarkStart>();
foreach (BookmarkStart bms in newDoc.MainDocumentPart.RootElement.Descendants<BookmarkStart>())
{
bookmarks[bms.Name] = bms;
}
//Festival name moet iets anders qua opmaak zijn
Run runTitle = new Run(new Text(festival.Naam));
RunProperties propTitle = new RunProperties();
RunFonts fontTitle = new RunFonts() { Ascii = "Segoe UI", HighAnsi = "Segoe UI" };
FontSize sizeTitle = new FontSize() { Val = "36" };
propTitle.Append(fontTitle);
propTitle.Append(sizeTitle);
runTitle.PrependChild<RunProperties>(propTitle);
bookmarks["FestivalTitle"].Parent.InsertAfter<Run>(runTitle, bookmarks["FestivalTitle"]);
bookmarks["Name"].Parent.InsertAfter<Run>(new Run(new Text(ticket.Ticketholder)), bookmarks["Name"]);
bookmarks["Email"].Parent.InsertAfter<Run>(new Run(new Text(ticket.TicketholderEmail)), bookmarks["Email"]);
bookmarks["Day"].Parent.InsertAfter<Run>(new Run(new Text(ticket.tickettype.Name)), bookmarks["Day"]);
bookmarks["Type"].Parent.InsertAfter<Run>(new Run(new Text(ticket.tickettype.Name)), bookmarks["Type"]);
bookmarks["Amount"].Parent.InsertAfter<Run>(new Run(new Text(ticket.Amount.ToString())), bookmarks["Amount"]);
bookmarks["Price"].Parent.InsertAfter<Run>(new Run(new Text(ticket.tickettype.Price.ToString())), bookmarks["Price"]);
double iTotalPrice = ticket.Amount * ticket.tickettype.Price;
bookmarks["Totalprice"].Parent.InsertAfter<Run>(new Run(new Text(iTotalPrice.ToString())), bookmarks["Totalprice"]);
//BARCODE TOEVOEGEN
//string code = Guid.NewGuid().ToString();
string code = GenerateUnique(ticket.TicketholderEmail);
Run run = new Run(new Text(code));
RunProperties prop = new RunProperties();
RunFonts font = new RunFonts() { Ascii = "Free 3 of 9 Extended", HighAnsi = "Free 3 of 9 Extended" };
FontSize size = new FontSize() { Val = "96" };
prop.Append(font);
prop.Append(size);
run.PrependChild<RunProperties>(prop);
bookmarks["Barcode"].Parent.InsertAfter<Run>(run, bookmarks["Barcode"]);
newDoc.Close();
MessageBox.Show(sFullPad + " is opgeslaan");
}
