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_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(); }