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