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