public JsonResult GetLeaveStatus()
{
JsonResult result = null;
try
{
EmployeeLeaveDetails employeeLeaveDetails = new EmployeeLeaveDetails();
employeeLeaveDetails.AppliedStatusCount = Leaveservice.GetLeaveList <EmployeeLeaveList>(s => s.Status == "Applied" && s.BranchId == USER_OBJECT.BranchId && s.EmployeeId == USER_OBJECT.EmployeeId).Count();
var GrantedLeavesList = Leaveservice.GetLeaveList <EmployeeLeaveList>
(s => s.EmployeeId == USER_OBJECT.EmployeeId && s.BranchId == USER_OBJECT.BranchId)
.GroupBy(g => g.LeaveTypeId).ToList().Select(s => new
{
count = s.Count(),
name = LookUpCodeService.GetLookUpType(s.Key).LookUpCode
});
employeeLeaveDetails.GrantedLeaves = Leaveservice.GetLeaveList <EmployeeLeaveList>(s => s.Status == "Grant" && s.BranchId == USER_OBJECT.BranchId && s.EmployeeId == USER_OBJECT.EmployeeId).Count();
List <LeaveHeader> LeaveHeaders = GrantLeaveService.GetAll <LeaveHeader>(l => l.BranchID == USER_OBJECT.BranchId).ToList();
var TotalLeaves = LeaveHeaders.Select(l => l.LeaveDetail.Sum(s => s.TotalLeaves)).Count();
employeeLeaveDetails.RemaingStatusCount = Math.Abs(employeeLeaveDetails.GrantedLeaves - TotalLeaves);
result = Json(new { employeeLeaveDetails = employeeLeaveDetails, GrantedLeavesList = GrantedLeavesList }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
return(Json(new { success = false, message = ex.InnerException.Message }, JsonRequestBehavior.DenyGet));
}
}
return(result);
}
public JsonResult GetAppliedLeaveList()
{
JsonResult result = null;
try
{
LookUp employeeDepartment = LookUpCodeService.GetLookUp <LookUp>(s => s.LookUpCategory == "EmployeeDesignation" && s.LookUpCode == "Manager").FirstOrDefault();
EmployeeHeader employeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(e => e.Id == USER_OBJECT.EmployeeId && e.EmployeeWorkDetail.FirstOrDefault().DesignationId == employeeDepartment.LookUpID).FirstOrDefault();
List <EmployeeLeaveList> employeeLeaveList = Leaveservice.GetLeaveList <EmployeeLeaveList>(e => e.ManagerId == employeeHeader.Id).OrderBy(o => o.EmployeeId).ToList();
List <EmployeeLeaveViewModel> employeeLeaveViewModelList = new List <EmployeeLeaveViewModel>();
foreach (EmployeeLeaveList employeeLeave in employeeLeaveList)
{
LookUp leaveType = LookUpCodeService.GetLookUpType(employeeLeave.LeaveTypeId);
EmployeeLeaveViewModel employeeLeaveViewModel = new EmployeeLeaveViewModel();
employeeLeaveViewModel.Id = employeeLeave.Id;
employeeLeaveViewModel.EmployeeName = employeeLeave.Employee.FirstName + " " + employeeLeave.Employee.LastName;
employeeLeaveViewModel.EmployeeId = employeeLeave.Employee.Id;
employeeLeaveViewModel.EmployeeNumber = employeeLeave.Employee.IDNumber;
employeeLeaveViewModel.LeaveType = leaveType.LookUpCode;
employeeLeaveViewModel.LeaveTypeId = leaveType.LookUpID;
employeeLeaveViewModel.FromDate = employeeLeave.FromDate;
employeeLeaveViewModel.Days = employeeLeave.Days;
employeeLeaveViewModel.ToDate = employeeLeave.ToDate;
employeeLeaveViewModel.ApplyDate = employeeLeave.ApplyDate;
employeeLeaveViewModel.Status = employeeLeave.Status;
employeeLeaveViewModel.Reason = employeeLeave.Reason;
employeeLeaveViewModel.Remarks = employeeLeave.Remarks;
employeeLeaveViewModel.BranchId = employeeLeave.BranchId;
employeeLeaveViewModel.TeamLeadId = employeeLeave.ManagerId;
employeeLeaveViewModelList.Add(employeeLeaveViewModel);
}
if (employeeLeaveViewModelList != null && employeeLeaveViewModelList.Any())
{
result = Json(new { employeeLeaveList = employeeLeaveViewModelList, sucess = true }, JsonRequestBehavior.AllowGet);
}
else
{
result = Json(new { sucess = false, message = "No Data Found." }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
return(Json(new { success = false, message = ex.InnerException.Message }, JsonRequestBehavior.DenyGet));
}
}
return(result);
}
public JsonResult GetEmployeeById(int employeeId, bool IsfromIndividualEmployee)
{
JsonResult result = null;
try
{
EmployeeHeader employeeHeader = null;
string imagePathName = string.Empty;
LookUpDescriptions lookUpDescriptions = null;
if (!IsfromIndividualEmployee)
{
employeeHeader = EmployeeProfileService.GetEmployeeProfileDetailsById(employeeId);
}
else if (employeeId == 0)
{
employeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(e => e.UserId == USER_OBJECT.Id).FirstOrDefault();
EmployeeDocument employeeDocument = EmployeeProfileService.GetEmployeeDocuments <EmployeeDocument>(ed => ed.EmployeeHeaderId == employeeHeader.Id).FirstOrDefault();
if (employeeDocument != null)
{
imagePathName = employeeDocument.FileName;
}
lookUpDescriptions = new LookUpDescriptions();
foreach (var employeePersonalInfo in employeeHeader.EmployeePersonalInfo)
{
lookUpDescriptions.MarriedStatus = LookUpCodeService.GetLookUpType(employeePersonalInfo.MaritalStatus).LookUpCode;
}
foreach (var employeeWorkDetail in employeeHeader.EmployeeWorkDetail)
{
lookUpDescriptions.Designation = LookUpCodeService.GetLookUpType(employeeWorkDetail.DesignationId.Value).LookUpCode;
lookUpDescriptions.Department = LookUpCodeService.GetLookUpType(employeeWorkDetail.DepartmentId.Value).LookUpCode;
}
lookUpDescriptions.Country = CompanyService.GetCountries <Country>(c => c.CountryCode == employeeHeader.Address.FirstOrDefault().CountryCode).FirstOrDefault().CountryName;
lookUpDescriptions.Nationality = CompanyService.GetCountries <Country>(c => c.CountryCode == employeeHeader.Nationality).FirstOrDefault().CountryName;
}
List <EmployeeDocument> employeeDocuments = EmployeeProfileService.GetEmployeeDocuments <EmployeeDocument>(e => e.EmployeeHeaderId == employeeHeader.Id).ToList();
employeeHeader.EmployeeDocument = employeeDocuments != null ? employeeDocuments : null;
result = Json(new { employeeHeader = employeeHeader, imagePathName = imagePathName, LookUpDescriptions = lookUpDescriptions }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
return(Json(new { success = false, message = ex.InnerException.Message }, JsonRequestBehavior.DenyGet));
}
}
return(result);
}
public JsonResult SaveGrantLeaves(LeaveHeader LeaveHeader)
{
JsonResult jsonResult = new JsonResult();
if (LeaveHeader != null)
{
LeaveHeader _LeaveHeader = null;
if (LeaveHeader.Id > 0)
{
_LeaveHeader = GrantLeaveService.Get(LeaveHeader.Id);
_LeaveHeader.ModifiedOn = Core.Utilities.DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
_LeaveHeader.ModifiedBy = USER_OBJECT.UserName;
}
else
{
_LeaveHeader = new LeaveHeader();
_LeaveHeader.CreatedBy = USER_OBJECT.UserName;
_LeaveHeader.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
_LeaveHeader.BranchID = LeaveHeader.BranchID;
}
_LeaveHeader.LeaveYear = LeaveHeader.LeaveYear;
string leaveYear = LeaveHeader.LeaveYear > 0 ? LookUpCodeService.GetLookUpType(LeaveHeader.LeaveYear).LookUpCode : "";
_LeaveHeader.PeriodicityType = LeaveHeader.PeriodicityType;
_LeaveHeader.PeriodType = LeaveHeader.PeriodType;
_LeaveHeader.StartDate = (LeaveHeader.PeriodType != 0 && LeaveHeader.PeriodType == 1108) ?
DateTimeConverter.SingaporeDateTimeConversion(LeaveHeader.StartDate = new DateTime(Convert.ToInt32(leaveYear), 1, 01)) :
DateTimeConverter.SingaporeDateTimeConversion(LeaveHeader.StartDate = new DateTime(Convert.ToInt32(leaveYear), 07, 01));
if (LeaveHeader.EndDate != null)
{
_LeaveHeader.EndDate = (LeaveHeader.PeriodType != 0 && LeaveHeader.PeriodType == 1108) ?
DateTimeConverter.SingaporeDateTimeConversion(LeaveHeader.EndDate = new DateTime(Convert.ToInt32(leaveYear), 06, 01)) :
DateTimeConverter.SingaporeDateTimeConversion(LeaveHeader.StartDate = new DateTime(Convert.ToInt32(leaveYear), 12, 01));
}
Prepareleavedetails(LeaveHeader, _LeaveHeader);
_LeaveHeader.LeaveSchemeType = LeaveHeader.LeaveSchemeType;
GrantLeaveService.Save(_LeaveHeader);
}
return(jsonResult = Json(new { sucess = true, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetEmployeeDetails(SearchViewModel searchViewModel)
{
JsonResult jsonResult = new JsonResult();
try
{
List <EmployeeHeader> employeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(e => e.Address.Select(s => s.CountryCode == USER_OBJECT.CountryCode).FirstOrDefault()).ToList();
List <EmployeeViewModel> employeeViewModelList = new List <EmployeeViewModel>();
foreach (var item in employeeHeader)
{
EmployeeViewModel employeeViewModel = new EmployeeViewModel();
employeeViewModel.Id = item.Id;
employeeViewModel.EmployeeName = string.Empty;
if (!string.IsNullOrEmpty(item.FirstName))
{
employeeViewModel.EmployeeName += item.FirstName;
}
if (!string.IsNullOrEmpty(item.MiddleName))
{
employeeViewModel.EmployeeName += " " + item.MiddleName;
}
if (!string.IsNullOrEmpty(item.LastName))
{
employeeViewModel.EmployeeName += " " + item.LastName;
}
foreach (var employeeWorkDetail in item.EmployeeWorkDetail)
{
employeeViewModel.JoiningDate = item.EmployeeWorkDetail != null ? employeeWorkDetail.JoiningDate.Value.Date : DateTime.Now.Date;
employeeViewModel.JoiningDate = employeeViewModel.JoiningDate.Date;
employeeViewModel.Designation = item.EmployeeWorkDetail != null && employeeWorkDetail.DesignationId.HasValue ? employeeWorkDetail.DesignationId.Value : 0;
employeeViewModel.DesignationName = item.EmployeeWorkDetail != null && employeeWorkDetail.DesignationId.HasValue ?
(LookUpCodeService.GetLookUpType(employeeWorkDetail.DesignationId.Value)).LookUpDescription : string.Empty;
}
foreach (var employeePersonalInfo in item.EmployeePersonalInfo)
{
employeeViewModel.DOB = Convert.ToDateTime(employeePersonalInfo.DOB);
}
foreach (var address in item.Address)
{
employeeViewModel.MobileNo = address.MobileNo;
employeeViewModel.Email = address.Email;
employeeViewModel.CountryCode = address.CountryCode;
}
employeeViewModel.EmployeeId = item.IDNumber;
employeeViewModel.EmployeeType = item.IDType;
employeeViewModelList.Add(employeeViewModel);
}
var employees = employeeViewModelList.AsQueryable();
int totalCount = employees.Count();
if (searchViewModel.FilterViewModel != null)
{
foreach (FilterViewModel item in searchViewModel.FilterViewModel)
{
employees = ApplyWhere(item, employees);
}
}
if (!string.IsNullOrWhiteSpace(searchViewModel.sortType))
{
if (searchViewModel.sortType.ToLower() == "asc")
{
employees = OrderBy(employees, searchViewModel.sortColumn, false, false);
}
else
{
employees = OrderBy(employees, searchViewModel.sortColumn, true, false);
}
}
employees = employees.Skip(searchViewModel.offset).Take(searchViewModel.limit).AsQueryable();
if (searchViewModel.FilterViewModel == null)
{
jsonResult = Json(new { sucess = true, employees = employees, total_count = totalCount }, JsonRequestBehavior.AllowGet);
}
else
{
jsonResult = Json(new { sucess = true, employees = employees, total_count = employees.Count() }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
return(Json(new { success = false, message = ex.InnerException.Message }, JsonRequestBehavior.DenyGet));
}
}
return(jsonResult);
}
