public async Task <IActionResult> Edit(int id, [Bind("FristName,Surname,Relationship,FkEmployeeId,Id")] EmployeeFamily employeeFamily)
{
if (id != employeeFamily.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(employeeFamily);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeFamilyExists(employeeFamily.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["FkEmployeeId"] = new SelectList(_context.Employees, "Id", "Address1", employeeFamily.FkEmployeeId);
return(View(employeeFamily));
}
public async Task <IActionResult> AddFamilyMember(EmployeeFamily item)
{
_context.EmployeeFamilies.Add(item);
await _context.SaveChangesAsync();
return(RedirectToAction("FamilyList", new { id = item.EmployeeId }));
}
public void UpdateEmployeeFamily(EmployeeFamilyDTO Record)
{
EmployeeFamily ReturnRecord = EmployeeFamilyRequestFormatter.EmployeeFamilyDTOToDb(Record);
ReturnRecord.EmpCode = Record.EmpId;
_unitOfWork.EmployeeFamilyRepository.Update(ReturnRecord);
}
public EmployeeFamilyDTO GetOneEmployeeFamily(int Id)
{
EmployeeFamily Record = _unitOfWork.EmployeeFamilyRepository.Get(x => x.FamilyId == Id).FirstOrDefault();
EmployeeFamilyDTO ReturnRecord = ResponseFormatters.EmployeeFamilyResponseFormatter.EmplyeeFamilyDbToDTO(Record);
return(ReturnRecord);
}
public async Task <IActionResult> EditFamilyMember(EmployeeFamily item)
{
var model = await _context.EmployeeFamilies.SingleOrDefaultAsync(b => b.Id == item.Id);
await TryUpdateModelAsync(model);
await _context.SaveChangesAsync();
return(RedirectToAction("FamilyList", new { id = model.EmployeeId }));
}
public async Task <IActionResult> Create([Bind("FristName,Surname,Relationship,FkEmployeeId,Id")] EmployeeFamily employeeFamily)
{
if (ModelState.IsValid)
{
_context.Add(employeeFamily);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["FkEmployeeId"] = new SelectList(_context.Employees, "Id", "Address1", employeeFamily.FkEmployeeId);
return(View(employeeFamily));
}
public void Save(IEntityManager em, Transaction tx, EmployeeFamily employeeFamily)
{
string[] columns = { "ID", "EmployeeId", "FamilyName", "Status", "Education", "BirthPlace",
"BirthDate", "Job", "IsInsurance" };
object[] values = { Guid.NewGuid(), employeeFamily.EmployeeId, employeeFamily.FamilyName,
employeeFamily.Status, employeeFamily.Education, employeeFamily.BirthPlace,
employeeFamily.BirthDate.ToShortDateString(), employeeFamily.Job,
employeeFamily.IsInsurance == true?1:0 };
var q = new Query().Select(columns).From(tableName).Insert(values);
em.ExecuteNonQuery(q.ToSql(), tx);
}
public async Task <IActionResult> Update([FromBody] EmployeeFamily employeeFamily)
{
int result = 0;
try
{
context.Update(employeeFamily);
result = await context.SaveChangesAsync();
}
catch (Exception ex)
{
logger.LogError(ex.ToString());
}
return(Ok(result));
}
public async Task <IActionResult> Save([FromBody] EmployeeFamily employeeFamily)
{
int result = 0;
try
{
employeeFamily.EmployeeFamilyId = Guid.NewGuid();
context.Add(employeeFamily);
result = await context.SaveChangesAsync();
}
catch (Exception ex)
{
logger.LogError(ex.ToString());
}
return(Ok(result));
}
public static EmployeeFamily EmployeeFamilyDTOToDb(EmployeeFamilyDTO ModelData)
{
EmployeeFamily Record = new EmployeeFamily
{
EmpCode = ModelData.EmpCode,
FamilyId = ModelData.FamilyId,
Fname = ModelData.Fname,
FDob = ModelData.FDob,
FGender = ModelData.FGender,
FRelation = ModelData.FRelation,
FContactNumber = ModelData.FContactNumber,
FContactAddress = ModelData.FContactAddress,
};
return(Record);
}
public static EmployeeFamilyViewModel ConvertRespondentInfoToDTO(EmployeeFamily family)
{
Mapper.CreateMap <EmployeeFamily, EmployeeFamilyViewModel>().ConvertUsing(
m =>
{
return(new EmployeeFamilyViewModel
{
EmpCode = m.EmpCode,
FamilyId = m.FamilyId,
FContactAddress = m.FContactAddress,
FContactNumber = m.FContactNumber,
FDob = Convert.ToDateTime(m.FDob),
FGender = m.FGender,
Fname = m.Fname,
FRelation = m.FRelation
});
});
return(Mapper.Map <EmployeeFamily, EmployeeFamilyViewModel>(family));
}
public static EmployeeFamilyDTO EmplyeeFamilyDbToDTO(EmployeeFamily ModelData)
{
EmployeeFamilyDTO Record = new EmployeeFamilyDTO
{
EmpCode = ModelData.EmpCode,
EmpId = ModelData.EmpCode,
FamilyId = ModelData.FamilyId,
Fname = ModelData.Fname,
FDob = ModelData.FDob,
FGender = ModelData.FGender,
FRelation = ModelData.FRelation,
FContactNumber = ModelData.FContactNumber,
FContactAddress = ModelData.FContactAddress,
Employee = new EmployeeDTO
{
EmpCode = ModelData.Employee.EmpCode,
EmpName = ModelData.Employee.EmpName,
}
};
return(Record);
}
/// <summary>
/// Khởi tạo đối tượng trước khi build các thông tin
/// Dựa vào thông tin bảng dữ liệu sẽ import dữ liệu vào mà map các đối tượng tương ứng.
/// </summary>
/// <typeparam name="T">Kiểu của object</typeparam>
/// <returns>Thực thể được khởi tạo với kiểu tương ứng</returns>
/// OverriderBy: NVMANH (15/12/2020)
protected override dynamic InstanceEntityBeforeMappingData <T>()
{
var ImportToTable = ImportWorksheetTemplate.ImportToTable;
switch (ImportToTable)
{
case "Employee":
var newEntity = new Employee();
newEntity.EmployeeId = Guid.NewGuid();
return(newEntity);
case "EmployeeFamily":
var eFamily = new EmployeeFamily()
{
EmployeeFamilyId = Guid.NewGuid()
}; //Activator.CreateInstance("MISA.ImportDemo.Core.Entities", "ProfileFamilyDetail");
return(eFamily);
default:
return(base.InstanceEntityBeforeMappingData <T>());
}
}
public int UpdateEmpFamily(EmployeeFamilyViewModel data)
{
EmployeeFamily rnk = EmpFamilyRequestFormatter.ConvertRespondentInfoFromDTO(data);
return(_unitOfWork.EmployeeFamilyRepository.Update(rnk));
}
public EmployeeFamilyViewModel InsertEmpFamily(EmployeeFamilyViewModel data)
{
EmployeeFamily rnk = EmpFamilyRequestFormatter.ConvertRespondentInfoFromDTO(data);
return(EmpFamilyRequestFormatter.ConvertRespondentInfoToDTO(_unitOfWork.EmployeeFamilyRepository.Create(rnk)));
}
public void AddEmplyeeFamily(EmployeeFamilyDTO Record)
{
EmployeeFamily ReturnRecord = EmployeeFamilyRequestFormatter.EmployeeFamilyDTOToDb(Record);
_unitOfWork.EmployeeFamilyRepository.Create(ReturnRecord);
}
