public void AddToCart(CurrentProductDTO prod, int UserID)
{
ModelAW db = new ModelAW();
ShoppingCartItem cart = new ShoppingCartItem()
{
ProductID = prod.ProductID,
ShoppingCartID = UserID.ToString(),
ModifiedDate = DateTime.Now,
DateCreated = DateTime.Now,
Quantity = prod.Count
};
db.ShoppingCartItems.Add(cart);
db.SaveChanges();
}
public CurrentProductDTO Get(int id)
{
IEnumerable <CurrentProductDTO> product = from ProductProductPhoto PPI in db.ProductProductPhotoes
join Product Prod in db.Products on PPI.ProductID equals Prod.ProductID
join ProductPhoto Photo in db.ProductPhotoes on PPI.ProductPhotoID equals Photo.ProductPhotoID
where Prod.ProductID == id
select new CurrentProductDTO
{
ProductID = Prod.ProductID,
ProductName = Prod.Name,
LargePhoto = Photo.LargePhoto,
ModelID = Prod.ProductModelID,
Class = Prod.Class,
Size = Prod.Size,
Color = Prod.Color,
ProductNumber = Prod.ProductNumber,
SizeUnit = Prod.SizeUnitMeasureCode,
ProductLine = Prod.ProductLine,
Weight = Prod.Weight,
Style = Prod.Style
};
CurrentProductDTO fullInfo = product.FirstOrDefault();
if (fullInfo.ModelID != null)
{
IEnumerable <CurrentProductDTO> Model = from ProductModelProductDescriptionCulture info in db.ProductModelProductDescriptionCultures
join ProductModel model in db.ProductModels on info.ProductModelID equals model.ProductModelID
join ProductDescription desk in db.ProductDescriptions on info.ProductDescriptionID equals desk.ProductDescriptionID
where model.ProductModelID == fullInfo.ModelID && info.CultureID == "en"
select new CurrentProductDTO
{
Model = model.Name,
Description = desk.Description
};
fullInfo.Model = Model.Select(m => m.Model).FirstOrDefault();
fullInfo.Description = Model.Select(m => m.Description).FirstOrDefault();
}
fullInfo.InventoryQ = db.ProductInventories.Where(m => m.ProductID == fullInfo.ProductID).Sum(m => m.Quantity);
return(fullInfo);
}