View difference between Paste ID: iF6yKNt0 and TLpkkqAv
SHOW: | | - or go back to the newest paste.
1-
class DAO
1+
public class DAO
2-
{
2+
{
3-
    static void Main()
3+
    static void Main()
4-
    {
4+
    {
5-
        int year = 1997;
5+
        int year = 1997;
6-
        Edit("ALFKI", "Plamen");
6+
        FindAllCustomers(year, "Canada");
7-
        //Add("NAKOVICA", "T233I");
7+
    }
8-
        FindAllCustomers(year, "Canada");
8+
9-
    }
9+
    static void FindAllCustomers(int orderDate, string shipDestination)
10-
    
10+
    {
11-
    static void Add(string name, string id)
11+
        using (NORTHWNDEntities db = new NORTHWNDEntities())
12-
    {
12+
        {
13-
        Customer newCustomer = new Customer()
13+
            var orders = from order in db.Orders
14-
        {
14+
                         where order.OrderDate.Value.Year == orderDate && order.ShipCountry == shipDestination
15-
            CompanyName = name,
15+
                         select order;
16-
            CustomerID = id
16+
17-
        };
17+
            foreach (var item in orders)
18-
        
18+
            {
19-
        using (NORTHWNDEntities db = new NORTHWNDEntities())
19+
                Console.WriteLine("Order made by: {0} with CustomerId: {1}", item.Customer.ContactName, item.Customer.CustomerID);
20-
        {
20+
            }
21-
            bool isInDB = IsInDataBase(db, id);
21+
        }
22-
22+
    }
23-
            if (!isInDB)
23+