public async Task <ActionResult> GetLeaveReportDetails(int year)
{
if (null != Session[Constants.SESSION_OBJ_USER])
{
var data = (UserAccount)Session[Constants.SESSION_OBJ_USER];
LeaveReportModel datares = await user.GetLeaveReportDetails(data.RefEmployeeId, year);
// model.Announcements = (Models.Announcement)datares.Announcements;
return(Json(new { result = datares }));
}
return(View("Login"));
}
public LeaveReportModel GetLeaveReportDetails(int employeeId, int year)
{
try
{
var leaveReport = new LeaveReportModel();
using (var ctx = new LeaveManagementSystemEntities1())
{
var years = ctx.EmployeeLeaveTransactions.Where(i => i.RefEmployeeId == employeeId && i.FromDate.Year == year && i.ToDate.Year == year).ToList();
foreach (var item in years)
{
for (DateTime date = item.FromDate; date <= item.ToDate; date = date.AddDays(1))
{
if (date.DayOfWeek != DayOfWeek.Saturday && date.DayOfWeek != DayOfWeek.Sunday)
{
switch (date.Month)
{
case 1:
leaveReport.Jan++;
break;
case 2:
leaveReport.Feb++;
break;
case 3:
leaveReport.Mar++;
break;
case 4:
leaveReport.Apr++;
break;
case 5:
leaveReport.May++;
break;
case 6:
leaveReport.Jun++;
break;
case 7:
leaveReport.Jul++;
break;
case 8:
leaveReport.Aug++;
break;
case 9:
leaveReport.Sep++;
break;
case 10:
leaveReport.Oct++;
break;
case 11:
leaveReport.Nov++;
break;
case 12:
leaveReport.Dec++;
break;
}
}
}
}
//var Year = new SqlParameter("@Year", 2016);
//var data= ctx.Database.SqlQuery<LeaveReportModel>("dbo.GetLeaveReportProcedure @Year", Year).ToList();
return(leaveReport);
}
}
catch (Exception ex)
{
throw ex;
}
}
