public ActionResult Part63Pagenation(string searchby, string search, int?Page)
{
EmployeeBusiness db = new EmployeeBusiness();
if (searchby == "Gender")
{
return(View(db.DeptEmployees().Where(x => x.Gender == search || search == null).ToList().ToPagedList(Page ?? 1, 3)));
}
else
{
return(View(db.DeptEmployees().Where(x => x.Employeename.StartsWith(search) || search == null).ToList().ToPagedList(Page ?? 1, 3)));
}
}
// GET: Part62seachFunctionality
public ActionResult Part62seachFunctionality(string searchby, string search)
{
EmployeeBusiness db = new EmployeeBusiness();
if (searchby == "Gender")
{
return(View(db.DeptEmployees().Where(x => x.Gender == search || search == null).ToList()));
}
else
{
return(View(db.DeptEmployees().Where(x => x.Employeename.StartsWith(search) || search == null).ToList()));
}
}
public ActionResult Part73OutputCache()
{
// System.Threading.Thread.Sleep(3000);
EmployeeBusiness db = new EmployeeBusiness();
return(View(db.DeptEmployees()));
}
public ActionResult Part64Sorting(string searchby, string search, int?Page, string sortBy)
{
ViewBag.SortByNameParameter = string.IsNullOrEmpty(sortBy) ? "Name desc" : "";
ViewBag.SortByGenderParameter = (sortBy == "Gender") ? "Gender Desc" : "Gender";
EmployeeBusiness db = new EmployeeBusiness();
var employee = db.DeptEmployees().AsQueryable();
if (searchby == "Gender")
{
employee = employee.Where(x => x.Gender == search || search == null);
}
else
{
employee = employee.Where(x => x.Employeename.StartsWith(search) || search == null);
}
switch (sortBy)
{
case "Name desc":
employee = employee.OrderByDescending(x => x.Employeename);
break;
case "Gender Desc":
employee = employee.OrderByDescending(x => x.Gender);
break;
case "Gender":
employee = employee.OrderBy(x => x.Gender);
break;
default:
employee = employee.OrderBy(x => x.Employeename);
break;
}
return(View(employee.ToPagedList(Page ?? 1, 3)));
}
// GET: Part40DisplayForFormatText/Edit/5
public ActionResult Edit(int id)
{
EmployeeBusiness emp = new EmployeeBusiness();
EmployeeBO employee = (EmployeeBO)emp.DeptEmployees().SingleOrDefault(m => m.EmpID == id);
return(View(employee));
}
// GET: Part40DisplayForFormatText/Details/5
public ActionResult Details(int id)
{
EmployeeBusiness emp = new EmployeeBusiness();
EmployeeBO employee = (EmployeeBO)emp.DeptEmployees().Where(m => m.EmpID == id).FirstOrDefault();
return(View(employee));
}
// GET: Part9GenerateHyperlinks
public ActionResult Part9GenerateHyperlinks()
{
List <EmployeeBO> li = new List <EmployeeBO>();
EmployeeBusiness eb = new EmployeeBusiness();
li = eb.DeptEmployees().ToList();
return(View(li));
}
// Part 11 Object Model Impliementation
public ActionResult Index()
{
EmployeeBusiness obj = new EmployeeBusiness();
List <EmployeeBO> list = obj.DeptEmployees().ToList();
return(View("Testing", list));
}
//Part44 DiplayTemplate and Edit Template
public ActionResult DisplayTemplate(int id)
{
EmployeeBusiness emp = new EmployeeBusiness();
EmployeeBO employee = (EmployeeBO)emp.DeptEmployees().Where(m => m.EmpID == id);
ViewData["EmployeeData"] = employee;
return(View());
}
public ActionResult Edit(EmployeeBO objEmployee)
{
try
{
if (ModelState.IsValid)
{
EmployeeBusiness db = new EmployeeBusiness();
EmployeeBO employeefromdb = db.DeptEmployees().SingleOrDefault(x => x.EmpID == objEmployee.EmpID);
employeefromdb.Employeename = objEmployee.Employeename;
employeefromdb.Gender = objEmployee.Gender;
employeefromdb.Department = objEmployee.Department;
employeefromdb.Email = objEmployee.Email;
employeefromdb.City = objEmployee.City;
employeefromdb.Salary = objEmployee.Salary;
}
return(View());
}
catch
{
return(View());
}
}
public string Part73GetEmployeeCount()
{
EmployeeBusiness db = new EmployeeBusiness();
return("Employee Count " + db.DeptEmployees().Count().ToString() + " @ " + DateTime.Now.ToString());
}
/// <summary>
/// Part 65 Deleting Check box data
/// </summary>
/// <param name="searchby"></param>
/// <param name="search"></param>
/// <returns></returns>
public ActionResult Part65DeleteData()
{
EmployeeBusiness db = new EmployeeBusiness();
return(View(db.DeptEmployees().ToList()));
}
