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 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 GetGrantLeave(int Id)
{
JsonResult result = null;
try
{
if (Id > 0)
{
LeaveHeader leaveHeader = GrantLeaveService.Get(Id);
result = Json(new { sucess = true, leaveHeader = leaveHeader }, 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 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);
}
