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:";
}
}
