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