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