public Models.Person CreatePerson(PersonDto personDto)
{
var ageId = _age.GetAgeByType(personDto.Age).Id;
const string sql =
"INSERT INTO SkiTickets.Person VALUES (@firstName, @lastName, @ageId)" +
" SELECT * FROM SkiTickets.Person WHERE id = SCOPE_IDENTITY()";
return(TransformDaoToBusinessLogicPerson(_database.QueryFirst <PersonDao>(sql, new
{
firstName = personDto.FirstName,
lastName = personDto.LastName,
ageId = ageId
})));
}
public Models.TicketType GetTicketTypeByTypeAndAge(string type, string ageType)
{
var age = _age.GetAgeByType(ageType);
const string sql = "SELECT * FROM SkiTickets.TicketType WHERE type = @ticketType AND ageId = @ageId";
return(TransformDaoToBusinessLogicTicketType(_database.QueryFirstOrDefault <TicketTypeDao>(sql, new { ticketType = type, ageId = age.Id })));
}
private List <Models.Ticket> GetTicketsByAge(string?age)
{
var ageId = _age.GetAgeByType(age).Id;
var ticketList = new List <Models.Ticket>();
const string sql =
"SELECT t.* FROM SkiTickets.Ticket as t LEFT JOIN SkiTickets.TicketType as tt ON t.ticketTypeId = tt.id WHERE tt.ageId = @ageId";
var ticketDaoList = _database.Query <TicketDao>(sql, new { ageId = ageId }).ToList();
ticketDaoList.ForEach(t => ticketList.Add(TransformDaoToBusinessLogicTicket(t)));
return(ticketList);
}
