Exemplo n.º 1
0
        public ActionResult DeleteConfirmed(int id)
        {
            productDetail productdetail = db.productDetails.Find(id);

            db.productDetails.Remove(productdetail);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ProductDetailsWithImages PutProductDetails(productDetail pd, productImage pi)
        {
            ProductDetailsWithImages finalModel = new ProductDetailsWithImages();

            finalModel.productdetails = pd;
            finalModel.productimages  = pi;
            return(finalModel);
        }
        public async Task <ActionResult> DeleteConfirmed(int id)
        {
            productDetail productDetail = await db.productDetails.FindAsync(id);

            db.productDetails.Remove(productDetail);
            await db.SaveChangesAsync();

            return(RedirectToAction("Index"));
        }
Exemplo n.º 4
0
        //
        // GET: /Admin/Delete/5

        public ActionResult Delete(int id = 0)
        {
            productDetail productdetail = db.productDetails.Find(id);

            if (productdetail == null)
            {
                return(HttpNotFound());
            }
            return(View(productdetail));
        }
Exemplo n.º 5
0
 public ActionResult Edit(productDetail productdetail)
 {
     if (ModelState.IsValid)
     {
         db.Entry(productdetail).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(productdetail));
 }
Exemplo n.º 6
0
        public ActionResult productList(string newProd, string Price, int id)
        {
            productDetail addProd = new productDetail {
                menuId = id, nameOfProduct = newProd, Price = Price
            };

            db.productDetails.Add(addProd);
            db.SaveChanges();
            return(Redirect("~/Menu/productList/" + id));
        }
Exemplo n.º 7
0
        public ActionResult Create(productDetail productdetail)
        {
            if (ModelState.IsValid)
            {
                db.productDetails.Add(productdetail);
                db.SaveChanges();
                return(RedirectToAction("AddNewImage"));
            }

            return(View(productdetail));
        }
        public async Task <ActionResult> Edit([Bind(Include = "pdid,productID,name,description,bprice,sprice,discountAllowed,discountReceived,date")] productDetail productDetail)
        {
            if (ModelState.IsValid)
            {
                db.Entry(productDetail).State = EntityState.Modified;
                await db.SaveChangesAsync();

                return(RedirectToAction("Index"));
            }
            ViewBag.productID = new SelectList(db.products, "pid", "name", productDetail.productID);
            return(View(productDetail));
        }
        // GET: productDetails/Details/5
        public async Task <ActionResult> Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            productDetail productDetail = await db.productDetails.FindAsync(id);

            if (productDetail == null)
            {
                return(HttpNotFound());
            }
            return(View(productDetail));
        }
        // GET: productDetails/Edit/5
        public async Task <ActionResult> Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            productDetail productDetail = await db.productDetails.FindAsync(id);

            if (productDetail == null)
            {
                return(HttpNotFound());
            }
            ViewBag.productID = new SelectList(db.products, "pid", "name", productDetail.productID);
            return(View(productDetail));
        }
Exemplo n.º 11
0
        public List <productDetail> getProductDetailsByOrder(int orderId)
        {
            List <productDetail> list = new List <productDetail>();

            context.products_by_order.ToList().ForEach(x =>
            {
                if (x.orderId == orderId)
                {
                    productDetail p = new productDetail(x.products);
                    p.quantity      = x.quantity;
                    list.Add(p);
                }
            });
            return(list);
        }
        public bool SaveProduct(ProductDetailsModel pod)
        {
            productDetail pd = new productDetail();

            pd.ProductName    = pod.ProductName;
            pd.ProductDetails = pod.ProductDetails;
            pd.ProductType    = pod.ProductType;
            _dbContext.productDetails.Add(pd);
            if (_dbContext.SaveChanges() == 1)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 13
0
        public ActionResult productDetail(int id)
        {
            Products pro = ctx.productBll.getOne(id);

            if (pro != null)
            {
                productDetail detail = new productDetail
                {
                    relatedProducts = ctx.productBll.getAll().Where(x => x.categoryID == pro.categoryID).Take(20).ToList(),
                    singleProduct   = pro,
                };
                return(View(detail));
            }
            else
            {
                return(PartialView("_error", "The Product is not Found"));
            }
        }
Exemplo n.º 14
0
        public void TC_AddProductToBasket([Values("ipad", "iphone")] string products)
        {
            test = extent.CreateTest("Test Case to Search " + products);

            var    homePage          = new home();
            var    loginPage         = new login(driver);
            var    searchPage        = new searchResults(driver);
            var    productDetailPage = new productDetail(driver);
            var    basketPage        = new basket(driver);
            string productNameCaptured;

            //Login to Amazon
            test.Log(Status.Info, "Login to Amamzon website");
            //Assert.IsTrue(homePage.verifyHomePage("Sign in"), "Amamzon home page is unavailable");
            AllClassesObjects aco = new AllClassesObjects();

            Assert.IsTrue(aco.homePage.verifyHomePage("Sign in"), "Amamzon home page is unavailable");
            homePage.clickOnSignIn();
            loginPage.setUser_email(ConfigurationManager.AppSettings.Get("email"));
            loginPage.clickOnContinue();
            loginPage.setUser_password(ConfigurationManager.AppSettings.Get("password"));
            loginPage.clickOnSubmit();
            Assert.IsTrue(homePage.verifyHomePage(ConfigurationManager.AppSettings.Get("user")), "User is not logged in");
            test.Log(Status.Info, "Login successfull");

            //Search the product in Amazon
            homePage.setSearch_Product(products);
            homePage.clickOnSearchBtn();
            productNameCaptured = searchPage.getFirstProductName();
            searchPage.verifyProductLandPage(products);
            test.Log(Status.Info, "The first product name from search list: " + productNameCaptured);
            searchPage.clickOnFirstProduct();

            //Add product to cart
            Assert.IsTrue(productDetailPage.verifyProduct(productNameCaptured), "Failed to verify the product: " + productNameCaptured);
            productDetailPage.clickOnAddToCartBtn();
            Assert.IsTrue(basketPage.verifyProductAddedToCart(), "Failed to add product to basket");
            test.Log(Status.Info, "Successfully added product to Basket");
        }
        public IActionResult Put(int id, [FromForm] IFormCollection data)
        {
            string customMessage = "";
            string fileName      = "";

            //create Product object
            Product newProduct = new Product()
            {
                productDetails       = new List <productDetail>(),
                productDiscountRates = new List <productDiscountRate>()
            };

            //Create a new productDetail and productDiscountRate object
            productDetail       foundOneProductDetail       = new productDetail();
            productDiscountRate foundOneProductDiscountRate = new productDiscountRate();

            //Cloudinary account
            //Account account = new Account(
            //    "singapore-polytechnic-csc-assignment-ca1",
            //    "475859446543313",
            //    "CQfmX8pn-pNZOFijjVn-nIhqKqs");
            //Cloudinary cloudinary = new Cloudinary(account);

            discountRate foundOneDiscountRate = new discountRate();

            try
            {
                var foundOneProd = Database.Products
                                   .SingleOrDefault(oneProd => oneProd.prodId == id);

                //    //Required Fields
                foundOneProd.prodName   = data["prodName"];
                foundOneProd.prodCode   = data["prodCode"];
                foundOneProd.prodImgUrl = null;
                foundOneProd.brandId    = Convert.ToInt32(data["brandId"]);
                foundOneProd.createdAt  = DateTime.Now;

                //    //Get File Path
                //    if (fileInput != null)
                //    {
                //        foreach (var file in fileInput)
                //        {
                //            fileName = Path.GetFullPath(file.FileName);
                //        }
                //    }

                //    //Image
                //    if (fileName != null)
                //    {
                //        var uploadParams = new ImageUploadParams()
                //        {
                //            File = new FileDescription(fileName)
                //        };
                //        var uploadResult = cloudinary.Upload(uploadParams);
                //    }

                //Optional Fields
                foundOneProd.guaranteedAnalysis = data["GA"];
                foundOneProd.prodDesc           = data["prodDesc"];
                foundOneProd.prodIngredients    = data["prodIng"];
                foundOneProd.updatedBy          = data["updatedBy"];
                foundOneProd.createdBy          = data["createdBy"];

                if (data["published"].Count != 0)
                {
                    foundOneProd.published = Convert.ToInt32(data["published"]);
                }
                foundOneProd.updatedAt = DateTime.Now;

                //List of prices
                var             priceArray      = data["price"].ToArray();
                List <String[]> priceAttributes = new List <String[]>();


                //Update Database
                Database.Update(foundOneProd);

                //Save changess
                Database.SaveChanges();
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    if (ex.InnerException.Message.Contains("Product_prodName_UniqueConstraint") == true)
                    {
                        customMessage = "Unable to save Product record due to another record having the same name: " + data["prodName"];
                        return(BadRequest(new { message = customMessage }));
                    }
                    else
                    {
                        customMessage = "Unable to save Product record due to internal server errors";
                        return(BadRequest(new { message = customMessage }));
                    }
                }
                else
                {
                    Debug.WriteLine("THE EXCEPTION IS " + ex);
                }
            }


            ////List of prices
            //var discountArray = data["discount"].ToArray();
            //List<String[]> discountAttributes = new List<String[]>();
            //Debug.WriteLine("PRICE DATA " + discountArray[0] + " AND " + discountArray[0][0]);

            ////For each discount input in discount price
            //for (int i = 0; i < discountArray.Length; i++)
            //{
            //    try
            //    {
            //        discountAttributes.Add(discountArray[i].Split(","));
            //        for (int j = 0; j < discountAttributes[i].Count(); j++)
            //        {
            //            switch (j)
            //            {
            //                case 0:
            //                    foundOneDiscountRate.discName = discountAttributes[i][j];
            //                    break;
            //                case 1:
            //                    foundOneDiscountRate.discRate = Convert.ToInt32(discountAttributes[i][j]);
            //                    break;
            //                default:
            //                    break;
            //            }
            //        }
            //        Database.Update(foundOneDiscountRate);
            //        Database.SaveChanges();

            //        foundOneProductDiscountRate.discountId = foundOneDiscountRate.discId;
            //        foundOneProductDiscountRate.prodId = foundOneProductDiscountRate.prodId;

            //        Database.Update(foundOneProductDiscountRate);
            //        Database.SaveChanges();
            //        Debug.WriteLine("CHANGES TO DISCOUNT RATE TABLE SAVED");
            //    }
            //    catch (Exception ex)
            //    {
            //        Debug.WriteLine("DISCOUNT RATE ERROR: " + ex);
            //    }
            //}
            return(Ok(new
            {
                message = "Updated Brand Record"
            }));
        }
        public async Task <IActionResult> Post(IFormCollection data, IList <IFormFile> fileInput)
        {
            //Initialize Variables
            string customMessage = "";
            int    fileCount     = 0;
            string url           = "";

            //create Product object
            Product newProduct = new Product()
            {
                productDetails       = new List <productDetail>(),
                productDiscountRates = new List <productDiscountRate>()
            };

            //Create a new discountRate, productDetail and productDiscountRate object
            discountRate        newDiscountRate        = new discountRate();
            productDetail       newProductDetail       = new productDetail();
            productDiscountRate newProductDiscountRate = new productDiscountRate();

            //Passing data into newProduct
            //Required Fields
            newProduct.prodName = data["prodName"];
            newProduct.prodCode = data["prodCode"];

            //newProduct.prodImgUrl = data["prodImgUrl"];
            newProduct.brandId   = Convert.ToInt32(data["brandId"]);
            newProduct.createdAt = DateTime.Now;


            //Image
            LogFile logFile = new LogFile();

            foreach (IFormFile oneFile in fileInput)
            {
                if (oneFile != null)
                {
                    var fileName = ContentDispositionHeaderValue
                                   .Parse(oneFile.ContentDisposition)
                                   .FileName
                                   .Trim('"');
                    string contentType = oneFile.ContentType;
                    try
                    {
                        //http://stackoverflow.com/questions/16392751/unable-to-cast-base-class-data-contract-to-derived-class
                        logFile = await CloudinaryAPIs.
                                  UploadFileToCloudinary <LogFile>(UPLOAD_PRESET, oneFile.OpenReadStream(),
                                                                   contentType, fileName);

                        logFile.Description = data["description"];
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }
                    if (logFile.PublicCloudinaryId != "")
                    {
                        url = logFile.Url;
                        Database.LogFiles.Add(logFile);
                        Database.SaveChanges();
                        fileCount += 1;
                    }
                    else
                    {
                        return(BadRequest(new { message = "Unable to save file" }));
                    }
                }//end of checking if there is a file for upload
            }
            newProduct.prodImgUrl = url;

            //Optional Fields
            newProduct.guaranteedAnalysis = data["GA"];
            newProduct.prodDesc           = data["prodDesc"];
            newProduct.prodIngredients    = data["prodIng"];
            newProduct.updatedBy          = data["updatedBy"];
            newProduct.createdBy          = data["createdBy"];
            //newProduct.minQty = Convert.ToInt32(data["minQty"]);
            //newProduct.prodQty = Convert.ToInt32(data["prodQty"]);
            if (data["published"].Count != 0)
            {
                newProduct.published = Convert.ToInt32(data["published"]);
            }
            newProduct.updatedAt = DateTime.Now;

            //List of prices
            var             priceArray      = data["price"].ToArray();
            List <String[]> priceAttributes = new List <String[]>();

            Debug.WriteLine("PRICE DATA " + priceArray[0] + " AND " + priceArray[0][0]);



            try
            {
                //Add newStudent object
                Database.Add(newProduct);

                //Save changess
                Database.SaveChanges();
                Debug.WriteLine("CHANGES TO PRODUCT TABLE SAVED");
            }
            catch (Exception ex)
            {
                if (ex.InnerException != null)
                {
                    if (ex.InnerException.Message.Contains("Product_prodName_UniqueConstraint") == true)
                    {
                        customMessage = "Unable to save Product record due to another record having the same name: " + data["prodName"];
                        return(BadRequest(new { message = customMessage }));
                    }
                    else
                    {
                        customMessage = "Unable to save Product record due to internal server errors";
                        return(BadRequest(new { message = customMessage }));
                    }
                }
                else
                {
                    Debug.WriteLine("THE EXCEPTION IS " + ex);
                }
            }


            ////For each price input in array price
            for (int i = 0; i < priceArray.Length; i++)
            {
                try
                {
                    priceAttributes.Add(priceArray[i].Split(","));
                    for (int j = 0; j < priceAttributes[i].Count(); j++)
                    {
                        newProductDetail.prodId = newProduct.prodId;
                        switch (j)
                        {
                        case 0:
                            newProductDetail.weightAmount = Convert.ToInt32(priceAttributes[i][j]);
                            break;

                        case 1:
                            newProductDetail.weightUnit = priceAttributes[i][j];
                            break;

                        case 2:
                            newProductDetail.price = Convert.ToInt32(priceAttributes[i][j]);
                            break;

                        default:
                            break;
                        }
                    }
                    Database.Add(newProductDetail);
                    Database.SaveChanges();
                    Debug.WriteLine("CHANGES TO PRODUCT DETAIL TABLE SAVED");
                }
                catch (Exception ex)
                {
                    Debug.WriteLine("PRODUCT DETAIL ERROR: " + ex);
                }
            }



            //List of prices
            var             discountArray      = data["discount"].ToArray();
            List <String[]> discountAttributes = new List <String[]>();

            Debug.WriteLine("PRICE DATA " + discountArray[0] + " AND " + discountArray[0][0]);

            ////For each discount input in discount price
            for (int i = 0; i < discountArray.Length; i++)
            {
                try
                {
                    discountAttributes.Add(discountArray[i].Split(","));
                    for (int j = 0; j < discountAttributes[i].Count(); j++)
                    {
                        switch (j)
                        {
                        case 0:
                            newDiscountRate.discName = discountAttributes[i][j];
                            break;

                        case 1:
                            newDiscountRate.discRate = Convert.ToInt32(discountAttributes[i][j]);
                            break;

                        default:
                            break;
                        }
                    }
                    Database.Add(newDiscountRate);
                    Database.SaveChanges();
                    newProductDiscountRate.discountId = newDiscountRate.discId;
                    newProductDiscountRate.prodId     = newProduct.prodId;
                    Database.Add(newProductDiscountRate);
                    Database.SaveChanges();
                    Debug.WriteLine("CHANGES TO DISCOUNT RATE TABLE SAVED");
                }
                catch (Exception ex)
                {
                    Debug.WriteLine("DISCOUNT RATE ERROR: " + ex);
                }
            }
            return(Ok(new
            {
                message = "Saved Brand Record"
            }));
        }