public VisitorsOverview()
{
InitializeComponent();
msh = new MySqlhelper();
label7.Text = msh.GetNumberOfVisitors().ToString();
label8.Text = msh.GetVisitorsInTheEvent().ToString();
timer1.Start();
}
public Camping_overview()
{
msh = new MySqlhelper();
InitializeComponent();
lbFree.Text = msh.GetCampingsNotBooked().ToString();
lbNoBooked.Text = msh.GetBookedCampings().ToString();
foreach (string item in msh.GetCampingId())
{
cbProductsSold.Items.Add(item);
}
timer1.Start();
}
public ProductsOverview()
{
InitializeComponent();
msh = new MySqlhelper();
foreach (string item in msh.GetProductsForSelling())
{
cbProductsSold.Items.Add(item);
}
foreach (string item in msh.GetProductsForRenting())
{
cbProductsLoaned.Items.Add(item);
}
}
public FinanceOverview()
{
InitializeComponent();
msh = new MySqlhelper();
textBox3.Text = msh.GetTotalMoneySpent().ToString() + "$";
textBox1.Text = msh.GetTotalBalance().ToString();
textBox4.Text = msh.GetBookedCampings().ToString();
textBox5.Text = msh.GetTotalAmountCampings().ToString() + "$";
tbRentShop.Text = msh.GetRentShopMoneyEarned().ToString() + "$";
tbFoodShop.Text = msh.GetFoodShopAmountEarned().ToString() + "$";
tbSouvenirShop.Text = msh.GetSouvernirShopAmountEarned().ToString() + "$";
timer1.Start();
}
public Form1()
{
InitializeComponent();
msh = new MySqlhelper();
visitorsOverview = new VisitorsOverview();
campingOverview = new Camping_overview();
productsOverview = new ProductsOverview();
financeOverview = new FinanceOverview();
lbCurrVisitors.Text = msh.GetVisitorsInTheEvent().ToString();
lbProfit.Text = msh.GetTotalMoneySpent().ToString();
lbProductsSold.Text = msh.GetTotalProductsSoldAndRent().ToString();
lbCampTaken.Text = msh.GetBookedCampings().ToString();
lbCheckedin.Text = msh.GetVisitorCheckedInEvent().ToString();
lbCheckedOut.Text = msh.GetVisitorCheckedOutEvent().ToString();
timer1.Start();
}