Пример #1
0
        public void AddEmployee(EmpTable emp)
        {
            //No SQL Statements, everything is OOP....
            var context = new MyDBEntities();

            context.EmpTables.Add(emp); //Adds to the Collection...
            context.SaveChanges();      //Commit to the database..
        }
Пример #2
0
        public void UpdateEmployee(EmpTable emp)
        {
            var context  = new MyDBEntities();
            var selected = context.EmpTables.FirstOrDefault((e) => e.EmpID == emp.EmpID);

            selected.Empname    = emp.Empname;
            selected.EmpAddress = emp.EmpAddress;
            selected.EmpSalary  = emp.EmpSalary;
            context.SaveChanges();
        }
Пример #3
0
        public void DeleteEmployee(int id)
        {
            var context = new MyDBEntities();
            var emp     = context.EmpTables.FirstOrDefault((e) => e.EmpID == id);

            if (emp == null)
            {
                throw new Exception("No Employee was found to delete");
            }
            context.EmpTables.Remove(emp);
            context.SaveChanges();
        }