protected void Page_Load(object sender, EventArgs e) { string key = Request.Params["key"]; if (!string.IsNullOrEmpty(key)) { db = new lafien_products_dbEntities(); product = db.Products.Where(x => x.ProductID.ToUpper() == key.ToUpper()).FirstOrDefault(); if (product == null) { var tmp = db.ProductOwnerReferences.Where(x => x.RefProductID.ToUpper() == key.ToUpper()).FirstOrDefault(); if (tmp != null) { product = tmp.Product; mess = key + " reference to " + product.ProductName; noResult = false; } } else { noResult = false; } if (noResult == false) { productCat = db.ProductCategories.Where(x => x.Active == true).ToList(); } } }
protected void Page_Load(object sender, EventArgs e) { db = new lafien_products_dbEntities(); carCats = db.CarCategories.Where(x => x.CatLevel == 0).OrderBy(x => x.CatName).ToList(); ddlBrand.DataSource = carCats; ddlBrand.DataTextField = "CatName"; ddlBrand.DataValueField = "CatID"; ddlBrand.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string key = Request.Params["key"]; if (!string.IsNullOrEmpty(key)) { db = new lafien_products_dbEntities(); string[] tmps = key.Trim().Split('$'); string[] tmpClass = tmps[0].TrimEnd(";".ToCharArray()).Split(';'); List <int> carCats = new List <int>(); for (int i = 0; i < tmpClass.Length; i++) { int tmpValue = 0; if (Int32.TryParse(tmpClass[i], out tmpValue)) { carCats.Add(tmpValue); } } string[] tmpY = tmps[1].TrimEnd(";".ToCharArray()).Split(';'); List <int> carYears = new List <int>(); for (int i = 0; i < tmpY.Length; i++) { int tmpValue = 0; if (Int32.TryParse(tmpY[i], out tmpValue)) { carYears.Add(tmpValue); } } string[] tmpEngine = tmps[2].TrimEnd(";".ToCharArray()).Split(';'); string[] tmpBody = tmps[3].TrimEnd(";".ToCharArray()).Split(';'); cars = db.Cars.Where(x => carCats.Contains(x.CarCatID) && ((x.FromDate.Year <= carYears.Max() && x.ToDate == null) || (x.ToDate.Year >= carYears.Min() && x.FromDate.Year <= carYears.Max()))).ToList(); if (tmpEngine.Length > 0) { if (!string.IsNullOrEmpty(tmpEngine[0])) { cars = cars.Where(x => tmpEngine.Contains(x.Engine)).ToList(); } } if (tmpBody.Length > 0) { if (!string.IsNullOrEmpty(tmpBody[0])) { cars = cars.Where(x => tmpBody.Contains(x.Body)).ToList(); } } if (cars.Count == 0) { noResult = true; } else { noResult = false; } if (noResult == false) { productCat = db.ProductCategories.Where(x => x.Active == true).ToList(); } } }
protected void Page_Load(object sender, EventArgs e) { string key = Request.Params["key"]; if (!string.IsNullOrEmpty(key)) { db = new lafien_products_dbEntities(); string[] tmps = key.Trim().Split('$'); string[] tmpClass = tmps[0].TrimEnd(";".ToCharArray()).Split(';'); List<int> carCats = new List<int>(); for (int i = 0; i < tmpClass.Length; i++) { int tmpValue = 0; if (Int32.TryParse(tmpClass[i], out tmpValue)) carCats.Add(tmpValue); } string[] tmpY = tmps[1].TrimEnd(";".ToCharArray()).Split(';'); List<int> carYears = new List<int>(); for (int i = 0; i < tmpY.Length; i++) { int tmpValue = 0; if (Int32.TryParse(tmpY[i], out tmpValue)) carYears.Add(tmpValue); } string[] tmpEngine = tmps[2].TrimEnd(";".ToCharArray()).Split(';'); string[] tmpBody = tmps[3].TrimEnd(";".ToCharArray()).Split(';'); cars = db.Cars.Where(x => carCats.Contains(x.CarCatID) && ((x.FromDate.Year <= carYears.Max() && x.ToDate == null) || (x.ToDate.Year >= carYears.Min() && x.FromDate.Year <= carYears.Max()))).ToList(); if (tmpEngine.Length > 0) if (!string.IsNullOrEmpty(tmpEngine[0])) { cars = cars.Where(x => tmpEngine.Contains(x.Engine)).ToList(); } if (tmpBody.Length > 0) if (!string.IsNullOrEmpty(tmpBody[0])) { cars = cars.Where(x => tmpBody.Contains(x.Body)).ToList(); } if (cars.Count == 0) { noResult = true; } else { noResult = false; } if (noResult == false) { productCat = db.ProductCategories.Where(x => x.Active == true).ToList(); } } }