public ActionResult Delete(int depID)
{
var t = new project1.Models.Project1DBEntities();
var temp_dep = t.Departments.First(g => g.ID == depID);
return(View(temp_dep));
}
// GET: Department
public ActionResult Index()
{
var t = new project1.Models.Project1DBEntities();
List <Models.Department> departments = t.Departments.ToList();
return(View(departments));
}
public ActionResult Delete(int empID)
{
var t = new project1.Models.Project1DBEntities();
var temp_emp = t.Employee1.First(g => g.ID == empID);
return(View(temp_emp));
}
public ActionResult Add(Department dep)
{
var t = new project1.Models.Project1DBEntities();
t.Departments.Add(dep);
t.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int empID)
{
var t = new project1.Models.Project1DBEntities();
var employee = t.Employee1.Include("Department").FirstOrDefault(emp => emp.ID == empID);
ViewData.Add("DepartmentsList", t.Departments.ToList());
return(View(employee));
}
public ActionResult Delete(int depID, int managerID)
{
var t = new project1.Models.Project1DBEntities();
var temp_dep = t.Departments.First(g => g.ID == depID && g.Manager == managerID);
t.Departments.Remove(temp_dep);
t.SaveChanges();
return(View(temp_dep));
}
public ActionResult Edit(Department dep)
{
var t = new project1.Models.Project1DBEntities();
var temp_dep = t.Departments.First(g => g.ID == dep.ID);
temp_dep.Manager = dep.Manager;
temp_dep.Name = dep.Name;
t.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int depID)
{
var t = new project1.Models.Project1DBEntities();
var dep = t.Departments.FirstOrDefault(g => g.ID == depID);
if (dep != null)
{
return(View(dep));
}
return(View());
}
public ActionResult Delete(int empID, int usr)
{
var t = new project1.Models.Project1DBEntities();
var temp_emp = t.Employee1.First(g => g.ID == empID);
var shifts = t.EmployeeShifts.Where(g => g.EmployeeID == empID).ToList();
t.Employee1.Remove(temp_emp);
t.EmployeeShifts.RemoveRange(shifts);
t.SaveChanges();
return(View(temp_emp));
}
public ActionResult Edit(Employee1 emp1)
{
var t = new project1.Models.Project1DBEntities();
var employee = t.Employee1.Include("Department").FirstOrDefault(emp => emp.ID == emp1.ID);
employee.FirstName = emp1.FirstName;
employee.LastName = emp1.LastName;
employee.StartWorkYear = emp1.StartWorkYear;
employee.DepartmentID = emp1.DepartmentID;
t.SaveChanges();
return(RedirectToAction("HomePage"));
}
// GET: Employee
public ActionResult HomePage(string search)
{
var t = new project1.Models.Project1DBEntities();
List <Models.Employee1> employees = t.Employee1.ToList();
if (!string.IsNullOrEmpty(search))
{
employees = t.Employee1.Include("Department").
Where(g => g.FirstName.ToLower().Contains(search.ToLower()) ||
g.LastName.ToLower().Contains(search.ToLower()) ||
g.Department.Name.ToLower().Contains(search.ToLower())).ToList();
}
return(View(employees));
}