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?");
}
}
