public void End()
{
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
var maxDateTimeThreshhold = DateTime.Now.AddMinutes(-1 * 2);
var expiredProductVisits = from ProductVisit in db.ProductVisits
where ProductVisit.updated <= maxDateTimeThreshhold
select ProductVisit;
if (expiredProductVisits != null)
{
foreach (ProductVisit productVisit in expiredProductVisits)
{
db.ProductVisits.Remove(productVisit);
}
db.SaveChanges();
}
var abandoneVisits = from v in db.Visits
where !db.ProductVisits.Any(pv => pv.sessionID == v.sessionID)
select v;
if (abandoneVisits != null)
{
foreach (Visit visit in abandoneVisits)
{
db.Visits.Remove(visit);
}
db.SaveChanges();
}
}
public ProductVM GetDetail(int id)
{
ProductVM CBAVM = new ProductVM();
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
var query =
from p in db.Products
where (p.productID == id)
select new
{
ProductID = p.productID,
ProductName = p.productName,
Price = (decimal)p.price,
};
foreach (var item in query)
{
CBAVM.ProductID = item.ProductID;
CBAVM.ProductName = item.ProductName;
CBAVM.Price = (decimal)item.Price;
CBAVM.Quantity = 1;
}
return(CBAVM);
}
public void Delete(string id)
{
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
Visit visit = db.Visits.Where(v => v.sessionID == id).FirstOrDefault();
db.Visits.Remove(visit);
db.SaveChanges();
}
public void Add()
{
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
SessionHelper sessionHelper = new SessionHelper();
Visit visit = new Visit();
visit.sessionID = sessionHelper.SessionID;
Delete(visit.sessionID);
visit.started = DateTime.Now;
db.Visits.Add(visit);
db.SaveChanges();
}
public ActionResult Cancel()
{
ProductVisitRepository productVisitRepository = new ProductVisitRepository();
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
SessionHelper sessionHelper = new SessionHelper();
string sessionid = sessionHelper.SessionID;
TempData["msg"] = "<script>alert('Are you sure that you want to remove all items from shopping cart?');</script>";
if (sessionid != null)
{
db.ProductVisits.Where(p => p.sessionID == sessionid).ToList().ForEach(p => db.ProductVisits.Remove(p));
}
db.SaveChanges();
return(View());
}
public ProductVM Getdetail(int id)
{
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
try {
ProductVM CBAVM = new ProductVM();
var query1 =
from p in db.Products
where (p.productID == id)
select new
{
ProductID = p.productID,
ProductName = p.productName,
Price = p.price,
};
foreach (var item in query1)
{
CBAVM.ProductID = item.ProductID;
CBAVM.ProductName = item.ProductName;
CBAVM.Price = (decimal)item.Price;
}
var query2 =
from pv in db.ProductVisits
where (pv.productID == id)
select new
{
Quantity = pv.qtyOrdered,
};
foreach (var item in query2)
{
CBAVM.Quantity = (int)item.Quantity;
}
if (CBAVM.Quantity == 0)
{
CBAVM.Quantity = 1;
}
else
{
}
return(CBAVM);
}
catch
{
return(null);
}
}
public bool Delete(int id, string sessionid)
{
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
ProductVisit productVisit = db.ProductVisits.Where(pv => pv.productID == id && pv.sessionID == sessionid).FirstOrDefault();
try
{
db.ProductVisits.Remove(productVisit);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public IEnumerable <ProductVM> GetAll()
{
IEnumerable <ProductVM> productSummary;
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
productSummary =
from p in db.Products
select new ProductVM()
{
ProductID = p.productID,
ProductName = p.productName,
Price = (decimal)p.price
};
return(productSummary);
}
public void Initialize()
{
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
// HttpContext.Current.Session[SESSION_START] = DateTime.Now;
try
{
Visit newVisit = new Visit();
newVisit.sessionID = SessionID;
newVisit.started = DateTime.Now;
db.Visits.Add(newVisit);
db.SaveChanges();
}
catch (Exception e)
{
}
}
public IEnumerable <ProductVisitVM> GetAll()
{
IEnumerable <ProductVisitVM> productVisitSummary;
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
productVisitSummary =
from p in db.Products
from pv in p.ProductVisits
where (p.productID == pv.productID)
select new ProductVisitVM()
{
ProductID = p.productID,
ProductName = p.productName,
Price = (decimal)p.price,
QtyOrdered = (int)pv.qtyOrdered
};
return(productVisitSummary);
}
public void Add(int id, int Quantity, string sessionid)
{
shoppingcartfaridehEntities db = new shoppingcartfaridehEntities();
try
{
ProductVisit productVisit = new ProductVisit();
SessionHelper sessionHelper = new SessionHelper();
sessionid = sessionHelper.SessionID;
// Delete(id, sessionid);
productVisit.productID = id;
productVisit.sessionID = sessionHelper.SessionID;
productVisit.updated = DateTime.Now;
productVisit.qtyOrdered = Quantity;
db.ProductVisits.Add(productVisit);
db.SaveChanges();
}
catch
{
}
}
