public ActionResult FirstPageUrl(int id = 1) { using (var db = new PracticeDBEntities()) { return(View(db.Orders.OrderBy(o => o.OrderId))); } }
public ActionResult Delete(int id, FormCollection formCollection) { using (PracticeDBEntities db = new PracticeDBEntities()) { Employee employee = db.Employees.Where(x => x.Eno == id).FirstOrDefault(); db.Employees.Remove(employee); db.SaveChanges(); } return(RedirectToAction("Index")); }
// private PracticeDBEntities db = new PracticeDBEntities(); // GET: Employee public ActionResult Index() { using (PracticeDBEntities db = new PracticeDBEntities()) { var emplist = db.Employees.ToList(); List <TestEmployee> list = new List <TestEmployee>(); list = emplist.Select(m => new TestEmployee { Eno = m.Eno, Ename = m.Ename, Job = m.Job, Salary = m.Salary, Dname = m.Dname }).ToList(); return(View(list)); } }
public ActionResult Delete(int id) { using (PracticeDBEntities db = new PracticeDBEntities()) { var employee = db.Employees.Where(x => x.Eno == id).FirstOrDefault(); TestEmployee model = new TestEmployee(); model.Eno = employee.Eno; model.Ename = employee.Ename; model.Job = employee.Job; model.Salary = employee.Salary; model.Dname = employee.Dname; return(View(model)); } }
public ActionResult Edit(int id, TestEmployee model) { using (PracticeDBEntities db = new PracticeDBEntities()) { Employee employee = new Employee(); employee.Eno = model.Eno; employee.Ename = model.Ename; employee.Job = model.Job; employee.Salary = model.Salary; employee.Dname = model.Dname; db.Entry(employee).State = EntityState.Modified; db.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Create(TestEmployee model) { using (PracticeDBEntities db = new PracticeDBEntities()) { Employee employee = new Employee(); employee.Eno = model.Eno; employee.Ename = model.Ename; employee.Job = model.Job; employee.Salary = model.Salary; employee.Dname = model.Dname; db.Employees.Add(employee); db.SaveChanges(); } return(RedirectToAction("Index")); }
public UnitOfWork() { _db = new PracticeDBEntities(); }
public GenericRepository(PracticeDBEntities db) { _db = db; _dbSet = _db.Set <T>(); }