public GetWorkOrderNumberForHeatQM Execute() { var response = new GetWorkOrderNumberForHeatQM() { }; var responseDtoList = new List <GetWorkOrderNumberHeatModelQM>(); using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].[uspGetWorkOrderNumberForHeat]"; sqlCommand.CommandType = CommandType.StoredProcedure; using (var reader = SsDbCommandHelper.ExecuteReader(sqlCommand)) { while (reader.Read()) { var responseDto = new GetWorkOrderNumberHeatModelQM() { WONumber = reader["WONumber"].ToString() }; responseDtoList.Add(responseDto); } } response.getWorkOrderNumberHeatDetails = responseDtoList; } return(response); }
public GetWorkOrderNumberForHeatQM GetWorkOrderNumberHeat() { var model = new GetWorkOrderNumberForHeatQM(); using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new WorkOrderNumberForHeatSelectCommand { Connection = connection }; model = command.Execute(); } return(model); }