Esempio n. 1
0
        static void InsertOrder(
        string shipName, string shipAddress,
        string shipCity, string shipRegionm,
        string shipPostalCode, string shipCountry,
        string customerID = null, int? employeeID = null,
        DateTime? orderDate = null, DateTime? requiredDate = null,
        DateTime? shippedDate = null, int? shipVia = null,
        decimal? freight = null)
        {
            using (NorthwindEntities context = new NorthwindEntities())
            {
                Order newOrder = new Order
                {
                    ShipAddress = shipAddress,
                    ShipCity = shipCity,
                    ShipCountry = shipCountry,
                    ShipName = shipName,
                    ShippedDate = shippedDate,
                    ShipPostalCode = shipPostalCode,
                    ShipRegion = shipRegionm,
                    ShipVia = shipVia,
                    EmployeeID = employeeID,
                    OrderDate = orderDate,
                    RequiredDate = requiredDate,
                    Freight = freight,
                    CustomerID = customerID
                };

                context.Orders.Add(newOrder);

                context.SaveChanges();

                Console.WriteLine("Row is inserted.");
            }
        }
Esempio n. 2
0
 static void Main(string[] args)
 {
     using (NorthwindEntities context = new NorthwindEntities())
     {
         InsertMultiple();
     }
 }
Esempio n. 3
0
        public static void RemoveCustomerByID(NorthwindEntities db, string customerID)
        {
            var customerForRemove = db.Customers.Where(c => c.CustomerID == customerID).First();

            db.Customers.Remove(customerForRemove);
            db.SaveChanges();
        }
Esempio n. 4
0
 private static IQueryable<Order> GetAllOrdersByYearAndCountry(NorthwindEntities db, int shipingYear, string shipingCountry)
 {
     var allOrdersFrom1997 =
         from order in db.Orders
         where order.OrderDate.Value.Year == shipingYear &&
               order.ShipCountry == shipingCountry
         select order;
     return allOrdersFrom1997;
 }
Esempio n. 5
0
        public static void ModifyCustomerByID(NorthwindEntities db, string customerID, string newCompanyName, string newContactName)
        {
            var customerForUpdate = db.Customers.Where(c => c.CustomerID == customerID).First();

            customerForUpdate.CompanyName = newCompanyName;
            customerForUpdate.ContactName = newContactName;

            db.SaveChanges();
        }
Esempio n. 6
0
        static void Main(string[] args)
        {
            Employee extended = new Employee();

            NorthwindEntities context = new NorthwindEntities();

            extended = context.Employees.Find(1);

            foreach (var item in extended.Territories)
            {
                Console.WriteLine("Teritory description - {0}", item.TerritoryDescription);
            }
        }
Esempio n. 7
0
        public static void CreateNewCustomer(NorthwindEntities db, string customerID, string companyName, string contactName, string country)
        {
            var newCustomer = new Customer()
            {
                CustomerID = customerID,
                CompanyName = companyName,
                ContactName = contactName,
                Country = country
            };

            db.Customers.Add(newCustomer);
            db.SaveChanges();
        }
Esempio n. 8
0
        static void Main(string[] args)
        {
            var db = new NorthwindEntities();

            string orderRegion = null;
            int startOrderYear = 1996;
            int endOrderYear = 1996;

            using (db)
            {
                ShowAllSalesByGivenRegionAndDate(db, orderRegion, startOrderYear, endOrderYear);
            }
        }
Esempio n. 9
0
        public static void Main()
        {
            var supplierName = "Exotic Liquids";
            var startDate = new DateTime(1996, 1, 1);
            var endDate = new DateTime(1997, 12, 31);

            // First input the stored procedure and after thar uncomment the code lines.
            using (var northwindEntities = new NorthwindEntities())
            {
                //var totalIncomes = northwindEntities.usp_TotalIncomesOfSupplier(supplierName, startDate, endDate).Single();

                //Console.WriteLine("Total incomes: {0:C}", totalIncomes);
            }
        }
Esempio n. 10
0
        private static void ShowAllSalesByGivenRegionAndDate(NorthwindEntities db, string orderRegion, int startOrderYear, int endOrderYear)
        {
            var allOrders =
                from order in db.Orders
                where order.ShipRegion == orderRegion &&
                order.ShippedDate.Value.Year >= startOrderYear &&
                order.ShippedDate.Value.Year <= endOrderYear
                select order;

            foreach (var order in allOrders)
            {
                Console.WriteLine("OrderID " + order.OrderID +
                    "; ShipRegion: " + order.ShipRegion +
                    "; ShipDate: " + order.ShippedDate);
            }
        }
Esempio n. 11
0
        static void Main(string[] args)
        {
            var db = new NorthwindEntities();

            int shipingYear = 1997;
            string shipingCountry = "Canada";

            using (db)
            {
                var allOrdersFrom1997 = GetAllOrdersByYearAndCountry(db, shipingYear, shipingCountry);

                foreach (var order in allOrdersFrom1997)
                {
                    Console.WriteLine("CustomerID: " + order.CustomerID + 
                        "; OrderID: " + order.OrderID + 
                        "; Year: " + order.OrderDate.Value.Year);
                }
            }
        }
Esempio n. 12
0
        static void Main(string[] args)
        {
            using (NorthwindEntities northwindEntities1 = new NorthwindEntities())
            {
                using (NorthwindEntities northwindEntities2 = new NorthwindEntities())
                {
                    Customer customerByFirstDataContext = northwindEntities1.Customers.Find("CHOPS");
                    customerByFirstDataContext.Region = "SW";

                    Customer customerBySecondDataContext = northwindEntities2.Customers.Find("CHOPS");
                    customerBySecondDataContext.Region = "SSWW";

                    northwindEntities1.SaveChanges();
                    northwindEntities2.SaveChanges();
                }
            }

            Console.WriteLine("Changes successfully made!");
        }
Esempio n. 13
0
        static void Main(string[] args)
        {
            IObjectContextAdapter context = new NorthwindEntities();
            string cloneNorthwind = context.ObjectContext.CreateDatabaseScript();

            string createNorthwindCloneDB = "CREATE DATABASE NorthwindTwin ON PRIMARY " +
            "(NAME = NorthwindTwin, " +
            "FILENAME = 'D:\\NorthwindTwin.mdf', " +
            "SIZE = 5MB, MAXSIZE = 10MB, FILEGROWTH = 10%) " +
            "LOG ON (NAME = NorthwindTwinLog, " +
            "FILENAME = 'D:\\NorthwindTwin.ldf', " +
            "SIZE = 1MB, " +
            "MAXSIZE = 5MB, " +
            "FILEGROWTH = 10%)";

            SqlConnection dbConForCreatingDB = new SqlConnection(
                "Server=BOBBY-PC; " +
                "Database=NORTHWND; " +
                "Integrated Security=true");

            dbConForCreatingDB.Open();

            using (dbConForCreatingDB)
            {
                SqlCommand createDB = new SqlCommand(createNorthwindCloneDB, dbConForCreatingDB);
                createDB.ExecuteNonQuery();
            }

            SqlConnection dbConForCloning = new SqlConnection(
                "Server=LOCALHOST; " +
                "Database=NorthwindTwin; " +
                "Integrated Security=true");

            dbConForCloning.Open();

            using (dbConForCloning)
            {
                SqlCommand cloneDB = new SqlCommand(cloneNorthwind, dbConForCloning);
                cloneDB.ExecuteNonQuery();
            }
        }
Esempio n. 14
0
        static void Main(string[] args)
        {
            var db = new NorthwindEntities();

            using (db)
            {
                string customerID = "AAAAA";
                string companyName = "ARS";
                string contactName = "Kiril Ivanov";
                string country = "Bulgaria";

                DAO.CreateNewCustomer(db, customerID, companyName, contactName, country);

                string newCompanyName = "BBR";
                string newContactName = "Marin Ivanov";

                DAO.ModifyCustomerByID(db, customerID, newCompanyName, newContactName);

                DAO.RemoveCustomerByID(db, customerID);
            }
        }
Esempio n. 15
0
        private static void FindByOrderUsingSQL(int year, string country)
        {
            NorthwindEntities db = new NorthwindEntities();

            string nativeSQLQuery =
                                    "SELECT c.CustomerID " +
                                    "FROM Customers c " +
                                    "JOIN Orders o " +
                                    "ON c.CustomerID = o.CustomerID " +
                                   "WHERE YEAR(o.OrderDate) = {0} " +
                                    "AND o.ShipCountry = {1} " +
                                    "group by c.CustomerID";

            object[] parameters = { year, country };

            var orders = db.Database.SqlQuery<string>(nativeSQLQuery, parameters);

            foreach (var order in orders)
            {
                Console.WriteLine(order);
            }
        }