private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbAmount.Text == "" || tbValue.Text == "" || dpPayrollDate.SelectedDate == null || rbLate.IsChecked == false && rbUndertime.IsChecked == false)
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
Tardy tardy = new Tardy();
tardy.Amount = Decimal.Parse(tbAmount.Text);
tardy.EmployeeID = empid;
tardy.PayrollDate = dpPayrollDate.SelectedDate.Value;
tardy.Value = Convert.ToInt32(tbValue.Text);
if (rbLate.IsChecked == true)
{
tardy.Type = 1;
}
else
{
tardy.Type = 2;
}
db.Tardies.Add(tardy);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var tardy = db.Tardies.Where(m => m.TardyID == tardyid).FirstOrDefault();
tardy.Amount = Decimal.Parse(tbAmount.Text);
tardy.EmployeeID = empid;
tardy.PayrollDate = dpPayrollDate.SelectedDate.Value;
tardy.Value = Convert.ToInt32(tbValue.Text);
if (rbLate.IsChecked == true)
{
tardy.Type = 1;
}
else
{
tardy.Type = 2;
}
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbAmortization.Text == "" || tbPrincipalAmount.Text == "" || tbTotalLoanAmount.Text == "" || tbTotalPayment.Text == "" || cbLoanType.SelectedItem == null || cbPeriod.SelectedItem == null || dpStartDate.SelectedDate == null || dpToDate.SelectedDate == null)
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
Loan loan = new Loan();
loan.EmployeeID = empid;
loan.Amortization = Decimal.Parse(tbAmortization.Text);
loan.PrincipalAmount = Decimal.Parse(tbPrincipalAmount.Text);
loan.TotalLoanAmount = Decimal.Parse(tbTotalLoanAmount.Text);
loan.TotalPayment = Decimal.Parse(tbTotalPayment.Text);
loan.StDate = dpStartDate.SelectedDate.Value;
loan.ToDate = dpToDate.SelectedDate.Value;
loan.LoanTypeID = Convert.ToInt32(cbLoanType.SelectedValue);
loan.PeriodID = Convert.ToInt32(cbPeriod.SelectedValue);
db.Loans.Add(loan);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var loan = db.Loans.Where(m => m.LoanID == loanid).FirstOrDefault();
loan.EmployeeID = empid;
loan.Amortization = Decimal.Parse(tbAmortization.Text);
loan.PrincipalAmount = Decimal.Parse(tbPrincipalAmount.Text);
loan.TotalLoanAmount = Decimal.Parse(tbTotalLoanAmount.Text);
loan.TotalPayment = Decimal.Parse(tbTotalPayment.Text);
loan.StDate = dpStartDate.SelectedDate.Value;
loan.ToDate = dpToDate.SelectedDate.Value;
loan.LoanTypeID = Convert.ToInt32(cbLoanType.SelectedValue);
loan.PeriodID = Convert.ToInt32(cbPeriod.SelectedValue);
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (cbHolidayType.SelectedItem == null || tbNoOfDays.Text == "" || tbAmount.Text == "" || dpDate.SelectedDate == null || dpStDate.SelectedDate == null || dpToDate.SelectedDate == null)
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
Holiday holiday = new Holiday();
holiday.EmployeeID = empid;
holiday.PayrollDate = dpDate.SelectedDate.Value;
holiday.StDate = dpStDate.SelectedDate.Value;
holiday.ToDate = dpToDate.SelectedDate.Value;
holiday.Amount = Decimal.Parse(tbAmount.Text);
holiday.HolidayTypeID = Convert.ToInt32(cbHolidayType.SelectedValue);
holiday.NoOfDays = Decimal.Parse(tbNoOfDays.Text);
db.Holidays.Add(holiday);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var holiday = db.Holidays.Where(m => m.HolidayID == holidayid).FirstOrDefault();
holiday.EmployeeID = empid;
holiday.PayrollDate = dpDate.SelectedDate.Value;
holiday.StDate = dpStDate.SelectedDate.Value;
holiday.ToDate = dpToDate.SelectedDate.Value;
holiday.Amount = Decimal.Parse(tbAmount.Text);
holiday.HolidayTypeID = Convert.ToInt32(cbHolidayType.SelectedValue);
holiday.NoOfDays = Decimal.Parse(tbNoOfDays.Text);
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (cbNightShiftType.SelectedItem == null || tbValue.Text == "" || tbAmount.Text == "" || dpToDate.SelectedDate == null || dpStDate.SelectedDate == null || dpDate.SelectedDate == null)
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
NightDifferential NightDifferential = new NightDifferential();
NightDifferential.EmployeeID = empid;
NightDifferential.PayrollDate = dpDate.SelectedDate.Value;
NightDifferential.StDate = dpStDate.SelectedDate.Value;
NightDifferential.ToDate = dpToDate.SelectedDate.Value;
NightDifferential.Amount = Decimal.Parse(tbAmount.Text);
NightDifferential.NightShiftTypeID = Convert.ToInt32(cbNightShiftType.SelectedValue);
NightDifferential.Value = Convert.ToInt32(tbValue.Text);
db.NightDifferentials.Add(NightDifferential);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var nightdiff = db.NightDifferentials.Where(m => m.NightDifferentialID == nightdiffid).FirstOrDefault();
nightdiff.EmployeeID = empid;
nightdiff.PayrollDate = dpDate.SelectedDate.Value;
nightdiff.StDate = dpStDate.SelectedDate.Value;
nightdiff.ToDate = dpToDate.SelectedDate.Value;
nightdiff.Amount = Decimal.Parse(tbAmount.Text);
nightdiff.NightShiftTypeID = Convert.ToInt32(cbNightShiftType.SelectedValue);
nightdiff.Value = Decimal.Parse(tbValue.Text);
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private async void btnSave_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
MessageDialogResult mdr = await this.ShowMessageAsync("READ", "ARE YOU SURE YOU WANT TO SAVE THIS ATTENDANCE?", MessageDialogStyle.AffirmativeAndNegative);
if (mdr == MessageDialogResult.Affirmative)
{
foreach (var x in lAttendance.Where(m => m.ID == "8166"))
{
DateTime datetime = DateTime.ParseExact(x.Date + " " + x.Time, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture);
BiometricsLog bio = new BiometricsLog();
bio.BiometricsID = Convert.ToInt32(x.ID);
bio.DTime = datetime;
bio.Mode = Convert.ToInt32(x.Mode);
db.BiometricsLogs.Add(bio);
db.SaveChanges();
}
MessageBox.Show("Saving Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbNoOfDays.Text == "" || tbAmount.Text == "" || dpStDate.SelectedDate == null || dpToDate.SelectedDate == null || dpToDate.SelectedDate == null)
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
Income income = new Income();
income.EmployeeID = employeeid;
income.PayrollDate = dpStartDate.SelectedDate.Value;
income.Amount = Decimal.Parse(tbAmount.Text);
income.NoOfDays = Decimal.Parse(tbNoOfDays.Text);
income.StDate = dpStartDate.SelectedDate.Value;
income.ToDate = dpToDate.SelectedDate.Value;
db.Incomes.Add(income);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var income = db.Incomes.Where(m => m.IncomeID == incomeid).FirstOrDefault();
income.EmployeeID = employeeid;
income.PayrollDate = dpStartDate.SelectedDate.Value;
income.NoOfDays = Decimal.Parse(tbNoOfDays.Text);
income.Amount = Decimal.Parse(tbAmount.Text);
income.StDate = dpStDate.SelectedDate.Value;
income.ToDate = dpToDate.SelectedDate.Value;
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbAmount.Text == "" || dpDate.SelectedDate == null)
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
Adjustment adjustment = new Adjustment();
adjustment.EmployeeID = empid;
adjustment.PayrollDate = dpDate.SelectedDate.Value;
adjustment.Amount = Decimal.Parse(tbAmount.Text);
db.Adjustments.Add(adjustment);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var adjustment = db.Adjustments.Where(m => m.AdjustmentID == adjustmentid).FirstOrDefault();
adjustment.EmployeeID = empid;
adjustment.PayrollDate = dpDate.SelectedDate.Value;
adjustment.Amount = Decimal.Parse(tbAmount.Text);
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
//try
//{
using (var db = new DMSIPayrollEntities())
{
if (tbIncomeTypeCode.Text == "" || tbMultiplier.Text == "" || tbDescription.Text == "")
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
HolidayType holidayType = new HolidayType();
holidayType.HolidayCode = tbIncomeTypeCode.Text;
holidayType.Description = tbDescription.Text;
holidayType.Multiplier = Decimal.Parse(tbMultiplier.Text);
db.HolidayTypes.Add(holidayType);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var holidayType = db.HolidayTypes.Where(m => m.HolidayTypeID == holidaytypeid).FirstOrDefault();
holidayType.HolidayCode = tbIncomeTypeCode.Text;
holidayType.Description = tbDescription.Text;
holidayType.Multiplier = Decimal.Parse(tbMultiplier.Text);
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
//}
//catch (Exception)
//{
// MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
//}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbDailyRate.Text == "" || tbPosition.Text == "")
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
EmployeePosition position = new EmployeePosition();
position.PositionName = tbPosition.Text;
position.DailyRate = Decimal.Parse(tbDailyRate.Text);
db.EmployeePositions.Add(position);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var position = db.EmployeePositions.Where(m => m.EmployeePositionID == positionid).FirstOrDefault();
position.PositionName = tbPosition.Text;
position.DailyRate = Decimal.Parse(tbDailyRate.Text);
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbCompany.Text == "" || tbAddress.Text == "")
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
Company company = new Company();
company.CompanyName = tbCompany.Text;
company.Address = tbAddress.Text;
db.Companies.Add(company);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var company = db.Companies.Where(m => m.CompanyID == companyid).FirstOrDefault();
company.CompanyName = tbCompany.Text;
company.Address = tbAddress.Text;
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbDescription.Text == "" || tbIncomeTypeCode.Text == "")
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
IncomeType incomeType = new IncomeType();
incomeType.IncomeTypeCode = tbIncomeTypeCode.Text;
incomeType.Description = tbDescription.Text;
db.IncomeTypes.Add(incomeType);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var incomeType = db.IncomeTypes.Where(m => m.IncomeTypeID == incometypeid).FirstOrDefault();
incomeType.IncomeTypeCode = tbIncomeTypeCode.Text;
incomeType.Description = tbDescription.Text;
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbNoOfDays.Text == "" || dpStartDate.SelectedDate == null || dpStDate.SelectedDate == null || dpToDate.SelectedDate == null)
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
List <CheckBox> checkBoxlist = new List <CheckBox>();
FindChildGroup <CheckBox>(datagridview, "checkboxinstance", ref checkBoxlist);
var checkeditems = checkBoxlist.Where(m => m.IsChecked == true).ToList();
foreach (var c in checkeditems)
{
Income income = new Income();
DMSIClass._Employee x = c.DataContext as DMSIClass._Employee;
var position = db.EmployeePositions.Where(m => m.EmployeePositionID == x.PositionID).FirstOrDefault();
income.EmployeeID = x.EmployeeID;
income.NoOfDays = Convert.ToInt32(tbNoOfDays.Text);
income.Amount = income.NoOfDays * position.DailyRate;
income.StDate = dpStDate.SelectedDate.Value;
income.ToDate = dpToDate.SelectedDate.Value;
income.PayrollDate = dpStartDate.SelectedDate.Value;
db.Incomes.Add(income);
db.SaveChanges();
}
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (string.IsNullOrEmpty(tbPayrollCode.Text) || dpPayrollDate.SelectedDate == null)
{
MessageBox.Show("Fill up the required fields.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
PYTable pyTable = new PYTable();
foreach (var x in lPayrollDetails)
{
Payroll payroll = new Payroll();
pyTable.Payrolls.Add(new Payroll()
{
EmployeeID = x.EmployeeID,
Income = Convert.ToDecimal(x.BasicAmount == null ? 0 : x.BasicAmount),
NightDifferential = Convert.ToDecimal(x.NightDiffamount),
Overtime = Convert.ToDecimal(x.OTAmount),
Holiday = Convert.ToDecimal(x.HolidayAmount),
Tardiness = Convert.ToDecimal(x.LateUndertimeAmount),
Adjustment = Convert.ToDecimal(x.Adjustment),
OtherIncome = Convert.ToDecimal(x.OtherInc),
Gross = Convert.ToDecimal(x.Gross),
SSS = Convert.ToDecimal(x.SSS),
PAGIBIG = Convert.ToDecimal(x.Pagibig),
PHILHEALTH = Convert.ToDecimal(x.Philhealth),
Loan = Convert.ToDecimal(x.Loan),
Deduction = Convert.ToDecimal(x.Deduction),
Leaves = Convert.ToDecimal(x.Leave),
});
}
pyTable.PYCode = tbPayrollCode.Text;
pyTable.StDate = StDate;
pyTable.ToDate = Todate;
pyTable.PYDate = dpPayrollDate.SelectedDate.Value;
pyTable.Comments = tbComment.Text;
pyTable.PYType = 2;
db.PYTables.Add(pyTable);
db.SaveChanges();
var pytable = db.PYTables.OrderByDescending(m => m.PYTableID).Take(1).FirstOrDefault();
var payrolls = db.Payrolls.Where(m => m.PYTableID == pytable.PYTableID).ToList();
foreach (var x in payrolls)
{
if (income != null)
{
foreach (var y in income)
{
var income = db.Incomes.Where(m => m.IncomeID == y.IncomeID).FirstOrDefault();
income.PayrollID = x.PayrollID;
}
foreach (var y in holiday)
{
var holiday = db.Holidays.Where(m => m.HolidayID == y.HolidayID).FirstOrDefault();
holiday.PayrollID = x.PayrollID;
}
foreach (var y in tardy)
{
var tardy = db.Tardies.Where(m => m.TardyID == y.TardyID).FirstOrDefault();
tardy.PayrollID = x.PayrollID;
}
foreach (var y in overtime)
{
var tardy = db.Overtimes.Where(m => m.OvertimeID == y.OvertimeID).FirstOrDefault();
tardy.PayrollID = x.PayrollID;
}
foreach (var y in nightdiff)
{
var tardy = db.NightDifferentials.Where(m => m.NightDifferentialID == y.NightDifferentialID).FirstOrDefault();
tardy.PayrollID = x.PayrollID;
}
foreach (var y in leave)
{
var leave = db.Leaves.Where(m => m.LeaveID == y.LeaveID).FirstOrDefault();
leave.PayrollID = x.PayrollID;
}
foreach (var y in adjustment)
{
var adjustment = db.Adjustments.Where(m => m.AdjustmentID == y.AdjustmentID).FirstOrDefault();
adjustment.PayrollID = x.PayrollID;
db.SaveChanges();
}
foreach (var y in otherinc)
{
PayrollDetails_OtherIncome otherincomeDetails = new PayrollDetails_OtherIncome();
otherincomeDetails.PayrollID = x.PayrollID;
otherincomeDetails.OtherIncomeID = y.OtherIncomeID;
otherincomeDetails.Amount = y.Amount;
db.PayrollDetails_OtherIncome.Add(otherincomeDetails);
}
foreach (var y in deduction)
{
PayrollDetails_Deduction deductionDetails = new PayrollDetails_Deduction();
deductionDetails.PayrollID = x.PayrollID;
deductionDetails.DeductionID = y.DeductionID;
deductionDetails.Amount = y.Amortization;
db.PayrollDetails_Deduction.Add(deductionDetails);
}
foreach (var y in loan)
{
PayrollDetails_Loan loanDetails = new PayrollDetails_Loan();
loanDetails.PayrollID = x.PayrollID;
loanDetails.LoanID = y.LoanID;
loanDetails.Amount = y.Amortization;
db.PayrollDetails_Loan.Add(loanDetails);
}
}
}
db.SaveChanges();
MessageBox.Show("Posting payroll success.", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = new DMSIPayrollEntities())
{
if (tbEmployeeNumber.Text == "" || tbFirstName.Text == "" || tbLastName.Text == "" || cbCompany.SelectedItem == null || cbPosition.SelectedItem == null)
{
MessageBox.Show("Required fields cannot be empty.", "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (mode == 1)
{
Employee employee = new Employee();
employee.LastName = tbLastName.Text;
employee.FirstName = tbFirstName.Text;
employee.MiddleName = tbMiddleName.Text;
employee.EmployeePositionID = Convert.ToInt32(cbPosition.SelectedValue);
employee.CompanyID = Convert.ToInt32(cbCompany.SelectedValue);
employee.DateResigned = dpDateResigned.SelectedDate == null ? null : dpDateResigned.SelectedDate;
employee.EmployeeNumber = tbEmployeeNumber.Text;
employee.BiometricsID = tbBiometricsID.Text == "" ? (int?)null : Convert.ToInt32(tbBiometricsID.Text);
employee.DateHired = dpDateHired.SelectedDate == null ? null : dpDateHired.SelectedDate;
employee.Birthdate = dpBirthdate.SelectedDate == null ? null : dpBirthdate.SelectedDate;
employee.Address = tbAddress.Text;
employee.CivilStatus = Convert.ToString(cbCivilStatus.SelectedValue);
employee.ContactNo = tbContactNo.Text;
employee.Guardian = tbGuardian.Text;
employee.GuardianContactNo = tbGuardianContactNo.Text;
employee.Relationship = tbRelationship.Text;
employee.SSS = tbSSS.Text;
employee.Philhealth = tbPhilhealth.Text;
employee.Tin = tbTIN.Text;
employee.HMDF = tbHDMF.Text;
if (rbFemale.IsChecked == true)
{
employee.Gender = "F";
}
else if (rbMale.IsChecked == true)
{
employee.Gender = "M";
}
if (rbLogistics.IsChecked == true)
{
employee.PayrollType = 1;
}
else if (rbOtherDivision.IsChecked == true)
{
employee.PayrollType = 2;
}
if (cboxIsActive.IsChecked == true)
{
employee.IsActive = true;
}
else
{
employee.IsActive = false;
}
db.Employees.Add(employee);
db.SaveChanges();
MessageBox.Show("Add Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
}
else if (mode == 2)
{
var employee = db.Employees.Where(m => m.EmployeeID == employeeid).FirstOrDefault();
employee.LastName = tbLastName.Text;
employee.FirstName = tbFirstName.Text;
employee.MiddleName = tbMiddleName.Text;
employee.EmployeePositionID = Convert.ToInt32(cbPosition.SelectedValue);
employee.CompanyID = Convert.ToInt32(cbCompany.SelectedValue);
employee.DateResigned = dpDateResigned.SelectedDate == null ? null : dpDateResigned.SelectedDate;
employee.EmployeeNumber = tbEmployeeNumber.Text;
employee.BiometricsID = tbBiometricsID.Text == "" ? (int?)null : Convert.ToInt32(tbBiometricsID.Text);
employee.DateHired = dpDateHired.SelectedDate == null ? null : dpDateHired.SelectedDate;
employee.Birthdate = dpBirthdate.SelectedDate == null ? null : dpBirthdate.SelectedDate;
employee.Address = tbAddress.Text;
employee.CivilStatus = Convert.ToString(cbCivilStatus.SelectedValue);
employee.ContactNo = tbContactNo.Text;
employee.Guardian = tbGuardian.Text;
employee.GuardianContactNo = tbGuardianContactNo.Text;
employee.Relationship = tbRelationship.Text;
employee.SSS = tbSSS.Text;
employee.Philhealth = tbPhilhealth.Text;
employee.Tin = tbTIN.Text;
employee.HMDF = tbHDMF.Text;
if (rbFemale.IsChecked == true)
{
employee.Gender = "F";
}
else if (rbMale.IsChecked == true)
{
employee.Gender = "M";
}
if (rbLogistics.IsChecked == true)
{
employee.PayrollType = 1;
}
else if (rbOtherDivision.IsChecked == true)
{
employee.PayrollType = 2;
}
if (cboxIsActive.IsChecked == true)
{
employee.IsActive = true;
}
else
{
employee.IsActive = false;
}
db.SaveChanges();
MessageBox.Show("Update Succesful", "System Succes!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong.", "System Error!", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
