public JsonResult GetEmployeesQualifications()
{
var data = new EmployeesQualificationsBLL().GetEmployeesQualifications()
.Select(x => new
{
EmployeeQualificationID = x.EmployeeQualificationID,
QualificationDegree = x.QualificationDegree != null ? x.QualificationDegree.QualificationDegreeName : null,
Qualification = x.Qualification != null ? x.Qualification.QualificationName : null,
GeneralSpecialization = x.GeneralSpecialization != null ? x.GeneralSpecialization.GeneralSpecializationName : null,
ExactSpecialization = x.ExactSpecialization != null ? x.ExactSpecialization.ExactSpecializationName : null,
UniSchName = x.UniSchName,
FullGPA = x.FullGPA,
Department = x.Department,
GPA = x.GPA,
StudyPlace = x.StudyPlace,
GraduationDate = x.GraduationDate != null ? Globals.Calendar.GetUmAlQuraDate(x.GraduationDate.Value) : null,
GraduationYear = x.GraduationYear,
QualificationType = x.QualificationType != null ? x.QualificationType.QualificationTypeName : null,
CreatedDate = Globals.Calendar.GetUmAlQuraDate(x.CreatedDate),
EmployeeCodeNo = x.EmployeeCode.EmployeeCodeNo,
EmployeeNameAr = x.EmployeeCode.Employee.EmployeeNameAr,
});
return(Json(new { data }, JsonRequestBehavior.AllowGet));
}
public JsonResult Delete(int id)
{
EmployeesQualificationsBLL EmployeeQualification = new EmployeesQualificationsBLL();
EmployeeQualification.LoginIdentity = UserIdentity;
Result result = EmployeeQualification.Remove(id);
if (result.EnumMember == EmployeesQualificationsValidationEnum.Done.ToString())
{
}
return(Json(new
{
data = EmployeeQualification
}, JsonRequestBehavior.AllowGet));
}
public JsonResult GetEmployeesQualificationsAsRanksCategories(int QualificationDegreeID, int QualificationID, int GeneralSpecializationID, int OrganizationID)
{
IQueryable <EmployeesQualificationBasedOnAssigngingsDTO> Qualifications;
Qualifications = new EmployeesQualificationsBLL().GetQualificationsBasedOnAssigningsAsRanksCategoriesDetails(QualificationDegreeID, QualificationID, GeneralSpecializationID, OrganizationID);
Session["EmployeesQualificationsDetails"] = Qualifications;
var QualificationsByRanksCategories = Qualifications
.GroupBy(x => x.RankCategoryName)
.Select(y => new
{
KeyName = y.Key,
Value = y.Count()
});
return(Json(new { data = QualificationsByRanksCategories }, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(EmployeesQualificationsViewModel EmployeeQualificationVM)
{
EmployeesQualificationsBLL EmployeeQualification = new EmployeesQualificationsBLL();
EmployeeQualification.QualificationDegree = new QualificationsDegreesBLL()
{
QualificationDegreeID = EmployeeQualificationVM.QualificationDegreeID
};
EmployeeQualification.Qualification = new QualificationsBLL()
{
QualificationID = EmployeeQualificationVM.QualificationID
};
EmployeeQualification.GeneralSpecialization = new GeneralSpecializationsBLL()
{
GeneralSpecializationID = EmployeeQualificationVM.GeneralSpecializationID
};
EmployeeQualification.EmployeeCode = new EmployeesCodesBLL()
{
EmployeeCodeID = EmployeeQualificationVM.EmployeeVM.EmployeeCodeID.Value
};
EmployeeQualification.ExactSpecialization = new ExactSpecializationsBLL()
{
ExactSpecializationID = EmployeeQualificationVM.ExactSpecializationID
};
EmployeeQualification.UniSchName = EmployeeQualificationVM.UniSchName;
EmployeeQualification.Department = EmployeeQualificationVM.Department;
EmployeeQualification.FullGPA = EmployeeQualificationVM.FullGPA;
EmployeeQualification.GPA = EmployeeQualificationVM.GPA;
EmployeeQualification.StudyPlace = EmployeeQualificationVM.StudyPlace;
EmployeeQualification.GraduationDate = EmployeeQualificationVM.GraduationDate;
EmployeeQualification.GraduationYear = EmployeeQualificationVM.GraduationYear;
EmployeeQualification.QualificationType = new QualificationsTypesBLL()
{
QualificationTypeID = EmployeeQualificationVM.QualificationType.QualificationTypeID
};
EmployeeQualification.LoginIdentity = UserIdentity;
Result result = EmployeeQualification.Add();
if (result.EnumMember == EmployeesQualificationsValidationEnum.Done.ToString())
{
}
return(Json(new { data = EmployeeQualification.EmployeeQualificationID }, JsonRequestBehavior.AllowGet));
}
public ActionResult HiringNewEmployeePost(HiringNewEmployeesViewModel HiringNewEmployeesViewModel)
{
EmployeesBLL _employeeBll = new EmployeesBLL()
{
EmployeeIDNo = HiringNewEmployeesViewModel.EmployeeIDNo,
FirstNameAr = HiringNewEmployeesViewModel.FirstNameAr,
MiddleNameAr = HiringNewEmployeesViewModel.MiddleNameAr,
GrandFatherNameAr = HiringNewEmployeesViewModel.GrandFatherNameAr,
FifthNameAr = HiringNewEmployeesViewModel.FifthNameAr,
LastNameAr = HiringNewEmployeesViewModel.LastNameAr,
FirstNameEn = HiringNewEmployeesViewModel.FirstNameEn,
MiddleNameEn = HiringNewEmployeesViewModel.MiddleNameEn,
GrandFatherNameEn = HiringNewEmployeesViewModel.GrandFatherNameEn,
FifthNameEn = HiringNewEmployeesViewModel.FifthNameEn,
LastNameEn = HiringNewEmployeesViewModel.LastNameEn,
EmployeeBirthDate = HiringNewEmployeesViewModel.EmployeeBirthDate,
EmployeeBirthPlace = HiringNewEmployeesViewModel.EmployeeBirthPlace,
EmployeeMobileNo = HiringNewEmployeesViewModel.EmployeeMobileNo,
EmployeePassportNo = HiringNewEmployeesViewModel.EmployeePassportNo,
EmployeeEMail = HiringNewEmployeesViewModel.EmployeeEMail,
EmployeeIDIssueDate = HiringNewEmployeesViewModel.EmployeeIDIssueDate,
EmployeePassportSource = HiringNewEmployeesViewModel.EmployeePassportSource,
EmployeePassportIssueDate = HiringNewEmployeesViewModel.EmployeePassportIssueDate,
EmployeePassportEndDate = HiringNewEmployeesViewModel.EmployeePassportEndDate,
EmployeeIDExpiryDate = HiringNewEmployeesViewModel.EmployeeIDExpiryDate,
EmployeeIDCopyNo = HiringNewEmployeesViewModel.EmployeeIDCopyNo,
EmployeeIDIssuePlace = HiringNewEmployeesViewModel.EmployeeIDIssuePlace,
DependentCount = HiringNewEmployeesViewModel.DependentCount,
MaritalStatus = new MaritalStatusBLL()
{
MaritalStatusID = HiringNewEmployeesViewModel.MaritalStatus.MaritalStatusID
},
Gender = new GendersBLL()
{
GenderID = HiringNewEmployeesViewModel.Gender.GenderID
},
Nationality = new CountriesBLL {
CountryID = HiringNewEmployeesViewModel.CountryID
},
LoginIdentity = UserIdentity
};
EmployeesCodesBLL _employeesCode = new EmployeesCodesBLL();
_employeesCode.EmployeeCodeNo = HiringNewEmployeesViewModel.EmployeeCodeNo;
_employeesCode.Employee = new EmployeesBLL()
{
EmployeeID = HiringNewEmployeesViewModel.EmployeeID
};
_employeesCode.EmployeeType = new EmployeesTypesBLL()
{
EmployeeTypeID = 1
};
_employeesCode.LoginIdentity = this.UserIdentity;
EmployeesCareersHistoryBLL _employeesCareersHistory = new EmployeesCareersHistoryBLL()
{
JoinDate = HiringNewEmployeesViewModel.JoinDate,
OrganizationJob = new OrganizationsJobsBLL()
{
OrganizationJobID = HiringNewEmployeesViewModel.OrganizationJobID
},
CareerDegree = new CareersDegreesBLL()
{
CareerDegreeID = HiringNewEmployeesViewModel.CareerDegreeID
},
CareerHistoryType = new CareersHistoryTypesBLL()
{
CareerHistoryTypeID = HiringNewEmployeesViewModel.CareerHistoryTypeID
},
};
EmployeesQualificationsBLL _employeeQualification = new EmployeesQualificationsBLL();
_employeeQualification.QualificationDegree = new QualificationsDegreesBLL()
{
QualificationDegreeID = HiringNewEmployeesViewModel.QualificationDegreeID
};
_employeeQualification.Qualification = new QualificationsBLL()
{
QualificationID = HiringNewEmployeesViewModel.QualificationID
};
_employeeQualification.GeneralSpecialization = new GeneralSpecializationsBLL()
{
GeneralSpecializationID = HiringNewEmployeesViewModel.GeneralSpecializationID
};
_employeeQualification.ExactSpecialization = new ExactSpecializationsBLL()
{
ExactSpecializationID = HiringNewEmployeesViewModel.ExactSpecializationID.HasValue ? (int)HiringNewEmployeesViewModel.ExactSpecializationID : 0
};
_employeeQualification.UniSchName = HiringNewEmployeesViewModel.UniSchName;
_employeeQualification.Department = HiringNewEmployeesViewModel.Department;
_employeeQualification.FullGPA = HiringNewEmployeesViewModel.FullGPA;
_employeeQualification.GPA = HiringNewEmployeesViewModel.GPA;
_employeeQualification.StudyPlace = HiringNewEmployeesViewModel.StudyPlace;
_employeeQualification.GraduationDate = HiringNewEmployeesViewModel.GraduationDate;
_employeeQualification.GraduationYear = HiringNewEmployeesViewModel.GraduationYear;
_employeeQualification.QualificationType = new QualificationsTypesBLL()
{
QualificationTypeID = HiringNewEmployeesViewModel.QualificationTypeID
};
_employeeQualification.LoginIdentity = UserIdentity;
ContractorsBasicSalariesBLL _contractorBasicSalaryBLL = new ContractorsBasicSalariesBLL();
_contractorBasicSalaryBLL.BasicSalary = HiringNewEmployeesViewModel.BasicSalary;
_contractorBasicSalaryBLL.TransfareAllowance = HiringNewEmployeesViewModel.TransfareAllowance;
_contractorBasicSalaryBLL.LoginIdentity = UserIdentity;
List <EmployeesAllowancesBLL> _employeesAllowancesBLL = new List <EmployeesAllowancesBLL>();
foreach (var item in HiringNewEmployeesViewModel.Allowances)
{
if (item.IsSelected)
{
_employeesAllowancesBLL.Add(new EmployeesAllowancesBLL()
{
EmployeeCareerHistory = _employeesCareersHistory, Allowance = item, AllowanceStartDate = DateTime.Now, IsActive = true, LoginIdentity = UserIdentity
});
}
}
_employeeBll.AddHiringNewEmployee(_employeeBll, _employeesCode, _employeesCareersHistory, _employeeQualification, _contractorBasicSalaryBLL, _employeesAllowancesBLL);
//return View("Employees/Index");
return(Json(new { ID = 0 }, JsonRequestBehavior.AllowGet));
}
