/// <summary>
/// Purpose: Dissconect to update data if a row is just deleted.
// Recreate the FulltimeEmployee Arraylist
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDisconnect_Click(object sender, EventArgs e)
{
loaded = false;
DataAdapter.Disconnect();
listBox1.Items.Clear();
DataAdapter.FullTimeEmployees.Clear();
}
private void button1_Click(object sender, EventArgs e)
{
int newInsurance = 0;
int newTaxExempt = 0;
if (addInsured.Checked == true)
{
newInsurance = 1;
}
if (addTaxExempt.Checked == true)
{
newTaxExempt = 1;
}
DataAdapter.InsertFullTime(
addLname.Text,
addFName.Text,
DateTime.Now,
Convert.ToInt32(addSocial.Text),
addEmail.Text,
Convert.ToInt32(addPhone.Text),
Convert.ToDecimal(addTaxRate.Text),
Convert.ToInt32(addEmpID.Text),
Convert.ToInt32(addSalary.Text),
Convert.ToInt32(addVacationDays.Text),
newInsurance,
newTaxExempt,
Convert.ToInt32(addSickDays.Text)
);
}
/// <summary>
/// Purpose: Delete from Database based on current ID ==> Disconect ==> Clear Array ==> ReLoad Data and the list to From and array
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDelete_Click(object sender, EventArgs e)
{
// listBox1.Items.Clear();
DataAdapter.Delete(Convert.ToInt16(txtBxID.Text));
DataAdapter.Disconnect();
loaded = false;
listBox1.Items.Clear();
DataAdapter.FullTimeEmployees.Clear();
if (loaded == false)
{
txtBxID.Enabled = false;
txtBxEmployeeID.Enabled = false;
btnAddnew.Enabled = true;
DataAdapter.Get();
foreach (FullTime item in DataAdapter.FullTimeEmployees)
{
listBox1.Items.Add(item);
loaded = true;
//Console.WriteLine(item);
}
}
else
{
MessageBox.Show("You already load the data");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
FullTime aFullTime = new FullTime();
aFullTime.ID = Convert.ToInt16(txtBxEmployeeID.Text);
aFullTime.FirstNanme = txtBxFName.Text;
aFullTime.LastName = txtBxLName.Text;
aFullTime.DateHired = Convert.ToDateTime(txtBxDateHired.Text);
aFullTime.SSN = txtBxSSN.Text;
aFullTime.Email = txtBxEmail.Text;
aFullTime.Phone = txtBxPhone.Text;
aFullTime.TaxRate = Convert.ToDecimal(txtBxTaxRate.Text);
aFullTime.ID = Convert.ToInt16(txtBxID.Text);
aFullTime.Salary = Convert.ToDecimal(txtBxSalary.Text);
aFullTime.NumOfVacationDays = Convert.ToInt16(numBxVacationDays.Text);
aFullTime.HasInsurance = txtBxHasInsurance.Text;
aFullTime.TaxExempt = txtBxTaxExempt.Text;
aFullTime.NumOfSickDays = Convert.ToInt16(numBxSickDays.Text);
DataAdapter.Update(aFullTime);
listBox1.Items.Clear();
DataAdapter.FullTimeEmployees[idx] = aFullTime;
foreach (FullTime item in DataAdapter.FullTimeEmployees)
{
listBox1.Items.Add(item);
loaded = true;
}
}
private void deleteBtn_Click(object sender, EventArgs e)
{
int employeeID = Convert.ToInt32(employeeIDtxtBox.Text);
DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete " + nameTxtBox.Text + "?", "Delete?", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
DataAdapter.DeleteFullTime(employeeID);
}
}
/// <summary>
/// Purpose: Check on condition before insert data to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnInsert_Click_1(object sender, EventArgs e)
{
FullTime aFullTime = new FullTime();
if (Convert.ToInt16(txtBxEmployeeID.Text) <= DataAdapter.FullTimeEmployees.Count)
{
MessageBox.Show("This ID has been taken!");
}
else if (!Decimal.TryParse(txtBxTaxRate.Text, out decimal number) || txtBxTaxRate.Text == "")
{
MessageBox.Show("Please Enter TaxRate to check out");
}
else if (!Decimal.TryParse(txtBxSalary.Text, out decimal salary) || txtBxSalary.Text == "")
{
MessageBox.Show("Please Enter Salary to check out");
}
else if (numBxVacationDays.Text == "")
{
MessageBox.Show("Please Enter TaxRate to check out");
}
else if (numBxSickDays.Text == "")
{
MessageBox.Show("Please Enter TaxRate to check out");
}
else
{
aFullTime.ID = Convert.ToInt16(txtBxEmployeeID.Text);
aFullTime.FirstNanme = txtBxFName.Text;
aFullTime.LastName = txtBxLName.Text;
aFullTime.DateHired = Convert.ToDateTime(txtBxDateHired.Text);
aFullTime.SSN = txtBxSSN.Text;
aFullTime.Email = txtBxEmail.Text;
aFullTime.Phone = txtBxPhone.Text;
aFullTime.TaxRate = Convert.ToDecimal(txtBxTaxRate.Text);
aFullTime.ID = Convert.ToInt16(txtBxID.Text);
aFullTime.Salary = Convert.ToDecimal(txtBxSalary.Text);
aFullTime.NumOfVacationDays = Convert.ToInt16(numBxVacationDays.Text);
aFullTime.HasInsurance = txtBxHasInsurance.Text;
aFullTime.TaxExempt = txtBxTaxExempt.Text;
aFullTime.NumOfSickDays = Convert.ToInt16(numBxSickDays.Text);
DataAdapter.Insert(aFullTime);
listBox1.Items.Clear();
DataAdapter.FullTimeEmployees.Add(aFullTime);
foreach (FullTime item in DataAdapter.FullTimeEmployees)
{
listBox1.Items.Add(item);
loaded = true;
}
}
}
private void btnLoad_Click(object sender, EventArgs e)
{
if (loaded == false)
{
txtBxID.Enabled = false;
txtBxEmployeeID.Enabled = false;
btnAddnew.Enabled = true;
DataAdapter.Get();
foreach (FullTime item in DataAdapter.FullTimeEmployees)
{
listBox1.Items.Add(item);
loaded = true;
//Console.WriteLine(item);
}
}
else
{
MessageBox.Show("You already load the data");
}
}
private void disconnectBtn_Click(object sender, EventArgs e)
{
DataAdapter.Disconnect();
labelStatus.Text = DataAdapter.Status;
}
private void button2_Click(object sender, EventArgs e)
{
listBoxFullTime.DataSource = DataAdapter.SelectAll();
labelStatus.Text = DataAdapter.Status;
}
