예제 #1
0
 // ADD
 public static void Add(Employee employee)
 {
     using (var db = new SoftUniEntities())
     {
         db.Employees.Add(employee);
         db.SaveChanges();
         Console.WriteLine("Employee added successiful.");
     }
 }
예제 #2
0
        // FIND BY KEY
        public static Employee FindByKey(object key)
        {
            using (var db = new SoftUniEntities())
            {
                var employee = db.Employees.Find(key);

                if (employee == null)
                {
                    throw new ArgumentException(
                        String.Format("\r\n\r\nEmployee with ID: {0}, was not found.\r\n\r\n", key));
                }

                return employee;
            }
        }
예제 #3
0
        // DELETE
        public static void Delete(int id)
        {
            using (var db = new SoftUniEntities())
            {
                var employeeToDelete = db.Employees.Find(id);

                if (employeeToDelete != null)
                {
                    db.Employees.Remove(employeeToDelete);
                    db.SaveChanges();
                    Console.WriteLine("Employee with ID: {0} removed.", id);
                }
                else
                {
                    Console.WriteLine("Employee with ID {0} was not found.", id);
                }
            }
        }
예제 #4
0
        // MODIFY
        public static void Modify(int id, string propertyToUpdate, string updateValue)
        {
            using (var db = new SoftUniEntities())
            {
                var employee = db.Employees.Find(id);

                try
                {
                    employee.GetType().GetProperty(propertyToUpdate).SetValue(employee, updateValue);
                    db.SaveChanges();
                    Console.WriteLine("Employee with ID: {0} -> {1} has changed to: {2}",
                        id, propertyToUpdate, updateValue);
                }
                catch (NullReferenceException)
                {
                    Console.Error.WriteLine("Unknown property/id parameter.");
                }
            }
        }