public ProductDB GetProductByModelNumber(string modelNumber) { using (var context = new ECommerceDB()) { return(context.productDB.FirstOrDefault(x => x.ModelNumber == modelNumber)); } }
public void CreateNewUser(RegisterDB register) { using (var context = new ECommerceDB()) { context.registerDB.Add(register); context.SaveChanges(); } }
public List <RegisterDB> GetRegisteredUsersList() { using (var context = new ECommerceDB()) { var listOfUsers = context.registerDB.ToList(); return(listOfUsers); } }
public bool CheckUserProductListDb(string email) { using (var context = new ECommerceDB()) { if (context.userProductDBModels.Any(x => x.Email == email)) { return(true); } return(false); } }
public ActionResult Index(int?id) { int currentPage = (id.HasValue) ? id.Value : 1; // shorter version of if/else - turnary operator, ?: const int ProdsPerPage = 2; ECommerceDB db = new ECommerceDB(); List <Product> prods = db.Products.OrderBy(p => p.Name).Skip((currentPage - 1) * ProdsPerPage).Take(ProdsPerPage).ToList(); //cast to avoid integer division, & round up to nearest whole number ViewBag.MaxPage = Math.Ceiling(db.Products.Count() / (double)ProdsPerPage); ViewBag.CurrentPage = currentPage; return(View(prods)); }
public ActionResult Edit(int id) { using (var db = new ECommerceDB()) { var category = db.ProductCategories.FirstOrDefault(x => x.Id == id); var model = new ViewModels.ProductCategoryEditViewModel { CategoryId = category.Id, Name = category.Name }; return(View(model)); } }
// GET: Category public ActionResult Index() { var model = new ProductCategoryViewModel(); using (var db = new ECommerceDB()) { model.CategoriesList.AddRange(db.ProductCategories.Select(x => new ProductCategoryViewModel.CategoryListViewModel { CategoryId = x.Id, Name = x.Name })); return(View(model)); } }
public AddressDB GetBillingAddress(AddressDTO addressDTO) { var addressDB = new AddressDB(); using (var context = new ECommerceDB()) { if (context.addressDB.Any(x => x.Email == addressDTO.Email)) { return(context.addressDB.FirstOrDefault(x => x.Email == addressDTO.Email)); } else { return(null); } } }
public List <UserProductDBModel> GetUserProductsDB(string email) { using (var context = new ECommerceDB()) { List <UserProductDBModel> userProductList = context.userProductDBModels.Where(x => x.Email == email).ToList(); if (userProductList != null) { return(userProductList); } else { return(null); } } }
public ProductDTO PurchaseProduct(ProductDTO productDTO) { ProductDB product = new ProductDB(); UserProductDBModel userProductDBModel = new UserProductDBModel(); ProductDTO productDTOObj = new ProductDTO(); using (var context = new ECommerceDB()) { if (context.productDB.Any(x => x.ModelNumber == productDTO.ModelNumber)) { product = context.productDB.FirstOrDefault(x => x.ModelNumber == productDTO.ModelNumber); if ((product.AvailableQuantity > productDTO.RequiredQuantity) && productDTO.RequiredQuantity != 0) { product.AvailableQuantity -= productDTO.RequiredQuantity; context.SaveChanges(); productDTOObj.ModelNumber = productDTO.ModelNumber; productDTOObj.Price = productDTO.Price; productDTOObj.Description = productDTO.Description; productDTOObj.AvailableQuantity = productDTO.AvailableQuantity; productDTOObj.RequiredQuantity = productDTO.RequiredQuantity; productDTOObj.DeliveryTime = productDTO.DeliveryTime; userProductDBModel.Email = productDTO.Email; userProductDBModel.ModelNumber = productDTO.ModelNumber; userProductDBModel.RequiredQuantity = productDTO.RequiredQuantity; userProductDBModel.Price = productDTO.Price; userProductDBModel.Description = productDTO.Description; userProductDBModel.DeliveryTime = productDTO.DeliveryTime; context.userProductDBModels.Add(userProductDBModel); context.SaveChanges(); return(productDTOObj); } return(null); } return(null); } }