private void btnAddEmployee_Click(object sender, RoutedEventArgs e)
{
if (txtFirst.Text != "" && txtLast.Text != "" && txtIRDNum.Text != "" && txtBankNum.Text != "" && txtPayRate.Text != "")
{
using (var db = new LoginContext())
{
Employee EmployeeObj = new Employee();
DateTime dt = dpStartDate.SelectedDate.Value;
EmployeeObj.First_Name = txtFirst.Text;
EmployeeObj.Last_Name = txtLast.Text;
EmployeeObj.IRD_Number = txtIRDNum.Text;
EmployeeObj.Taxcode = cbTaxCode.SelectionBoxItem.ToString();
EmployeeObj.Kiwisaver = Convert.ToDouble(cbKiwiSaver.SelectionBoxItem.ToString());
EmployeeObj.StudentLoan = cbStudentLoan.SelectionBoxItem.ToString();
EmployeeObj.Start_Date = dt;
EmployeeObj.Pay_Rate = Convert.ToDouble(txtPayRate.Text);
EmployeeObj.Bank_ACC_Num = txtBankNum.Text;
EmployeeObj.Annual_Leave = 5;
EmployeeObj.Sick_Days = 5;
var User = (from u in db.LoginInfo
where u.EMP_ID == ManagerID
select u).First();
User.Employees.Add(EmployeeObj);
db.SaveChanges();
DGSearchEmployee.ItemsSource = db.EmployeeInfo.ToList();
MessageBox.Show("Employee Added Successfully");
}
}
}
private void DGSearchEmployee_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
using (var db = new LoginContext())
{
var row = DGSearchEmployee.SelectedItems[0];
Type type = row.GetType();
txtFirst.Text = (string)type.GetProperty("First_Name").GetValue(row, null);
txtLast.Text = (string)type.GetProperty("Last_Name").GetValue(row, null);
txtIRDNum.Text = (string)type.GetProperty("IRD_Number").GetValue(row, null);
cbTaxCode.SelectedValue = (string)type.GetProperty("Taxcode").GetValue(row, null);
cbKiwiSaver.Text = (double)type.GetProperty("Kiwisaver").GetValue(row, null) + "";
cbStudentLoan.Text = (string)type.GetProperty("StudentLoan").GetValue(row, null);
dpStartDate.SelectedDate = (DateTime)type.GetProperty("Start_Date").GetValue(row, null);
txtPayRate.Text = (double)type.GetProperty("Pay_Rate").GetValue(row, null) + "";
txtBankNum.Text = (string)type.GetProperty("Bank_ACC_Num").GetValue(row, null);
}
}
catch (Exception)
{
}
}
public double payment()
{
using (var db = new LoginContext())
{
Employee EmployeeDB = new Employee();
annualPay = grossPay * 52;
if (annualPay <= 14000)
{
taxDeductionYearly = annualPay * tax1;
taxDeductionWeekly = taxDeductionYearly / 52;
takeHomePayYearly = annualPay - taxDeductionYearly;
takeHomePayWeekly = takeHomePayYearly / 52;
}
else if (annualPay >= 14000 && annualPay <= 48000)
{
leftoverPay = annualPay - 14000;
taxDeductionYearly = leftoverPay * tax2;
taxDeductionYearly = taxDeductionYearly + 1470;
taxDeductionWeekly = taxDeductionYearly / 52;
takeHomePayYearly = annualPay - taxDeductionYearly;
takeHomePayWeekly = takeHomePayYearly / 52;
}
else if (annualPay >= 48000 && annualPay <= 70000)
{
leftoverPay = annualPay - 48000;
taxDeductionYearly = leftoverPay * tax3;
taxDeductionYearly = taxDeductionYearly + 1470 + 5950;
taxDeductionWeekly = taxDeductionYearly / 52;
takeHomePayYearly = annualPay - taxDeductionYearly;
takeHomePayWeekly = takeHomePayYearly / 52;
}
else if (annualPay >= 70000)
{
leftoverPay = annualPay - 70000;
taxDeductionYearly = leftoverPay * tax4;
taxDeductionYearly = taxDeductionYearly + 1470 + 5950 + 6600;
taxDeductionWeekly = taxDeductionYearly / 52;
takeHomePayYearly = annualPay - taxDeductionYearly;
takeHomePayWeekly = takeHomePayYearly / 52;
}
if (KiwisaverPercent != 0)
{
KiwisaverPercent = KiwisaverPercent / 100;
KiwiSaverDeduction = takeHomePayWeekly * KiwisaverPercent;
takeHomePayWeekly = takeHomePayWeekly - KiwiSaverDeduction;
}
if (studentLoan == "Yes")
{
studentLoanDeduction = takeHomePayWeekly * studentLoanPercent;
takeHomePayWeekly = takeHomePayWeekly - studentLoanDeduction;
}
}
return(takeHomePayWeekly);
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
lblWelcome.Content += " " + EmployeeName + "\nCompany Name: " + CompanyName;
using (var db = new LoginContext())
{
DGEmployees.ItemsSource = db.EmployeeInfo.ToList();
}
}
private void btnCreate_Click(object sender, RoutedEventArgs e)
{
using (var db = new LoginContext())
{
string companyName = txtCompanyName.Text;
string employeeName = txtEmployeeName.Text;
string irdNumber = txtIRD.Text;
string bankNumber = txtAcountNum.Text;
string userName = txtUserName.Text;
string password = txtPassword.Password;
string passwordAuth = txtPasswordAuth.Password;
if (companyName != "" && employeeName != "" && irdNumber != "" && bankNumber != "" && userName != "" && password != "" && passwordAuth != "")
{
if (password == passwordAuth && password != "" && passwordAuth != "")
{
var User = (from u in db.LoginInfo
where u.UserName == userName
select u);
if (User.Any())
{
MessageBox.Show("The Username that you've selected is already taken");
}
else
{
var newUser = new LoginID
{
CompanyName = companyName,
EmployeeName = employeeName,
IRDNumber = irdNumber,
AccountNumber = bankNumber,
UserName = userName,
Password = password
};
db.LoginInfo.Add(newUser);
db.SaveChanges();
MessageBox.Show("User Succesfully Created");
}
}
else
{
MessageBox.Show("Please make sure passwords are the same");
}
}
else
{
MessageBox.Show("Please fill in all the information");
}
}
}
private void addUpdateEmployee_Click(object sender, RoutedEventArgs e)
{
using (var db = new LoginContext())
{
var User = (from u in db.LoginInfo
select new { u.EMP_ID, u.CompanyName, u.EmployeeName });
var emp = User.First();
AddUpdateEmployee AUEmployee = new AddUpdateEmployee(emp.EMP_ID, emp.EmployeeName, emp.CompanyName);
AUEmployee.Show();
Hide();
Close();
}
}
private void btnBack_Click(object sender, RoutedEventArgs e)
{
using (var db = new LoginContext())
{
var User = (from u in db.LoginInfo
select new { u.EMP_ID, u.CompanyName, u.EmployeeName });
var emp = User.First();
MainUI mainUI = new MainUI(emp.EMP_ID, emp.EmployeeName, emp.CompanyName);
mainUI.Show();
Hide();
Close();
}
}
private void txtSearch_TextChanged(object sender, TextChangedEventArgs e)
{
using (var db = new LoginContext())
{
var sQuery = from x in db.EmployeeInfo
select x;
if (!string.IsNullOrEmpty(txtSearch.Text))
{
sQuery = sQuery.Where(x => x.First_Name.Contains(txtSearch.Text) || x.Last_Name.Contains(txtSearch.Text));
}
DGSearchEmployee.ItemsSource = sQuery.ToList();
}
}
private void DGEmployees_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
using (var db = new LoginContext())
{
cbSickLeave.Items.Clear();
cbAnnualLeave.Items.Clear();
var row = DGEmployees.SelectedItems[0];
Type type = row.GetType();
double sickLeave = (double)type.GetProperty("Sick_Days").GetValue(row, null);
double annualLeave = (double)type.GetProperty("Annual_Leave").GetValue(row, null);
for (int i = 1; i <= sickLeave; i++)
{
cbSickLeave.Items.Add(i);
}
for (int i = 1; i <= annualLeave; i++)
{
cbAnnualLeave.Items.Add(i);
}
tbEmpInfo.Text = " EMPLOYEE INFORMATION \n";
tbEmpInfo.Text += "\n First Name: " + (string)type.GetProperty("First_Name").GetValue(row, null);
tbEmpInfo.Text += "\n Last Name: " + (string)type.GetProperty("Last_Name").GetValue(row, null);
tbEmpInfo.Text += "\n IRD Number: " + (string)type.GetProperty("IRD_Number").GetValue(row, null);
tbEmpInfo.Text += "\n Tax Code: " + (string)type.GetProperty("Taxcode").GetValue(row, null);
tbEmpInfo.Text += "\n Kiwisaver: " + (double)type.GetProperty("Kiwisaver").GetValue(row, null) + "%";
tbEmpInfo.Text += "\n Student Loan: " + (string)type.GetProperty("StudentLoan").GetValue(row, null);
tbEmpInfo.Text += "\n Start Date: " + (DateTime)type.GetProperty("Start_Date").GetValue(row, null);
tbEmpInfo.Text += "\n Bank Account Number: " + (string)type.GetProperty("Bank_ACC_Num").GetValue(row, null);
tbEmpInfo.Text += "\n Annual Leave Days: " + (double)type.GetProperty("Annual_Leave").GetValue(row, null);
tbEmpInfo.Text += "\n Sick Days Remaining: " + (double)type.GetProperty("Sick_Days").GetValue(row, null);
tbEmpInfo.Text += "\n Pay Rate: $" + (double)type.GetProperty("Pay_Rate").GetValue(row, null);
}
}
catch (Exception)
{
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
cbTaxCode.Items.Add("M");
cbTaxCode.Items.Add("M SL");
cbTaxCode.Items.Add("ME");
cbTaxCode.Items.Add("ME SL");
cbTaxCode.Items.Add("SB");
cbTaxCode.Items.Add("SB SL");
cbTaxCode.Items.Add("S");
cbTaxCode.Items.Add("S SL");
cbTaxCode.Items.Add("SH");
cbTaxCode.Items.Add("SH SL");
cbTaxCode.Items.Add("ST SL");
using (var db = new LoginContext())
{
DGSearchEmployee.ItemsSource = db.EmployeeInfo.ToList();
}
}
private void btnUpdateEmployee_Click(object sender, RoutedEventArgs e)
{
try
{
if (txtFirst.Text != "" && txtLast.Text != "" && txtIRDNum.Text != "" && txtBankNum.Text != "" && txtPayRate.Text != "")
{
using (var db = new LoginContext())
{
Employee EmployeeObj = new Employee();
DateTime dt = dpStartDate.SelectedDate.Value;
var row = DGSearchEmployee.SelectedItems[0];
Type type = row.GetType();
var ID = (int)type.GetProperty("EMPLOYEE_ID").GetValue(row, null);
var User = (from u in db.EmployeeInfo
where u.EMPLOYEE_ID == ID
select u).First();
User.First_Name = txtFirst.Text;
User.Last_Name = txtLast.Text;
User.IRD_Number = txtIRDNum.Text;
User.Taxcode = cbTaxCode.SelectionBoxItem.ToString();
User.Kiwisaver = Convert.ToDouble(cbKiwiSaver.SelectionBoxItem.ToString());
User.StudentLoan = cbStudentLoan.SelectionBoxItem.ToString();
User.Pay_Rate = Convert.ToDouble(txtPayRate.Text);
User.Bank_ACC_Num = txtBankNum.Text;
db.SaveChanges();
DGSearchEmployee.ItemsSource = db.EmployeeInfo.ToList();
MessageBox.Show("Employee Updated Successfully");
}
}
}
catch (Exception)
{
MessageBox.Show("Please Select An Employee");
}
}
private void deleteEmployee_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Are You Sure?", "Delete Employee", MessageBoxButton.YesNo, MessageBoxImage.Warning) == MessageBoxResult.Yes)
{
using (var db = new LoginContext())
{
Employee emp = (Employee)DGEmployees.SelectedItems[0];
int ID = emp.EMPLOYEE_ID;
var User = (from c in db.EmployeeInfo
where c.EMPLOYEE_ID == ID
select c).First();
db.EmployeeInfo.Remove(User);
db.SaveChanges();
MessageBox.Show("Employee Successfully Deleted");
DGEmployees.ItemsSource = db.EmployeeInfo.ToList();
}
}
}
private void btnPay_Click(object sender, RoutedEventArgs e)
{
if (txtHoursWorked.Text != "" && DGEmployees.SelectedItem != null)
{
using (var db = new LoginContext())
{
Payment objPayment = new Payment();
Employee objEmployee = new Employee();
var row = DGEmployees.SelectedItems[0];
Type type = row.GetType();
DateTime startDate = (DateTime)type.GetProperty("Start_Date").GetValue(row, null);
DateTime sickLeaveRenew = startDate.AddDays(365);
if (DateTime.Now == sickLeaveRenew)
{
objEmployee.Start_Date = DateTime.Today;
objEmployee.Sick_Days = objEmployee.Sick_Days + 5;
objEmployee.Annual_Leave = objEmployee.Annual_Leave + 20;
}
objSalary.hoursWorked = Convert.ToDouble(txtHoursWorked.Text);
objSalary.studentLoan = (string)type.GetProperty("StudentLoan").GetValue(row, null);
objSalary.payRate = (double)type.GetProperty("Pay_Rate").GetValue(row, null);
objSalary.KiwisaverPercent = (double)type.GetProperty("Kiwisaver").GetValue(row, null);
objSalary.sickLeave = Convert.ToDouble(cbSickLeave.SelectedValue);
objSalary.annualLeave = Convert.ToDouble(cbAnnualLeave.SelectedValue);
objSalary.grossPayment();
objSalary.payment();
objPayment.Gross_Income = Convert.ToDouble(objSalary.annualPay);
objPayment.Payment_Date = DateTime.Today;
objPayment.Sick_Days_Used = Convert.ToDouble(cbSickLeave.SelectedValue);
objPayment.Annual_Leave = Convert.ToDouble(cbAnnualLeave.SelectedValue);
objPayment.Tax_Deduction = Convert.ToDouble(objSalary.taxDeductionWeekly);
objPayment.Kiwi_Saver_Deduction = Convert.ToDouble(objSalary.KiwiSaverDeduction);
objPayment.StudentLoan_Deduction = Convert.ToDouble(objSalary.studentLoanDeduction);
objPayment.Yearly_Income = Convert.ToDouble(objSalary.takeHomePayYearly);
objPayment.Sick_Days_Remaining = (double)type.GetProperty("Sick_Days").GetValue(row, null);
objPayment.Annual_Leave_Remaining = (double)type.GetProperty("Annual_Leave").GetValue(row, null);
var id = (int)type.GetProperty("EMPLOYEE_ID").GetValue(row, null);
var User = (from u in db.EmployeeInfo
where u.EMPLOYEE_ID == id
select u).First();
User.Sick_Days = User.Sick_Days - Convert.ToDouble(cbSickLeave.SelectedValue);
User.Annual_Leave = User.Annual_Leave - Convert.ToDouble(cbAnnualLeave.SelectedValue);
objPayment.Sick_Days_Remaining = objPayment.Sick_Days_Remaining - Convert.ToDouble(cbSickLeave.SelectedValue);
objPayment.Annual_Leave_Remaining = objPayment.Annual_Leave_Remaining - Convert.ToDouble(cbAnnualLeave.SelectedValue);
User.Payments.Add(objPayment);
db.SaveChanges();
tbResult.Text = "PAYSLIP FOR " + (string)type.GetProperty("First_Name").GetValue(row, null) + " " + (string)type.GetProperty("Last_Name").GetValue(row, null);
tbResult.Text += "\n\nHOURS WORKED: " + objSalary.hoursWorked.ToString();
tbResult.Text += " @ " + objSalary.payRate.ToString("$" + "#.##");
tbResult.Text += "\nSICK LEAVE USED: " + objSalary.sickLeave / 8;
tbResult.Text += "\nANNUAL LEAVE USED: " + objSalary.annualLeave / 8;
tbResult.Text += "\nGROSS PAY: $" + objSalary.grossPay.ToString("#.##");
tbResult.Text += "\nTAX DEDUCTIONS: $" + objSalary.taxDeductionWeekly.ToString("#.##");
tbResult.Text += "\nTAX CODE: " + (string)type.GetProperty("Taxcode").GetValue(row, null);
tbResult.Text += "\nSTUDENT LOANS DEDUCTION: " + objSalary.studentLoanDeduction.ToString("$" + "#.##");
tbResult.Text += "\nKIWISAVER DEDUCTION: " + objSalary.KiwiSaverDeduction.ToString("$" + "#.##");
tbResult.Text += "\n\nTAKE HOME PAY: $" + objSalary.takeHomePayWeekly.ToString("#.##");
tbResult.Text += "\n\nSICK DAYS REMAINING: " + objPayment.Sick_Days_Remaining;
tbResult.Text += "\nANNUAL LEAVE REMAINING: " + objPayment.Annual_Leave_Remaining;
DGEmployees.ItemsSource = db.EmployeeInfo.ToList();
MessageBox.Show("Payment Processed");
}
}
else
{
MessageBox.Show("Select an employee or allocate hours worked");
}
}