static void Main(string[] args) { AdventureWorksDataContext db = new AdventureWorksDataContext(); db.Log = Console.Out; var query = from p in db.Persons join e in db.EmailAddresses on p.BusinessEntityID equals e.BusinessEntityID where p.LastName.Contains("SMI") orderby p.LastName, p.FirstName select new { LastName = p.LastName, FirstName = p.FirstName, MiddleName = p.MiddleName, EmailAddress = e.EmailAddress1 }; foreach (var q in query) { Console.WriteLine ( "{0}\t{1}\t{2}\t{3}", q.FirstName, q.MiddleName, q.LastName, q.EmailAddress ); } Console.WriteLine("Press a key to continue..."); Console.ReadKey(); }
public ActionResult Create([Bind(Include = "FirstName,LastName,Title")] Person person) { if (ModelState.IsValid) { using (var pp = new AdventureWorksDataContext()) { person.ModifiedDate = DateTime.Now; person.PersonType = "EM"; person.BusinessEntityID = 1; var businessEntity = new BusinessEntity(); businessEntity.ModifiedDate = DateTime.Now; businessEntity.Person = person; businessEntity.rowguid = Guid.NewGuid( ); person.BusinessEntity = businessEntity; pp.BusinessEntities.InsertOnSubmit(businessEntity); pp.Persons.InsertOnSubmit(person); pp.SubmitChanges(); } return(RedirectToAction("Index")); } return(View(person)); }
public static List<Product> Page(this List<Product> products, int pageSize, int pageNo) { using (AdventureWorksDataContext dataContext = new AdventureWorksDataContext()) { return products.Skip(pageNo * pageSize).Take(pageSize).ToList(); } }
private void DisplayInventory(SalesOrderDetail salesDetail, String desc) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { var inventoryRow = (from pi in dc.ProductInventories where pi.ProductID == salesDetail.ProductID && pi.LocationID == 7 //finished goods storage select pi).SingleOrDefault(); Boolean historyRowFound = (from th in dc.TransactionHistories where th.ProductID == salesDetail.ProductID && (DateTime.Now - th.ModifiedDate < new TimeSpan(0, 0, 3)) select th).Any(); if (inventoryRow != null) { Console.WriteLine("Product {0}: {1} - {2} - {3}", inventoryRow.ProductID, inventoryRow.Quantity, desc, (historyRowFound ? "History Row Found" : "No History")); } } }
public void Dodaj(int prodID) { bool znaleziono = false; foreach (ElementKoszyka element in _koszyk) { if (element.ProdID == prodID) { element.IloscSztuk += 1; znaleziono = true; } } if (!znaleziono) { AdventureWorksDataContext db = new AdventureWorksDataContext(); var produkt = (from p in db.Products where p.ProductID == prodID select p).FirstOrDefault(); if (produkt != null) { ElementKoszyka element = new ElementKoszyka(prodID, produkt.Name, produkt.ListPrice, 1); _koszyk.Add(element); } } }
protected void Page_Load(object sender, EventArgs e) { MultiView1.SetActiveView(blednyView); if (Request.QueryString["id"] != null) { AdventureWorksDataContext db = new AdventureWorksDataContext(); var produkt = (from p in db.Products where p.ProductID == int.Parse(Request.QueryString["id"]) select new { ProductID = p.ProductID, Name = p.Name, Category = p.ProductCategory.Name, ListPrice = p.ListPrice, Color = p.Color, Description = p.ProductModel.ProductModelProductDescriptions.First().ProductDescription.Description }).FirstOrDefault(); if (produkt != null) { KoszykHyperLink.NavigateUrl = "~/Zakupy.aspx?ProdID=" + produkt.ProductID; MultiView1.SetActiveView(prawidlowyView); Page.Title = "PrzeglÄ…dasz: " + produkt.Name; nazwaLabel.Text = produkt.Name; produktImage.ImageUrl = "Miniatura.aspx?id=" + produkt.ProductID.ToString(); kategoriaLabel.Text = produkt.Category; cenaLabel.Text = String.Format("{0:C}", produkt.ListPrice); kolorLabel.Text = produkt.Color; opisLabel.Text = produkt.Description; } } }
public void CreateDeleteProductTest() { AdventureWorksDataContext db = new AdventureWorksDataContext(); ProductService pr = new ProductService(); Product product = new Product(); product.Name = "Test-Create-Product"; product.ProductNumber = "Test-Number-Create-P"; pr.CreateProduct(product); List <Product> actualProducts = (from p in db.Product where p.ProductNumber.Equals(product.ProductNumber) select p).ToList <Product>(); Assert.AreEqual(product.Name, actualProducts[0].Name); pr.DeleteProduct(product); List <Product> actualProductsAfterDelete = (from p in db.Product where p.ProductNumber.Equals(product.ProductNumber) select p).ToList <Product>(); Assert.AreEqual(0, actualProductsAfterDelete.Count); }
public void UpdateReviewTest() { AdventureWorksDataContext db = new AdventureWorksDataContext(); ProductService pr = new ProductService(); ProductReviewService prs = new ProductReviewService(); Product product = new Product(); product.Name = "Test-Update-ProductReview2"; product.ProductNumber = "Test-U-PR"; pr.CreateProduct(product); ProductReview productReview = new ProductReview(); productReview.Rating = 1; productReview.Comments = "Comments-Test"; productReview.ProductID = product.ProductID; prs.CreateReview(productReview); productReview.Comments = "UPDATED-Comments-Test"; prs.UpdateReview(productReview); ProductReview actualProductReview = (from p in db.ProductReview where p.ProductID.Equals(product.ProductID) select p).First(); Assert.AreEqual("UPDATED-Comments-Test", actualProductReview.Comments); prs.DeleteReview(productReview); pr.DeleteProduct(product); }
public static List <Product> GetProductsByName(string namePart) { using (AdventureWorksDataContext db = new AdventureWorksDataContext()) { var productsByName = db.Products.Where(x => x.Name.Contains(namePart)).ToList(); return(productsByName); } }
public static List<Product> NullCategoryMS(this List<Product> products) { using (AdventureWorksDataContext dataContext = new AdventureWorksDataContext()) { IEnumerable<Product> list = products.Where<Product>(product => product.ProductSubcategory == null); return list.ToList(); } }
public static List <Product> GetProductsByName(string namePart) { using (AdventureWorksDataContext db = new AdventureWorksDataContext()) { IQueryable <Product> query = db.Products.Where(p => p.Name.Contains(namePart)); return(query.ToList()); } }
static void Main(string[] args) { string connString = "Server=(LocalDb)\\MSSQLLocalDb;Integrated Security=true;database=AdventureWorksDW2014"; DataContext context = new DataContext(connString); var tableProd = context.GetTable <Product>(); var products = from prod in tableProd where prod.Color == "Black" select prod; foreach (Product p in products) { Console.WriteLine(p.EnglishProductName); } Product product = products.First(); product.Color = "Red"; context.SubmitChanges(); AdventureWorksDataContext awdc = new AdventureWorksDataContext(connString); var categories = awdc.DimProductCategories; foreach (DimProductCategory pc in categories) { Console.WriteLine(pc.EnglishProductCategoryName); foreach (var sub in pc.DimProductSubcategories) { Console.WriteLine(sub.EnglishProductSubcategoryName); foreach (var pd in sub.DimProducts) { Console.WriteLine(" {0}", pd.EnglishProductName); } } } var query = from cat in categories from sub in cat.DimProductSubcategories from prod in sub.DimProducts where cat.EnglishProductCategoryName.Contains("Bikes") select prod; foreach (var p in query) { Console.WriteLine("{0}", p.EnglishProductName); } awdc.DimProducts.First().Color = "Dark Red"; awdc.SubmitChanges(); DimProductCategory newCat = new DimProductCategory(); newCat.EnglishProductCategoryName = "New Category 1"; newCat.SpanishProductCategoryName = "Nueva Categoria 1"; newCat.FrenchProductCategoryName = "Nouvelle Categorie 1"; awdc.DimProductCategories.InsertOnSubmit(newCat); awdc.SubmitChanges(); }
protected void Page_Load(object sender, EventArgs e) { string nazwa = Request.QueryString["Nazwa"]; if (nazwa != null) { AdventureWorksDataContext db = new AdventureWorksDataContext(); var produkty = from p in db.Products where p.Name.Contains(nazwa) select p; WynikiWyszukiwaniaGridView.DataSource = produkty; WynikiWyszukiwaniaGridView.DataBind(); } }
public DomainService CreateDomainService(Type domainServiceType, DomainServiceContext context) { AdventureWorksDataContext ctxt = new AdventureWorksDataContext(); IRepository <Employee> empRepository = new LinqToSqlRepository <Employee>(ctxt); DomainService ds = (DomainService)Activator.CreateInstance(domainServiceType, new object[] { empRepository }); ds.Initialize(context); return(ds); }
public void GetProductWithoutCategory_MethodTest() { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { List <Product> products = dc.Products.ToList(); List <Product> result = products.GetProductWithoutCategory_Method(); Assert.AreEqual(209, result.Count); } }
protected void Page_Load(object sender, EventArgs e) { AdventureWorksDataContext db = new AdventureWorksDataContext(); var noweProdukty = (from p in db.Products orderby db.Losuj() select p).Take(3); WybraneProduktyListView.DataSource = noweProdukty; WybraneProduktyListView.DataBind(); }
public static List<Product> NullCategoryQS(this List<Product> products) { using (AdventureWorksDataContext dataContext = new AdventureWorksDataContext()) { IEnumerable<Product> list = from product in products where product.ProductSubcategory == null select product; return list.ToList(); } }
protected void Page_Load(object sender, EventArgs e) { AdventureWorksDataContext db = new AdventureWorksDataContext(); var noweProdukty = (from p in db.Products orderby p.SellStartDate descending select p).Take(4); NoweProduktyListView.DataSource = noweProdukty; NoweProduktyListView.DataBind(); }
public static int GetTotalStandardCostByCategory(ProductCategory category) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { IEnumerable <decimal> query = from p in dc.Products where p.ProductSubcategory.ProductCategory.Name == category.Name select p.StandardCost; return((int)query.Sum()); } }
public static List <Product> GetProductsByName(string namePart) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { IEnumerable <Product> query = from p in dc.Products where p.Name.Contains(namePart) select p; return(query.ToList()); } }
public static List <Product> GetProductsByVendorName(string vendorName) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { IEnumerable <Product> query = from p in dc.ProductVendors where p.Vendor.Name.Equals(vendorName) select p.Product; return(query.ToList()); } }
public static String ProductVendorString(this List<Product> products) { using (AdventureWorksDataContext dataContext = new AdventureWorksDataContext()) { var query = from product in products from productVendor in dataContext.ProductVendor where product.ProductID == productVendor.ProductID select new { pName = productVendor.Product.Name, vName = productVendor.Vendor.Name }; return string.Join("\n", query.Select(x => $"{x.pName}-{x.vName}").ToArray()); } }
public void GetProductWithoutCategory_MethodToQueryTest() { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { List <Product> products = dc.Products.ToList(); List <Product> resultMethod = products.GetProductWithoutCategory_Method(); List <Product> resultQuery = products.GetProductWithoutCategory_Query(); Assert.AreEqual(resultMethod.Count, resultQuery.Count); } }
public static List <Product> GetProductsWithNRecentReviews(int howManyReviews) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { IEnumerable <Product> query = from p in dc.Products where p.ProductReviews.Count == howManyReviews select p; return(query.ToList()); } }
public void GetAllProductsTest() { AdventureWorksDataContext db = new AdventureWorksDataContext(); ProductService pr = new ProductService(); int expectedCount = (from p in db.Product select p).Count(); int actualCount = pr.GetAllProducts().Count(); Assert.AreEqual(expectedCount, actualCount); }
public static List <Product> GetNProductsFromCategory(string categoryName, int n) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { IEnumerable <Product> query = from p in dc.Products where p.ProductSubcategory.ProductCategory.Name == categoryName orderby p.Name select p; return(query.Take(n).ToList()); } }
public static List <Product> GetNRecentlyReviewedProducts(int howManyProducts) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { IEnumerable <Product> query = from r in dc.ProductReviews orderby r.ReviewDate descending group r.Product by r.ProductID into items select items.First(); return(query.Take(howManyProducts).ToList()); } }
public static string GetProductVendorByProductName(string productName) { using (AdventureWorksDataContext dc = new AdventureWorksDataContext()) { IEnumerable <string> query = from p in dc.Products join pVendor in dc.ProductVendors on p.ProductID equals pVendor.ProductID where p.Name == productName select pVendor.Vendor.Name; return(query.First()); } }
public static List <Product> GetNRecentlyReviewedProducts(int howManyProducts) { using (AdventureWorksDataContext db = new AdventureWorksDataContext()) { var recentlyReviewed = (from Product p in db.Products join ProductReview pr in db.ProductReviews on p.ProductID equals pr.ProductID orderby pr.ReviewDate descending select p).GroupBy(p => p.ProductID).Select(p => p.First()).Take(howManyProducts); return(recentlyReviewed.ToList()); } }
protected void Page_Load(object sender, EventArgs e) { AdventureWorksDataContext db = new AdventureWorksDataContext(); var noweProdukty = (from p in db.Products orderby p.SellStartDate descending select p).Take(4); NoweProduktyListView.DataSource = noweProdukty; NoweProduktyListView.DataBind(); GenericWebPart gwp = Parent as GenericWebPart; if (gwp != null) { gwp.Title = "Nasze nowe produkty:"; } }