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 IActionResult Create(ModelViewHuman request) { if (ModelState.IsValid) { _manageHuman.Add(request); return(RedirectToAction("Index")); } return(View()); }
public void Update(ModelViewHuman request) { var canhan = _context.PERSONALS.FromSqlRaw("SELECT * FROM PERSONAL WHERE PERSONAL_ID ='" + request.EMPLOYEE_ID + "' ").First <PERSONAL>(); canhan.CURRENT_FIRST_NAME = request.CURRENT_FIRST_NAME; canhan.CURRENT_LAST_NAME = request.CURRENT_LAST_NAME; canhan.BIRTH_DATE = request.BIRTH_DATE; canhan.CURRENT_ADDRESS_1 = request.CURRENT_ADDRESS_1; canhan.CURRENT_GENDER = request.CURRENT_GENDER; canhan.CURRENT_PHONE_NUMBER = request.CURRENT_PHONE_NUMBER; canhan.CURRENT_PERSONAL_EMAIL = request.CURRENT_PERSONAL_EMAIL; var nhanvien = _context.EMPLOYMENTS.Find(request.EMPLOYEE_ID); nhanvien.HIRE_DATE_FOR_WORKING = request.HIRE_DATE_FOR_WORKING; nhanvien.NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH = request.NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH; _context.SaveChanges(); }
public ModelViewHuman Detail(int id) { var nhanvien = _context.EMPLOYMENTS.Find(id); var canhan = _context.PERSONALS.FromSqlRaw("SELECT * FROM PERSONAL where EMPLOYEE_ID ='" + id + "'").First <PERSONAL>(); ModelViewHuman model = new ModelViewHuman { EMPLOYEE_ID = id, CURRENT_FIRST_NAME = canhan.CURRENT_FIRST_NAME, CURRENT_LAST_NAME = canhan.CURRENT_LAST_NAME, BIRTH_DATE = canhan.BIRTH_DATE, SOCIAL_SECURITY_NUMBER = canhan.SOCIAL_SECURITY_NUMBER, CURRENT_ADDRESS_1 = canhan.CURRENT_ADDRESS_1, CURRENT_GENDER = canhan.CURRENT_GENDER, CURRENT_MARITAL_STATUS = canhan.CURRENT_MARITAL_STATUS, CURRENT_PHONE_NUMBER = canhan.CURRENT_PHONE_NUMBER, CURRENT_PERSONAL_EMAIL = canhan.CURRENT_PERSONAL_EMAIL, HIRE_DATE_FOR_WORKING = nhanvien.HIRE_DATE_FOR_WORKING, NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH = nhanvien.NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH, }; return(model); }