public JsonResult GetTableData(DTwithlimit dt)
{
JsonResult result = null;
try
{
if (!string.IsNullOrWhiteSpace(dt.LookUpCategory))
{
var dataList = (from eType in LookUpCodeService.GetLookUp <LookUp>(et => et.LookUpCategory == dt.LookUpCategory)
select new
{
LookUpID = eType.LookUpID,
LookUpCode = eType.LookUpCode,
LookUpDescription = eType.LookUpDescription,
IsActive = eType.IsActive
}).Distinct();
var data = dataList.Select(x => new SortingViewModel()
{
employeeDescription = x.LookUpDescription,
employeeDesignation = x.LookUpCode,
IsActive = x.IsActive,
LookUpID = x.LookUpID
}).AsQueryable();
int totalCount = dataList.Count();
dt.sortType = dt.sortType ?? "asc";
dt.sortColumn = dt.sortColumn ?? "employeeDescription";
if (dt.sortType.ToLower() == "asc")
{
data = OrderBy(data, dt.sortColumn, false, false);
}
else
{
data = OrderBy(data, dt.sortColumn, true, false);
}
var lookups = data.Skip(dt.offset).Take(dt.limit).AsQueryable();
if (lookups.Any() && lookups != null)
{
result = Json(new { success = true, lookUpLists = lookups, total_count = totalCount, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet);
}
else
{
result = Json(new { success = false, message = C.NO_DATA_FOUND }, JsonRequestBehavior.AllowGet);
}
}
else
{
result = Json(new { success = false, message = C.NO_DATA_FOUND }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
private void PrepareEmployeeDocuments(HttpFileCollection hfc, EmployeeHeader employeeHeader, List <EmployeeDocument> employeeDocuments, List <EmployeeDocumentViewModel> employeeDocumentViewModel)
{
for (var i = 0; i < hfc.Count; i++)
{
HttpPostedFile httpPostedFileBase = hfc[i];
foreach (var item in employeeDocumentViewModel)
{
if (item.Name == httpPostedFileBase.FileName)
{
EmployeeDocument employeeDocument = new EmployeeDocument();
LookUp lookUp = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCode == item.DocumentType).FirstOrDefault();
bool employeeHeaders = employeeHeader.EmployeeDocument != null?employeeHeader.EmployeeDocument.Any(e => e.DocumentType == lookUp.LookUpID && e.FileName == item.Name) : false;
if (!employeeHeaders)
{
employeeDocument.CreatedBy = USER_OBJECT.UserID;
employeeDocument.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
employeeDocument.FileName = httpPostedFileBase.FileName;
employeeDocument.BranchId = USER_OBJECT.BranchId;
employeeDocument.DocumentType = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCode == item.DocumentType).Select(s => s.LookUpID).FirstOrDefault();;
// employeeDocuments.Add(employeeDocument);
SaveFile(httpPostedFileBase);
employeeHeader.EmployeeDocument = employeeHeader.EmployeeDocument == null ? new List <EmployeeDocument>() : employeeHeader.EmployeeDocument;
employeeHeader.EmployeeDocument.Add(employeeDocument);
}
}
}
}
}
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 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 GetGrantLeaves()
{
JsonResult result = null;
try
{
List <LeaveHeader> leaveHeaders = GrantLeaveService.GetAll <LeaveHeader>().ToList();
List <LeaveHeaderViewModel> LeaveHeaderVMList = new List <LeaveHeaderViewModel>();
List <LookUp> LeaveTypeLookUp = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpCategory == "LeaveType").ToList();
foreach (LeaveHeader leaveHeader in leaveHeaders)
{
LeaveHeaderViewModel LeaveHeaderVM = new LeaveHeaderViewModel()
{
Id = leaveHeader.Id,
BranchId = leaveHeader.BranchID,
LeaveSchemeType = leaveHeader.LeaveSchemeType,
LeaveSchemeTypeDescription = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == leaveHeader.LeaveSchemeType).Select(s => s.LookUpCode).FirstOrDefault(),
LeaveYear = leaveHeader.LeaveYear,
LeaveYearType = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == leaveHeader.LeaveYear).Select(l => l.LookUpCode).FirstOrDefault(),
PeriodicityType = leaveHeader.PeriodicityType,
PeriodicityTypeDescription = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == leaveHeader.PeriodicityType).Select(l => l.LookUpCode).FirstOrDefault(),
PeriodType = leaveHeader.PeriodType,
PeriodTypeDescription = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == leaveHeader.PeriodType).Select(l => l.LookUpCode).FirstOrDefault(),
};
PrepareleavedetailsViewModel(leaveHeader, LeaveHeaderVM, LeaveTypeLookUp);
LeaveHeaderVMList.Add(LeaveHeaderVM);
}
result = Json(new { sucess = true, LeaveHeaderVMList = LeaveHeaderVMList }, 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 ActionResult GetEmployeeList(string employeeName)
{
JsonResult jsonResult = new JsonResult();
if (!string.IsNullOrWhiteSpace(employeeName))
{
try
{
var employeeDepartment = LookUpCodeService.GetLookUp <LookUp>(s => s.LookUpCategory == "EmployeeDesignation" && s.LookUpCode.Contains(employeeName)).Select(x => new
{
name = x.LookUpCode,
description = x.LookUpDescription,
id = x.LookUpID
}).ToList();
// var managerData = employeeDepartment
//var employees = (from employee in EmployeeProfileService.GetEmployeeProfileList<EmployeeHeader>(e => e.FirstName.ToLower().
// Contains(employeeName.ToLower())
// && (e.EmployeeWorkDetail.Any() && e.EmployeeWorkDetail.FirstOrDefault().DepartmentId == employeeDepartment.LookUpID )
// && e.BranchId == USER_OBJECT.BranchId)
// select new
// {
// Id = employee.Id,
// Name = employee.FirstName + " " + employee.MiddleName + " " + employee.LastName
// }).ToList();
jsonResult = Json(new { sucess = true, employees = employeeDepartment }, 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);
}
public JsonResult SaveLookUp(LookUp lookUpViewModel)
{
JsonResult result = null;
try
{
if (lookUpViewModel != null)
{
LookUp lookUp = LookUpCodeService.GetLookUp <LookUp>(l => l.LookUpID == lookUpViewModel.LookUpID).FirstOrDefault();
if (lookUp != null)
{
lookUp.ModifiedBy = USER_OBJECT.UserID;
lookUp.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
else
{
lookUp = new LookUp();
lookUp.CreatedBy = USER_OBJECT.UserID;
lookUp.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
lookUp.ModifiedOn = null;
}
lookUp.LookUpCode = lookUpViewModel.LookUpCode;
lookUp.LookUpDescription = lookUpViewModel.LookUpDescription;
lookUp.IsActive = lookUpViewModel.IsActive;
lookUp.LookUpCategory = lookUpViewModel.LookUpCategory;
LookUpCodeService.Save(lookUp);
result = Json(new { success = true, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
result = Json(new { success = true, message = ex.Message }, JsonRequestBehavior.AllowGet);
}
return(result);
}
public JsonResult GetActiveLookUp(string LookUpCategory)
{
JsonResult result = null;
try
{
if (!string.IsNullOrWhiteSpace(LookUpCategory))
{
var lookUp = from eType in LookUpCodeService.GetLookUp <LookUp>(et => et.LookUpCategory == LookUpCategory && et.IsActive == true)
select new
{
LookUpID = eType.LookUpID,
LookUpCode = eType.LookUpCode,
LookUpDescription = eType.LookUpDescription,
IsActive = eType.IsActive
};
if (lookUp.Any() && lookUp != null)
{
result = Json(new { success = true, lookUpLists = lookUp, message = C.SUCCESSFUL_SAVE_MESSAGE }, JsonRequestBehavior.AllowGet);
}
else
{
result = Json(new { success = false, message = C.NO_DATA_FOUND }, JsonRequestBehavior.AllowGet);
}
}
else
{
result = Json(new { success = false, message = C.NO_DATA_FOUND }, JsonRequestBehavior.AllowGet);
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
