/// <summary>
        /// gets the all subcontractor from the 'beszallito' table
        /// </summary>
        /// <returns>list of subcontractors 'beszallito_id'</returns>
        public List <string> getSubcontrList()
        {
            mdi.openConnection();
            List <string> list = mdi.executeQueryGetOneFieldToList(querySubcontrList);

            mdi.closeConnection();
            if (list == null)
            {
                throw new ErrorServiceProductGetSubcontr("Beszállítók adatlista megalkotása sikertelen (ModProdListPart)");
            }
            return(list);
        }