Beispiel #1
0
        public void AddNewEmployee(EmpTable emp)
        {
            var context = new EmpDBEntities();

            context.EmpTables.Add(emp);
            context.SaveChanges();
        }
Beispiel #2
0
        public void UpdateEmployee(EmpTable emp)
        {
            var context = new EmpDBEntities();
            var find    = context.EmpTables.FirstOrDefault(e => e.EmpID == emp.EmpID);

            if (find == null)
            {
                throw new Exception("No Employee found to update");
            }
            find.EmpAddress = emp.EmpAddress;
            find.EmpName    = emp.EmpName;
            find.EmpSalary  = emp.EmpSalary;
            find.DeptID     = emp.DeptID;
            context.SaveChanges();
        }