public ActionResult NoOfLateReportRpt()
{
DaywiseLeaveQueryModel mdl = new DaywiseLeaveQueryModel();
ViewBag.RequestLevelPerson = "Admin";
mdl.OnlyReportedToMe = true;
mdl.DonotShowRejected = true;
return(View("NoOfLateReportRpt", mdl));
}
public ActionResult TeamDaywiseLeaves()
{
DaywiseLeaveQueryModel mdl = new DaywiseLeaveQueryModel();
ViewBag.RequestLevelPerson = "Team";
mdl.OnlyReportedToMe = true;
mdl.DonotShowRejected = true;
return(View("DaywiseLeaveDateRangeView", mdl));
}
public ActionResult ExportToExcel(DaywiseLeaveQueryModel data, string RequestLevelPerson)
{
IList <DaywiseLeaveDtlModel> LeaveRequests = null;
string startDate = data.DateRange.Substring(0, 10);
string endDate = data.DateRange.Substring(12);
DateTime?startDateFormatted = null;
DateTime?endDateFormatted = null;
if (startDate != "")
{
try
{
startDateFormatted = DateTime.Parse(startDate, new CultureInfo("en-GB", true));
endDateFormatted = DateTime.Parse(endDate, new CultureInfo("en-GB", true));
}
catch (Exception)
{
throw;
}
}
using (var client = new LeaveClient())
{
LeaveRequests = client.GetDaywiseLeaveDtl(startDateFormatted, endDateFormatted, data.IsLeaveOnly, UserId, data.OnlyReportedToMe, data.SearchUserID, RequestLevelPerson, data.DonotShowRejected);
}
List <DaywiseLeaveDtlModel> excelData = new List <DaywiseLeaveDtlModel>();
excelData = LeaveRequests.ToList();
if (excelData.Count > 0)
{
string[] columns = { "Emp Id", "Name", "Request Type", "Leave Balance", "Request Date", "Part Of Day", "Duration", "Status", "Reason", "Approver Comments" };
byte[] filecontent = ExcelExportHelper.ExportExcel(excelData, "", false, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "DaywiseReport_" + System.DateTime.Now + ".xlsx"));
}
else
{
ViewBag.RequestLevelPerson = RequestLevelPerson;
data.ErrorMsg = "Excel file is not generated as no data returned.";
return(View("DaywiseLeaveDateRangeView", data));
}
}
