public string getPersonen(int Ticketid)
{
TicketAccess t = new TicketAccess();
DataTable table = t.getPersonenPerTicket(Ticketid);
int atl = table.Rows.Count;
string str = "";
for (int i = 0; i < atl; i++)
{
str += "<li> " + table.Rows[i][2] + " " + table.Rows[i][3] + " </li>";
}
return str;
}
protected void btnAnnuleer_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
int TicketID = Int32.Parse(btn.ToolTip.ToString());
TicketAccess t = new TicketAccess();
DataTable table = t.getDatum(TicketID);
string date = table.Rows[0][0].ToString();
DateTime d = DateTime.Parse(date);
DateTime today = new DateTime();
if (d.AddDays(3) >= today)
{
t.AnnuleerTicket(TicketID);
updateRitten();
}
else
{
Response.Write("<script LANGUAGE='JavaScript'>alert('Deze Rit kan niet worden geannuleerd!');</script>");
}
}
protected void btnBevestig_Click(object sender, EventArgs e)
{
TicketAccess tktacc = new TicketAccess();
PersoonAccess persacc = new PersoonAccess();
CapaciteitAccess capacc = new CapaciteitAccess();
GridView grdRitten = (GridView)Session["VPR_grdRitten"];
DataTable rit = (DataTable)Session["VPR_tempRit"];
mail = new StringBuilder();
mail.Append("Beste "+ (String)Session["VPR_fullnaam"]+",");
mail.AppendLine("<br/>");
mail.AppendLine("<br/>");
mail.Append("U heeft volgende reis bij VPRtravel geboekt:");
mail.AppendLine("<br/>");
// rij id in het sessionobject met de bestellingstabel
int i = 0;
foreach (DataRow r in bestelling.Rows)
{
//mail opstellen
mail.Append(r.ItemArray[6].ToString() +" - "+r.ItemArray[7].ToString());
mail.AppendLine("<br/>");
TicketData t = new TicketData();
t.gebruikerID = (int)Session["VPR_id"];
t.totalePrijs = Convert.ToDouble(r.ItemArray[1].ToString());
String s = r.ItemArray[2].ToString();
t.aankomstdatum = DateTime.Parse(r.ItemArray[2].ToString());
t.vertrekdatum = DateTime.Parse(r.ItemArray[3].ToString());
t.typeID = Convert.ToInt32(r.ItemArray[4].ToString());
t.treinID = Convert.ToInt32(r.ItemArray[5].ToString());
tktacc.addTicket(t);
int tID = Convert.ToInt32(tktacc.getTicket(t).Rows[0].ItemArray[0]);
int tRowID = i;
i++;
DataTable pers = (DataTable)Session["VPR_personen"];
//mail opstellen
mail.Append("met volgende personen als reizigers:");
mail.AppendLine("<br/>");
foreach (DataRow pr in pers.Rows)
{
if(pr.ItemArray[0].ToString().Equals(tRowID.ToString()))
{
PersoonData p = new PersoonData();
p.ticketID = tID;
p.voornaam = pr.ItemArray[1].ToString();
p.naam = pr.ItemArray[2].ToString();
p.stoelnr = pr.ItemArray[3].ToString();
persacc.addPersoon(p);
//mail opstellen
mail.Append(p.naam +" "+p.voornaam);
mail.AppendLine("<br/>");
}
}
for (int j = 0; j < rit.Rows.Count; j++)
{
DateTime datum = DateTime.Parse(grdRitten.Rows[j].Cells[0].Text);
DataTable d = new CapaciteitAccess().getCapa(datum, Convert.ToInt32(rit.Rows[j].ItemArray[0].ToString()));
CapaciteitData c = new CapaciteitData();
c.datum = datum;
c.ritID = Convert.ToInt32(rit.Rows[j].ItemArray[0].ToString());
double extraCapa= specialeDagen(datum, Convert.ToInt32(rit.Rows[j].ItemArray[1].ToString()));
if (d.Rows.Count != 0)
{
c.capaciteit = Convert.ToInt32((extraCapa*Convert.ToInt32(d.Rows[0].ItemArray[0].ToString())) - pers.Rows.Count);
capacc.updateCapa(c);
}
else
{
DataTable ritTabel = new RitAccess().getRitById(Convert.ToInt32(rit.Rows[j].ItemArray[0].ToString()));
c.capaciteit = Convert.ToInt32((extraCapa*Convert.ToInt32(ritTabel.Rows[0].ItemArray[2].ToString())) - pers.Rows.Count);
capacc.addCapa(c);
}
}
}
//mail opstellen
mail.AppendLine("<br/>");
mail.AppendLine("<br/>");
mail.Append("Mvg");
mail.AppendLine("<br/>");
mail.Append("Het VPRtravel team");
String emailAdress = new GebruikersAccess().getMailByID(Convert.ToInt32(Session["VPR_id"].ToString()));
Mail.sendMail(mail.ToString(),emailAdress ,Session["VPR_fullnaam"].ToString());
Response.Redirect("BoekSucces.aspx");
}