private void btnLogin_Click(object sender, EventArgs e) { Settings.fTime = DateTime.Now; Settings.Username = txtUsername.Text; Settings.ID_Number = nudID.Value; string errorMessage = "Invalid Credentials!"; databaseFunctions dfunc = new databaseFunctions(); if (dfunc.authenticateLoginDetailsRegular(txtUsername, nudID) == true) { Home hme = new Home(); this.Hide(); hme.FormClosed += (s, args) => this.Close(); hme.ShowDialog(); } else if (dfunc.authenticateLoginDetailsSupervisor(txtUsername, nudID) == true) { supervisorHome shme = new supervisorHome(); this.Hide(); shme.FormClosed += (s, args) => this.Close(); shme.ShowDialog(); } else { MessageBox.Show(errorMessage, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnDisabled_Click(object sender, EventArgs e) { string id = dgvAllRecords.SelectedRows[0].Cells[0].Value.ToString(); databaseFunctions dfunc = new databaseFunctions(); dfunc.disableRecord(id); if (!bwGetRecords.IsBusy) { bwGetRecords.RunWorkerAsync(); } }
private void GoodBye_Load(object sender, EventArgs e) { databaseFunctions dfunc = new databaseFunctions(); dfunc.getNameForGoodBye(lb_Name); speaker = new SpeechSynthesizer(); speaker.Volume = 100; speaker.Rate = 1; speaker.SpeakAsync(lb_Name.Text); speaker.SpeakAsync(lb_Messsage.Text); speaker.SpeakAsync(lb_Poli.Text + ", Living Simplified!"); }
private void Step1_Load(object sender, EventArgs e) { databaseFunctions dfunc = new databaseFunctions(); dfunc.getName(lbName); dfunc.getChairType(lbChairType); speaker = new SpeechSynthesizer(); speaker.Volume = 100; speaker.Rate = 1; speaker.SpeakAsync(lb_Step1.Text); speaker.SpeakAsync(lb_InfoForStep1.Text); }
private void bwGetRecords_DoWork(object sender, DoWorkEventArgs e) { databaseFunctions dfunc = new databaseFunctions(); dgvAllRecords.Invoke(new MethodInvoker(delegate { dfunc.getAllRecords(dgvAllRecords, lbAllRecords, Settings.startDate, Settings.endDate, txtDate); })); dgvActive.Invoke(new MethodInvoker(delegate { dfunc.getActiveRecords(dgvActive, lbActive, Settings.startDate, Settings.endDate); })); dgvDisabled.Invoke(new MethodInvoker(delegate { dfunc.getDisabledRecords(dgvDisabled, lbDisabled, Settings.startDate, Settings.endDate); })); dgvQuery.Invoke(new MethodInvoker(delegate { dfunc.getQueryRecords(dgvQuery, lbQuery, Settings.startDate, Settings.endDate); })); dgvComplied.Invoke(new MethodInvoker(delegate { dfunc.getCompliedRecords(dgvComplied, lbComplied, Settings.startDate, Settings.endDate); })); dgvSlow.Invoke(new MethodInvoker(delegate { dfunc.getSlowRecords(dgvSlow, lbSlow, Settings.startDate, Settings.endDate); })); e.Result = "Ready!"; }
private void btnFinish_Click(object sender, EventArgs e) { speaker.Dispose(); Settings.eTime = DateTime.Now; databaseFunctions dfunc = new databaseFunctions(); dfunc.insertIntoAuditTable(); GoodBye gb = new GoodBye(); this.Hide(); gb.FormClosed += (s, args) => this.Close(); gb.ShowDialog(); }
private void Home_Load(object sender, EventArgs e) { databaseFunctions dfunc = new databaseFunctions(); dfunc.getNameOfUser(lbWelcome); speaker = new SpeechSynthesizer(); speaker.Volume = 100; speaker.Rate = 1; speaker.SpeakAsync(lbWelcome.Text); speaker.SpeakAsync(lb_Info.Text); speaker.SpeakAsync(rbtnChairWithArmRest.Text); speaker.SpeakAsync("or,"); speaker.SpeakAsync(rbtnChairWithoutArmRest.Text); }
private void btnQuery_Click(object sender, EventArgs e) { Settings.isQuery = true; Settings.isComplied = false; Settings.isSlow = false; Settings.isClear = false; string id = dgvAllRecords.SelectedRows[0].Cells[0].Value.ToString(); databaseFunctions dfunc = new databaseFunctions(); dfunc.updateStatus(id); if (!bwGetRecords.IsBusy) { bwGetRecords.RunWorkerAsync(); } }
private void txtSearch_TextChanged(object sender, EventArgs e) { databaseFunctions dfunc = new databaseFunctions(); if (txtSearch.Text != "") { dfunc.searchRecords(txtSearch, dgvAllRecords, lbAllRecords); dfunc.searchActiveRecords(txtSearch, dgvActive, lbActive); dfunc.searchDisabledRecords(txtSearch, dgvDisabled, lbDisabled); dfunc.searchQueryRecords(txtSearch, dgvQuery, lbQuery); dfunc.searchCompliedRecords(txtSearch, dgvComplied, lbComplied); dfunc.searchSlowRecords(txtSearch, dgvSlow, lbSlow); } else { if (!bwGetRecords.IsBusy) { bwGetRecords.RunWorkerAsync(); } } }
private void timer1_Tick(object sender, EventArgs e) { databaseFunctions dfunc = new databaseFunctions(); dfunc.Time(lbTime); }
private void supervisorHome_Load(object sender, EventArgs e) { databaseFunctions dfunc = new databaseFunctions(); dfunc.getNameOfSupervisor(lbName); }
private void btnsave_Click(object sender, EventArgs e) { databaseFunctions df = new databaseFunctions(); df.insert(); }
private void btnSubmit_Click(object sender, EventArgs e) { string errorMessageName = "Name is Required!"; string errorMessageGender = "Gender is Required!"; string errorMessagePhone = "Phone number is Required!"; string errorMessageUsername = "******"; if (txtName.Text == "") { MessageBox.Show(errorMessageName, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (cmbGender.Text == "" || cmbGender.SelectedItem.ToString() == "") { MessageBox.Show(errorMessageGender, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (nudPhone.Text == "" || nudPhone.Value <= 0) { MessageBox.Show(errorMessagePhone, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (txtUsername.Text == "") { MessageBox.Show(errorMessageUsername, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (chkSupervisor.Checked == true) { Settings.isSupervisor = true; databaseFunctions dfunc = new databaseFunctions(); if (dfunc.authenticateUsername(txtUsername) == true && dfunc.authenticateID(nudID) == true) { lbInfoUsername.Text = "Acquired!"; lbInfoID.Text = "Acquired!"; return; } if (dfunc.authenticateUsername(txtUsername) == true) { lbInfoUsername.Text = "Acquired!"; return; } else { lbInfoUsername.Text = ""; } if (dfunc.authenticateID(nudID) == true) { lbInfoID.Text = "Acquired!"; return; } else { lbInfoID.Text = ""; } if (lbInfoUsername.Text == "" && lbInfoID.Text == "") { dfunc.insertIntoSupervisorTable(txtName, cmbGender, nudPhone, txtUsername, nudID); this.Hide(); lg.FormClosed += (s, args) => this.Close(); lg.ShowDialog(); } else { return; } } else if (chkSupervisor.Checked == false) { Settings.isSupervisor = false; databaseFunctions dfunc = new databaseFunctions(); if (dfunc.authenticateUsername(txtUsername) == true && dfunc.authenticateID(nudID) == true) { lbInfoUsername.Text = "Acquired!"; lbInfoID.Text = "Acquired!"; return; } if (dfunc.authenticateUsername(txtUsername) == true) { lbInfoUsername.Text = "Acquired!"; } else { lbInfoUsername.Text = ""; } if (dfunc.authenticateID(nudID) == true) { lbInfoID.Text = "Acquired!"; } else { lbInfoID.Text = ""; } if (lbInfoUsername.Text == "" && lbInfoID.Text == "") { dfunc.insertIntoStaffTable(txtName, cmbGender, nudPhone, txtUsername, nudID); this.Hide(); lg.FormClosed += (s, args) => this.Close(); lg.ShowDialog(); } else { return; } } if (chkDialog.Checked == true) { using (StreamWriter writer = new StreamWriter(filePath)) { try { writer.WriteLine("false"); } catch (Exception exception) { } } } }