public int UpdateTransfer(EmployeeJobHistoryDTO jobHistories) { EmployeeJobHistory dataToInsert = EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoFromDTO(jobHistories); //var conn = DbConnectHelper.GetConnection(); //conn.Open(); //SqlCommand cmd = new SqlCommand("sp_EmployeeTransferUpdate", conn); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@EmpCode", jobHistories.EmpCode); //cmd.Parameters.AddWithValue("@EmpOfficeId", jobHistories.OfficeId); //cmd.Parameters.AddWithValue("@EmpLevelId", jobHistories.LevelId); //cmd.Parameters.AddWithValue("@EmpShiftId", jobHistories.ShiftId); //cmd.Parameters.AddWithValue("@EmpDeptId", jobHistories.DeptId); //cmd.Parameters.AddWithValue("@EmpSectionId", jobHistories.SectionId); //cmd.Parameters.AddWithValue("@EmpDesgId", jobHistories.DesgId); //cmd.Parameters.AddWithValue("@EmpTypeId", 1); //cmd.Parameters.AddWithValue("@EmpBgId", jobHistories.BusinessGroupId); //cmd.Parameters.AddWithValue("@EmpJobTypeId", jobHistories.JobTypeId); //cmd.Parameters.AddWithValue("@EmpRankId", jobHistories.RankId); //SqlDataAdapter da = new SqlDataAdapter(cmd); //DataTable dt = new DataTable(); //da.Fill(dt); //cmd.Dispose(); //conn.Close(); //conn.Dispose(); dataToInsert.ServiceEventGroupId = 2; int result = _unitOfWork.EmployeeJobHistoryRepository.Update(dataToInsert); return(result); }
public int InsertJobHistoryForNiyukti(EmployeeJobHistoryDTO data) { EmployeeJobHistory dataToInsert = EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoFromDTO(data); EmployeeJobHistory result = _unitOfWork.EmployeeJobHistoryRepository.Create(dataToInsert); return(result.HistoryId); }
public int UpdatePunishment(EmployeeJobHistoryDTO jobHistories) { EmployeeJobHistory dataToInsert = EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoFromDTO(jobHistories); dataToInsert.ServiceEventGroupId = 5; int result = _unitOfWork.EmployeeJobHistoryRepository.Update(dataToInsert); return(result); }
public static EmployeeJobHistoryDTO ConvertRespondentInfoToDTO(EmployeeJobHistory employeeJobHistory) { Mapper.CreateMap <EmployeeJobHistory, EmployeeJobHistoryDTO>().ConvertUsing( m => { return(new EmployeeJobHistoryDTO { BusinessGroupId = m.BusinessGroupId, EffectiveDate = m.EffectiveDate, DecisionDate = m.DecisionDate, DeptId = m.DeptId, DesgId = m.DesgId, DesgKayamMukayamMuKaRaRa = m.DesgKayamMukayamMuKaRaRa, EffectiveTillDate = m.EffectiveTillDate, EmpCode = m.EmpCode, HistoryId = m.HistoryId, Instruction = m.Instruction, JobTypeId = m.JobTypeId, KajEndDate = m.KajEndDate, JobTypeName = m.JobType.JobTypeName, KajStartDate = m.KajStartDate, LetterIssueDate = m.LetterIssueDate, LetterRefNo = m.LetterRefNo, LevelId = m.LevelId, OfficeId = m.OfficeId, OfficeJoinDate = m.OfficeJoinDate, OfficeName = m.Office.OfficeName, RankId = m.RankId, Remarks = m.Remarks, RemoteId = m.RemoteId, SadarDate = m.SadarDate, SadarGarneEmployeeCode = m.SadarGarneEmployeeCode, SectionId = m.SectionId, SectionName = m.Section.SectionName, ServiceEventGroupId = m.ServiceEventGroupId, ServiceHolidingDate = m.ServiceHolidingDate, ServiceEventName = m.ServiceEventGroup.ServiceEventGroupName, ServiceEvent = m.ServiceEvent, ServiceEventSubGroupId = m.ServiceEventSubGroupId, ServiceEventSubName = m.ServiceEventSubGroup.ServiceEventSubGroupName, ShiftId = m.ShiftId, DeptName = m.Department.DeptName, DesignationName = m.Designation.DsgName, // SadarGarneName = m.Employee.EmpName, LevelName = m.Level.LevelName, //RankName = m.Rank.RankName, EmployeeName = m.Employee1.EmpName, KaajType = m.KaajType, ChalaniNumber = m.ChalaniNumber, RemoteCode = m.RemoteCode, }); }); return(Mapper.Map <EmployeeJobHistory, EmployeeJobHistoryDTO>(employeeJobHistory)); }
public int InsertJobHistoryForAbakash(EmployeeJobHistoryDTO data) { EmployeeJobHistory dataToInsert = EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoFromDTO(data); Employee entityToUpdate = _unitOfWork.EmployeeRepository.GetById(dataToInsert.EmpCode); entityToUpdate.EmpStatus = false; dataToInsert.BusinessGroupId = entityToUpdate.EmpBgId; dataToInsert.DeptId = entityToUpdate.EmpDeptId; dataToInsert.DesgId = entityToUpdate.EmpDesgId; dataToInsert.JobTypeId = entityToUpdate.EmpJobTypeId; dataToInsert.LevelId = entityToUpdate.EmpLevelId; dataToInsert.OfficeId = entityToUpdate.EmpOfficeId; dataToInsert.RankId = entityToUpdate.EmpRankId; dataToInsert.SectionId = entityToUpdate.EmpSectionId; dataToInsert.ShiftId = entityToUpdate.EmpSectionId; int res = _unitOfWork.EmployeeRepository.Update(entityToUpdate); _unitOfWork.Save(); return(_unitOfWork.EmployeeJobHistoryRepository.Create(dataToInsert).HistoryId); }
public int InsertJobHistoryForSaruwa(EmployeeJobHistoryDTO data) { EmployeeJobHistory dataToInsert = EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoFromDTO(data); var conn = DbConnectHelper.GetConnection(); conn.Open(); SqlCommand cmd = new SqlCommand("sp_EmployeeTransferUpdate", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EmpCode", data.EmpCode); cmd.Parameters.AddWithValue("@EmpOfficeId", data.OfficeId); cmd.Parameters.AddWithValue("@EmpLevelId", data.LevelId); cmd.Parameters.AddWithValue("@EmpShiftId", data.ShiftId); cmd.Parameters.AddWithValue("@EmpDeptId", data.DeptId); cmd.Parameters.AddWithValue("@EmpSectionId", data.SectionId); cmd.Parameters.AddWithValue("@EmpDesgId", data.DesgId); cmd.Parameters.AddWithValue("@EmpTypeId", 1); cmd.Parameters.AddWithValue("@EmpBgId", data.BusinessGroupId); cmd.Parameters.AddWithValue("@EmpJobTypeId", data.JobTypeId); cmd.Parameters.AddWithValue("@EmpRankId", data.RankId); cmd.Parameters.AddWithValue("@RemoteType", data.RemoteCode); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); cmd.Dispose(); conn.Close(); conn.Dispose(); EmployeeJobHistory result = _unitOfWork.EmployeeJobHistoryRepository.Create(dataToInsert); return(result.HistoryId); }
private static async Task CreateEmployeeCvJobHistory(int id, string historyName, string shortDescription, int employerCvId, ApplicationDbContext _context) { var newHistory = new EmployeeJobHistory { Id = id, Name = historyName, ShortDescription = shortDescription, EmployeeCvId = employerCvId }; var check = _context.EmployeeJobHistories.Where(a => a.Id == id); if (check.Any()) { return; } try { await _context.EmployeeJobHistories.AddAsync(newHistory); await _context.SaveChangesAsync(); } catch (Exception ex) { // ignored } }
public EmployeeJobHistoryDTO GetJobHistoryById(int id) { EmployeeJobHistory res = _unitOfWork.EmployeeJobHistoryRepository.GetById(id); return(EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoToDTO(res)); }
public int UpdateJobHistoryForKaj(EmployeeJobHistoryDTO data) { EmployeeJobHistory dataToInsert = EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoFromDTO(data); return(_unitOfWork.EmployeeJobHistoryRepository.Update(dataToInsert)); }
public int InsertJobHistoryForPunishment(EmployeeJobHistoryDTO data) { EmployeeJobHistory dataToInsert = EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoFromDTO(data); return(_unitOfWork.EmployeeJobHistoryRepository.Create(dataToInsert).HistoryId); }