public void saveCoatDataInDataBase(object sender, EventArgs e) //Metoda zapisu informacji o lakierze w bazie danych
{
HistoryDataAccess db = new HistoryDataAccess();
db.GetLoggedUser();
db.AddCoatData(coatQuantity, coatFinishTime, coatType);
}
private void buttonDelete7Days_Click(object sender, EventArgs e)
{
HistoryDataAccess db = new HistoryDataAccess();
db.DeleteCoatData7Days();
listViewHistory.Items.Clear();
listViewHistory.Refresh();
PopulateListView(null, null);
}
public BookingController()
{
flightDAL = new FlightDataAccess();
passengerDAL = new PassengerDataAccess();
contactsDAL = new ContactsDataAccess();
ticketsDAL = new TicketDataAccess();
seatsDAL = new SeatDataAccess();
historyDAL = new HistoryDataAccess();
userDAL = new UserDataAccess();
}
public void PopulateListView(object sender, EventArgs e)
{
listViewHistory.GridLines = true;
listViewHistory.View = View.Details;
HistoryDataAccess db = new HistoryDataAccess();
history = db.GetHistory();
foreach (HistoryModel data in history)
{
ListViewItem item = new ListViewItem(data.CoatQuantity.ToString());
item.SubItems.Add(data.CoatTime);
item.SubItems.Add(data.User);
item.SubItems.Add(data.CoatType);
item.SubItems.Add(data.CoatDate);
listViewHistory.Items.Add(item);
}
}
private void DeleteRowDataBase(object sender, EventArgs e) //USUWANIE ZAZNACZONYCH DANYCH
{
if (listViewHistory.SelectedItems.Count > 0) //Zabezpieczenie przed brakiem wyboru wiersza z ListView
{
string date = listViewHistory.SelectedItems[0].SubItems[4].Text;
string coat = listViewHistory.SelectedItems[0].SubItems[3].Text;
string user = listViewHistory.SelectedItems[0].SubItems[2].Text;
string hour = listViewHistory.SelectedItems[0].SubItems[1].Text;
HistoryDataAccess db = new HistoryDataAccess();
db.DeleteCoatData(date, coat, user, hour);
}
else
{
MessageBox.Show("You didnt select ant row!");
}
listViewHistory.Items.Clear();
listViewHistory.Refresh();
PopulateListView(null, null);
}
public ProfileController()
{
userDAL = new UserDataAccess();
historyDAL = new HistoryDataAccess();
flightDAL = new FlightDataAccess();
}
public HistoryServices()
{
historyDataAccess = new HistoryDataAccess();
}
