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) { }
}
}
}
