public List <PricelistItem> GetCompatibleItems([QueryString("pricelistItemID")] int?pricelistItemId,
[RouteData] string reference)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <PricelistItem> query = _db.PricelistItems;
if (pricelistItemId.HasValue && pricelistItemId > 0)
{
query = query.Where(p => p.PricelistItemID == pricelistItemId);
}
else if (!String.IsNullOrEmpty(reference))
{
query = query.Where(p =>
String.Compare(p.Reference, reference) == 0);
}
else
{
query = null;
}
var tmp = query.Select(p => p.CompatibleItems);
List <PricelistItem> result = new List <PricelistItem>();
foreach (var list in tmp)
{
foreach (var item in list)
{
result.Add(_db.PricelistItems.Find(item));
}
}
return(result);
}
public IQueryable <Category> GetCategories()
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Category> query = _db.Categories;
return(query);
}
public IQueryable <QnA> GetQuestions()
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <QnA> query = _db.QuestionsAndAnswers;
return(query);
}
public IQueryable <Rank> GetIntRanks()
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Rank> ranks = _db.Ranks;
return(ranks);
}
public IQueryable <PricelistItem> GetPricelist()
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <PricelistItem> query = _db.PricelistItems;
return(query);
}
public IQueryable <Purpose> GetPurposes()
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Purpose> query = _db.Purposes;
return(query.OrderBy(p => p.PurposeName));
}
public IQueryable <Bundle> GetBundles()
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Bundle> query = _db.Bundles;
return(query);
}
public IQueryable <Category> GetServiceCategories()
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Category> query = _db.Categories;
query = query.Where(p => p.Type == "SERVICE").OrderBy(p => p.CategoryName);
return(query);
}
protected void Page_Load(object sender, EventArgs e)
{
string plId = Request.QueryString["pricelistItemID"];
int pricelistItemId;
string tpId = Request.QueryString["templateID"];
int templateId;
string blId = Request.QueryString["bundleID"];
int bundleId;
string qnt = Request.QueryString["quantity"];
int quantity;
if (!String.IsNullOrEmpty(qnt) && int.TryParse(qnt, out quantity))
{
if (!String.IsNullOrEmpty(plId) && int.TryParse(plId, out pricelistItemId))
{
using (ShoppingCartActions usersShoppingCart = new ShoppingCartActions())
{
usersShoppingCart.AddToCart(Convert.ToInt16(plId), quantity);
}
Response.Redirect("Pricelist.aspx");
}
else if (!String.IsNullOrEmpty(tpId) && int.TryParse(tpId, out templateId))
{
using (ShoppingCartActions usersShoppingCart = new ShoppingCartActions())
{
var _db = new BomShopping2.Data.BomShoppingContext();
var query = _db.Templates.Find(templateId);
foreach (PricelistItem i in query.Items)
{
usersShoppingCart.AddToCart(Convert.ToInt16(i.PricelistItemID), quantity);
}
}
Response.Redirect("TemplateList.aspx");
}
else if (!String.IsNullOrEmpty(blId) && int.TryParse(blId, out bundleId))
{
using (ShoppingCartActions usersShoppingCart = new ShoppingCartActions())
{
var _db = new BomShopping2.Data.BomShoppingContext();
var query = _db.Bundles.Find(bundleId);
foreach (Template t in query.Templates)
{
foreach (PricelistItem i in t.Items)
{
usersShoppingCart.AddToCart(Convert.ToInt16(i.PricelistItemID), quantity);
}
}
}
Response.Redirect("BundleList.aspx");
}
}
else
{
Debug.Fail("ERROR : We should never get to AddToCart.aspx without a pricelistItemID.");
throw new Exception("ERROR : It is illegal to load AddToCart.aspx without setting a pricelistItemID.");
}
Response.Redirect("ShoppingCart.aspx");
}
public IQueryable <Template> GetTemplate([QueryString("templateID")] int?templateId)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Template> query = _db.Templates;
if (templateId.HasValue && templateId > 0)
{
query = query.Where(p => p.TemplateID == templateId);
}
else
{
query = null;
}
return(query);
}
public List <PricelistItem> GetItems([QueryString("bundleID")] int?bundleId)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Bundle> query = _db.Bundles;
if (bundleId.HasValue && bundleId > 0)
{
query = query.Where(p => p.BundleID == bundleId);
}
else
{
query = null;
}
return(query.FirstOrDefault().GetPricelistItems());
}
public IQueryable <Bundle> GetBundle([QueryString("bundleID")] int?bundleId)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Bundle> query = _db.Bundles;
if (bundleId.HasValue && bundleId > 0)
{
query = query.Where(p => p.BundleID == bundleId);
}
else
{
query = null;
}
return(query);
}
public IQueryable <NewsRelease> GetLastNews([QueryString("Region")] string region)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <NewsRelease> query = _db.News;
if (!String.IsNullOrEmpty(region))
{
query = query.Where(p => p.Region == region);
}
else
{
query = query.Where(p => p.Region == "EU");
}
return(query);
}
public IQueryable <Bundle> GetBundles([QueryString("rank")] int?rank, [RouteData] string rankName)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Bundle> query = _db.Bundles;
if (rank.HasValue && rank > 0)
{
query = query.Where(p => p.Rank.Value == rank);
}
if (!String.IsNullOrEmpty(rankName))
{
query = query.Where(p =>
String.Compare(p.Rank.Name,
rankName) == 0);
}
return(query);
}
public IQueryable <Template> GetTemplates([QueryString("purposeID")] int?purposeId, [RouteData] string purposeName)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <Template> query = _db.Templates;
if (purposeId.HasValue && purposeId > 0)
{
query = query.Where(p => p.PurposeID == purposeId);
}
if (!String.IsNullOrEmpty(purposeName))
{
query = query.Where(p =>
String.Compare(p.Purpose.PurposeName,
purposeName) == 0);
}
return(query);
}
public IQueryable <PricelistItem> GetPricelist([QueryString("categoryID")] int?categoryId, [RouteData] string categoryName)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <PricelistItem> query = _db.PricelistItems;
if (categoryId.HasValue && categoryId > 0)
{
query = query.Where(p => p.CategoryID == categoryId);
}
if (!String.IsNullOrEmpty(categoryName))
{
query = query.Where(p =>
String.Compare(p.Category.CategoryName,
categoryName) == 0);
}
return(query);
}
public IQueryable <PricelistItem> GetPricelistItem([QueryString("pricelistItemID")] int?pricelistItemId,
[RouteData] string reference)
{
var _db = new BomShopping2.Data.BomShoppingContext();
IQueryable <PricelistItem> query = _db.PricelistItems;
if (pricelistItemId.HasValue && pricelistItemId > 0)
{
query = query.Where(p => p.PricelistItemID == pricelistItemId);
}
else if (!String.IsNullOrEmpty(reference))
{
query = query.Where(p =>
String.Compare(p.Reference, reference) == 0);
}
else
{
query = null;
}
return(query);
}
