View difference between Paste ID: w4gYtAJA and 8krhXBkS

-public class DAO
+public class DAO
-{
+{
-    static void Main()
+    static void Main()
-    {
+    {
-        int year = 1997;
+        Edit("ALFKI", "Plamen");
-        Edit("ALFKI", "Plamen");
+        Add("GRIVICA", "T233I");
-        //Add("NAKOVICA", "T233I");
+    }
-        FindAllCustomers(year, "Canada");
+
-    }
+    static void Add(string name, string id)
-
+    {
-    static void Add(string name, string id)
+        Customer newCustomer = new Customer()
-    {
+        {
-        Customer newCustomer = new Customer()
+            CompanyName = name,
-        {
+            CustomerID = id
-            CompanyName = name,
+        };
-            CustomerID = id
+
-        };
+        using (NORTHWNDEntities db = new NORTHWNDEntities())
-
+        {
-        using (NORTHWNDEntities db = new NORTHWNDEntities())
+            bool isInDB = IsInDataBase(db, id);
-        {
+
-            bool isInDB = IsInDataBase(db, id);
+            if (!isInDB)
-
+            {
-            if (!isInDB)
+                db.Customers.Add(newCustomer);
-            {
+                db.SaveChanges();
-                db.Customers.Add(newCustomer);
+                Console.WriteLine("Added Successful.");
-                db.SaveChanges();
+            }
-                Console.WriteLine("Added Successful.");
+            else
-            }
+            {
-            else
+                throw new ArgumentException("Such customer already exists");
-            {
+            }
-                throw new ArgumentException("Such customer already exists");
+        }
-            }
+    }
-        }
+
-    }
+    static void Edit(string id, string newContactName)
-
+    {
-    static void Edit(string id, string newContactName)
+        using (NORTHWNDEntities db = new NORTHWNDEntities())
-    {
+        {
-        using (NORTHWNDEntities db = new NORTHWNDEntities())
+            var customer = db.Customers.Where(x => x.CustomerID == id).FirstOrDefault();
-        {
+            customer.ContactName = newContactName;
-            var customer = db.Customers.Where(x => x.CustomerID == id).FirstOrDefault();
+            db.SaveChanges();
-            customer.ContactName = newContactName;
+        }
-            db.SaveChanges();
+    }
-        }
+
-    }
+    static void Delete(string id)
-
+    {
-    static void Delete(string id)
+        using (NORTHWNDEntities db = new NORTHWNDEntities())
-    {
+        {
-        using (NORTHWNDEntities db = new NORTHWNDEntities())
+            var customer = db.Customers.Where(x => x.CustomerID == id).FirstOrDefault();
-        {
+            db.Customers.Remove(customer);
-            var customer = db.Customers.Where(x => x.CustomerID == id).FirstOrDefault();
+            db.SaveChanges();
-            db.Customers.Remove(customer);
+        }
-            db.SaveChanges();
+    }
-        }
+
-    }
+    static bool IsInDataBase(NORTHWNDEntities db, string id)
-
+    {
-    static bool IsInDataBase(NORTHWNDEntities db, string id)
+        bool alreadyInDB = db.Customers.Where(a => a.CustomerID == id).Any();
-    {
+        return alreadyInDB;
-        bool alreadyInDB = db.Customers.Where(a => a.CustomerID == id).Any();
+    }
-        return alreadyInDB;
+