public async Task <IActionResult> AddExperience(EmployeeQualification item)
{
_context.EmployeeQualifications.Add(item);
await _context.SaveChangesAsync();
return(RedirectToAction("ExperiencesList", new { id = item.EmployeeId }));
}
public int Update(EmpQualificationItem model)
{
Mapper.CreateMap <EmpQualificationItem, EmployeeQualification>();
EmployeeQualification objQual = DBcontext.EmployeeQualifications.SingleOrDefault(m => m.Qid == model.Qid);
objQual = Mapper.Map(model, objQual);
return(DBcontext.SaveChanges());
}
public async Task <IActionResult> EditExperience(EmployeeQualification item)
{
var model = await _context.EmployeeQualifications.SingleOrDefaultAsync(b => b.Id == item.Id);
await TryUpdateModelAsync(model);
await _context.SaveChangesAsync();
return(RedirectToAction("ExperiencesList", new { id = model.EmployeeId }));
}
public static void UpdateEmployeeQualification(this EmployeeQualification model, EmployeeQualificationDto modelVm)
{
model.Id = modelVm.Id;
model.EmployeeId = modelVm.EmployeeId;
model.QualificationId = modelVm.QualificationId;
model.Institution = modelVm.Institution;
model.City = modelVm.City;
model.ValidFrom = modelVm.ValidFrom;
model.ValidTo = modelVm.ValidTo;
model.Note = modelVm.Note;
}
public ActionResult Create_Qualifi(ModelView model)
{
if (ModelState.IsValid)
{
EmployeeQualification data = new EmployeeQualification();
db.EmployeeQualifications.Add(data);
TempData["message"] = "Insert success";
db.SaveChanges();
return(RedirectToAction("Edit", "Employee"));
}
return(View());
}
public EmpQualificationItem GetById(int id)
{
try
{
Mapper.CreateMap <EmployeeQualification, EmpQualificationItem>();
EmployeeQualification objQual = DBcontext.EmployeeQualifications.SingleOrDefault(m => m.Qid == id);
EmpQualificationItem objQualItem = Mapper.Map <EmpQualificationItem>(objQual);
return(objQualItem);
}
catch (Exception ex)
{
throw ex;
}
}
public int Insert(EmpQualificationItem model)
{
try
{
Mapper.CreateMap <EmpQualificationItem, EmployeeQualification>();
EmployeeQualification objQual = Mapper.Map <EmployeeQualification>(model);
DBcontext.EmployeeQualifications.Add(objQual);
return(DBcontext.SaveChanges());
}
catch (Exception)
{
throw;
}
}
// GET: EmployeeQualifications/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EmployeeQualification employeeQualification = db.EmployeeQualification.Include(e => e.Employee).Include(e => e.Qualification).
Where(empQual => empQual.EmployeeQualificationID == id).FirstOrDefault();
if (employeeQualification == null)
{
return(HttpNotFound());
}
return(View(employeeQualification));
}
public string Create(EmployeeQualification employeeQualification)
{
qualificationService.Create(employeeQualification);
return("successful");
// PUT api/<QualificationController>/5
// [HttpPut("{id}")]
//public void Put(int id, [FromBody] string value)
//{
//}
// DELETE api/<QualificationController>/5
//[HttpDelete("{id}")]
//public void Delete(int id)
//{
}
public ActionResult Edit([Bind(Include = "EmployeeInTrainingID,EmployeeID,TrainingID,IfPass")] EmployeeInTraining employeeInTraining)
{
if (ModelState.IsValid)
{
if (employeeInTraining.IfPass)
{
var training = db.Trainings.Find(employeeInTraining.TrainingID);
// Find employee qualification
var empQualification = db.EmployeeQualification.Where(empQual => empQual.EmployeeID == employeeInTraining.EmployeeID && empQual.QualificationID == training.QualificationID).FirstOrDefault();
if (empQualification == null)
{
empQualification = new EmployeeQualification()
{
EmployeeID = employeeInTraining.EmployeeID,
QualificationID = training.QualificationID,
ExpirationDate = training.ExpirationDate
};
db.EmployeeQualification.Add(empQualification);
}
else
{
if (empQualification.ExpirationDate < training.ExpirationDate)
{
empQualification.ExpirationDate = training.ExpirationDate;
}
}
}
db.Entry(employeeInTraining).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("EmployeesInTraining", new { id = employeeInTraining.TrainingID }));
}
ViewBag.EmployeeID = new SelectList(db.Employees, "EmployeeID", "LastName", employeeInTraining.EmployeeID);
ViewBag.TrainingID = new SelectList(db.Trainings, "TrainingID", "Name", employeeInTraining.TrainingID);
return(View(employeeInTraining));
}
public EmployeeQualification Create(EmployeeQualification employeeQualification)
{
_qualification.InsertOne(employeeQualification);
return(employeeQualification);
}
public void Update(EmployeeQualification model)
{
_employeeQualificationRepository.Update(model);
}
public void Delete(EmployeeQualification enity)
{
_employeeQualificationRepository.Delete(enity);
}
public void Add(EmployeeQualification model)
{
_employeeQualificationRepository.Add(model);
}
public async Task <IActionResult> HireCandidate(Candidate item, int employmentTypeId, int?jobGradeId, int?salaryStepId, int?salaryScaleTypeId, int basicSalary = 0, string isHead = "false", bool isProbation = false)
{
var model = await _context.Candidates.SingleOrDefaultAsync(b => b.Id == item.Id);
Employee emp = new Employee();
emp.FirstName = model.FirstName;
emp.FatherName = model.FatherName;
emp.FamilyName = model.FamilyName;
emp.MotherName = model.MotherName;
emp.OthFirstName = model.OthFirstName;
emp.OthFatherName = model.OthFatherName;
emp.OthFamilyName = model.OthFamilyName;
emp.OthMotherName = model.OthMotherName;
emp.IsMale = model.IsMale;
emp.MaritalStatus = model.MaritalStatus;
emp.IsMilitaryExempted = model.IsMilitaryExempted;
emp.BirthDate = model.BirthDate;
emp.NationalityId = model.NationalityId;
emp.Phone = model.Phone;
emp.HomePhone1 = model.HomePhone1;
emp.HomePhone2 = model.HomePhone2;
emp.GovernorateId = model.GovernorateId;
emp.Address = model.Address;
emp.PermenantAddress = model.PermenantAddress;
emp.Email = model.Email;
emp.JoinDate = DateTime.Now.Date;
emp.AppForm = model.AppForm;
//CreateEmployee(emp, model.OrgUnitId, employmentTypeId, null, model.PositionId, jobGradeId, salaryStepId, salaryScaleTypeId, basicSalary, model.IsHead, isProbation);
//add qualifications
dynamic json = JsonConvert.DeserializeObject(model.AppForm);
foreach (var x in json.QualificationsList)
{
if (!string.IsNullOrEmpty(x.type.Value))
{
EmployeeQualification eq = new EmployeeQualification();
eq.EmployeeId = emp.Id;
eq.QualificationTypeId = int.Parse(x.type.ToString());
eq.CompetencyAreaTypeId = int.Parse(x.competency.ToString());
eq.ObtainedDate = DateTime.Parse(x.obtainedDate.ToString());
eq.Name = x.name.ToString();
_context.EmployeeQualifications.Add(eq);
}
}
int othCompetencyAreaId = _lookup.GetLookupItems <CompetencyAreaType>().SingleOrDefault(b => b.SysCode == "OTHER").Id;
int domainCompetencyAreaId = _lookup.GetLookupItems <CompetencyAreaType>().SingleOrDefault(b => b.SysCode == "DOMAIN").Id;
foreach (var x in json.ExperiencesList)
{
if (!string.IsNullOrEmpty(x.type.Value))
{
EmployeeQualification eq = new EmployeeQualification();
eq.EmployeeId = emp.Id;
eq.QualificationTypeId = int.Parse(x.type.ToString());
string qualificationCode = _lookup.GetLookupItems <QualificationType>().SingleOrDefault(b => b.Id == eq.QualificationTypeId).SysCode;
if (qualificationCode == "OTHER_EXPERIENCE")
{
eq.CompetencyAreaTypeId = othCompetencyAreaId;
}
else
{
eq.CompetencyAreaTypeId = domainCompetencyAreaId;
}
eq.Name = x.details.ToString();
eq.TotalYears = int.Parse(x.totalYears.ToString());
_context.EmployeeQualifications.Add(eq);
}
}
//update candidate
//item.IsApproved = true;
//await _context.SaveChangesAsync();
return(RedirectToAction("CandidatesList"));
}
