Ejemplo n.º 1
0
        public static void AddProducts(Product[] products)
        {
            using (DbNorthwind db = new DbNorthwind())
            {
                foreach (Product prod in products)
                {
                    var cat = from c in db.Category
                                    where c.CategoryID == prod.Category.CategoryID
                                    select c;
                    if (cat.Count() == 0)
                        prod.Category.CategoryID = Convert.ToInt32(db.InsertWithIdentity(prod.Category));
                    else
                        prod.Category = cat.First();

                    var sup = from s in db.Supplier
                                    where s.SupplierID == prod.Supplier.SupplierID
                                    select s;
                    if (sup.Count() == 0)
                        prod.Supplier.SupplierID = Convert.ToInt32(db.InsertWithIdentity(prod.Supplier));
                    else
                        prod.Supplier = sup.First();

                    db.Insert(prod);
                }
            }
        }
Ejemplo n.º 2
0
 public static void AddEmployee(string lastName, string[] territories, string firstName = "", string title = "")
 {
     using (DbNorthwind db = new DbNorthwind())
     {
         Employee emp = new Employee()
         {
             LastName = lastName,
             FirstName = firstName,
             Title = title,
             BirthDate = DateTime.Now,
             HireDate = DateTime.Now
         };
         emp.EmployeeID = Convert.ToInt32(db.InsertWithIdentity(emp));
         foreach (string terr in territories)
         {
             Territory territory = (from t in db.Territory
                                   where t.TerritoryID == terr
                                   select t).First();
             EmployeeTerritory et = new EmployeeTerritory()
             {
                  Employee = emp,
                  Territory = territory
             };
         }
     }
 }
Ejemplo n.º 3
0
 public static IEnumerable<Product> Products()
 {
     using (DbNorthwind db = new DbNorthwind())
     {
         var q = from p in db.Product
                 select p;
         return q.ToList();
     }
 }
Ejemplo n.º 4
0
 public static IEnumerable<EmployeeShipper> GetEmployeeShipperCoworking()
 {
     using (DbNorthwind db = new DbNorthwind())
     {
         var q = from o in db.Order
                 select new EmployeeShipper()
                 {
                     Employee = o.Employee,
                     Shipper = o.Shipper
                 };
         return q.ToList();
     }
 }
Ejemplo n.º 5
0
 public static IEnumerable<EmployeeRegionStat> GetEmployeeRegionStatistic()
 {
     using (DbNorthwind db = new DbNorthwind())
     {
         var q = from e in db.Employee
                 join et in db.EmployeeTerritory on e.EmployeeID equals et.Employee.EmployeeID
                 join t in db.Territory on et.Territory.TerritoryID equals t.TerritoryID
                 join r in db.Region on t.Region.RegionID equals r.RegionID
                 group e by r.RegionDescription into grp
                 select new EmployeeRegionStat()
                 {
                     RegionDescription = grp.Key,
                     EmployeeCount = grp.Count()
                 };
         return q.ToList();
     }
 }
Ejemplo n.º 6
0
 public static IEnumerable<EmployeeRegion> GetEmployeeRegionInformation()
 {
     using (DbNorthwind db = new DbNorthwind())
     {
         var q = from e in db.Employee
                 join et in db.EmployeeTerritory on e.EmployeeID equals et.Employee.EmployeeID
                 join t in db.Territory on et.Territory.TerritoryID equals t.TerritoryID
                 join r in db.Region on t.Region.RegionID equals r.RegionID
                 select new EmployeeRegion()
                 {
                     LastName = e.LastName,
                     FirstName = e.FirstName,
                     RegionDescription = r.RegionDescription
                 };
         return q.ToList();
     }
 }
Ejemplo n.º 7
0
        public static void ReplaceByProduct(Product newProduct)
        {
            using (DbNorthwind db = new DbNorthwind())
            {
                var prod = from p in db.Product
                                where p.ProductID == newProduct.ProductID
                                select p;
                if (prod.Count() == 0)
                    newProduct.ProductID = Convert.ToInt32(db.InsertWithIdentity(newProduct));

                var q = (from o in db.Order
                        where o.ShippedDate == null
                        select o).ToList();
                foreach (Order order in q)
                {
                    OrderDetail orderDetail = (from od in db.OrderDetail
                                               where od.Order.OrderID == order.OrderID
                                               select od).First();
                    orderDetail.Product = newProduct;
                    db.Update(orderDetail);
                }
            }
        }
Ejemplo n.º 8
0
 public static void UpdateCategory(Product[] products, Category newCategory)
 {
     using (DbNorthwind db = new DbNorthwind())
     {
         foreach (Product prod in products)
         {
             prod.Category = newCategory;
             db.Update(prod);
         }
     }
 }