public JsonResult InsertEmployeLeaveHistory(EmployeeLeaveHistory LeaveStory)
{
int leaveHistories = db.EmployeeLeaveHistories.Count();
try
{
LeaveStory.Status = AppUtils.TableStatusIsActive;
db.EmployeeLeaveHistories.Add(LeaveStory);
db.SaveChanges();
EmployeeLeaveViewModel LeaveHistoryInfo = new EmployeeLeaveViewModel
{
ID = LeaveStory.EmployeeLeaveHistoryID,
LoginName = db.Employee.Find(LeaveStory.EmployeeID).LoginName,
Reason = LeaveStory.Reason,
StartDate = LeaveStory.EndDate,
EndDate = LeaveStory.EndDate,
LeaveTypeName = db.LeaveSallaryTypes.Find(LeaveStory.LeaveType).LeaveTypeName,
};
return(Json(new { SuccessInsert = true, LeaveHistoryInfo = LeaveHistoryInfo, leaveHistories = leaveHistories }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { SuccessInsert = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateLeaveHistoryType(EmployeeLeaveHistory LeaveHistoryIformation)
{
try
{
var leaveHistory = db.EmployeeLeaveHistories.Where(s => s.EmployeeLeaveHistoryID == LeaveHistoryIformation.EmployeeLeaveHistoryID);
LeaveHistoryIformation.Status = AppUtils.TableStatusIsActive;
db.Entry(leaveHistory.SingleOrDefault()).CurrentValues.SetValues(LeaveHistoryIformation);
db.SaveChanges();
var LeaveHistory =
new EmployeeLeaveViewModel()
{
ID = LeaveHistoryIformation.EmployeeLeaveHistoryID,
Reason = LeaveHistoryIformation.Reason,
LeaveTypeName = db.LeaveSallaryTypes.Find(LeaveHistoryIformation.LeaveType).LeaveTypeName,
StartDate = LeaveHistoryIformation.StartDate,
EndDate = LeaveHistoryIformation.EndDate,
LoginName = db.Employee.Find(LeaveHistoryIformation.EmployeeID).LoginName,
};
var JSON = Json(new { UpdateSuccess = true, EMPLH = LeaveHistory }, JsonRequestBehavior.AllowGet);
JSON.MaxJsonLength = int.MaxValue;
return(JSON);
}
catch
{
return(Json(new { UpdateSuccess = false, EMPLH = "" }, JsonRequestBehavior.AllowGet));
}
}
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);
}
