public ModelViewPayroll Detail(int id)
{
var nhanVien = _context.employees.Find(id);
var luong = _context.payratess.Find(nhanVien.PayRatesidPayRates);
ModelViewPayroll mdp = new ModelViewPayroll
{
idEmployee = nhanVien.idEmployee,
EmployeeNumber = nhanVien.EmployeeNumber,
LastName = nhanVien.LastName,
FirstName = nhanVien.FirstName,
SSN = nhanVien.SSN,
PayRate = nhanVien.PayRate,
VacationDays = nhanVien.VacationDays,
PayRateName = luong.PayRateName,
Value = luong.Value,
TaxPercentage = luong.TaxPercentage,
PayType = luong.PayType,
PayAmount = luong.PayAmount,
PTLevelC = luong.PTLevelC,
};
return(mdp);
}
public IActionResult Create(ModelViewPayroll request)
{
if (ModelState.IsValid)
{
_managePayroll.Add(request);
return(RedirectToAction("Index"));
}
return(View());
}
public void Update(ModelViewPayroll request)
{
var nhanvien = _context.employees.FromSqlRaw("SELECT * FROM employee WHERE EmployeeNumber= '" + request.EmployeeNumber + "'").First <employee>();
nhanvien.LastName = request.LastName;
nhanvien.FirstName = request.FirstName;
nhanvien.SSN = request.SSN;
nhanvien.PayRate = request.PayRate;
nhanvien.PayRatesidPayRates = request.PayRatesidPayRates;
nhanvien.VacationDays = request.VacationDays;
_context.SaveChanges();
}
public void Add(ModelViewPayroll request)
{
var idE = _context.employees.Count <employee>() + 1;
employee nhanvien = new employee
{
idEmployee = idE,
LastName = request.LastName,
FirstName = request.FirstName,
SSN = request.SSN,
PayRate = request.PayRate,
PayRatesidPayRates = request.PayRatesidPayRates,
VacationDays = request.VacationDays,
};
_context.employees.Add(nhanvien);
_context.SaveChanges();
}
