public async void load_subtypeAndAdditionall(F form, string type_id)
        {
            CurtainDesigner.Models.Classes.DNCManage <L>             model = new CurtainDesigner.Models.Classes.DNCManage <L>();
            CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T> view  = new CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T>();
            SqlDataReader reader = null;

            reader = await model.getDataFromDB($"Select * From [DNC_subtypes] fcs Where [fcs].[Type_id] = {type_id};");

            view.loadDataFromDB_comboboxes((form as CurtainDesigner.OrderForms.FormDNCOrder).comboBoxCurtainSubtype, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), "Subtype_name", "Subtype_id");

            reader = await model.getDataFromDB($"Select * From [DNC_Additional_equipment] fcs Where [fcs].[Type_id] = {type_id};");

            view.loadDataFromDB_comboboxes((form as CurtainDesigner.OrderForms.FormDNCOrder).comboBoxEquipment, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), "Equipment", "Equipment_id");
        }
        public async void load_data_once_label(Label label_price, Label label_id, string query, string key, string value)
        {
            CurtainDesigner.Models.Classes.DNCManage <L>             model = new CurtainDesigner.Models.Classes.DNCManage <L>();
            CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T> view  = new CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T>();
            SqlDataReader reader = null;

            reader = await model.getDataFromDB(query);

            view.loadDataFromDB_label(label_price, label_id, reader, value, key);
        }
        public async void load_data_once_comboboxes(ComboBox comboBox, string query, string key, string value, int selected_value)
        {
            CurtainDesigner.Models.Classes.DNCManage <L>             model = new CurtainDesigner.Models.Classes.DNCManage <L>();
            CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T> view  = new CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T>();
            SqlDataReader reader = null;

            reader = await model.getDataFromDB(query);

            view.loadDataFromDB_comboboxes(comboBox, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), key, value, selected_value);
        }
        public async void load_installations(F form)
        {
            CurtainDesigner.Models.Classes.DNCManage <L>             model = new CurtainDesigner.Models.Classes.DNCManage <L>();
            CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T> view  = new CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T>();
            SqlDataReader reader = null;

            reader = await model.getDataFromDB($"Select * From [Installation];");

            view.loadDataFromDB_comboboxes((form as CurtainDesigner.OrderForms.FormDNCOrder).comboBoxInstallation, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), "Price", "Installation_id");

            model.closeConnection();
        }
        public async void load_FabricCategorydata(F form, string type_id, string fabric_id, string subtype_id)
        {
            CurtainDesigner.Models.Classes.DNCManage <L>             model = new CurtainDesigner.Models.Classes.DNCManage <L>();
            CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T> view  = new CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T>();
            SqlDataReader reader = null;

            reader = await model.getDataFromDB($"Select * From [DNC_category] fcc Where [fcc].[Category_id] IN (Select Category_id From [DNC_Fabric] ffc Where [ffc].[Fabric_id] = {fabric_id}) and [fcc].[Type_id] = {type_id} and [fcc].[Subtype_id] = {subtype_id};");

            view.loadDataFromDB_label((form as CurtainDesigner.OrderForms.FormDNCOrder).labelFabricCategory, (form as CurtainDesigner.OrderForms.FormDNCOrder).labelFabricCategoryId, reader, "Price", "Category_id");

            model.closeConnection();
        }
        public async void load_data(F form, string type_id, string subtype_id)
        {
            CurtainDesigner.Models.Classes.DNCManage <L>             model = new CurtainDesigner.Models.Classes.DNCManage <L>();
            CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T> view  = new CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T>();
            SqlDataReader reader = null;

            reader = await model.getDataFromDB($"Select * From [DNC_Fabric] f Where [f].[Type_id] = {type_id} and [f].[Subtype_id] = {subtype_id};");

            view.loadDataFromDB_comboboxes((form as CurtainDesigner.OrderForms.FormDNCOrder).comboBoxFabric, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), "Name", "Fabric_id");

            model.closeConnection();
        }
        public async void load_data(F form)
        {
            CurtainDesigner.Models.Classes.DNCManage <L>             model = new CurtainDesigner.Models.Classes.DNCManage <L>();
            CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T> view  = new CurtainDesigner.Views.Classes.DNCViewManage <O, L, F, T>();
            SqlDataReader reader = null;

            reader = await model.getDataFromDB("Select * From [DNC_types];");

            view.loadDataFromDB_comboboxes((form as CurtainDesigner.OrderForms.FormDNCOrder).comboBoxCurtainType, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), "Type_name", "Type_id");

            reader = await model.getDataFromDB("Select * From [Control];");

            view.loadDataFromDB_comboboxes((form as CurtainDesigner.OrderForms.FormDNCOrder).comboBoxSide, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), "Control_side", "Control_id");

            reader = await model.getDataFromDB("Select * From [System_color];");

            view.loadDataFromDB_comboboxes((form as CurtainDesigner.OrderForms.FormDNCOrder).comboBoxSystemColor, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), "Name", "Color_id");

            reader = await model.getDataFromDB($"Select * From [Installation];");

            view.loadDataFromDB_comboboxes((form as CurtainDesigner.OrderForms.FormDNCOrder).comboBoxInstallation, reader, new System.ComponentModel.BindingList <KeyValuePair <string, int> >(), "Price", "Installation_id");

            model.closeConnection();
        }