public EmployeeViewModel Add(EmployeeViewModel vm)
{
var temp = _mapper.Map <EmployeeViewModel, Employee>(vm);
_employeeReponsitory.Add(temp);
return(vm);
}
public void HandleExcelFile(FileInfo fileInfo, int requestId)
{
using (ExcelPackage excel = new ExcelPackage(fileInfo))
{
ExcelWorksheet worksheet = excel.Workbook.Worksheets[1];
int rowCount = rowCount = worksheet.Dimension.Rows;
for (int row = 6; row <= rowCount; row++)
{
try
{
EmployeeViewModel e = GetEmployeeViewModelByWorkSheet(worksheet, row);
PayslipDetailViewModel payslipDetailViewModel = GetPayslipDetailViewModelByWorkSheet(worksheet, row, requestId, e);
var employee = _mapper.Map <EmployeeViewModel, Employee>(e);
Employee temp = _employeeReponsitory.FindById(employee.Id);
if (temp == null)
{
_employeeReponsitory.Add(employee);
}
else
{
temp.Email = employee.Email;
temp.FullName = employee.FullName;
temp.DeptTeam = employee.DeptTeam;
temp.StartDay = employee.StartDay;
temp.Position = employee.Position;
}
_employeeReponsitory.Commit();
var payslip = _mapper.Map <PayslipDetailViewModel, PayslipDetail>(payslipDetailViewModel);
_payslipDetailReponsitory.Add(payslip);
_payslipDetailReponsitory.Commit();
}
catch (Exception ex)
{
throw ex;
}
}
}
}