public GetSubContractStockEnquiryQM GetSubContractStockEnquiryForGrid() { GetSubContractStockEnquiryQM getSubContractStockEnquiryQM = new GetSubContractStockEnquiryQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetSubContractStockEnquiryForGridSelectCommand { Connection = connection }; getSubContractStockEnquiryQM = command.Execute(); } return(getSubContractStockEnquiryQM); }
public GetSubContractStockEnquiryQM Execute() { GetSubContractStockEnquiryQM response = new GetSubContractStockEnquiryQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetSubContractStockEnquiry]"; sqlCommand.CommandType = CommandType.StoredProcedure; using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.GetSubContractStockEnquiryModelList = reader.ToList <GetSubContractStockEnquiryModel>(); } } return(response); }