Ejemplos de TicketRow en C# (CSharp)

Ejemplo n.º 1

        public void InsertTicket(TicketRow ticket)
        {
            DbConnection conn = CreateConn("MainDB");

            try
            {
                string strSQL = $@"
INSERT INTO Ticket
       ( ID,  Name,  Seat,  Amount,  DateTime)
VALUES (@ID, @Name, @Seat, @Amount, @DateTime)
";
                conn.Execute(strSQL, ticket);
            }
            catch (Exception ex)
            {
                _logger.Error(ex, "InsertTicket");
                throw ex;
            }
            finally
            {
                conn?.Close();
            }
        }

Ejemplo n.º 2

 public void Post([FromBody] TicketRow ticket)
 {
     // #日期要換成本地時間
     ticket.DateTime = ticket.DateTime.ToLocalTime();
     _dbHelper.InsertTicket(ticket);
 }