public ActionResult ExportAccessCardAttendanceToExcel(EmployeeAttendanceQueryModel EmployeeAttendanceQueryModelObj, string RequestLevelPerson)
{
List <EmployeeAttendanceModel> excelData = GetAccessCardEmployeeAttendanceList(EmployeeAttendanceQueryModelObj.CardID.ToString(), (EmployeeAttendanceQueryModelObj.FromDate == DateTime.MinValue ? "" : EmployeeAttendanceQueryModelObj.FromDate.ToString()),
(EmployeeAttendanceQueryModelObj.ToDate == DateTime.MinValue ? "" : EmployeeAttendanceQueryModelObj.ToDate.ToString()), RequestLevelPerson).ToList();
if (excelData.Count > 0)
{
List <string> columns = new List <string>()
{
"Card Id", "Date", "In Out Time", "In Out", "Name"
};
string fileName = string.Format("AccessCardReport_{0}{1}", DateTime.Now.ToString("ddMMyyyyHHmmss"), ".xlsx");
if (EmployeeAttendanceQueryModelObj.RequestLevelPerson == "My")
{
columns = new List <string>()
{
"Card Id", "Date", "In Out Time", "In Out", "Name"
};
}
byte[] filecontent = ExcelExportHelper.ExportExcelAccessCardAttendance(excelData, "", false, columns.ToArray());
return(File(filecontent, ExcelExportHelper.ExcelContentType, fileName));
}
else
{
ViewBag.RequestLevelPerson = RequestLevelPerson;
EmployeeAttendanceQueryModel data = new EmployeeAttendanceQueryModel
{
ErrorMsg = "Excel file is not generated as no data returned."
};
return(View("~/Views/Attendance/AccessCardAttendance.cshtml", data));
}
}
