public void RemoveCartBySessionNoTime(string sessionID)
{
ShoppingCart743Entities context = new ShoppingCart743Entities();
Visit visitToRemove = context.Visits.Find(sessionID);
//only removes items if the updates were not done within the last hour
if (visitToRemove != null)
{
ProductVisit productVisit = (from pv in context.ProductVisits
where pv.sessionID == sessionID
select pv).FirstOrDefault();
DateTime updateTime = ((DateTime)productVisit.updated);
DateTime endTime = ((DateTime)productVisit.updated).AddMinutes(59);
var productVisitsToRemove = from pv in context.ProductVisits
where pv.sessionID == sessionID
select pv;
foreach (var product_Visit in productVisitsToRemove)
{
context.ProductVisits.Remove(product_Visit);
context.Visits.Remove(visitToRemove);
}
context.SaveChanges();
}
}
public void RemoveCartStartupCheck(string sessionID)
{
ShoppingCart743Entities context = new ShoppingCart743Entities();
Visit visitToRemove = (from p in context.Visits
where p.sessionID == sessionID
select p).FirstOrDefault();
if (visitToRemove != null)
{
var productVisitsToRemove = from pv in context.ProductVisits
where pv.sessionID == sessionID
select pv;
if (productVisitsToRemove != null)
{
foreach (var productVisit in productVisitsToRemove)
{
DateTime updateTime = ((DateTime)productVisit.updated);;
if (updateTime.AddMinutes(60) < DateTime.Now)
{
foreach (var productVisitB in productVisitsToRemove)
{
context.ProductVisits.Remove(productVisitB);
}
context.Visits.Remove(visitToRemove);
context.SaveChanges();
}
}
}
}
}
public void AddOrUpdateProductVisit(ProductVisit formProductVisit)
{
ShoppingCart743Entities context = new ShoppingCart743Entities();
ProductVisit dbProductVisit = (from pv in context.ProductVisits
where formProductVisit.sessionID == pv.sessionID && formProductVisit.productID == pv.productID
select pv).FirstOrDefault();
if (dbProductVisit != null)
{
dbProductVisit.productID = formProductVisit.productID;
dbProductVisit.qtyOrdered = formProductVisit.qtyOrdered;
dbProductVisit.sessionID = formProductVisit.sessionID;
dbProductVisit.updated = formProductVisit.updated;
//update the time for all of the session items
SessionHelper sessionHelper = new SessionHelper();
var dbProductVisits = (from pv in context.ProductVisits
where formProductVisit.sessionID == pv.sessionID
select pv);
foreach (ProductVisit productVisit in dbProductVisits)
{
productVisit.updated = sessionHelper.EndTime;
}
context.SaveChanges();
}
else
{
SessionHelper sessionHelper = new SessionHelper();
Visit visit = new Visit();
visit.started = sessionHelper.StartTime;
visit.sessionID = sessionHelper.SessionID;
Visit dbVisit = (from pv in context.Visits
where formProductVisit.sessionID == pv.sessionID
select pv).FirstOrDefault();
if (dbVisit == null)
{
context.Visits.Add(visit);
}
context.ProductVisits.Add(formProductVisit);
//update the session time for all of the sessions-- if the product, session ID combo doesn't exist
var dbProductVisits = (from pv in context.ProductVisits
where formProductVisit.sessionID == pv.sessionID
select pv);
foreach (ProductVisit productVisit in dbProductVisits)
{
productVisit.updated = sessionHelper.StartTime;
}
context.SaveChanges();
}
}
public ProductVisit GetCartItem(string sessionID, int productID)
{
ShoppingCart743Entities context = new ShoppingCart743Entities();
ProductVisit cartItem = (from pv in context.ProductVisits
where sessionID == pv.sessionID && pv.productID == productID
select pv).FirstOrDefault();
return(cartItem);
}
public IEnumerable <ProductVisit> GetCart(string sessionID)
{
ShoppingCart743Entities context = new ShoppingCart743Entities();
var cartContents = from pv in context.ProductVisits
where sessionID == pv.sessionID
select pv;
return(cartContents);
}
public IEnumerable <ProductVM> GetAllProducts()
{
ShoppingCart743Entities db = new ShoppingCart743Entities();
IEnumerable <ProductVM> products = from p in db.Products
select new ProductVM
{
ProductID = p.productID,
ProductName = p.productName,
Price = p.price,
};
return(products);
}
public void SendCartList(string sessionID, List <ProductVisitCartVM> cart)
{
ShoppingCart743Entities context = new ShoppingCart743Entities();
foreach (ProductVisitCartVM item in cart)
{
var customerCart = (from pv in context.ProductVisits
where sessionID == pv.sessionID && pv.productID == item.ProductID
select pv);
customerCart.FirstOrDefault().qtyOrdered = item.QtyOrdered;
}
context.SaveChanges();
}
public ProductVM GetProduct(int productID)
{
ShoppingCart743Entities context = new ShoppingCart743Entities();
ProductVM productVM = (from p in context.Products
where p.productID == productID
select new ProductVM
{
ProductID = p.productID,
ProductName = p.productName,
Price = p.price
}).FirstOrDefault();
return(productVM);
}
