public ActionResult RemoveCategory(int id)
 {
     try
     {
         CATEGORIES_BY_SUPPLIER _CATEGORIER_BY_SUPPLIER = db.CATEGORIES_BY_SUPPLIER.Find(id);
         db.CATEGORIES_BY_SUPPLIER.Remove(_CATEGORIER_BY_SUPPLIER);
         db.SaveChanges();
         return(RedirectToAction("ManagingCategoriesBySupplier", "Admin"));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
 public ActionResult AddCategory(int id_sup, int id_cate)
 {
     try
     {
         CATEGORIES_BY_SUPPLIER _CATEGORIER_BY_SUPPLIER = new CATEGORIES_BY_SUPPLIER();
         _CATEGORIER_BY_SUPPLIER.SUPPLIER_ID   = id_sup;
         _CATEGORIER_BY_SUPPLIER.SUPPLIER_NAME = m_SUPPLIER_MODEL.GetSupplierName(id_sup);
         _CATEGORIER_BY_SUPPLIER.CATEGORY_ID   = id_cate;
         _CATEGORIER_BY_SUPPLIER.CATEGORY_NAME = m_CATEGORY_MODEL.GetCategoryName(id_cate);
         db.CATEGORIES_BY_SUPPLIER.Add(_CATEGORIER_BY_SUPPLIER);
         db.SaveChanges();
         return(RedirectToAction("ManagingCategoriesBySupplier", "Admin"));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }