public int GetCountTicket() { string sql = "Select * From [dbo].[Ticket]"; dalTicket dal = new dalTicket(); int count = 0; SqlDataReader reader = dal.ReadData(sql); while (reader.Read()) { count++; } return(count); }
public List <dtoTicket> GetTickets() { dalTicket dalTicket = new dalTicket(); List <dtoTicket> listEmp = new List <dtoTicket>(); DataTable Tickets = dalTicket.GetTickets(); for (int i = 0; i < Tickets.Rows.Count; i++) { dtoTicket Ticket = new dtoTicket(); DataRow row = Tickets.Rows[i]; if (row[6] is DBNull) { Ticket.TicketID = Convert.ToInt32(row[0]); Ticket.TimeCreate = Convert.ToDateTime(row[1]); Ticket.TicketPrice = Convert.ToInt32(row[2]); Ticket.SeatName = row[3].ToString(); Ticket.FilmID = Convert.ToInt32(row[4]); Ticket.SetID = Convert.ToInt32(row[5]); Ticket.EmployeeID = Convert.ToInt32(row[7]); listEmp.Add(Ticket); } else { Ticket.TicketID = Convert.ToInt32(row[0]); Ticket.TimeCreate = Convert.ToDateTime(row[1]); Ticket.TicketPrice = Convert.ToInt32(row[2]); Ticket.SeatName = row[3].ToString(); Ticket.FilmID = Convert.ToInt32(row[4]); Ticket.SetID = Convert.ToInt32(row[5]); Ticket.CustomerID = Convert.ToInt32(row[6]); Ticket.EmployeeID = Convert.ToInt32(row[7]); listEmp.Add(Ticket); } } return(listEmp); }
public int InsertTicket(dtoTicket ticket) { dalTicket dal = new dalTicket(); return(dal.InsertTicket(ticket)); }