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();
}
