public InvoicedEnquiryOptionQM GetInvoicedEnquiryForGrid() { InvoicedEnquiryOptionQM ds = new InvoicedEnquiryOptionQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetInvoicedEnquirySelectCommandForGrid { Connection = connection }; ds = command.Execute(); } return(ds); }
public InvoicedEnquiryOptionQM Execute() { InvoicedEnquiryOptionQM response = new InvoicedEnquiryOptionQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetToBeInvoicedEnquiry]"; sqlCommand.CommandType = CommandType.StoredProcedure; using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.GetInvoicedEnquiryOptionModel = reader.ToList <InvoicedEnquiryOptionModel>(); } } return(response); }