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 UpdatePunishment(EmployeeJobHistoryDTO jobHistories) { EmployeeJobHistory dataToInsert = EmployeeJobHistoryRequestFormatter.ConvertRespondentInfoFromDTO(jobHistories); dataToInsert.ServiceEventGroupId = 5; 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 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); }
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); }