public ListOfStatusTickets ReadStatusTickets() { List <StatusTicket> statusTicketList = new List <StatusTicket>(); SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase); using (connectToDateBase) { SqlCommand command = new SqlCommand( "SELECT STATUS_ID, USER_ID, TICKET_ID, STATUS_TICKET, DATE_CHANGE, TIME_CHANGE FROM [STATUSTICKETS];", connectToDateBase); connectToDateBase.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { StatusTicket statusTicket = new StatusTicket(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3), reader.GetDateTime(4), reader.GetTimeSpan(5)); statusTicketList.Add(statusTicket); } } reader.Close(); } ListOfStatusTickets statusTickets = new ListOfStatusTickets(statusTicketList); return(statusTickets); }
public fTickets(AuthorisedUser user) { InitializeComponent(); this.user = user; ReadingFromDateBase reading = new ReadingFromDateBase(); ticketsList = reading.ReadTickets(); percentsList = reading.ReadPercentages(); totalPercentList = reading.ReadTotalPercents(); statusTicketList = reading.ReadStatusTickets(); sessionList = reading.ReadSessions(); LoadDataGridView(); }
public fTickets(AuthorisedUser user, Session session, int row, int placeNumber, double price) { InitializeComponent(); this.user = user; ReadingFromDateBase reading = new ReadingFromDateBase(); ticketsList = reading.ReadTickets(); percentsList = reading.ReadPercentages(); totalPercentList = reading.ReadTotalPercents(); statusTicketList = reading.ReadStatusTickets(); sessionList = reading.ReadSessions(); LoadDataGridView(); SessionInput.Text = session.FilmSession.FilmName; RowInput.Text = row.ToString(); PlaceNumberInput.Text = placeNumber.ToString(); PriceInput.Text = price.ToString(); TicketInput.Text = (ticketsList.Tickets.Count() + 1).ToString(); }