public StockEnquiryOptionQM Execute(Int16 Option) { StockEnquiryOptionQM response = new StockEnquiryOptionQM(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetStockOptionEnquiry]"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@Option", SsDbType.SmallInt, ParameterDirection.Input, Option)); if (Option == 0) { using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.getStockOptionEnquiryForSerialModel = reader.ToList <GetStockOptionEnquiryForSerialModel>(); } } else { using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { response.getStockOptionEnquiryForItemModel = reader.ToList <GetStockOptionEnquiryForItemModel>(); } } } return(response); }
public StockEnquiryOptionQM GetStockEnquiryForGrid(Int16 Option) { StockEnquiryOptionQM ds = new StockEnquiryOptionQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new GetStockEnquirySelectCommandForGrid { Connection = connection }; ds = command.Execute(Option); } return(ds); }