/// <summary> /// Inserts a new ticket claim object in to the database /// </summary> /// <param name="ticketClaim">information about a ticket claim</param> public void InsertTicketClaim(TicketClaims ticketClaim) { SqlStatement statement = new SqlStatement(StoredProcedures.InsertTicketClaim); statement.AddParameter("EventId", ticketClaim.EventId); statement.AddParameter("EventName", ticketClaim.EventName); statement.AddParameter("FirstName", ticketClaim.FirstName); statement.AddParameter("LastName", ticketClaim.LastName); statement.AddParameter("EmailAddress", ticketClaim.EmailAddress); statement.AddParameter("UserName", ticketClaim.UserName); dataRepository.ExecuteStoredProc(statement); }
/// <summary> /// Maps ticket claims object /// </summary> /// <param name="data">the record from the database</param> /// <param name="rownum">the row numberof the record</param> /// <returns>A ticket claims object</returns> private TicketClaims TicketClaimsMapper(SqlReaderWrapper data, int rownum) { TicketClaims claims = new TicketClaims (data.GetInt("TicketClaimsId"), data.GetInt("EventId"), data.GetString("EventName"), data.GetString("FirstName"), data.GetString("LastName"), data.GetString("EmailAddress"), data.GetString("UserName"), data.GetDate("ClaimDate"), data.GetInt("TicketWins"), data.GetInt("HandRaises")); return(claims); }
/// <summary> /// Adds a team memeber's name to the list of ticket claims for a particular event /// </summary> /// <param name="loginName">the loginname of the individual who has raised their hand</param> /// <param name="eventName">the name of the event</param> /// <param name="eventId">the id of the event that the individual is interested in</param> public void InterestedInEvent(string loginName, string eventName, int eventId) { SelectUserQuery userQuery = new SelectUserQuery(new CurrentUser() { LoginName = loginName }); CurrentUser user = commandBus.ProcessQuery(userQuery); TicketClaims claim = new TicketClaims( ticketClaimsId: 0, eventName: eventName, eventId: eventId, firstName: user.FirstName, lastName: user.LastName, eMailAddress: user.EmailAddress, userName: loginName); InsertTicketClaim command = new InsertTicketClaim(claim); commandBus.Execute(command); }
/// <summary> /// Insert Ticket Claim Command Constructor /// </summary> public InsertTicketClaim(TicketClaims ticketClaim) { TicketClaim = ticketClaim; }