public void Add(ModelViewHuman request)
{
var maNhanVien = _context.PERSONALS.Count <PERSONAL>() + 1;
EMPLOYMENT nhanvien = new EMPLOYMENT
{
EMPLOYMENT_ID = maNhanVien,
HIRE_DATE_FOR_WORKING = request.HIRE_DATE_FOR_WORKING,
NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH = request.NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH,
};
_context.EMPLOYMENTS.Add(nhanvien);
_context.SaveChanges();
PERSONAL canhan = new PERSONAL
{
EMPLOYEE_ID = maNhanVien,
CURRENT_FIRST_NAME = request.CURRENT_FIRST_NAME,
CURRENT_LAST_NAME = request.CURRENT_LAST_NAME,
BIRTH_DATE = request.BIRTH_DATE,
CURRENT_ADDRESS_1 = request.CURRENT_ADDRESS_1,
CURRENT_GENDER = request.CURRENT_GENDER,
CURRENT_PHONE_NUMBER = request.CURRENT_PHONE_NUMBER,
CURRENT_PERSONAL_EMAIL = request.CURRENT_PERSONAL_EMAIL,
};
_context.PERSONALS.Add(canhan);
_context.SaveChanges();
}
// }
public void Add(ModelViewAdmin request)
{
//var id = _contextHuman.EMPLOYMENTS.Count<EMPLOYMENT>() + 1;
EMPLOYMENT employment = new EMPLOYMENT
{
//EMPLOYMENT_ID = id,
HIRE_DATE_FOR_WORKING = request.HIRE_DATE_FOR_WORKING,
EMPLOYMENT_STATUS = request.EMPLOYMENT_STATUS,
};
_contextHuman.EMPLOYMENTS.Add(employment);
_contextHuman.SaveChanges();
var id = _contextHuman.EMPLOYMENTS.FromSqlRaw("SELECT TOP 1 * FROM EMPLOYMENT ORDER BY EMPLOYMENT_ID DESC ").FirstOrDefault();
//var id = _contextHuman.EMPLOYMENTS.Last<EMPLOYMENT>();
PERSONAL personal = new PERSONAL
{
EMPLOYEE_ID = id.EMPLOYMENT_ID,
CURRENT_FIRST_NAME = request.CURRENT_FIRST_NAME,
CURRENT_LAST_NAME = request.CURRENT_LAST_NAME,
BIRTH_DATE = request.BIRTH_DATE,
SOCIAL_SECURITY_NUMBER = request.SOCIAL_SECURITY_NUMBER,
CURRENT_ADDRESS_1 = request.CURRENT_ADDRESS_1,
CURRENT_GENDER = request.CURRENT_GENDER,
CURRENT_PHONE_NUMBER = request.CURRENT_PHONE_NUMBER,
CURRENT_PERSONAL_EMAIL = request.CURRENT_PERSONAL_EMAIL,
};
_contextHuman.PERSONALS.Add(personal);
_contextHuman.SaveChanges();
employee employee = new employee
{
idEmployee = id.EMPLOYMENT_ID,
LastName = request.CURRENT_LAST_NAME,
FirstName = request.CURRENT_FIRST_NAME,
PayRatesidPayRates = request.PayRatesidPayRates,
VacationDays = request.VacationDays,
};
_contextPayroll.employees.Add(employee);
_contextPayroll.SaveChanges();
}
