public JsonResult GetAttendanceRepotrt(int year, int month)
{
int employeeid = Convert.ToInt32(Session["Emp_ID"].ToString());
string from = year + "-" + month + "-" + 01;
string to = year + "-" + month + "-" + 31;
EmployeeProperty emp = new EmployeeProperty();
emp.Id = employeeid;
Employee_BLL empbll = new Employee_BLL(emp);
int empattendanceid = empbll.GetEmployeeAttendanceId();
objattendancebll = new Attendance_BLL();
DataTable dt = objattendancebll.SelectEmployeeAttendance(from, to, empattendanceid);
var dtserialize = JsonConvert.SerializeObject(dt);
return(Json(new { data = dtserialize }, JsonRequestBehavior.AllowGet));
}
public FileResult DownloadAttendance(int year, int month)
{
int employeeid = Convert.ToInt32(Session["Emp_ID"].ToString());
string from = year + "-" + month + "-" + 01;
string to = year + "-" + month + "-" + 31;
EmployeeProperty emp = new EmployeeProperty();
emp.Id = employeeid;
Employee_BLL empbll = new Employee_BLL(emp);
int empattendanceid = empbll.GetEmployeeAttendanceId();
objattendancebll = new Attendance_BLL();
DataTable dt = objattendancebll.SelectEmployeeAttendance(from, to, empattendanceid);
string fullName = Server.MapPath("~" + "/AttendanceFiles/Attendance Report" + from + to + employeeid);
bool flag = WriteDataTableToExcel(dt, "Attendance Report" + employeeid, fullName);
if (flag)
{
try
{
byte[] fileBytes = System.IO.File.ReadAllBytes(fullName + ".xlsx");
string fileName = Path.GetFileName(fullName + ".xlsx");
return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, fileName));
}
catch (Exception ex)
{
//StringBuilder sb = new StringBuilder();
//sb.Append("log something");
//File.AppendAllText(filePath + "log.txt", sb.ToString());
//sb.Clear();
byte[] fileBytes = new byte[1];
return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, ""));
}
}
else
{
byte[] fileBytes = System.IO.File.ReadAllBytes(fullName);
string fileName = Path.GetFileName("");
return(File(fileBytes, System.Net.Mime.MediaTypeNames.Application.Octet, "abc Else Case"));
}
}