public List <Employee> GetEmployeeInfo(int userid)
{
List <Employee> cm = new List <Employee>();
using (rdlcdbEntities dc = new rdlcdbEntities())
{
cm = dc.Employees.Where(x => x.Id == userid || userid == -1).ToList();
}
return(cm);
}
public List <vemp> GetEmployeeAttendanceInfo(int userid, DateTime startdate, DateTime endate)
{
using (rdlcdbEntities dc = new rdlcdbEntities())
{
var data = dc.vemps.Where(x => x.Logintime >= startdate && x.logouttime <= endate);
if (userid != -1)
{
data = data.Where(x => x.EmpID == userid);
}
return(data.ToList());
}
}
public ActionResult Report()
{
ViewBag.Message = "";
ReportParam objmodel = new ReportParam();
objmodel.StartDate = DateTime.Now.AddMonths(-1).Date;
objmodel.EndDate = DateTime.Now.Date;
using (rdlcdbEntities obj = new rdlcdbEntities())
{
objmodel.EmployeesList = obj.Employees.ToList();
objmodel.EmpName = "kiran";
objmodel.EmployeesList.Add(new Employee()
{
Id = -1, Name = "All Employee"
});
}
return(View(objmodel));
}