private void Page_Load(object sender, System.EventArgs e) { string param = Request.QueryString["img"]; string pic_id = param.Substring(0, param.Length - 5); char pic_size = param[pic_id.Length]; Binary pic; AggDataContext db = new AggDataContext(); AggImage image = db.AggImages.Single(i => i.img_id == Int32.Parse(pic_id)); switch (pic_size) { case ('s'): pic = image.img_small; break; case ('m'): pic = image.img_medium; break; case ('l'): pic = image.img_large; break; default: pic = null; break; } Response.ContentType = "image/jpeg"; Response.BinaryWrite(pic.ToArray()); }
protected void lvMainPageCategories_ItemDataBound(object sender, ListViewItemEventArgs e) { ListViewDataItem dataItem = (ListViewDataItem)e.Item; AggCategory c = (AggCategory)dataItem.DataItem; AggDataContext db = new AggDataContext(); string img_format = "s.jpg"; string navigateUrl = "~/Search.aspx?ucid=" + c.cat_id; string imageUrl = "~/ViewImage.aspx?img="; HyperLink cat_link1 = (HyperLink)e.Item.FindControl("cat_link1"); cat_link1.NavigateUrl = navigateUrl; HyperLink cat_link2 = (HyperLink)e.Item.FindControl("cat_link2"); cat_link2.NavigateUrl = navigateUrl; Literal cat_name = (Literal)e.Item.FindControl("cat_name"); cat_name.Text = c.cat_name; Image cat_img = (Image)e.Item.FindControl("cat_img"); cat_img.ImageUrl = imageUrl + db.AggProducts.Where(p => p.cat_id == c.cat_id).First().img_id + img_format; }
private void ShowStats(bool validString, bool validUcid, bool validCid, bool validMid, string searchString, int ucid, int cid, int mid) { AggDataContext db = new AggDataContext(); ltStats.Text = "Found " + howManyResults + " product(s)"; if (validString) { ltStats.Text += " for "" + Server.HtmlEncode(searchString) + """; } if (howManyResults > 0) { if (validMid) { ltStats.Text += ", by " + db.AggManufacters.Single(m => m.man_id == mid).man_name; } if (validUcid) { if (ucid == -1) { ltStats.Text += " in all categories"; } else { ltStats.Text += " in category "" + db.AggCategories.Single(c => c.cat_id == ucid).cat_name.ToLower() + """; } } else if (validCid) { ltStats.Text += " in category "" + db.AggCategories.Single(c => c.cat_id == cid).cat_name.ToLower() + """; } } ltStats.Text += "."; }
private void InitDdlFilterManufacter() { AggDataContext db = new AggDataContext(); ddlFilterManufacter.DataSource = db.AggManufacters.Select(m => m).OrderBy(m => m.man_name); ddlFilterManufacter.DataBind(); ddlFilterManufacter.Items.Insert(0, new ListItem("All Manufacters", "0")); }
private void InitDdlFilterCategory() { AggDataContext db = new AggDataContext(); ddlFilterCategory.DataSource = db.AggCategories.Select(c => c).OrderBy(c => c.cat_name); ddlFilterCategory.DataBind(); ddlFilterCategory.Items.Insert(0, new ListItem("All Categories", "0")); }
private object LoadCategoriesForLinks() { AggDataContext db = new AggDataContext(); return(from c in db.AggCategories orderby c.cat_name select new { cat_url = "Search.aspx?ucid=" + c.cat_id, cat_name = c.cat_name }); }
private IQueryable <AggProduct> LoadProdDetail(int prodId) { AggDataContext db = new AggDataContext(); return(from p in db.AggProducts where p.prod_id == prodId select p); }
private void InitLvFeatProd() { AggDataContext db = new AggDataContext(); lvFeatProd.DataSource = (from p in db.AggProducts orderby db.Random() select p).Take(4); lvFeatProd.DataBind(); }
protected void Page_Init(object sender, EventArgs e) { Session["mainPage"] = "home"; Session["subPage"] = "homeHome"; AggDataContext db = new AggDataContext(); lvMainPageCategories.DataSource = db.AggCategories.OrderBy(c => c.cat_name); lvMainPageCategories.DataBind(); }
private void ShowAllProducts() { AggDataContext db = new AggDataContext(); var v = db.AggProducts.Select(p => p); lvProducts.DataSource = v; lvProducts.DataBind(); }
private void InitBlCatNavBar() { AggDataContext db = new AggDataContext(); var v = db.AggCategories.OrderBy(c => c.cat_name); blCatNavBar.DataSource = LoadCategoriesForLinks(); blCatNavBar.DataBind(); blCatNavBar.Items.Insert(0, new ListItem("All Categories", "Search.aspx?ucid=-1")); }
internal static IQueryable <AggCategory> SearchCategories(params int[] ids) { var predicate = SearchEngine.False <AggCategory>(); AggDataContext db = new AggDataContext(); foreach (int id in ids) { int temp = id; predicate = predicate.Or(x => x.cat_id.Equals(temp)); } return(db.AggCategories.Where(predicate).OrderBy(x => x.cat_name)); }
internal static IQueryable <AggProduct> SearchProducts(params string[] keywords) { var predicate = SearchEngine.False <AggProduct>(); AggDataContext db = new AggDataContext(); foreach (string keyword in keywords) { string temp = keyword; predicate = predicate.Or(p => p.prod_name.Contains(temp) || p.AggManufacter.man_name.Contains(temp)); } return(db.AggProducts.Where(predicate)); }
internal static IQueryable <AggProduct> FilterProductsByCategoryAndManufacter(string[] keywords, int cid, int mid) { var predicate = SearchEngine.False <AggProduct>(); AggDataContext db = new AggDataContext(); foreach (string keyword in keywords) { string temp = keyword; predicate = predicate.Or(p => (p.prod_name.Contains(temp) || p.AggManufacter.man_name.Contains(temp)) && (p.cat_id == cid) && (p.man_id == mid)); } return(db.AggProducts.Where(predicate)); }
internal static IQueryable <AggProduct> SearchProductsByIdWithoutOne(int[] ids, int notThisOne, byte limitResult) { var predicate = SearchEngine.False <AggProduct>(); AggDataContext db = new AggDataContext(); foreach (int id in ids) { int temp = id; predicate = predicate.Or(x => x.prod_id.Equals(temp) && x.prod_id != notThisOne); } //orderby stock to get more variety! return(db.AggProducts.Where(predicate).Take(limitResult)); }
private void ShowResultBasedOnUnsortingCategoryAndManufacter(int ucid, int mid) { AggDataContext db = new AggDataContext(); var v = db.AggProducts.Where(p => p.cat_id == ucid && p.man_id == mid); if (ucid == -1) { v = db.AggProducts.Where(p => p.man_id == mid); } lvProducts.DataSource = v; lvProducts.DataBind(); this.howManyResults = v.Count(); }
private void ShowResultBasedOn(int ucid) { AggDataContext db = new AggDataContext(); var v = db.AggProducts.Where(p => p.cat_id == ucid); if (ucid == -1) { v = db.AggProducts.Select(p => p); } lvProducts.DataSource = v; ShowOnlyRelevantManufacters(v); this.howManyResults = v.Count(); }