public JsonResult SaveEmployeeLeaveForm(EmployeeLeaveList employeeLeaveList)
{
JsonResult result = new JsonResult();
if (employeeLeaveList != null)
{
try
{
EmployeeLeaveList _employeeLeaveList = new EmployeeLeaveList();
if (employeeLeaveList.Id > 0)
{
_employeeLeaveList = Leaveservice.GetLeaveListById(employeeLeaveList.Id);
_employeeLeaveList.ModifiedBy = USER_OBJECT.UserName;
_employeeLeaveList.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
else
{
_employeeLeaveList.CreatedBy = USER_OBJECT.UserName;
_employeeLeaveList.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
_employeeLeaveList.ApplyDate = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
EmployeeHeader employeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(e => e.Id == employeeLeaveList.EmployeeId).FirstOrDefault();
_employeeLeaveList.EmployeeId = employeeHeader.Id;
_employeeLeaveList.FromDate = employeeLeaveList.FromDate;
_employeeLeaveList.ToDate = employeeLeaveList.ToDate;
_employeeLeaveList.Days = employeeLeaveList.Days;
_employeeLeaveList.Reason = employeeLeaveList.Reason;
_employeeLeaveList.Remarks = employeeLeaveList.Remarks;
_employeeLeaveList.LeaveTypeId = employeeLeaveList.LeaveTypeId;
_employeeLeaveList.Status = employeeLeaveList.Status;
_employeeLeaveList.ManagerId = employeeHeader.ManagerId.HasValue ? employeeHeader.ManagerId.Value : 0;
Leaveservice.SaveLeaveList(_employeeLeaveList);
result = Json(new { sucess = true, message = "Sent successfully" }, 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));
}
}
}
else
{
result = Json(new { sucess = false, message = "No Data Found" }, JsonRequestBehavior.AllowGet);
}
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 SaveEmployeeDocuments()
{
var employeeId = Convert.ToInt16(System.Web.HttpContext.Current.Request["employeeId"]);
HttpFileCollection hfc = System.Web.HttpContext.Current.Request.Files;
JsonResult result = null;
try
{
EmployeeDocument employeeDocument = null;
HttpPostedFile file = hfc[0];
employeeDocument = EmployeeProfileService.GetEmployeeDocuments <EmployeeDocument>(ed => ed.EmployeeHeaderId == employeeId).FirstOrDefault();
//EmployeeHeader employeeHeader = EmployeeProfileService.GetEmployeeDocuments(Convert.ToInt16(employeeId));
if (employeeDocument != null)
{
employeeDocument.ModifiedBy = USER_OBJECT.UserID;
employeeDocument.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
else
{
employeeDocument = new EmployeeDocument();
employeeDocument.CreatedBy = USER_OBJECT.UserID;
employeeDocument.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
EmployeeHeader EmployeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>(s => s.Id == employeeId).FirstOrDefault();
employeeDocument.FileName = System.IO.Path.GetFileName(file.FileName);
employeeDocument.BranchId = USER_OBJECT.BranchId;
employeeDocument.EmployeeHeaderId = Convert.ToInt32(employeeId);
employeeDocument.DocumentType = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCode == "ProfilePic").Select(s => s.LookUpID).FirstOrDefault();
SaveFile(file);
EmployeeHeader.EmployeeDocument.Add(employeeDocument);
if (employeeDocument != null)
{
EmployeeProfileService.SaveEmployeeDocuments(employeeDocument);
}
}
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 GetRegionWiseEmployees()
{
JsonResult result = null;
try
{
List <EmployeeHeader> EmployeeHeader = EmployeeProfileService.GetEmployeeProfileList <EmployeeHeader>().ToList();
var regionWiseEmployees = EmployeeHeader.GroupBy(g => g.Branch.BranchName).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key
}).OrderByDescending(o => o.y);
//var designationWiseEmployees = EmployeeHeader.Select(g => g.EmployeeWorkDetail).GroupBy(g => g.Select(s => s.DesignationId.Value).FirstOrDefault()).ToList()
// .Select(n => new
// {
// y = n.Count(),
// name = n.Key > 0? LookUpCodeService.GetLookUpType(n.Key).LookUpCode:string.Empty
// });
var genderWiseEmployees = EmployeeHeader.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender).FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
});
//var genderWiseEmployees = EmployeeHeader.
// GroupBy(g => g.Branch.BranchName).ToList()
// .Select(n => new
// {
// y= n.Count(),
// name = n.Key,
// male = n.Where(s => s.EmployeePersonalInfo.FirstOrDefault().Gender == 0).Count(),
// female = n.Where(s => s.EmployeePersonalInfo.FirstOrDefault().Gender == 1).Count()
// }).OrderByDescending(o=>o.y);
var indiawiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "INDIA")
.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender)
.FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
}).OrderByDescending(n => n.name);
var singaporewiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "SINGAPORE")
.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender)
.FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
}).OrderByDescending(n => n.name);
var hongkongwiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "HONGKONG")
.GroupBy(x => x.EmployeePersonalInfo.Select(s => s.Gender)
.FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
}).OrderByDescending(n => n.name);
var mayanmarwiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "MAYANMAR")
.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender)
.FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
}).OrderByDescending(n => n.name);
var pakistanwiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "PAKISTAN")
.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender)
.FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
}).OrderByDescending(n => n.name);
var srilankawiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "SRILANKA")
.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender)
.FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
}).OrderByDescending(n => n.name);
var cambodiawiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "CAMBODIA")
.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender)
.FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
}).OrderByDescending(n => n.name);
var bangladeshwiseGenders = EmployeeHeader.Where(s => s.Branch.BranchName == "BANGLADESH")
.GroupBy(g => g.EmployeePersonalInfo.Select(s => s.Gender)
.FirstOrDefault()).ToList()
.Select(n => new
{
y = n.Count(),
name = n.Key == 0 ? "Male" : n.Key == 1 ? "Female" : ""
}).OrderByDescending(n => n.name);
//var countryWiseGender = EmployeeHeader.GroupBy(g => g.Address.CountryCode && g.EmployeePersonalInfo.Gender).ToList();
result = Json(new
{
sucess = true,
regionWiseEmployees = regionWiseEmployees,
genderWiseEmployees = genderWiseEmployees,
indiawiseGenders = indiawiseGenders,
bangladeshwiseGenders = bangladeshwiseGenders,
cambodiawiseGenders = cambodiawiseGenders,
srilankawiseGenders = srilankawiseGenders,
pakistanwiseGenders = pakistanwiseGenders,
mayanmarwiseGenders = mayanmarwiseGenders,
hongkongwiseGenders = hongkongwiseGenders,
singaporewiseGenders = singaporewiseGenders
}, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
result = Json(new { sucess = false, message = ex.Message }, JsonRequestBehavior.AllowGet);
}
return(result);
}
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);
}
