public ActionResult Insert(Ticketholder reservatie) { ViewBag.TypeID = new SelectList(TickettypeRepository.GetTypes(), "ID", "Name"); if (ModelState.IsValid) { TicketholderRepository.InsertReservatie(reservatie); return(View("Ticket", reservatie)); } return(View()); }
private static Ticketholder Fill(DbDataReader reader) { Ticketholder reservatie = new Ticketholder(); reservatie.ID = (int)reader["ID"]; reservatie.Name = reader["Name"].ToString(); reservatie.FirstName = reader["FirstName"].ToString(); reservatie.Email = reader["Email"].ToString(); reservatie.Amount = (int)reader["Amount"]; reservatie.TypeID = (int)reader["TickettypeID"]; reservatie.Type = TickettypeRepository.FindById(reservatie.TypeID); return(reservatie); }
public static void InsertReservatie(Ticketholder reservatie) { string sSQL = null; //1. SQL instructie + parameters sSQL = "INSERT INTO Ticketholders(Name, FirstName, Email, Amount, TickettypeID) "; sSQL += "VALUES (@Name,@FirstName,@Email,@Amount,@TypeID)"; DbParameter parName = Database.AddParameter("@Name", reservatie.Name); DbParameter parFirstName = Database.AddParameter("@FirstName", reservatie.FirstName); DbParameter parEmail = Database.AddParameter("@Email", reservatie.Email); DbParameter parTypeID = Database.AddParameter("@TypeID", reservatie.TypeID); DbParameter parAmount = Database.AddParameter("@Amount", reservatie.Amount); string sSQL2 = "UPDATE Tickettypes SET Tickettypes.Available=Tickettypes.Available-@Aantal "; sSQL2 += "FROM Tickettypes INNER JOIN Ticketholders ON Tickettypes.ID = Ticketholders.TickettypeID "; sSQL2 += "WHERE Tickettypes.ID=@TypeID"; DbParameter parAantal = Database.AddParameter("@Aantal", reservatie.Amount); DbParameter parType = Database.AddParameter("@TypeID", reservatie.TypeID); //2. Execute met SQL parameters Database.GetData(sSQL, parName, parFirstName, parEmail, parTypeID, parAmount); Database.GetData(sSQL2, parAantal, parType); }