private void loginButton_Click_1(object sender, EventArgs e)
{
if (userNametxt.Text.Trim().Equals("") || passWordtxt.Text.Trim().Equals(""))
{
MetroFramework.MetroMessageBox.Show(this, "Please input username/password", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (dataLib.logInVerification(userNametxt.Text.Trim(), passWordtxt.Text.Trim(), DBConnection.connect()) == true)
{
insertStatements.insertLoggedAdmin(DBConnection.connect(), dataLib.getLoggedID(DBConnection.connect(), userNametxt.Text.Trim()), userNametxt.Text.Trim());
insertStatements.insertSystemLog(DBConnection.connect(), "Log-in", dataLib.loggedAdminName(DBConnection.connect(), dataLib.getLoggedAdminID(DBConnection.connect())), dataLib.currentDateAndTime());
mainMenu_Form mainObj = new mainMenu_Form();
this.Hide();
mainObj.Show();
}
else
{
MetroFramework.MetroMessageBox.Show(this, "Incorrect username/password", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
userNametxt.Text = "";
passWordtxt.Text = "";
userNametxt.Focus();
}
}
}
void refreshCounts()
{
eventCountLbl.Text = dataLib.countAllEvents(DBConnection.connect()).ToString();
adminCountLbl.Text = dataLib.countAllAdminAccounts(DBConnection.connect()).ToString();
updateStatement.updateEventStatus(DBConnection.connect());
upcomingEvent();
}
private void timer1_Tick(object sender, EventArgs e)
{
BarcodeReader Reader = new BarcodeReader();
Result result = Reader.Decode((Bitmap)cameraPreview.Image);
try
{
decoded = result.ToString().Trim();
if ((dataLib.isQRCodeExists(DBConnection.connect(), decoded) == false) || (dataLib.isPastEvent(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded))) == true)
{
timer1.Stop();
MetroFramework.MetroMessageBox.Show(this, "QR Code doesn't exists", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
checkBtn.Enabled = true;
}
else
{
timer1.Stop();
if (dataLib.isAlreadyPaid(DBConnection.connect(), decoded) == true)
{
MetroFramework.MetroMessageBox.Show(this, "Participant already paid", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
checkBtn.Enabled = true;
}
else
{
if (dataLib.isFullEvent(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded)) == true)
{
MetroFramework.MetroMessageBox.Show(this, "Event already full", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
checkBtn.Enabled = true;
}
else
{
participantIDLbl.Text = dataLib.participantID(DBConnection.connect(), decoded).ToString();
partNameLbl.Text = dataLib.participantName(DBConnection.connect(), dataLib.participantID(DBConnection.connect(), decoded));
eventNameLbl.Text = dataLib.eventName(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded));
ticketAmountLbl.Text = dataLib.ticketAmount(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded)).ToString();
age = dataLib.age(DBConnection.connect(), Convert.ToInt32(participantIDLbl.Text)).ToString();
contactNo = dataLib.contactNum(DBConnection.connect(), Convert.ToInt32(participantIDLbl.Text));
venue = dataLib.venue(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded));
dateStart = dataLib.dateStart(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded));
dateEnd = dataLib.dateEnd(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded));
timeStart = dataLib.timeStart(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded));
timeEnd = dataLib.timeEnd(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded));
venue = dataLib.venue(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded));
fbGroupID = dataLib.fbGroupID(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded));
ticketAmount = ticketAmountLbl.Text;
amountTenderedTxt.Enabled = true;
checkBtn.Enabled = true;
}
}
}
}
catch (Exception ex)
{
timer1.Stop();
MetroFramework.MetroMessageBox.Show(this, "No QR code detected", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
checkBtn.Enabled = true;
}
}
private void mainMenu_Form_Load(object sender, EventArgs e)
{
updateStatement.updateEventStatus(DBConnection.connect());
//adminNameLbl.Text = dataLib.loggedAdminName(DBConnection.connect(), dataLib.getLoggedAdminID(DBConnection.connect())) + " !";
dashboard1.BringToFront();
dashBoardbtn.selected = true;
}
private void searchResult_Click(object sender, EventArgs e)
{
if (searchResult.CurrentRow.Index != -1)
{
unpaidDGV.DataSource = dataLib.fillParticipantTable(DBConnection.connect(), Convert.ToInt32(searchResult.CurrentRow.Cells[0].Value.ToString()), "UNPAID");
unpaidDGV.Columns["firstName"].HeaderText = "FIRST NAME";
unpaidDGV.Columns["lastName"].HeaderText = "LAST NAME";
unpaidDGV.Columns["age"].HeaderText = "AGE";
unpaidDGV.Columns["contactNum"].HeaderText = "CONTACT NUMBER";
paidDGV.DataSource = dataLib.fillParticipantTable(DBConnection.connect(), Convert.ToInt32(searchResult.CurrentRow.Cells[0].Value.ToString()), "PAID");
paidDGV.Columns["firstName"].HeaderText = "FIRST NAME";
paidDGV.Columns["lastName"].HeaderText = "LAST NAME";
paidDGV.Columns["age"].HeaderText = "AGE";
paidDGV.Columns["contactNum"].HeaderText = "CONTACT NUMBER";
unpaidDGV.Columns[0].Width = 110;
unpaidDGV.Columns[1].Width = 110;
unpaidDGV.Columns[2].Width = 45;
unpaidDGV.Columns[3].Width = 120;
paidDGV.Columns[0].Width = 110;
paidDGV.Columns[1].Width = 110;
paidDGV.Columns[2].Width = 45;
paidDGV.Columns[3].Width = 120;
ticketLeftLbl.Text = (Convert.ToInt32(searchResult.CurrentRow.Cells[8].Value.ToString()) - dataLib.ticketBoughtCount(DBConnection.connect(), Convert.ToInt32(searchResult.CurrentRow.Cells[0].Value.ToString()))).ToString();
ticketBoughtLbl.Text = (dataLib.ticketBoughtCount(DBConnection.connect(), Convert.ToInt32(searchResult.CurrentRow.Cells[0].Value.ToString()))).ToString();
unpaidLbl.Text = (dataLib.countUnpaidParticipants(DBConnection.connect(), Convert.ToInt32(searchResult.CurrentRow.Cells[0].Value.ToString()))).ToString();
searchResult.CurrentRow.DefaultCellStyle.BackColor = Color.FromArgb(107, 185, 240);
searchResult.CurrentRow.DefaultCellStyle.ForeColor = Color.Black;
}
}
private void close_Click_1(object sender, EventArgs e)
{
if (MetroFramework.MetroMessageBox.Show(this, "Are you sure you want to exit?", "e-Ventory", MessageBoxButtons.YesNo, MessageBoxIcon.Error) == DialogResult.Yes)
{
deleteStatement.deleteAllLoggedAdmin(DBConnection.connect());
Application.Exit();
}
}
private void close_Click(object sender, EventArgs e)
{
if (MetroFramework.MetroMessageBox.Show(this, "Are you sure you want to exit?", "e-Ventory", MessageBoxButtons.YesNo, MessageBoxIcon.Error) == DialogResult.Yes)
{
insertStatements.insertSystemLog(DBConnection.connect(), "Log-out", dataLib.loggedAdminName(DBConnection.connect(), dataLib.getLoggedAdminID(DBConnection.connect())), dataLib.currentDateAndTime());
deleteStatement.deleteAllLoggedAdmin(DBConnection.connect());
Application.Exit();
}
}
void fillResult()
{
searchResult.DataSource = dataLib.viewAllEventsToday(DBConnection.connect(), DateTime.Today);
searchResult.Columns["scheduleID"].Visible = false;
searchResult.Columns["eventName"].HeaderText = "EVENT NAME";
searchResult.Columns["description"].HeaderText = "DESCRIPTION";
searchResult.Columns["dateStart"].HeaderText = "START DATE";
searchResult.Columns["dateEnd"].HeaderText = "END DATE";
searchResult.Columns["timeStart"].HeaderText = "START TIME";
searchResult.Columns["timeEnd"].HeaderText = "END TIME";
}
private void registerBtn_Click(object sender, EventArgs e)
{
bool emptyField = lastNameTxt.Text.Equals("Last Name") || firstNameTxt.Text.Equals("First Name") || ageTxt.Text.Equals("Age") || contactNoTxt.Text.Equals("Contact Number");
bool noChosenEvent = participantIdLbl.Text.Equals("") || schedIDLbl.Text.Equals("") || eventNameLbl.Text.Equals("");
if (noChosenEvent == true)
{
MetroFramework.MetroMessageBox.Show(this, "Kindly choose the event you want to join", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (emptyField == true)
{
MetroFramework.MetroMessageBox.Show(this, "Kindly fill out all fields", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (MetroFramework.MetroMessageBox.Show(this, "Register " + firstNameTxt.Text + " " + lastNameTxt.Text + " to " + eventNameLbl.Text + " event?", "e-Ventory", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Warning) == DialogResult.Yes)
{
double amount = Convert.ToDouble(ticketAmount);
searchResult.Enabled = false;
insertStatements.insertTicket(DBConnection.connect(), Convert.ToInt32(schedIDLbl.Text), participantIdLbl.Text, participantIdLbl.Text + schedIDLbl.Text, amount, false);
insertStatements.insertParticipant(DBConnection.connect(), participantIdLbl.Text, lastNameTxt.Text, firstNameTxt.Text, ageTxt.Text, contactNoTxt.Text, Convert.ToInt32(schedIDLbl.Text));
QRCodeEncoder encoder = new QRCodeEncoder();
encoder.QRCodeScale = 15;
Bitmap qr = encoder.Encode(participantIdLbl.Text + schedIDLbl.Text);
qr = new Bitmap(qr, new Size(197, 175));
qrCodePic.Image = qr;
if (amount == 0)
{
updateStatement.updateTicketBought(DBConnection.connect(), dataLib.ticketBoughtCount(DBConnection.connect(), Convert.ToInt32(schedIDLbl.Text)) + 1, Convert.ToInt32(schedIDLbl.Text));
insertStatements.insertSystemLog(DBConnection.connect(), "'" + firstNameTxt.Text.Trim() + " " + lastNameTxt.Text.Trim() + "' register for event '" + eventNameLbl.Text.Trim() + "' (FREE ADMISSION)", dataLib.loggedAdminName(DBConnection.connect(), dataLib.getLoggedAdminID(DBConnection.connect())), dataLib.currentDateAndTime());
saveTicket.Enabled = true;
saveVoucher.Enabled = false;
amountType = "FREE";
}
else
{
insertStatements.insertSystemLog(DBConnection.connect(), "'" + firstNameTxt.Text.Trim() + " " + lastNameTxt.Text.Trim() + "' register for event '" + eventNameLbl.Text.Trim() + "'", dataLib.loggedAdminName(DBConnection.connect(), dataLib.getLoggedAdminID(DBConnection.connect())), dataLib.currentDateAndTime());
saveVoucher.Enabled = true;
saveTicket.Enabled = false;
amountType = ticketAmount;
}
}
}
}
}
void fillResult()
{
searchResult.DataSource = dataLib.viewAllNotFullEvents(DBConnection.connect());
searchResult.Columns["scheduleID"].Visible = false;
searchResult.Columns["eventName"].HeaderText = "EVENT NAME";
searchResult.Columns["description"].HeaderText = "DESCRIPTION";
searchResult.Columns["dateStart"].HeaderText = "START DATE";
searchResult.Columns["dateEnd"].HeaderText = "END DATE";
searchResult.Columns["timeStart"].HeaderText = "START TIME";
searchResult.Columns["timeEnd"].HeaderText = "END TIME";
searchResult.Columns["venueName"].HeaderText = "VENUE";
searchResult.Columns["ticketCapacity"].HeaderText = "PARTICIPANTS";
searchResult.Columns["ticketAmount"].HeaderText = "TICKET FEE";
searchResult.Columns["fbGroupCode"].HeaderText = "FB GROUP CODE";
}
private void proceedBtn_Click_1(object sender, EventArgs e)
{
if (amountTenderedTxt.Text == "")
{
MetroFramework.MetroMessageBox.Show(this, "Kindly input tendered amount", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
string newQrCode = participantIDLbl.Text + dataLib.schedIDFromQR(DBConnection.connect(), decoded) + "PAID";
QRCodeEncoder encoder = new QRCodeEncoder();
encoder.QRCodeScale = 15;
Bitmap qr = encoder.Encode(newQrCode);
qr = new Bitmap(qr, new Size(197, 175));
qrCodePic.Image = qr;
updateStatement.updateTicketBought(DBConnection.connect(), (dataLib.ticketBoughtCount(DBConnection.connect(), dataLib.schedIDFromQR(DBConnection.connect(), decoded))) + 1, dataLib.schedIDFromQR(DBConnection.connect(), decoded));
updateStatement.updateQRCode(DBConnection.connect(), newQrCode, Convert.ToInt32(participantIDLbl.Text));
updateStatement.updatePaymentStatus(DBConnection.connect(), Convert.ToInt32(participantIDLbl.Text));
insertStatements.insertSystemLog(DBConnection.connect(), "'" + partNameLbl.Text.Trim() + "'" + " paid for event '" + eventNameLbl.Text.Trim() + "'", dataLib.loggedAdminName(DBConnection.connect(), dataLib.getLoggedAdminID(DBConnection.connect())), dataLib.currentDateAndTime());
amountTenderedTxt.Enabled = false;
checkBtn.Enabled = false;
}
}
private void submitButton_Click(object sender, EventArgs e)
{
bool emptyFields = lastNameTxt.Text.Equals("") || firstNameTxt.Text.Equals("") || ageTxt.Text.Equals("") || contactNumTxt.Text.Equals("") || houseNumTxt.Text.Equals("") || streetNameTxt.Text.Equals("") || brgyTxt.Text.Equals("") || cityTxt.Text.Equals("") || uNametxt.Text.Equals("") || passWordtxt.Text.Equals("") || (!(male.Checked) && !(female.Checked));
char genderSymbol = 'a';
if (emptyFields == true)//if empty fields
{
MetroFramework.MetroMessageBox.Show(this, "Kindly fill-out all fields", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (validations.userNameExists(uNametxt.Text.Trim(), DBConnection.connect()) == true)//if username alredy exists
{
MetroFramework.MetroMessageBox.Show(this, "Username already exists", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
uNametxt.Text = "";
uNametxt.Focus();
}
else
{
if (male.Checked)
{
genderSymbol = 'M';
}
else if (female.Checked)
{
genderSymbol = 'F';
}
insertStatements.insertAdmin(DBConnection.connect(), adminIDTxt.Text.Trim(), lastNameTxt.Text.Trim(), firstNameTxt.Text.Trim(), genderSymbol, ageTxt.Text.Trim(), contactNumTxt.Text.Trim(), houseNumTxt.Text.Trim(), streetNameTxt.Text.Trim(), brgyTxt.Text.Trim(), cityTxt.Text.Trim(), uNametxt.Text.Trim(), passWordtxt.Text.Trim(), fbUsername.Text.Trim(), fbPassword.Text.Trim());
insertStatements.insertSystemLog(DBConnection.connect(), "Account creation", firstNameTxt.Text + " " + lastNameTxt.Text, dataLib.currentDateAndTime());
MetroFramework.MetroMessageBox.Show(this, "Account successfully created!", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Question);
idGenerator();
clearInputs();
}
}
}
private void checkOutBtn_Click(object sender, EventArgs e)
{
updateStatement.updateIsScanned(DBConnection.connect(), dataLib.participantID(DBConnection.connect(), decoded), false);
sucssflChkOutLbl.Visible = true;
checkBtn.Enabled = true;
}
private void timer1_Tick(object sender, EventArgs e)
{
BarcodeReader Reader = new BarcodeReader();
Result result = Reader.Decode((Bitmap)cameraPreview.Image);
try
{
decoded = result.ToString().Trim();
if (dataLib.isQRCodeExists(DBConnection.connect(), decoded) == false || dataLib.isAlreadyPaid(DBConnection.connect(), decoded) == false)
{
timer1.Stop();
validLbl.Visible = false;
validIcon.Visible = false;
invalidLbl.Visible = true;
invalidIcon.Visible = true;
ticketDsntExistLbl.Visible = true;
ticketScanAlrdyLbl.Visible = false;
checkOutBtn.Visible = false;
checkBtn.Enabled = true;
welcomeLbl.Visible = false;
partNameLbl.Visible = false;
sucssflChkOutLbl.Visible = false;
}
else
{
timer1.Stop();
if (schedID != dataLib.schedIDFromQR(DBConnection.connect(), decoded))
{
validLbl.Visible = false;
validIcon.Visible = false;
invalidLbl.Visible = true;
invalidIcon.Visible = true;
ticketDsntExistLbl.Visible = true;
ticketScanAlrdyLbl.Visible = false;
checkOutBtn.Visible = false;
checkBtn.Enabled = true;
welcomeLbl.Visible = false;
partNameLbl.Visible = false;
sucssflChkOutLbl.Visible = false;
}
else
{
if (dataLib.isScannedAlready(DBConnection.connect(), decoded) == true)
{
validLbl.Visible = false;
validIcon.Visible = false;
invalidLbl.Visible = true;
invalidIcon.Visible = true;
ticketDsntExistLbl.Visible = false;
ticketScanAlrdyLbl.Visible = true;
checkOutBtn.Visible = true;
checkBtn.Enabled = true;
welcomeLbl.Visible = false;
partNameLbl.Visible = false;
sucssflChkOutLbl.Visible = false;
}
else
{
validLbl.Visible = true;
validIcon.Visible = true;
invalidLbl.Visible = false;
invalidIcon.Visible = false;
ticketDsntExistLbl.Visible = false;
ticketScanAlrdyLbl.Visible = false;
checkOutBtn.Visible = false;
checkBtn.Enabled = true;
welcomeLbl.Visible = true;
partNameLbl.Visible = true;
sucssflChkOutLbl.Visible = false;
partNameLbl.Text = dataLib.participantName(DBConnection.connect(), dataLib.participantID(DBConnection.connect(), decoded));
updateStatement.updateIsScanned(DBConnection.connect(), dataLib.participantID(DBConnection.connect(), decoded), true);
checkBtn.Enabled = true;
}
}
}
}
catch (Exception ex)
{
timer1.Stop();
MetroFramework.MetroMessageBox.Show(this, "No QR code detected", "e-Ventory", MessageBoxButtons.OK, MessageBoxIcon.Error);
checkBtn.Enabled = true;
}
}
void upcomingEvent()
{
if (dataLib.upcomingEventCount(DBConnection.connect()) <= 0)
{
noUpcomingEventLbl.Visible = true;
noUpcomingEventLbl1.Visible = true;
lbl1.Visible = false;
lbl2.Visible = false;
bunifuCustomLabel5.Visible = false;
bunifuCustomLabel6.Visible = false;
bunifuCustomLabel7.Visible = false;
bunifuCustomLabel8.Visible = false;
bunifuCustomLabel9.Visible = false;
bunifuCustomLabel10.Visible = false;
bunifuCustomLabel11.Visible = false;
}
else
{
noUpcomingEventLbl.Visible = false;
noUpcomingEventLbl1.Visible = false;
bunifuCustomLabel5.Visible = true;
bunifuCustomLabel6.Visible = true;
bunifuCustomLabel7.Visible = true;
bunifuCustomLabel8.Visible = true;
bunifuCustomLabel9.Visible = true;
bunifuCustomLabel10.Visible = true;
bunifuCustomLabel11.Visible = true;
lbl1.Visible = true;
lbl2.Visible = true;
try
{
if (con.State == ConnectionState.Closed)
{
con.Open();
SqlCommand getNearestEvent = new SqlCommand(@"SELECT TOP 1 eventName, dateStart, dateEnd,
CONVERT(varchar(15),timeStart,100) AS 'timeStart',
CONVERT(varchar(15),timeEnd,100) AS 'timeEnd',
venueName, ticketCapacity, ticketBought
FROM tb_schedule S JOIN tb_EventInfo E ON S.scheduleID = E.scheduleID
WHERE (DATEDIFF(DAY, GETDATE(), dateStart) IN (SELECT TOP 1 datediff(DAY, getdate(), dateStart)
FROM tb_schedule S JOIN tb_EventInfo E
ON S.scheduleID = E.scheduleID
WHERE (isPastEvent != 1 AND datediff(DAY, getdate(), dateStart) >= 0) AND (CONVERT(DATETIME, CONVERT(CHAR(8), dateStart, 112)+ ' ' +CONVERT(CHAR(8), timeStart, 108)) !< GETDATE())
ORDER BY 1 ASC)) AND (isPastEvent != 1 AND CONVERT(DATETIME, CONVERT(CHAR(8), dateStart, 112)+ ' ' +CONVERT(CHAR(8), timeStart, 108)) !< GETDATE())
ORDER BY (CONVERT(DATETIME, CONVERT(CHAR(8), dateStart, 112)+ ' ' +CONVERT(CHAR(8), timeStart, 108))) DESC", con);
SqlDataReader reader = getNearestEvent.ExecuteReader();
while (reader.Read())
{
eventName = (string)reader["eventName"];
dateStart.Text = ((DateTime)reader["dateStart"]).ToShortDateString();
dateEnd.Text = ((DateTime)reader["dateEnd"]).ToShortDateString();
timeStart.Text = ((string)reader["timeStart"]).ToString();
timeEnd.Text = ((string)reader["timeEnd"]).ToString();
venueLoc.Text = (string)reader["venueName"];
ticketCapacityLbl.Text = ((int)reader["ticketCapacity"]).ToString();
registeredCountLbl.Text = ((int)reader["ticketBought"]).ToString();
}
}
}
catch (Exception ex)
{
}
finally
{
con.Close();
}
eventNameLbl.Text = eventName;
eventNameLbl1.Text = eventName;
}
}
private void dashboard_Load(object sender, EventArgs e)
{
eventCountLbl.Text = dataLib.countAllEvents(DBConnection.connect()).ToString();
adminCountLbl.Text = dataLib.countAllAdminAccounts(DBConnection.connect()).ToString();
upcomingEvent();
}
