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