// ====================================== end of delete in database ============================================


        // ============================= END OF PRODUCT UPDATE DELETE SEARCH INSERT METHODS =============================



        public ArrayList searchProdOfCategory(ProductDTO dto)
        {
            productDAL = new ProductManagementDAL();
            ArrayList arr = productDAL.searchProdOfCategory(dto);

            return(arr);
        }
        public Int64 prodNameToID(ProductDTO dto)
        {
            productDAL = new ProductManagementDAL();
            Int64 result = productDAL.prodNameToID(dto);

            return(result);
        }
        // ====================================== end of search in database ============================================



        // ====================================== update in database ============================================

        public void updateRecord(ProductDTO DTO)
        {
            productDAL = new ProductManagementDAL();


            productDAL.updateToDatabase(DTO);
        }
        // ====================================== end of insertion in database ============================================



        // ====================================== search in database ============================================

        public ArrayList searchRecord(string a, string b)
        {
            productDAL = new ProductManagementDAL();
            ArrayList arr = productDAL.searchInDatabase(a, b);

            return(arr);
        }
        public ArrayList getAllProducts()
        {
            productDAL = new ProductManagementDAL();
            ArrayList arr = productDAL.getAllProducts();

            return(arr);
        }
        public string prodIdToName(ProductDTO dto)
        {
            productDAL = new ProductManagementDAL();
            string result = productDAL.prodIDToName(dto);

            return(result);
        }
        // ============================== PRODUCT UPDATE DELETE SEARCH INSERT METHODS ==============================


        // ====================================== insertion in database ============================================
        public void insertRecord(ProductDTO dto)
        {
            productDAL = new ProductManagementDAL();
            productDAL.insertToDatabase(dto);
        }