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