/// <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;
}
