public ActionResult StaffDetailReport(FormCollection formObject)
{
string department, designation;
DateTime startDate, fromDate;
ViewBag.StaffDepartmentCode = new SelectList(db.Departments, "DepartmentCode", "DepartmentName");
ViewBag.SemesterCode = new SelectList(db.Semesters, "SemesterCode", "SemesterDesc");
ViewBag.OfficeCode = new SelectList(db.Locations, "RoomNo", "RoomNo");
department = formObject["StaffDepartmentCode"];
startDate = Convert.ToDateTime(formObject["StartDate"]);
fromDate = Convert.ToDateTime(formObject["FromDate"]);
designation = formObject["staff.StaffDesignation"];
var staffList = db.Staffs.Where(a => a.StaffDepartmentCode.Equals(department) && a.StaffDesignation.Equals(designation));
// staffList = staffList.Where(a => a.StaffHireDate >= startDate && a.StaffHireDate <= fromDate); a.
staffReportView reportView = new staffReportView()
{
staff = new Staff(),
staffs = staffList.ToList()
};
return(View(reportView));
}
public ActionResult StaffDetailReport()
{
ViewBag.StaffDepartmentCode = new SelectList(db.Departments, "DepartmentCode", "DepartmentName");
ViewBag.SemesterCode = new SelectList(db.Semesters, "SemesterCode", "SemesterDesc");
ViewBag.OfficeCode = new SelectList(db.Locations, "RoomNo", "RoomNo");
var staffList = db.Staffs.Include(s => s.Department).Include(s => s.Semester);
//ViewBag.Department = new SelectList(db.Departments, "DepartmentCode", "DepartmentName", dept.DepartmentName);
staffReportView reportView = new staffReportView
{
staff = new Staff(),
staffs = staffList.ToList()
};
return(View(reportView));
}
