public ActionResult ExportYearSummaryToExcel(YearwiseLeaveSummaryQueryModel data, string RequestLevelPerson) { IList <EmployeeWiseLeaveSummaryModel> LeaveRequests = null; using (var client = new LeaveClient()) { LeaveRequests = client.GetEmployeeWiseLeaveSumary(UserId, data.Year, RequestLevelPerson, data.SearchUserID, data.OnlyReportedToMe); } List <EmployeeWiseLeaveSummaryModel> excelData = new List <EmployeeWiseLeaveSummaryModel>(); excelData = LeaveRequests.ToList(); if (excelData.Count > 0) { string[] columns = { "Emp Id", "Name", "Request Type", "Total Leaves", "Used Leaves", "Pending Approval", "Balance Leaves" }; byte[] filecontent = ExcelExportHelper.ExportExcelYearSummary(excelData, "", false, columns); return(File(filecontent, ExcelExportHelper.ExcelContentType, "LeaveBalanceReport_" + System.DateTime.Now + ".xlsx")); } else { using (var Client = new LeaveClient()) { var result = Client.GetYearsFromLeaveBalance(); ViewBag.YearsInLeaveBal = result; } ViewBag.RequestLevelPerson = RequestLevelPerson; data.ErrorMsg = "Excel file is not generated as no data returned."; return(View("ViewEmployeeWiseLeaveSummary", data)); } }