protected void Page_Load(object sender, EventArgs e) { // Handle the query from the URL string query = Request.QueryString["q"]; if (query == null) { query = ""; } AdvWorksDataContext db = new AdvWorksDataContext(); try { var latestItems = (from model in db.ProductModels where model.CatalogDescription != null && model.Products.Any(p => p.Name.ToLower().Contains(query.ToLower()) || model.CatalogDescription.ToString().ToLower().Contains(query.ToLower())) select model.Products.First()); LatestItemsView.DataSource = latestItems; LatestItemsView.DataBind(); } catch (Exception ex) { Response.Redirect("readme.txt"); Debug.WriteLine(ex.Message); Debug.WriteLine("Did you forget to set up the AdventureWorks SQL Database?"); } }
protected void Page_Load(object sender, EventArgs e) { // Handle the query from the URL string query = Request.QueryString["q"]; if (query == null) query = ""; AdvWorksDataContext db = new AdvWorksDataContext(); try { var latestItems = (from model in db.ProductModels where model.CatalogDescription != null && model.Products.Any(p => p.Name.ToLower().Contains(query.ToLower()) || model.CatalogDescription.ToString().ToLower().Contains(query.ToLower())) select model.Products.First()); LatestItemsView.DataSource = latestItems; LatestItemsView.DataBind(); } catch (Exception ex) { Response.Redirect("readme.txt"); Debug.WriteLine(ex.Message); Debug.WriteLine("Did you forget to set up the AdventureWorks SQL Database?"); } }
public JgGrid SearchGrid(int rows, int page, string sidx, string sord, string filters) { AdvWorksDataContext dc = new AdvWorksDataContext(); JavaScriptSerializer serializer = new JavaScriptSerializer(); filters f = serializer.Deserialize <filters>(filters); var p = dc.vProductAndDescriptions.AsQueryable(); if (f.groupOp == "AND") { foreach (var rule in f.rules) { p = p.Where <vProductAndDescription>( rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op) ); } } else { //Or var temp = (new List <vProductAndDescription>()).AsQueryable(); foreach (var rule in f.rules) { var t = p.Where <vProductAndDescription>( rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op) ); temp = temp.Concat <vProductAndDescription>(t); } p = temp; } p = p.OrderBy <vProductAndDescription>(sidx, sord); return(new JgGrid(page, p, rows)); }
private void Form1_Load(object sender, EventArgs e) { gridControl1.ServerMode = true; AdvWorksDataContext dc = new AdvWorksDataContext(); dc.Log = Console.Out; // log queries linqServerModeSource1.QueryableSource = dc.PurchaseOrderHeaders; gridControl1.DataSource = linqServerModeSource1; }
protected void Page_Load(object sender, EventArgs e) { if (String.IsNullOrEmpty(Request.Params["id"])) { Response.Redirect("default.aspx"); } AdvWorksDataContext db = new AdvWorksDataContext(); Response.ContentType = "image/jpeg"; var picture = (from p in db.ProductProductPhotos where p.ProductID == int.Parse(Request.QueryString["id"]) select (Request.QueryString["size"] == "small") ? p.ProductPhoto.ThumbNailPhoto : p.ProductPhoto.LargePhoto).FirstOrDefault(); System.Drawing.Image img = System.Drawing.Image.FromStream(new MemoryStream(picture.ToArray())); img.Save(Response.OutputStream, ImageFormat.Jpeg); }
protected void Page_Load(object sender, EventArgs e) { if (String.IsNullOrEmpty(Request.Params["id"])) { Response.Redirect("default.aspx"); } AdvWorksDataContext db = new AdvWorksDataContext(); Response.ContentType = "image/jpeg"; var picture = (from p in db.ProductProductPhotos where p.ProductID == int.Parse(Request.QueryString["id"]) select(Request.QueryString["size"] == "small") ? p.ProductPhoto.ThumbNailPhoto : p.ProductPhoto.LargePhoto).FirstOrDefault(); System.Drawing.Image img = System.Drawing.Image.FromStream(new MemoryStream(picture.ToArray())); img.Save(Response.OutputStream, ImageFormat.Jpeg); }
protected void Page_Load(object sender, EventArgs e) { // Handle the query from the URL string query = Request.QueryString["q"]; if (query == null) query = ""; bool returnPhotos = (Request.QueryString["type"] == "photos"); AdvWorksDataContext db = new AdvWorksDataContext(); try { Response.ContentType = "application/rss+xml"; XNamespace nsMediaRSS = "http://search.yahoo.com/mrss/"; XNamespace nsExample = "http://sdk.microsoft.com/example/"; XNamespace nsDescription = "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; XDocument xml; // Query DB and generate RSS output using LINQ xml = new XDocument( new XElement("rss", new XAttribute("version", "2.0"), new XAttribute(XNamespace.Xmlns + "media", "http://search.yahoo.com/mrss/"), new XAttribute(XNamespace.Xmlns + "example", "http://sdk.microsoft.com/example/"), new XElement("channel", new XElement("title", "AdventureWorks Product Search Results - " + query), new XElement("link", Request.Url), new XElement("description", "Example search results from an example database."), from model in db.ProductModels where model.CatalogDescription != null && (model.Products.Any(p => p.Name.ToLower().Contains(query.ToLower())) || model.CatalogDescription.ToString().ToLower().Contains(query.ToLower())) select new XElement("item", new XElement("title", model.Name), new XElement("description", model.CatalogDescription.Element(nsDescription + "Summary").Value), new XElement("link", String.Format( "http://localhost:63000/AdventureSearch/productinfo.aspx?id={0}", model.Products.FirstOrDefault().ProductID)), new XElement("pubDate", DateTime.Now.ToString("R")), // add custom thumbnail new XElement(nsMediaRSS + "thumbnail", new XAttribute("url", "http://localhost:63000/AdventureSearch/DisplayPicture.aspx?id=" + model.Products.FirstOrDefault().ProductID + "&size=small")), // add enclosure if type == photos returnPhotos ? new XElement("enclosure", new XAttribute("type", "image/jpeg"), new XAttribute("url", "http://localhost:63000/AdventureSearch/DisplayPicture.aspx?id=" + model.Products.FirstOrDefault().ProductID + "&size=large")) : null, // add custom property new XElement(nsExample + "color", model.Products.FirstOrDefault().Color), new XElement(nsExample + "copyright", model.CatalogDescription.Element(nsDescription + "Manufacturer").Element(nsDescription + "Copyright").Value), new XElement(nsExample + "company", model.CatalogDescription.Element(nsDescription + "Manufacturer").Element(nsDescription + "Name").Value) ) ) ) ); XmlTextWriter writer = new XmlTextWriter(Response.Output); writer.Formatting = Formatting.Indented; xml.WriteTo(writer); writer.Close(); } catch (Exception ex) { Response.Redirect("readme.txt"); Debug.WriteLine(ex.Message); Debug.WriteLine("Did you forget to set up the AdventureWorks SQL Database?"); } }
protected void Page_Load(object sender, EventArgs e) { // Handle the query from the URL string query = Request.QueryString["q"]; if (query == null) { query = ""; } bool returnPhotos = (Request.QueryString["type"] == "photos"); AdvWorksDataContext db = new AdvWorksDataContext(); try { Response.ContentType = "application/rss+xml"; XNamespace nsMediaRSS = "http://search.yahoo.com/mrss/"; XNamespace nsExample = "http://sdk.microsoft.com/example/"; XNamespace nsDescription = "http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription"; XDocument xml; // Query DB and generate RSS output using LINQ xml = new XDocument( new XElement("rss", new XAttribute("version", "2.0"), new XAttribute(XNamespace.Xmlns + "media", "http://search.yahoo.com/mrss/"), new XAttribute(XNamespace.Xmlns + "example", "http://sdk.microsoft.com/example/"), new XElement("channel", new XElement("title", "AdventureWorks Product Search Results - " + query), new XElement("link", Request.Url), new XElement("description", "Example search results from an example database."), from model in db.ProductModels where model.CatalogDescription != null && (model.Products.Any(p => p.Name.ToLower().Contains(query.ToLower())) || model.CatalogDescription.ToString().ToLower().Contains(query.ToLower())) select new XElement("item", new XElement("title", model.Name), new XElement("description", model.CatalogDescription.Element(nsDescription + "Summary").Value), new XElement("link", String.Format( "http://localhost:63000/AdventureSearch/productinfo.aspx?id={0}", model.Products.FirstOrDefault().ProductID)), new XElement("pubDate", DateTime.Now.ToString("R")), // add custom thumbnail new XElement(nsMediaRSS + "thumbnail", new XAttribute("url", "http://localhost:63000/AdventureSearch/DisplayPicture.aspx?id=" + model.Products.FirstOrDefault().ProductID + "&size=small")), // add enclosure if type == photos returnPhotos ? new XElement("enclosure", new XAttribute("type", "image/jpeg"), new XAttribute("url", "http://localhost:63000/AdventureSearch/DisplayPicture.aspx?id=" + model.Products.FirstOrDefault().ProductID + "&size=large")) : null, // add custom property new XElement(nsExample + "color", model.Products.FirstOrDefault().Color), new XElement(nsExample + "copyright", model.CatalogDescription.Element(nsDescription + "Manufacturer").Element(nsDescription + "Copyright").Value), new XElement(nsExample + "company", model.CatalogDescription.Element(nsDescription + "Manufacturer").Element(nsDescription + "Name").Value) ) ) ) ); XmlTextWriter writer = new XmlTextWriter(Response.Output); writer.Formatting = Formatting.Indented; xml.WriteTo(writer); writer.Close(); } catch (Exception ex) { Response.Redirect("readme.txt"); Debug.WriteLine(ex.Message); Debug.WriteLine("Did you forget to set up the AdventureWorks SQL Database?"); } }