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