public ListOfTotalPercents ReadTotalPercents()
{
List <TotalPercent> totalPercentList = new List <TotalPercent>();
SqlConnection connectToDateBase = new SqlConnection(pathOfDataBase);
using (connectToDateBase)
{
SqlCommand command = new SqlCommand(
"SELECT PERCENT_ID, TICKET_ID FROM [TOTALPERCENTS];",
connectToDateBase);
connectToDateBase.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
TotalPercent totalPercent = new TotalPercent(reader.GetInt32(0), reader.GetInt32(1));
totalPercentList.Add(totalPercent);
}
}
reader.Close();
}
ListOfTotalPercents totalPercents = new ListOfTotalPercents(totalPercentList);
return(totalPercents);
}
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();
}
