public ModelViewAdmin Detail(int id)
{
var employment = _contextHuman.EMPLOYMENTS.Find(id);
var personal = _contextHuman.PERSONALS.FromSqlRaw("SELECT * FROM PERSONAL where EMPLOYEE_ID ='" + id + "'").First <PERSONAL>();
var employee = _contextPayroll.employees.FromSqlRaw("SELECT * FROM employee where EmployeeNumber ='" + id + "'").First <employee>();
ModelViewAdmin model = new ModelViewAdmin
{
EMPLOYEE_ID = personal.EMPLOYEE_ID,
CURRENT_FIRST_NAME = personal.CURRENT_FIRST_NAME,
CURRENT_LAST_NAME = personal.CURRENT_LAST_NAME,
BIRTH_DATE = personal.BIRTH_DATE,
SOCIAL_SECURITY_NUMBER = personal.SOCIAL_SECURITY_NUMBER,
CURRENT_ADDRESS_1 = personal.CURRENT_ADDRESS_1,
CURRENT_GENDER = personal.CURRENT_GENDER,
CURRENT_MARITAL_STATUS = personal.CURRENT_MARITAL_STATUS,
CURRENT_PHONE_NUMBER = personal.CURRENT_PHONE_NUMBER,
CURRENT_PERSONAL_EMAIL = personal.CURRENT_PERSONAL_EMAIL,
HIRE_DATE_FOR_WORKING = employment.HIRE_DATE_FOR_WORKING,
NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH = employment.NUMBER_DAYS_REQUIREMENT_OF_WORKING_PER_MONTH,
EMPLOYMENT_STATUS = employment.EMPLOYMENT_STATUS,
PayRate = employee.PayRate,
PayRatesidPayRates = employee.PayRatesidPayRates,
VacationDays = employee.VacationDays,
};
return(model);
}
public IActionResult Edit(ModelViewAdmin model)
{
if (ModelState.IsValid)
{
_admin.Update(model);
return(RedirectToAction("Index"));
}
return(View());
}
// }
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();
}
public void Update(ModelViewAdmin request)
{
var employment = _contextHuman.EMPLOYMENTS.Find(request.EMPLOYEE_ID);
var personal = _contextHuman.PERSONALS.FromSqlRaw("SELECT * FROM PERSONAL where EMPLOYEE_ID ='" + request.EMPLOYEE_ID + "'").First <PERSONAL>();
var employee = _contextPayroll.employees.FromSqlRaw("SELECT * FROM employee where EmployeeNumber ='" + request.EMPLOYEE_ID + "'").First <employee>();
// update personal table
personal.CURRENT_FIRST_NAME = request.CURRENT_FIRST_NAME;
personal.CURRENT_LAST_NAME = request.CURRENT_LAST_NAME;
personal.BIRTH_DATE = request.BIRTH_DATE;
personal.SOCIAL_SECURITY_NUMBER = request.SOCIAL_SECURITY_NUMBER;
personal.CURRENT_ADDRESS_1 = request.CURRENT_ADDRESS_1;
personal.CURRENT_GENDER = request.CURRENT_GENDER;
personal.CURRENT_PHONE_NUMBER = request.CURRENT_PHONE_NUMBER;
personal.CURRENT_PERSONAL_EMAIL = request.CURRENT_PERSONAL_EMAIL;
_contextHuman.SaveChanges();
// update employment
employment.HIRE_DATE_FOR_WORKING = request.HIRE_DATE_FOR_WORKING;
employment.EMPLOYMENT_STATUS = request.EMPLOYMENT_STATUS;
_contextHuman.SaveChanges();
// update employee
employee.LastName = request.CURRENT_LAST_NAME;
employee.FirstName = request.CURRENT_FIRST_NAME;
employee.PayRatesidPayRates = request.PayRatesidPayRates;
employee.VacationDays = request.VacationDays;
_contextPayroll.SaveChanges();
}
