//    public List<ProductCatogeries> List()
        //    {
        //        using (DbConnect dbConnect = new DbConnect())
        //        {
        //            return dbConnect.ProductCategoryData.ToList();
        //        }
        //   }

        //Add product category
        public int AddProductCategory(ProductCatogeries productCategories)
        {
            using (DbConnect dbConnect = new DbConnect())
            {
                dbConnect.ProductCategoryData.Add(productCategories);
                return(dbConnect.SaveChanges());
            }
        }
        //update category using object
        public int UpdateProductCategory(ProductCatogeries product)
        {
            using (DbConnect productConnect = new DbConnect())
            {
                productConnect.Entry(product).State = EntityState.Modified;

                return(productConnect.SaveChanges());
            }
        }
 //get productcategory using productcategory id
 public ProductCatogeries GetProduct(int productNumber)
 {
     using (DbConnect dbConnect = new DbConnect())
     {
         List <Product>    products = dbConnect.ProductData.ToList();
         ProductCatogeries product  = dbConnect.ProductCategoryData.Where(id => id.ProductCatogeryId == productNumber).SingleOrDefault();
         return(product);
     }
 }
 //delete category using object
 public void DeleteProductCategories(ProductCatogeries product)
 {
     using (DbConnect productConnect = new DbConnect())
     {
         ProductCatogeries products = productConnect.ProductCategoryData.Where(id => id.ProductCatogeryId == product.ProductCatogeryId).SingleOrDefault();
         productConnect.ProductCategoryData.Attach(products);
         productConnect.ProductCategoryData.Remove(products);
         productConnect.SaveChanges();
     }
 }
Ejemplo n.º 5
0
 [HttpGet]//getting delete object from admin
 public ActionResult DeleteProductCategory(int id)
 {
     try
     {
         ProductCatogeries product = productCategoryDetails.GetProduct(id);
         return(View(product));
     }
     catch
     {
         return(RedirectToAction("Error", "Error"));
     }
 }
Ejemplo n.º 6
0
 [HttpGet]//geting the edit object from admin
 public ActionResult EditProductCategory(int id)
 {
     try
     {
         ProductCatogeries product = productCategoryDetails.GetProduct(id);
         TempData["CatogeryImage"] = product.ProductImagePath;
         return(View(product));
     }
     catch
     {
         return(RedirectToAction("Error", "Error"));
     }
 }
 public void DeleteProductCategory(ProductCatogeries product)
 {
     productCategoryRepositary.DeleteProductCategories(product);
 }
 public int UpdateProductCategory(ProductCatogeries product)
 {
     return(productCategoryRepositary.UpdateProductCategory(product));
 }
 public int AddProductCategory(ProductCatogeries productCatogeries)
 {
     return(productCategoryRepositary.AddProductCategory(productCatogeries));
 }