/// <summary>
/// Get all items available in stock
/// </summary>
/// <param name="items">list of items to be returned</param>
/// <returns>whether call to DB was successful or not</returns>
public bool GetItems(out List <ItemModel> items)
{
bool success = false;
items = new List <ItemModel>();
try {
using (ShoppingCartEntities context = new ShoppingCartEntities())
{
items = context.Items
.Where(i => i.Quantity != 0) //Get available items only
.Select(i => new ItemModel()
{
ID = i.ID,
Name = i.Name,
Description = i.Description,
Quantity = i.Quantity,
Price = i.Price
})
.ToList();
}
success = true;
}
catch (Exception ex)
{
new Logging().LogProgress(token, Common.CallerIP, ex);
}
return(success);
}
/// <summary>
/// 2018/12/17 Vaishnavi Soni
/// Delete an existing product category
/// </summary>
/// <returns>int</returns>
public int DeleteCategory(Category categoryModel)
{
try
{
using (ShoppingCartEntities db = new ShoppingCartEntities())
{
var categoryToDelete = db.Category.FirstOrDefault(em => em.CategoryId == categoryModel.CategoryId);
if (categoryToDelete != null)
{
db.Category.Remove(categoryToDelete);
return(db.SaveChanges());
}
else
{
//if not available to be deleted
return(-1);
}
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
throw ex;
}
}
public ActionResult Cart()
{
DisplayOrderDetailsVM cdList = new DisplayOrderDetailsVM();
cdList.CDVM = new List <CartDetailsViewModel>();
if (Session["cart"] != null)
{
DisplayOrderDetailsVM cartIds = (DisplayOrderDetailsVM)Session["cart"]; //type casting
using (ShoppingCartEntities db = new ShoppingCartEntities())
{
CartDetailsViewModel cd = new CartDetailsViewModel();
foreach (var item in cartIds.CDVM)
{
cd = db.tblProductDetails.Where(c => c.id == item.ProductId).Select(c => new CartDetailsViewModel
{
ProductName = c.productName,
Description = c.description,
Id = c.id,
ImagePath = c.imagePath,
Price = c.price,
ProductId = c.productId,
Quantity = item.Quantity,
TotalPrice = item.Quantity * c.price
}).FirstOrDefault();
cdList.CDVM.Add(cd);
}
}
}
return(View(cdList.CDVM));
}
public UserDatabase()
{
shoppingCartEntities = new ShoppingCartEntities();
var roleMapRoleBasicConfig = new MapperConfiguration(cfg => {
cfg.CreateMap <Role, RoleDTO>();
});
var userDTOMapUserConfig = new MapperConfiguration(cfg =>
{
cfg.CreateMap <UserDTO, User>();
});
var userMapUserDTOConfig = new MapperConfiguration(cfg => {
cfg.CreateMap <User, UserDTO>();
});
var userMapUserBasicDTOConfig = new MapperConfiguration(cfg => {
cfg.CreateMap <User, UserBasicDTO>();
});
userMapUserDTOMapper = new Mapper(userMapUserDTOConfig);
userMapUserBasicDTOMapper = new Mapper(userMapUserBasicDTOConfig);
roleMapRoleBasicDTOMapper = new Mapper(roleMapRoleBasicConfig);
userDTOMapUserMapper = new Mapper(userDTOMapUserConfig);
}
public IEnumerable <Item> GetItems()
{
using (ShoppingCartEntities itms = new ShoppingCartEntities())
{
return(itms.Items.ToList());
}
}
public void removeOldVisits(DateTime now)
{
ShoppingCartEntities db = new ShoppingCartEntities();
var prodVisits = db.ProductVisits;
DateTime oneHourAgo = DateTime.Now.AddHours(-1);
List <ProductVisit> oldProdVisits = db.ProductVisits.Where(pv => DateTime.Compare((DateTime)pv.updated, oneHourAgo) < 0).ToList();
//Remove from Visit and ProductVisit sessions that are older than 1 hour
foreach (var pv in oldProdVisits)
{
var prodVisit = db.ProductVisits.Where(prodv => prodv.sessionID == pv.sessionID).FirstOrDefault();
if (prodVisit != null)
{
db.ProductVisits.Remove(prodVisit);
var visit = db.Visits.Where(v => v.sessionID == prodVisit.sessionID).FirstOrDefault();
if (visit != null)
{
db.Visits.Remove(visit);
}
}
}
//Remove Visits that are older than 1 hour (sessions that didn't add anything to a cart)
var Visits = db.Visits;
List <Visit> oldVisits = db.Visits.Where(v => DateTime.Compare((DateTime)v.started, oneHourAgo) < 0).ToList();
if (oldVisits.Count() > 0)
{
db.Visits.RemoveRange(oldVisits);
}
db.SaveChanges();
}
public void SaveProductVisit(string sessionID, int productID, string productName, decimal price, int qty)
{
// reference db
ShoppingCartEntities context = new ShoppingCartEntities();
// If item is already in the cart, update qty
// othherwise, just toss that item into the cart
ProductVisit row = context.ProductVisits.Find(sessionID, productID);
if (row == null)
{
// create and initialize the ProductVisit object
ProductVisit pv = new ProductVisit();
pv.sessionID = sessionID;
pv.productID = productID;
pv.qtyOrdered = qty;
pv.updated = DateTime.Now;
context.ProductVisits.Add(pv);
}
else
{
row.qtyOrdered = qty;
row.updated = DateTime.Now;
}
// commit
context.SaveChanges();
}
/// <summary>
/// 2018/12/18 Deepanjali Yadav
/// Delete an existing product
/// </summary>
/// <returns>int</returns>
public int DeleteProduct(Product product)
{
try
{
using (ShoppingCartEntities db = new ShoppingCartEntities())
{
var ProductId = new SqlParameter("@ProductId", product.ProductId);
var ProductToDelete = db.Product.FirstOrDefault(em => em.ProductId == product.ProductId);
if (ProductToDelete != null)
{
//ExecuteSqlCommand returns int value i.e no of rows affected
int flag = db.Database.ExecuteSqlCommand("STP_DeleteProduct @ProductId", ProductId);
return(flag);
}
else
{
//if not available to be deleted
return(-1);
}
}
}
catch (System.Exception ex)
{
objErrorLogger.ErrorLog(ex);
throw ex;
}
}
public ActionResult Shipping(ShippingViewModel objship)
{
DisplayOrderDetailsVM ids = new DisplayOrderDetailsVM();
if (Session["Cart"] != null)
{
ids = (DisplayOrderDetailsVM)Session["Cart"];
ids.SVM = objship;
}
using (ShoppingCartEntities objdb = new ShoppingCartEntities())
{
tblCustomerDetail objtblcd = new tblCustomerDetail();
tblItemQuantity objtbliq = new tblItemQuantity();
objtblcd.customerName = ids.SVM.CustomerName;
objtblcd.customerAddress = ids.SVM.Address;
objtblcd.mobile = ids.SVM.Mobile;
objdb.tblCustomerDetails.Add(objtblcd);
objdb.SaveChanges();
foreach (var i in ids.CDVM)
{
objtbliq.itemId = i.ProductId;
objtbliq.Quantity = i.Quantity;
objtbliq.customerId = objtblcd.customerId;
objdb.tblItemQuantities.Add(objtbliq);
objdb.SaveChanges();
}
return(Json(new { msg = "Order Placed", Url = "/Home/HomePage" }, JsonRequestBehavior.AllowGet));
}
}
public CartProduct getProduct(int id)
{
ShoppingCartEntities db = new ShoppingCartEntities();
CartProduct product = db.CartProducts.Where(p => p.productID == id).FirstOrDefault();
return(product);
}
public IEnumerable <ProductVisit> getProductVisit(string sessionId)
{
ShoppingCartEntities db = new ShoppingCartEntities();
var prodVisit = db.ProductVisits
.Where(pv => pv.sessionID == sessionId);
return(prodVisit);
}
public List <Product> ViewProducts()
{
// reference db
ShoppingCartEntities context = new ShoppingCartEntities();
// query and return all products
return(context.Products.ToList());
}
public Visit getVisit(string id)
{
ShoppingCartEntities db = new ShoppingCartEntities();
Visit visit = db.Visits
.Where(v => v.sessionID == id)
.FirstOrDefault();
return(visit);
}
// POST api/values
public HttpResponseMessage Post([FromBody] Item item)
{
using (ShoppingCartEntities itms = new ShoppingCartEntities())
{
itms.Items.Add(item);
itms.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.Created));
}
}
public ActionResult HomePage()
{
using (ShoppingCartEntities db = new ShoppingCartEntities())
{
var result = db.tblProductDetails.ToList();
return(View(result));
}
}
public Item GetByID(int id)
{
using (ShoppingCartEntities itms = new ShoppingCartEntities())
{
Item item = itms.Items.FirstOrDefault(i => i.Item_ID == id);
return(item);
}
}
public Product GetProduct(int productID)
{
// reference db
ShoppingCartEntities context = new ShoppingCartEntities();
// query info on ProductID
var product = context.Products.Find(productID);
return(product);
}
// GET: Home
public ActionResult Index()
{
var db = new ShoppingCartEntities();
ViewBag.categories = db.Categories.ToList();
ViewBag.brands = db.Brands.Where(b => b.Products.Count > 0);
ViewBag.products = db.Products.ToList();
return(View());
}
public Visit GetVisit(string sessionID)
{
// reference db
ShoppingCartEntities context = new ShoppingCartEntities();
// query and return info on sessionID
var session = context.Visits.Find(sessionID);
return(session);
}
public AddressDatabaseContext()
{
shoppingCartEntities = new ShoppingCartEntities();
var Config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <AddressDTO, Address>();
});
AddressMapper = new Mapper(Config);
}
/// <summary>
/// Add item to cart
/// </summary>
/// <param name="cartItem">item to be added in cart</param>
/// <returns>whether the task was succesful or not</returns>
public bool AddCartItem(CartItemModel cartItem, out HttpStatusCode status)
{
bool success = false;
status = HttpStatusCode.OK;
try
{
CartItem newCartItem = new CartItem();
newCartItem.CartId = cartItem.CartId;
newCartItem.ItemId = cartItem.ItemId;
newCartItem.Quantity = cartItem.Quantity;
using (ShoppingCartEntities context = new ShoppingCartEntities())
{
//check if item already exists in cart
CartItem cartExists = context.CartItems
.Include("Item")
.Where(c => c.ItemId == newCartItem.ItemId && c.CartId == newCartItem.CartId)
.FirstOrDefault();
if (cartExists == null)
{
//Add new item to car
context.CartItems.Add(newCartItem);
context.SaveChanges();
success = true;
}
else
{
if (cartExists.Quantity + newCartItem.Quantity > cartExists.Item.Quantity)
{
//HTTP 410 - Not enough quantity in stock
status = HttpStatusCode.Gone;
}
else
{
//Update quantity of item in cart
cartExists.Quantity += newCartItem.Quantity;
context.CartItems.Attach(cartExists);
context.Entry(cartExists).State = EntityState.Modified;
context.SaveChanges();
success = true;
}
}
}
}
catch (Exception ex)
{
new Logging().LogProgress(token, Common.CallerIP, ex);
}
return(success);
}
public ActionResult MyCart()
{
ShoppingCartEntities db = new ShoppingCartEntities();
SessionHelper session = new SessionHelper();
string id = session.SessionID;
CartItemRepo cir = new CartItemRepo();
return(View(cir.GetCartItemsBySession(id)));
}
public void removeProductVisit(string sessionId)
{
ShoppingCartEntities db = new ShoppingCartEntities();
var prodVisit = (from pv in db.ProductVisits where pv.sessionID == sessionId select pv);
if (prodVisit.Count() > 0)
{
db.ProductVisits.RemoveRange(prodVisit);
db.SaveChanges();
}
}
public ActionResult MyRegister(Customer customer)
{
if (ModelState.IsValid)
{
using (ShoppingCartEntities db = new ShoppingCartEntities())
{
db.Customers.Add(customer);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
public void removeVisit(string id)
{
ShoppingCartEntities db = new ShoppingCartEntities();
var visit = (from v in db.Visits where v.sessionID == id select v).FirstOrDefault();
if ((from vis in db.Visits where vis.sessionID == id select vis).Count() > 0)
{
var productVisits = db.ProductVisits.Where(pv => pv.sessionID == visit.sessionID);
db.ProductVisits.RemoveRange(productVisits);
db.Visits.Remove(visit);
db.SaveChanges();
}
}
public int GetProductQty(string sessionID, int productID)
{
ShoppingCartEntities context = new ShoppingCartEntities();
ProductVisit p = context.ProductVisits.Find(sessionID, productID);
if (p == null)
{
return(1);
}
else
{
return((int)p.qtyOrdered);
}
}
public void addVisit(string id, DateTime start)
{
ShoppingCartEntities db = new ShoppingCartEntities();
Visit visit = new Visit();
var prevVisit = db.Visits.SingleOrDefault(v => v.sessionID == id);
if (prevVisit == null)
{
visit.sessionID = id;
visit.started = start;
db.Visits.Add(visit);
db.SaveChanges();
}
}
public ShoppingCartEntities InsertProductContext(ShoppingCartEntities context, Product product, int count, int commitCount, bool recreateContext)
{
context.Set <Product>().Add(product);
if (count % commitCount == 0)
{
context.SaveChanges();
if (recreateContext)
{
context.Dispose();
context = new ShoppingCartEntities();
context.Configuration.AutoDetectChangesEnabled = false;
}
}
return(context);
}
public ActionResult Add(int id)
{
if (TempData["error"] != null)
{
ViewBag.Error = TempData["error"].ToString();
}
CartProductRepo products = new CartProductRepo();
ShoppingCartEntities db = new ShoppingCartEntities();
SessionHelper session = new SessionHelper();
//Stores qty of product added in the cart for display in the view
var prodVisit = db.ProductVisits.Where(pv => pv.productID == id && pv.sessionID == session.SessionID).FirstOrDefault();
ViewBag.Qty = (prodVisit != null) ? prodVisit.qtyOrdered : 1;
return(View(products.getProduct(id)));
}
public OrderDatabaseContext()
{
shoppingCartEntities = new ShoppingCartEntities();
var OrdersConfig = new MapperConfiguration(cfg => {
cfg.CreateMap <Order, OrderDTO>();
cfg.CreateMap <OrderPlaced, OrderProductDTO>();
cfg.CreateMap <OrderPlacedVariant, OrderPlacedVariantDTO>();
cfg.CreateMap <Variant, VariantDTO>();
cfg.CreateMap <VariantImage, VariantImageDTO>();
cfg.CreateMap <Address, AddressDTO>();
cfg.CreateMap <Product, ProductDTO>();
cfg.CreateMap <Category, CategoryProductDTO>();
});
OrderMapper = new Mapper(OrdersConfig);
}
