// GET: api/Employees
//public IEnumerable<string> Get()
//{
// return new string[] { "value1", "value2" };
//}
public IEnumerable <Employee> Get()
{
using (EmEntities ent = new EmEntities())
{
return(ent.Employees.ToList());
}
}
//HTTPGET: Student,The HTTP GET request embeds data into a query string
public ActionResult Index()
{
EmEntities emDatabase = new EmEntities();
List <TestTable> dbStudentList = emDatabase.TestTables.ToList();
//var x = "This is Index action method of StudentController";
return(View(dbStudentList));
//return View(studentList.OrderBy(s => s.StudentId).ToList());
//return ViewPage("This is Index action method of StudentController");
}
public JsonResult DeleteEmployee(int id)
{
var result = false;
var db = new EmEntities();
var em = db.Employees.SingleOrDefault(e => e.EmployeeId == id && e.IsDeleted == false);
if (em != null)
{
em.IsDeleted = true;
result = true;
db.SaveChanges();
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult DisplayEmployees()
{
var db = new EmEntities();
var empList = db.Employees
.Where(e => e.IsDeleted == false)
.Select(x => new EmployeeViewModel
{
EmployeeId = x.EmployeeId,
Name = x.Name,
Address = x.Address,
DepartmentName = x.Department.DepartmentName,
IsDeleted = x.IsDeleted,
}).ToList();
ViewBag.EmployeeList = empList;
return(PartialView("DisplayPartial"));
}
// GET: Employee
public ActionResult Index(EmployeeViewModel model)
{
var db = new EmEntities();
var depList = db.Departments.ToList();
ViewBag.DepartmentList = new SelectList(depList, "DepartmentId", "DepartmentName");
var em = new Employee();
//em.EmployeeId = model.EmployeeId;
em.Name = model.Name;
em.Address = model.Address;
em.DepartmentId = model.DepartmentId;
db.Employees.Add(em);
//db.SaveChanges();
var latestEmpId = em.EmployeeId;
var site = new Site();
site.SiteName = model.SiteName;
db.Sites.Add(site);
//db.SaveChanges();
site.EmployeeId = latestEmpId;
var empList = db.Employees
.Where(e => e.IsDeleted == false)
.Select(x => new EmployeeViewModel
{
EmployeeId = x.EmployeeId,
Name = x.Name,
Address = x.Address,
DepartmentName = x.Department.DepartmentName,
IsDeleted = x.IsDeleted,
}).ToList();
ViewBag.EmployeeList = empList;
return(View(model));
}
