private void StartUp()
{
LbNotReturned.Items.Clear();
LbInfoReturned.Items.Clear();
try
{
foreach (string item in SQLItemsControl.GetProductLoanersReturned())
{
LbInfoReturned.Items.Add(item).ToString();
}
foreach (string item in SQLItemsControl.GetProductLoanersNotReturned())
{
LbNotReturned.Items.Add(item).ToString();
}
}
catch (MySqlException)
{
MessageBox.Show("Database problem");
SQLItemsControl.Disconnect();
}
catch (NullReferenceException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception)
{
MessageBox.Show("Something went wrong");
SQLItemsControl.Disconnect();
}
}
private void BtnCheck_Click(object sender, EventArgs e)
{
int UserID = Convert.ToInt32(tBUserId.Text);
try
{
LbEvenstatus.Text = sqlVisitorControl.GetVisitorEventStatus(UserID);
LbFirstName.Text = sqlVisitorControl.GetVisitorFirstName(UserID);
LbLastName.Text = sqlVisitorControl.GetVisitorLastName(UserID);
LbBalance.Text = sqlVisitorControl.GetVisitorBalance(UserID);
LbCampingStatus.Text = sqlVisitorControl.GetVisitorCampingStatus(UserID);
LbBuy.Text = Convert.ToString(sqlVisitorControl.GetSpecificPersonNumberOfProduct(UserID));
LbProductLoaned.Text = Convert.ToString(sqlVisitorControl.GetSpecificPersonNumberOfLoaned(UserID));
LbVisitorHistory.Items.Clear();
foreach (string item in sqlVisitorControl.GetProductSpecificUserBuy(UserID))
{
LbVisitorHistory.Items.Add(item);
}
foreach (string item in sqlVisitorControl.GetProductSpecificUserLoaned(UserID))
{
LbVisitorHistory.Items.Add(item);
}
}
catch (FormatException)
{
MessageBox.Show("Please type User ID ");
}
catch (NullReferenceException)
{
MessageBox.Show("Please type User ID ");
}
catch (MySqlException)
{
MessageBox.Show("Something went wrong");
}
catch (InvalidCastException)
{
LbVisitorHistory.Items.Clear();
LbEvenstatus.Text = "";
LbFirstName.Text = "";
LbLastName.Text = "";
LbBalance.Text = "";
LbCampingStatus.Text = "";
LbBuy.Text = "";
LbProductLoaned.Text = "";
MessageBox.Show("User didnt checked yet and dont have a Rfid");
sqlVisitorControl.Disconnect();
LbVisitorHistory.Items.Clear();
}
}
private void btnCheck_Click(object sender, EventArgs e)
{
int CampID = Convert.ToInt32(tBCampID.Text);
try
{
LbStartDate.Text = sqlControl.GetStardDateOfCamping(CampID);
LbEndDate.Text = sqlControl.GetEndDateOfCamping(CampID);
int AvailableSpots = 6 - sqlControl.NumberOfBookedSpots(CampID);
LbSpotsAvailable.Text = Convert.ToString(AvailableSpots);
LbCampInfo.Items.Clear();
foreach (string item in sqlControl.GetUserFirstNameCamping(CampID))
{
LbCampInfo.Items.Add(item);
}
}
catch (MySqlException)
{
LbStartDate.Text = "";
LbEndDate.Text = "";
LbSpotsAvailable.Text = "";
LbCampInfo.Items.Clear();
MessageBox.Show("Camp id " + CampID.ToString() + " has no bookings");
sqlControl.Disconnect();
}
catch (NullReferenceException)
{
LbStartDate.Text = "";
LbEndDate.Text = "";
LbSpotsAvailable.Text = "";
LbCampInfo.Items.Clear();
sqlControl.Disconnect();
MessageBox.Show("Please type a correct Camp ID");
sqlControl.Disconnect();
}
catch (FormatException)
{
LbStartDate.Text = "";
LbEndDate.Text = "";
LbSpotsAvailable.Text = "";
LbCampInfo.Items.Clear();
sqlControl.Disconnect();
MessageBox.Show("Please type a correct Camp ID");
sqlControl.Disconnect();
}
}