// 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)); }